Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
Company              The company number you are defining         GL500
                     budgets for.


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


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

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


FDH-ACCOUNT          Numeric 6                                   FB122   GL500
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
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
Version              This field displays the budget version
                     number.


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


FDH-DB-AMOUNT        Currency 15.2 Occurs 13 Times               FB122   GL500
Debit Amount         The budget debit amount.

FDH-CR-AMOUNT        Currency 15.2 Occurs 13 Times               FB122   GL500
Credit Amount        The budget credit amount.

FDH-DB-UNITS         Signed 15.2 Occurs 13 Times                 FB122   GL500
Debit Units          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
Credit Unit          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
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
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       Currency 15.2                               FB122   GL500
Debit Beginning      The debit beginning balance.
Balance

FDH-CR-BEG-BAL       Currency 15.2                               FB122   GL500
Credit Beginning     The credit beginning balance.
Balance

FDH-DB-BEG-BAL-UNT   Signed 15.2                                 FB122   GL500
Unit Debit           You can enter the units beginning
Beginning Balance    balance. For example, a unit would be
                     the number of computers purchased.


FDH-CR-BEG-BAL-UNT   Signed 15.2                                 FB122   GL500
Unit Credit          You can enter the units beginning
Beginning Balance    balance in this field. For example, a
                     unit would be the number of computers
                     purchased.


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

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



FDH-BEG-BAL-RATE     Signed 12.6                                 FB122
Rate Beginning       You can type or select the rate that
Balance              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
Factor               The element that affects the budget
                     change.

FDH-FACTOR-RATE      Signed 12.6 Occurs 13 Times                 FB122   GL500
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                                            FB295
          BUDGET-NBR
          COMPANY
          VERSION
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT