# 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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.