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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000203 | DISTARRANG_ID, RECEIPT_ID | Unique Index |
SQL030416035048510 | RCPTAVAIL_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|