     IM_SalesPromotionWrk                  IM Sales Promotion Work         Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_SalesPromotionReport_rpt
     SQL Def: Y  SysDB: N                           "MAS_"+%C$+"/IM"+%C$+"/IM_SalesPromotionWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
       3  SalesPromotionCode. . . . . .    10 SNN  Sales Promotion Code. . . . . .
       4  SaleStartDate . . . . . . . .     8 SNN  Sale Starting Date. . . . . . .DATE
       5  SaleEndDate . . . . . . . . .     8 SNN  Sale Ending Date. . . . . . . .DATE
       6  SaleMethod. . . . . . . . . .     1 SNN  Sale Method . . . . . . . . . .
       7  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
       8  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
       9  StandardUnitOfMeasure . . . .     4 SNN  Standard Unit of Measure. . . .
      10  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
      11  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
      12  PrimaryAPDivisionNo . . . . .     2 SNN  Primary AP Division Number. . .
      13  PrimaryVendorNo . . . . . . .     7 SNN  Primary Vendor Number . . . . .
      14  PrimaryVendorName . . . . . .    30 SNN  Primary Vendor Name . . . . . .
      15  Category1Desc . . . . . . . .    15 SNN  Category 1 Description. . . . .
      16  Category1 . . . . . . . . . .    10 SNN  Category 1. . . . . . . . . . .
      17  Category2Desc . . . . . . . .    15 SNN  Category 2 Description. . . . .
      18  Category2 . . . . . . . . . .    10 SNN  Category 2. . . . . . . . . . .
      19  Category3Desc . . . . . . . .    15 SNN  Category 3 Description. . . . .
      20  Category3 . . . . . . . . . .    10 SNN  Category 3. . . . . . . . . . .
      21  Category4Desc . . . . . . . .    15 SNN  Category 4 Description. . . . .
      22  Category4 . . . . . . . . . .    10 SNN  Category 4. . . . . . . . . . .
      23  SuggestedRetailPrice. . . . . 16.6  NNN  Suggested Retail Price. . . . .
      24  StandardUnitPrice . . . . . . 16.6  NNN  Standard Unit Price . . . . . .
      25  SalesPromotionPrice . . . . . 16.6  NNN  Sales Promotion Price . . . . .
      26  SalesPromotionDiscountPercent 12.3  NNN  Sales Promotion Discount Percen