Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FBUDGETREL


                            FBUDGETREL FILE

                        Budgeting Relationships

The Budget Relations file contains information for budget conversion from a
non-Lawson system to the Lawson General Ledger system.


REFERENCED BY

FB265

UPDATED BY

FB195     FB65.1    FB165

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FBR-RUN-GROUP          Alpha 15                                  FB195   FB65.1
Element: Run Group     The run group name. A run group name is
                       the name you assigned to the file when
                       you transferred the non-Lawson file to
                       the target machine.


FBR-SEQ-NUMBER         Numeric 6                                 FB195   FB65.1
Element: Sequence      The sequence number is a unique number
                       assigned to each transaction to be
                       transferred into the Lawson system.

                       Run Group and Sequence Number are the
                       keys to this file. Use these fields to
                       group records together for
                       interfacing.



FBR-OLD-COMPANY        Alpha 35                                  FB195   FB65.1
Element: OrganizationalThe old company identification code
                       defined in GL08.1 (Organization
                       Relationships).


FBR-OLD-CPY-SHORT      Derived
Old Company (Short     This is a short version of the old
Version)               company structure.


FBR-OLD-ACCT-NBR       Alpha 25                                  FB195   FB65.1
Element: Old Account NuThe old account identification code
                       defined in GL09.1 (Account
                       Relationships).


FBR-OLD-ACCT-SHORT     Derived
Old Acct Nbr (Short    This is the short version of the old
Version)               account structure.


FBR-FISCAL-YEAR        Numeric 4                                 FB195   FB65.1
Element: Year          This is the fiscal year budgets are
                       transferred in.


FBR-BUDGET-NBR         Numeric 3                                 FB195   FB65.1
Element: Budget        The budget number as defined in FB20.1
                       (Period Budget, Rate) you are converting
                       data to.


FBR-BEGIN-BAL          Signed 15.2                               FB195   FB65.1
Element: Beg Bal       The beginning balance period amount for
                       balance sheet accounts. For example, the
                       amount you spent for the computers in a
                       particular period.

                       If you select units and a rate, the
                       system calculates the amount.



FBR-AMOUNT             Currency 15.2 Occurs 13 Times             FB195   FB65.1
Element: Amounts       The period amount. For example, how
                       much you spent on computers in a period.



FBR-BEGIN-BAL-UNT      Signed 15.2                               FB195   FB65.1
Element: Beg Bal       The units beginning balance for a
                       balance sheet account. For example, a
                       unit would be the number of computers
                       purchased.


FBR-UNITS              Signed 15.2 Occurs 13 Times               FB195   FB65.1
Element: Amounts       The budget unit. For example, a unit
                       would be the number of computers
                       purchased.


FBR-BEG-BAL-RATE       Signed 12.6                               FB165   FB195
Element: Account Rate  The rate that affects the factor. For     FB65.1
                       example, the inflation rate or an
                       employees hourly contract salary.


FBR-FACTOR-RATE        Signed 12.6 Occurs 13 Times               FB165   FB195
Element: Account Rate  The rate that affects the factor. For     FB65.1
                       example, the inflation rate.


FBR-BEG-BAL-FACTOR     Alpha 15                                  FB195   FB65.1
Element: Factor        The global factor defined in FB00.1
                       (Global Factors) that is used to help
                       calculate the budget amount.


FBR-FACTOR             Alpha 15 Occurs 13 Times                  FB195   FB65.1
Element: Factor        The global factor defined in FB00.1
                       (Global Factors) that is used to
                       calculate the budget amount.


FBR-AMOUNT-TYPE        Alpha 1                                   FB165   FB195
Element: Type          This field determines whether the         FB65.1
                       amount fields are period balances or
                       year-to-date balances.  The interface
                       program uses this field to load the
                       files correctly.

                       P = Period
                       Y = YTD

                         FBUDGETREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FBRSET1   RUN-GROUP                                              FB165   FB195
          SEQ-NUMBER*                                            FB65.1

FBRSET2   RUN-GROUP     KeyChange                                FB265
          OLD-COMPANY
          OLD-ACCT-NBR
          FISCAL-YEAR
          BUDGET-NBR
          SEQ-NUMBER

                         FBUDGETREL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glacctrel      GLACCTREL    Not Required

                            FBR-OLD-ACCT-NBR    -> GAR-OLD-ACCT-NBR

Glcomprel      GLCOMPREL    Not Required

                            FBR-OLD-COMPANY     -> GCR-OLD-COMPANY