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 Descriptions:

NameTypeDescription
INVRESERVE_IDBIGINT NOT NULLSystem generated unique identifier.
INVRSRVTYP_IDBIGINT NOT NULLThe type or purpose of the reservation, such as an auction. The types are user defined and are in the INVRSRVTYP table.
QUANTITYINTEGERThe quantity of the reservation.
DESCRIPTIONVARCHAR (254)Descriptive information about this reservation.
EXPIRATIONTIMESTAMPThe date and time when this reservation will expire.
ITEMSPC_IDBIGINTThe identifier for the item being reserved.
LASTUPDATETIMESTAMPThe last time the row was updated.
STORE_IDINTEGERThe Store which owns the inventory.
FFMCENTER_IDINTEGERThe FulfillmentCenter which holds the reserved inventory.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>INVRESERVE_IDPrimary Key
I0001260ITEMSPC_ID+STORE_ID+FFMCENTER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_398INVRSRVTYP_IDINVRSRVTYPINVRSRVTYP_IDCascade
F_399ITEMSPC_ID+STORE_ID+FFMCENTER_IDITEMFFMCTRITEMSPC_ID+STORE_ID+FFMCENTER_IDCascade