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