OEPLCLASS

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
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.
OPC-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
OPC-LIST-NAME
Element: List Name
Alpha 14
Enter the identifier of the price list that is to have the price list sales class record established.
OPC-PROMOTION
Element: Promotion
Alpha 10
Enter the name of the promotion that has a sales class price modifier established.
OPC-SALES-MAJCL
Element: Major Class
Alpha 4
Sales major class code that indicates which items will be affected by this price modifier.
OPC-SALES-MINCL
Element: Minor Class
Alpha 4
Sales minor class code that indicates which items will be affected by the price modifier.
OPC-BEG-DATE
Element: Beg Date
Numeric 8 (yyyymmdd)
This is the beginning date indicating when the promotion sales class price modifier will begin.
OPC-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
This is the end date indicating when the promotion sales class price modifier will no longer be valid.
OPC-PROHIBIT-FL
Element: All Flag
Alpha 1
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
Element: All Flag
Alpha 1
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
Element: Disc Qty
Signed 9.0 Occurs 10 Times
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
Element: Pct
Percent 5.2 (Percent) Occurs 10 Times
The override pricing percentage to be used for the item order quantity break (specified in the Quantity Break field) is entered in this field.
OPC-DISC-CODE
Element: Discount Code
Alpha 10
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.
OPC-NO-CHARGE-FL
Element: No Charge Fl
Alpha 1
This field indicates the item's price is zero. This defaults to (N)o. If (Y)es, this field prevents the system from pricing the item. No charge invoices are not be passed to the Lawson Accounts Receivable system for collection.


OEPLCLASS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OPCSET1 COMPANY
CUSTOMER
LIST-NAME
PROMOTION
SALES-MAJCL
SALES-MINCL
WH20.2 WH20.7
OPCSET2 COMPANY
LIST-NAME
PROMOTION
SALES-MAJCL
SALES-MINCL
Subset
WherePROMOTION !=Spaces
OPCSET3 COMPANY
CUSTOMER
LIST-NAME
SALES-MAJCL
SALES-MINCL
Subset
WherePROMOTION =Spaces
OPCSET4 COMPANY
CUSTOMER
SALES-MAJCL
SALES-MINCL
LIST-NAME
Subset
WhereCUSTOMER !=Spaces
AndPROMOTION =Spaces
OPCSET5 COMPANY
CUSTOMER
SALES-MAJCL
SALES-MINCL
END-DATE
KeyChange, Subset
WhereCUSTOMER >Spaces
WH20.2 WH20.7
OPCSET6 COMPANY
LIST-NAME
SALES-MAJCL
SALES-MINCL
END-DATE
KeyChange, Subset
WherePROMOTION !=Spaces
WH20.2 WH20.7


OEPLCLASS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


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

Home
Contact Us



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