| 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
|
| 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
|
| 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
|
| BRATEOVRRD |
Boolean |
Base Rate Overidden |
List: 2 entries
|
| 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
|
| SRATEOVRRD |
Boolean |
Sale Rate Overidden |
List: 2 entries
|
| PRICESTART |
Date |
Price List Start Date |
|
| PRICEEND |
Date |
Price List End Date |
|
|