OEPLITEM FILE
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 Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
OPI-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
OPI-LIST-NAME Alpha 14
List Name Enter the identifier of the price list
that is to have the price list item
record established.
OPI-PROMOTION Alpha 10
Promotion Enter the name of the promotion that is
to have an item level price modifier
established.
OPI-ITEM Alpha 32
Item Number The item identifier that is to be
priced at the item price list level.
OPI-BEG-DATE Numeric 8 (yyyymmdd)
Beginning Date This is the beginning date indicating
when the promotion item price modifier
will begin.
OPI-END-DATE Numeric 8 (yyyymmdd)
Ending Date This is the end date indicating when
the promotion item price modifier will
no longer be valid.
OPI-PROHIBIT-FL Alpha 1
Prohibit Fl 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 Alpha 1
No Charge Flag 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 Alpha 1
Mult Spr Fl 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 Alpha 1
Unit of Measure The unit of measure break code
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 Alpha 4 Occurs 10 Times
Unit of Measure This field contains the valid stock
unit of measure for this item.
OPI-SELL-PRICE-FL Alpha 1 Occurs 10 Times
Sell Price Flag 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 Percent 5.2 (Percent) Occurs 10 Times
Percent 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 Signed 13.5 Occurs 10 Times
Unit Price 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 Signed 13.5 Occurs 10 Times
Add On Unit Price This is the Price Break Add-on Unit
Amount 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 Alpha 1
Quantity Break Code 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 Signed 9.0 Occurs 10 Times
Price Break Quantity 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 Percent 5.2 (Percent) Occurs 10 Times
Price Break The percentage that should be
Percentage 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 Signed 13.5 Occurs 10 Times
Price Break Price 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 Signed 13.5 Occurs 10 Times
Brk Add On 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 Alpha 10
Disc Code 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 Derived
Mult Spr Ind 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 Derived
Brk Qty 1 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 Derived
Brk Price 1 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 WH20.2 WH20.7
CUSTOMER
LIST-NAME
PROMOTION
ITEM
OPISET2 COMPANY Subset
LIST-NAME Where PROMOTION != Spaces
PROMOTION And CUSTOMER = Spaces
ITEM
OPISET3 COMPANY Subset
CUSTOMER Where PROMOTION = Spaces
LIST-NAME And CUSTOMER != Spaces
ITEM
OPISET5 COMPANY KeyChange, Subset WH20.2 WH20.7
CUSTOMER Where CUSTOMER != Spaces
ITEM And PROMOTION = Spaces
END-DATE
OPISET6 COMPANY KeyChange, Subset WH20.2 WH20.7
LIST-NAME Where PROMOTION != Spaces
ITEM And CUSTOMER = Spaces
END-DATE
OEPLITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
And OPI-CUSTOMER = Spaces
OPI-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPI-LIST-NAME -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
|
