|
|
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
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL243 BL245 BL246 BL247 BL29.1
BL29.2 BL31.1 BL31.2 BL31.3 BL31.5 BL31.7
BL32.3 BL32.4 BL520 BL820 BL85.1 BL85.2
BL90.1 BL92.1 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE111 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.4 OE283 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE810 OE830 WH20.2 WH20.7
UPDATED BY
BL45.1 BL45.3 BL46.1 BL46.3 BL47.1 BL47.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OPI-COMPANY Numeric 4 BL45.3 BL46.3
Element: Company Identifies the AP company if the BL47.3
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
OPI-CUSTOMER Alpha 9 (Right Justified) BL45.3 BL46.3
Element: Customer NumbeThis field contains the number that BL47.3
represents a customer.
OPI-LIST-NAME Alpha 14 BL45.3 BL46.3
Element: List Name Enter the identifier of the price list BL47.3
that is to have the price list item
record established.
OPI-PROMOTION Alpha 10 BL45.3 BL46.3
Element: Promotion Enter the name of the promotion that is BL47.3
to have an item level price modifier
established.
OPI-ITEM Alpha 32 BL45.3 BL46.3
Element: Item Number The item identifier that is to be BL47.3
priced at the item price list level.
OPI-BEG-DATE Numeric 8 (yyyymmdd) BL46.1 BL46.3
Element: Beginning DateThis is the beginning date indicating BL47.1 BL47.3
when the promotion item price modifier
will begin.
OPI-END-DATE Numeric 8 (yyyymmdd) BL46.1 BL46.3
Element: Ending Date This is the end date indicating when BL47.1 BL47.3
the promotion item price modifier will
no longer be valid.
OPI-PROHIBIT-FL Alpha 1 BL45.3 BL46.3
Element: All Flag Indicates whether sales of the item are BL47.3
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 BL45.3
Element: No Charge FlagNo 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 BL45.3 BL46.3
Element: All Flag Multiple sell price flag. The flag is BL47.3
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 BL45.3 BL46.3
Unit of Measure The unit of measure break code BL47.3
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 BL45.3 BL46.3
Element: Unit of MeasurThis field contains the valid stock BL47.3
unit of measure for this item.
OPI-SELL-PRICE-FL Alpha 1 Occurs 10 Times
Element: Account 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 BL45.3 BL46.3
Element: Percent This price break percentage is the BL47.3
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 18.5 Occurs 10 Times BL45.3 BL46.3
Element: Intl Cost The price break unit price amount that BL47.3
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 18.5 Occurs 10 Times BL45.3 BL46.3
Element: Intl Cost This is the Price Break Add-on Unit BL47.3
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 BL45.3 BL46.3
Element: Quantity BreakThe quantity pricing code determines BL47.3
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 BL45.3 BL46.3
Element: Disc Qty If special pricing percentages or BL47.3
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 BL45.3 BL46.3
Element: Percent The percentage that should be BL47.3
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 18.5 Occurs 10 Times BL45.3 BL46.3
Element: Intl Cost This is the price break unit price BL47.3
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 18.5 Occurs 10 Times BL45.3 BL46.3
Element: Intl Cost The price break add-on unit price BL47.3
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 BL45.3 BL46.3
Element: Discount Code A discount code can be added at this BL47.3
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
Element: 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
Element: 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
Element: 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 BL120 BL122
CUSTOMER BL130 BL20.1
LIST-NAME BL20.3 BL21.2
PROMOTION BL21.5 BL243
ITEM BL245 BL246
BL247 BL29.1
BL29.2 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL45.1 BL45.3
BL46.3 BL47.1
BL520 BL820
BL85.1 BL85.2
BL90.1 BL92.1
...
OPISET2 COMPANY Subset BL47.1 BL47.3
LIST-NAME Where PROMOTION != Spaces
PROMOTION And CUSTOMER = Spaces
ITEM
OPISET3 COMPANY Subset BL46.1
CUSTOMER Where PROMOTION = Spaces
LIST-NAME And CUSTOMER != Spaces
ITEM
OPISET5 COMPANY KeyChange, Subset BL120 BL122
CUSTOMER Where CUSTOMER != Spaces BL130 BL20.1
ITEM And PROMOTION = Spaces BL20.3 BL21.2
END-DATE BL21.5 BL243
BL29.1 BL29.2
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL46.1
BL46.3 BL520
BL820 BL85.1
BL85.2 BL90.1
BL92.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
...
OPISET6 COMPANY KeyChange, Subset BL120 BL122
LIST-NAME Where PROMOTION != Spaces BL130 BL20.1
ITEM And CUSTOMER = Spaces BL20.3 BL21.2
END-DATE BL21.5 BL243
BL29.1 BL29.2
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL47.1
BL47.3 BL520
BL820 BL85.1
BL85.2 BL90.1
BL92.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
...
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
|
