# Table: Price List Codes

Table: ICPCOD
View: IC0390
Record length: 295
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Price List Code |  | PRICELIST

## Fields: 37

Field | Type | Title | Presentation
--- | --- | --- | ---
PRICELIST | String*6 | Price List Code | Mask: %-6N
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DESC | String*60 | Description |
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 Cost
7 | = | Markup on Landed
PRICEFMT | Integer | Discount/Markup on 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 |
PRICEDECS | Integer | Decimals in Price | List: 7 entries
0 | = | 0
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
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
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 Cost
6 | = | Landed

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.