WebSphere Commerce database table: RCPTAVAIL

Defines which DistributionArrangements have access to received inventory.

Column Descriptions
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.

Indexes
Index Name Indexed Column Names Index Type
I0000203 DISTARRANG_ID+RECEIPT_ID Unique Index
SQL060903235241840 RCPTAVAIL_ID Primary Key
I0000714 RECEIPT_ID Non-Unique Index

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