Table: Item Pricing

Table: ICPRIC
View: IC0480
Record Length: 537

Flags: A R 

Keys: 3

Title Flags Fields
Currency Code CURRENCY, ITEMNO, PRICELIST
Item Number ITEMNO, CURRENCY, PRICELIST
Price List Code CURRENCY, PRICELIST, ITEMNO

Fields: 76

Field Type Title Presentation
CURRENCY String*3 Currency Code Mask: %-3N
ITEMNO String*24 Unformatted Item Number Mask: %-24C
PRICELIST String*6 Price List Code Mask: %-6N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
DESC String*60 Description
PRICEDECS Integer Decimals in Price List:7 entries
0 = 0
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
MARKUPCOST BCD*10.6 Markup Cost
MARKUPUNIT String*10 Markup Unit of Measure Mask: %-10w
MARKUPCONV BCD*10.6 Markup Conversion Factor
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 Unit Cost
7 = Markup on Landed
PRICEFMT Integer Discount/Markup 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
MARKUP BCD*5.5 Markup Factor
LASTMKPDT Date Last Markup Cost Change Date
PREVMKPCST BCD*10.6 Previous Markup Cost
LASTEXCHDT Date Last Exchange Rate Change Date
PREVEXCHRT BCD*8.7 Previous Exchange Rate
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
MRKUPWUNIT String*10 Markup Weight Unit of Measure Mask: %-10w
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 Unit Cost
6 = Landed
DEFBUNIT String*10 Default Base Unit Mask: %-10w
DEFBWUNIT String*10 Default Base Weight Unit Mask: %-10w
DEFSUNIT String*10 Default Sale Unit Mask: %-10w
DEFSWUNIT String*10 Default Sale Weight Unit Mask: %-10w
BPRICETYPE Integer Base Price Type List:3 entries
1 = Base Price for Single Unit of Measure
2 = Base Price for Multiple Units of Measure
3 = Base Price Calculated Using a Cost
BDEFUSING Integer Default Base Price Using List:3 entries
0 = No Default
1 = Cost Plus a Percentage
2 = Cost Plus an Amount
BLOCATION String*6 Base Location Mask: %-6N
BBASE Integer Base Cost Base List:5 entries
1 = Standard Cost
2 = Most Recent Cost
3 = Average Cost
4 = Last Unit Cost
5 = Landed
BPERCENT BCD*5.5 Base Percentage
BAMOUNT BCD*10.6 Base Amount
BRATETYPE String*2 Base Rate Type Mask: %-2N
BRATEDATE Date Base Rate Date
BEXCHRATE BCD*8.7 Base Exchange Rate
BRATEOP Integer Base Rate Operator List:2 entries
1 = Multiply
2 = Divide
BRATEOVRRD Boolean Base Rate Overidden List:2 entries
0 = No
1 = Yes
SPRICETYPE Integer Sale Price Type List:3 entries
1 = Sale Price for Single Unit of Measure
2 = Sale Price for Multiple Units of Measure
3 = Sale Price Calculated Using a Cost
SDEFUSING Integer Default Sale Price Using List:3 entries
0 = No Default
1 = Cost Plus a Percentage
2 = Cost Plus an Amount
SLOCATION String*6 Sale Location Mask: %-6N
SBASE Integer Sale Cost Base List:5 entries
1 = Standard Cost
2 = Most Recent Cost
3 = Average Cost
4 = Last Unit Cost
5 = Landed
SPERCENT BCD*5.5 Sale Percentage
SAMOUNT BCD*10.6 Sale Amount
SRATETYPE String*2 Sale Rate Type Mask: %-2N
SRATEDATE Date Sale Rate Date
SEXCHRATE BCD*8.7 Sale Exchange Rate
SRATEOP Integer Sale Rate Operator List:2 entries
1 = Multiply
2 = Divide
SRATEOVRRD Boolean Sale Rate Overidden List:2 entries
0 = No
1 = Yes
PRICESTART Date Price List Start Date
PRICEEND Date Price List End Date

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).