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
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OPC-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
OPC-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
OPC-LIST-NAME Alpha 14
List Name Enter the identifier of the price list
that is to have the price list sales
class record established.
OPC-PROMOTION Alpha 10
Promotion Enter the name of the promotion that
has a sales class price modifier
established.
OPC-SALES-MAJCL Alpha 4
Sales Major Class Sales major class code that indicates
which items will be affected by this
price modifier.
OPC-SALES-MINCL Alpha 4
Sales Minor Class Sales minor class code that indicates
which items will be affected by the
price modifier.
OPC-BEG-DATE Numeric 8 (yyyymmdd)
Beginning Date This is the beginning date indicating
when the promotion sales class price
modifier will begin.
OPC-END-DATE Numeric 8 (yyyymmdd)
Ending Date This is the end date indicating when
the promotion sales class price modifier
will no longer be valid.
OPC-PROHIBIT-FL Alpha 1
Prohibit Fl This flag indicates whether sales of
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
Class Prc Fl This class price flag indicates whether
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 10 Times
Price Break Quantity If special pricing percentages should
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 10 Times
Price Break The override pricing percentage to be
Percentage used for the item order quantity break
(specified in the Quantity Break field)
is entered in this field.
OPC-DISC-CODE Alpha 10
Disc Code A discount code can be assigned at this
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 WH20.2 WH20.7
CUSTOMER
LIST-NAME
PROMOTION
SALES-MAJCL
SALES-MINCL
OPCSET2 COMPANY Subset
LIST-NAME Where PROMOTION != Spaces
PROMOTION
SALES-MAJCL
SALES-MINCL
OPCSET3 COMPANY Subset
CUSTOMER Where PROMOTION = Spaces
LIST-NAME
SALES-MAJCL
SALES-MINCL
OPCSET4 COMPANY Subset
CUSTOMER Where CUSTOMER != Spaces
SALES-MAJCL And PROMOTION = Spaces
SALES-MINCL
LIST-NAME
OPCSET5 COMPANY KeyChange, Subset WH20.2 WH20.7
CUSTOMER Where CUSTOMER > Spaces
SALES-MAJCL
SALES-MINCL
END-DATE
OPCSET6 COMPANY KeyChange, Subset WH20.2 WH20.7
LIST-NAME Where PROMOTION != Spaces
SALES-MAJCL
SALES-MINCL
END-DATE
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
|
