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 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 IC320 IC81.1
one or more companies. 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 IC320 IC81.1
all function codes. 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. 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. 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. 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. 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 IC320 IC81.1
description of the field. 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. 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. 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. IC320 IC81.1
ITE = Item Master File (ITEMMAST) IC811 IC812
ITL = Item Location File (ITEMLOC)
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 IC320 IC81.1
database. 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
|
