Table: Item Pricing

Table: ICPRIC
View: IC0480
Record length: 537
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: 76

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
PRICESTART  Date  Price List Start Date   
PRICEEND  Date  Price List End Date   

This page was generated on 2008-May-01

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