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: 6 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
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: 5 entries
1=Markup Cost
2=Standard Cost
3=Most Recent Cost
4=Average Cost
5=Last Cost

This page was generated on 2009-Nov-19

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