This table contains detailed information about items on an expected inventory record.
Column Name | Column Type | Column Description |
---|---|---|
EXPECTEDDATE | TIMESTAMP NOT NULL |
Date the inventory is expected. |
FFMCENTER_ID | INTEGER NULL |
FulfillmentCenter identifier. |
ITEMSPC_ID | BIGINT NOT NULL |
Item identifier. |
LASTUPDATE | TIMESTAMP NULL |
Timestamp of last update. |
MARKFORDELETE | INTEGER NOT NULL, DEFAULT 0 |
Indicates if this row has been marked for deletion: 0 = No. 1 = Yes, this row has been marked for deletion and should not be used. |
QTYALLOCATED | INTEGER NOT NULL, DEFAULT 0 |
Quantity of expected inventory that has been allocated to backorders. |
QTYORDERED | INTEGER NOT NULL, DEFAULT 0 |
Quantity ordered from vendor in this expected inventory record. |
QTYRECEIVED | INTEGER NOT NULL, DEFAULT 0 |
Quantity received to date from the vendor for this expected inventory record. |
QTYREMAINING | INTEGER NOT NULL, DEFAULT 0 |
Quantity still expected from vendor for this expected inventory record. This quantity should usually be equal to the quantity ordered minus the quantity received, but could be different if the vendor is unable to ship the total quantity. |
RADETAILCOMMENT | VARCHAR (254) NULL |
Comment. |
RADETAIL_ID | BIGINT NOT NULL |
Unique identifier. |
RA_ID | BIGINT NOT NULL |
Expected inventory record identifier. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000201 | RA_ID, FFMCENTER_ID, ITEMSPC_ID, EXPECTEDDATE | Unique Index |
I0000202 | RA_ID, RADETAIL_ID, EXPECTEDDATE | Non-Unique Index |
SQL030416035048170 | RADETAIL_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_655 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | Cascade |
F_656 | ITEMSPC_ID | ITEMSPC | ITEMSPC_ID | Cascade |
F_657 | RA_ID | RA | RA_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_652 | RADETAIL_ID | RABACKALLO | RADETAIL_ID | Cascade |
F_660 | RADETAIL_ID | RECEIPT | RADETAIL_ID | Cascade |