WebSphere Commerce database table: RCPTAVAIL

Defines which DistributionArrangements have access to received inventory.


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I0000203 DISTARRANG_ID+RECEIPT_ID Unique Index
SQL050212031303930 RCPTAVAIL_ID Primary Key
I0000714 RECEIPT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_658 DISTARRANG_ID DISTARRANG DISTARRANG_ID Cascade
F_659 RECEIPT_ID RECEIPT RECEIPT_ID Cascade

Feedback