| View Name: | vw_con_fin_accnt |
| View Number: | 5716 |
| Group: | Billing Manager |
| Description: | Used by 712,767,768,769,771,772,773,774,16000,16005,16010,16012,16035,16155 |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| role_objid | con_fin_accnt_role | objid | Con_fin_accnt_role internal record number | 3 (UNIQUE) |
| con_objid | contact | objid | Contact internal record number | |
| fa_objid | fin_accnt | objid | Financial account 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_fin_accnt_role | role_name | Name of the role | |
| fa_name | fin_accnt | name | A name for the financial account, e.g., Monthly charges of sales division | |
| fa_ext_src | fin_accnt_extern | ext_src | The name of the system that manages the financial account (e.g., Ensemble, Kenan) | |
| fa_ext_ref | fin_accnt_extern | ext_ref | The identifier of the financial account from the external system | |
| fa_ext_objid | fin_accnt_extern | objid | Fin_accnt_extern internal record number |
| Join From | Join To |
|---|---|
| (con_fin_accnt_role).fin_accnt_role2fin_accnt | (fin_accnt).accnt2con_fin_accnt_role |
| (con_fin_accnt_role).con_accnt_role2contact | (contact).contact2con_fin_accnt_role |
| (fin_accnt_extern).fin_accnt_extern2fin_accnt | (fin_accnt).fin_accnt2fin_accnt_extern |
| vw_con_fin_accnt | |||