Import Order (прозорец ID-281)

От iDempiere bg
Направо към:навигация, търсене



прозорец: Import Order

описание: Импорт поръчки

помощ: Please set Y/N selections in the import loader format explicitly (e.g. as constants) and no not leave them NULL. A NULL value stands for "don't know". In general, selection boxes are not selected if the value is not "Y" (i.e. could be null or any other value). All tests are made on "Y" or "not Y" - i.e. NULL values are not "not Y", but NULL (don't know) - see SQL Language introductions.



TAB: Поръчка

описание: Импорт поръчки


помощ You should supply the Document Type Name (or ID). The Document Type is on purpose not fully derived as it has too many consequences if it's wrong. The best way is to set the Document Type Name as a Constant in your Import File Format or as an imported field in the file.


Файл:Import Order - Поръчка - прозорец (iDempiere 1.0.0).png




име име описание помощ спецификации
Import Order Import Order Импорт поръчки null I_Order_ID
numeric(10) NOT NULL
ID
Imported Импортирано Импортирано The Imported check box indicates if this import has been processed. I_IsImported
character(1) NOT NULL
Yes-No
Order Поръчка за покупка Поръчка за покупка The Order is a control document. The Order is complete when the quantity ordered is the same as the quantity shipped and invoiced. When you cloase an order, unshipped (backordered) quantities are cancelled. C_Order_ID
numeric(10)
Search
Sales Order Line Ред в поръчката Ред в поръчката за покупка The Sales Order Line is a unique identifier for a line in an order. C_OrderLine_ID
numeric(10)
Search
Import Error Message Съобщение за грешка при импорта Съобщения генерирани от процеса на импорт The Import Error Message displays any error messages generated during the import process. I_ErrorMsg
character varying(2000)
String
Client Фирма Фирма Фирма AD_Client_ID
numeric(10)
Table Direct
Organization Организация Подразделение на клиента An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10)
Table Direct
Document Type Name Document Type Name Name of the Document Type null DocTypeName
character varying(60)
String
Document Type Тип документ Тип на документа The Document Type determines document sequence and processing rules C_DocType_ID
numeric(10)
Table Direct
Document No Номер на документа Номер на документа The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

DocumentNo
character varying(30)
String
Sales Transaction Транз. продажба Тази транзакция представя продажба The Sales Transaction checkbox indicates if this item is a Sales Transaction. IsSOTrx
character(1)
Yes-No
Description Описание Описание (не повече 255 символа) A description is limited to 255 characters. Description
character varying(255)
String
Sales Representative Търговски представител Търговски представител или Агент на компания The Sales Representative indicates the Sales Rep for this Region. Any Sales Rep must be a valid internal user. SalesRep_ID
numeric(10)
Table
Delivery Rule Правила за доставка Правила за доставка The Delivery Rule indicates when an order should be delivered. For example should the order be delivered when the entire order is complete, when a line is complete or as the products become available. DeliveryRule
character(1)
List
Currency Валута Валута Indicates the Currency to be used when processing or reporting on this record C_Currency_ID
numeric(10)
Table Direct
Price List Ценова листа Уникален идентификатор на дадена ценова листа Price Lists are used to determine the pricing, margin and cost of items purchased or sold. M_PriceList_ID
numeric(10)
Table Direct
Payment Term Key Payment Term Key Key of the Payment Term null PaymentTermValue
character varying(40)
String
Payment Term Срок на плащане Определя начина на плащане за тази сделка Payment Terms identify the method and timing of payment. C_PaymentTerm_ID
numeric(10)
Table Direct
Warehouse Склад Стоков склад и точка за услуги Това поле идентифицира уникален Склад където се съхраняват продукти или се предоставят услуги. M_Warehouse_ID
numeric(10)
Table Direct
Shipper Спедитор Method or manner of product delivery The Shipper indicates the method of delivering product M_Shipper_ID
numeric(10)
Table Direct
Business Partner Партньор Партньор Партньорът е всеки, с когото работите. Това може да означава Доставчик, Клиент, Служител или Търговски представител. C_BPartner_ID
numeric(10)
Search
Business Partner Key Business Partner Key Key of the Business Partner null BPartnerValue
character varying(40)
String
Name Наименование Не повече от 60 знака The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60)
String
Invoice To Къде Адрес, на който да се изпраща сметката The Bill/Invoice To indicates the address to use when remitting bills BillTo_ID
numeric(10)
Table
Partner Location Адрес партньор Идентифицира (до кого) адреса за този партньор The Partner address indicates the location of a Business Partner C_BPartner_Location_ID
numeric(10)
Table Direct
Address Адрес Местоположение или адрес The Location / Address field defines the location of an entity. C_Location_ID
numeric(10)
Search
Address 1 Адрес 1 Адрес The Address 1 identifies the address for an entity's location Address1
character varying(60)
String
Address 2 Адрес 2 Адрес 2 The Address 2 provides additional address information for an entity. It can be used for building location, apartment number or similar information. Address2
character varying(60)
String
City Град Град The City identifies a unique City for this Country or Region. City
character varying(60)
String
ZIP Пощенски код Postal code The Postal Code or ZIP identifies the postal code for this entity's address. Postal
character varying(10)
String
Region Регион Name of the Region The Region Name defines the name that will print when this region is used in a document. RegionName
character varying(60)
String
Region Регион Район или област The Region identifies a unique Region for this Country. C_Region_ID
numeric(10)
Table Direct
ISO Country Code ISO код на държавата Код на държавата по ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html Детайли на - http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1.html или - http://www.unece.org/trade/rec/rec03en.htm CountryCode
character(2)
String
Country Държава Държава The Country defines a Country. Each Country must be defined before it can be used in any document. C_Country_ID
numeric(10)
Table Direct
User/Contact Лице за контакт Потребител на системата - Вътрешен или Партньор за контакти The User identifies a unique user in the system. This could be an internal user or a business partner contact AD_User_ID
numeric(10)
Table Direct
Contact Name Име за контакти Име за контакти null ContactName
character varying(60)
String
Phone Телефон Идентифицира телефонен номер The Phone field identifies a telephone number Phone
character varying(40)
String
EMail Address Ел. поща Адрес за ел. поща The Email Address is the Electronic Mail ID for this User and should be fully qualified (e.g. joe.smith@company.com). The Email Address is used to access the self service application functionality from the web. EMail
character varying(60)
String
Date Ordered Дата на поръчката Дата на поръчката Indicates the Date an item was ordered. DateOrdered
timestamp without time zone
Date
Account Date Дата осчетоводяване Дата на осчетоводяване на фактурата The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. DateAcct
timestamp without time zone
Date
Product Продукт Продукт Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10)
Search
Product Key Само за тази стойност Генериране на листа само за този продукт (може да се исползва %) null ProductValue
character varying(40)
String
Charge Такса Допълнителни разходи The Charge indicates a type of Charge (Handling, Shipping, Restocking) C_Charge_ID
numeric(10)
Table Direct
Charge Name Charge Name Name of the Charge null ChargeName
character varying(60)
String
SKU Вътрешен код Код за вътрешна употреба Това поле показва дефиниран от потребителя код за съхранение и проследяване на материалите. Може да се използва за допълнителен бар код или собствено дефинирана система от кодове. SKU
character varying(30)
String
UPC/EAN Баркод Баркод (Универсален Продуктов Код или по-общото Европейски Артикулен Номер) Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI/Plessey, and Pharmacode) UPC
character varying(30)
String
UOM Мярка Мерна единица The UOM defines a unique non monetary Unit of Measure C_UOM_ID
numeric(10)
Table Direct
Ordered Quantity Поръчано количество Поръчано The Ordered Quantity indicates the quantity of a product that was ordered. QtyOrdered
numeric
Quantity
Unit Price Актуална Цена Актуална цена Актуалната или единична цена показва цената на продукта в първоначалната валута. PriceActual
numeric
Costs+Prices
Line Description Line Description Description of the Line null LineDescription
character varying(255)
String
Tax Indicator Символ на данъка Кратко наименование на данъка (за печат върху документите) The Tax Indicator identifies the short name that will print on documents referencing this tax. TaxIndicator
character varying(10)
String
Tax Данък Идентификатор на данъка The Tax indicates the type of tax used in document line. C_Tax_ID
numeric(10)
Table Direct
Tax Amount Сума на данъка Сума на данъка за документа The Tax Amount displays the total tax amount for a document. TaxAmt
numeric
Amount
Project Проект Финансов проект A Project allows you to track and control internal or external activities. C_Project_ID
numeric(10)
Search
Campaign Кампания Маркетингова кампания The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. C_Campaign_ID
numeric(10)
Table Direct
Activity Дейност Бизнес дейност Activities indicate tasks that are performed and used to utilize Activity based Costing C_Activity_ID
numeric(10)
Table Direct
Trx Organization Начална организация Performing or initiating organization The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. AD_OrgTrx_ID
numeric(10)
Table
Order Source Key Order Source Key null null C_OrderSourceValue
character varying(40)
String
Order Source Order Source null null C_OrderSource_ID
numeric(10)
Table Direct
Import Orders Импорт поръчки Импорт поръчки The Parameters are default values for null import record values, they do not overwrite any data.

Note that only Prepare and Complete are valid document actions.

Processing
character(1)
Button
Processed Обработено Документа е обработен The Processed checkbox indicates that a document has been processed. Processed
character(1)
Yes-No


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.