This table is used to store two diffrent types of shipping information. Both sets of infomation will be passed in the generated PackSlip.xml file. The first set of infomation is to store shipping instructions. Only one set of shipping instructions will be captured for any order, address, and shipmode combination. The second set of infomation is to store a shipping carrier account number. A shipping carrier account number will be stored for any order and shipmode combination.
Column Description(s):
Column Name | Column Type | Description |
SHIPINFO_ID |
BIGINT NOT NULL |
Generated unique key. |
ORDERS_ID |
BIGINT NOT NULL |
This is the order ID of the order that this entry is associated with. |
ADDRESS_ID |
BIGINT NOT NULL |
This is the address ID for which the shipping instructions apply to. This field will be -1 when a shipping carrier account number is specified. |
POLICY_ID |
BIGINT |
This value is the business policy ID for the shipping carrier account number. This value will be null if a shipping instruction is being specified for this row entry. |
SHIPMODE_ID |
INTEGER NOT NULL |
This is the shipping mode that infomation is being attached to. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
CARRIERACCNTNUM |
VARCHAR(100) |
This is the shipping carrier account number specified by the customer or the service representative. This value will be null if a shipping instruction is being specified for this row entry. |
INSTRUCTIONS |
VARCHAR(4000) |
These are the shipping instructions specified by the customer or the service representative. This value will be null if shipping carrier account number is specified for this row entry. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000898 |
ORDERS_ID+SHIPMODE_ID+ADDRESS_ID |
Unique Index |
SQL050212031311200 |
SHIPINFO_ID |
Primary Key |
I0000899 |
ADDRESS_ID |
Non-Unique Index |
I0000900 |
POLICY_ID |
Non-Unique Index |
I0000902 |
SHIPMODE_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1146 |
ADDRESS_ID |
ADDRESS |
ADDRESS_ID |
Cascade |
F_1145 |
ORDERS_ID |
ORDERS |
ORDERS_ID |
Cascade |
F_1147 |
POLICY_ID |
POLICY |
POLICY_ID |
Cascade |
F_1148 |
SHIPMODE_ID |
SHIPMODE |
SHIPMODE_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.