GLNAMESAU

General Ledger Names Audit

REFERENCED BY
GL278 GL91.3


UPDATED 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 GL146 GL148 GL167 GL190
GL195 GL196 GL197 GL199 GL330 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
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 GL20.1 GL20.2
GL20.4 GL305 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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GNA-UNIQUE-I-D
Element: Unique I D
Bad Type 36
GNA-COMPANY
Element: Company
Numeric 4
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-ACCT-UNIT
Element: Acct Unit
Alpha 15
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-ACTION
Element: Action
Alpha 1
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-OPERATOR
Element: Operator
Alpha 10
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-DATE
Element: Date
Numeric 8 (yyyymmdd)
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-TIME
Element: Sys Time
Numeric 6 (hhmmss)
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-PROGRAM
Element: Program Code
Alpha 5
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-FIELD-NAME
Element: Acct Unit
Alpha 15
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-OLD-VALUE
Element: Account Desc
Alpha 60 (Lower Case)
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-NEW-VALUE
Element: Account Desc
Alpha 60 (Lower Case)
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
GNA-FIELD-ID
Element: Field Id
Numeric 3
...
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 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195


GLNAMESAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GNASET1 COMPANY
ACCT-UNIT
ACTION
DATE
TIME
UNIQUE-I-D
GL278 GL91.3
GNASET2 COMPANY
DATE
TIME
ACTION
ACCT-UNIT
UNIQUE-I-D
GL278 GL305
GNASET3 COMPANY
OPERATOR
ACTION
ACCT-UNIT
DATE
TIME
UNIQUE-I-D
GL278
GNASET4 COMPANY
FIELD-NAME
ACTION
DATE
TIME
ACCT-UNIT
UNIQUE-I-D
GL278
GNASET5 COMPANY
ACTION
DATE
TIME
ACCT-UNIT
UNIQUE-I-D
GL278
GNAUID UNIQUE-I-D


GLNAMESAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Account Unit GLNAMES Required
GNA-COMPANY->GLN-COMPANY (GLNSET1)
GNA-ACCT-UNIT->GLN-ACCT-UNIT
Ifdict IFDICT Required
"GNA"->IFD-DB-FILE
GNA-FIELD-ID->IFD-FLD-NBR


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

Home
Contact Us



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