Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FBFUNDDTL


                             FBFUNDDTL FILE

                           Budget Fund Detail

The Budgt Edit Group Detail file contains a record for each member of the
group maintained 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     FB145     FB190     FB40.1
FB40.2    FB40.3    FB45.1    GL146     GL165     GL170
GL197     GL40.1    GL40.2    GL40.3    GL40.7    GL40.8
GL44.1    GL45.1    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    CA195     FB100     FB101     FB120
FB121     FB122     FB165     FB20.1    FB20.3    FB20.4
FB20.6    FB20.7    FB21.1    FB30.1    FB31.1    GL167
GL190     GL191     GL199     GL500     IFGT.1

UPDATED BY

FB11.1    FB111     FB160     FB211     GL110

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FUD-COMPANY            Numeric 4                                 FB11.1  FB111
Element: Company       The company number represents an          FB160   FB211
                       established General Ledger company.       GL110

FUD-FUND-GROUP         Alpha 15                                  FB11.1  FB111
Element: Fund Group    The budget edit group established in      FB160   FB211
                       FB11 represents a set of accounting
                       units and accounts that are grouped
                       together for budget editing purposes.

FUD-ACCT-UNIT          Alpha 15                                  FB11.1  FB111
Element: Acct Unit     The accounting unit along with the        FB160   FB211
                       company and account represent a member
                       record for the budget edit group.

FUD-ACCOUNT            Numeric 6                                 FB11.1  FB111
Element: Account       The account along with the company and    FB160   FB211
                       accounting unit represent a member
                       record  for the budget edit group.

FUD-SUB-ACCOUNT        Numeric 4                                 FB11.1  FB111
Element: Sub Acct      The subaccount along with the company,    FB160   FB211
                       accounting unit and account represent a
                       member record for the budget edit group.

                         FBFUNDDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FUDSET1   COMPANY                                                AC191   AC40.4
          FUND-GROUP                                             AC41.4  AC42.1
          ACCT-UNIT                                              AP125   AP126
          ACCOUNT                                                AP170   AP193
          SUB-ACCOUNT                                            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
                                                                 ...

FUDSET2   COMPANY                                                AC191   AC40.4
          ACCOUNT                                                AC41.4  AC42.1
          SUB-ACCOUNT                                            AP125   AP126
          ACCT-UNIT                                              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
                                                                 ...

                         FBFUNDDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Fbfundhdr      FBFUNDHDR    Required

                            FUD-COMPANY       -> FUH-COMPANY
                            FUD-FUND-GROUP    -> FUH-FUND-GROUP