IM_PriceCode                           IM Price Code                  Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: IM_PriceCode_bus
 SQL Def: Y  SysDB: N                                          "MAS_"+%C$+"/IM"+%C$+"/IM_PriceCode.M4T"

 KPRIMARY: PriceCodeRecord+PriceCode+ItemCode+CustomerPriceLevel+ARDivisionNo+CustomerNo
 KITEM: ItemCode+PriceCodeRecord+PriceCode+CustomerPriceLevel+ARDivisionNo+CustomerNo
 KITEMCUSTOMER: ItemCode+PriceCodeRecord+CustomerPriceLevel+ARDivisionNo+CustomerNo+PriceCode
 KCUSTOMERITEM: ItemCode+PriceCodeRecord(d)+CustomerPriceLevel+ARDivisionNo+CustomerNo+PriceCode
 KCUSTOMER: ARDivisionNo+CustomerNo+ItemCode+PriceCodeRecord+PriceCode+CustomerPriceLevel

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  PriceCodeRecord . . . . . . .     1 SYY  Price Code Record . . . . . . .
                                                Valid:0,1,2 Notes: 0=Price
                                                Code record, 1= Item Price
                                                record, 2 = Item/Customer
                                                Price record
   2  PriceCode . . . . . . . . . .     4 SYN  Price Code. . . . . . . . . . .PRICECODE
                                                DepVal:REQUIRED
   3  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .ITEMCODE
                                                DepVal:REQUIRED ChngTag:Repla
                                                ce0
   4  CustomerPriceLevel. . . . . .     1 SYN  Customer Price Level. . . . . .
                                                DepVal:REQUIRED
   5  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                Mask:00 DepVal:REQUIRED
   6  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
                                                FmtType:MASTERNUMC DepVal:REQ
                                                UIRED ChngTag:Replace1/ARDivi
                                                sionNo$
   7  PriceCodeDesc . . . . . . . .    25 SNN  Price Code Description. . . . .
   8  PricingMethod . . . . . . . .     1 SYN  Pricing Method. . . . . . . . .
                                                DfltVal:C Valid:C,D,M,O,P
                                                Notes: C=Cost markup amount,
                                                D=Discount percentage,
                                                M=Markup percentage,
                                                O=Override Price to Notes,
                                                P=Price discount amount
   9  BreakQuantity1. . . . . . . .  8.0  NNN  Break Quantity 1. . . . . . . .BREAKQUANTITY
                                                Mask:########
  10  BreakQuantity2. . . . . . . .  8.0  NNN  Break Quantity 2. . . . . . . .BREAKQUANTITY
                                                Mask:########
  11  BreakQuantity3. . . . . . . .  8.0  NNN  Break Quantity 3. . . . . . . .BREAKQUANTITY
                                                Mask:########
  12  BreakQuantity4. . . . . . . .  8.0  NNN  Break Quantity 4. . . . . . . .BREAKQUANTITY
                                                Mask:########
  13  BreakQuantity5. . . . . . . .  8.0  NNN  Break Quantity 5. . . . . . . .BREAKQUANTITY
                                                Mask:########
  14  DiscountMarkup1 . . . . . . . 16.6  NNN  Discount Markup 1 . . . . . . .DISCOUNTMARKUP
                                                Mask:##,###,###.000000-
  15  DiscountMarkup2 . . . . . . . 16.6  NNN  Discount Markup 2 . . . . . . .DISCOUNTMARKUP
                                                Mask:##,###,###.000000-
  16  DiscountMarkup3 . . . . . . . 16.6  NNN  Discount Markup 3 . . . . . . .DISCOUNTMARKUP
                                                Mask:##,###,###.000000-
  17  DiscountMarkup4 . . . . . . . 16.6  NNN  Discount Markup 4 . . . . . . .DISCOUNTMARKUP
                                                Mask:##,###,###.000000-
  18  DiscountMarkup5 . . . . . . . 16.6  NNN  Discount Markup 5 . . . . . . .DISCOUNTMARKUP
                                                Mask:##,###,###.000000-
  19  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  20  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                Read Only:Y
  21  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
  22  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  23  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  24  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL