Column Descriptions
| 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.
|