The OPTIM_SHIP_TO table contains order shipping information.
The OPTIM_SHIP_TO table has the following
columns:
- CUST_ID
- CHAR; up to 5 characters; cannot contain null.
- SHIP_ID
- DECIMAL; cannot contain null.
- ADDRESS1
- VARCHAR; up to 100 characters
- ADDRESS2
- VARCHAR; up to 100 characters
- LOCALITY
- VARCHAR; up to 56 characters
- CITY
- VARCHAR; up to 30 characters
- STATE
- VARCHAR; up to 30 characters
- COUNTRY_CODE
- CHAR; 2 character abbreviation
- POSTAL_CODE
- VARCHAR; up to 15 characters
- POSTAL_CODE_PLUS4
- CHAR; 4 characters
- IN_CARE_OF
- VARCHAR; up to 31 characters
- SHIPPING_CHANGE_DT
- TIMESTAMP; cannot contains nulls; has default value.
Primary Keys
The
SHIP_ID column is the primary key column.
Relationships to Other Tables
The OPTIM_SHIP_TO table is a parent of the OPTIM_SHIP_INSTR
table, through an Optim™ relationship
on column SHIP_ID.
The OPTIM_SHIP_TO table is
a child of the OPTIM_CUSTOMERS table, through its Optim relationship on column CUST_ID.