FBTRANSAU

Budget Transactions Audit

REFERENCED 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 FB278 FB91.5 GL100 GL111 GL122
GL135 GL146 GL148 GL167 GL190 GL195
GL196 GL330 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 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 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


UPDATED BY
CA110 CA195 FB10.1 FB100 FB101 FB11.1
FB120 FB121 FB122 FB145 FB160 FB165
FB190 FB20.1 FB20.2 FB20.3 FB20.4 FB20.6
FB20.7 FB21.1 FB30.1 FB305 FB31.1 FB325
FB35.1 FB40.1 FB40.2 FB40.3 FB40.4 FB42.1
FB45.1 GL110 GL120 GL197 GL199 GL300
GL500 SNOP.1 SNRP.1 SNSP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FTA-UNIQUE-I-D
Element: Unique I D		Bad Type 36
FTA-COMPANY
Element: Company		Numeric 4
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-FISCAL-YEAR
Element: Year		Numeric 4
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-BUDGET-NBR
Element: Budget Nbr		Numeric 3
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-JE-TYPE
Element: Je Type		Alpha 1
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-CONTROL-GROUP
Element: Control Group		Numeric 8
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-LINE-NBR
Element: Line Nbr		Numeric 6
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-ACTION
Element: Action		Alpha 1

A = Add
C = Change
D = Delete
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-OPERATOR
Element: Operator		Alpha 10
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-DATE
Element: Date		Numeric 8 (yyyymmdd)
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-TIME
Element: Sys Time		Numeric 6 (hhmmss)
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-PROGRAM
Element: Program Code		Alpha 5
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-FIELD-NAME
Element: Field Name		Alpha 20 (Lower Case)
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-FIELD-ID
Element: Field Id		Numeric 3
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-OLD-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1
FTA-NEW-VALUE
Element: Account Desc		Alpha 60 (Lower Case)
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB160 FB165
FB190 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FB40.3 FB40.4
FB42.1 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
SNOP.1 SNRP.1
SNSP.1


FBTRANSAU FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FTASET1 COMPANY
FISCAL-YEAR
BUDGET-NBR
JE-TYPE
CONTROL-GROUP
LINE-NBR
ACTION
DATE
TIME
UNIQUE-I-D
...
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 FB278
FB45.1 FB91.5
GL100 GL110
GL111 GL120
GL122 GL135
GL146 GL148
FTASET2 COMPANY
FISCAL-YEAR
JE-TYPE
BUDGET-NBR
CONTROL-GROUP
LINE-NBR
ACTION
DATE
TIME
UNIQUE-I-D
FTASET3 OPERATOR
ACTION
DATE
COMPANY
FISCAL-YEAR
BUDGET-NBR
JE-TYPE
CONTROL-GROUP
LINE-NBR
UNIQUE-I-D
FTASET4 ACTION
DATE
COMPANY
FISCAL-YEAR
BUDGET-NBR
JE-TYPE
CONTROL-GROUP
LINE-NBR
UNIQUE-I-D
FTASET5 DATE
COMPANY
ACTION
FISCAL-YEAR
BUDGET-NBR
JE-TYPE
CONTROL-GROUP
LINE-NBR
UNIQUE-I-D
FB305
FTAUID UNIQUE-I-D


FBTRANSAU FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Fbtrans FBTRANS Required
FTA-COMPANY->FLT-COMPANY (FLTSET2)
FTA-FISCAL-YEAR->FLT-FISCAL-YEAR
FTA-BUDGET-NBR->FLT-BUDGET-NBR
FTA-JE-TYPE->FLT-JE-TYPE
FTA-CONTROL-GROUP->FLT-CONTROL-GROUP
FTA-LINE-NBR->FLT-LINE-NBR

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

Home
Contact Us



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