RADETAIL

This table contains detailed information about items on an expected inventory record.

Column Descriptions:

NameTypeDescription
RADETAIL_IDBIGINT NOT NULLUnique identifier.
RA_IDBIGINT NOT NULLExpected inventory record identifier.
FFMCENTER_IDINTEGERFulfillmentCenter identifier.
ITEMSPC_IDBIGINT NOT NULLItem identifier.
QTYORDEREDINTEGER NOT NULL DEFAULT 0Quantity ordered from vendor in this expected inventory record.
QTYRECEIVEDINTEGER NOT NULL DEFAULT 0Quantity received to date from the vendor for this expected inventory record.
QTYREMAININGINTEGER NOT NULL DEFAULT 0Quantity 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.
QTYALLOCATEDINTEGER NOT NULL DEFAULT 0Quantity of expected inventory that has been allocated to backorders.
EXPECTEDDATETIMESTAMP NOT NULLDate the inventory is expected.
RADETAILCOMMENTVARCHAR (254)Comment.
LASTUPDATETIMESTAMPTimestamp of last update.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this row has been marked for deletion: 0 = No. 1 = Yes, this row has been marked for deletion and should not be used.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RADETAIL_IDPrimary Key
I0000201RA_ID+FFMCENTER_ID+ITEMSPC_ID+EXPECTEDDATEUnique Index
I0000202RA_ID+RADETAIL_ID+EXPECTEDDATENon-Unique Index
I0000712ITEMSPC_IDNon-Unique Index
I0000713FFMCENTER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_655FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade
F_656ITEMSPC_IDITEMSPCITEMSPC_IDCascade
F_657RA_IDRARA_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_652RADETAIL_IDRABACKALLORADETAIL_IDCascade
F_660RADETAIL_IDRECEIPTRADETAIL_IDCascade