| objid | con_opp_role | objid | Con_opp_role internal record number | 3 (UNIQUE) |
| con_objid | contact | objid | Contact internal record number | |
| opp_objid | opportunity | objid | Opportunity internal record number | |
| first_name | contact | first_name | Contact first name | 15 |
| last_name | contact | last_name | Contact last name | 14 |
| phone | contact | phone | Contact phone number which includes area code, number, and extension | |
| role_name | con_opp_role | role_name | Name of the role. This is a user-defined popup with defaul name Roles In The Buying | |
| focus_type | con_opp_role | focus_type | Object type ID of the role-player; i.e., 45=a contact's role, 5000=an opportunity's role | |
| active | con_opp_role | active | Indicates whether the role is active; i.e., 0=inactive, 1=active | |
| id | opportunity | id | Opportunity ID number | |
| objective | opportunity | objective | Sales objective for this opportunity | |
| name | opportunity | name | Name given to the opportunity | |
| proj_name | opportunity | proj_name | Customer's project name for the opportunity | |
| purch_date | opportunity | purch_date | When the opportunity is expected to close | |
| comments | con_opp_role | comments | Comments about the role | |
| orientation | con_opp_role | orientation | Decision orientation is a function of style, not job function. This is a user-defined popup with default name Decision Orientation | |
| time_spent | con_opp_role | time_spent | Indicates the time spent with the person. This is from a user-defined popup with default name Time Spent | |
| your_status | con_opp_role | your_status | Indicates the status of the Sales Rep with this person. This is a user-defined popup with default name Your Status | |
| con_title | contact | title | Contact's title | |
| 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 | |
| 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 opportunity 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 | |