1.Functional Description
1.1Purpose
This function will validate that the summary key postions set up for the forecast summary constants
are unique and do not skip values.
1.2Setup Notes and Prerequisites
1.3Special Logic
2.Technical Specifications
1.Will need to convert the Customer Level to a numeric if it is not blank and include it in the
key position values in order.
2.Validate that the values entered in the key positions do not have any duplicates.
If a value is duplicated set on error '3007' and highlight the key that is the duplicate.
3.Validate that no value is skipped in the setup (ie. if there is a 1, 2 and 5 there must be a 3
and 4)
If a value is skipped set on error '3750' and highlight the first value that is out of sequence
(ie in the above example you would highlight the 5).
4.If sequence value 11 is entered and Customer Level is not selected as a key set on error
'023H'.
^
D3400950 - Validate Summary Key
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| mnKeyPosition1 | KC01 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific category code should be. | ||||
| mnKeyPosition2 | KC02 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition3 | KC03 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition4 | KC04 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition5 | KC05 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition6 | KC06 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition7 | KC07 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition8 | KC08 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition9 | KC09 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition10 | KC10 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition11 | KC11 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition12 | KC12 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition13 | KC13 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition14 | KC14 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition15 | KC15 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition16 | KC16 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition17 | KC17 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition18 | KC18 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition19 | KC19 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition20 | KC20 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition21 | KC21 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition22 | KC22 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition23 | KC23 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition24 | KC24 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition25 | KC25 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition26 | KC26 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition27 | KC27 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition28 | KC28 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition29 | KC29 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition30 | KC30 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition31 | KC31 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition32 | KC32 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition33 | KC33 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition34 | KC34 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition35 | KC35 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition36 | KC36 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition37 | KC37 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition38 | KC38 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition39 | KC39 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| mnKeyPosition40 | KC40 | MATH_NUMERIC | NONE | NONE |
An indicator that specifies which level in the forecasting hierarchy a specific Category Code should be. | ||||
| szCustomerLevel | CSLV | char | NONE | NONE |
A code that indicates the customer number as one of the levels in the forecasting hierarchy. | ||||
| None |
| None |