Database Table: DISTARRANG

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

Column Name Column Type Column Description
BASEITEM_ID BIGINT
NOT NULL
The product covered by this distribution arrangement.
DISTARRANG_ID BIGINT
NOT NULL
Generated primary key.
ENDDATE TIMESTAMP
NOT NULL
The time this DistributionArrangement stops being effective.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
FIELD3 VARCHAR (254)
NULL
Customizable.
LASTUPDATE TIMESTAMP
NULL
The time this DistributionArrangement was most recently updated.
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 CHARACTER (1)
NULL
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.
WHOLESALESTORE_ID INTEGER
NOT NULL
The wholesale Store that owns the inventory that can be sold by the merchant Store.
Indexes:
Index Name Indexed Column Names Index Type
I0000095 BASEITEM_ID, MERCHANTSTORE_ID, WHOLESALESTORE_ID, STARTDATE, ENDDATE Unique Index
SQL030416034922500 DISTARRANG_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_308 WHOLESALESTORE_ID STORE STORE_ID Cascade
F_309 MERCHANTSTORE_ID STORE STORE_ID Cascade
F_310 BASEITEM_ID BASEITEM BASEITEM_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_658 DISTARRANG_ID RCPTAVAIL DISTARRANG_ID Cascade