| opp_objid | opportunity | objid | Opportunity internal record number | 3 (UNIQUE) |
| id | opportunity | id | Opportunity ID number | |
| owner_objid | user | objid | Internal record number of the opportunity owner | |
| stage | cycle_stage | name | Status/Stage of opportunity | |
| name | opportunity | name | Name of the opportunity | |
| frcst_cls_dt | opportunity | frcst_cls_dt | Forecasted close date of the opportunity | |
| purch_date | opportunity | purch_date | Purchase date from the opportunity | |
| frcst_cls_amt | opportunity | frcst_cls_amount | Forecasted close currency amount from the opportunity | |
| currency_objid | currency | objid | Internal record number of the currency the opporutnity is denominated in | |
| currency | currency | name | Name of the currency the opporutnity is denominated in | |
| login_name | user | login_name | User login name | |
| frcst_cls_prb | opportunity | frcst_cls_prb | Forecasted close probability from the opportunity | |
| condition | condition | title | Condition/state of the opportunity | |
| cond_objid | condition | objid | Internal record number of condition | |