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; i.e., 1=BUSINESS, 2=OFFICE, 3=RESELLER, 4=INDIVIDUAL, 5=VENDOR | |
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 | |