GLACMXVLAU

GL Acct Attribute Value Audit

REFERENCED BY
AC191 AP125 AP126 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 API1.1 API2.1 BR44.1
CB222 FB45.1 GL100 GL110 GL111 GL120
GL122 GL135 GL148 GL167 GL190 GL195
GL196 GL199 GL330 GL500 DR100 IC141
IC142 IC222 IC83.1 CU00.1 CU01.1 CU01.2
CU02.1 CU02.2 CU03.1 CU10.1 CU10.2 CU20.1
CU20.2 CU20.3 GL00.2 GL00.3 GL00.6 GL00.7
GL00.9 GL02.1 GL02.2 GL02.3 GL02.6 GL03.6
GL10.1 GL10.2 GL121 GL124 GL125 GL160
GL161 IFAC.1 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA44.1 MA44.2 MA61.1 MAI1.1
ML146 ML167 ML190 ML195 ML196 ML199
ML330 ML40.1 ML40.2 ML40.3 ML40.7 ML40.8
ML44.1 ML45.1 RQ10.1 RQ10.3 RQ11.1 RQ13.2
RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1 MX278
MX93.7


UPDATED BY
GL146 GL197 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL70.1 GL70.2 GL70.3
GL70.6 GL14.1 GL14.5 GL14.7 GL14.8 GL16.1
GL16.2 GL16.3 GL16.4 GL20.7 GL20.8 GL20.9
MX00.1 MX00.2 MX00.3 MX05.1 MX05.2 MX06.1
MX06.2 MX10.1 MX10.2 MX135 MX20.1 MX20.2
MX20.4 MX20.5 MX305 SL40.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
GAA-OBJ-ID
Element: Obj Id		Numeric 12
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-MATRIX-CAT
Element: Matrix Cat		Alpha 12
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-CHART-NAME
Element: Chart Name		Alpha 12
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-SUMMARY-ACCT
Element: Summary Acct		Alpha 12
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-ACCOUNT
Element: Account		Numeric 6
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-SUB-ACCOUNT
Element: Sub Acct		Numeric 4
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-ACTION
Element: Action		Alpha 1

A = Add
C = Change
D = Delete
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-OPERATOR
Element: Operator		Alpha 10
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-DATE
Element: Date		Numeric 8 (yyyymmdd)
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-PROGRAM
Element: Program Code		Alpha 5
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-FIELD-NAME
Element: Field Name		Alpha 20 (Lower Case)
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-FIELD-ID
Element: Field Id		Numeric 3
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1
GAA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
GL14.1 GL14.5
GL14.7 GL14.8
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL197
GL20.7 GL20.8
GL20.9 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
MX00.1 MX00.2
MX00.3 MX05.1
MX05.2 MX06.1
MX06.2 MX10.1
MX10.2 MX135
MX20.1 MX20.2
MX20.4 MX20.5
SL40.1


GLACMXVLAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GAASET1 OBJ-ID
MATRIX-CAT
ACTION
DATE
TIME
UNIQUE-I-D
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 FB45.1
GL100 GL110
GL111 GL120
GL122 GL135
GL146 GL148
GL167 GL190
GAASET2 MATRIX-CAT
CHART-NAME
SUMMARY-ACCT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
ACTION
DATE
TIME
UNIQUE-I-D
MX278
GAASET3 CHART-NAME
SUMMARY-ACCT
ACCOUNT
SUB-ACCOUNT
MATRIX-CAT
OBJ-ID
ACTION
DATE
TIME
UNIQUE-I-D
MX278 MX93.7
GAASET4 OPERATOR
ACTION
CHART-NAME
SUMMARY-ACCT
ACCOUNT
SUB-ACCOUNT
MATRIX-CAT
DATE
OBJ-ID
UNIQUE-I-D
GAASET5 ACTION
DATE
MATRIX-CAT
CHART-NAME
SUMMARY-ACCT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
UNIQUE-I-D
GAASET6 DATE
CHART-NAME
SUMMARY-ACCT
ACCOUNT
SUB-ACCOUNT
MATRIX-CAT
ACTION
OBJ-ID
UNIQUE-I-D
MX278 MX305
GAAUID UNIQUE-I-D


GLACMXVLAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Glaccmxval GLACCMXVAL Required
GAA-OBJ-ID->GAC-OBJ-ID (GACSET1)
GAA-MATRIX-CAT->GAC-MATRIX-CAT

File created: Thu Jun 09 02:20:31 2016

Home
Contact Us



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