GLCNTRLAU

Journal Control Audit

REFERENCED BY
GL279 GL92.1


UPDATED BY
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 AP30.2 AP30.4 CA00.1 CA00.2
CA05.1 CA05.2 CA10.1 CA10.2 CA10.4 CA10.6
CA10.7 CA15.1 CA15.2 CA160 GL110 GL145
GL146 GL148 GL167 GL170 GL190 GL191
GL196 GL197 GL199 GL300 GL306 GL40.1
GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL41.4
GL44.1 GL45.1 GL500 GL70.1 GL70.2 GL70.3
GL70.6 GL75.1 IFGT.1 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA44.1 MA44.2 MA61.1
MA70.1 MA75.1 MAI1.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCU-UNIQUE-I-D
Element: Unique I D
Bad Type 36
GCU-COMPANY
Element: Company
Numeric 4
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-ACCT-PERIOD
Element: Acct Period
Numeric 2
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-SYSTEM
Element: System
Alpha 2
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-JE-TYPE
Element: Je Type
Alpha 1
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-CONTROL-GROUP
Element: Control Group
Numeric 8
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-JE-SEQUENCE
Element: Je Sequence
Numeric 2
GCU-ACTION
Element: Action
Alpha 1

A
C
D
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-OPERATOR
Element: Operator
Alpha 10
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-DATE
Element: Date
Numeric 8 (yyyymmdd)
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-TIME
Element: Sys Time
Numeric 6 (hhmmss)
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-PROGRAM
Element: Program
Alpha 5
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-FIELD-NAME
Element: Acct Unit
Alpha 15
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-FIELD-ID
Element: Field Id
Numeric 3
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-OLD-VALUE
Element: Account Desc
Alpha 60 (Lower Case)
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7
GCU-NEW-VALUE
Element: Account Desc
Alpha 60 (Lower Case)
...
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
AP30.2 AP30.4
CA00.1 CA00.2
CA05.1 CA05.2
CA10.1 CA10.2
CA10.4 CA10.6
CA10.7 CA15.1
CA15.2 CA160
GL110 GL145
GL146 GL148
GL167 GL170
GL190 GL191
GL196 GL197
GL199 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL41.4 GL44.1
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1 IFGT.1
MA41.1 MA41.2
MA41.4 MA41.7


GLCNTRLAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCUSET1 COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
ACTION
DATE
TIME
UNIQUE-I-D
GL279 GL306
GL92.1
GCUSET2 COMPANY
SYSTEM
ACTION
DATE
TIME
JE-TYPE
UNIQUE-I-D
GCUSET3 COMPANY
FISCAL-YEAR
OPERATOR
ACTION
DATE
TIME
SYSTEM
UNIQUE-I-D
GCUSET4 COMPANY
FISCAL-YEAR
ACTION
DATE
TIME
SYSTEM
UNIQUE-I-D
GCUSET5 COMPANY
FISCAL-YEAR
DATE
ACTION
UNIQUE-I-D
GCUSET6 FIELD-NAME
ACTION
DATE
TIME
UNIQUE-I-D
GCUSET7 DATE
COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
UNIQUE-I-D
GL306
GCUUID UNIQUE-I-D


GLCNTRLAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glcntrlau1 GLCONTROL Required
GCU-COMPANY->GLC-COMPANY (GLCSET1)
GCU-FISCAL-YEAR->GLC-FISCAL-YEAR
GCU-ACCT-PERIOD->GLC-ACCT-PERIOD
GCU-SYSTEM->GLC-SYSTEM
GCU-JE-TYPE->GLC-JE-TYPE
GCU-CONTROL-GROUP->GLC-CONTROL-GROUP
GCU-JE-SEQUENCE->GLC-JE-SEQUENCE


File created: Thu Jun 09 02:13:58 2016

Home
Contact Us



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