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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#OPC-COMPANY PKCOMPANY | 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 PKCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | — |
#OPC-LIST-NAME PKLIST_NAME | Alpha 14 | Enter the identifier of the price list that is to have the price list sales class record established. | — |
#OPC-PROMOTION PKPROMOTION | Alpha 10 | Enter the name of the promotion that has a sales class price modifier established. | — |
#OPC-SALES-MAJCL PKSALES_MAJCL | Alpha 4 | Sales major class code that indicates which items will be affected by this price modifier. | — |
#OPC-SALES-MINCL PKSALES_MINCL | Alpha 4 | Sales minor class code that indicates which items will be affected by the price modifier. | — |
#OPC-BEG-DATEBEG_DATE | Numeric 8 (yyyymmdd) | This is the beginning date indicating when the promotion sales class price modifier will begin. | — |
#OPC-END-DATE SET5 SET6END_DATE | Numeric 8 (yyyymmdd) | This is the end date indicating when the promotion sales class price modifier will no longer be valid. | — |
#OPC-PROHIBIT-FLPROHIBIT_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).
| — |
#OPC-CLASS-PRC-FLCLASS_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.
| — |
#OPC-BRK-QTYBRK_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-PCTBRK_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-CODEDISC_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-FLNO_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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OPCSET1 |
| Primary | WH20.2, WH20.7 | |
OPCSET2 |
| Subset | Where PROMOTION != Spaces | — |
OPCSET3 |
| Subset | Where PROMOTION = Spaces | — |
OPCSET4 |
| Subset | Where CUSTOMER != Spaces And PROMOTION = Spaces | — |
OPCSET5 |
| KeyChange, Subset | Where CUSTOMER > Spaces | WH20.2, WH20.7 |
OPCSET6 |
| 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 |
| |||||||||||||
| Custdesc | CUSTDESC | Required |
| |||||||||||||
| Iccompany | ICCOMPANY | Required |
| |||||||||||||
| Majorcl | MAJORCL | Required |
| |||||||||||||
| Minorcl | MINORCL | Required | When OPC-SALES-MINCL != Spaces |
| ||||||||||||
| Oecompany | OECOMPANY | Required |
| |||||||||||||
| Oediscount | OEDISCOUNT | Required | When OPC-DISC-CODE != Spaces |
| ||||||||||||
| Oeprclist | OEPRCLIST | Required |
| |||||||||||||
| Price List | OEPRCLIST | Required | When OPC-PROMOTION != Spaces |
|
Programs
No Lawson programs are documented as updating or referencing this table.