CUTRNSLAU

Currency Translation Audit

REFERENCED BY
CU278 CU91.6


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
CLA-UNIQUE-I-D
Element: Unique I D
Bad Type 36
CLA-CURRENCY-TABLE
Element: Currency Table
Alpha 12
...
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
CLA-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
CLA-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
CLA-FISCAL-YEAR
Element: Year
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
CLA-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
CLA-BUDGET-NBR
Element: Budget Nbr
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
CLA-TRANSL-CODE
Element: Transl Code
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
CLA-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
CLA-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
CLA-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
CLA-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
CLA-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
CLA-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
CLA-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
CLA-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
CLA-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


CUTRNSLAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CLASET1 CURRENCY-TABLE
COMPANY
FR-CURR-CODE
TO-CURR-CODE
FISCAL-YEAR
BUDGET-NBR
TRANSL-CODE
ACTION
DATE
TIME
UNIQUE-I-D
CU278 CU91.6
CLASET2 CURRENCY-TABLE
COMPANY
FR-CURR-CODE
TO-CURR-CODE
FISCAL-YEAR
BUDGET-NBR
TRANSL-CODE
OPERATOR
ACTION
DATE
TIME
UNIQUE-I-D
CLASET3 DATE
CURRENCY-TABLE
COMPANY
TIME
UNIQUE-I-D
CU305
CLAUID UNIQUE-I-D


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

Home
Contact Us



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