Database Table: RCPTAVAIL

Defines which DistributionArrangements have access to received inventory.

Column Name Column Type Column Description
DISTARRANG_ID BIGINT
NOT NULL
Indicates the DistributionArrangement under which this receipt is available.
LASTUPDATE TIMESTAMP
NULL
Timestamp of last update.
PRECEDENCE INTEGER
NULL
Represents the order in which inventory should be picked. Picking starts with the lowest number first.
RCPTAVAIL_ID BIGINT
NOT NULL
Unique identifier.
RECEIPT_ID BIGINT
NOT NULL
Indicates which receipt is available under the DistributionArrangement.
Indexes:
Index Name Indexed Column Names Index Type
I0000203 DISTARRANG_ID, RECEIPT_ID Unique Index
SQL030416035048510 RCPTAVAIL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_658 DISTARRANG_ID DISTARRANG DISTARRANG_ID Cascade
F_659 RECEIPT_ID RECEIPT RECEIPT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable