View source | Discuss this page | Page history | Printable version   

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:
  • For Product Attribute Sets checked as Serial Number, the Attribute Value is the serial number value.
  • For Product Attribute Sets checked as Lot, the Attribute Value is the lot value.
  • For Product Attribute Sets with only one Attribute, the Attribute Value is the value of that attribute.

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)

Retrieved from "http://wiki.openbravo.com/wiki/Modules:IDL_On_Hand_Quantity"

This page has been accessed 5,412 times. This page was last modified on 11 April 2013, at 15:09. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.