Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: 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 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030346080 CATENTRY_ID+FFMCENTER_ID+STORE_ID Primary Key I0000594 FFMCENTER_ID Non-Unique Index I0000595 STORE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Related reference
_vcc_freeselect_bottom_