Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FBFUNDREL


                             FBFUNDREL FILE

                         Budget Fund Interface

The Budget Edit Group conversion file contains information for budget edit
groups from a non-ln-Lawson system to the Lawson General Ledger system.

REFERENCED BY

FB260

UPDATED BY

FB160     FB60.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FFR-RUN-GROUP          Alpha 15                                  FB60.1
Element: Run Group     Run Group and Seq Number are the keys
                       to the file.  They are used to group
                       records together for interfacing.

FFR-SEQ-NUMBER         Numeric 6                                 FB60.1
Element: Seq Number    A unique number assigned to each
                       transaction to be interfaced into the
                       Lawson system.

FFR-COMPANY            Numeric 4                                 FB60.1
Element: Company       The company number represents an
                       established General Ledger company.

FFR-FUND-GROUP         Alpha 15                                  FB60.1
Element: Fund Group    The budget edit group name established
                       in  FB11 represents a set of acounting
                       units and accounts that are grouped
                       together for budget editing purposes.

FFR-DESCRIPTION        Alpha 30  (Lower Case)                    FB60.1
Element: Description   The budget edit group description.

FFR-ACCT-UNIT          Alpha 15                                  FB60.1
Element: Acct Unit     An Accounting Unit. List or Level Group
                       is required.
                       The value is used to build the members
                       of the group (FBFUNDDTL).

FFR-ACCT-UNIT-LIST     Alpha 12                                  FB60.1
Element: Acct Unit ListAn Accounting Unit. List or Level Group
                       is required.
                       The value is used to build the members
                       of the group (FBFUNDDTL).

FFR-LEVEL-GROUP        Alpha 12                                  FB60.1
Element: Level Group   An Accounting Unit. List or Level Group
                       is required.
                       The value is used to build the members
                       of the group (FBFUNDDTL).

FFR-SUMMARY-ACCT       Alpha 12                                  FB60.1
Element: Summary Acct  A Summary Account, List or Account
                       Group is required.
                       The value is used to build the members
                       of the group (FBFUNDDTL).

FFR-ACCOUNT-GROUP      Alpha 12                                  FB60.1
Element: Account Group A Summary Account, List or Account
                       Group is required.
                       The value is used to build the members
                       of the group (FBFUNDDTL).

FFR-ACCOUNT-LIST       Alpha 12                                  FB60.1
Element: Account List  A Summary Account, List or Account
                       Group is required.
                       The value is used to build the members
                       of the group (FBFUNDDTL).

FFR-SUB-ACCT-GRP       Alpha 12                                  FB60.1
Element: Sub Acct Grp  The Subaccount Group is not required.
                       If a value is entered the specified
                       subaccounts will be included in the
                       detail members.  If the value is blank,
                       only major accounts will be included in
                       the members (FBFUNDDTL).

                         FBFUNDREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FFRSET1   RUN-GROUP                                              FB160   FB260
          SEQ-NUMBER                                             FB60.1

FFRSET2   FUND-GROUP                                             FB160
          RUN-GROUP
          SEQ-NUMBER