RABACKALLO

Each row contains information about how backorders are allocated against expected inventory.

Column Descriptions:

NameTypeDescription
RABACKALLONUMINTEGER NOT NULLUniquely identifies this row for a backordered OrderItem.
RADETAIL_IDBIGINT NOT NULLThe RADETAIL row which contributed to the allocation.
ITEMSPC_IDBIGINT NOT NULLThe backordered item.
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem that is backordered.
QTYALLOCATEDINTEGERAmount of expected inventory allocated to this backordered OrderItem.
LASTUPDATETIMESTAMPTimestamp of the last update.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>ORDERITEMS_ID+RABACKALLONUMPrimary Key
I0000710ITEMSPC_IDNon-Unique Index
I0000711RADETAIL_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_652RADETAIL_IDRADETAILRADETAIL_IDCascade
F_653ITEMSPC_IDITEMSPCITEMSPC_IDCascade
F_654ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade