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) |