| Table Name: | frcst_itm |
| Table Number: | 5009 |
| Group: | Sales Mgr |
| Description: | Sales forecast detail 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 | Currency amount forecasted | Search (3) | |||
| arch_ind | LONG | int | DIRECT, ALLOW_NULL | When set to 1, indicates the object is ready for purge/archive | ||||
| close_date | CLK_TIME | datetime | Close date for this forecast item (from opportunity or manual) | Search (3) | ||||
| comments | CHAR | varchar | 255 | Comments about the item | Search (3) | |||
| conf_amt | LONG | tinyint | DIRECT | Reserved; not used | ||||
| conf_cls | LONG | tinyint | DIRECT | Reserved; not used | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| discount | FLOAT | real | CURRENCY | Discount to subtract from the forecast item | ||||
| eff_date | CLK_TIME | datetime | 1 | Reserved; not used | ||||
| family | CHAR | varchar | 40 | Marketing product family the part belongs to. This is a user-defined pop up with defaul name FAMILY and level lev1 | Search (3) | |||
| id_number | CHAR | varchar | 32 | Application-controlled ID number of the item | Search (3) | |||
| line | CHAR | varchar | 40 | Product line forecasted. This is from a user-defined popup list with default name FAMILY and level All Products | Search (3) | |||
| name | CHAR | varchar | 2 | 80 | Name of the forecast item | Search (3) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (3) | ||
| probability | FLOAT | real | Probability that the forecasted amount will close | Search (3) | ||||
| quantity | LONG | int | DIRECT | Quantity forecasted | ||||
| split_percent | FLOAT | real | The percentage of the commision split to be applied | |||||
| status | CHAR | varchar | 40 | Status of the forecast item. This is a user-defined popup with default name Forecast Item Commitment | Search (3) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| item2bus_org | MTO | bus_org | bus_org2frcst_itm | Account forecasted. Reserved; future | Search (1) | ||
| frcst_itm2currency | MTO | currency | curr2frcst_itm | Currency in which the forecast item is denominated | Search (3) | ||
| item2opportunity | MTO | opportunity | opp2frcst_itm | The opportunity forecasted | Search (3) | ||
| frcst_itm2territory | MTO | territory | terr2frcst_itm | The territory forecasted | Search (3) | ||
| originator2user | MTO | user | originator2frcst_itm | User who originated the forecast item. Reserved | Search (3) | ||
| itm_owner2usr_ter_role | MTO | usr_ter_role | owner2frcst_itm | User (in territory role) who forecasted the item. Reserved; future |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_close_date | close_date | nonclustered located on PRIMARY |
| ind_frcst_itm2territory | frcst_itm2territory, close_date | nonclustered located on PRIMARY |
| ind_item2opportunity | item2opportunity, close_date | nonclustered located on PRIMARY |
| ind_probability | probability, close_date | nonclustered located on PRIMARY |
| o2u5009 | originator2user | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5159 | frcstitem_view | currency, frcst_itm, opportunity, territory, user |
| 5189 | v_frcstitem | currency, frcst_itm, opportunity, territory, user |
| 5344 | sfa_frcst_v | bus_org, currency, frcst_itm, opportunity, territory, user |
| frcst_itm | |||