Modules:IDL On Hand Quantity
Introduction
Stock levels are the products units available in different locations managed by Openbravo ERP.
Input file definition
Field name | Type | Nullable | Description | Accepted values | Comment |
---|---|---|---|---|---|
Organization | String(40) | No | Indicates the organization to be used when processing documents. | Organization search key | |
TransactionalOrg | String(40) | No | Indicates the organization to be used when processing transactional documents. | [Organization search key] | |
Name | String(60) | No | Indicates the name of the physical inventory header. | ||
Description | String(255) | Yes | Additional related information for the physical inventory header. | ||
MovementDate | Date | No | Date a product was moved in or out of inventory. | ||
Warehouse | String(40) | No | The warehouse that is used to store products. | Warehouse Search Key | If a warehouse with the described value does not exist, a new warehouse is created. |
WarehouseName | String(60) | No | Indicates the name of the warehouse | ||
WarehouseDescription | String(255) | Yes | Additional related information for the warehouse. | ||
Warehouse1stLine | String(60) | Yes | Identifies the address for an entity's location | ||
Warehouse2ndline | String(60) | Yes | Provides additional address information for an entity. It can be used for building location, apartment number or similar information. | ||
WarehousePostalCode | String(10) | Yes | Identifies the postal code for this entity's address. | ||
WarehouseCity | String(60) | Yes | City in a country. | ||
WarehouseRegion | String(60) | Yes | Identifies a unique Region for this Country. | Region Name | |
WarehouseCountry | String(60) | Yes | Defines a Country. Each Country must be defined before it can be used in any document. | Country Name | |
WarehouseBinSeparator | String(1) | Yes | The Element Separator defines the delimiter printed between elements of the structure. | ||
Bin | String(40) | No | A set of coordinates (x, y, z) which help locate an item in a warehouse. | Bin Search Key | If a bin with the described value does not exist, a new bin is created. |
BinIsDefault | Boolean | No | A value that is shown whenever a record is created. | ||
BinPriority | Number(10, 0) | No | Where inventory should be picked from first. | ||
BinRowX | String(60) | Yes | X dimension, e.g., Aisle | ||
BinStackY | String(60) | Yes | Y dimension, e.g., Bin | ||
BinLevelZ | String(60) | Yes | Z dimension, e.g., Level | ||
Product | String(40) | No | Identifies an item which is either purchased or sold in this organization. | Product Search Key | The product must exist in the database. |
AttributeValue | String(60) | Yes | Individual value of a product attribute, serial number or lot. (e.g. green, large, ..) | The Attribute value meaning depends on the Product Attribute Set defined:
There is not defined a behaviour for Product Attribute Sets with more than one Attribute. | |
Quantity | Number | No | The number of a certain item involved in the transaction. | ||
Cost | Number | Yes | The cost of the product of the line. |
* This fields can be NULL if they have a default value associated.
Default Value definition
Field name | Type | Accepted values | Examples |
---|---|---|---|
Organization | String(40) | [search_key] column from [AD_Org] table | |
TransactionalOrg | String(40) | [search_key] column from [AD_Org] table | |
Name | String(40) | ||
Description | String(60) | ||
MovementDate | Date | yyyy-MM-dd format. | |
Warehouse | String(40) | Search Key column from Warehouse table | |
WarehouseName | String(60) | ||
WarehouseDescription | String(255) | ||
WarehouseCountry | String(60) | Name column from Country table. | |
WarehouseBinSeparator | String(1) | ||
Bin | String(40) | Search Key column from Locator table. | |
BinIsDefault | Boolean | True, False, Yes, No, Y, N. | |
BinPriority | Number(10, 0) | ||
BinRowX | String(60) | ||
BinStackY | String(60) | ||
BinLevelZ | String(60) |