# Table: Item Pricing

Table: ICPRIC
View: IC0480
Record length: 527
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: 74

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

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.