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.
UPDATED 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).

OEPLITEM FILE INDEX

OEPLITEM FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.