DISTARRANG

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

Column Descriptions:

NameTypeDescription
DISTARRANG_IDBIGINT NOT NULLGenerated primary key.
MERCHANTSTORE_IDINTEGER NOT NULLThe 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.
PICKINGMETHODCHAR (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.
STARTDATETIMESTAMP NOT NULLThe time this DistributionArrangement begins being effective.
ENDDATETIMESTAMP NOT NULLThe time this DistributionArrangement stops being effective. Specify an end date that will not expire, for example: '9999-12-31 23:59:59.0'
FIELD1VARCHAR (254)Customizable.
FIELD2VARCHAR (254)Customizable.
FIELD3VARCHAR (254)Customizable.
WHOLESALESTORE_IDINTEGER NOT NULLThe wholesale Store that owns the inventory that can be sold by the merchant Store.
BASEITEM_IDBIGINT NOT NULLThe product covered by this distribution arrangement.
LASTUPDATETIMESTAMPThe time this DistributionArrangement was most recently updated.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>DISTARRANG_IDPrimary Key
I0000095 BASEITEM_ID+MERCHANTSTORE_ID+WHOLESALESTORE_ID+STARTDATE+ENDDATEUnique Index
I0000347DISTARRANG_ID+MERCHANTSTORE_IDNon-Unique Index
I0000560MERCHANTSTORE_IDNon-Unique Index
I0000561WHOLESALESTORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_308WHOLESALESTORE_IDSTORESTORE_IDCascade
F_309MERCHANTSTORE_IDSTORESTORE_IDCascade
F_310BASEITEM_IDBASEITEMBASEITEM_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_658DISTARRANG_IDRCPTAVAILDISTARRANG_IDCascade