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

прозорец: 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