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:
Name | Type | Description |
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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | INVRESERVE_ID | Primary Key |
I0001260 | ITEMSPC_ID+STORE_ID+FFMCENTER_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_398 | INVRSRVTYP_ID | INVRSRVTYP | INVRSRVTYP_ID | Cascade |
F_399 | ITEMSPC_ID+STORE_ID+FFMCENTER_ID | ITEMFFMCTR | ITEMSPC_ID+STORE_ID+FFMCENTER_ID | Cascade |