RATOTALAU

Ratio Totals Audit

REFERENCED BY
RW278 RW91.7


UPDATED BY
FB01.1 FB01.2 FB141 GL292 GL293 GL294
GL95.4 GL99.1 RW00.1 RW00.6 RW03.1 RW03.2
RW10.2 RW10.3 RW10.4 RW10.8 RW11.1 RW11.2
RW11.3 RW11.4 RW20.1 RW20.2 RW20.8 RW210
RW30.1 RW305 RW40.1 RW40.3 RW40.4 RW40.5
RW40.6 RW40.7 RW40.8 RW50.1 RW60.1 RW60.2
RW60.3 RW70.1 ML292 ML293 ML95.4 ML99.1
SNGL.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
RTA-TOTAL-NAME
Element: Total Name		Alpha 10
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-FISCAL-YEAR
Element: Year		Numeric 4
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-ACCT-UNIT
Element: Acct Unit		Alpha 15
RTA-ACTION
Element: Action		Alpha 1

A = Add
C = Change
D = Delete
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-OPERATOR
Element: Operator		Alpha 10
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-DATE
Element: Date		Numeric 8 (yyyymmdd)
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-PROGRAM
Element: Program Code		Alpha 5
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-FIELD-NAME
Element: Acct Unit		Alpha 15
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-FIELD-ID
Element: Field Id		Numeric 3
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1
RTA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
FB01.1 FB01.2
FB141 GL292
GL293 GL294
GL95.4 GL99.1
ML292 ML293
ML95.4 ML99.1
RW00.1 RW00.6
RW03.1 RW03.2
RW10.2 RW10.3
RW10.4 RW10.8
RW11.1 RW11.2
RW11.3 RW11.4
RW20.1 RW20.2
RW20.8 RW210
RW30.1 RW40.1
RW40.3 RW40.4
RW40.5 RW40.6
RW40.7 RW40.8
RW50.1 RW60.1
RW60.2 RW60.3
RW70.1 SNGL.1


RATOTALAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTASET1 TOTAL-NAME
FISCAL-YEAR
ACTION
DATE
TIME
UNIQUE-I-D
RW278 RW305
RW91.7
RTASET2 TOTAL-NAME
FISCAL-YEAR
OPERATOR
ACTION
DATE
TIME
UNIQUE-I-D
RW278
RTASET3 TOTAL-NAME
FISCAL-YEAR
DATE
TIME
ACTION
UNIQUE-I-D
RW278 RW305
RTASET4 TOTAL-NAME
FISCAL-YEAR
FIELD-NAME
ACTION
DATE
TIME
UNIQUE-I-D
RW278
RTAUID UNIQUE-I-D


RATOTALAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Ratotals RATOTALS Required
RTA-FISCAL-YEAR->RAT-FISCAL-YEAR (RATSET1)
RTA-TOTAL-NAME->RAT-TOTAL-NAME
RTA-ACCT-UNIT->RAT-ACCT-UNIT

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

Home
Contact Us



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