Each row of this table represents a DistributionArrangement, enabling a Store to sell its own inventory.
Column Description(s):
Column Name | Column Type | Description |
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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_658 |
DISTARRANG_ID |
RCPTAVAIL |
DISTARRANG_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.