INVENTORY

The inventory table. Each row of this table contains a quantity amount representing the inventory for a particular CatalogEntry. The CatalogEntry is available to be shipped from a FulfillmentCenter on behalf of a Store. This table cannot be used in conjunction with Available To Promise (ATP) inventory allocation. It is used only when ATP inventory is not enabled (refer to the INVENTORYSYSTEM column of the STORE table). And it is used by the default implementations of the non-ATP inventory task commands: ResolveFullmentCenterCmd, CheckInventoryCmd, UpdateInventoryCmd, and ReverseUpdateInventoryCmd.

Column Descriptions:

Name	Type	Description
CATENTRY_ID	BIGINT NOT NULL	The CatalogEntry.
QUANTITY	DOUBLE NOT NULL DEFAULT 0	The quantity amount, in units indicated by QUANTITYMEASURE.
FFMCENTER_ID	INTEGER NOT NULL	The FulfillmentCenter.
STORE_ID	INTEGER NOT NULL	The Store.
QUANTITYMEASURE	CHAR (16) NOT NULL DEFAULT 'C62'	The unit of measurement for QUANTITY.
INVENTORYFLAGS	INTEGER NOT NULL DEFAULT 0	Bit flags, from low to high order, indicating how QUANTITY is used: 1 = noUpdate. The default UpdateInventory task command does not update QUANTITY. 2 = noCheck. The default CheckInventory and UpdateInventory task commands do not check QUANTITY.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CATENTRY_ID+FFMCENTER_ID+STORE_ID	Primary Key
I0000594	FFMCENTER_ID	Non-Unique Index
I0000595	STORE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_393	STORE_ID	STORE	STORE_ID	Cascade
F_394	QUANTITYMEASURE	QTYUNIT	QTYUNIT_ID	Cascade
F_395	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_396	FFMCENTER_ID	FFMCENTER	FFMCENTER_ID	Cascade

Related reference
Fulfillment data model
Quantity unit - references data model