INVAVL

Each row represents an inventory availability record cached by the Commerce database.

Column Descriptions:

NameTypeDescription
INVAVL_IDBIGINT NOT NULLInternal ID of this record.
AVAILQUANTITYDOUBLEAvailable quantity of the item at the location specified. An inventory status of AVL and an available quantity of NULL means that the item is available and the available quantity is infinite.
AVAILTIMETIMESTAMPAvailability date of the item at the location specified.
AVAILOFFSETINTEGERThe number of seconds from the time when the inventory checking is performed to the time when the product is available.
LASTUPDATETIMESTAMPTime this record was last updated. A value of NULL means that this record never expires, except when INVCNF. CACHEEXPIRYABOVETHRES or INVCNF. CACHEEXPIRYBELOWTHRES (whichever is applicable) is 0, in which case it expires immediately.
FIELD1INTEGERCustomizable
FIELD2DECIMAL (20,5)Customizable
FIELD3VARCHAR (254)Customizable
CATENTRY_IDBIGINT NOT NULLThe catalog entry ID.
STORE_IDINTEGERThe online store ID. Either this or the physical store ID must be specified, but not both.
STLOC_IDINTEGERThe physical store ID. Either this or the online store ID must be specified, but not both.
QUANTITYMEASURECHAR (16) NOT NULL DEFAULT 'C62'Unit of measure of the quantity above.
INVENTORYSTATUSCHAR (4)Inventory status of the item at the location specified. Predefined values include:
AVL
Available
BA
Backorderable
UAVL
Unavailable
OPTCOUNTERSMALLINTThe 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>INVAVL_IDPrimary Key
I0001223CATENTRY_ID+STORE_ID+STLOC_IDUnique Index
I0001224STORE_IDNon-Unique Index
I0001225STLOC_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3581CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_3582STORE_IDSTORESTORE_IDCascade
F_3583STLOC_IDSTLOCSTLOC_IDCascade
F_3584QUANTITYMEASUREQTYUNITQTYUNIT_IDCascade