Database Table: SHPARRANGE

Each row of this table represents a ShippingArrangement, indicating that a FulfillmentCenter can ship products on behalf of a Store using a ShippingMode.

Column Name Column Type Column Description
ENDDATE TIMESTAMP
NULL
The time this ShippingArrangement stops being effective.
FFMCENTER_ID INTEGER
NOT NULL
The FulfillmentCenter.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 INTEGER
NULL
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.
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.
SHIPMODE_ID INTEGER
NULL
The ShippingMode. NULL indicates this ShippingArrangement can be used regardless of ShippingMode.
SHPARRANGE_ID INTEGER
NOT NULL
Generated unique key.
STARTDATE TIMESTAMP
NULL
The time this ShippingArrangement starts being effective.
STORE_ID INTEGER
NOT NULL
The Store.
TRACKINGNUMBER VARCHAR (64)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000229 FFMCENTER_ID, SHIPMODE_ID, STORE_ID, STARTDATE, ENDDATE Unique Index
SQL030416035105320 SHPARRANGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_748 STORE_ID STORE STORE_ID Cascade
F_749 SHIPMODE_ID SHIPMODE SHIPMODE_ID Cascade
F_750 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_747 SHPARRANGE_ID SHPARJURGP SHPARRANGE_ID Cascade