Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEBPAUDIT


                             OEBPAUDIT FILE

                            Base Price Audit

This is the Base Price Audit file that holds audit records of any changes
made to the base price of items in the system.

REFERENCED BY

BL241

UPDATED BY

BL141     BL341     BL40.1    BL40.2    BL40.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OBA-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.

OBA-LOCATION           Alpha 5                                   BL141   BL40.1
Element: Location      This field contains a valid stock         BL40.2  BL40.3
                       location within the company inventory.

OBA-BASE-NAME          Alpha 10                                  BL141   BL40.1
Element: Base Name     User-defined name of the base price       BL40.2  BL40.3
                       that has been changed.

OBA-CURRENCY-CODE      Alpha 5                                   BL141   BL40.1
Element: Currency Code This field contains the company's base    BL40.2  BL40.3
                       currency code established in the General
                       Ledger system.

OBA-ITEM               Alpha 32                                  BL141   BL40.1
Element: Item          The identifier of the item that has had   BL40.2  BL40.3
                       its base price changed.

OBA-UPDATE-DATE        Numeric 8  (yyyymmdd)                     BL141   BL40.1
Element: Update Date   The record update date indicating when    BL40.2  BL40.3
                       the base price was changed.

OBA-UPDATE-TIME        Numeric 6                                 BL141   BL40.1
Element: Update Time   The record update time indicating when    BL40.2  BL40.3
                       the base price was changed.

OBA-LST-EFF-DATE       Numeric 8  (yyyymmdd)                     BL141   BL40.1
Element: Date          Date from which the previous base price   BL40.2  BL40.3
                       was effective.

OBA-CUR-EFF-DATE       Numeric 8  (yyyymmdd)                     BL141   BL40.1
Element: Date          Date from which the current base price    BL40.2  BL40.3
                       became effective.

OBA-UOM                Alpha 4 Occurs 10 Times                   BL141   BL40.1
Element: Uom           This field contains the valid stock       BL40.2  BL40.3
                       unit of measure for this item.

OBA-OLD-CUR-PRICE      Signed 18.5 Occurs 10 Times               BL141   BL40.1
Element: Intl Cost     This is the old current base price that   BL40.2  BL40.3
                       was used prior to the change to the base
                       price.

OBA-CHG-SOURCE         Alpha 10                                  BL141   BL40.1
Element: Chg Source    This field carries information telling    BL40.2  BL40.3
                       you how the change originated (what the
                       source is). For example, online or the
                       base price worksheet that was used to
                       modify the base price.

                         OEBPAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OBASET1   COMPANY                                                BL141   BL241
          LOCATION                                               BL341
          BASE-NAME
          CURRENCY-CODE
          ITEM
          UPDATE-DATE
          UPDATE-TIME

                         OEBPAUDIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            OBA-COMPANY          -> ICC-COMPANY

Iclocation     ICLOCATION   Required
                            When OBA-LOCATION != Spaces

                            OBA-COMPANY          -> ICL-COMPANY
                            OBA-LOCATION         -> ICL-LOCATION

Itemmast       ITEMMAST     Required

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

Oebase         OEBASE       Not Required

                            OBA-COMPANY          -> OEB-COMPANY
                            OBA-LOCATION         -> OEB-LOCATION
                            OBA-BASE-NAME        -> OEB-BASE-NAME
                            OBA-CURRENCY-CODE    -> OEB-CURRENCY-CODE
                            OBA-ITEM             -> OEB-ITEM

Oecompany      OECOMPANY    Required

                            OBA-COMPANY          -> OEC-COMPANY