Увоз - производ (прозор ID-247)

прозор: Увоз - производ

опис: Увези производе

помоћ: The Import Products Window is an interim table which is used when importing external data into the system. Selecting the 'Process' button will either add or modify the appropriate records.

TAB: Увоз - производ

опис: Увези производе

помоћ Before importing, Adempiere checks the Unit of Measure (default if not set), the Product Category (default if not set), the Business Partner, the Currency (defaults to accounting currency if not set), the Product Type (only Items and Services), the uniqueness of UPC, Key and uniqueness and existence of the Vendor Product No.
Adempiere tries to map to existing products, if the UPC, the Key and the Vendor Product No matches (in this sequence). If the imported record could be matched, product field values will only be overwritten, if the corresponding Import field is explicitly defined. Example: the Product Category will only be overwritten if explicitly set in the Import.

Датотека:Увоз - производ - Увоз - производ - прозор (iDempiere 1.0.0).png

име	име	опис	помоћ	Спецификације
Import Product	Увоз - производ	Import Item or Service	null	I_Product_ID numeric(10) NOT NULL ID
Imported	Увежено	Has this import been processed	The Imported check box indicates if this import has been processed.	I_IsImported character(1) NOT NULL Yes-No
Product	Производ	Product, Service, Item	Identifies an item which is either purchased or sold in this organization.	M_Product_ID numeric(10) Table Direct
Import Error Message	Порука грешке о увозу	Messages generated from import process	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	Организација	Организациони ентитет унутар клијента	Организација је организациона јединица клијента или правни ентитит - нпр. продавница, одељење Подаци између организација су заједнички.	AD_Org_ID numeric(10) Table Direct
Search Key	Кључна реч	Search key for the record in the format required - must be unique	A search key allows you a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number. 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).	Value character varying(40) String
Name	Назив	Алфанумерички идентификатор ентитета.	Назив ентитета (слога) се користи приликом основне претраге као додатна опција уз кључну реч - ид број. Назив може бити дужине до 60 карактера.	Name character varying(255) String
Description	Опис	Optional short description of the record	Опис је ограничен на 255 карактера.	Description character varying(255) String
Document Note	Белешка документа	Additional information for a Document	The Document Note is used for recording any additional information regarding this product.	DocumentNote character varying(2000) Text
Comment/Help	Коментар/помоћ	Comment or Hint	The Help field contains a hint, comment or help about the use of this item.	Help character varying(2000) Text
UPC/EAN	UPC/EAN	Bar Code (Universal Product Code or its superset European Article Number)	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
SKU	SKU	Stock Keeping Unit	The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema.	SKU character varying(30) String
UOM Code	UOM код	UOM EDI X12 Code	The Unit of Measure Code indicates the EDI X12 Code Data Element 355 (Unit or Basis for Measurement)	X12DE355 character varying(4) String
UOM	ЈМ	Јединице мере	The UOM defines a unique non monetary Unit of Measure	C_UOM_ID numeric(10) Table Direct
Product Category Key	Product Category Key	null	null	ProductCategory_Value character varying(40) String
Product Category	Категорија производа	Category of a Product	Identifies the category which this product belongs to. Product categories are used for pricing and selection.	M_Product_Category_ID numeric(10) Table Direct
Product Type	Врста производа	Type of product	The type of product also determines accounting consequences.	ProductType character(1) List
Classification	Класификација	Classification for grouping	The Classification can be used to optionally group products.	Classification character(1) String
Volume	Обим	Volume of a product	The Volume indicates the volume of the product in the Volume UOM of the Client	Volume numeric Amount
Weight	Тежина	Weight of a product	The Weight indicates the weight of the product in the Weight UOM of the Client	Weight numeric Amount
Shelf Width	Ширина рафа	Shelf width required	The Shelf Width indicates the width dimension required on a shelf for a product	ShelfWidth numeric(10) Integer
Shelf Height	Висина рафа	Shelf height required	The Shelf Height indicates the height dimension required on a shelf for a product	ShelfHeight numeric(10) Integer
Shelf Depth	Дубина рафа	Shelf depth required	The Shelf Depth indicates the depth dimension required on a shelf for a product	ShelfDepth numeric(10) Integer
Units Per Pallet	Јединица по палети	Јединица по палети	The Units per Pallet indicates the number of units of this product which fit on a pallet.	UnitsPerPallet numeric(10) Integer
Discontinued	Нестао	This product is no longer available	The Discontinued check box indicates a product that has been discontinued.	Discontinued character(1) Yes-No
Discontinued At	Discontinued At	Discontinued At indicates Date when product was discontinued	null	DiscontinuedAt timestamp without time zone Date
Image URL	URL слике	URL of image	URL of image; The image is not stored in the database, but retrieved at runtime. The image can be a gif, jpeg or png.	ImageURL character varying(120) URL
Description URL	Опис URL	URL for the description	null	DescriptionURL character varying(120) URL
Business Partner Key	Кључ пословног партнера	The Key of the Business Partner	null	BPartner_Value character varying(40) String
Business Partner	Пословни партнер	Означава пословног партнера	Пословни партнер је било ко, са којим вршите трансакције. Он може бити добављач, купац, запослени или референт продаје.	C_BPartner_ID numeric(10) Search
ISO Currency Code	ISO код валуте	Three letter ISO 4217 Code of the Currency	For details - http://www.unece.org/trade/rec/rec09en.htm	ISO_Code character(3) String
Currency	Валута	The Currency for this record	Indicates the Currency to be used when processing or reporting on this record	C_Currency_ID numeric(10) Table Direct
List Price	Каталошка цена	Каталошка цена	The List Price is the official List Price in the document currency.	PriceList numeric Costs+Prices
PO Price	Наб цена	Price based on a purchase order	The PO Price indicates the price for a product per the purchase order.	PricePO numeric Costs+Prices
Standard Price	Стандардна цена	Стандардна цена	The Standard Price indicates the standard or normal price for a product on this price list	PriceStd numeric Costs+Prices
Limit Price	Најнижа цена	Најнижа цена за производ	The Price Limit indicates the lowest price for a product stated in the Price List Currency.	PriceLimit numeric Costs+Prices
Royalty Amount	Royalty Amount	(Included) Amount for copyright, etc.	null	RoyaltyAmt numeric Amount
Price effective	Цена важи од	Effective Date of Price	The Price Effective indicates the date this price is for. This allows you to enter future prices for products which will become effective when appropriate.	PriceEffective timestamp without time zone Date
Partner Product Key	Партнеров кључ производа	Product Key of the Business Partner	The Business Partner Product Key identifies the number used by the Business Partner for this product. It can be printed on orders and invoices when you include the Product Key in the print format.	VendorProductNo character varying(40) String
Partner Category	Категорија партнера	Product Category of the Business Partner	The Business Partner Category identifies the category used by the Business Partner for this product.	VendorCategory character varying(30) String
Manufacturer	Произвођач	Manufacturer of the Product	The manufacturer of the Product (used if different from the Business Partner / Vendor)	Manufacturer character varying(30) String
Minimum Order Qty	Најмања кол поручивања	Minimum order quantity in UOM	The Minimum Order Quantity indicates the smallest quantity of this product which can be ordered.	Order_Min numeric Integer
Order Pack Qty	Количина по паковању	Package order size in UOM (e.g. order set of 5 units)	The Order Pack Quantity indicates the number of units in each pack of this product.	Order_Pack numeric Integer
Cost per Order	Трошак по наруџбеници	Fixed Cost Per Order	The Cost Per Order indicates the fixed charge levied when an order for this product is placed.	CostPerOrder numeric Costs+Prices
Promised Delivery Time	Обећано време испоруке	Promised days between order and delivery	The Promised Delivery Time indicates the number of days between the order date and the date that delivery was promised.	DeliveryTime_Promised numeric(10) Integer
Import Products	Увези производе	Imports products from a file into the application	Import Products will bring a file of products, in a predefined format into the application. The Parameters are default values for null import record values, they do not overwrite any data. If you select an existing price list and you have List, Standard, and Limit Price defined, they are directly created/updated.	Processing character(1) Button
Processed	Обрађено	The document has been processed	The Processed checkbox indicates that a document has been processed.	Processed character(1) Yes-No