WebSphere Commerce database table: INVRESERVE

Each row contains information about existing inventory that has been reserved for such purposes as auctions. This reserved inventory is not available for customer orders until the reservation is reversed.


Column Description(s):
Column NameColumn TypeDescription
INVRESERVE_ID BIGINT NOT NULL System generated unique identifier.
INVRSRVTYP_ID BIGINT NOT NULL The type or purpose of the reservation, such as an auction. The types are user defined and are in the INVRSRVTYP table.
QUANTITY INTEGER The quantity of the reservation.
DESCRIPTION VARCHAR(254) Descriptive information about this reservation.
EXPIRATION TIMESTAMP The date and time when this reservation will expire.
ITEMSPC_ID BIGINT The identifier for the item being reserved.
LASTUPDATE TIMESTAMP The last time the row was updated.
STORE_ID INTEGER The Store which owns the inventory.
FFMCENTER_ID INTEGER The FulfillmentCenter which holds the reserved inventory.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031234330 INVRESERVE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_398 INVRSRVTYP_ID INVRSRVTYP INVRSRVTYP_ID Cascade
F_399 ITEMSPC_ID STORE_ID FFMCENTER_ID ITEMFFMCTR ITEMSPC_ID Cascade

Feedback