View Name:sitepart_address_vw
View Number:5745
Group:Billing Manager
Description:To locate the subscriber address given the exterenal reference. Used in Billing Integrator save beans
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_sitepart_address_vw
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidsite_partobjidSite_part internal record number 3 (UNIQUE)
site_part_ext_refsite_part_externext_refThe identifier of the customer from the external system 
site_objidsite_partsite_objidSite internal record number 
part_statussite_partpart_statusSite Configuration installed part status. This is a user-defined popup with default name PART_STATUS 
status_dtsite_partstatus_dtDate on which subscriber status changed 
address_objidaddressobjidAddress internal record number 
site_part_ext_objidsite_part_externobjidSite_part_ext internal record number 

Joins:

Join FromJoin To
(site_part_extern).site_part_extern2site_part(site_part).site_part2site_part_extern
(site_part).all_site_part2site(site).site2all_site_part
(site).cust_primaddr2address(address).primary_addr2site
My Recent Objects
sitepart_address_vw      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user