Defines which DistributionArrangements have access to received inventory.
Column Description(s):
Column Name | Column Type | Description |
RCPTAVAIL_ID |
BIGINT NOT NULL |
Unique identifier. |
DISTARRANG_ID |
BIGINT NOT NULL |
Indicates the DistributionArrangement under which this receipt is available. |
RECEIPT_ID |
BIGINT NOT NULL |
Indicates which receipt is available under the DistributionArrangement. |
PRECEDENCE |
INTEGER |
Represents the order in which inventory should be picked. Picking starts with the lowest number first. |
LASTUPDATE |
TIMESTAMP |
Timestamp of last update. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000203 |
DISTARRANG_ID+RECEIPT_ID |
Unique Index |
SQL050212031303930 |
RCPTAVAIL_ID |
Primary Key |
I0000714 |
RECEIPT_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_658 |
DISTARRANG_ID |
DISTARRANG |
DISTARRANG_ID |
Cascade |
F_659 |
RECEIPT_ID |
RECEIPT |
RECEIPT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.