Database Table: INVENTORY

The inventory table. Each row of this table contains a quantity amount representing the inventory for a particular CatalogEntry 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 ALLOCATIONGOODFOR column of the STORE table), and is used by the default implementations of the non-ATP inventory task commands: ResolveFullmentCenterCmd, CheckInventoryCmd, UpdateInventoryCmd, and ReverseUpdateInventoryCmd.

Column Name Column Type Column Description
CATENTRY_ID BIGINT
NOT NULL
The CatalogEntry.
FFMCENTER_ID INTEGER
NOT NULL
The FulfillmentCenter.
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.
QUANTITY DOUBLE
NOT NULL, DEFAULT 0
The quantity amount, in units indicated by QUANTITYMEASURE.
QUANTITYMEASURE CHARACTER (16)
NOT NULL, DEFAULT 'C62'
The unit of measurement for QUANTITY.
STORE_ID INTEGER
NOT NULL
The Store.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034947210 CATENTRY_ID, FFMCENTER_ID, STORE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable