OEPLITEM

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


OEPLITEM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OPISET1 COMPANY
CUSTOMER
LIST-NAME
PROMOTION
ITEM
WH20.2 WH20.7
OPISET2 COMPANY
LIST-NAME
PROMOTION
ITEM
Subset
WherePROMOTION !=Spaces
AndCUSTOMER =Spaces
OPISET3 COMPANY
CUSTOMER
LIST-NAME
ITEM
Subset
WherePROMOTION =Spaces
AndCUSTOMER !=Spaces
OPISET5 COMPANY
CUSTOMER
ITEM
END-DATE
KeyChange, Subset
WhereCUSTOMER !=Spaces
AndPROMOTION =Spaces
WH20.2 WH20.7
OPISET6 COMPANY
LIST-NAME
ITEM
END-DATE
KeyChange, Subset
WherePROMOTION !=Spaces
AndCUSTOMER =Spaces
WH20.2 WH20.7


OEPLITEM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OPI-COMPANY->ACO-COMPANY
Arcustomer ARCUSTOMER Not Required
OPI-COMPANY->ACM-COMPANY
OPI-CUSTOMER->ACM-CUSTOMER
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
OPI-CUSTOMER->CUD-CUSTOMER
Iccompany ICCOMPANY Required
OPI-COMPANY->ICC-COMPANY
Itemloc ITEMLOC Not Required
OPI-COMPANY->ITL-COMPANY
Spaces->ITL-LOCATION
OPI-ITEM->ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
OPI-ITEM->ITE-ITEM
Oecompany OECOMPANY Required
OPI-COMPANY->OEC-COMPANY
Oediscount OEDISCOUNT Required
When OPI-DISC-CODE !=Spaces
OPI-COMPANY->OED-COMPANY
OPI-DISC-CODE->OED-DISC-CODE
Oeprclist OEPRCLIST Required
OPI-COMPANY->OPL-COMPANY
OPI-CUSTOMER->OPL-CUSTOMER
OPI-LIST-NAME->OPL-LIST-NAME
OPI-PROMOTION->OPL-PROMOTION
Price List OEPRCLIST Required
When OPI-PROMOTION !=Spaces
AndOPI-CUSTOMER =Spaces
OPI-COMPANY->OPL-COMPANY
Spaces->OPL-CUSTOMER
OPI-LIST-NAME->OPL-LIST-NAME
Spaces->OPL-PROMOTION


File created: Thu Jun 09 02:09:42 2016

Home
Contact Us



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