Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEBASE


                              OEBASE FILE

                               Base Price

This file stores the price bases established for items that are to be sold
through the Lawson Order Entry system.  All items must have a record in this
file if they are to be ordered and priced by the Lawson Order Entry system.
This is simply the price base for the item and this can be modified up or down
with any one of the three price modifiers (price list, promotion, or
contract).

REFERENCED BY

BL00.1    BL120     BL122     BL130     BL140     BL20.1
BL20.3    BL21.2    BL21.5    BL240     BL241     BL243
BL29.1    BL29.2    BL31.1    BL31.2    BL31.3    BL31.5
BL31.7    BL32.3    BL32.4    BL340     BL41.1    BL48.1
BL520     BL820     BL85.1    BL85.2    BL90.1    BL92.1
WH20.2    WH20.7    BL45.3    BL45.1    BL46.3    BL46.1
BL47.3    BL47.1    BL248

UPDATED BY

BL141     BL40.1    BL40.2    BL40.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OEB-COMPANY            Numeric 4                                 BL141   BL40.1
Element: Company       Identifies the AP company if the          BL40.2  BL40.3
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OEB-LOCATION           Alpha 5                                   BL141   BL40.1
Element: Location      If the base location required option      BL40.2  BL40.3
                       has been selected for the company, the
                       base list can be further identified by
                       location to establish base price. This
                       will indicate that item pricing may
                       differ, depending on the location where
                       the item is stored. For example, base
                       name BASE1 could appear on this form
                       several times, with a different price
                       for each different inventory location.

                       Note: Inventory locations are
                       established in the Inventory Control
                       system.

OEB-BASE-NAME          Alpha 10                                  BL141   BL40.1
Element: Base Name     The user-defined name of a price base.    BL40.2  BL40.3

OEB-CURRENCY-CODE      Alpha 5                                   BL141   BL40.1
Element: Currency Code The currency code indicating which        BL40.2  BL40.3
                       currency the system will use when
                       creating the price base for the order.

OEB-ITEM               Alpha 32                                  BL141   BL40.1
Element: Item          The identifier of the item to which the   BL40.2  BL40.3
                       price base will be or has been assigned.


OEB-LAST-MULT-SPR      Numeric 1                                 BL141   BL40.1
Element: Cur Mult Spr  This field indicates whether an item      BL40.2  BL40.3
                       can be priced using one or multiple
                       units of measure. If multiple units of
                       measure are defined for this item, the
                       user must establish a price for each
                       unit of measure when defining the base
                       price for this item.
                       Applies only to old or "last" pricing
                       unit of measure table of price base.
                       0 = Single Pricing UOM
                       1 = Multiple Pricing UOM

OEB-LAST-SPR-UOM       Alpha 4 Occurs 10 Times                   BL141   BL40.1
Element: Uom           If an item is priced in multiple units    BL40.2  BL40.3
                       of measure, this field holds up to six
                       different units of measure that can be
                       used to price the item.

OEB-LAST-SPR-MULT      Signed 13.7 Occurs 10 Times               BL141   BL40.1
Element: Uom Mult      If the item is priced using multiple      BL40.2  BL40.3
                       units of measure, this field holds up to
                       six conversion factors used to convert
                       quantities from those pricing units of
                       measure to stock units of measure.

OEB-LAST-SPR-CD        Alpha 1 Occurs 10 Times                   BL141   BL40.1
Element: Cur Spr Cd    Code indicating whether each pricing      BL40.2  BL40.3
                       unit of measure is the default pricing
                       unit of measure or a valid pricing unit
                       of measure or an invalid unit of measure
                       to be used for pricing.
                       1 = Default Sell Price UOM
                       2 = Valid Sell Price UOM

OEB-LAST-PRICE         Signed 18.5 Occurs 10 Times               BL141   BL40.1
Element: Intl Cost     Last base price used before the use of    BL40.2  BL40.3
                       the current base price.

OEB-CUR-EFF-DATE       Numeric 8  (yyyymmdd)                     BL140   BL141
Element: Date          A date indicating when the current        BL240   BL241
                       price base became effective.              BL340   BL40.1
                                                                 BL40.2  BL40.3

OEB-CUR-MULT-SPR       Numeric 1                                 BL140   BL141
Element: Cur Mult Spr  Current multiple sell price unit of       BL240   BL241
                       measure flag. If an item is priced in     BL340   BL40.1
                       multiple units of measure, this field     BL40.2  BL40.3
                       holds up to six different units of
                       measure that can be used to price the
                       item.
                       0 = Single Pricing UOM
                       1 = Multiple Pricing UOM

OEB-CUR-SPR-UOM        Alpha 4 Occurs 10 Times                   BL140   BL141
Element: Uom           If this item is priced in multiple        BL240   BL241
                       units of measure, this field holds up to  BL340   BL40.1
                       six different units of measure that can   BL40.2  BL40.3
                       be used to price the item.

OEB-CUR-SPR-MULT       Signed 13.7 Occurs 10 Times               BL140   BL141
Element: Uom Mult      If an item is currently priced using      BL240   BL241
                       multiple units of measure, this field     BL340   BL40.1
                       holds up to six conversion factors used   BL40.2  BL40.3
                       to convert quantities from pricing units
                       of measure to stock units of measure.

OEB-CUR-SPR-CD         Alpha 1 Occurs 10 Times                   BL140   BL141
Element: Cur Spr Cd    Code indicating whether each pricing      BL240   BL241
                       unit of measure is the default pricing    BL340   BL40.1
                       unit of measure or a valid pricing unit   BL40.2  BL40.3
                       of measure or an invalid unit of measure
                       to be used for pricing.
                       1 = Default Sell Price UOM
                       2 = Valid Sell Price UOM

OEB-CUR-PRICE          Signed 18.5 Occurs 10 Times               BL140   BL141
Element: Intl Cost     Current base price for the item.          BL240   BL241
                                                                 BL340   BL40.1
                                                                 BL40.2  BL40.3

OEB-NXT-EFF-DATE       Numeric 8  (yyyymmdd)                     BL120   BL122
Element: Date          The date from which the next price base   BL130   BL141
                       will become effective.                    BL20.1  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
                                                                 BL40.1  BL40.2
                                                                 BL40.3  BL520
                                                                 BL820   BL85.1
                                                                 BL85.2  BL90.1
                                                                 BL92.1  WH20.2
                                                                 WH20.7

OEB-NXT-MULT-SPR       Numeric 1                                 BL141   BL40.1
Element: Cur Mult Spr  Next multiple sell price unit of          BL40.2  BL40.3
                       measure flag. If an item will be priced
                       in multiple units of measure, this field
                       holds up to six different units of
                       measure that can be used to price the
                       item.
                       0 = Single Pricing UOM
                       1 = Multiple Pricing UOM

OEB-NXT-SPR-UOM        Alpha 4 Occurs 10 Times                   BL141   BL40.1
Element: Uom           If this item will be priced in multiple   BL40.2  BL40.3
                       units of measure, this field holds up to
                       six different units of measure that can
                       be used to price the item.

OEB-NXT-SPR-MULT       Signed 13.7 Occurs 10 Times               BL141   BL40.1
Element: Uom Mult      If an item will be priced using           BL40.2  BL40.3
                       multiple units of measure, this field
                       holds up to six conversion factors used
                       to convert quantities from pricing units
                       of measure to stock units of measure.

OEB-NEXT-SPR-CD        Alpha 1 Occurs 10 Times                   BL141   BL40.1
Element: Cur Spr Cd    Code indicating whether each pricing      BL40.2  BL40.3
                       unit of measure that will be used is the
                       default pricing unit of measure or a
                       valid pricing unit of measure or an
                       invalid unit of measure to be used for
                       pricing.

OEB-NXT-PRICE          Signed 18.5 Occurs 10 Times               BL141   BL40.1
Element: Intl Cost     Next base price to be used by the         BL40.2  BL40.3
                       system when pricing this item.

OEB-CUR-MULT-IND       Derived
Element: Cur Mult Ind  This field contains the current pricing
                       multiplier.

OEB-NXT-MULT-IND       Derived
Element: Nxt Mult Ind  This field contains the next pricing
                       multiplier.

OEB-CUR-PRICE-1        Derived
Element: Cur Price 1   This field is used only to facilitate
                       painting BL243 (Price Book Print).

OEB-PL1-PRICE          Derived
Element: Pl1 Price     This field is used only to facilitate
                       painting BL243 (Price Book Print). Price
                       book will  print up to three different
                       price lists that have been added to the
                       system.

OEB-PL2-PRICE          Derived
Element: Pl2 Price     This field is used only to facilitate
                       painting BL243 (Price Book Print). The
                       price book will print up to three
                       different price lists that have been
                       added to the system.

OEB-PL3-PRICE          Derived
Element: Pl3 Price     This field is used only to facilitate
                       painting BL243 (Price Book Print). The
                       price book will print up to three
                       different price lists that have been
                       added to the system.

OEB-CURR-NO-CHARGE     Alpha 1                                   BL40.1  BL40.2
Element: No Charge Fl  This field indicates the item's price     BL40.3
                       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.

OEB-NEXT-NO-CHARGE     Alpha 1                                   BL40.1  BL40.2
Element: No Charge Fl  This field indicates the item's price     BL40.3
                       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.

                         OEBASE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OEBSET1   COMPANY                                                BL00.1  BL120
          LOCATION                                               BL122   BL130
          BASE-NAME                                              BL140   BL141
          CURRENCY-CODE                                          BL20.1  BL20.3
          ITEM                                                   BL21.2  BL21.5
                                                                 BL240   BL241
                                                                 BL243   BL29.1
                                                                 BL29.2  BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL340   BL40.1
                                                                 BL40.2  BL41.1
                                                                 BL48.1  BL520
                                                                 BL820   BL85.1
                                                                 ...

OEBSET2   COMPANY                                                BL40.3  BL45.3
          ITEM                                                   BL46.3  BL47.3
          BASE-NAME
          LOCATION
          CURRENCY-CODE

OEBSET3   COMPANY                                                BL248   BL45.1
          BASE-NAME                                              BL46.1  BL47.1
          CURRENCY-CODE
          LOCATION
          ITEM

                         OEBASE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cucodes        CUCODES      Required

                            OEB-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Iccompany      ICCOMPANY    Required

                            OEB-COMPANY          -> ICC-COMPANY

Iclocation     ICLOCATION   Required
                            When OEB-LOCATION != Spaces

                            OEB-COMPANY          -> ICL-COMPANY
                            OEB-LOCATION         -> ICL-LOCATION

Itemmast       ITEMMAST     Required

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

Majorcl        MAJORCL      Required

                            ICC-ITEM-GROUP       -> MAJ-ITEM-GROUP
                            PBC-MAJOR-SCLASS     -> MAJ-CLASS-TYPE
                            PBC-MINOR-SCLASS     -> MAJ-MAJOR-CLASS

Minorcl        MINORCL      Required

                            ICC-ITEM-GROUP       -> MIN-ITEM-GROUP
                            "S"                  -> MIN-CLASS-TYPE
                            ITE-SALES-MAJCL      -> MIN-MAJOR-CLASS
                            ITE-SALES-MINCL      -> MIN-MINOR-CLASS

Oecompany      OECOMPANY    Required

                            OEB-COMPANY          -> OEC-COMPANY

Oepbclass      OEPBCLASS    Not Required

                            OEB-COMPANY          -> PBC-COMPANY
                            OPB-BOOK-NAME        -> PBC-BOOK-NAME
                            ITE-SALES-MAJCL      -> PBC-MAJOR-SCLASS
                            ITE-SALES-MINCL      -> PBC-MINOR-SCLASS

Oepbitem       OEPBITEM     Not Required

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

Oeprcbook      OEPRCBOOK    Not Required

                            OEB-COMPANY          -> OPB-COMPANY
                            OEB-BASE-NAME        -> OPB-BASE-NAME
                            Spaces               -> OPB-BOOK-NAME

Price List1    OEPRCLIST    Required

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

Price List2    OEPRCLIST    Required
                            When OPB-PRICE-LIST-2 != Spaces

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

Price List3    OEPRCLIST    Required
                            When OPB-PRICE-LIST-3 != Spaces

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

                         OEBASE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oebpaudit      OEBPAUDIT

                            OEB-COMPANY          -> OBA-COMPANY
                            OEB-LOCATION         -> OBA-LOCATION
                            OEB-BASE-NAME        -> OBA-BASE-NAME
                            OEB-CURRENCY-CODE    -> OBA-CURRENCY-CODE
                            OEB-ITEM             -> OBA-ITEM
                                                    OBA-UPDATE-DATE
                                                    OBA-UPDATE-TIME