Lawson Insight Technical Documentation |
|
ICAUDIT
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 PO150
PO25.6 PO25.7 PO36.2 PO536
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IAU-ITEM-GROUP Alpha 5 IC10.2 IC11.1
Element: 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 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-COMPANY Numeric 4 IC10.2 IC11.1
Element: Company Identifies the AP company if the IC12.1 IC12.2
resource type = V. Identifies the HR IC183 IC320
company if the resource type = E. It is IC81.1 IC811
blank for type A, P or Q resources. IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-LOCATION Alpha 5 IC10.2 IC11.1
Element: Location Code This field contains a valid stocking IC12.1 IC12.2
location within the company inventory. IC183 IC320
IC81.1 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-ITEM Alpha 32 IC10.2 IC11.1
Element: Item Number This field contains the item's IC12.1 IC12.2
identifier. IC183 IC320
IC81.1 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-DATE Numeric 8 (yyyymmdd) IC10.2 IC11.1
Element: Date This field contains the system date IC12.1 IC12.2
when the audit record was created. IC183 IC320
IC81.1 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-TIME Numeric 8 IC10.2 IC11.1
Element: Time This field contains the system time IC12.1 IC12.2
when the audit record was created. IC183 IC320
IC81.1 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
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 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-BEFORE-IMAGE Alpha 32 IC10.2 IC11.1
Element: Before Change This field contains the field image IC12.1 IC12.2
before the change. IC183 IC320
IC81.1 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-AFTER-IMAGE Alpha 32 IC10.2 IC11.1
Element: Before Change This field contains the field image IC12.1 IC12.2
after the change. IC183 IC320
IC81.1 IC811
IC812 PO150
PO25.6 PO25.7
PO36.2 PO536
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 PO150
PO25.6 PO25.7
PO36.2 PO536
IAU-OPERATOR-ID Alpha 10 IC10.2 IC11.1
Element: Operator Code This field contains the terminal sign IC12.1 IC12.2
on when this update was performed to the IC183 IC320
database. IC81.1 IC812
PO150 PO25.6
PO25.7 PO36.2
PO536
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
|