objid | child(site) | objid | Child site internal record number | 3 (UNIQUE) |
site_id | child(site) | site_id | Child site ID number assigned according to auto-numbering definition | |
parent_objid | parent(site) | objid | Parent site internal record number | |
site_name | child(site) | name | Name of the child site | |
site_type | child(site) | type | Type of the child site; i.e., 1=BUSINESS, 2=OFFICE, 3=RESELLER, 4=INDIVIDUAL, 5=VENDOR | |
address | address | address | Child site primary address | |
city | address | city | Child site's city | |
state | address | state | Child site's state | |
country_code | country | code | Child site's country code | |
site_typest | child(site) | site_type | Child site's type string; i.e., mnemonic representation of the integer site type field | |
status | child(site) | status | Status of child site; i.e., active, inactive, obsolete | |
bus_org_objid | bus_org | objid | Child site's owning bus_org internal record number | |
org_id | bus_org | org_id | Child site's owning account's ID number | |
org_name | bus_org | name | Child site's owning account's name | |
org_type | bus_org | type | Child site's owning Business type; e.g., competitor, prospect, customer, etc., from a user-defined pop up | |
country_name | country | name | Name of the child site's country | |
zipcode | address | zipcode | Child site's zipcode | |
country_objid | country | objid | Child sit'e country internal record number | |
address_objid | address | objid | Child sit'e address internal record number | |
region | child(site) | region | Region to which the child site belongs | |
district | child(site) | district | District to which the child site belongs | |
address_2 | address | address_2 | Line 2 of child site's address which typically includes office, building, or suite number, etc | |