GLCHTDTLAU

UPDATED BY
GL100 GL110 GL120 GL199 GL500 GL00.2
GL00.3 GL00.6 GL00.7 GL00.9 GL02.1 GL02.2
GL02.3 GL02.6 GL10.1 GL10.2 GL124 GL125
GL160 GL161 GL20.1 GL305 GL278 GL91.1
GL91.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GDA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
GDA-CHART-NAME
Element: Chart Name		Alpha 12
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-ACCOUNT
Element: Account		Numeric 6
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-SUB-ACCOUNT
Element: Sub Account		Numeric 4
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-ACTION
Element: Action		Alpha 1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-OPERATOR
Element: Operator		Alpha 10
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-DATE
Element: Date		Numeric 8 (yyyymmdd)
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-PROGRAM
Element: Program Code		Alpha 5
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-FIELD-NAME
Element: Acct Unit		Alpha 15
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500
GDA-FIELD-ID
Element: Field Id		Numeric 3
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL10.1
GL10.2 GL100
GL110 GL120
GL124 GL125
GL160 GL161
GL199 GL20.1
GL500


GLCHTDTLAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GDASET1 CHART-NAME
ACCOUNT
SUB-ACCOUNT
ACTION
DATE
TIME
UNIQUE-I-D
GL278 GL91.1
GL91.7
GDASET2 CHART-NAME
DATE
TIME
ACTION
ACCOUNT
SUB-ACCOUNT
UNIQUE-I-D
GL278 GL305
GDASET3 CHART-NAME
OPERATOR
ACCOUNT
SUB-ACCOUNT
ACTION
DATE
TIME
UNIQUE-I-D
GL278
GDASET4 CHART-NAME
FIELD-NAME
ACTION
DATE
TIME
ACCOUNT
SUB-ACCOUNT
UNIQUE-I-D
GL278
GDASET5 CHART-NAME
ACTION
DATE
TIME
ACCOUNT
SUB-ACCOUNT
UNIQUE-I-D
GL278
GDAUID UNIQUE-I-D


GLCHTDTLAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Chart Detail GLCHARTDTL Required
GDA-CHART-NAME->GDT-CHART-NAME (GDTSET2)
GDA-ACCOUNT->GDT-ACCOUNT
GDA-SUB-ACCOUNT->GDT-SUB-ACCOUNT
Ifdict IFDICT Required
"GDA"->IFD-DB-FILE
GDA-FIELD-ID->IFD-FLD-NBR

File created: Wed Jun 08 20:49:43 2016

Home
Contact Us



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