RCPTAVAIL

Defines which DistributionArrangements have access to received inventory.

Column Descriptions:

NameTypeDescription
RCPTAVAIL_IDBIGINT NOT NULLUnique identifier.
DISTARRANG_IDBIGINT NOT NULLIndicates the DistributionArrangement under which this receipt is available.
RECEIPT_IDBIGINT NOT NULLIndicates which receipt is available under the DistributionArrangement.
PRECEDENCEINTEGERRepresents the order in which inventory should be picked. Picking starts with the lowest number first.
LASTUPDATETIMESTAMPTimestamp of 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>RCPTAVAIL_IDPrimary Key
I0000203DISTARRANG_ID+RECEIPT_IDUnique Index
I0000714RECEIPT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_658DISTARRANG_IDDISTARRANGDISTARRANG_IDCascade
F_659RECEIPT_IDRECEIPTRECEIPT_IDCascade