AMLOCAUDIT

UPDATED BY
AC10.1 AC10.3 AM07.1 AM07.2 AM07.3 AM115
AM117 AM12.1 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 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
API1.1 API2.1 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MAI1.1 PO136 PO190 PO300 PO520 POCP.1
POI3.1 POII.1 POIJ.1 AM288 AM305 AM81.2

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
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
LOA-ACTION
Element: Action		Alpha 1
 ...
AC10.1 AC10.3
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
LOA-OPERATOR
Element: Operator		Alpha 10
 ...
AC10.1 AC10.3
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
LOA-DATE
Element: Date		Numeric 8 (yyyymmdd)
 ...
AC10.1 AC10.3
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
LOA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
 ...
AC10.1 AC10.3
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
LOA-PROGRAM
Element: Program Code		Alpha 5
 ...
AC10.1 AC10.3
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
LOA-FIELD-NAME
Element: Acct Unit		Alpha 15
 ...
AC10.1 AC10.3
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
LOA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
 ...
AC10.1 AC10.3
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
LOA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
 ...
AC10.1 AC10.3
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
LOA-FIELD-ID
Element: Field Id		Numeric 3
 ...
AC10.1 AC10.3
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
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
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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
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
Amlocation AMLOCATION Required
LOA-LOCATION-NAME->LOC-LOCATION-NAME (LOCSET1)

File created: Wed Jun 08 20:47:10 2016

Home
Contact Us



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