MP2 Projected Demands (MP2_ProjectedDemands) Level: 4.40 Record Type: 1 Projected Demands Monthly 08/28/2009 File Type: Direct Key Size: 55 Rec Len: 1371 Min Len: 121 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase *(1,30) Warehouse Number. . . . . . . . . . . . WarehouseNumber . . . . . . . Account *(31,3) Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(34,2) Customer Number . . . . . . . . . . . . CustomerNumber. . . . . . . . Account *(36,20) Projection Type ("M") . . . . . . . . . ProjectionType. . . . . . . . Uppercase (56,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (57,65) January Forecast This Year. . . . . . . ForecastJanuary . . . . . . . Number [0] 6.3 February Forecast This Year . . . . . . ForecastFebruary. . . . . . . Number [1] 6.3 March Forecast This Year. . . . . . . . ForecastMarch . . . . . . . . Number [2] 6.3 April Forecast This Year. . . . . . . . ForecastApril . . . . . . . . Number [3] 6.3 May Forecast This Year. . . . . . . . . ForecastMay . . . . . . . . . Number [4] 6.3 June Forecast This Year . . . . . . . . ForecastJune. . . . . . . . . Number [5] 6.3 July Forecast This Year . . . . . . . . ForecastJuly. . . . . . . . . Number [6] 6.3 August Forecast This Year . . . . . . . ForecastAugust. . . . . . . . Number [7] 6.3 September Forecast This Year. . . . . . ForecastSeptember . . . . . . Number [8] 6.3 October Forecast This Year. . . . . . . ForecastOctober . . . . . . . Number [9] 6.3 November Forecast This Year . . . . . . ForecastNovember. . . . . . . Number [10] 6.3 December Forecast This Year . . . . . . ForecastDecember. . . . . . . Number [11] 6.3 January Forecast Next Year. . . . . . . ForecastJanuaryNextYear . . . Number [12] 6.3 February Forecast Next Year . . . . . . ForecastFebruaryNextYear. . . Number [13] 6.3 March Forecast Next Year. . . . . . . . ForecastMarchNextYear . . . . Number [14] 6.3 April Forecast Next Year. . . . . . . . ForecastAprilNextYear . . . . Number [15] 6.3 May Forecast Next Year. . . . . . . . . ForecastMayNextYear . . . . . Number [16] 6.3 June Forecast Next Year . . . . . . . . ForecastJuneNextYear. . . . . Number [17] 6.3 July Forecast Next Year . . . . . . . . ForecastJulyNextYear. . . . . Number [18] 6.3 August Forecast Next Year . . . . . . . ForecastAugustNextYear. . . . Number [19] 6.3 September Forecast Next Year. . . . . . ForecastSeptemberNextYear . . Number [20] 6.3 October Forecast Next Year. . . . . . . ForecastOctoberNextYear . . . Number [21] 6.3 November Forecast Next Year . . . . . . ForecastNovemberNextYear. . . Number [22] 6.3 December Forecast Next Year . . . . . . ForecastDecemberNextYear. . . Number [23] 6.3 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [24] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [25] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [26] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [27] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [28] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [29] 0. Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [30] 0. Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [31] 0. Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [32] 0. Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [33] 0. Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [34] 0. Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [35] 0. Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [36] 0. Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [37] 0. Open Number . . . . . . . . . . . . . . _N15. . . . . . . . . . . . . Open Number [38] 0. Open Number . . . . . . . . . . . . . . _N16. . . . . . . . . . . . . Open Number [39] 0. Open Number . . . . . . . . . . . . . . _N17. . . . . . . . . . . . . Open Number [40] 0. Open Number . . . . . . . . . . . . . . _N18. . . . . . . . . . . . . Open Number [41] 0. Open Number . . . . . . . . . . . . . . _N19. . . . . . . . . . . . . Open Number [42] 0. Open Number . . . . . . . . . . . . . . _N20. . . . . . . . . . . . . Open Number [43] 0. Open Number . . . . . . . . . . . . . . _N21. . . . . . . . . . . . . Open Number [44] 0. Open Number . . . . . . . . . . . . . . _N22. . . . . . . . . . . . . Open Number [45] 0. Open Number . . . . . . . . . . . . . . _N23. . . . . . . . . . . . . Open Number [46] 0. Open Number . . . . . . . . . . . . . . _N24. . . . . . . . . . . . . Open Number [47] 0. Open Number . . . . . . . . . . . . . . _N25. . . . . . . . . . . . . Open Number [48] 0. Open Number . . . . . . . . . . . . . . _N26. . . . . . . . . . . . . Open Number [49] 0. Open Number . . . . . . . . . . . . . . _N27. . . . . . . . . . . . . Open Number [50] 0. Open Number . . . . . . . . . . . . . . _N28. . . . . . . . . . . . . Open Number [51] 0. Open Number . . . . . . . . . . . . . . _N29. . . . . . . . . . . . . Open Number [52] 0. Open Number . . . . . . . . . . . . . . _N30. . . . . . . . . . . . . Open Number [53] 0. Open Number . . . . . . . . . . . . . . _N31. . . . . . . . . . . . . Open Number [54] 0. Open Number . . . . . . . . . . . . . . _N32. . . . . . . . . . . . . Open Number [55] 0. Open Number . . . . . . . . . . . . . . _N33. . . . . . . . . . . . . Open Number [56] 0. Open Number . . . . . . . . . . . . . . _N34. . . . . . . . . . . . . Open Number [57] 0. Open Number . . . . . . . . . . . . . . _N35. . . . . . . . . . . . . Open Number [58] 0. Open Number . . . . . . . . . . . . . . _N36. . . . . . . . . . . . . Open Number [59] 0. Open Number . . . . . . . . . . . . . . _N37. . . . . . . . . . . . . Open Number [60] 0. Open Number . . . . . . . . . . . . . . _N38. . . . . . . . . . . . . Open Number [61] 0. Open Number . . . . . . . . . . . . . . _N39. . . . . . . . . . . . . Open Number [62] 0. Open Number . . . . . . . . . . . . . . _N40. . . . . . . . . . . . . Open Number [63] 0. Open Number . . . . . . . . . . . . . . _N41. . . . . . . . . . . . . Open Number [64] 0. Open Number . . . . . . . . . . . . . . _N42. . . . . . . . . . . . . Open Number [65] 0. Open Number . . . . . . . . . . . . . . _N43. . . . . . . . . . . . . Open Number [66] 0. Open Number . . . . . . . . . . . . . . _N44. . . . . . . . . . . . . Open Number [67] 0. Open Number . . . . . . . . . . . . . . _N45. . . . . . . . . . . . . Open Number [68] 0. Open Number . . . . . . . . . . . . . . _N46. . . . . . . . . . . . . Open Number [69] 0. Open Number . . . . . . . . . . . . . . _N47. . . . . . . . . . . . . Open Number [70] 0. Open Number . . . . . . . . . . . . . . _N48. . . . . . . . . . . . . Open Number [71] 0. Open Number . . . . . . . . . . . . . . _N49. . . . . . . . . . . . . Open Number [72] 0. Open Number . . . . . . . . . . . . . . _N50. . . . . . . . . . . . . Open Number [73] 0. Open Number . . . . . . . . . . . . . . _N51. . . . . . . . . . . . . Open Number [74] 0. Open Number . . . . . . . . . . . . . . _N52. . . . . . . . . . . . . Open Number [75] 0. Open Number . . . . . . . . . . . . . . _N53. . . . . . . . . . . . . Open Number [76] 0. Open Number . . . . . . . . . . . . . . _N54. . . . . . . . . . . . . Open Number [77] 0. Open Number . . . . . . . . . . . . . . _N55. . . . . . . . . . . . . Open Number [78] 0. Open Number . . . . . . . . . . . . . . _N56. . . . . . . . . . . . . Open Number [79] 0. Open Number . . . . . . . . . . . . . . _N57. . . . . . . . . . . . . Open Number [80] 0. Open Number . . . . . . . . . . . . . . _N58. . . . . . . . . . . . . Open Number [81] 0. Open Number . . . . . . . . . . . . . . _N59. . . . . . . . . . . . . Open Number [82] 0. Open Number . . . . . . . . . . . . . . _N60. . . . . . . . . . . . . Open Number [83] 0. Open Number . . . . . . . . . . . . . . _N61. . . . . . . . . . . . . Open Number [84] 0. Open Number . . . . . . . . . . . . . . _N62. . . . . . . . . . . . . Open Number [85] 0. Open Number . . . . . . . . . . . . . . _N63. . . . . . . . . . . . . Open Number [86] 0. Open Number . . . . . . . . . . . . . . _N64. . . . . . . . . . . . . Open Number [87] 0. Open Number . . . . . . . . . . . . . . _N65. . . . . . . . . . . . . Open Number [88] 0. Open Number . . . . . . . . . . . . . . _N66. . . . . . . . . . . . . Open Number [89] 0. Open Number . . . . . . . . . . . . . . _N67. . . . . . . . . . . . . Open Number [90] 0. Open Number . . . . . . . . . . . . . . _N68. . . . . . . . . . . . . Open Number [91] 0. Open Number . . . . . . . . . . . . . . _N69. . . . . . . . . . . . . Open Number [92] 0. Open Number . . . . . . . . . . . . . . _N70. . . . . . . . . . . . . Open Number [93] 0. Open Number . . . . . . . . . . . . . . _N71. . . . . . . . . . . . . Open Number [94] 0. Open Number . . . . . . . . . . . . . . _N72. . . . . . . . . . . . . Open Number [95] 0. Open Number . . . . . . . . . . . . . . _N73. . . . . . . . . . . . . Open Number [96] 0. Open Number . . . . . . . . . . . . . . _N74. . . . . . . . . . . . . Open Number [97] 0. Open Number . . . . . . . . . . . . . . _N75. . . . . . . . . . . . . Open Number [98] 0. Open Number . . . . . . . . . . . . . . _N76. . . . . . . . . . . . . Open Number [99] 0. Open Number . . . . . . . . . . . . . . _N77. . . . . . . . . . . . . Open Number [100] 0. Open Number . . . . . . . . . . . . . . _N78. . . . . . . . . . . . . Open Number [101] 0. Open Number . . . . . . . . . . . . . . _N79. . . . . . . . . . . . . Open Number [102] 0. Open Number . . . . . . . . . . . . . . _N80. . . . . . . . . . . . . Open Number [103] 0. ________ Total Bytes 491
MP2 Projected Demands (MP2_ProjectedDemands) Level: 4.40 Record Type: 2 Projected Demands Weekly 08/28/2009 File Type: Direct Key Size: 55 Rec Len: 1371 Min Len: 121 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase *(1,30) Warehouse Number. . . . . . . . . . . . WarehouseNumber . . . . . . . Account *(31,3) Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(34,2) Customer Number . . . . . . . . . . . . CustomerNumber. . . . . . . . Account *(36,20) Projection Type ("W") . . . . . . . . . ProjectionType. . . . . . . . Uppercase (56,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (57,65) Forecast This Year Week1. . . . . . . . ForecastWeek1 . . . . . . . . Number [0] 6.3 Forecast This Year Week2. . . . . . . . ForecastWeek2 . . . . . . . . Number [1] 6.3 Forecast This Year Week3. . . . . . . . ForecastWeek3 . . . . . . . . Number [2] 6.3 Forecast This Year Week4. . . . . . . . ForecastWeek4 . . . . . . . . Number [3] 6.3 Forecast This Year Week5. . . . . . . . ForecastWeek5 . . . . . . . . Number [4] 6.3 Forecast This Year Week6. . . . . . . . ForecastWeek6 . . . . . . . . Number [5] 6.3 Forecast This Year Week7. . . . . . . . ForecastWeek7 . . . . . . . . Number [6] 6.3 Forecast This Year Week8. . . . . . . . ForecastWeek8 . . . . . . . . Number [7] 6.3 Forecast This Year Week9. . . . . . . . ForecastWeek9 . . . . . . . . Number [8] 6.3 Forecast This Year Week10 . . . . . . . ForecastWeek10. . . . . . . . Number [9] 6.3 Forecast This Year Week11 . . . . . . . ForecastWeek11. . . . . . . . Number [10] 6.3 Forecast This Year Week12 . . . . . . . ForecastWeek12. . . . . . . . Number [11] 6.3 Forecast This Year Week13 . . . . . . . ForecastWeek13. . . . . . . . Number [12] 6.3 Forecast This Year Week14 . . . . . . . ForecastWeek14. . . . . . . . Number [13] 6.3 Forecast This Year Week15 . . . . . . . ForecastWeek15. . . . . . . . Number [14] 6.3 Forecast This Year Week16 . . . . . . . ForecastWeek16. . . . . . . . Number [15] 6.3 Forecast This Year Week17 . . . . . . . ForecastWeek17. . . . . . . . Number [16] 6.3 Forecast This Year Week18 . . . . . . . ForecastWeek18. . . . . . . . Number [17] 6.3 Forecast This Year Week19 . . . . . . . ForecastWeek19. . . . . . . . Number [18] 6.3 Forecast This Year Week20 . . . . . . . ForecastWeek20. . . . . . . . Number [19] 6.3 Forecast This Year Week21 . . . . . . . ForecastWeek21. . . . . . . . Number [20] 6.3 Forecast This Year Week22 . . . . . . . ForecastWeek22. . . . . . . . Number [21] 6.3 Forecast This Year Week23 . . . . . . . ForecastWeek23. . . . . . . . Number [22] 6.3 Forecast This Year Week24 . . . . . . . ForecastWeek24. . . . . . . . Number [23] 6.3 Forecast This Year Week25 . . . . . . . ForecastWeek25. . . . . . . . Number [24] 6.3 Forecast This Year Week26 . . . . . . . ForecastWeek26. . . . . . . . Number [25] 6.3 Forecast This Year Week27 . . . . . . . ForecastWeek27. . . . . . . . Number [26] 6.3 Forecast This Year Week28 . . . . . . . ForecastWeek28. . . . . . . . Number [27] 6.3 Forecast This Year Week29 . . . . . . . ForecastWeek29. . . . . . . . Number [28] 6.3 Forecast This Year Week30 . . . . . . . ForecastWeek30. . . . . . . . Number [29] 6.3 Forecast This Year Week31 . . . . . . . ForecastWeek31. . . . . . . . Number [30] 6.3 Forecast This Year Week32 . . . . . . . ForecastWeek32. . . . . . . . Number [31] 6.3 Forecast This Year Week33 . . . . . . . ForecastWeek33. . . . . . . . Number [32] 6.3 Forecast This Year Week34 . . . . . . . ForecastWeek34. . . . . . . . Number [33] 6.3 Forecast This Year Week35 . . . . . . . ForecastWeek35. . . . . . . . Number [34] 6.3 Forecast This Year Week36 . . . . . . . ForecastWeek36. . . . . . . . Number [35] 6.3 Forecast This Year Week37 . . . . . . . ForecastWeek37. . . . . . . . Number [36] 6.3 Forecast This Year Week38 . . . . . . . ForecastWeek38. . . . . . . . Number [37] 6.3 Forecast This Year Week39 . . . . . . . ForecastWeek39. . . . . . . . Number [38] 6.3 Forecast This Year Week40 . . . . . . . ForecastWeek40. . . . . . . . Number [39] 6.3 Forecast This Year Week41 . . . . . . . ForecastWeek41. . . . . . . . Number [40] 6.3 Forecast This Year Week42 . . . . . . . ForecastWeek42. . . . . . . . Number [41] 6.3 Forecast This Year Week43 . . . . . . . ForecastWeek43. . . . . . . . Number [42] 6.3 Forecast This Year Week44 . . . . . . . ForecastWeek44. . . . . . . . Number [43] 6.3 Forecast This Year Week45 . . . . . . . ForecastWeek45. . . . . . . . Number [44] 6.3 Forecast This Year Week46 . . . . . . . ForecastWeek46. . . . . . . . Number [45] 6.3 Forecast This Year Week47 . . . . . . . ForecastWeek47. . . . . . . . Number [46] 6.3 Forecast This Year Week48 . . . . . . . ForecastWeek48. . . . . . . . Number [47] 6.3 Forecast This Year Week49 . . . . . . . ForecastWeek49. . . . . . . . Number [48] 6.3 Forecast This Year Week50 . . . . . . . ForecastWeek50. . . . . . . . Number [49] 6.3 Forecast This Year Week51 . . . . . . . ForecastWeek51. . . . . . . . Number [50] 6.3 Forecast This Year Week52 . . . . . . . ForecastWeek52. . . . . . . . Number [51] 6.3 Forecast Next Year Week1. . . . . . . . ForecastWeek1NextYear . . . . Number [52] 6.3 Forecast Next Year Week2. . . . . . . . ForecastWeek2NextYear . . . . Number [53] 6.3 Forecast Next Year Week3. . . . . . . . ForecastWeek3NextYear . . . . Number [54] 6.3 Forecast Next Year Week4. . . . . . . . ForecastWeek4NextYear . . . . Number [55] 6.3 Forecast Next Year Week5. . . . . . . . ForecastWeek5NextYear . . . . Number [56] 6.3 Forecast Next Year Week6. . . . . . . . ForecastWeek6NextYear . . . . Number [57] 6.3 Forecast Next Year Week7. . . . . . . . ForecastWeek7NextYear . . . . Number [58] 6.3 Forecast Next Year Week8. . . . . . . . ForecastWeek8NextYear . . . . Number [59] 6.3 Forecast Next Year Week9. . . . . . . . ForecastWeek9NextYear . . . . Number [60] 6.3 Forecast Next Year Week10 . . . . . . . ForecastWeek10NextYear. . . . Number [61] 6.3 Forecast Next Year Week11 . . . . . . . ForecastWeek11NextYear. . . . Number [62] 6.3 Forecast Next Year Week12 . . . . . . . ForecastWeek12NextYear. . . . Number [63] 6.3 Forecast Next Year Week13 . . . . . . . ForecastWeek13NextYear. . . . Number [64] 6.3 Forecast Next Year Week14 . . . . . . . ForecastWeek14NextYear. . . . Number [65] 6.3 Forecast Next Year Week15 . . . . . . . ForecastWeek15NextYear. . . . Number [66] 6.3 Forecast Next Year Week16 . . . . . . . ForecastWeek16NextYear. . . . Number [67] 6.3 Forecast Next Year Week17 . . . . . . . ForecastWeek17NextYear. . . . Number [68] 6.3 Forecast Next Year Week18 . . . . . . . ForecastWeek18NextYear. . . . Number [69] 6.3 Forecast Next Year Week19 . . . . . . . ForecastWeek19NextYear. . . . Number [70] 6.3 Forecast Next Year Week20 . . . . . . . ForecastWeek20NextYear. . . . Number [71] 6.3 Forecast Next Year Week21 . . . . . . . ForecastWeek21NextYear. . . . Number [72] 6.3 Forecast Next Year Week22 . . . . . . . ForecastWeek22NextYear. . . . Number [73] 6.3 Forecast Next Year Week23 . . . . . . . ForecastWeek23NextYear. . . . Number [74] 6.3 Forecast Next Year Week24 . . . . . . . ForecastWeek24NextYear. . . . Number [75] 6.3 Forecast Next Year Week25 . . . . . . . ForecastWeek25NextYear. . . . Number [76] 6.3 Forecast Next Year Week26 . . . . . . . ForecastWeek26NextYear. . . . Number [77] 6.3 Forecast Next Year Week27 . . . . . . . ForecastWeek27NextYear. . . . Number [78] 6.3 Forecast Next Year Week28 . . . . . . . ForecastWeek28NextYear. . . . Number [79] 6.3 Forecast Next Year Week29 . . . . . . . ForecastWeek29NextYear. . . . Number [80] 6.3 Forecast Next Year Week30 . . . . . . . ForecastWeek30NextYear. . . . Number [81] 6.3 Forecast Next Year Week31 . . . . . . . ForecastWeek31NextYear. . . . Number [82] 6.3 Forecast Next Year Week32 . . . . . . . ForecastWeek32NextYear. . . . Number [83] 6.3 Forecast Next Year Week33 . . . . . . . ForecastWeek33NextYear. . . . Number [84] 6.3 Forecast Next Year Week34 . . . . . . . ForecastWeek34NextYear. . . . Number [85] 6.3 Forecast Next Year Week35 . . . . . . . ForecastWeek35NextYear. . . . Number [86] 6.3 Forecast Next Year Week36 . . . . . . . ForecastWeek36NextYear. . . . Number [87] 6.3 Forecast Next Year Week37 . . . . . . . ForecastWeek37NextYear. . . . Number [88] 6.3 Forecast Next Year Week38 . . . . . . . ForecastWeek38NextYear. . . . Number [89] 6.3 Forecast Next Year Week39 . . . . . . . ForecastWeek39NextYear. . . . Number [90] 6.3 Forecast Next Year Week40 . . . . . . . ForecastWeek40NextYear. . . . Number [91] 6.3 Forecast Next Year Week41 . . . . . . . ForecastWeek41NextYear. . . . Number [92] 6.3 Forecast Next Year Week42 . . . . . . . ForecastWeek42NextYear. . . . Number [93] 6.3 Forecast Next Year Week43 . . . . . . . ForecastWeek43NextYear. . . . Number [94] 6.3 Forecast Next Year Week44 . . . . . . . ForecastWeek44NextYear. . . . Number [95] 6.3 Forecast Next Year Week45 . . . . . . . ForecastWeek45NextYear. . . . Number [96] 6.3 Forecast Next Year Week46 . . . . . . . ForecastWeek46NextYear. . . . Number [97] 6.3 Forecast Next Year Week47 . . . . . . . ForecastWeek47NextYear. . . . Number [98] 6.3 Forecast Next Year Week48 . . . . . . . ForecastWeek48NextYear. . . . Number [99] 6.3 Forecast Next Year Week49 . . . . . . . ForecastWeek49NextYear. . . . Number [100] 6.3 Forecast Next Year Week50 . . . . . . . ForecastWeek50NextYear. . . . Number [101] 6.3 Forecast Next Year Week51 . . . . . . . ForecastWeek51NextYear. . . . Number [102] 6.3 Forecast Next Year Week52 . . . . . . . ForecastWeek52NextYear. . . . Number [103] 6.3 ________ Total Bytes 1371