What field in IC item pricing table determines discount by percentage or by amount?
What field in IC item pricing table determines discount by percentage or by amount?
ICPRIC.PRICEFMT. 1 = Percentage, 2 = Amount
Here are all the fields:
Roto ID:IC0480 DLL Name: ICPRIC Item Pricing
View Composition - 11 view(s)
IC0490 - ICPRTX Price List Tax Authorities
IC0310 - VI0500 Items
IC0390 - ICPCOD Price List Codes
IC0750 - ICUNIT Units of Measure
IC0395 - ICPCTX Price List Code Tax Authorities
TX0002 - TXAUTH Tax Authorities
IC0481 - ICPRICC Pricing Price Checks
IC0482 - ICPRICP Item Pricing Details
IC0758 - ICWCOD Weight Units of Measure
IC0392 - ICPCODC Price List Codes Checks
IC0290 - ICILOC Location Details
Index List - 3 Index(es)
0 - Currency Code
CURRENCY, ITEMNO, PRICELIST
1 - Item Number
ITEMNO, CURRENCY, PRICELIST
2 - Price List Code
CURRENCY, PRICELIST, ITEMNO
Field List - 90 fields
Name Type Size Prec Description Index Attrib Initial Value
CURRENCY String 3 0 Currency Code 1 RKEA USD
Mask Presentation - %-3N
ITEMNO String 24 0 Unformatted Item Number 2 RKEA
Mask Presentation - %-24C
PRICELIST String 6 0 Price List Code 3 RKEA
Mask Presentation - %-6N
DESC String 60 0 Description 4 EA
PRICEDECS Integer 2 0 Decimals in Price 5 EA 2
List Presentation with 7 items in the list:
0 - 0
1 - 1
2 - 2
3 - 3
4 - 4
5 - 5
6 - 6
MARKUPCOST BCD 10 6 Markup Cost 14 EA 0
MARKUPUNIT String 10 0 Markup Unit of Measure 15 EA
Mask Presentation - %-10w
MARKUPCONV BCD 10 6 Markup Conversion Factor 16 EA 0
PRICETYPE Integer 2 0 Selling Price Based on 17 EAP 1
List Presentation with 7 items in the list:
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 2 0 Discount/Markup Price by 18 EA 1
List Presentation with 2 items in the list:
1 - Percentage
2 - Amount
PRCNTLVL1 BCD 5 5 Discount/Markup Percentage 1 19 EA 0
PRCNTLVL2 BCD 5 5 Discount/Markup Percentage 2 20 EA 0
PRCNTLVL3 BCD 5 5 Discount/Markup Percentage 3 21 EA 0
PRCNTLVL4 BCD 5 5 Discount/Markup Percentage 4 22 EA 0
PRCNTLVL5 BCD 5 5 Discount/Markup Percentage 5 23 EA 0
PRICEBASE Integer 2 0 Price Determined by 24 EA 1
List Presentation with 2 items in the list:
1 - Customer Type
2 - Volume Discounts
PRICEQTY1 BCD 10 4 Quantity Level 1 25 EA 0
PRICEQTY2 BCD 10 4 Quantity Level 2 26 EA 0
PRICEQTY3 BCD 10 4 Quantity Level 3 27 EA 0
PRICEQTY4 BCD 10 4 Quantity Level 4 28 EA 0
PRICEQTY5 BCD 10 4 Quantity Level 5 29 EA 0
MARKUP BCD 5 5 Markup Factor 30 EA 1
LASTMKPDT Date 5 0 Last Markup Cost Change Date 33 EA
PREVMKPCST BCD 10 6 Previous Markup Cost 34 EA 0
LASTEXCHDT Date 5 0 Last Exchange Rate Change Date 35 EA
PREVEXCHRT BCD 8 7 Previous Exchange Rate 36 EA 0
ROUNDMETHD Integer 2 0 Rounding Method 37 EA 1
List Presentation with 3 items in the list:
1 - No Rounding
2 - Round Up
3 - Round Down
ROUNDAMT BCD 10 6 Round to a Multiple of 38 EA 0
AMOUNTLVL1 BCD 10 6 Discount/Markup Amount 1 39 EA 0
AMOUNTLVL2 BCD 10 6 Discount/Markup Amount 2 40 EA 0
AMOUNTLVL3 BCD 10 6 Discount/Markup Amount 3 41 EA 0
AMOUNTLVL4 BCD 10 6 Discount/Markup Amount 4 42 EA 0
AMOUNTLVL5 BCD 10 6 Discount/Markup Amount 5 43 EA 0
PRICEBY Integer 2 0 Price By 44 EAX 1
List Presentation with 2 items in the list:
1 - Quantity
2 - Weight
MRKUPWUNIT String 10 0 Markup Weight Unit of Measure 45 EA
Mask Presentation - %-10w
PRICEWGHT1 BCD 10 4 Weight Level 1 46 EA 0
PRICEWGHT2 BCD 10 4 Weight Level 2 47 EA 0
PRICEWGHT3 BCD 10 4 Weight Level 3 48 EA 0
PRICEWGHT4 BCD 10 4 Weight Level 4 49 EA 0
PRICEWGHT5 BCD 10 4 Weight Level 5 50 EA 0
CPRICETYPE Integer 2 0 Price Check Type 51 EA 0
List Presentation with 4 items in the list:
0 - None
1 - Warning
2 - Error
3 - Approval
CCHECK Integer 2 0 Check 52 EA 1
List Presentation with 2 items in the list:
1 - Unit Price
2 - Sales Margin
CCHECKBASE Integer 2 0 Check Base 53 EAP 1
List Presentation with 3 items in the list:
1 - Cost Plus a Percentage
2 - Cost Plus a Fixed Amount
3 - Fixed Amount
CBASE Integer 2 0 Cost/Margin Base 54 EAP 1
List Presentation with 6 items in the list:
1 - Markup Cost
2 - Standard Cost
3 - Most Recent Cost
4 - Average Cost
5 - Last Unit Cost
6 - Landed
DEFBUNIT String 10 0 Default Base Unit 55 CEA
Mask Presentation - %-10w
DEFBWUNIT String 10 0 Default Base Weight Unit 56 CEA
Mask Presentation - %-10w
DEFSUNIT String 10 0 Default Sale Unit 57 CEA
Mask Presentation - %-10w
DEFSWUNIT String 10 0 Default Sale Weight Unit 58 CEA
Mask Presentation - %-10w
STOCKITEM Boolean 2 0 Stock Item 59 CA True
List Presentation with 2 items in the list:
False - No
True - Yes
DBASEPRICE BCD 10 6 Base Price 60 EA 0
DBASEUNIT String 10 0 Pricing Unit of Measure 61 EA
Mask Presentation - %-10w
DBASEWUNIT String 10 0 Pricing Weight Unit of Measure 62 EA
Mask Presentation - %-10w
DBASECONV BCD 10 6 Base Conversion Factor 63 EA 1
DSALEPRICE BCD 10 6 Sale Price 64 EA 0
DSALEUNIT String 10 0 Sale Unit of Measure 65 EA
Mask Presentation - %-10w
DSALEWUNIT String 10 0 Sale Weight Unit of Measure 66 EA
Mask Presentation - %-10w
DSALECONV BCD 10 6 Sale Conversion Factor 67 EA 1
DSALESTART Date 5 0 Sale Start Date 68 EA
DSALEEND Date 5 0 Sale End Date 69 EA
FMTITEMNO String 24 0 Item Number 70 CA
Mask Presentation - %-24C
STOCKUNIT String 10 0 Stocking Unit of Measure 71 CA
Mask Presentation - %-10w
BPRICETYPE Integer 2 0 Base Price Type 72 EAP 1
List Presentation with 3 items in the list:
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 2 0 Default Base Price Using 73 EAP 0
List Presentation with 3 items in the list:
0 - No Default
1 - Cost Plus a Percentage
2 - Cost Plus an Amount
BLOCATION String 6 0 Base Location 74 EA
Mask Presentation - %-6N
BBASE Integer 2 0 Base Cost Base 75 EAP 1
List Presentation with 5 items in the list:
1 - Standard Cost
2 - Most Recent Cost
3 - Average Cost
4 - Last Unit Cost
5 - Landed
BPERCENT BCD 5 5 Base Percentage 76 EA 0
BAMOUNT BCD 10 6 Base Amount 77 EA 0
BRATETYPE String 2 0 Base Rate Type 78 EA SP
Mask Presentation - %-2N
BRATEDATE Date 5 0 Base Rate Date 79 EA 10/17/2018
BEXCHRATE BCD 8 7 Base Exchange Rate 80 EA 1
BRATEOP Integer 2 0 Base Rate Operator 81 CEA 1
List Presentation with 2 items in the list:
1 - Multiply
2 - Divide
BRATEOVRRD Boolean 2 0 Base Rate Overidden 82 EA False
List Presentation with 2 items in the list:
False - No
True - Yes
SPRICETYPE Integer 2 0 Sale Price Type 83 EAP 1
List Presentation with 3 items in the list:
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 2 0 Default Sale Price Using 84 EAP 0
List Presentation with 3 items in the list:
0 - No Default
1 - Cost Plus a Percentage
2 - Cost Plus an Amount
SLOCATION String 6 0 Sale Location 85 EA
Mask Presentation - %-6N
SBASE Integer 2 0 Sale Cost Base 86 EAP 1
List Presentation with 5 items in the list:
1 - Standard Cost
2 - Most Recent Cost
3 - Average Cost
4 - Last Unit Cost
5 - Landed
SPERCENT BCD 5 5 Sale Percentage 87 EA 0
SAMOUNT BCD 10 6 Sale Amount 88 EA 0
SRATETYPE String 2 0 Sale Rate Type 89 EA SP
Mask Presentation - %-2N
SRATEDATE Date 5 0 Sale Rate Date 90 EA 10/17/2018
SEXCHRATE BCD 8 7 Sale Exchange Rate 91 EA 1
SRATEOP Integer 2 0 Sale Rate Operator 92 CEA 1
List Presentation with 2 items in the list:
1 - Multiply
2 - Divide
SRATEOVRRD Boolean 2 0 Sale Rate Overidden 93 EA False
List Presentation with 2 items in the list:
False - No
True - Yes
PROCESSCMD Integer 2 0 Process Command 94 CEA 0
List Presentation with 5 items in the list:
0 - Nothing to Process
1 - Default the Base Price
2 - Default the Sale Price
3 - Set Price List Maintenance Status
4 - Reset Price List Maintenance Status
CHECKITEM Boolean 2 0 Check Item Existence 95 CEA True
List Presentation with 2 items in the list:
False - No
True - Yes
BRATEEXIST Integer 2 0 Calc. Base Exch. Rate Exists 96 CA 0
List Presentation with 3 items in the list:
0 - Rate does not exist
1 - Rate exists
2 - Rate is calculated
SRATEEXIST Integer 2 0 Calc. Sale Exch. Rate Exists 97 CA 0
List Presentation with 3 items in the list:
0 - Rate does not exist
1 - Rate exists
2 - Rate is calculated
LOCCOSTOK Boolean 2 0 Item Location Cost Allowable 98 CA True
List Presentation with 2 items in the list:
False - No
True - Yes
PRICESTART Date 5 0 Price List Start Date 99 EA
PRICEEND Date 5 0 Price List End Date 100 EA
ICPRIC.PRICEFMT. 1 = Percentage, 2 = Amount
Here are all the fields:
Roto ID:IC0480 DLL Name: ICPRIC Item Pricing
View Composition - 11 view(s)
IC0490 - ICPRTX Price List Tax Authorities
IC0310 - VI0500 Items
IC0390 - ICPCOD Price List Codes
IC0750 - ICUNIT Units of Measure
IC0395 - ICPCTX Price List Code Tax Authorities
TX0002 - TXAUTH Tax Authorities
IC0481 - ICPRICC Pricing Price Checks
IC0482 - ICPRICP Item Pricing Details
IC0758 - ICWCOD Weight Units of Measure
IC0392 - ICPCODC Price List Codes Checks
IC0290 - ICILOC Location Details
Index List - 3 Index(es)
0 - Currency Code
CURRENCY, ITEMNO, PRICELIST
1 - Item Number
ITEMNO, CURRENCY, PRICELIST
2 - Price List Code
CURRENCY, PRICELIST, ITEMNO
Field List - 90 fields
Name Type Size Prec Description Index Attrib Initial Value
CURRENCY String 3 0 Currency Code 1 RKEA USD
Mask Presentation - %-3N
ITEMNO String 24 0 Unformatted Item Number 2 RKEA
Mask Presentation - %-24C
PRICELIST String 6 0 Price List Code 3 RKEA
Mask Presentation - %-6N
DESC String 60 0 Description 4 EA
PRICEDECS Integer 2 0 Decimals in Price 5 EA 2
List Presentation with 7 items in the list:
0 - 0
1 - 1
2 - 2
3 - 3
4 - 4
5 - 5
6 - 6
MARKUPCOST BCD 10 6 Markup Cost 14 EA 0
MARKUPUNIT String 10 0 Markup Unit of Measure 15 EA
Mask Presentation - %-10w
MARKUPCONV BCD 10 6 Markup Conversion Factor 16 EA 0
PRICETYPE Integer 2 0 Selling Price Based on 17 EAP 1
List Presentation with 7 items in the list:
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 2 0 Discount/Markup Price by 18 EA 1
List Presentation with 2 items in the list:
1 - Percentage
2 - Amount
PRCNTLVL1 BCD 5 5 Discount/Markup Percentage 1 19 EA 0
PRCNTLVL2 BCD 5 5 Discount/Markup Percentage 2 20 EA 0
PRCNTLVL3 BCD 5 5 Discount/Markup Percentage 3 21 EA 0
PRCNTLVL4 BCD 5 5 Discount/Markup Percentage 4 22 EA 0
PRCNTLVL5 BCD 5 5 Discount/Markup Percentage 5 23 EA 0
PRICEBASE Integer 2 0 Price Determined by 24 EA 1
List Presentation with 2 items in the list:
1 - Customer Type
2 - Volume Discounts
PRICEQTY1 BCD 10 4 Quantity Level 1 25 EA 0
PRICEQTY2 BCD 10 4 Quantity Level 2 26 EA 0
PRICEQTY3 BCD 10 4 Quantity Level 3 27 EA 0
PRICEQTY4 BCD 10 4 Quantity Level 4 28 EA 0
PRICEQTY5 BCD 10 4 Quantity Level 5 29 EA 0
MARKUP BCD 5 5 Markup Factor 30 EA 1
LASTMKPDT Date 5 0 Last Markup Cost Change Date 33 EA
PREVMKPCST BCD 10 6 Previous Markup Cost 34 EA 0
LASTEXCHDT Date 5 0 Last Exchange Rate Change Date 35 EA
PREVEXCHRT BCD 8 7 Previous Exchange Rate 36 EA 0
ROUNDMETHD Integer 2 0 Rounding Method 37 EA 1
List Presentation with 3 items in the list:
1 - No Rounding
2 - Round Up
3 - Round Down
ROUNDAMT BCD 10 6 Round to a Multiple of 38 EA 0
AMOUNTLVL1 BCD 10 6 Discount/Markup Amount 1 39 EA 0
AMOUNTLVL2 BCD 10 6 Discount/Markup Amount 2 40 EA 0
AMOUNTLVL3 BCD 10 6 Discount/Markup Amount 3 41 EA 0
AMOUNTLVL4 BCD 10 6 Discount/Markup Amount 4 42 EA 0
AMOUNTLVL5 BCD 10 6 Discount/Markup Amount 5 43 EA 0
PRICEBY Integer 2 0 Price By 44 EAX 1
List Presentation with 2 items in the list:
1 - Quantity
2 - Weight
MRKUPWUNIT String 10 0 Markup Weight Unit of Measure 45 EA
Mask Presentation - %-10w
PRICEWGHT1 BCD 10 4 Weight Level 1 46 EA 0
PRICEWGHT2 BCD 10 4 Weight Level 2 47 EA 0
PRICEWGHT3 BCD 10 4 Weight Level 3 48 EA 0
PRICEWGHT4 BCD 10 4 Weight Level 4 49 EA 0
PRICEWGHT5 BCD 10 4 Weight Level 5 50 EA 0
CPRICETYPE Integer 2 0 Price Check Type 51 EA 0
List Presentation with 4 items in the list:
0 - None
1 - Warning
2 - Error
3 - Approval
CCHECK Integer 2 0 Check 52 EA 1
List Presentation with 2 items in the list:
1 - Unit Price
2 - Sales Margin
CCHECKBASE Integer 2 0 Check Base 53 EAP 1
List Presentation with 3 items in the list:
1 - Cost Plus a Percentage
2 - Cost Plus a Fixed Amount
3 - Fixed Amount
CBASE Integer 2 0 Cost/Margin Base 54 EAP 1
List Presentation with 6 items in the list:
1 - Markup Cost
2 - Standard Cost
3 - Most Recent Cost
4 - Average Cost
5 - Last Unit Cost
6 - Landed
DEFBUNIT String 10 0 Default Base Unit 55 CEA
Mask Presentation - %-10w
DEFBWUNIT String 10 0 Default Base Weight Unit 56 CEA
Mask Presentation - %-10w
DEFSUNIT String 10 0 Default Sale Unit 57 CEA
Mask Presentation - %-10w
DEFSWUNIT String 10 0 Default Sale Weight Unit 58 CEA
Mask Presentation - %-10w
STOCKITEM Boolean 2 0 Stock Item 59 CA True
List Presentation with 2 items in the list:
False - No
True - Yes
DBASEPRICE BCD 10 6 Base Price 60 EA 0
DBASEUNIT String 10 0 Pricing Unit of Measure 61 EA
Mask Presentation - %-10w
DBASEWUNIT String 10 0 Pricing Weight Unit of Measure 62 EA
Mask Presentation - %-10w
DBASECONV BCD 10 6 Base Conversion Factor 63 EA 1
DSALEPRICE BCD 10 6 Sale Price 64 EA 0
DSALEUNIT String 10 0 Sale Unit of Measure 65 EA
Mask Presentation - %-10w
DSALEWUNIT String 10 0 Sale Weight Unit of Measure 66 EA
Mask Presentation - %-10w
DSALECONV BCD 10 6 Sale Conversion Factor 67 EA 1
DSALESTART Date 5 0 Sale Start Date 68 EA
DSALEEND Date 5 0 Sale End Date 69 EA
FMTITEMNO String 24 0 Item Number 70 CA
Mask Presentation - %-24C
STOCKUNIT String 10 0 Stocking Unit of Measure 71 CA
Mask Presentation - %-10w
BPRICETYPE Integer 2 0 Base Price Type 72 EAP 1
List Presentation with 3 items in the list:
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 2 0 Default Base Price Using 73 EAP 0
List Presentation with 3 items in the list:
0 - No Default
1 - Cost Plus a Percentage
2 - Cost Plus an Amount
BLOCATION String 6 0 Base Location 74 EA
Mask Presentation - %-6N
BBASE Integer 2 0 Base Cost Base 75 EAP 1
List Presentation with 5 items in the list:
1 - Standard Cost
2 - Most Recent Cost
3 - Average Cost
4 - Last Unit Cost
5 - Landed
BPERCENT BCD 5 5 Base Percentage 76 EA 0
BAMOUNT BCD 10 6 Base Amount 77 EA 0
BRATETYPE String 2 0 Base Rate Type 78 EA SP
Mask Presentation - %-2N
BRATEDATE Date 5 0 Base Rate Date 79 EA 10/17/2018
BEXCHRATE BCD 8 7 Base Exchange Rate 80 EA 1
BRATEOP Integer 2 0 Base Rate Operator 81 CEA 1
List Presentation with 2 items in the list:
1 - Multiply
2 - Divide
BRATEOVRRD Boolean 2 0 Base Rate Overidden 82 EA False
List Presentation with 2 items in the list:
False - No
True - Yes
SPRICETYPE Integer 2 0 Sale Price Type 83 EAP 1
List Presentation with 3 items in the list:
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 2 0 Default Sale Price Using 84 EAP 0
List Presentation with 3 items in the list:
0 - No Default
1 - Cost Plus a Percentage
2 - Cost Plus an Amount
SLOCATION String 6 0 Sale Location 85 EA
Mask Presentation - %-6N
SBASE Integer 2 0 Sale Cost Base 86 EAP 1
List Presentation with 5 items in the list:
1 - Standard Cost
2 - Most Recent Cost
3 - Average Cost
4 - Last Unit Cost
5 - Landed
SPERCENT BCD 5 5 Sale Percentage 87 EA 0
SAMOUNT BCD 10 6 Sale Amount 88 EA 0
SRATETYPE String 2 0 Sale Rate Type 89 EA SP
Mask Presentation - %-2N
SRATEDATE Date 5 0 Sale Rate Date 90 EA 10/17/2018
SEXCHRATE BCD 8 7 Sale Exchange Rate 91 EA 1
SRATEOP Integer 2 0 Sale Rate Operator 92 CEA 1
List Presentation with 2 items in the list:
1 - Multiply
2 - Divide
SRATEOVRRD Boolean 2 0 Sale Rate Overidden 93 EA False
List Presentation with 2 items in the list:
False - No
True - Yes
PROCESSCMD Integer 2 0 Process Command 94 CEA 0
List Presentation with 5 items in the list:
0 - Nothing to Process
1 - Default the Base Price
2 - Default the Sale Price
3 - Set Price List Maintenance Status
4 - Reset Price List Maintenance Status
CHECKITEM Boolean 2 0 Check Item Existence 95 CEA True
List Presentation with 2 items in the list:
False - No
True - Yes
BRATEEXIST Integer 2 0 Calc. Base Exch. Rate Exists 96 CA 0
List Presentation with 3 items in the list:
0 - Rate does not exist
1 - Rate exists
2 - Rate is calculated
SRATEEXIST Integer 2 0 Calc. Sale Exch. Rate Exists 97 CA 0
List Presentation with 3 items in the list:
0 - Rate does not exist
1 - Rate exists
2 - Rate is calculated
LOCCOSTOK Boolean 2 0 Item Location Cost Allowable 98 CA True
List Presentation with 2 items in the list:
False - No
True - Yes
PRICESTART Date 5 0 Price List Start Date 99 EA
PRICEEND Date 5 0 Price List End Date 100 EA
*Community Hub is the new name for Sage City