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