Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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