| agr_bus_objid | fr_agr_bus_role | objid | Fr_agr_bus_role internal record number | 3 (UNIQUE) |
| objid | fr_agrmnt | objid | Framework agreement internal record number | |
| id | fr_agrmnt | id | Id. Populated by numbering scheme | |
| is_template | fr_agrmnt | is_template | Indicate that framework agreement is a template to be used to create other framework agreements.1=template, 0=framework agreement. Default=0 | |
| title | fr_agrmnt | title | Title | |
| pool_id | fr_agrmnt | pool_id | Resource pool reference | |
| effective_date | fr_agrmnt | start_date | Start date | |
| expiry_date | fr_agrmnt | end_date | End date | |
| status | fr_agrmnt | status | User defined status. Populated through a user defined popup list | |
| acct_id | bus_org | objid | Account internal record number | |
| owner | user | login_name | Owner | |
| user_objid | user | objid | User internal record number | |
| is_prm_acct | fr_agr_bus_role | is_primary | Indicates primary bus_org for agreement. 1=is primary bus_org, 0=non primary bus_org; Default=0 | |
| limit_offerings | fr_agrmnt | limit_offerings | Indicates that offerings should be limited to only those associated to the Framework Agreement. 0=Unlimited offering, 1=limited to those related to framework agreement. Default=0 | |
| acct_name | bus_org | name | Name of the organization | |