RJCNTRLAU

Recurring Journal Ctrl Audit

REFERENCED BY
GL279 GL92.3


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
RCU-UNIQUE-I-D
Element: Unique I D		Bad Type 36
RCU-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
RCU-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
RCU-REC-GROUP
Element: Rec 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
RCU-ACTION
Element: Action		Alpha 1

A
D
C		 ...
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
RCU-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
RCU-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
RCU-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
RCU-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
RCU-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
RCU-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
RCU-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
RCU-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
RCU-CHART-NAME
Element: Chart Name		Alpha 12


RJCNTRLAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RCUSET1 COMPANY
JE-TYPE
REC-GROUP
ACTION
DATE
TIME
UNIQUE-I-D
GL279 GL306
GL92.3
RCUSET2 COMPANY
OPERATOR
ACTION
DATE
TIME
UNIQUE-I-D
RCUSET3 COMPANY
ACTION
DATE
TIME
UNIQUE-I-D
RCUSET4 DATE
COMPANY
JE-TYPE
REC-GROUP
UNIQUE-I-D
GL306
RCUUID UNIQUE-I-D


RJCNTRLAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Rjcntrlau1 RJCONTROL Required
RCU-COMPANY->RJC-COMPANY (RJCSET1)
RCU-JE-TYPE->RJC-JE-TYPE
RCU-REC-GROUP->RJC-REC-GROUP

File created: Thu Jun 09 02:14:21 2016

Home
Contact Us



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