| View Name: | vw_con_pay_chnl |
| View Number: | 5718 |
| Group: | Billing Manager |
| Description: | Used by 712,767,768,769,771,772,773,774,16000,16005,16010,16012,16020,16175 |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| role_objid | con_pc_role | objid | con_pc_role internal record number | 3 (UNIQUE) |
| con_objid | contact | objid | Contact internal record number | |
| pc_objid | pay_channel | objid | Pay Channel internal record number | |
| con_first_name | contact | first_name | Contact's first name | |
| con_last_name | contact | last_name | Contact's last name | |
| con_phone | contact | phone | Contact's phone number which includes area code, number, and extension | |
| role_name | con_pc_role | role_name | Name of the role | |
| pc_name | pay_channel | name | Name given to the pay channel, e.g. Personal, Business, Voice, Data etc | |
| 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 |
|---|---|
| (con_pc_role).con_pc_role2contact | (contact).contact2con_pc_role |
| (con_pc_role).con_pc_role2pay_channel | (pay_channel).pay_channel2con_pc_role |
| (pay_chnl_extern).pay_chnl_extern2pay_channel | (pay_channel).pay_channel2pay_chnl_extern |
| vw_con_pay_chnl | |||