Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEPRCLIST


                             OEPRCLIST FILE

                               Price List

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

REFERENCED BY

BL00.1    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL243     BL245     BL246     BL29.1
BL29.2    BL31.1    BL31.2    BL31.3    BL31.5    BL31.7
BL32.3    BL32.4    BL32.1    BL32.2    BL48.1    BL520
BL820     BL85.1    BL85.2    BL90.1    BL92.1    WH20.2
WH20.7    BL247     AR08.1    AR10.1    AR120     AR501
AR550     BL02.1    BL30.1    BL30.2    BL30.3    BL30.5
BL546     BL802

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

OPL-CUSTOMER           Alpha 9  (Right Justified)                BL45.1  BL46.1
Element: Customer      This field contains the number that       BL47.1
                       represents a customer.

OPL-LIST-NAME          Alpha 14                                  BL45.1  BL46.1
Element: List Name     User-defined name assigned to a price     BL47.1
                       list.

OPL-PROMOTION          Alpha 10                                  BL45.1  BL46.1
Element: Promotion     User-defined name assigned to a           BL47.1
                       promotion that is associated with this
                       price list.

OPL-DESCRIPTION        Alpha 30  (Lower Case)                    BL45.1  BL46.1
Element: Description   The description of the price list.        BL47.1  BL48.1

OPL-BASE-NAME          Alpha 10                                  BL45.1  BL46.1
Element: Base Name     User-defined name of the price base       BL47.1
                       that this price list modifies. Price
                       bases are defined on BL40.1 (Price
                       Base).

OPL-BEG-DATE           Numeric 8  (yyyymmdd)                     BL46.1  BL47.1
Element: Beg Date      The beginning effective date for the
                       promotion or contract.

OPL-END-DATE           Numeric 8  (yyyymmdd)                     BL46.1  BL47.1
Element: End Date      The ending effective date for the
                       promotion or contract.

OPL-MISC               Alpha 16                                  BL45.1  BL46.1
Element: Misc          You can add an add-on charge to the       BL47.1
                       price list that will always be assessed
                       when the price list is used.

OPL-PCT                Percent 5.2  (Percent)                    BL45.1  BL46.1
Element: Pct           This default percentage (enter 90% as     BL47.1
                       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-CODE          Alpha 10                                  BL45.1  BL46.1
Element: Discount Code A discount code, entered using BL44.1     BL47.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-DATE      Numeric 8  (yyyymmdd)                     BL46.1
Element: Contract Date Enter the date indicating when the
                       contract was added to the system.

OPL-CONTACT            Alpha 20                                  BL46.1
Element: Contact       The name of the customer that can be
                       contacted regarding this contract.

OPL-PHONE              Alpha 15                                  BL46.1
Element: Phone         Customer contact phone number.

OPL-PREV-CONTRACT      Alpha 14                                  BL46.1
Element: List Name     A previous number used to reference the
                       last contract can be entered in this
                       field.

OPL-CURRENCY-CODE      Alpha 5                                   BL45.1  BL46.1
Element: Currency Code The currency this price list is meant     BL47.1
                       to use. If blank, orders in any currency
                       can be priced via this price list.

OPL-CURR-RATE          Signed 14.7                               BL46.1
Element: Curr Rate     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-REFERENC      Alpha 20                                  BL46.1
Element: Contact       A customer reference number, or any
                       information that the user wants to carry
                       on the contract. Purely informational.

OPL-MIN-CONT-AMT       Signed 18.2                               BL46.1
Element: Intl Amt      Enter a minimum contract amount for the
                       contract. This minimum will print on a
                       report that lists the actual contract
                       sales.

OPL-MAX-CONT-AMT       Signed 18.2                               BL46.1
Element: Intl Amt      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-FL        Alpha 1                                   BL45.1  BL46.1
Element: Ord Disc Fl   This order discount flag is used only     BL47.1
                       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.
                       N = No
                       Y = Yes

OPL-MIN-ORD-AMT        Signed 18.2
Element: Intl Amt      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-AMT        Signed 18.2
Element: Intl Amt      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-COUNT           Numeric 4                                 BL45.2  BL46.2
Element: Sc Count      This field indicates the number of        BL47.2
                       price list sales class price modifiers
                       that have been established under this
                       price list.

OPL-ITEM-COUNT         Numeric 6                                 BL45.3  BL46.3
Element: Item Count    This field indicates the number of        BL47.3
                       price list item modifiers that have been
                       established under this price list.

                         OEPRCLIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OPLSET1   COMPANY                                                BL00.1  BL120
          CUSTOMER                                               BL122   BL130
          LIST-NAME                                              BL20.1  BL20.3
          PROMOTION                                              BL21.2  BL21.5
                                                                 BL243   BL245
                                                                 BL246   BL29.1
                                                                 BL29.2  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL45.1  BL45.2
                                                                 BL45.3  BL46.1
                                                                 BL46.2  BL46.3
                                                                 BL47.1  BL47.2
                                                                 BL47.3  BL48.1
                                                                 ...

OPLSET2   COMPANY       Subset                                   BL247   BL47.1
          LIST-NAME     Where PROMOTION != Spaces                BL47.2  BL47.3
          PROMOTION

OPLSET4   COMPANY       Subset                                   AR08.1  AR10.1
          CUSTOMER      Where PROMOTION = Spaces                 AR120   AR501
          LIST-NAME                                              AR550   BL02.1
                                                                 BL130   BL245
                                                                 BL30.1  BL30.2
                                                                 BL30.3  BL30.5
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.1
                                                                 BL32.2  BL32.3
                                                                 BL32.4  BL45.1
                                                                 BL45.2  BL45.3
                                                                 BL46.1  BL46.3
                                                                 BL546   BL802

OPLSET5   COMPANY       KeyChange, Subset                        BL120   BL122
          CUSTOMER      Where CUSTOMER > Spaces                  BL130   BL20.1
          END-DATE      And   PCT      > Zeroes                  BL20.3  BL21.2
                                                                 BL21.5  BL243
                                                                 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
                                                                 WH20.2  WH20.7

OPLSET6   COMPANY       KeyChange, Subset                        BL120   BL122
          LIST-NAME     Where PROMOTION > Spaces                 BL130   BL20.1
          END-DATE      And   PCT       > Zeroes                 BL20.3  BL21.2
                                                                 BL21.5  BL243
                                                                 BL29.1  BL29.2
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 BL31.7  BL32.3
                                                                 BL32.4  BL47.1
                                                                 BL520   BL820
                                                                 BL85.1  BL85.2
                                                                 BL90.1  BL92.1
                                                                 WH20.2  WH20.7

                         OEPRCLIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

                         OEPRCLIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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