Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEPLCLASS


                             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

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL243     BL245     BL246     BL247     BL29.1
BL29.2    BL31.1    BL31.2    BL31.3    BL31.5    BL31.7
BL32.3    BL32.4    BL520     BL820     BL85.1    BL85.2
BL90.1    BL92.1    OE10.1    OE10.2    OE10.3    OE10.4
OE10.5    OE10.6    OE10.7    OE10.8    OE11.1    OE11.4
OE11.8    OE11.9    OE110     OE111     OE113     OE114
OE116     OE129     OE13.2    OE13.3    OE13.5    OE13.6
OE14.4    OE283     OE30.1    OE30.2    OE30.3    OE30.4
OE30.5    OE30.6    OE30.7    OE30.9    OE510     OE530
OE810     OE830     WH20.2    WH20.7

UPDATED BY

BL45.1    BL45.2    BL46.1    BL46.2    BL47.1    BL47.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OPC-COMPANY            Numeric 4                                 BL45.2  BL46.2
Element: Company       Identifies the AP company if the          BL47.2
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OPC-CUSTOMER           Alpha 9  (Right Justified)                BL45.2  BL46.2
Element: Customer NumbeThis field contains the number that       BL47.2
                       represents a customer.

OPC-LIST-NAME          Alpha 14                                  BL45.2  BL46.2
Element: List Name     Enter the identifier of the price list    BL47.2
                       that is to have the price list sales
                       class record established.

OPC-PROMOTION          Alpha 10                                  BL45.2  BL46.2
Element: Promotion     Enter the name of the promotion that      BL47.2
                       has a sales class price modifier
                       established.

OPC-SALES-MAJCL        Alpha 4                                   BL45.2  BL46.2
Element: Major Class   Sales major class code that indicates     BL47.2
                       which items will be affected by this
                       price modifier.

OPC-SALES-MINCL        Alpha 4                                   BL45.2  BL46.2
Element: Minor Class   Sales minor class code that indicates     BL47.2
                       which items will be affected by the
                       price modifier.

OPC-BEG-DATE           Numeric 8  (yyyymmdd)                     BL45.2  BL46.1
Element: Beginning DateThis is the beginning date indicating     BL46.2  BL47.1
                       when the promotion sales class price      BL47.2
                       modifier will begin.

OPC-END-DATE           Numeric 8  (yyyymmdd)                     BL45.2  BL46.1
Element: Ending Date   This is the end date indicating when      BL46.2  BL47.1
                       the promotion sales class price modifier  BL47.2
                       will no longer be valid.

OPC-PROHIBIT-FL        Alpha 1                                   BL45.2  BL46.2
Element: All Flag      This flag indicates whether sales of      BL47.2
                       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                                   BL45.2  BL46.2
Element: All Flag      This class price flag indicates whether   BL47.2
                       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                BL45.2  BL46.2
Element: Disc Qty      If special pricing percentages should     BL47.2
                       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    BL45.2  BL46.2
Element: Percent       The override pricing percentage to be     BL47.2
                       used for the item order quantity break
                       (specified in the Quantity Break field)
                       is entered in this field.

OPC-DISC-CODE          Alpha 10                                  BL45.2  BL46.2
Element: Discount Code A discount code can be assigned at this   BL47.2
                       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                                                BL120   BL122
          CUSTOMER                                               BL130   BL20.1
          LIST-NAME                                              BL20.3  BL21.2
          PROMOTION                                              BL21.5  BL243
          SALES-MAJCL                                            BL245   BL246
          SALES-MINCL                                            BL247   BL29.1
                                                                 BL29.2  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL45.1  BL45.2
                                                                 BL46.2  BL47.1
                                                                 BL520   BL820
                                                                 BL85.1  BL85.2
                                                                 BL90.1  BL92.1
                                                                 ...

OPCSET2   COMPANY       Subset                                   BL47.1  BL47.2
          LIST-NAME     Where PROMOTION != Spaces
          PROMOTION
          SALES-MAJCL
          SALES-MINCL

OPCSET3   COMPANY       Subset                                   BL46.1  BL46.2
          CUSTOMER      Where PROMOTION = Spaces
          LIST-NAME
          SALES-MAJCL
          SALES-MINCL

OPCSET4   COMPANY       Subset                                   BL46.2
          CUSTOMER      Where CUSTOMER  != Spaces
          SALES-MAJCL   And   PROMOTION =  Spaces
          SALES-MINCL
          LIST-NAME

OPCSET5   COMPANY       KeyChange, Subset                        BL120   BL122
          CUSTOMER      Where CUSTOMER > Spaces                  BL130   BL20.1
          SALES-MAJCL                                            BL20.3  BL21.2
          SALES-MINCL                                            BL21.5  BL243
          END-DATE                                               BL29.1  BL29.2
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL46.1
                                                                 BL520   BL820
                                                                 BL85.1  BL85.2
                                                                 BL90.1  BL92.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 ...

OPCSET6   COMPANY       KeyChange, Subset                        BL120   BL122
          LIST-NAME     Where PROMOTION != Spaces                BL130   BL20.1
          SALES-MAJCL                                            BL20.3  BL21.2
          SALES-MINCL                                            BL21.5  BL243
          END-DATE                                               BL29.1  BL29.2
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL47.1
                                                                 BL47.2  BL520
                                                                 BL820   BL85.1
                                                                 BL85.2  BL90.1
                                                                 BL92.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 ...

                         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