OPTIM_SHIP_TO Table

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.



Feedback