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
Company              The company number represents an            BL40.2  BL40.3
                     established company and is entered on
                     all function codes.

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

OBA-BASE-NAME        Alpha 10                                    BL141   BL40.1
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
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
Item Number          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
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
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
Lst Eff Date         Date from which the previous base price     BL40.2  BL40.3
                     was effective.

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

OBA-UOM              Alpha 4 Occurs 6 Times                      BL141   BL40.1
Unit of Measure      This field contains the valid stock         BL40.2  BL40.3
                     unit of measure for this item.

OBA-OLD-CUR-PRICE    Signed 13.5 Occurs 6 Times                  BL141   BL40.1
Old Cur Price        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
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