View Name:busorg_site_addr_vw
View Number:5713
Group:Customer Mgr
Description:Used for locating sites and addresses of a customer node. Used in Billing Integrator save beans
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidsiteobjidSite internal record number 3 (UNIQUE)
address_objidaddressobjidAddress internal record number 
country_objidcountryobjidCountry internal record number 
state_prov_objidstate_provobjidState internal record number 
bus_org_objidbus_orgobjidBus Org internal record number 
ext_ref_objidbus_org_externobjidBus Org extern internal record number 
ext_refbus_org_externext_refBus Org extern reference id 
statussitestatusStatus of site; i.e., active, inactive, obsolete 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
site_namesitenameName of the site 
addressaddressaddressLine 1 of address which includes street number, street name, office, building, or suite number, etc 
address_2addressaddress_2Line 2 of address which typically includes office, building, or suite number, etc 
cityaddresscityThe city for the specified address 
statenamestate_provnameState or province name 
state_fullnamestate_provfull_nameState or province full name 
zipcodeaddresszipcodeThe zip or other postal code for the specified address 

Joins:

Join FromJoin To
(bus_org_extern).bus_org_extern2bus_org(bus_org).bus_org2bus_org_extern
(site).primary2bus_org(bus_org).primary_org2site
(site).cust_primaddr2address(address).primary_addr2site
(address).address2state_prov(state_prov).state_prov2address
(address).address2countryOUTER (country).country2address
My Recent Objects
busorg_site_addr_vw