| objid | opportunity | objid | Opportunity internal record number | 3 (UNIQUE) |
| terr_objid | territory | objid | Territory internal record number | |
| leadsrc_objid | lead_source | objid | Lead_source internal record number | |
| cycle_objid | life_cycle | objid | Life_cycle internal record number | |
| currency_objid | currency | objid | Currency internal record number | |
| opp_name | opportunity | name | Name of the opportunity | |
| opp_id | opportunity | id | Unique ID number of the opportunity | |
| terr_name | territory | name | Name of the territory | |
| terr_id | territory | terr_id | Unique ID number of the territory | |
| source_name | lead_source | name | Name of the lead source | |
| source_id | lead_source | id | Unique ID of the lead source | |
| cycle_name | life_cycle | name | Name of the sales process | |
| currency_name | currency | name | Currency in which the opportunity is denominated | |
| 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 | |
| stage_objid | cycle_stage | objid | Cycle_stage internal record number | |
| stage_name | cycle_stage | name | Name of the Sales Stage | |