| Table Name: | frcst_target |
| Table Number: | 5191 |
| Group: | Sales Mgr |
| Description: | Sales forecast target or quota object |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| amount | DECIMAL | decimal (19,4) | CURRENCY | Target currency amount | Search (2) | |||
| arch_ind | LONG | int | DIRECT, ALLOW_NULL | When set to 1, indicates the object is ready for purge/archive | ||||
| comments | CHAR | varchar | 255 | Comments about the forecast target | Search (2) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| end_date | CLK_TIME | datetime | Last date of the period for the target | Search (2) | ||||
| family | CHAR | varchar | 40 | Marketing product family the part belongs to. This is from a user-defined popup with default name FAMILY and level name lev1 | Search (2) | |||
| id_number | CHAR | varchar | 32 | System-generated ID number of the forecast target | Search (2) | |||
| line | CHAR | varchar | 40 | 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 | Search (2) | |||
| name | CHAR | varchar | 2 | 80 | Name assigned to the target | Search (2) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) | ||
| start_date | CLK_TIME | datetime | Beginning date of the period for the target | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| frcst2bus_org | MTO | bus_org | bus_org2frcst_target | Related account. Reserved; future | Search (1) | ||
| frcst_target2currency | MTO | currency | currency2frcst_target | Currency in which the frcst_target is denominated | Search (2) | ||
| frcst_target2frcst_grp | MTO | frcst_grp | group2frcst_target | Related sales forecast groups. Reserved; not used | |||
| frcst_stat2gbst_elm | MTO | gbst_elm | status2frcst_target | Status of forecast target. Reserved; future | Search (1) | ||
| frcst2territory | MTO | territory | terr2frcst_target | Related territory. Reserved | Search (2) | ||
| frcst_target2user | MTO | user | user2frcst_target | Person having the forecast target. Reserved | Search (2) | ||
| trgt_owner2usr_ter_role | MTO | usr_ter_role | owner2frcst_target | User's territory role assigned the quota. Reserved; future |
| Index Name | Fields | Flags |
|---|---|---|
| name_ind | name | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| f2t5191 | frcst2territory, start_date, end_date, frcst_target2user, frcst_target2currency | nonclustered located on PRIMARY |
| name_ind | name | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5158 | frtrgt_view | currency, frcst_target, territory, user |
| 5347 | sfa_target | bus_org, currency, frcst_target, gbst_elm, territory, user |
| frcst_target | |||