WebSphere Commerce database table: INVAVL

Reference > Database > WebSphere Commerce database tables > I

WebSphere Commerce database table: INVAVL

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

Column Name Column 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 now when the item will be available at the location specified.
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 Reserved IBM Internal Use

Indexes
Index Name Indexed Column Names Index Type
I0001223 CATENTRY_ID+STORE_ID+STLOC_ID Unique Index
SQL100520030345620 INVAVL_ID Primary Key
I0001224 STORE_ID Non-Unique Index
I0001225 STLOC_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_3581 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_3584 QUANTITYMEASURE QTYUNIT QTYUNIT_ID Cascade
F_3583 STLOC_ID STLOC STLOC_ID Cascade
F_3582 STORE_ID STORE STORE_ID Cascade
_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column 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 now when the item will be available at the location specified.
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	Reserved IBM Internal Use

Index Name	Indexed Column Names	Index Type
I0001223	CATENTRY_ID+STORE_ID+STLOC_ID	Unique Index
SQL100520030345620	INVAVL_ID	Primary Key
I0001224	STORE_ID	Non-Unique Index
I0001225	STLOC_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_3581	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_3584	QUANTITYMEASURE	QTYUNIT	QTYUNIT_ID	Cascade
F_3583	STLOC_ID	STLOC	STLOC_ID	Cascade
F_3582	STORE_ID	STORE	STORE_ID	Cascade