| View Name: | vw_bus_org_fin_accnt |
| View Number: | 5724 |
| 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,16115,16150,16180 |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| bus_org_objid | bus_org | objid | Bus_org internal record number | |
| fa_objid | fin_accnt | objid | Financial account internal record number | 3 (UNIQUE) |
| fa_name | fin_accnt | name | A name for the financial account, e.g., Monthly charges of sales division | |
| org_id | bus_org | org_id | User-specified ID number of the organization | |
| org_name | bus_org | name | Name of the organization | |
| fa_status | fin_accnt | status | Status of financial account, e.g. Active, Close | |
| 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 |
|---|---|
| (fin_accnt).fa_child2bus_org | (bus_org).child2fin_accnt |
| (fin_accnt_extern).fin_accnt_extern2fin_accnt | (fin_accnt).fin_accnt2fin_accnt_extern |
| vw_bus_org_fin_accnt | |||