GLNAMESAU

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.3
GL91.9

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 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 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 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 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 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 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 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 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 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 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 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: Wed Jun 08 20:49:45 2016

Home
Contact Us



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