Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: SHIPINFO
This table is used to store two different types of shipping information. Both sets of information will be passed in the generated PackSlip.xml file. The first set of information 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 information is to store a shipping carrier account number. A shipping carrier account number will be stored for any order and shipmode combination.
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.
Indexes Index Name Indexed Column Names Index Type I0000898 ORDERS_ID+SHIPMODE_ID+ADDRESS_ID Unique Index SQL100520030428660 SHIPINFO_ID Primary Key I0000899 ADDRESS_ID Non-Unique Index I0000900 POLICY_ID Non-Unique Index I0000902 SHIPMODE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 _vcc_freeselect_bottom_