PO_VendorPriceLevel PO Vendor Price Level Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_VendorPriceLevel_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_VendorPriceLevel.M4T"
KPRIMARY: APDivisionNo+VendorNo+PricingType+ProductLine+ItemCode KDESCPRICINGTYPE: APDivisionNo+VendorNo+PricingType(d)+ProductLine+ItemCode
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {POR$(1,2)} 2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {POR$(3,7)} 3 PricingType . . . . . . . . . 1 SYY Pricing Type. . . . . . . . . . DfltVal:V Valid:V,P,I 4 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE DepVal:REQUIRED Notes: {POR$(10,4)} 5 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE DepVal:REQUIRED ChngTag:Repla ce0 Notes: {POR$(14,15)} 6 PricingMethod . . . . . . . . 1 SYY Pricing Method. . . . . . . . . DfltVal:D Valid:C,D,S Notes: {POR$(34,1)}C=Cost Discount Amount, D=Discount Percentage , S= Standard Cost 7 BreakQuantity1. . . . . . . . 8.0 NNN Break Quantity 1. . . . . . . .BREAKQUANTITY Mask:######## 8 BreakQuantity2. . . . . . . . 8.0 NNN Break Quantity 2. . . . . . . .BREAKQUANTITY Mask:######## 9 BreakQuantity3. . . . . . . . 8.0 NNN Break Quantity 3. . . . . . . .BREAKQUANTITY Mask:######## 10 BreakQuantity4. . . . . . . . 8.0 NNN Break Quantity 4. . . . . . . .BREAKQUANTITY Mask:######## 11 BreakQuantity5. . . . . . . . 8.0 NNN Break Quantity 5. . . . . . . .BREAKQUANTITY Mask:######## 12 BreakQuantity6. . . . . . . . 8.0 NNN Break Quantity 6. . . . . . . .BREAKQUANTITY Mask:######## 13 BreakQuantity7. . . . . . . . 8.0 NNN Break Quantity 7. . . . . . . .BREAKQUANTITY Mask:######## 14 BreakQuantity8. . . . . . . . 8.0 NNN Break Quantity 8. . . . . . . .BREAKQUANTITY Mask:######## 15 DiscountMarkup1 . . . . . . . 16.6 NNN Discount/Markup 1 . . . . . . .DISCOUNTMARKUP Mask:##,###,###.000000- Notes: {POR[8]} 16 DiscountMarkup2 . . . . . . . 16.6 NNN Discount/Markup 2 . . . . . . .DISCOUNTMARKUP Mask:##,###,###.000000- Notes: {POR[9]} 17 DiscountMarkup3 . . . . . . . 16.6 NNN Discount/Markup 3 . . . . . . .DISCOUNTMARKUP Mask:##,###,###.000000- Notes: {POR[10]} 18 DiscountMarkup4 . . . . . . . 16.6 NNN Discount/Markup 4 . . . . . . .DISCOUNTMARKUP Mask:##,###,###.000000- Notes: {POR[11]} 19 DiscountMarkup5 . . . . . . . 16.6 NNN Discount/Markup 5 . . . . . . .DISCOUNTMARKUP Mask:##,###,###.000000- Notes: {POR[12]} 20 DiscountMarkup6 . . . . . . . 16.6 NNN Discount/Markup 6 . . . . . . .DISCOUNTMARKUP Mask:##,###,###.000000- Notes: {POR[13]} 21 DiscountMarkup7 . . . . . . . 16.6 NNN Discount/Markup 7 . . . . . . .DISCOUNTMARKUP Mask:##,###,###.000000- Notes: {POR[14]} 22 DiscountMarkup8 . . . . . . . 16.6 NNN Discount/Markup 8 . . . . . . .DISCOUNTMARKUP Mask:##,###,###.000000- Notes: {POR[15]} 23 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 24 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 25 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 26 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 27 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 28 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000