Table: Price List Codes

Table: ICPCOD
View: IC0390
Record Length: 295

Flags: A R 

Keys: 1

Title Flags Fields

Price List Code PRICELIST

Fields: 37

Field Type Title Presentation

PRICELIST String*6 Price List Code Mask: %-6N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DESC String*60 Description
PRICETYPE Integer Selling Price Based on 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 Integer Discount/Markup on Price by List:2 entries
1 = Percentage
2 = Amount
PRCNTLVL1 BCD*5.5 Discount/Markup Percentage 1
PRCNTLVL2 BCD*5.5 Discount/Markup Percentage 2
PRCNTLVL3 BCD*5.5 Discount/Markup Percentage 3
PRCNTLVL4 BCD*5.5 Discount/Markup Percentage 4
PRCNTLVL5 BCD*5.5 Discount/Markup Percentage 5
PRICEBASE Integer Price Determined by List:2 entries
1 = Customer Type
2 = Volume Discounts
PRICEQTY1 BCD*10.4 Quantity Level 1
PRICEQTY2 BCD*10.4 Quantity Level 2
PRICEQTY3 BCD*10.4 Quantity Level 3
PRICEQTY4 BCD*10.4 Quantity Level 4
PRICEQTY5 BCD*10.4 Quantity Level 5
PRICEDECS Integer Decimals in Price List:7 entries
0 = 0
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
ROUNDMETHD Integer Rounding Method List:3 entries
1 = No Rounding
2 = Round Up
3 = Round Down
ROUNDAMT BCD*10.6 Round to a Multiple of
AMOUNTLVL1 BCD*10.6 Discount/Markup Amount 1
AMOUNTLVL2 BCD*10.6 Discount/Markup Amount 2
AMOUNTLVL3 BCD*10.6 Discount/Markup Amount 3
AMOUNTLVL4 BCD*10.6 Discount/Markup Amount 4
AMOUNTLVL5 BCD*10.6 Discount/Markup Amount 5
PRICEBY Integer Price By List:2 entries
1 = Quantity
2 = Weight
PRICEWGHT1 BCD*10.4 Weight Level 1
PRICEWGHT2 BCD*10.4 Weight Level 2
PRICEWGHT3 BCD*10.4 Weight Level 3
PRICEWGHT4 BCD*10.4 Weight Level 4
PRICEWGHT5 BCD*10.4 Weight Level 5
CPRICETYPE Integer Price Check Type List:4 entries
0 = None
1 = Warning
2 = Error
3 = Approval
CCHECK Integer Check List:2 entries
1 = Unit Price
2 = Sales Margin
CCHECKBASE Integer Check Base List:3 entries
1 = Cost Plus a Percentage
2 = Cost Plus a Fixed Amount
3 = Fixed Amount
CBASE Integer Cost/Margin Base List:6 entries
1 = Markup Cost
2 = Standard Cost
3 = Most Recent Cost
4 = Average Cost
5 = Last Cost
6 = Landed