| objid | opportunity | objid | Opportunity internal record number | 3 (UNIQUE) |
| id | opportunity | id | Opportunity ID number | |
| name | opportunity | name | Name given to the opportunity | |
| frcst_cls_dt | opportunity | frcst_cls_dt | Forecasted close date | |
| purch_date | opportunity | purch_date | When the opportunity is expected to close | |
| frcst_cls_amt | opportunity | frcst_cls_amount | Forecasted close amount | |
| frcst_cls_prb | opportunity | frcst_cls_prb | Forecasted close probability | |
| stage | cycle_stage | name | Name of the stage | |
| process_name | life_cycle | name | Name of the life cycle | |
| source_name | lead_source | name | Name of the lead source | |
| terr_name | territory | name | Name of the territory | |
| currency | currency | name | Name of the currency | |
| curr_objid | currency | objid | currency internal record number | |
| lead_source_objid | lead_source | objid | Lead_source internal record number | |
| territory_objid | territory | objid | Territory internal record number | |
| life_cycle_objid | life_cycle | objid | Life_cycle internal record number | |
| cycle_stage_objid | cycle_stage | objid | Cycle_stage internal record number | |