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 Name | Column Type | Column Description |
---|---|---|
DESCRIPTION | VARCHAR (254) NULL |
Descriptive information about this reservation. |
EXPIRATION | TIMESTAMP NULL |
The date and time when this reservation will expire. |
FFMCENTER_ID | INTEGER NULL |
The FulfillmentCenter which holds the reserved inventory. |
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. |
ITEMSPC_ID | BIGINT NULL |
The identifier for the item being reserved. |
LASTUPDATE | TIMESTAMP NULL |
The last time the row was updated. |
QUANTITY | INTEGER NULL |
The quantity of the reservation. |
STORE_ID | INTEGER NULL |
The Store which owns the inventory. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034947850 | INVRESERVE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_398 | INVRSRVTYP_ID | INVRSRVTYP | INVRSRVTYP_ID | Cascade |
F_399 | FFMCENTER_ID, ITEMSPC_ID, STORE_ID | ITEMFFMCTR | FFMCENTER_ID, ITEMSPC_ID, STORE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|