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
CA110 GL165 GL65.1 EX545 IFAC.1 IFEB.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 AP520 API1.1 API2.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 CB80.1 CB82.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 EX175 EX542
EXI2.1 EXI4.1 IFGT.1 IFUC.1 LP130 LP140
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PA182
PO136 PO190 PO300 PO520 POCP.1 POI3.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 TA147

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 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
CB80.1 CB82.1
EE135 EE35.1
EE35.2 EE520
EX175 EX542
EXI2.1 EXI4.1
FB100 FB101
FB11.1 FB111
FB120 FB121
FB122 FB145
FB160 FB165
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 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
CB80.1 CB82.1
EE135 EE35.1
EE35.2 EE520
EX175 EX542
EXI2.1 EXI4.1
FB100 FB101
FB11.1 FB111
FB120 FB121
FB122 FB145
FB160 FB165
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 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
CB80.1 CB82.1
EE135 EE35.1
EE35.2 EE520
EX175 EX542
EXI2.1 EXI4.1
FB100 FB101
FB11.1 FB111
FB120 FB121
FB122 FB145
FB160 FB165
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
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-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 BN150
BN66.1 CB150
CB180 CB191
CB500 CB543
CB544 CB554
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 IFGT.1
IFUC.1 LP130
LP140 MAI1.1
PA182 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POII.1 POIJ.1
PR128 PR130
PR131 PR132
PR134 PR135
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 BN150
BN66.1 CB150
CB180 CB191
CB500 CB543
CB544 CB554
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 IFGT.1
IFUC.1 LP130
LP140 MAI1.1
PA182 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POIF.1
POII.1 POIJ.1
PR128 PR130
PR131 PR132
PR134 PR135


FBFUNDAMT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBBSET1 COMPANY
FUND-GROUP
FISCAL-YEAR
...
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 BN150
BN66.1 CB10.1
CB15.1 CB15.2
CB150 CB180


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: Wed Jun 08 20:48:37 2016

Home
Contact Us



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