CUACCTAU

CU Account Audit

REFERENCED BY
CU278 CU91.1


UPDATED BY
AC191 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 API1.1 API2.1 BR44.1
CB222 FB45.1 GL100 GL110 GL111 GL120
GL122 GL135 GL146 GL148 GL167 GL190
GL195 GL196 GL197 GL199 GL330 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL500 DR100 IC141 IC142 IC222 IC83.1
CU00.1 CU01.1 CU01.2 CU02.1 CU02.2 CU03.1
CU10.1 CU10.2 CU20.1 CU20.2 CU20.3 CU305
GL00.2 GL00.3 GL00.6 GL00.7 GL00.9 GL02.1
GL02.2 GL02.3 GL02.6 GL03.6 GL10.1 GL10.2
GL121 GL124 GL125 GL160 GL161 GL20.1
GL20.2 GL20.4 IFAC.1 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA44.1 MA44.2 MA61.1
MAI1.1 ML146 ML167 ML190 ML195 ML196
ML199 ML330 ML40.1 ML40.2 ML40.3 ML40.7
ML40.8 ML44.1 ML45.1 RQ10.1 RQ10.3 RQ11.1
RQ13.2 RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
CAA-COMPANY
Element: Company		Numeric 4
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-FR-CURR-CODE
Element: Currency Code		Alpha 5
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-TO-CURR-CODE
Element: Currency Code		Alpha 5
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-SYSTEM
Element: System		Alpha 2
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-ACTION
Element: Action		Alpha 1
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-OPERATOR
Element: Operator		Alpha 10
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-DATE
Element: Date		Numeric 8 (yyyymmdd)
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-PROGRAM
Element: Program		Alpha 5
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-FIELD-NAME
Element: Acct Unit		Alpha 15
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-FIELD-ID
Element: Field Id		Numeric 3
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195
CAA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
 ...
AC191 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 API1.1
API2.1 BR44.1
CB222 CU00.1
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU20.1
CU20.2 CU20.3
DR100 FB45.1
GL00.2 GL00.3
GL00.6 GL00.7
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.6
GL10.1 GL10.2
GL100 GL110
GL111 GL120
GL121 GL122
GL124 GL125
GL135 GL146
GL148 GL160
GL161 GL167
GL190 GL195


CUACCTAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAASET1 COMPANY
FR-CURR-CODE
TO-CURR-CODE
SYSTEM
ACTION
DATE
TIME
UNIQUE-I-D
CU278 CU91.1
CAASET2 COMPANY
FR-CURR-CODE
TO-CURR-CODE
SYSTEM
DATE
TIME
ACTION
UNIQUE-I-D
CAASET3 DATE
COMPANY
TIME
UNIQUE-I-D
CU305
CAAUID UNIQUE-I-D


CUACCTAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Cuacct CUACCT Required
CAA-COMPANY->CUA-COMPANY (CUASET1)
CAA-FR-CURR-CODE->CUA-FR-CURR-CODE
CAA-TO-CURR-CODE->CUA-TO-CURR-CODE
CAA-SYSTEM->CUA-SYSTEM

File created: Thu Jun 09 02:20:24 2016

Home
Contact Us



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