View: Price List Codes

RotoID: IC0390
Table: ICPCOD
Protocol: Header
DLL:ICPCOD

Compositions: 2

RotoID Tables Title DLL

IC0395 ICPCTX Price List Code Tax Authorities ICPCTX
IC0392 ICPCODC Price List Codes Checks ICPCODC

Keys: 1

Title Fields

Price List Code PRICELIST

Fields: 33

Field Index Type Title Attributes Presentation

PRICELIST 1 String*6 Price List Code E A K R  Mask: %-6N
DESC 2 String*60 Description E A 
PRICETYPE 3 Integer Selling Price Based on E A P  List:7 entries
1 = Discount
2 = Markup on Markup Cost
3 = Markup on Standard Cost
4 = Markup on Most Recent Cost
5 = Markup on Average Cost
6 = Markup on Last Cost
7 = Markup on Landed
PRICEFMT 4 Integer Discount/Markup on Price by E A  List:2 entries
1 = Percentage
2 = Amount
PRCNTLVL1 5 BCD*5.5 Discount/Markup Percentage 1 E A 
PRCNTLVL2 6 BCD*5.5 Discount/Markup Percentage 2 E A 
PRCNTLVL3 7 BCD*5.5 Discount/Markup Percentage 3 E A 
PRCNTLVL4 8 BCD*5.5 Discount/Markup Percentage 4 E A 
PRCNTLVL5 9 BCD*5.5 Discount/Markup Percentage 5 E A 
PRICEBASE 10 Integer Price Determined by E A  List:2 entries
1 = Customer Type
2 = Volume Discounts
PRICEQTY1 11 BCD*10.4 Quantity Level 1 E A 
PRICEQTY2 12 BCD*10.4 Quantity Level 2 E A 
PRICEQTY3 13 BCD*10.4 Quantity Level 3 E A 
PRICEQTY4 14 BCD*10.4 Quantity Level 4 E A 
PRICEQTY5 15 BCD*10.4 Quantity Level 5 E A 
PRICEDECS 16 Integer Decimals in Price E A  List:7 entries
0 = 0
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
ROUNDMETHD 17 Integer Rounding Method E A  List:3 entries
1 = No Rounding
2 = Round Up
3 = Round Down
ROUNDAMT 18 BCD*10.6 Round to a Multiple of E A 
AMOUNTLVL1 19 BCD*10.6 Discount/Markup Amount 1 E A 
AMOUNTLVL2 20 BCD*10.6 Discount/Markup Amount 2 E A 
AMOUNTLVL3 21 BCD*10.6 Discount/Markup Amount 3 E A 
AMOUNTLVL4 22 BCD*10.6 Discount/Markup Amount 4 E A 
AMOUNTLVL5 23 BCD*10.6 Discount/Markup Amount 5 E A 
PRICEBY 24 Integer Price By E A  List:2 entries
1 = Quantity
2 = Weight
PRICEWGHT1 25 BCD*10.4 Weight Level 1 E A 
PRICEWGHT2 26 BCD*10.4 Weight Level 2 E A 
PRICEWGHT3 27 BCD*10.4 Weight Level 3 E A 
PRICEWGHT4 28 BCD*10.4 Weight Level 4 E A 
PRICEWGHT5 29 BCD*10.4 Weight Level 5 E A 
CPRICETYPE 30 Integer Price Check Type E A  List:4 entries
0 = None
1 = Warning
2 = Error
3 = Approval
CCHECK 31 Integer Check E A  List:2 entries
1 = Unit Price
2 = Sales Margin
CCHECKBASE 32 Integer Check Base E A P  List:3 entries
1 = Cost Plus a Percentage
2 = Cost Plus a Fixed Amount
3 = Fixed Amount
CBASE 33 Integer Cost/Margin Base E A P  List:6 entries
1 = Markup Cost
2 = Standard Cost
3 = Most Recent Cost
4 = Average Cost
5 = Last Cost
6 = Landed