View Name: | vw_bus_org_pay_chnl |
View Number: | 5730 |
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,16145,16150,16185 |
Flags: | VIEW_OPTIMIZED |
Baseline/Custom: | Baseline |
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
---|---|---|---|---|
pc_objid | pay_channel | objid | Pay channel internal record number | 3 (UNIQUE) |
bus_org_objid | bus_org | objid | Bus_org internal record number | |
pc_name | pay_channel | 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 | |
pc_status | pay_channel | status | Status of pay channel, e.g. Active, Close | |
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 |
---|---|
(pay_channel).pc_child2bus_org | (bus_org).child2pay_channel |
(pay_chnl_extern).pay_chnl_extern2pay_channel | (pay_channel).pay_channel2pay_chnl_extern |
vw_bus_org_pay_chnl | |||