View: Item Pricing

RotoID: IC0480
Table: ICPRIC
Protocol: Header
DLL:ICPRIC

Compositions: 11

RotoID Tables Title DLL
IC0490 ICPRTX Price List Tax Authorities ICPRTX
IC0310 ICITEM Items ICITEM
IC0390 ICPCOD Price List Codes ICPCOD
IC0750 ICUNIT Units of Measure ICUNIT
IC0395 ICPCTX Price List Code Tax Authorities ICPCTX
TX0002 TXAUTH Tax Authorities TXAUTH
IC0481 ICPRICC Pricing Price Checks ICPRICC
IC0482 ICPRICP Item Pricing Details ICPRICP
IC0758 ICWCOD Weight Units of Measure ICWCOD
IC0392 ICPCODC Price List Codes Checks ICPCODC
IC0290 ICILOC Location Details ICILOC

Keys: 3

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

Fields: 90

Field Index Type Title Attributes Presentation
CURRENCY 1 String*3 Currency Code E A K R  Mask: %-3N
ITEMNO 2 String*24 Unformatted Item Number E A K R  Mask: %-24C
PRICELIST 3 String*6 Price List Code E A K R  Mask: %-6N
DESC 4 String*60 Description E A 
PRICEDECS 5 Integer Decimals in Price E A  List:7 entries
0 = 0
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
MARKUPCOST 14 BCD*10.6 Markup Cost E A 
MARKUPUNIT 15 String*10 Markup Unit of Measure E A  Mask: %-10w
MARKUPCONV 16 BCD*10.6 Markup Conversion Factor E A 
PRICETYPE 17 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 Unit Cost
7 = Markup on Landed
PRICEFMT 18 Integer Discount/Markup Price by E A  List:2 entries
1 = Percentage
2 = Amount
PRCNTLVL1 19 BCD*5.5 Discount/Markup Percentage 1 E A 
PRCNTLVL2 20 BCD*5.5 Discount/Markup Percentage 2 E A 
PRCNTLVL3 21 BCD*5.5 Discount/Markup Percentage 3 E A 
PRCNTLVL4 22 BCD*5.5 Discount/Markup Percentage 4 E A 
PRCNTLVL5 23 BCD*5.5 Discount/Markup Percentage 5 E A 
PRICEBASE 24 Integer Price Determined by E A  List:2 entries
1 = Customer Type
2 = Volume Discounts
PRICEQTY1 25 BCD*10.4 Quantity Level 1 E A 
PRICEQTY2 26 BCD*10.4 Quantity Level 2 E A 
PRICEQTY3 27 BCD*10.4 Quantity Level 3 E A 
PRICEQTY4 28 BCD*10.4 Quantity Level 4 E A 
PRICEQTY5 29 BCD*10.4 Quantity Level 5 E A 
MARKUP 30 BCD*5.5 Markup Factor E A 
LASTMKPDT 33 Date Last Markup Cost Change Date E A 
PREVMKPCST 34 BCD*10.6 Previous Markup Cost E A 
LASTEXCHDT 35 Date Last Exchange Rate Change Date E A 
PREVEXCHRT 36 BCD*8.7 Previous Exchange Rate E A 
ROUNDMETHD 37 Integer Rounding Method E A  List:3 entries
1 = No Rounding
2 = Round Up
3 = Round Down
ROUNDAMT 38 BCD*10.6 Round to a Multiple of E A 
AMOUNTLVL1 39 BCD*10.6 Discount/Markup Amount 1 E A 
AMOUNTLVL2 40 BCD*10.6 Discount/Markup Amount 2 E A 
AMOUNTLVL3 41 BCD*10.6 Discount/Markup Amount 3 E A 
AMOUNTLVL4 42 BCD*10.6 Discount/Markup Amount 4 E A 
AMOUNTLVL5 43 BCD*10.6 Discount/Markup Amount 5 E A 
PRICEBY 44 Integer Price By E A X  List:2 entries
1 = Quantity
2 = Weight
MRKUPWUNIT 45 String*10 Markup Weight Unit of Measure E A  Mask: %-10w
PRICEWGHT1 46 BCD*10.4 Weight Level 1 E A 
PRICEWGHT2 47 BCD*10.4 Weight Level 2 E A 
PRICEWGHT3 48 BCD*10.4 Weight Level 3 E A 
PRICEWGHT4 49 BCD*10.4 Weight Level 4 E A 
PRICEWGHT5 50 BCD*10.4 Weight Level 5 E A 
CPRICETYPE 51 Integer Price Check Type E A  List:4 entries
0 = None
1 = Warning
2 = Error
3 = Approval
CCHECK 52 Integer Check E A  List:2 entries
1 = Unit Price
2 = Sales Margin
CCHECKBASE 53 Integer Check Base E A P  List:3 entries
1 = Cost Plus a Percentage
2 = Cost Plus a Fixed Amount
3 = Fixed Amount
CBASE 54 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 Unit Cost
6 = Landed
DEFBUNIT 55 String*10 Default Base Unit E A C  Mask: %-10w
DEFBWUNIT 56 String*10 Default Base Weight Unit E A C  Mask: %-10w
DEFSUNIT 57 String*10 Default Sale Unit E A C  Mask: %-10w
DEFSWUNIT 58 String*10 Default Sale Weight Unit E A C  Mask: %-10w
STOCKITEM 59 Boolean Stock Item A C  List:2 entries
0 = No
1 = Yes
DBASEPRICE 60 BCD*10.6 Base Price E A 
DBASEUNIT 61 String*10 Pricing Unit of Measure E A  Mask: %-10w
DBASEWUNIT 62 String*10 Pricing Weight Unit of Measure E A  Mask: %-10w
DBASECONV 63 BCD*10.6 Base Conversion Factor E A 
DSALEPRICE 64 BCD*10.6 Sale Price E A 
DSALEUNIT 65 String*10 Sale Unit of Measure E A  Mask: %-10w
DSALEWUNIT 66 String*10 Sale Weight Unit of Measure E A  Mask: %-10w
DSALECONV 67 BCD*10.6 Sale Conversion Factor E A 
DSALESTART 68 Date Sale Start Date E A 
DSALEEND 69 Date Sale End Date E A 
FMTITEMNO 70 String*24 Item Number A C  Mask: %-24C
STOCKUNIT 71 String*10 Stocking Unit of Measure A C  Mask: %-10w
BPRICETYPE 72 Integer Base Price Type E A P  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 73 Integer Default Base Price Using E A P  List:3 entries
0 = No Default
1 = Cost Plus a Percentage
2 = Cost Plus an Amount
BLOCATION 74 String*6 Base Location E A  Mask: %-6N
BBASE 75 Integer Base Cost Base E A P  List:5 entries
1 = Standard Cost
2 = Most Recent Cost
3 = Average Cost
4 = Last Unit Cost
5 = Landed
BPERCENT 76 BCD*5.5 Base Percentage E A 
BAMOUNT 77 BCD*10.6 Base Amount E A 
BRATETYPE 78 String*2 Base Rate Type E A  Mask: %-2N
BRATEDATE 79 Date Base Rate Date E A 
BEXCHRATE 80 BCD*8.7 Base Exchange Rate E A 
BRATEOP 81 Integer Base Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
BRATEOVRRD 82 Boolean Base Rate Overidden E A  List:2 entries
0 = No
1 = Yes
SPRICETYPE 83 Integer Sale Price Type E A P  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 84 Integer Default Sale Price Using E A P  List:3 entries
0 = No Default
1 = Cost Plus a Percentage
2 = Cost Plus an Amount
SLOCATION 85 String*6 Sale Location E A  Mask: %-6N
SBASE 86 Integer Sale Cost Base E A P  List:5 entries
1 = Standard Cost
2 = Most Recent Cost
3 = Average Cost
4 = Last Unit Cost
5 = Landed
SPERCENT 87 BCD*5.5 Sale Percentage E A 
SAMOUNT 88 BCD*10.6 Sale Amount E A 
SRATETYPE 89 String*2 Sale Rate Type E A  Mask: %-2N
SRATEDATE 90 Date Sale Rate Date E A 
SEXCHRATE 91 BCD*8.7 Sale Exchange Rate E A 
SRATEOP 92 Integer Sale Rate Operator E A C  List:2 entries
1 = Multiply
2 = Divide
SRATEOVRRD 93 Boolean Sale Rate Overidden E A  List:2 entries
0 = No
1 = Yes
PROCESSCMD 94 Integer Process Command E A C  List:5 entries
0 = Nothing to Process
1 = Default the Base Price
2 = Default the Sale Price
3 = Set Price List Maintenance Status
4 = Reset Price List Maintenance Status
CHECKITEM 95 Boolean Check Item Existence E A C  List:2 entries
0 = No
1 = Yes
BRATEEXIST 96 Integer Calc. Base Exch. Rate Exists A C  List:3 entries
0 = Rate does not exist
1 = Rate exists
2 = Rate is calculated
SRATEEXIST 97 Integer Calc. Sale Exch. Rate Exists A C  List:3 entries
0 = Rate does not exist
1 = Rate exists
2 = Rate is calculated
LOCCOSTOK 98 Boolean Item Location Cost Allowable A C  List:2 entries
0 = No
1 = Yes
PRICESTART 99 Date Price List Start Date E A 
PRICEEND 100 Date Price List End Date E A 

This page was generated on 2023-Aug-31

© 2023 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).