objid | site | objid | Site internal record number | 3 (UNIQUE) |
site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
site_name | site | name | Site name | |
site_type | site | type | Site type | |
address | address | address | Site address | |
city | address | city | Site city | |
state | address | state | Site state | |
country_code | country | code | Site country code | |
site_typest | site | site_type | Site type string | |
status | site | status | Status of site; i.e., active, inactive, obsolete | |
bus_org_objid | bus_org | objid | Bus Org internal record number | |
org_id | bus_org | org_id | Business organization's ID number | |
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 | Site's zipcode | |
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 | |
x_res1 | site | x_res1 | Data Restriction field | |
x_res2 | site | x_res2 | Data Restriction field | |
x_res3 | site | x_res3 | Data Restriction field | |
x_res4 | site | x_res4 | Data Restriction field | |
x_res5 | site | x_res5 | Data Restriction field | |
x_no_alias | site | x_no_alias | Is this site a no alias one? | |
x_objid_master | site | x_objid_master | What is the master objid for this alias? | |