View Name:bar_rel_prim_addr_v
View Number:5828
Group:Billing Manager
Description:To get primary address/site information for a billing arrangement. Used in ppb_create.jsp JSP page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
ba_objidblg_argmntobjidBlg_argment internal record number 3 (UNIQUE)
ba_nameblg_argmntnameName of billing arrangement 
site_objidsiteobjidSite internal record number 
site_namesitenameName of the site 
address_objidaddressobjidSite internal record number 
addressaddressaddressLine 1 of address which includes street number, street name, office, building, or suite number, etc 
address2addressaddress_2Line 2 of address which typically includes office, building, or suite number, etc 
cityaddresscityThe city for the specified address 
zipcodeaddresszipcodeThe zip or other postal code for the specified address 
state_prov_namestate_provnameState or province name 
state_prove_full_namestate_provfull_nameState or province full name 
state_prov_codestate_provcodeState or province code 
country_namecountrynameName of the specific country 
country_codecountrycodeCountry code used in telephone numbers for that country 
tz_nametime_zonenameTime zone name 
tz_full_nametime_zonefull_nameDetailed name/description of time zone 
site_idsitesite_idUnique site number assigned according to auto-numbering definition 
e_addr_objide_addrobjidE_addr internal record number 
e_nume_addre_numFull electonic address number; e.g., phone number including country code (if needed) and area code, email number, pager number. This is the addressable number 
typee_addre_typeType of electronic address; i.e., 0=reserved, 1=e-mail, 2=phone, 3=fax, 4-9999 (Reserved) 
bus_org_objidbus_orgobjidInternal record number for bus_org 
fa_objidfin_accntobjidFinancial account internal record number 

Joins:

Join FromJoin To
(blg_argmnt).primary_blg_argmnt2site(site).primary_site2blg_argmnt
(site).cust_primaddr2address(address).primary_addr2site
(address).address2state_provOUTER (state_prov).state_prov2address
(address).address2countryOUTER (country).country2address
(address).address2time_zoneOUTER (time_zone).time_zone2address
(blg_argmnt).primary_blg_argmnt2e_addrOUTER (e_addr).primary_e_addr2blg_argmnt
(blg_argmnt).ba_child2bus_orgOUTER (bus_org).child2blg_argmnt
(blg_argmnt).blg_argmnt2fin_accntOUTER (fin_accnt).fin_accnt2blg_argmnt
My Recent Objects
bar_rel_prim_addr_v