OEPLCLASS – Price List Sales Class

System: Billing (BL)
Prefix: OPC
Primary key: COMPANY, CUSTOMER, LIST-NAME, PROMOTION, SALES-MAJCL, SALES-MINCL
Fields: 14
Updated by: 0 programs
Referenced by: 0 programs

OEPLCLASS is the Price List Sales Class table in Lawson Billing (prefix OPC). It is indexed by COMPANY, CUSTOMER, LIST-NAME, PROMOTION, SALES-MAJCL, SALES-MINCL (OPCSET1); alternate indexes: OPCSET2, OPCSET3, OPCSET4, OPCSET5 and OPCSET6. It is related 1:1 to ARCOMP, CUSTDESC, ICCOMPANY, MAJORCL, MINORCL, OECOMPANY, OEDISCOUNT and OEPRCLIST. The table has 14 fields, 6 indexes and 9 documented relations.

About OEPLCLASS

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.

Fields (14)

Column = COBOL field name without the OPC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`OPC-COMPANY` PK 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` PK CUSTOMER	Alpha 9 (Right Justified)	This field contains the number that represents a customer.	—
`OPC-LIST-NAME` PK LIST_NAME	Alpha 14	Enter the identifier of the price list that is to have the price list sales class record established.	—
`OPC-PROMOTION` PK PROMOTION	Alpha 10	Enter the name of the promotion that has a sales class price modifier established.	—
`OPC-SALES-MAJCL` PK SALES_MAJCL	Alpha 4	Sales major class code that indicates which items will be affected by this price modifier.	—
`OPC-SALES-MINCL` PK SALES_MINCL	Alpha 4	Sales minor class code that indicates which items will be affected by the price modifier.	—
`OPC-BEG-DATE` BEG_DATE	Numeric 8 (yyyymmdd)	This is the beginning date indicating when the promotion sales class price modifier will begin.	—
`OPC-END-DATE` 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` PROHIBIT_FL	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` CLASS_PRC_FL	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` BRK_QTY	Signed 9.0 Occurs 10 Times ×10	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` BRK_PCT	Percent 5.2 (Percent) Occurs 10 Times ×10	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` DISC_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` 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.	—

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`OPCSET1`	`COMPANY`, `CUSTOMER`, `LIST-NAME`, `PROMOTION`, `SALES-MAJCL`, `SALES-MINCL`	Primary		WH20.2, WH20.7
`OPCSET2`	`COMPANY`, `LIST-NAME`, `PROMOTION`, `SALES-MAJCL`, `SALES-MINCL`	Subset	Where PROMOTION != Spaces	—
`OPCSET3`	`COMPANY`, `CUSTOMER`, `LIST-NAME`, `SALES-MAJCL`, `SALES-MINCL`	Subset	Where PROMOTION = Spaces	—
`OPCSET4`	`COMPANY`, `CUSTOMER`, `SALES-MAJCL`, `SALES-MINCL`, `LIST-NAME`	Subset	Where CUSTOMER != Spaces And PROMOTION = Spaces	—
`OPCSET5`	`COMPANY`, `CUSTOMER`, `SALES-MAJCL`, `SALES-MINCL`, `END-DATE`	KeyChange, Subset	Where CUSTOMER > Spaces	WH20.2, WH20.7
`OPCSET6`	`COMPANY`, `LIST-NAME`, `SALES-MAJCL`, `SALES-MINCL`, `END-DATE`	KeyChange, Subset	Where PROMOTION != Spaces	WH20.2, WH20.7

Relations

One to one (9) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

Programs

No Lawson programs are documented as updating or referencing this table.