| objid | frcst_target | objid | Forecast target internal record number | 3 (UNIQUE) |
| id | frcst_target | id_number | Forecast target Id | |
| name | frcst_target | name | Name of the forecast target | |
| start_date | frcst_target | start_date | Start date of the forecast target | |
| end_date | frcst_target | end_date | End date of the forecast target | |
| product_family | frcst_target | family | Product family of the forecast target | |
| product_line | frcst_target | line | Product line of the forecast target | |
| amount | frcst_target | amount | Amount of the forecast target | |
| comments | frcst_target | comments | Comments of the forecast target | |
| 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 | |
| curr_objid | currency | objid | Currency internal record number | |
| currency_name | currency | name | Name of the currency | |
| currency_symbol | currency | symbol | symbol of the currency | |
| currency_rate | currency | conv_rate | Rate of the currency to base 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 | |