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	IC120	IC150
IC151	IC152	IC183	IC191	IC192	IC320
IC330	IC331	IC512	IC81.1	IC811	IC812
IC82.1	IC91.1	IC91.2	PO150	PO25.6	PO25.7
PO26.4	PO26.5	PO28.2	PO36.2	PO536

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
IAU-ITEM-GROUP Element: Item Group	Alpha 5 This field contains the identifier for a group of items that can be shared by one or more companies.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-COMPANY Element: Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-LOCATION Element: Location	Alpha 5 This field contains a valid stocking location within the company inventory.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-ITEM Element: Item	Alpha 32 This field contains the item's identifier.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the system date when the audit record was created.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-TIME Element: Time	Numeric 8 This field contains the system time when the audit record was created.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-FLD-NBR Element: Fld Nbr	Numeric 4 This field contains a unique number assigned to a field that identifies the description of the field.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-BEFORE-IMAGE Element: Field Val	Alpha 35 This field contains the field image before the change.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-AFTER-IMAGE Element: Field Val	Alpha 35 This field contains the field image after the change.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-DB-FILE Element: Db File	Alpha 3 This field identifies which file is being maintained by this audit record. ITE = Item Master File (ITEMMAST) ITL = Item Location File (ITEMLOC) ITM = Item Source File (ITEMSRC)	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC811 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-OPERATOR-ID Element: Operator	Alpha 10 This field contains the terminal sign on when this update was performed to the database.	IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC150 IC151 IC152 IC183 IC320 IC330 IC331 IC81.1 IC812 IC82.1 PO150 PO25.6 PO25.7 PO26.4 PO26.5 PO28.2 PO36.2 PO536
IAU-FLD-DESC Element: Fld Desc	Derived

ICAUDIT FILE INDEX

ICAUDIT FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.