|
|
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 Code 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 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
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: Unit of MeasurThis 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
|
