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 | 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 | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031234010 | CATENTRY_ID+FFMCENTER_ID+STORE_ID | Primary Key |
I0000594 | FFMCENTER_ID | Non-Unique Index |
I0000595 | STORE_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_395 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_396 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | Cascade |
F_394 | QUANTITYMEASURE | QTYUNIT | QTYUNIT_ID | Cascade |
F_393 | STORE_ID | STORE | STORE_ID | Cascade |