View Name: | busorg_bussite_vw |
View Number: | 5743 |
Group: | Billing Manager |
Description: | To locate a specific role_name in bus_site_role for an external reference. Used in Billing Integrator save beans |
Flags: | VIEW_OPTIMIZED |
Baseline/Custom: | Baseline |
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
---|---|---|---|---|
objid | bus_site_role | objid | Bus_site_role internal record number | 3 (UNIQUE) |
busorg_ext_ref | bus_org_extern | ext_ref | The identifier of the customer from the external system | |
busorg_objid | bus_org | objid | Bus_org internal record number | |
site_objid | site | objid | Site internal record number | |
role_name | bus_site_role | role_name | Name of the role | |
bus_org_ext_objid | bus_org_extern | objid | Bus_org_ext internal record number |
Join From | Join To |
---|---|
(bus_org_extern).bus_org_extern2bus_org | (bus_org).bus_org2bus_org_extern |
(bus_site_role).bus_site_role2bus_org | (bus_org).bus_org2bus_site_role |
(bus_site_role).bus_site_role2site | (site).site2bus_site_role |
busorg_bussite_vw | |||