| objid | frcst_itm | objid | Forecast item internal record number | 3 (UNIQUE) |
| id | frcst_itm | id_number | Forecast item ID | |
| name | frcst_itm | name | Name of the forecast target | |
| close_date | frcst_itm | close_date | Close date of the forecast target | |
| product_family | frcst_itm | family | Product family of the forecast item | |
| product_line | frcst_itm | line | Product line of the forecast item | |
| amount | frcst_itm | amount | Amount of the forecast item | |
| probability | frcst_itm | probability | Probability of the forecast item | |
| comments | frcst_itm | comments | Comments of the forecast item | |
| status | frcst_itm | status | Status of the forecast item | |
| terr_objid | territory | objid | Territory internal record number | |
| terr_name | territory | name | Name of the territory | |
| terr_nodeKey | territory | node_key | Node Key of the territory | |
| opp_objid | opportunity | objid | Opportunity internal record number | |
| opp_name | opportunity | name | Name of the opportunity | |
| opp_id | opportunity | id | Id of the opportunity | |
| currency_objid | currency | objid | Currency internal record number | |
| currency_name | currency | name | Name of the currency | |
| currency_rate | currency | conv_rate | Ratio of the currency | |
| owner_objid | user | objid | User internal record number | |
| owner_name | user | login_name | Name of the user | |
| terr_terr_id | territory | terr_id | User-specified ID number of the territory | |
| 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 | |