AMLOCAUDIT

AM Location Audit

REFERENCED BY
AM81.2


UPDATED BY
AC10.1 AC10.3 AC160 AC56.1 AC560 AC71.1
AM07.1 AM07.2 AM07.3 AM115 AM117 AM12.1
AM12.2 AM15.1 AM15.2 AM15.3 AM15.4 AM17.1
AM170 AM19.1 AM19.2 AM20.1 AM20.2 AM20.3
AM20.4 AM20.5 AM20.6 AM21.1 AM21.2 AM21.3
AM21.4 AM21.5 AM21.6 AM22.1 AM22.2 AM500
AM52.1 AM551 AM88.7 AM96.1 AM98.1 AP115
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
AP305 AP510 API1.1 API2.1 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 DR100 IC12.1 IC140 IC141
IC142 IC145 IC243 IC330 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC66.1 IC83.1 MA126 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA44.1 MA44.2 MA53.1 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA69.1
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500
RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 AM288 AM305

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LOA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
LOA-LOCATION-NAME
Element: Location Name		Alpha 15
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-ACTION
Element: Action		Alpha 1
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-OPERATOR
Element: Operator		Alpha 10
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-DATE
Element: Date		Numeric 8 (yyyymmdd)
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-PROGRAM
Element: Program Code		Alpha 5
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-FIELD-NAME
Element: Acct Unit		Alpha 15
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-FIELD-ID
Element: Field Id		Numeric 3
 ...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
LOA-FLD-NAME-DESC
Element: Loa Fld Name		Derived


AMLOCAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LOASET1 LOCATION-NAME
DATE
TIME
ACTION
UNIQUE-I-D
AM288 AM305
AM81.2
LOASET2 LOCATION-NAME
OPERATOR
ACTION
DATE
TIME
UNIQUE-I-D
AM288 AM81.2
LOASET3 LOCATION-NAME
FIELD-NAME
ACTION
DATE
TIME
UNIQUE-I-D
AM288 AM81.2
LOASET4 LOCATION-NAME
ACTION
DATE
TIME
UNIQUE-I-D
AM288 AM81.2
LOAUID UNIQUE-I-D


AMLOCAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Amdict2 AMDICT2 Required
"LOC"->AMZ-DB-FILE-PFX (AMZSET1)
LOA-FIELD-ID->AMZ-FLD-NBR
Amlocation AMLOCATION Required
LOA-LOCATION-NAME->LOC-LOCATION-NAME

File created: Thu Jun 09 02:05:35 2016

Home
Contact Us



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