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