Price List Item
This file contains pricing/discounting parameters for specific items. These parameters override those at the price list and price list sales class level.
REFERENCED BY
WH20.2 | WH20.7 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
OPI-COMPANY Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
|
OPI-CUSTOMER Element: Customer | Alpha 9 (Right Justified) This field contains the number that represents a customer. |
|
|
OPI-LIST-NAME Element: List Name | Alpha 14 Enter the identifier of the price list that is to have the price list item record established. |
|
|
OPI-PROMOTION Element: Promotion | Alpha 10 Enter the name of the promotion that is to have an item level price modifier established. |
|
|
OPI-ITEM Element: Item | Alpha 32 The item identifier that is to be priced at the item price list level. |
|
|
OPI-BEG-DATE Element: Beg Date | Numeric 8 (yyyymmdd) This is the beginning date indicating when the promotion item price modifier will begin. |
|
|
OPI-END-DATE Element: End Date | Numeric 8 (yyyymmdd) This is the end date indicating when the promotion item price modifier will no longer be valid. |
|
|
OPI-PROHIBIT-FL Element: All Flag | Alpha 1 Indicates whether sales of the item are prohibited, meaning that no sales of this item will be allowed (unless there is an item level record pricing the item, as that level overrides the sales class records). Y = Yes N = No |
|
|
OPI-NO-CHARGE-FL Element: No Charge Fl | Alpha 1 No charge flag indicating that there will not be a charge for this item when it is priced using this record. Y = Yes N = No |
|
|
OPI-MULT-SPR-FL Element: All Flag | Alpha 1 Multiple sell price flag. The flag is set if the item has multiple pricing set in the Item Master file. If this flag is set, price break is maintained in the order line pricing UOM's file. Y = Yes N = No |
|
|
OPI-UOM-BRK-CD Element: Uom Brk Cd | Alpha 1 The unit of measure break code determines how the price list item record will modify the price base for this item if it is priced using multiple units of measure. For example, if a (P) is used, the pricing parameters below will multiply the price base by a percentage defined below. If a (U) is used, the pricing parameters below will add the add-on charge amount defined to each unit of measure. U = Unit Add-On O = Override Price P = Percentage |
|
|
OPI-UOM Element: Uom | Alpha 4 Occurs 10 Times This field contains the valid stock unit of measure for this item. |
|
|
OPI-SELL-PRICE-FL Element: Account Flag | Alpha 1 Occurs 10 Times This flag specifies if this alternate unit of measure is valid for the sell price in the Order Entry system. Valid values are: Blank = Cannot be used 1 = Valid, default on entry 2 = Valid |
|
|
OPI-PCT Element: Pct | Percent 5.2 (Percent) Occurs 10 Times This price break percentage is the percentage that should be multiplied against the price base for the item if the quantity ordered exceeds the lower limit to the left and is less than the next limit. |
|
|
OPI-UNIT-PRICE Element: Intl Cost | Signed 18.5 Occurs 10 Times The price break unit price amount that should be added to the unit price of the item if the quantity ordered exceeds the lower limit and is less than the next limit. |
|
|
OPI-ADD-UNIT-PRIC Element: Intl Cost | Signed 18.5 Occurs 10 Times This is the Price Break Add-on Unit Price Amount field that should be added to each unit of the item if the quantity ordered exceeds the lower limit to the left and is less than the next limit. |
|
|
OPI-QTY-BRK-CD Element: Qty Brk Cd | Alpha 1 The quantity pricing code determines how the price list item record will modify the price base. For example, if a (P) is used, the pricing parameters below will multiply the price base by a percentage defined below. If a (U) is used, the pricing parameters below will add the add-on charge amount defined to each unit of measure for the item ordered. U = Unit Add-On O = Override Price P = Percentage |
|
|
OPI-BRK-QTY Element: Disc Qty | Signed 9.0 Occurs 10 Times If special pricing percentages or amounts should be applied for a specific item depending on quantities ordered, the lower item order quantity limit is entered in this field. An order of an item quantity surpassing this limit and less than the next limit will be priced using the modifier found in the next series of fields. |
|
|
OPI-BRK-PCT Element: Pct | Percent 5.2 (Percent) Occurs 10 Times The percentage that should be multiplied against the price base for the item if the quantity ordered exceeds the lower limit and is less than the next limit. |
|
|
OPI-BRK-PRICE Element: Intl Cost | Signed 18.5 Occurs 10 Times This is the price break unit price amount field that should be added to the unit price of the item if the quantity ordered exceeds the lower limit and is less than the next limit. |
|
|
OPI-BRK-ADD-ON Element: Intl Cost | Signed 18.5 Occurs 10 Times The price break add-on unit price amount that should be added to each unit of the item if the quantity ordered exceeds the lower limit and is less than the next limit. |
|
|
OPI-DISC-CODE Element: Discount Code | Alpha 10 A discount code can be added at this level of the price list modifier. If you enter a discount code, the discount will automatically be applied to lines priced via this record. |
|
|
OPI-MULT-SPR-IND Element: Mult Spr Ind | Derived This is the multiple selling price indicator that tells the user that there are multiple pricing units of measure defined for this item. |
|
|
OPI-BRK-QTY-1 Element: Brk Qty 1 | Derived This is the first occurrence of the quantity breaks identified on the price list item modifier. This is used in creating BL90.1 (Pricing Inquiry). |
|
|
OPI-BRK-PRICE-1 Element: Brk Price 1 | Derived This is the first occurrence of the quantity price breaks identified on the price list item modifier. This is used in creating BL90.1 (Pricing Inquiry). |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
OPISET1 |
COMPANY CUSTOMER LIST-NAME PROMOTION ITEM |
|
| ||||||||||||||||||||
OPISET2 |
COMPANY LIST-NAME PROMOTION ITEM |
|
|||||||||||||||||||||
OPISET3 |
COMPANY CUSTOMER LIST-NAME ITEM |
|
|||||||||||||||||||||
OPISET5 |
COMPANY CUSTOMER ITEM END-DATE |
|
| ||||||||||||||||||||
OPISET6 |
COMPANY LIST-NAME ITEM END-DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arcomp | ARCOMP |
Required
| ||||||||||||||||||||||||
Arcustomer | ARCUSTOMER |
Not Required
| ||||||||||||||||||||||||
Custdesc | CUSTDESC |
Required
| ||||||||||||||||||||||||
Iccompany | ICCOMPANY |
Required
| ||||||||||||||||||||||||
Itemloc | ITEMLOC |
Not Required
| ||||||||||||||||||||||||
Itemmast | ITEMMAST |
Required
| ||||||||||||||||||||||||
Oecompany | OECOMPANY |
Required
| ||||||||||||||||||||||||
Oediscount | OEDISCOUNT |
Required
| ||||||||||||||||||||||||
Oeprclist | OEPRCLIST |
Required
| ||||||||||||||||||||||||
Price List | OEPRCLIST |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.