This table contains detailed information about items on an expected inventory record.
Column Descriptions
| Column Name
| Column Type
| Description
|
| RADETAIL_ID
| BIGINT NOT NULL
| Unique identifier.
|
| RA_ID
| BIGINT NOT NULL
| Expected inventory record identifier.
|
| FFMCENTER_ID
| INTEGER
| FulfillmentCenter identifier.
|
| ITEMSPC_ID
| BIGINT NOT NULL
| Item identifier.
|
| 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 it could be different if the vendor is unable to ship the total quantity.
|
| QTYALLOCATED
| INTEGER NOT NULL DEFAULT 0
| Quantity of expected inventory that has been allocated to backorders.
|
| EXPECTEDDATE
| TIMESTAMP NOT NULL
| Date the inventory is expected.
|
| RADETAILCOMMENT
| VARCHAR(254)
| Comment.
|
| LASTUPDATE
| TIMESTAMP
| 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.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|