| View Name: | agr_bus_v |
| View Number: | 5786 |
| Group: | Morder |
| Description: | Uses for retrieve data of additional agreement accounts for Accounts Tab of screen Agreement Details. Used in morder\agreement\agreement_accounts.jsp JSP page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| acc_role_objid | fr_agr_bus_role | objid | Role internal record number | 3 (UNIQUE) |
| objid | fr_agrmnt | objid | Framework agreement internal record number | |
| acc_objid | bus_org | objid | Account internal record number | |
| name | bus_org | name | Account name | |
| acct_id | bus_org | org_id | Account ID number | |
| role_name | fr_agr_bus_role | role_name | Role name accounts and framework agreements play for one another | |
| is_primary | fr_agr_bus_role | is_primary | Indicates primary bus_org for agreement. 1=is primary bus_org, 0=non primary bus_org; Default=0 |
| Join From | Join To |
|---|---|
| (fr_agr_bus_role).fr_agr_bus_role2fr_agrmnt | (fr_agrmnt).fr_agrmnt2fr_agr_bus_role |
| (fr_agr_bus_role).fr_agr_bus_role2bus_org | (bus_org).bus_org2fr_agr_bus_role |
| agr_bus_v | |||