| objid | frcst_target | objid | Forecast target internal record number | 3 (UNIQUE) |
| id | frcst_target | id_number | Forecast target Id | |
| name | frcst_target | name | Name assigned to the forecast target | |
| start_date | frcst_target | start_date | Beginning date of the period for the target | |
| end_date | frcst_target | end_date | Last date of the period for the target | |
| product_family | frcst_target | family | Marketing product family the part belongs to. This is from a user-defined popup with default name FAMILY and level name lev1 | |
| product_line | frcst_target | line | If target is assigned to a product, the marketing product line, within family, of the part; new user-defined pop up with default name FAMILY and level name Hardware Line | |
| amount | frcst_target | amount | Target currency amount | |
| comments | frcst_target | comments | Comments about the forecast target | |
| terr_objid | territory | objid | Territory internal record number | |
| terr_name | territory | name | Name of the sales territory | |
| terr_node_key | territory | node_key | Node Key of the territory | |
| curr_objid | currency | objid | Currency internal record number | |
| currency_name | currency | name | Name of the currency | |
| currency_symbol | currency | symbol | Symbol of the currency | |
| owner_objid | user | objid | User owner 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 | |
| acct_name | bus_org | name | If the forecast target is account based, the account name | |
| acct_objid | bus_org | objid | Bus_org internal record number | |
| status | gbst_status(gbst_elm) | title | Status of forecast target | |
| status_objid | gbst_status(gbst_elm) | objid | Status gbst_elm internal record number | |
| 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 | |