ICICLAUDIT

The IC Location Audit table is created as a result of choosing the audit option in IC01.1 (IC Company). When this option is selected, entries to the table are added whenever changes are made to an IC Location.

REFERENCED BY
IC92.1


UPDATED BY
AP510 IC02.1 IC02.2 IC193 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC802 IC81.1 IC840 TX140

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ILA-COMPANY
Element: Company
Numeric 4
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-LOCATION
Element: Location
Alpha 5
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-SYSTEM-CD
Element: System Cd
Alpha 2
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-SEQ
Element: Seq
Numeric 3
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-DATE
Element: Date
Numeric 8 (yyyymmdd)
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-TIME
Element: Time
Numeric 8
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-FLD-NBR
Element: Fld Nbr
Numeric 4
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-BEFORE-IMAGE
Element: Field Value
Alpha 60
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-AFTER-IMAGE
Element: Field Value
Alpha 60
This field contains the field image after the change.
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-OPERATOR
Element: Operator
Alpha 10
AP510 IC02.1
IC02.2 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC802 IC81.1
IC840 TX140
ILA-FLD-DESC
Element: Fld Desc
Derived


ICICLAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ILASET1 COMPANY
LOCATION
SYSTEM-CD
SEQ
DATE*
TIME*
FLD-NBR
AP510 IC02.1
IC02.2 IC193
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC802
IC81.1 IC840
IC92.1 TX140


ICICLAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Icdict ICDICT Required
ILA-FLD-NBR->IDI-FLD-NBR
Iclocation ICLOCATION Required
ILA-COMPANY->ICL-COMPANY
ILA-LOCATION->ICL-LOCATION
Iclocgrp ICLOCGRP Not Required
ILA-COMPANY->ILG-COMPANY
ILA-LOCATION->ILG-LOCATION
ILA-SYSTEM-CD->ILG-SYSTEM-CD
ILA-SEQ->ILG-SEQ


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

Home
Contact Us



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