IM_PriceListWrk IM Price List Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_PriceList_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/IM"+%C$+"/IM_PriceListWrk"+%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 PriceCodeRecord . . . . . . . 1 SNN Price Code Record . . . . . . . 4 PriceCode . . . . . . . . . . 4 SNN Price Code. . . . . . . . . . . 5 PriceCodeDesc . . . . . . . . 25 SNN Price Code Description. . . . . 6 ItemCode. . . . . . . . . . . 30 SNN Item Code . . . . . . . . . . . 7 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . . 8 StandardUnitOfMeasure . . . . 4 SNN Standard Unit Of Measure. . . . 9 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . . 10 ProductLineDesc . . . . . . . 25 SNN Product Line Description. . . . 11 PrimaryAPDivisionNo . . . . . 2 SNN Primary AP Division Number. . . 12 PrimaryVendorNo . . . . . . . 7 SNN Primary Vendor Number . . . . . 13 PrimaryVendorName . . . . . . 30 SNN Primary Vendor Name . . . . . . 14 Category1Desc . . . . . . . . 15 SNN Category 1 Description. . . . . 15 Category1 . . . . . . . . . . 10 SNN Category 1. . . . . . . . . . . 16 Category2Desc . . . . . . . . 15 SNN Category 2 Description. . . . . 17 Category2 . . . . . . . . . . 10 SNN Category 2. . . . . . . . . . . 18 Category3Desc . . . . . . . . 15 SNN Category 3 Description. . . . . 19 Category3 . . . . . . . . . . 10 SNN Category 3. . . . . . . . . . . 20 Category4Desc . . . . . . . . 15 SNN Category 4 Description. . . . . 21 Category4 . . . . . . . . . . 10 SNN Category 4. . . . . . . . . . . 22 CustomerPriceLevel. . . . . . 1 SNN Customer Price Level. . . . . . 23 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 24 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 25 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 26 PricingMethod . . . . . . . . 1 SNN Pricing Method. . . . . . . . . 27 BreakQuantity1. . . . . . . . 8.0 NNN Break Quantity 1. . . . . . . . Mask:######## 28 BreakQuantity2. . . . . . . . 8.0 NNN Break Quantity 2. . . . . . . . Mask:######## 29 BreakQuantity3. . . . . . . . 8.0 NNN Break Quantity 3. . . . . . . . Mask:######## 30 BreakQuantity4. . . . . . . . 8.0 NNN Break Quantity 4. . . . . . . . Mask:######## 31 BreakQuantity5. . . . . . . . 8.0 NNN Break Quantity 5. . . . . . . . Mask:######## 32 DiscountMarkup1 . . . . . . . 16.6 NNN Discount Markup 1 . . . . . . . 33 DiscountMarkup2 . . . . . . . 16.6 NNN Discount Markup 2 . . . . . . . 34 DiscountMarkup3 . . . . . . . 16.6 NNN Discount Markup 3 . . . . . . . 35 DiscountMarkup4 . . . . . . . 16.6 NNN Discount Markup 4 . . . . . . . 36 DiscountMarkup5 . . . . . . . 16.6 NNN Discount Markup 5 . . . . . . . 37 StandardUnitCost. . . . . . . 16.6 NNN Standard Unit Cost. . . . . . . 38 StandardUnitPrice . . . . . . 16.6 NNN Standard Unit Price . . . . . . 39 SuggestedRetailPrice. . . . . 16.6 NNN Suggested Retail Price. . . . .