仓库&货位 (窗口 ID-139)
窗口: 仓库&货位
描述: Maintain Warehouses and Locators
幫助: The Warehouse and Locators Window defines each Warehouse, any Locators for that Warehouse and the Accounting parameters to be used for inventory in that Warehouse.
TAB: 仓库
描述: 仓库
幫助 The Warehouse Tab defines each Warehouse that is used to store products.
File:仓库&货位 - 仓库 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL 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) NOT NULL 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) NOT NULL 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(60) NOT NULL String |
Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Active | 有效 | 本记录有效 | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) NOT NULL Yes-No |
In Transit | In Transit | Movement is in transit | Material Movement is in transit - shipped, but not received | IsInTransit character(1) Yes-No |
Address | 地址 | 位置或地址 | The Location Address field defines the location of an entity. | C_Location_ID numeric(10) NOT NULL Location (Address) |
Element Separator | 元素分隔符 | 元素分隔符 | The Element Separator defines the delimiter printed between elements of the structure | Separator character(1) NOT NULL String |
Source Warehouse | Source Warehouse | Optional Warehouse to replenish from | If defined, the warehouse selected is used to replenish the product(s) | M_WarehouseSource_ID numeric(10) Table |
Replenishment Class | Replenishment Class | Custom class to calculate Quantity to Order | If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level. | ReplenishmentClass character varying(60) String |
Disallow Negative Inventory | Disallow Negative Inventory | Negative Inventory is not allowed in this warehouse | If checked, any transaction that results in the onhand inventory being driven negative will be prevented. | IsDisallowNegativeInv character(1) NOT NULL Yes-No |
TAB: 货位
描述: 货位
幫助 The Locator Tab defines any Locators for that Warehouse.
File:仓库&货位 - 货位 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Locator | 货位 | 仓库货位 | The Locator ID indicates where in a Warehouse a product is located. | M_Locator_ID numeric(10) NOT NULL ID |
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL 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) NOT NULL Table Direct |
Warehouse | 仓库或服务位置 | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | M_Warehouse_ID numeric(10) NOT NULL 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) NOT NULL String |
Active | 有效 | 本记录有效 | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) NOT NULL Yes-No |
Relative Priority | 相对优先权 | Where inventory should be picked from first | The Relative Priority indicates the location to pick from first if an product is stored in more than one location. (0 = highest priority) | PriorityNo numeric(10) NOT NULL Integer |
Default | 缺省值 | 缺省值 | The Default Checkbox indicates if this record will be used as a default value. | IsDefault character(1) NOT NULL Yes-No |
Aisle (X) | 走廊(X) | X dimension, e.g., Aisle | The X dimension indicates the Aisle a product is located in. | X character varying(60) String |
Bin (Y) | 货柜(Y) | Y dimension, e.g., Bin | The Y dimension indicates the Bin a product is located in | Y character varying(60) String |
Level (Z) | 货层(Z) | Z dimension, e.g., Level | The Z dimension indicates the Level a product is located in. | Z character varying(60) String |
TAB: 存储
描述: null
幫助 null
File:仓库&货位 - 存储 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL 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) NOT NULL Table Direct |
Locator | 货位 | 仓库货位 | The Locator ID indicates where in a Warehouse a product is located. | M_Locator_ID numeric(10) NOT NULL Locator (WH) |
Product | 产品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) NOT NULL Search |
Attribute Set Instance | 属性组合实例 | Product Attribute Set Instance | The values of the actual Product Attributes | M_AttributeSetInstance_ID numeric(10) NOT NULL Product Attribute |
Active | 有效 | 本记录有效 | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) NOT NULL Yes-No |
On Hand Quantity | 在库库存 | 在库库存 | The On Hand Quantity indicates the quantity of a product that is on hand in a warehouse. | QtyOnHand numeric NOT NULL Quantity |
Date last inventory count | 最近盘点日期 | 最近盘点日期 | The Date Last Inventory Count indicates the last time an Inventory count was done. | DateLastInventory timestamp without time zone Date |
Reserved Quantity | 保留库存 | 保留库存 | The Reserved Quantity indicates the quantity of a product that is currently reserved for other orders. | QtyReserved numeric NOT NULL Quantity |
Ordered Quantity | 已定单量 | 已定单量 | The Ordered Quantity indicates the quantity of a product that was ordered. | QtyOrdered numeric NOT NULL Quantity |
TAB: Replenish
描述: Define Product Replenishment
幫助 The Replenishment Tab defines the type of replenishment quantities. This is used for automated ordering. If you select a custom replenishment type, you need to create a class implementing org.compiere.util.ReplenishInterface and set that on warehouse level.
File:仓库&货位 - Replenish - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL 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) NOT NULL Table Direct |
Warehouse | 仓库或服务位置 | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | M_Warehouse_ID numeric(10) NOT NULL Table Direct |
Product | 产品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) NOT NULL Search |
Active | 有效 | 本记录有效 | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) NOT NULL Yes-No |
Replenish Type | 补货类型 | Method for re-ordering a product | The Replenish Type indicates if this product will be manually re-ordered, ordered when the quantity is below the minimum quantity or ordered when it is below the maximum quantity. | ReplenishType character(1) NOT NULL List |
Minimum Level | 库存下限 | Minimum Inventory level for this product | Indicates the minimum quantity of this product to be stocked in inventory. | Level_Min numeric NOT NULL Amount |
Maximum Level | 库存上限 | Maximum Inventory level for this product | Indicates the maximum quantity of this product to be stocked in inventory. | Level_Max numeric NOT NULL Amount |
Source Warehouse | Source Warehouse | Optional Warehouse to replenish from | If defined, the warehouse selected is used to replenish the product(s) | M_WarehouseSource_ID numeric(10) Table |
TAB: 会计
描述: 会计
幫助 The Accounting Tab defines the Accounting parameters to be used for inventory in that Warehouse.
File:仓库&货位 - 会计 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL 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) NOT NULL Table Direct |
Warehouse | 仓库或服务位置 | Storage Warehouse and Service Point | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | M_Warehouse_ID numeric(10) NOT NULL Table Direct |
Accounting Schema | 会计模式 | 帐户的规则 | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar | C_AcctSchema_ID numeric(10) NOT NULL Table Direct |
Active | 有效 | 本记录有效 | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) NOT NULL Yes-No |
(Not Used) | (Not Used) | Warehouse Inventory Asset Account - Currently not used | The Warehouse Inventory Asset Account identifies the account used for recording the value of your inventory. This is the counter account for inventory revaluation differences. The Product Asset account maintains the product asset value. | W_Inventory_Acct numeric(10) Account |
Inventory Adjustment | Inventory Adjustment | Account for Inventory value adjustments for Actual Costing | In actual costing systems, this account is used to post Inventory value adjustments. You could set it to the standard Inventory Asset account. | W_InvActualAdjust_Acct numeric(10) Account |
Warehouse Differences | 储入仓库差额 | 储入仓库差额帐户 | The Warehouse Differences Account indicates the account used recording differences identified during inventory counts. | W_Differences_Acct numeric(10) NOT NULL Account |
Inventory Revaluation | Inventory Revaluation | Account for Inventory Revaluation | The Inventory Revaluation Account identifies the account used to records changes in inventory value due to currency revaluation. | W_Revaluation_Acct numeric(10) Account |
TAB: 产品交易
描述: Transactions for stored Products
幫助 null
File:仓库&货位 - 产品交易 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Inventory Transaction | 库存交易 | null | null | M_Transaction_ID numeric(10) NOT NULL ID |
Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL 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) NOT NULL Table Direct |
Locator | 货位 | 仓库货位 | The Locator ID indicates where in a Warehouse a product is located. | M_Locator_ID numeric(10) NOT NULL Locator (WH) |
Active | 有效 | 本记录有效 | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive 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) NOT NULL Search |
Attribute Set Instance | 属性组合实例 | Product Attribute Set Instance | The values of the actual Product Attributes | M_AttributeSetInstance_ID numeric(10) NOT NULL Product Attribute |
Movement Quantity | 调拨数量 | Quantity of a product moved. | The Movement Quantity indicates the quantity of a product that has been moved. | MovementQty numeric NOT NULL Quantity |
Movement Date | 调拨日期 | Date a product was moved in or out of inventory | The Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement. | MovementDate timestamp without time zone NOT NULL Date |
Movement Type | 调拨类型 | Method of moving the inventory | The Movement Type indicates the type of movement (in, out, to production, etc) | MovementType character(2) NOT NULL List |
Shipment/Receipt Line | 收货明细 | 接收货明细 | The Shipment Receipt Line indicates a unique line in a Shipment Receipt document | M_InOutLine_ID numeric(10) Search |
Phys.Inventory Line | Phys.Inventory Line | 盘点明细 | The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction | M_InventoryLine_ID numeric(10) Search |
Move Line | 调拨明细 | 调拨明细 | The Movement Line indicates the inventory movement document line (if applicable) for this transaction | M_MovementLine_ID numeric(10) Search |
Production Line | 制造明细 | 制造明细 | The Production Line indicates the production document line (if applicable) for this transaction | M_ProductionLine_ID numeric(10) Search |
Project Issue | Project Issue | Project Issues (Material, Labor) | Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock. | C_ProjectIssue_ID numeric(10) Search |