GLNAMESAU

REFERENCED BY
GL278 GL91.3 GL91.9


UPDATED BY
GL100 GL110 GL111 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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GNA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
GNA-COMPANY
Element: Company		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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-ACCT-UNIT
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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500
GNA-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 GL111
GL120 GL124
GL125 GL160
GL161 GL199
GL20.1 GL500


GLNAMESAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GNASET1 COMPANY
ACCT-UNIT
ACTION
DATE
TIME
UNIQUE-I-D
GL278 GL91.3
GL91.9
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 11:18:41 2016

Home
Contact Us



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