View Name: | vw_bus_org_blg_argmnt |
View Number: | 5726 |
Group: | Billing Manager |
Description: | Used by 11650,11651,11652,11653,11654,11656,11657,11658,11659,11660,11661,11662,11663,11664,147,11666,11667,11668,11669,11670,11671,16100,16110,16140,16150,16190 |
Flags: | VIEW_OPTIMIZED |
Baseline/Custom: | Baseline |
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
---|---|---|---|---|
bus_org_objid | bus_org | objid | Bus_org internal record number | |
ba_objid | blg_argmnt | objid | Billing arrangement internal record number | 3 (UNIQUE) |
ba_name | blg_argmnt | name | Name of billing arrangement | |
org_id | bus_org | org_id | User-specified ID number of the organization | |
org_name | bus_org | name | Name of the organization | |
ba_status | blg_argmnt | status | Status of billing arrangement, e.g. Active, Close | |
ba_ext_src | blg_argmnt_extern | ext_src | The name of the system that manages the Billing arrangement (e.g., Ensemble, Kenan) | |
ba_ext_ref | blg_argmnt_extern | ext_ref | The identifier of the billing arrangement from the external system | |
ba_ext_objid | blg_argmnt_extern | objid | blg_argmnt_extern internal record number |
Join From | Join To |
---|---|
(blg_argmnt).ba_child2bus_org | (bus_org).child2blg_argmnt |
(blg_argmnt_extern).blg_argmnt_extern2blg_argmnt | (blg_argmnt).blg_argmnt2blg_argmnt_extern |
vw_bus_org_blg_argmnt | |||