INVAVL

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

Column Descriptions:

Name	Type	Description
INVAVL_ID	BIGINT NOT NULL	Internal ID of this record.
AVAILQUANTITY	DOUBLE	Available 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.
AVAILTIME	TIMESTAMP	Availability date of the item at the location specified.
AVAILOFFSET	INTEGER	The number of seconds from the time when the inventory checking is performed to the time when the product is available.
LASTUPDATE	TIMESTAMP	Time 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.
FIELD1	INTEGER	Customizable
FIELD2	DECIMAL (20,5)	Customizable
FIELD3	VARCHAR (254)	Customizable
CATENTRY_ID	BIGINT NOT NULL	The catalog entry ID.
STORE_ID	INTEGER	The online store ID. Either this or the physical store ID must be specified, but not both.
STLOC_ID	INTEGER	The physical store ID. Either this or the online store ID must be specified, but not both.
QUANTITYMEASURE	CHAR (16) NOT NULL DEFAULT 'C62'	Unit of measure of the quantity above.
INVENTORYSTATUS	CHAR (4)	Inventory status of the item at the location specified. Predefined values include: AVL Available BA Backorderable UAVL Unavailable
OPTCOUNTER	SMALLINT	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Constraint	Columns	Parent Table	Parent Columns	Type
F_3581	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_3582	STORE_ID	STORE	STORE_ID	Cascade
F_3583	STLOC_ID	STLOC	STLOC_ID	Cascade
F_3584	QUANTITYMEASURE	QTYUNIT	QTYUNIT_ID	Cascade