FBFUNDAMT

Budget Fund Balance

The Budget Edit Group Balance file contains the stored commitment budget balance and the released General Ledger transaction balance/posted balance for the budget edit group established in FB11.

REFERENCED BY
AC191 AC40.4 AC41.4 AC42.1 BR41.4 BR44.1
CB222 CA110 GL165 GL65.1 IC141 IC142
IC222 EX545 IFAC.1 IFEB.1 ML165 ML65.1
POIK.1 POIM.1 RQ11.1 RQIB.1 RQIJ.1


UPDATED BY
AP125 AP126 AP131 AP170 AP190 AP193
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 AP520 API1.1 API2.1 ARLL.1
BN150 BN66.1 CB10.1 CB15.1 CB150 CB180
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 CB57.1 CB80.1
CB82.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 EE135
EE35.1 EE35.2 EE520 CA195 FB100 FB101
FB11.1 FB111 FB120 FB121 FB122 FB145
FB160 FB165 FB190 FB20.1 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB211 FB30.1 FB31.1
FB40.1 FB40.2 FB40.3 FB45.1 GL110 GL146
GL167 GL170 GL190 GL191 GL197 GL199
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL500 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 GL76.1 PR521 DR100 IC140
IC66.1 IC83.1 EX175 EX542 EXI2.1 EXI4.1
IFGT.1 IFUC.1 LP130 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PA182
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO135 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POD0.1
POI3.1 POID.1 POIF.1 POII.1 POIJ.1 PR128
PR130 PR131 PR132 PR134 PR135 PR136
PR137 PR140 PR189 PR195 PR197 PR29.1
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR37.1 PR38.1 PR45.1 PR529
PR530 PR560 PR582 PR80.1 PR80.4 PR82.1
PR85.1 PR89.1 UK102 UK330 UK560 ZP530
RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQD0.1 RQIF.1 TA147 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBB-COMPANY
Element: Company		Numeric 4
The company number represents an established General Ledger company. 		...
AP125 AP126
AP131 AP170
AP190 AP193
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
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CA195 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
FBB-FUND-GROUP
Element: Fund Group		Alpha 15
The Fund Group represents a set of accounting units and accounts that are grouped together for budget editing purposes. 		...
AP125 AP126
AP131 AP170
AP190 AP193
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
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CA195 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
FBB-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
The fiscal year of the record. 		...
AP125 AP126
AP131 AP170
AP190 AP193
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
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CA195 CB10.1
CB15.1 CB150
CB180 CB191
CB20.1 CB30.1
CB45.1 CB46.1
CB500 CB543
CB544 CB55.1
CB554 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
FBB-BEG-BAL-AMOUNT
Element: Intl Amt		Signed 18.2
the cumulative beginning balance total (GLAMOUNTS) and released transactions (GLTRANS) for the budget edit group for the fiscal year.
CA195 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL146
GL167 GL190
GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
FBB-PER-AMOUNT
Element: Intl Amt		Signed 18.2 Occurs 13 Times
The cumulative period balance (GLAMOUNTS) and the released transactions (GLTRANS) for the budget edit group.
CA195 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL146
GL167 GL190
GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
FBB-BEG-BAL-BUD
Element: Intl Amt		Signed 18.2
The cumulative commitment budget beginning balance for the budget edit group.
CA195 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL146
GL167 GL190
GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
FBB-PER-BUDGET
Element: Intl Amt		Signed 18.2 Occurs 13 Times
The cumulative commitment budget period balance for the budget edit group.
CA195 FB100
FB101 FB11.1
FB120 FB121
FB122 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB30.1 FB31.1
FB40.1 FB40.2
FB40.3 FB45.1
GL146 GL167
GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
FBB-ROLLOVER-AMT
Element: Intl Amt		Signed 18.2
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP21.1 AP23.1
AP26.1 AP27.1
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB150 CB180
CB191 CB500
CB543 CB544
CB554 CB57.1
CX100 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE520 EX175
EX542 EXI2.1
EXI4.1 FB11.1
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL170 GL197
GL199 GL75.1
IC140 IC83.1
IFGT.1 IFUC.1
LP130 MA180
MA530 MA531
MA70.1 MA75.1
MA80.1 MAI1.1
FBB-ROLLOVER-BAL
Element: Intl Amt		Signed 18.2
 ...
AP125 AP126
AP131 AP170
AP190 AP193
AP21.1 AP23.1
AP26.1 AP27.1
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1
CB150 CB180
CB191 CB500
CB543 CB544
CB554 CB57.1
CX100 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE520 EX175
EX542 EXI2.1
EXI4.1 FB11.1
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL170 GL197
GL199 GL75.1
IC140 IC83.1
IFGT.1 IFUC.1
LP130 MA180
MA530 MA531
MA70.1 MA75.1
MA80.1 MAI1.1


FBFUNDAMT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBBSET1 COMPANY
FUND-GROUP
FISCAL-YEAR
...
AC191 AC40.4
AC41.4 AC42.1
AP125 AP126
AP131 AP170
AP190 AP193
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
AP520 API1.1
API2.1 ARLL.1
BN150 BN66.1


FBFUNDAMT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Fbfundhdr FBFUNDHDR Required
FBB-COMPANY->FUH-COMPANY
FBB-FUND-GROUP->FUH-FUND-GROUP

File created: Thu Jun 09 11:13:04 2016

Home
Contact Us



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