objid | bus_site_role | objid | Bus_site_role internal record number | 3 (UNIQUE) |
role_name | bus_site_role | role_name | The name of the role | |
acct_objid | bus_org | objid | Bus_org internal record number | |
acct_name | bus_org | name | Name of the account | |
acct_org_id | bus_org | org_id | User-specified ID number of the account | |
acct_phone | bus_org | phone | Main phone number of the account | |
acct_web_site | bus_org | web_site | The URL of the main web page of the account | |
acct_size_empl | bus_org | size_empl | Estimated number of employees in the account | |
acct_type | bus_org | type | Business type; e.g., competitor, prospect, customer. This is a user-defined pop up with default name Company Type | |
acct_revn_range | bus_org | revn_range | Revenue range of the account. This is a user-defined popup with default name Company Revenue | |
acct_fax | bus_org | fax | Main fax number of the account | |
acct_stock_sym | bus_org | stock_sym | Stock symbol of the account | |
acct_status | bus_org | status | Status of account; i.e., 0=active, 1=inactive, 2=obsolete, default=0 | |
acct_business_desc | bus_org | business_desc | Describes the purpose of the account or the business it is in | |
site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
site_name | site | name | Name of the site | |
site_type | site | type | Site type; i.e., 1=CUST, 2=INTR, 3=RSEL, 4=INDV | |
address | address | address | Primary address of the site | |
city | address | city | City where the site is located | |
state | address | state | State where the site is located | |
country_code | country | code | Country code of the country where the site is located | |
site_typest | site | site_type | Mnemonic representation of the integer site type field | |
status | site | status | Status of site; i.e., active, inactive, obsolete | |
site_status | site | site_id | Used for display of site status. Must be replaced with active/inactive/obsolete in display | |
site_objid | site | objid | Site internal record number | |
address_objid | address | objid | Address internal record number | |
country_objid | country | objid | Country internal record number | |
country | country | name | Name of the country | |
zipcode | address | zipcode | The zip or other postal code for the specified address | |
address_2 | address | address_2 | Line 2 of address which typically includes office, building, or suite number, etc | |