| objid | bus_opp_role | objid | Bus_opp_role internal record nubmer | 3 (UNIQUE) |
| bus_objid | bus_org | objid | Bus_org internal record number | |
| opp_objid | opportunity | objid | Opportunity internal record number | |
| owner_objid | user | objid | Opportunity owner internal record number | |
| stage_objid | cycle_stage | objid | Opportunity stage internal record number | |
| curr_objid | currency | objid | Opportunity currency internal record number | |
| role_name | bus_opp_role | role_name | Name of the business organization's role for the opportunity | |
| bus_name | bus_org | name | Business organization's name | |
| active | bus_opp_role | active | Indicates whether the role is active; i.e., 0=inactive, 1=active | |
| role_type | bus_opp_role | role_type | Type of role for the opportunity; i.e., 0=partner, 1=competitor | |
| comments | bus_opp_role | comments | Comments about the role | |
| focus_type | bus_opp_role | focus_type | Object type ID of the role-player; i.e., 173=an business organizations's role, 5000=an opportunity's role | |
| products | bus_opp_role | products | Products this bus_org is trying to sell in this opportunity | |
| close_date | bus_opp_role | close_date | Attempted close date for the opportunity by the bus_org | |
| amount | bus_opp_role | amount | Currenty amount the bus_org is trying to close in this opportunity | |
| drop_date | bus_opp_role | drop_date | Date on which the bus_org dropped out of the opportunity | |
| drop_reason | bus_opp_role | drop_reason | Reason the bus_org left the opportunity | |
| opp_name | opportunity | name | Name given to the opportunity | |
| opp_id | opportunity | id | Opportunity ID number | |
| frcst_cls_dt | opportunity | frcst_cls_dt | Forecasted close date of the opportunity | |
| frcst_cls_amt | opportunity | frcst_cls_amount | Forecasted close amount of the opportunity | |
| frcst_cls_prb | opportunity | frcst_cls_prb | Forecasted close probability of the opportunity | |
| stage | cycle_stage | name | Status/Stage of opportunity | |
| owner | user | login_name | User login name of the opportunity owner | |
| currency | currency | name | Name of the currency the opporutnity is denominated in | |
| sub_scale | currency | sub_scale | Gives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0 | |