OEPRCLIST – Price List
- System
- Billing (BL)
- Prefix
OPL- Primary key
COMPANY,CUSTOMER,LIST-NAME,PROMOTION- Fields
- 25
- Updated by
- 0 programs
- Referenced by
- 0 programs
OEPRCLIST is the Price List table in Lawson Billing (prefix OPL). It is indexed by COMPANY, CUSTOMER, LIST-NAME, PROMOTION (OPLSET1); alternate indexes: OPLSET2, OPLSET4, OPLSET5 and OPLSET6. It is related 1:1 to ARCOMP, ARCUSTOMER, CUCODES, CUSTDESC, OECOMPANY, OEDISCOUNT, OEMISC and OEPRCLIST and 1:M to OEPLCLASS and OEPLITEM. The table has 25 fields, 5 indexes and 16 documented relations.
About OEPRCLIST
This file contains three types of records: price lists, contracts, and promotions. The difference between the records is how they are accessed. The following shows the access methods for each: Price List Contract Promotion Company Yes Yes Yes Customer No Yes No Price List Name Yes Yes, Contract ID Yes Promotion Name No No Yes
Fields (25)
Column = COBOL field name without the OPL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
OPL-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. | — |
OPL-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | — |
OPL-LIST-NAME PKLIST_NAME | Alpha 14 | User-defined name assigned to a price list. | — |
OPL-PROMOTION PKPROMOTION | Alpha 10 | User-defined name assigned to a promotion that is associated with this price list. | — |
OPL-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The description of the price list. | — |
OPL-BASE-NAMEBASE_NAME | Alpha 10 | User-defined name of the price base that this price list modifies. Price bases are defined on BL40.1 (Price Base). | — |
OPL-BEG-DATEBEG_DATE | Numeric 8 (yyyymmdd) | The beginning effective date for the promotion or contract. | — |
OPL-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | The ending effective date for the promotion or contract. | — |
OPL-MISCMISC | Alpha 16 | You can add an add-on charge to the price list that will always be assessed when the price list is used. | — |
OPL-PCTPCT | Percent 5.2 (Percent) | This default percentage (enter 90% as 90.0) will be multiplied by the base price specified for an item to arrive at an item's price. Price list percentages, assigned to sales classes or individual items will override the default pricing percentage entered here. | — |
OPL-DISC-CODEDISC_CODE | Alpha 10 | A discount code, entered using BL44.1 (Discount Code), can optionally be assigned at this level. If this has been done, the entered discount will automatically be applied when calculating the item price for items using this price list. Note: If price lists have been assigned to sales classes or to individual items, the discount (if any) assigned at these levels will be used instead. | — |
OPL-CONTRACT-DATECONTRACT_DATE | Numeric 8 (yyyymmdd) | Enter the date indicating when the contract was added to the system. | — |
OPL-CONTACTCONTACT | Alpha 20 | The name of the customer that can be contacted regarding this contract. | — |
OPL-PHONEPHONE | Alpha 15 | Customer contact phone number. | — |
OPL-PREV-CONTRACTPREV_CONTRACT | Alpha 14 | A previous number used to reference the last contract can be entered in this field. | — |
OPL-CURRENCY-CODECURRENCY_CODE | Alpha 5 | The currency this price list is meant to use. If blank, orders in any currency can be priced via this price list. | — |
OPL-CURR-RATECURR_RATE | Signed 14.7 | The currency rate that is in effect for this contract. If blank, the system will use the rate tied to the currency code in the currency tables at the time of invoicing. | — |
OPL-CUST-REFERENCCUST_REFERENC | Alpha 20 | A customer reference number, or any information that the user wants to carry on the contract. Purely informational. | — |
OPL-MIN-CONT-AMTMIN_CONT_AMT | Signed 18.2 | Enter a minimum contract amount for the contract. This minimum will print on a report that lists the actual contract sales. | — |
OPL-MAX-CONT-AMTMAX_CONT_AMT | Signed 18.2 | A maximum contract amount can be specified for the contract in this field. This maximum will print on OE293 (Contract Status Report), a report that lists the actual contract sales. | — |
OPL-ORD-DISC-FLORD_DISC_FL | Alpha 1 | This order discount flag is used only by contracts and promotions. If this flag is set to No, this indicates that any line priced with this promotion or contract will not be included in the order total when calculating the order-level discount.
| — |
OPL-MIN-ORD-AMTMIN_ORD_AMT | Signed 18.2 | This is a minimum contract amount that can be specified for the contract in this field. This minimum will print on OE293 (Contract Status Report), a report that lists the actual contract sales. This is informational only. | — |
OPL-MAX-ORD-AMTMAX_ORD_AMT | Signed 18.2 | A maximum contract amount can be specified for a contract only in this field. This maximum will print on OE293 (Contract Status Report), a report that lists the actual contract sales. | — |
OPL-SC-COUNTSC_COUNT | Numeric 4 | This field indicates the number of price list sales class price modifiers that have been established under this price list. | — |
OPL-ITEM-COUNTITEM_COUNT | Numeric 6 | This field indicates the number of price list item modifiers that have been established under this price list. | — |
Indexes (5)
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 |
|---|---|---|---|---|
OPLSET1 | COMPANY, CUSTOMER, LIST-NAME, PROMOTION | Primary | WH20.2, WH20.7 | |
OPLSET2 | COMPANY, LIST-NAME, PROMOTION | Subset | Where PROMOTION != Spaces | — |
OPLSET4 | COMPANY, CUSTOMER, LIST-NAME | Subset | Where PROMOTION = Spaces | AR08.1, AR10.1, AR501, AR550, WH130, WH132, WH190, WH20.7 +22 more |
OPLSET5 | COMPANY, CUSTOMER, END-DATE | KeyChange, Subset | Where CUSTOMER > Spaces And PCT > Zeroes | WH20.2, WH20.7 |
OPLSET6 | COMPANY, LIST-NAME, END-DATE | KeyChange, Subset | Where PROMOTION > Spaces And PCT > Zeroes | WH20.2, WH20.7 |
Relations
One to one (8) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Arcomp | ARCOMP | Required | OPL-COMPANY → ACO-COMPANY | |
| Arcustomer | ARCUSTOMER | Required | When OPL-CUSTOMER > Spaces | OPL-COMPANY → ACM-COMPANY, OPL-CUSTOMER → ACM-CUSTOMER |
| Cucodes | CUCODES | Required | When OPL-CURRENCY-CODE != Spaces | OPL-CURRENCY-CODE → CUC-CURRENCY-CODE |
| Custdesc | CUSTDESC | Required | When OPL-CUSTOMER > Spaces | ACO-CUST-GROUP → CUD-CUST-GROUP, OPL-CUSTOMER → CUD-CUSTOMER |
| Oecompany | OECOMPANY | Required | OPL-COMPANY → OEC-COMPANY | |
| Oediscount | OEDISCOUNT | Required | When OPL-DISC-CODE != Spaces | OPL-COMPANY → OED-COMPANY, OPL-DISC-CODE → OED-DISC-CODE |
| Oemisc | OEMISC | Required | When OPL-MISC != Spaces | OPL-COMPANY → OEM-COMPANY, OPL-MISC → OEM-MISC, OPL-CURRENCY-CODE → OEM-CURRENCY-CODE |
| Oeprclist | OEPRCLIST | Required | When OPL-CUSTOMER = Spaces And OPL-PROMOTION > Spaces | OPL-COMPANY → OPL-COMPANY, Spaces → OPL-CUSTOMER, OPL-LIST-NAME → OPL-LIST-NAME, Spaces → OPL-PROMOTION |
One to many (8) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Cont Classes | OEPLCLASS | Valid When OPL-CUSTOMER > Spaces | OPL-COMPANY → OPC-COMPANY, OPL-CUSTOMER → OPC-CUSTOMER, OPL-LIST-NAME → OPC-LIST-NAME, OPC-SALES-MAJCL, OPC-SALES-MINCL | |
| Cont Items | OEPLITEM | Valid When OPL-CUSTOMER > Spaces | OPL-COMPANY → OPI-COMPANY, OPL-CUSTOMER → OPI-CUSTOMER, OPL-LIST-NAME → OPI-LIST-NAME, OPI-ITEM | |
| List Classes | OEPLCLASS | Valid When OPL-CUSTOMER = Spaces And OPL-PROMOTION = Spaces | OPL-COMPANY → OPC-COMPANY, OPL-CUSTOMER → OPC-CUSTOMER, OPL-LIST-NAME → OPC-LIST-NAME, OPL-PROMOTION → OPC-PROMOTION, Spaces → OPC-SALES-MAJCL, OPC-SALES-MINCL | |
| List Items | OEPLITEM | Valid When OPL-CUSTOMER = Spaces And OPL-PROMOTION = Spaces | OPL-COMPANY → OPI-COMPANY, Spaces → OPI-CUSTOMER, OPL-LIST-NAME → OPI-LIST-NAME, Spaces → OPI-PROMOTION, OPI-ITEM | |
| Oeplclass | OEPLCLASS | Delete Cascades | OPL-COMPANY → OPC-COMPANY, OPL-CUSTOMER → OPC-CUSTOMER, OPL-LIST-NAME → OPC-LIST-NAME, OPL-PROMOTION → OPC-PROMOTION, OPC-SALES-MAJCL, OPC-SALES-MINCL | |
| Oeplitem | OEPLITEM | Delete Cascades | OPL-COMPANY → OPI-COMPANY, OPL-CUSTOMER → OPI-CUSTOMER, OPL-LIST-NAME → OPI-LIST-NAME, OPL-PROMOTION → OPI-PROMOTION, OPI-ITEM | |
| Promo Classes | OEPLCLASS | Valid When OPL-CUSTOMER = Spaces And OPL-PROMOTION > Spaces | OPL-COMPANY → OPC-COMPANY, OPL-LIST-NAME → OPC-LIST-NAME, OPL-PROMOTION → OPC-PROMOTION, OPC-SALES-MAJCL, OPC-SALES-MINCL | |
| Promo Items | OEPLITEM | Valid When OPL-CUSTOMER = Spaces And OPL-PROMOTION > Spaces | OPL-COMPANY → OPI-COMPANY, OPL-LIST-NAME → OPI-LIST-NAME, OPL-PROMOTION → OPI-PROMOTION, OPI-ITEM |
Programs
No Lawson programs are documented as updating or referencing this table.