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:

NameTypeDescription
CATENTRY_IDBIGINT NOT NULLThe CatalogEntry.
QUANTITYDOUBLE NOT NULL DEFAULT 0The quantity amount, in units indicated by QUANTITYMEASURE.
FFMCENTER_IDINTEGER NOT NULLThe FulfillmentCenter.
STORE_IDINTEGER NOT NULLThe Store.
QUANTITYMEASURECHAR (16) NOT NULL DEFAULT 'C62'The unit of measurement for QUANTITY.
INVENTORYFLAGSINTEGER NOT NULL DEFAULT 0Bit 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. 4 = actualQuantity. The default CheckInventory and UpdateInventory task commands do not check QUANTITY.
Note: Fetching non-ATP inventory availability for Catalog entry with INVENTORYFLAGS value 2 always returns with QUANTITY 1. The Catalog entry with INVENTORYFLAGS value 4 returns with the actual QUANTITY measure if QUANTITY is greater than 1 in the Inventory table; otherwise, it will return 1.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATENTRY_ID+FFMCENTER_ID+STORE_IDPrimary Key
I0000594FFMCENTER_IDNon-Unique Index
I0000595STORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_393STORE_IDSTORESTORE_IDCascade
F_394QUANTITYMEASUREQTYUNITQTYUNIT_IDCascade
F_395CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_396FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade