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 Descriptions:

NameTypeDescription
SHPARRANGE_IDINTEGER NOT NULLGenerated unique key.
STORE_IDINTEGER NOT NULLThe Store.
FFMCENTER_IDINTEGER NOT NULLThe FulfillmentCenter.
SHIPMODE_IDINTEGERThe ShippingMode. NULL indicates this ShippingArrangement can be used regardless of ShippingMode.
STARTDATETIMESTAMPThe time this ShippingArrangement starts being effective. If STARTDATE is NULL, it means it begin effective from the beginning.
ENDDATETIMESTAMPThe time this ShippingArrangement stops being effective. If ENDDATE is NULL, it means it will effective forever once it has been started. The default value is set to '9999-12-31 23:59:59.0'. If the EndDate expires, this ShippingArrangement turns invaild and then shoppers could not add items to the cart with this ShippingArrangement.
TRACKINGNUMBERVARCHAR (64)Reserved for IBM internal use.
FIELD1VARCHAR (254)Customizable.
PRECEDENCEDOUBLE NOT NULL DEFAULT 0When more than one ShippingArrangement (for the same Store and ShippingMode) is effective at a particular time, the one with the highest precedence is used.
FIELD2INTEGERCustomizable.
FLAGSINTEGER NOT NULL DEFAULT 0The 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.
OPTCOUNTERSMALLINTThe 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>SHPARRANGE_IDPrimary Key
I0000229 FFMCENTER_ID+SHIPMODE_ID+STORE_ID+STARTDATE+ENDDATEUnique Index
I0000765SHIPMODE_IDNon-Unique Index
I0000766STORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_748STORE_IDSTORESTORE_IDCascade
F_749SHIPMODE_IDSHIPMODESHIPMODE_IDCascade
F_750FFMCENTER_IDFFMCENTERFFMCENTER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_747SHPARRANGE_IDSHPARJURGPSHPARRANGE_IDCascade