| View Name: | vw_con_blg_argmnt |
| View Number: | 5717 |
| Group: | Billing Manager |
| Description: | Used by 712,767,768,769,771,772,773,774,16000,16005,16010,16012,16025,16160 |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| role_objid | con_blg_argmnt_role | objid | con_blg_argmnt_role internal record number | 3 (UNIQUE) |
| con_objid | contact | objid | Contact internal record number | |
| ba_objid | blg_argmnt | objid | Billing arrangement 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_blg_argmnt_role | role_name | Name of the role | |
| ba_name | blg_argmnt | name | Name of billing arrangement | |
| 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 |
|---|---|
| (con_blg_argmnt_role).ba_role2blg_argmnt | (blg_argmnt).ba2con_blg_argmnt_role |
| (con_blg_argmnt_role).con_role2contact | (contact).contact2con_blg_argmnt_role |
| (blg_argmnt_extern).blg_argmnt_extern2blg_argmnt | (blg_argmnt).blg_argmnt2blg_argmnt_extern |
| vw_con_blg_argmnt | |||