# View: Item Pricing

RotoID: IC0480
Tables: ICPRIC
DLL: ICPRIC

## Compositions: 6

RotoID | Title | Tables | DLL
--- | --- | --- | ---
IC0490 | Price List Tax Authorities | ICPRTX | ICPRTX
IC0310 | Items | ICITEM | ICITEM
IC0390 | Price List Codes | ICPCOD | ICPCOD
IC0750 | Units of Measure | ICUNIT | ICUNIT
IC0395 | Price List Code Tax Authorities | ICPCTX | ICPCTX
TX0002 | Tax Authorities | TXAUTH | TXAUTH

## Keys: 3

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

## Fields: 44

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
BASEPRICE | 6 | BCD*10.6 | Base Price | E A |
BASEUNIT | 7 | String*10 | Pricing Unit of Measure | E A | Mask: %-10c
BASECONV | 8 | BCD*10.6 | Base Conversion Factor | E A |
SALEPRICE | 9 | BCD*10.6 | Sale Price | E A |
SALEUNIT | 10 | String*10 | Sale Unit of Measure | E A | Mask: %-10c
SALECONV | 11 | BCD*10.6 | Sale Conversion Factor | E A |
SALESTART | 12 | Date | Sale Start Date | E A |
SALEEND | 13 | Date | Sale End Date | E A |
MARKUPCOST | 14 | BCD*10.6 | Markup Cost | E A |
MARKUPUNIT | 15 | String*10 | Markup Unit of Measure | E A | Mask: %-10c
MARKUPCONV | 16 | BCD*10.6 | Markup Conversion Factor | E A |
PRICETYPE | 17 | Integer | Selling Price Based on | E A P | List: 8 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
8 | = | Markup on Alt.Amt.2
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 |
LASTPRICDT | 31 | Date | Last Price Change Date | E A |
PREVPRICE | 32 | BCD*10.6 | Previous Price | 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 |
FMTITEMNO | 70 | String*24 | Item Number | A C | Mask: %-24C

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.