Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEPRCBOOK


                             OEPRCBOOK FILE

                               Price Book

This file stores price books that have been set up online.  Price books are
used to print out pricing information in a booklet format.  The report that
actually prints the books out is BL243 (Price Book Print).

REFERENCED BY

BL243

UPDATED BY

BL00.1    BL48.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OPB-COMPANY            Numeric 4                                 BL48.1
Element: Company       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.

OPB-BOOK-NAME          Alpha 10                                  BL243   BL48.1
Element: Base Name     Enter the price book identifier.

OPB-BASE-LOC           Alpha 5                                   BL48.1
Element: Location Code Enter the price base location if your
                       company uses location-based pricing.
                       Location-based pricing indicates that
                       base list pricing can differ for the
                       same item, depending on where it is
                       shipped from.

OPB-BASE-NAME          Alpha 10                                  BL48.1
Element: Base Name     The price base name that will be
                       referenced by price lists specified in
                       the fields below.

OPB-CURRENCY-CODE      Alpha 5                                   BL48.1
Element: Currency Code This field contains the company's base
                       currency code established in the General
                       Ledger system.

OPB-DESCRIPTION        Alpha 30  (Lower Case)                    BL243   BL48.1
Element: Description   Description of price book is entered in
                       this field.

OPB-PRICE-LIST-1       Alpha 14                                  BL243   BL48.1
Element: Price Lst     The price list that will print in
                       column 1 of the price book.

OPB-PRICE-LIST-2       Alpha 14                                  BL243   BL48.1
Element: Price Lst     The price list that will print in
                       column 2 of the price book.

OPB-PRICE-LIST-3       Alpha 14                                  BL243   BL48.1
Element: Price Lst     The price list that will print in
                       column 3 of the price book.

OPB-COMMENTS           Alpha 50  (Lower Case)                    BL243   BL48.1
Element: Comments      Occurs 10 Times
                       You can enter comments here and they
                       will print at the beginning of the price
                       book.

                         OEPRCBOOK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OPBSET1   COMPANY                                                BL00.1  BL243
          BOOK-NAME                                              BL48.1  BL48.2
                                                                 BL48.3

OPBSET2   COMPANY       KeyChange                                BL243
          BASE-NAME
          BOOK-NAME

                         OEPRCBOOK FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cucodes        CUCODES      Required

                            OPB-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Iccompany      ICCOMPANY    Not Required

                            OPB-COMPANY          -> ICC-COMPANY

Iclocation     ICLOCATION   Required
                            When OPB-BASE-LOC != Spaces

                            OPB-COMPANY          -> ICL-COMPANY
                            OPB-BASE-LOC         -> ICL-LOCATION

Oecompany      OECOMPANY    Required

                            OPB-COMPANY          -> OEC-COMPANY

Oeprclist1     OEPRCLIST    Required
                            When OPB-PRICE-LIST-1 != Spaces

                            OPB-COMPANY          -> OPL-COMPANY
                            Spaces               -> OPL-CUSTOMER
                            OPB-PRICE-LIST-1     -> OPL-LIST-NAME
                            Spaces               -> OPL-PROMOTION

Oeprclist2     OEPRCLIST    Required
                            When OPB-PRICE-LIST-2 != Spaces

                            OPB-COMPANY          -> OPL-COMPANY
                            Spaces               -> OPL-CUSTOMER
                            OPB-PRICE-LIST-2     -> OPL-LIST-NAME
                            Spaces               -> OPL-PROMOTION

Oeprclist3     OEPRCLIST    Required
                            When OPB-PRICE-LIST-3 != Spaces

                            OPB-COMPANY          -> OPL-COMPANY
                            Spaces               -> OPL-CUSTOMER
                            OPB-PRICE-LIST-3     -> OPL-LIST-NAME
                            Spaces               -> OPL-PROMOTION

                         OEPRCBOOK FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemmast       ITEMMAST

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                                                    ITE-ITEM

Oebase         OEBASE       Required

                            OPB-COMPANY          -> OEB-COMPANY
                            OPB-BASE-LOC         -> OEB-LOCATION
                            OPB-BASE-NAME        -> OEB-BASE-NAME
                            OPB-CURRENCY-CODE    -> OEB-CURRENCY-CODE
                                                    OEB-ITEM

Oepbclass      OEPBCLASS    Delete Cascades

                            OPB-COMPANY          -> PBC-COMPANY
                            OPB-BOOK-NAME        -> PBC-BOOK-NAME
                                                    PBC-MAJOR-SCLASS
                                                    PBC-MINOR-SCLASS

Oepbitem       OEPBITEM     Delete Cascades

                            OPB-COMPANY          -> PBI-COMPANY
                            OPB-BOOK-NAME        -> PBI-BOOK-NAME
                                                    PBI-ITEM