|
ICAUDIT FILE
Item/Item Location Audit
The Item/Item Location Audit file is created as a result of choosing the
audit options in IC00.1 (Corporate Item Group) and/or IC01.1 (Company). When
the options are selected, the file is updated whenever a change is made to
either the Item Master or the Item Location Master file.
UPDATED BY
IC11.1 IC12.1 IC12.2 IC320 IC330 IC811
IC812 PO150 PO25.6 PO25.7 PO36.2 PO536
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IAU-ITEM-GROUP Alpha 5 IC11.1 IC12.1
Element: Item Group This field contains the identifier for IC12.2 IC320
a group of items that can be shared by IC330 IC811
one or more companies. IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-COMPANY Numeric 4 IC11.1 IC12.1
Element: Company Identifies the AP company if the IC12.2 IC320
resource type = V. Identifies the HR IC330 IC811
company if the resource type = E. It is IC812 PO150
blank for type A, P or Q resources. PO25.6 PO25.7
PO36.2 PO536
IAU-LOCATION Alpha 5 IC11.1 IC12.1
Element: Location This field contains a valid stocking IC12.2 IC320
location within the company inventory. IC330 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-ITEM Alpha 32 IC11.1 IC12.1
Element: Item This field contains the item's IC12.2 IC320
identifier. IC330 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-DATE Numeric 8 (yyyymmdd) IC11.1 IC12.1
Element: Date This field contains the system date IC12.2 IC320
when the audit record was created. IC330 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-TIME Numeric 8 IC11.1 IC12.1
Element: Time This field contains the system time IC12.2 IC320
when the audit record was created. IC330 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-FLD-NBR Numeric 4 IC11.1 IC12.1
Element: Fld Nbr This field contains a unique number IC12.2 IC320
assigned to a field that identifies the IC330 IC811
description of the field. IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-BEFORE-IMAGE Alpha 32 IC11.1 IC12.1
Element: Before Image This field contains the field image IC12.2 IC320
before the change. IC330 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-AFTER-IMAGE Alpha 32 IC11.1 IC12.1
Element: Before Image This field contains the field image IC12.2 IC320
after the change. IC330 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-DB-FILE Alpha 3 IC11.1 IC12.1
Element: Db File This field identifies which file is IC12.2 IC320
being maintained by this audit record. IC330 IC811
ITE = Item Master File (ITEMMAST) IC812 PO150
ITL = Item Location File (ITEMLOC) PO25.6 PO25.7
PO36.2 PO536
IAU-OPERATOR-ID Alpha 10 IC11.1 IC12.1
Element: Operator This field contains the terminal sign IC12.2 IC320
on when this update was performed to the IC330 IC812
database. PO150 PO25.6
PO25.7 PO36.2
PO536
ICAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IAUSET1 ITEM-GROUP
COMPANY
LOCATION
ITEM
DATE
TIME
FLD-NBR
ICAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
When IAU-COMPANY != Zeroes
IAU-COMPANY -> ICC-COMPANY
Icdict ICDICT Required
IAU-FLD-NBR -> IDI-FLD-NBR
Itemgroup ITEMGROUP Required
When IAU-ITEM-GROUP != Spaces
IAU-ITEM-GROUP -> ITG-ITEM-GROUP
Itemmast ITEMMAST Required
IAU-ITEM-GROUP -> ITE-ITEM-GROUP
IAU-ITEM -> ITE-ITEM
Location ICLOCATION Required
IAU-COMPANY -> ICL-COMPANY
IAU-LOCATION -> ICL-LOCATION
|