Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FBDTLHIST


                             FBDTLHIST FILE

                         Budget Detail History

The Budgeting Detail History file stores detail budget records for a version
number.


REFERENCED BY

FB220     FB95.2    FB95.3    FB95.4    FB95.5    FB95.6
FB295     FB296

UPDATED BY

FB122     GL110     GL120     GL300     GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FDH-COMPANY            Numeric 4                                 FB122   GL110
Element: Company       The company number you are defining       GL500
                       budgets for.


FDH-FISCAL-YEAR        Numeric 4                                 FB122   GL500
Element: Fiscal Year   This is the fiscal year budgets are
                       defined in.


FDH-BUDGET-NBR         Numeric 3                                 FB122   GL500
Element: Budget        This identifies the budget.

FDH-ACCT-UNIT          Alpha 15                                  FB122   GL500
Element: Accounting UniThe 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.


FDH-ACCOUNT            Numeric 6                                 FB122   GL500
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

FDH-SUB-ACCOUNT        Numeric 4                                 FB122   GL500
Element: Subaccount    This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

FDH-VERSION            Numeric 2                                 FB122   GL500
Element: Version       This field displays the budget version
                       number.


FDH-VAR-LEVELS         Alpha 30                                  FB122   GL120
Element: Variable LevelA level that represents the location of   GL500
                       an accounting unit in an organization's
                       level structure.


FDH-DB-AMOUNT          Signed 18.2 Occurs 13 Times               FB122   GL500
Element: Intl Amt      The budget debit amount.

FDH-CR-AMOUNT          Signed 18.2 Occurs 13 Times               FB122   GL500
Element: Intl Amt      The budget credit amount.

FDH-DB-UNITS           Signed 15.2 Occurs 13 Times               FB122   GL500
Element: Auto Debits   Select the unit for the activity you
                       performed. For example, a unit would be
                       the number of computers purchased.


FDH-CR-UNITS           Signed 15.2 Occurs 13 Times               FB122   GL500
Element: Auto Credits  Select the unit for the activity you
                       performed. For example, a unit would be
                       the number of computers purchased.


FDH-COMPUTE-NAME       Alpha 12                                  FB122   GL500
Compute Statement      The name assigned to an arithmetic
Name                   equation created in Compute Statement
                       (RW50.1).  A compute statement consists
                       of data dictionary items and operation
                       symbols.

FDH-CHART-NAME         Alpha 12                                  FB122   GL500
Element: Chart Name    This is the name you assigned to the
                       chart of accounts when you defined your
                       company structure in the General Ledger
                       system.


FDH-SPREAD-CODE        Alpha 3                                   FB122   GL500
Element: Spread Code   A spread code is a formula for
                       budgeting spending activity that can be
                       set up in AC23.1 (Spread Codes) for each
                       account category. You can use a spread
                       code to schedule spending over the life
                       of the activity or activity group.
                       Spread codes can be used to represent
                       the characteristic spending pattern of
                       each account category.

FDH-DB-BEG-BAL         Signed 18.2                               FB122   GL500
Element: Intl Amt      The debit beginning balance.

FDH-CR-BEG-BAL         Signed 18.2                               FB122   GL500
Element: Intl Amt      The credit beginning balance.

FDH-DB-BEG-BAL-UNT     Signed 18.2                               FB122   GL500
Element: Intl Amt      You can enter the units beginning
                       balance. For example, a unit would be
                       the number of computers purchased.


FDH-CR-BEG-BAL-UNT     Signed 18.2                               FB122   GL500
Element: Intl Amt      You can enter the units beginning
                       balance in this field. For example, a
                       unit would be the number of computers
                       purchased.


FDH-BEG-BAL-FACTOR     Alpha 15                                  FB122
Element: Factor        You can type or select the global
                       factor that is used to help calculate
                       the budget amount.

                       You define global factors in FB00.1
                       (Global Factors).



FDH-BEG-BAL-RATE       Signed 14.7                               FB122
Element: Currency Rate You can type or select the rate that
                       affects the factor. For example, you
                       could type the inflation rate or an
                       employees hourly contract salary.


FDH-FACTOR             Alpha 15 Occurs 13 Times                  FB122   GL500
Element: Factor        The element that affects the budget
                       change.

FDH-FACTOR-RATE        Signed 14.7 Occurs 13 Times               FB122   GL500
Element: Currency Rate You can type or select the rate that
                       affects the factor. For example, you
                       could type the inflation rate.

                       If you select units and amounts, the
                       rate is calculated.

                         FBDTLHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FDHSET1   COMPANY*                                               FB122   FB220
          FISCAL-YEAR                                            FB95.2  FB95.3
          BUDGET-NBR                                             FB95.4  FB95.5
          ACCT-UNIT                                              FB95.6  GL110
          ACCOUNT                                                GL120   GL300
          SUB-ACCOUNT                                            GL500
          VERSION

FDHSET2   COMPANY                                                FB295   FB296
          FISCAL-YEAR                                            GL500
          BUDGET-NBR
          VERSION
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT

FDHSET3   FISCAL-YEAR   KeyChange                                FB295
          BUDGET-NBR
          COMPANY
          VERSION
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT