| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| address | VARCHAR2 | 2997 | Address | ||||
| address_1 | VARCHAR2 | 450 | Address line 1 | ||||
| address_2 | VARCHAR2 | 450 | Address line 2 | ||||
| address_3 | VARCHAR2 | 150 | Address line 3 | ||||
| city | VARCHAR2 | 150 | City | ||||
| company_name | VARCHAR2 | 83 | Company name | ||||
| country | VARCHAR2 | 2 | Country | ||||
| e_mail | VARCHAR2 | 254 | |||||
| fax | VARCHAR2 | 21 | Fax | ||||
| federal_ein | VARCHAR2 | 40 | Employee identification number (EIN) | ||||
| frst_fiscal_month | VARCHAR2 | 3 | First fiscal month | ||||
| legal_name | VARCHAR2 | 83 | Legal name | ||||
| logo_url | VARCHAR2 | 80 | Company logo | ||||
| parent_comp_id | VARCHAR2 | 16 | Parent company ID | ||||
| parent_company | VARCHAR2 | 1 | Parent company | ||||
| phone | VARCHAR2 | 100 | Phone | ||||
| return_address | VARCHAR2 | 2997 | Address for returns | ||||
| shipping_address | VARCHAR2 | 2997 | Shipping address | ||||
| state1 | VARCHAR2 | 50 | State 1 | ||||
| state1_taxid | VARCHAR2 | 40 | State 1 tax ID | ||||
| state2 | VARCHAR2 | 2 | State 2 | ||||
| state2_taxid | VARCHAR2 | 20 | State 2 tax ID | ||||
| state3 | VARCHAR2 | 2 | State 3 | ||||
| state3_taxid | VARCHAR2 | 20 | State 3 tax ID | ||||
| state4 | VARCHAR2 | 2 | State 4 | ||||
| state4_taxid | VARCHAR2 | 20 | State 4 tax ID | ||||
| state5 | VARCHAR2 | 2 | State 5 | ||||
| state5_taxid | VARCHAR2 | 20 | State 5 tax ID | ||||
| web_site | VARCHAR2 | 64 | Web site | ||||
| zip | VARCHAR2 | 108 | Zip code |