Each row of this table represents a ShippingArrangement, indicating that a FulfillmentCenter can ship products on behalf of a Store using a ShippingMode.
Column Descriptions
| Column Name
| Column Type
| Description
|
| SHPARRANGE_ID
| INTEGER NOT NULL
| Generated unique key.
|
| STORE_ID
| INTEGER NOT NULL
| The Store.
|
| FFMCENTER_ID
| INTEGER NOT NULL
| The FulfillmentCenter.
|
| SHIPMODE_ID
| INTEGER
| The ShippingMode. NULL indicates this ShippingArrangement can be used regardless of ShippingMode.
|
| STARTDATE
| TIMESTAMP
| The time this ShippingArrangement starts being effective.
|
| ENDDATE
| TIMESTAMP
| The time this ShippingArrangement stops being effective.
|
| TRACKINGNUMBER
| VARCHAR(64)
| Reserved for IBM internal use.
|
| FIELD1
| VARCHAR(254)
| Customizable.
|
| PRECEDENCE
| DOUBLE NOT NULL DEFAULT 0
| When more than one ShippingArrangement (for the same Store and ShippingMode) is effective at a particular time, the one with the highest precedence is used.
|
| FIELD2
| INTEGER
| Customizable.
|
| FLAGS
| INTEGER NOT NULL DEFAULT 0
| The low order bit contains a flag as follows:
1 - restricted: If this flag is 1, then this ShippingArrangement applies only to OrderItems whose shipping Addresses match one of the ShippingJurisdictionGroups associated (through the SHPARJURGP table) with this ShippingArrangement. Otherwise, it applies to all OrderItems.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|