Database Table: RADETAIL

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.
Indexes:
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
Constraints:
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

Referenced By:
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