| View Name: | vw_blg_argmnt_pay_chnl |
| View Number: | 5722 |
| Group: | Billing Manager |
| Description: | Used by 11650,11651,11652,11653,11654,11656,11657,11658,11659,11660,11661,11662,11663,11664,11665,11666,11667,11668,11669,11670,11671,16100,16110,16150 |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| role_objid | ba_pc_role | objid | Ba_pc_role internal record number | 3 (UNIQUE) |
| ba_objid | blg_argmnt | objid | Billing arrangement internal record number | |
| ba_name | blg_argmnt | name | Name of billing arrangement | |
| pc_objid | pay_channel | objid | Pay Channel internal record number | |
| pc_name | pay_channel | name | Name given to the pay channel, e.g. Personal, Business, Voice, Data etc | |
| role_name | ba_pc_role | role_name | Name of the role | |
| 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 | |
| pc_ext_src | pay_chnl_extern | ext_src | The name of the system that manages the Pay channel (e.g., Ensemble, Kenan) | |
| pc_ext_ref | pay_chnl_extern | ext_ref | The identifier of the pay channel from the external system | |
| pc_ext_objid | pay_chnl_extern | objid | Pay_chnl_extern internal record number |
| Join From | Join To |
|---|---|
| (ba_pc_role).ba_pc_role2blg_argmnt | (blg_argmnt).blg_argmnt2ba_pc_role |
| (ba_pc_role).ba_pc_role2pay_channel | (pay_channel).pay_channel2ba_pc_role |
| (blg_argmnt_extern).blg_argmnt_extern2blg_argmnt | (blg_argmnt).blg_argmnt2blg_argmnt_extern |
| (pay_chnl_extern).pay_chnl_extern2pay_channel | (pay_channel).pay_channel2pay_chnl_extern |
| vw_blg_argmnt_pay_chnl | |||