| objid | bus_site_role | objid | Bus_site_role internal record number | 3 (UNIQUE) |
| site_objid | site | objid | Site internal record number | |
| site_id | site | site_id | Unique site number assigned according to auto-numbering definition | |
| site_name | site | name | Name of the site | |
| site_type | site | type | Site type; i.e., 1=BUSINESS, 2=OFFICE, 3=RESELLER, 4=INDIVIDUAL, 5=VENDOR | |
| phone | site | phone | Main phone number | |
| fax | site | fax | Main fax number | |
| ship_via | site | ship_via | Default means of shipment for the site. This is from a Clarify-defined popup list with default name SHIP_VIA | |
| address | address | address | Line 1 of site address which includes street number, street name, office, building, or suite number, etc | |
| city | address | city | The city for the specified address | |
| state | address | state | The state for the specified address | |
| country_code | country | code | Country code used in telephone numbers for that country | |
| site_typest | site | site_type | Mnemonic representation of the integer site type field | |
| status | site | status | Status of site; i.e., 0=active, 1=inactive, 2=obsolete, default=0 | |
| bus_org_objid | bus_org | objid | Bus Org internal record number | |
| org_id | bus_org | org_id | User-specified ID number of the organization | |
| org_name | bus_org | name | Name of the organization | |
| org_type | bus_org | type | Business type; e.g., competitor, prospect, customer, etc., from a user-defined pop up | |
| country_name | country | name | Name of the site's country | |
| zipcode | address | zipcode | The zip or other postal code for the specified site address | |
| country_objid | country | objid | Country internal record number | |
| address_objid | address | objid | Address internal record number | |
| region | site | region | Region to which the site belongs | |
| district | site | district | District to which the site belongs | |
| address_2 | address | address_2 | Line 2 of address which typically includes office, building, or suite number, etc | |
| time_zone_objid | time_zone | objid | Time Zone internal record number | |
| time_zone_name | time_zone | name | Time Zone name | |