| objid | site | objid | Site internal record number | 3 (UNIQUE) |
| site_id | site | site_id | Site ID number | |
| 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 | |
| site_status | site | status | Status of site; i.e., 0=active, 1=inactive, 2=obsolete, default=0 | |
| address | address | address | Line 1 of address which includes street number, street name, office, building, or suite number, etc | |
| address_2 | address | address_2 | Line 2 of address which typically includes office, building, or suite number, etc | |
| city | address | city | The city for the specified address | |
| zipcode | address | zipcode | The zip code or other postal code for the address | |
| state | address | state | The state for the specified address | |
| country_name | country | name | The country name for the specified address | |
| country_objid | country | objid | Country internal record number | |
| address_objid | address | objid | Address internal record number | |
| con_objid | contact | objid | Contact internal record number | |
| contact_role_objid | contact_role | objid | Contact_role internal record number | |