ICAUDIT

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.

REFERENCED BY
IC524 IC93.2 IC93.1


UPDATED BY
IC00.1 IC01.1 IC01.2 IC01.3 IC01.4 IC04.1
IC10.2 IC11.1 IC12.1 IC12.2 IC120 IC15.2
IC15.3 IC150 IC151 IC152 IC183 IC189
IC191 IC192 IC194 IC196 IC197 IC198
IC320 IC330 IC331 IC81.1 IC811 IC812
IC82.1 IC840 IC841 PO150 PO25.6 PO25.7
PO26.4 PO26.5 PO28.2 PO36.2 PO536 IC512
IC91.3 IC91.4 IC91.5

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.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
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.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
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.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
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.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IAU-GL-CATEGORY
Element: Gl Category		Alpha 4
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC12.1
IC12.2 IC120
IC15.2 IC15.3
IC150 IC151
IC152 IC183
IC320 IC330
IC331 IC81.1
IC812 IC82.1
IC840 IC841
IAU-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field contains the system date when the audit record was created.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
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.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
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.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IAU-BEFORE-IMAGE
Element: Description3		Alpha 350 (Lower Case)
This field contains the field image before the change.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IAU-AFTER-IMAGE
Element: Description3		Alpha 350 (Lower Case)
This field contains the field image after the change.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
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)
ICA = GL Category File (ICCATEGORY)
ICB = IC Bin (ICBIN)
BGD = Bin Group Detail (BINGRPDTL)
ITG = Item Group File (ITEMGROUP)
ICC = IC Company File (ICCOMPANY)
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC811
IC812 IC82.1
IC840 IC841
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.
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC11.1
IC12.1 IC12.2
IC120 IC15.2
IC15.3 IC150
IC151 IC152
IC183 IC320
IC330 IC331
IC81.1 IC812
IC82.1 IC840
IC841 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536
IAU-FLD-DESC
Element: Fld Desc		Derived
IAU-BIN-GROUP
Element: Bin Group		Alpha 7
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC12.1
IC12.2 IC120
IC15.2 IC15.3
IC150 IC151
IC152 IC183
IC320 IC330
IC331 IC81.1
IC812 IC82.1
IC840 IC841
IAU-BIN
Element: Bin		Alpha 7
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC12.1
IC12.2 IC120
IC15.2 IC15.3
IC150 IC151
IC152 IC183
IC320 IC330
IC331 IC81.1
IC812 IC82.1
IC840 IC841


ICAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IAUSET1 ITEM-GROUP
COMPANY
LOCATION
ITEM
GL-CATEGORY
DATE
TIME
FLD-NBR
...
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC12.1
IC12.2 IC120
IC15.2 IC15.3
IC150 IC151
IC152 IC183
IC191 IC192
IC194 IC196
IC197 IC320
IC330 IC331
IC512 IC524
IC81.1 IC812
IC82.1 IC840
IAUSET2 DATE
TIME
ITEM-GROUP
COMPANY
LOCATION
ITEM
GL-CATEGORY
FLD-NBR
IAUSET3 DATE
TIME
DB-FILE
COMPANY
LOCATION
BIN-GROUP
BIN
FLD-NBR
Subset
WhereBIN-GROUP !=Spaces
IC00.1 IC01.1
IC01.2 IC01.3
IC01.4 IC04.1
IC10.2 IC12.1
IC12.2 IC120
IC15.2 IC15.3
IC150 IC151
IC152 IC183
IC320 IC330
IC331 IC81.1
IC812 IC82.1
IC840 IC841
IAUSET4 COMPANY
LOCATION
BIN-GROUP
DATE
TIME
FLD-NBR
Subset
WhereBIN-GROUP !=Spaces
IC198 IC93.2
IAUSET5 COMPANY
LOCATION
BIN
DATE
TIME
FLD-NBR
Subset
WhereBIN !=Spaces
IC189 IC93.1


ICAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Iccategory ICCATEGORY Not Required
Valid When IAU-GL-CATEGORY !=Spaces
IAU-COMPANY->ICA-COMPANY
IAU-LOCATION->ICA-LOCATION
IAU-GL-CATEGORY->ICA-GL-CATEGORY
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
Itemloc ITEMLOC Not Required
Valid When IAU-COMPANY !=Zeroes
AndIAU-GL-CATEGORY =Spaces
IAU-COMPANY->ITL-COMPANY
IAU-ITEM->ITL-LOCATION
IAU-ITEM->ITL-ITEM
Itemmast ITEMMAST Not Required
Valid When IAU-ITEM-GROUP !=Spaces
IAU-ITEM-GROUP->ITE-ITEM-GROUP
IAU-ITEM->ITE-ITEM
Itemmast2 ITEMMAST Not Required
Valid When IAU-COMPANY !=Zeroes
AndIAU-GL-CATEGORY =Spaces
ICC-ITEM-GROUP->ITE-ITEM-GROUP
IAU-ITEM->ITE-ITEM
Location ICLOCATION Required
IAU-COMPANY->ICL-COMPANY
IAU-LOCATION->ICL-LOCATION

File created: Thu Jun 09 02:18:32 2016

Home
Contact Us



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