Inventory (erp_inventory)

Field name	Type	Constraints	Meaning
Administration	Text (max 50 chars)		A reference to the ERP system that provided the data
ERP code	Text (max 256 chars)	Unique, not empty	The unique code by which the inventory lot is known.
WH.code	Text (max 50 chars)	Not empty	The unique code of the warehouse
Prod.code	Text (max 50 chars)	Not empty	The unique code of the product
Quantity	Decimal (5 DPs)	Not empty, greater than zero	The quantity of the product code (in base unit, i.e. what has been specified as the SKU_code for the product)
Release date	Datetime	Before the expiration date (if given)	The date when the inventory lot is ready to serve demand
Expiration date	Datetime	After the release date (if given)	The date when the inventory lot expires. This is the true end, not fit for consumption. The shelf life guaranteer, i.e. the number of days left that the retailer insists on is managed per product-customer. Null means the lot will never expire
Inventory status	Text (max 50 chars)		e.g. free, reserved
Production date	Datetime	Before the release date (if given)
Datetime stamp	Datetime		The date/time of when the inventory was recorded