OEPLCLASS FILE
Price List Sales Class
This file stores the price list sales class that, if used, identifies the
pricing and discounting parameters used to price all order or invoice lines
for items falling into the specified sales class. This level of pricing
overrides the prices on the price list level and is overridden by any item
level pricing parameters established.
REFERENCED BY
BL120 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 BL940 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 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE283 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810
OE830 OE920 OE950 WH20.2 WH20.7
UPDATED BY
BL45.1 BL45.2 BL46.1 BL46.2 BL47.1 BL47.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OPC-COMPANY Numeric 4 BL45.2 BL46.2
Company The company number represents an BL47.2
established company and is entered on
all function codes.
OPC-CUSTOMER Alpha 9 (Right Justified) BL45.2 BL46.2
Customer Number This field contains the number that BL47.2
represents a customer.
OPC-LIST-NAME Alpha 14 BL45.2 BL46.2
List Name Enter the identifier of the price list BL47.2
that is to have the price list sales
class record established.
OPC-PROMOTION Alpha 10 BL45.2 BL46.2
Promotion Enter the name of the promotion that BL47.2
has a sales class price modifier
established.
OPC-SALES-MAJCL Alpha 4 BL45.2 BL46.2
Sales Major Class Sales major class code that indicates BL47.2
which items will be affected by this
price modifier.
OPC-SALES-MINCL Alpha 4 BL45.2 BL46.2
Sales Minor Class Sales minor class code that indicates BL47.2
which items will be affected by the
price modifier.
OPC-BEG-DATE Numeric 8 (yyyymmdd) BL45.2 BL46.1
Beginning Date This is the beginning date indicating BL46.2 BL47.1
when the promotion sales class price BL47.2
modifier will begin.
OPC-END-DATE Numeric 8 (yyyymmdd) BL45.2 BL46.1
Ending Date This is the end date indicating when BL46.2 BL47.1
the promotion sales class price modifier BL47.2
will no longer be valid.
OPC-PROHIBIT-FL Alpha 1 BL45.2 BL46.2
Prohibit Fl This flag indicates whether sales of BL47.2
the items within the sales major and
minor classes are prohibited - meaning
no sales of these items 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
OPC-CLASS-PRC-FL Alpha 1 BL45.2 BL46.2
Class Prc Fl This class price flag indicates whether BL47.2
the items in the sales class should be
priced using amalgamation (group pricing
logic). Group pricing is explained in
detail in the Billing Procedures Manual.
N = No
Y = Yes
OPC-BRK-QTY Signed 9.0 Occurs 6 Times BL45.2 BL46.2
Price Break Quantity If special pricing percentages should BL47.2
be applied for a specific sales class
based on item quantities ordered, the
lower item order quantity limit is
entered in this field. An order for an
item quantity surpassing this limit and
less than the next limit will be priced
using the override percentage specified
in the field to the right, overriding
the default pricing percentage specified
for the sales class.
OPC-BRK-PCT Percent 5.2 (Percent) Occurs 6 Times BL45.2 BL46.2
Price Break The override pricing percentage to be BL47.2
Percentage used for the item order quantity break
(specified in the Quantity Break field)
is entered in this field.
OPC-DISC-CODE Alpha 10 BL45.2 BL46.2
Disc Code A discount code can be assigned at this BL47.2
level. If this has been done, the
entered discount will automatically be
applied to lines priced via this record.
OEPLCLASS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OPCSET1 COMPANY BL120 BL130
CUSTOMER BL20.1 BL20.3
LIST-NAME BL21.2 BL21.5
PROMOTION BL243 BL245
SALES-MAJCL BL246 BL247
SALES-MINCL BL29.1 BL29.2
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.3
BL32.4 BL45.1
BL45.2 BL46.2
BL47.1 BL520
BL820 BL85.1
BL85.2 BL90.1
BL92.1 BL940
...
OPCSET2 COMPANY Subset BL47.1 BL47.2
LIST-NAME Where PROMOTION != Spaces
PROMOTION
SALES-MAJCL
SALES-MINCL
OPCSET3 COMPANY Subset BL46.1 BL46.2
CUSTOMER Where PROMOTION = Spaces
LIST-NAME
SALES-MAJCL
SALES-MINCL
OPCSET4 COMPANY Subset BL46.2
CUSTOMER Where CUSTOMER != Spaces
SALES-MAJCL And PROMOTION = Spaces
SALES-MINCL
LIST-NAME
OPCSET5 COMPANY KeyChange, Subset BL120 BL130
CUSTOMER Where CUSTOMER > Spaces BL20.1 BL20.3
SALES-MAJCL BL21.2 BL21.5
SALES-MINCL BL243 BL29.1
END-DATE BL29.2 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL46.1 BL520
BL820 BL85.1
BL85.2 BL90.1
BL92.1 BL940
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
...
OPCSET6 COMPANY KeyChange, Subset BL120 BL130
LIST-NAME Where PROMOTION != Spaces BL20.1 BL20.3
SALES-MAJCL BL21.2 BL21.5
SALES-MINCL BL243 BL29.1
END-DATE BL29.2 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.3 BL32.4
BL47.1 BL47.2
BL520 BL820
BL85.1 BL85.2
BL90.1 BL92.1
BL940 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
...
OEPLCLASS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OPC-COMPANY -> ACO-COMPANY
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
OPC-CUSTOMER -> CUD-CUSTOMER
Iccompany ICCOMPANY Required
OPC-COMPANY -> ICC-COMPANY
Majorcl MAJORCL Required
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
OPC-SALES-MAJCL -> MAJ-MAJOR-CLASS
Minorcl MINORCL Required
When OPC-SALES-MINCL != Spaces
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
OPC-SALES-MAJCL -> MIN-MAJOR-CLASS
OPC-SALES-MINCL -> MIN-MINOR-CLASS
Oecompany OECOMPANY Required
OPC-COMPANY -> OEC-COMPANY
Oediscount OEDISCOUNT Required
When OPC-DISC-CODE != Spaces
OPC-COMPANY -> OED-COMPANY
OPC-DISC-CODE -> OED-DISC-CODE
Oeprclist OEPRCLIST Required
OPC-COMPANY -> OPL-COMPANY
OPC-CUSTOMER -> OPL-CUSTOMER
OPC-LIST-NAME -> OPL-LIST-NAME
OPC-PROMOTION -> OPL-PROMOTION
Price List OEPRCLIST Required
When OPC-PROMOTION != Spaces
OPC-COMPANY -> OPL-COMPANY
Spaces -> OPL-CUSTOMER
OPC-LIST-NAME -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
|