WebSphere Commerce database table: DISTARRANG

Each row of this table represents a DistributionArrangement, enabling a Store to sell its own inventory.


Column Description(s):
Column NameColumn TypeDescription
DISTARRANG_ID BIGINT NOT NULL Generated primary key.
MERCHANTSTORE_ID INTEGER NOT NULL The merchant Store that can sell from the inventory of the wholesale Store. The value of this column must be the same as the value of the WHOLESALESTORE_ID column.
PICKINGMETHOD CHAR(1) Determines the sequence in which inventory is picked from the RECEIPT table under this arrangement:
F = FIFO (First In First Out) - the least recently received inventory.
L = LIFO (Last in First Out) - the most recently received inventory.
STARTDATE TIMESTAMP NOT NULL The time this DistributionArrangement begins being effective.
ENDDATE TIMESTAMP NOT NULL The time this DistributionArrangement stops being effective.
FIELD1 VARCHAR(254) Customizable.
FIELD2 VARCHAR(254) Customizable.
FIELD3 VARCHAR(254) Customizable.
WHOLESALESTORE_ID INTEGER NOT NULL The wholesale Store that owns the inventory that can be sold by the merchant Store.
BASEITEM_ID BIGINT NOT NULL The product covered by this distribution arrangement.
LASTUPDATE TIMESTAMP The time this DistributionArrangement was most recently updated.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000095 BASEITEM_ID+MERCHANTSTORE_ID+WHOLESALESTORE_ID+STARTDATE+ENDDATE Unique Index
SQL050212031221080 DISTARRANG_ID Primary Key
I0000347 DISTARRANG_ID+MERCHANTSTORE_ID Non-Unique Index
I0000560 MERCHANTSTORE_ID Non-Unique Index
I0000561 WHOLESALESTORE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_310 BASEITEM_ID BASEITEM BASEITEM_ID Cascade
F_308 WHOLESALESTORE_ID STORE STORE_ID Cascade
F_309 MERCHANTSTORE_ID STORE STORE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_658 DISTARRANG_ID RCPTAVAIL DISTARRANG_ID Cascade

Feedback