| objid | frcst_itm | objid | Forecast item internal record number | 3 (UNIQUE) |
| user_objid | user | objid | User owner internal record number | |
| acct_objid | bus_org | objid | Account internal record number | |
| currency_objid | currency | objid | Currency internal record number | |
| terr_objid | territory | objid | Territory internal record number | |
| opp_objid | opportunity | objid | Opportunity internal record number | |
| id | frcst_itm | id_number | Application-controlled ID number of the forcast item | |
| name | frcst_itm | name | Name of the forecast item | |
| close_date | frcst_itm | close_date | Close date of the forecast item | |
| product_family | frcst_itm | family | Marketing product family the part belongs to | |
| product_line | frcst_itm | line | Product line forecasted | |
| amount | frcst_itm | amount | Currency amount forecasted | |
| probability | frcst_itm | probability | Probability that the forecasted amount will close | |
| comments | frcst_itm | comments | Comments about of the forecast item | |
| status | frcst_itm | status | Status of the forecast item | |
| terr_name | territory | name | Name of the territory | |
| terr_node_key | territory | node_key | Node Key of the territory | |
| opp_name | opportunity | name | Name of the related opportunity | |
| opp_id | opportunity | id | System generated D of the opportunity | |
| currency_name | currency | name | Name of the currency | |
| owner_name | user | login_name | Login name of the user | |
| acct_name | bus_org | name | Name of the forecasted account | |
| 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 | |