导入产品 (窗口 ID-247)

来自iDempiere zh
跳转至:导航搜索



窗口: 导入产品

描述: 导入产品

幫助: 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.


File:导入产品 - 导入产品 - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Import Product 导入产品 导入项目或维修 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 机构 客户内的机构实体。 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
Search Key 检索关键字 记录的检索关键字在格式上是必须的 -并且必须唯一 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 名称 Alphanumeric identifier of the entity 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(255)
String
Description 描述 该记录的可选描述 描述最多为 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 注释/帮助 注释或提示 The Help field contains a hint, comment or help about the use of this item. Help
character varying(2000)
Text
UPC/EAN 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
SKU SKU 存货保管单位 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 EDI 编码 UOM EDI 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 产品分类关键字 null null ProductCategory_Value
character varying(40)
String
Product Category 产品分类 Category this product is part of Identifies the category which this product belongs to. Product categories are used for pricing. M_Product_Category_ID
numeric(10)
Table Direct
Product Type 产品类型 产品的类型 The type of product also determines accounting consequences. ProductType
character(1)
List
Classification 分类 分类为配列 The Classification can be used to optionally group products. Classification
character(1)
String
Volume 体积 产品的体积 The Volume indicates the volume of the product in the Volume UOM of the Client Volume
numeric
Amount
Weight 重量 一产品的重量 The Weight indicates the weight of the product in the Weight UOM of the Client Weight
numeric
Amount
Shelf Width 架宽度 要求的架宽度 The Shelf Width indicates the width dimension required on a shelf for a product ShelfWidth
numeric(10)
Integer
Shelf Height 架高度 要求的架高度 The Shelf Height indicates the height dimension required on a shelf for a product ShelfHeight
numeric(10)
Integer
Shelf Depth 架深度 要求的架深度 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 中止 该产品不再可用 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 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 描述网址 网址为描述 null DescriptionURL
character varying(120)
URL
Business Partner Key 业务伙伴关键字 The Key of the Business Partner null BPartner_Value
character varying(40)
String
Business Partner 业务伙伴 标识业务伙伴 A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID
numeric(10)
Search
ISO Currency Code ISO货币编码 币种的 ISO 4217 编码 For details - http: www.unece.org trade rec rec09en.htm ISO_Code
character(3)
String
Currency 货币 币种为该笔记录 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 采购定单价格 基于采购定单的价格 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 版权金额 (Included) Amount for copyright, etc. null RoyaltyAmt
numeric
Amount
Price effective 有效的日期价格 有效的日期价格 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 伙伴产品号 供应商的产品未 The Vendor Product Number identifies the number used by the vendor for this product. VendorProductNo
character varying(40)
String
Partner Category 供应商分类 供应商的产品种类 The Vendor Category identifies the category used by the vendor for this product. VendorCategory
character varying(30)
String
Manufacturer 制造商 null null Manufacturer
character varying(30)
String
Minimum Order Qty 最小量定单数量 在 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 每定单成本 每定单固定的成本 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 导入产品 从一个文件导入产品 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

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


Contributions / Posts

Cookie帮助我们提供我们的服务。通过使用我们的服务,您同意我们使用cookie。