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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000229 | FFMCENTER_ID, SHIPMODE_ID, STORE_ID, STARTDATE, ENDDATE | Unique Index |
SQL030416035105320 | SHPARRANGE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_747 | SHPARRANGE_ID | SHPARJURGP | SHPARRANGE_ID | Cascade |