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 | 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 |