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
IC10.2 IC11.1 IC12.1 IC12.2 IC183 IC191
IC192 IC320 IC81.1 IC811 IC812
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IAU-ITEM-GROUP Alpha 5 IC10.2 IC11.1
Item Group This field contains the identifier for IC12.1 IC12.2
a group of items that can be shared by IC183 IC320
one or more companies. IC81.1 IC811
IC812
IAU-COMPANY Numeric 4 IC10.2 IC11.1
Company The company number represents an IC12.1 IC12.2
established company and is entered on IC183 IC320
all function codes. IC81.1 IC811
IC812
IAU-LOCATION Alpha 5 IC10.2 IC11.1
Location Code This field contains a valid stocking IC12.1 IC12.2
location within the company inventory. IC183 IC320
IC81.1 IC811
IC812
IAU-ITEM Alpha 32 IC10.2 IC11.1
Item Number This field contains the item's IC12.1 IC12.2
identifier. IC183 IC320
IC81.1 IC811
IC812
IAU-DATE Numeric 8 (yyyymmdd) IC10.2 IC11.1
Date This field contains the system date IC12.1 IC12.2
when the audit record was created. IC183 IC320
IC81.1 IC811
IC812
IAU-TIME Numeric 8 IC10.2 IC11.1
Time This field contains the system time IC12.1 IC12.2
when the audit record was created. IC183 IC320
IC81.1 IC811
IC812
IAU-FLD-NBR Numeric 4 IC10.2 IC11.1
Dictionary Field This field contains a unique number IC12.1 IC12.2
Number assigned to a field that identifies the IC183 IC320
description of the field. IC81.1 IC811
IC812
IAU-BEFORE-IMAGE Alpha 32 IC10.2 IC11.1
Before Change Image This field contains the field image IC12.1 IC12.2
before the change. IC183 IC320
IC81.1 IC811
IC812
IAU-AFTER-IMAGE Alpha 32 IC10.2 IC11.1
After Change Image This field contains the field image IC12.1 IC12.2
after the change. IC183 IC320
IC81.1 IC811
IC812
IAU-DB-FILE Alpha 3 IC10.2 IC11.1
Data Base File This field identifies which file is IC12.1 IC12.2
Prefix being maintained by this audit record. IC183 IC320
ITE = Item Master File (ITEMMAST) IC81.1 IC811
ITL = Item Location File (ITEMLOC) IC812
IAU-OPERATOR-ID Alpha 10 IC10.2 IC11.1
Operator This field contains the terminal sign IC12.1 IC12.2
Identification Code on when this update was performed to the IC183 IC320
database. IC81.1 IC812
ICAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IAUSET1 ITEM-GROUP IC191 IC192
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
|
