Lawson Insight Technical Documentation |
|
FBFUNDAMT
FBFUNDAMT FILE
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 AP125 AP126
AP170 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 AP520 API1.1 API2.1
BR41.4 BR44.1 CB10.1 CB15.1 CB15.2 CB150
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 EE135 EE35.1
EE35.2 EE520 CA110 GL165 GL170 GL65.1
GL70.1 GL70.2 GL70.3 GL70.5 GL70.6 GL75.1
IFAC.1 MA41.1 MA41.2 MA41.4 MA41.7 MA43.2
MA61.1 MAI1.1 PO150 PO25.1 PO25.6 PO25.7
PO536 POIM.1 RQ10.1 RQ10.3 RQ11.1 RQ13.2
RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1
UPDATED BY
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 GL190 GL191
GL197 GL199 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL500 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBB-COMPANY Numeric 4 CA195 FB100
Element: Company The company number represents an FB101 FB11.1
established General Ledger company. 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
GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
FBB-FUND-GROUP Alpha 15 CA195 FB100
Element: Fund Group The Fund Group represents a set of FB101 FB11.1
accounting units and accounts that are FB111 FB120
grouped together for budget editing FB121 FB122
purposes. 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 GL146
GL167 GL190
GL191 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
FBB-FISCAL-YEAR Numeric 4 CA195 FB100
Element: Fiscal Year The fiscal year of the record. 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 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-AMOUNT Signed 18.2 CA195 FB100
Element: Intl Amt the cumulative beginning balance total FB101 FB11.1
(GLAMOUNTS) and released transactions FB120 FB121
(GLTRANS) for the budget edit group for FB122 FB145
the fiscal year. 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 Signed 18.2 Occurs 13 Times CA195 FB100
Element: Intl Amt The cumulative period balance FB101 FB11.1
(GLAMOUNTS) and the released FB120 FB121
transactions (GLTRANS) for the budget FB122 FB145
edit group. 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 Signed 18.2 CA195 FB100
Element: Intl Amt The cumulative commitment budget FB101 FB11.1
beginning balance for the budget edit FB120 FB121
group. 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 Signed 18.2 Occurs 13 Times CA195 FB100
Element: Intl Amt The cumulative commitment budget period FB101 FB11.1
balance for the budget edit group. 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
FBFUNDAMT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBBSET1 COMPANY AC191 AC40.4
FUND-GROUP AC41.4 AC42.1
FISCAL-YEAR AP125 AP126
AP170 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 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1
CB15.2 CB150
...
FBFUNDAMT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Fbfundhdr FBFUNDHDR Required
FBB-COMPANY -> FUH-COMPANY
FBB-FUND-GROUP -> FUH-FUND-GROUP
|