# Table: Item Pricing

Table: ICPRIC
View: IC0480
Record length: 410
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: 47

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
BASEPRICE | BCD*10.6 | Base Price |
BASEUNIT | String*10 | Pricing Unit of Measure | Mask: %-10c
BASECONV | BCD*10.6 | Base Conversion Factor |
SALEPRICE | BCD*10.6 | Sale Price |
SALEUNIT | String*10 | Sale Unit of Measure | Mask: %-10c
SALECONV | BCD*10.6 | Sale Conversion Factor |
SALESTART | Date | Sale Start Date |
SALEEND | Date | Sale End Date |
MARKUPCOST | BCD*10.6 | Markup Cost |
MARKUPUNIT | String*10 | Markup Unit of Measure | Mask: %-10c
MARKUPCONV | BCD*10.6 | Markup Conversion Factor |
PRICETYPE | Integer | Selling Price Based on | 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 | 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 |
LASTPRICDT | Date | Last Price Change Date |
PREVPRICE | BCD*10.6 | Previous Price |
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 |

This page was generated on 2004-Oct-28

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