Lawson Insight Technical Documentation

                             FBFUNDDTL FILE

REFERENCED BY

AC191     AP125     AP126     AP25.1    AP25.2    AP26.1
AP27.1    CB10.1    CB191     CB20.1    CB30.1    CB500
EE135     EE35.1    EE35.2    EE520     CA110     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    POIM.1

UPDATED BY

FB11.1    FB211

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

FUD-COMPANY          Numeric 4                                   FB11.1  FB211
Company              The company number represents an
                     established company and is entered on
                     all function codes.


FUD-FUND-GROUP       Alpha 15                                    FB11.1  FB211
Fund Group

FUD-ACCT-UNIT        Alpha 15                                    FB11.1  FB211
Accounting Unit      The accounting unit is a shorthand
                     notation representing the variable level
                     number. When used in the General Ledger
                     Account Master file, the accounting unit
                     must be defined in the General Ledger
                     Names file as a posting accounting unit.


FUD-ACCOUNT          Numeric 6                                   FB11.1  FB211
Account              This field along with the accounting
                     unit and subaccount make up the location
                     (account) where amounts and other
                     account information is stored.

FUD-SUB-ACCOUNT      Numeric 4                                   FB11.1  FB211
Subaccount           This field along with the accounting
                     unit and subaccount make up the location
                     (account) where amounts and other
                     account information is stored.

                         FBFUNDDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FUDSET1   COMPANY                                                AC191   AP125
          FUND-GROUP                                             AP126   AP25.1
          ACCT-UNIT                                              AP25.2  AP26.1
          ACCOUNT                                                AP27.1  CB10.1
          SUB-ACCOUNT                                            CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 CA110   FB11.1
                                                                 FB11.2  FB190
                                                                 FB211   FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL146
                                                                 GL165   GL170
                                                                 GL197   GL40.1
                                                                 ...

FUDSET2   COMPANY                                                AC191   AP125
          ACCOUNT                                                AP126   AP25.1
          SUB-ACCOUNT                                            AP25.2  AP26.1
          ACCT-UNIT                                              AP27.1  CB10.1
          FUND-GROUP                                             CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 CA110   FB11.1
                                                                 FB190   FB211
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL146   GL165
                                                                 GL170   GL197
                                                                 GL40.1  GL40.2
                                                                 ...

                         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