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 IC222 EX545
IFAC.1 IFEB.1 ML165 ML65.1 POIK.1 POIM.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 AP510 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
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
EX175 EX542 EXI2.1 EXI4.1 IFGT.1 IFUC.1
LP130 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 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
PD570 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO131 PO132
PO135 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO18.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 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 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 PR36.4
PR37.1 PR38.1 PR45.1 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 PR85.1 PR89.1
PRAT.1 UK102 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQD0.1 RQIB.1
RQIF.1 RQII.1 RQIJ.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

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
AP510 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
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
AP510 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
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
AP510 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
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
AP510 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
IC141 IC142
IC145 IC243
IC330 IC83.1
IFGT.1 IFUC.1
LP130 MA180
FBB-ROLLOVER-BAL
Element: Intl Amt
Signed 18.2
...
AP125 AP126
AP131 AP170
AP190 AP193
AP21.1 AP23.1
AP26.1 AP27.1
AP510 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
IC141 IC142
IC145 IC243
IC330 IC83.1
IFGT.1 IFUC.1
LP130 MA180


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
AP510 AP520
API1.1 API2.1
ARLL.1 BN150


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 02:13:47 2016

Home
Contact Us



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