Lawson Insight Technical Documentation

                             FBFUNDDTL FILE

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
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    API1.1
API2.1    BR41.4    CB10.1    CB191     CB20.1    CB30.1
CB500     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
GL75.1    IC222     IFAC.1    MA41.2    MA41.7    MA43.2
MA61.1    MAI1.1    PO150     PO25.1    PO25.6    PO25.7
PO536     POIM.1    IFGT.1

UPDATED BY

FB11.1    FB111     FB211     GL110

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

FUD-FUND-GROUP         Alpha 15                                  FB11.1  FB111
Element: Fund Group    the Budget Edit Group established in      FB211
                       FB11 represents a set of accounting
                       units and accounts that are grouped
                       together for budget editng purposes.

FUD-ACCT-UNIT          Alpha 15                                  FB11.1  FB111
Element: Accounting UniThe accounting unit along with the        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 an     FB211
                       the accounting unit represent a member
                       record for the budget edit group.

FUD-SUB-ACCOUNT        Numeric 4                                 FB11.1  FB111
Element: Subaccount    The subaccount along with the company,    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                                                AP20.1  AP20.2
          SUB-ACCOUNT                                            AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR41.4
                                                                 CB10.1  CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   CA110
                                                                 ...

FUDSET2   COMPANY                                                AC191   AC40.4
          ACCOUNT                                                AC41.4  AC42.1
          SUB-ACCOUNT                                            AP125   AP126
          ACCT-UNIT                                              AP20.1  AP20.2
          FUND-GROUP                                             AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 API2.1  BR41.4
                                                                 CB10.1  CB191
                                                                 CB20.1  CB30.1
                                                                 CB500   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   CA110
                                                                 ...

                         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