Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RCPTAVAIL
Defines which DistributionArrangements have access to received inventory.
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 SQL100520030421060 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
Related reference
_vcc_freeselect_bottom_