Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FBDETAIL


                             FBDETAIL FILE

                             Budget Detail

The Budgeting detail file contains the budget information for each budget
number, fiscal year and account. Thirteen amount fields are maintained on each
detail record.


REFERENCED BY

FB11.1    FB111     FB141     FB160     FB195     FB211
FB220     FB295     FB296     FB95.2    FB95.3    FB95.4
FB95.5    FB95.6    FB95.1    GL146     GL167     GL190
GL191     GL199     GL295     GL40.1    GL40.2    GL40.3
GL40.7    GL40.8    GL44.1    GL45.1    GLOP.1    IFGT.1
FB60.1    GL298     GL90.6    GL94.1    GL94.2    GL94.3
GL94.4    GL94.5    GL94.6    GL94.7    GL95.1    GL95.2
GL95.3    GL95.4    GL95.5    GL95.6    GL95.7    GL95.8
GL95.9    GL96.1    GL96.2    GL96.3    GL96.4    GL96.5
GL97.1    GL97.2    GL97.3    GL97.4    GL97.5    GL97.6
GL97.7    GL97.8    GL97.9    GL98.1    GL98.2    GL98.3
GL98.4    GL98.5    GL99.1    GL99.2    GL99.3    GL99.4
GL99.5    GL99.6    GLSV.1    RW80.1    GLRV.1    AC191
AC40.4    AC41.4    AC42.1    AP125     AP126     AP25.1
AP25.2    AP26.1    AP27.1    AP30.2    BR41.4    BR44.1
CB10.1    CB15.1    CB15.2    CB191     CB20.1    CB30.1
CB500     EE135     EE35.1    EE35.2    EE520     GL122
GL165     GL170     GL65.1    GL70.1    GL70.2    GL70.3
GL70.5    GL70.6    GL75.1    IC222     GL20.2    IFAC.1
PO150     PO25.1    PO25.6    PO25.7    PO536     POIM.1
FB230     FB231     RW298     GL320

UPDATED BY

CA110     CA195     FB100     FB101     FB120     FB121
FB122     FB145     FB165     FB190     FB20.1    FB20.2
FB20.3    FB20.4    FB20.6    FB20.7    FB21.1    FB30.1
FB31.1    FB40.1    FB40.2    FB40.3    FB45.1    GL110
GL120     GL197     GL300     GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FBD-COMPANY            Numeric 4                                 CA110   CA195
Element: Company       The company number you are defining       FB120   FB121
                       budgets for.                              FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL110
                                                                 GL197   GL500
                                                                 GLSV.1  RW298
                                                                 RW80.1

FBD-FISCAL-YEAR        Numeric 4                                 CA110   CA195
Element: Fiscal Year   This is the fiscal year you are           FB120   FB121
                       defining budgets in.                      FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL197
                                                                 GL500   GLSV.1
                                                                 RW298

FBD-BUDGET-NBR         Numeric 3                                 CA110   CA195
Element: Budget        The number that identifies the budget.    FB100   FB101
                                                                 FB120   FB121
                                                                 FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL197
                                                                 GL500   GLSV.1
                                                                 RW298

FBD-ACCT-UNIT          Alpha 15                                  CA110   CA195
Element: Accounting UniThe accounting unit you are defining      FB120   FB121
                       budget values for.                        FB145   FB165
                                                                 FB190   FB20.1
                       This field, along with the account and    FB20.3  FB20.4
                       subaccount, make up the location          FB20.6  FB20.7
                       (account) where amounts and other         FB21.1  FB30.1
                       account information is stored.            FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL197
                                                                 GL500   GLSV.1
                                                                 RW298

FBD-ACCOUNT            Numeric 6                                 CA110   CA195
Element: Account       The account number you are defining       FB120   FB121
                       budget values for.                        FB145   FB165
                                                                 FB190   FB20.1
                       This field, along with the accounting     FB20.3  FB20.4
                       unit and subaccount, make up the          FB20.6  FB20.7
                       location (account) where amounts and      FB21.1  FB30.1
                       other account information are stored.     FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL197
                                                                 GL500   GLSV.1
                                                                 RW298   RW80.1

FBD-SUB-ACCOUNT        Numeric 4                                 CA110   CA195
Element: Subaccount    The subaccount number you are defining    FB120   FB121
                       budget values for.                        FB145   FB165
                                                                 FB190   FB20.1
                       This field along with the accounting      FB20.3  FB20.4
                       unit and account make up the location     FB20.6  FB20.7
                       (account) where amounts and other         FB21.1  FB30.1
                       account information is stored.            FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL197
                                                                 GL500   GLSV.1
                                                                 RW298   RW80.1

FBD-VAR-LEVELS         Alpha 30                                  CA110   CA195
Element: Variable LevelA variable level represents the           FB120   FB121
                       location of an accounting unit in an      FB145   FB165
                       organization's level structure.           FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL120
                                                                 GL197   GL500
                                                                 GLSV.1

FBD-DB-AMOUNT          Signed 18.2 Occurs 13 Times               CA195   FB100
Element: Debit Amount  This is the budget debit amount.          FB101   FB120
                                                                 FB121   FB145
                                                                 FB165   FB190
                                                                 FB20.1  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL197   GL500
                                                                 GLSV.1

FBD-CR-AMOUNT          Signed 18.2 Occurs 13 Times               CA195   FB100
Element: Credit Amount This is the budget credit amount.         FB101   FB120
                                                                 FB121   FB145
                                                                 FB165   FB190
                                                                 FB20.1  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL197   GL500
                                                                 GLSV.1

FBD-DB-UNITS           Signed 15.2 Occurs 13 Times               CA195   FB100
Element: Auto Debits   Select the unit for the activity you      FB101   FB120
                       performed. For example, a unit would be   FB121   FB145
                       the number of computers purchased.        FB165   FB190
                                                                 FB20.1  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL197   GL500
                                                                 GLSV.1

FBD-CR-UNITS           Signed 15.2 Occurs 13 Times               CA195   FB100
Element: Auto Credits  Select the unit for the activity you      FB101   FB120
                       performed. For example, a unit would be   FB121   FB145
                       the number of computers purchased.        FB165   FB190
                                                                 FB20.1  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL197   GL500
                                                                 GLSV.1

FBD-COMPUTE-NAME       Alpha 12                                  CA195   FB100
Element: Compute       The name assigned to an arithmetic        FB120   FB121
                       equation created in Compute Statement     FB165   FB20.1
                       (RW50.1).  A compute statement consists   FB20.3  FB20.4
                       of data dictionary items and operation    FB20.6  FB20.7
                       symbols.                                  FB21.1  FB30.1
                                                                 FB31.1  GL500
                                                                 GLSV.1

FBD-MAINT-DATE         Numeric 8  (yyyymmdd)                     CA195   FB100
Element: Maintenance DaThe last date the budget was              FB120   FB121
                       maintained.                               FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL197
                                                                 GL500   GLSV.1

FBD-MAINT-TIME         Numeric 6  (hhmmss)                       CA195   FB100
Element: Maintenance TiThe last time the budget was              FB120   FB121
                       maintained.                               FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL197
                                                                 GL500   GLSV.1

FBD-CHART-NAME         Alpha 12                                  CA110   CA195
Element: Chart Name    This is the name you assigned to the      FB120   FB145
                       chart of accounts when you defined your   FB165   FB190
                       company structure in the General Ledger   FB20.1  FB20.3
                       system.                                   FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL197   GL500
                                                                 GLSV.1

FBD-SPREAD-CODE        Alpha 3                                   CA195   FB120
Element: Spread Code   A spread code is a budget spending        FB121   FB165
                       activity formula set up in FB10.1         FB20.1  FB20.3
                       (Spread Codes) for each budget period.    FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 GL500   GLSV.1

FBD-DB-BEG-BAL         Signed 18.2                               CA195   FB101
Debit Beginning        This is the debit beginning balance.      FB120   FB121
Balance                                                          FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL197
                                                                 GL500   GLSV.1

FBD-CR-BEG-BAL         Signed 18.2                               CA195   FB101
Credit Beginning       This is the credit beginning balance.     FB120   FB121
Balance                                                          FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL197
                                                                 GL500   GLSV.1

FBD-DB-BEG-BAL-UNT     Signed 18.2                               FB101   FB120
Element: Intl Amt      You can enter the units beginning         FB121   FB145
                       balance. For example, a unit would be     FB165   FB190
                       the number of computers purchased.        FB20.1  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL197   GL500
                                                                 GLSV.1

FBD-CR-BEG-BAL-UNT     Signed 18.2                               FB101   FB120
Element: Intl Amt      You can enter the units beginning         FB121   FB145
                       balance in this field. For example, a     FB165   FB190
                       unit would be the number of computers     FB20.1  FB20.3
                       purchased.                                FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL197   GL500
                                                                 GLSV.1

FBD-BEG-BAL-FACTOR     Alpha 15                                  CA195   FB120
Element: Factor        You can type or select the global         FB121   FB165
                       factor that is used to help calculate     FB20.1  FB20.3
                       the budget amount.                        FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                       You define global factors in FB00.1
                       (Global Factors).



FBD-BEG-BAL-RATE       Signed 14.7                               CA195   FB101
Element: Currency Rate You can type or select the rate that      FB120   FB121
                       affects the factor. For example, you      FB165   FB20.1
                       could type the inflation rate or an       FB20.3  FB20.4
                       employees hourly contract salary.         FB20.6  FB20.7
                                                                 FB21.1

FBD-FACTOR             Alpha 15 Occurs 13 Times                  CA195   FB100
Element: Factor        The global factor defined in FB00.1       FB120   FB121
                       (Global Factors).                         FB165   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  GL500

FBD-FACTOR-RATE        Signed 14.7 Occurs 13 Times               CA195   FB101
Element: Currency Rate The rate that affects the factor. For     FB120   FB121
                       example, you  could type the inflation    FB165   FB20.1
                       rate.                                     FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                       If you select units and amounts, the      FB21.1  GL500
                       rate is calculated.



FBD-PARENT-VAR-LEV     Alpha 30                                  CA110   CA195
Element: Parent Var LevThe variable level address of the parent  FB120   FB121
                       accounting unit.                          FB145   FB165
                                                                 FB190   FB20.1
                                                                 FB20.3  FB20.4
                                                                 FB20.6  FB20.7
                                                                 FB21.1  FB30.1
                                                                 FB31.1  FB40.1
                                                                 FB40.2  FB40.3
                                                                 FB45.1  GL120
                                                                 GL197   GL500

FBD-CYBBUD             Derived
Current Year           This is the current year beginning
Beginning Budget       budget.


FBD-CPBUD-DR           Derived
Current Period         This is the current period debit
Debit Amount           amount.


FBD-CPBUD-CR           Derived
Current Period         This is the current period credit
Credit Amount          amount.


FBD-CPBUD              Derived
Current Net Debit      This is the current period net debit
and Credit             and credit amount.


FBD-CUR-PD-SUM-B-D     Derived
Current YTD Debit      This is the current year-to-date debit
Amount                 amount.


FBD-CUR-PD-SUM-B-C     Derived
Current YTD Credit     This is the current year-to-date credit
Amount                 amount.


FBD-CYDBUD             Derived
Element: Current YTD BuThis is the current year-to-date
                       budget.


FBD-CYPBUD1-DR         Derived
Period 1 Debit         This is the period 1 debit budget.
Budget

FBD-CYPBUD1-CR         Derived
Period 1 Credit        This is the period 1 credit budget.
Budget

FBD-CYPYTD1            Derived
Element: Period 1 BudgeCurrent year period year to date
                       period 1.

FBD-CYPBUD2-DR         Derived
Period 2 Debit         This is the period 2 debit budget.
Budget

FBD-CYPBUD2-CR         Derived
Period 2 Credit        This is the period 2 credit budget.
Budget

FBD-CYPYTD2            Derived
Element: Period 2 BudgeCurrent year period year to date
                       period 2.

FBD-CYPBUD3-DR         Derived
Period 3 Debit         This is the period 3 debit budget.
Budget

FBD-CYPBUD3-CR         Derived
Period 3 Credit        This is the period 3 credit budget.
Budget

FBD-CYPYTD3            Derived
Element: Period 3 BudgeCurrent year period year to date
                       period 3.

FBD-CYPBUD4-DR         Derived
Period 4 Debit         This is the period 4 debit budget.
Budget

FBD-CYPBUD4-CR         Derived
Period 4 Credit        This is the period 4 credit budget.
Budget

FBD-CYPYTD4            Derived
Element: Period 4 BudgeCurrent year period year to date
                       period 4.

FBD-CYPBUD5-DR         Derived
Period 5 Debit         This is the period 5 debit budget.
Budget

FBD-CYPBUD5-CR         Derived
Period 5 Credit        This is the period 5 credit budget.
Budget

FBD-CYPYTD5            Derived
Element: Period 5 BudgeCurrent year period year to date
                       period 5.

FBD-CYPBUD6-DR         Derived
Period 6 Debit         This is the period 6 debit budget.
Budget

FBD-CYPBUD6-CR         Derived
Period 6 Credit        This is the period 6 credit budget.
Budget

FBD-CYPYTD6            Derived
Element: Period 6 BudgeCurrent year period year to date
                       period 6.

FBD-CYPBUD7-DR         Derived
Period 7 Debit         This is the period 7 debit budget.
Budget

FBD-CYPBUD7-CR         Derived
Period 7 Credit        This is the period 7 credit budget.
Budget

FBD-CYPYTD7            Derived
Element: Period 7 BudgeCurrent year period year to date
                       period 7.

FBD-CYPBUD8-DR         Derived
Period 8 Debit         This is the period 8 debit budget.
Budget

FBD-CYPBUD8-CR         Derived
Period 8 Credit        This is the period 8 credit budget.
Budget

FBD-CYPYTD8            Derived
Element: Period 8 BudgeCurrent year period year to date
                       period 8.

FBD-CYPBUD9-DR         Derived
Period 9 Debit         This is the period 9 debit budget.
Budget

FBD-CYPBUD9-CR         Derived
Period 9 Credit        This is the period 9 credit budget.
Budget

FBD-CYPYTD9            Derived
Element: Period 9 BudgeCurrent year period year to date
                       period 9.

FBD-CYPBUD10-DR        Derived
Period 10 Debit        This is the period 10 debit budget.
Budget

FBD-CYPBUD10-CR        Derived
Period 10 Credit       This is the period 10 credit budget.
Budget

FBD-CYPYTD10           Derived
Element: Period 10 BudgCurrent year period year to date
                       period 10.

FBD-CYPBUD11-DR        Derived
Period 11 Debit        This is the period 11 debit budget.
Budget

FBD-CYPBUD11-CR        Derived
Period 11 Credit       This is the period 11 credit budget.
Budget

FBD-CYPYTD11           Derived
Element: Period 11 BudgCurrent year period year to date
                       period 11.

FBD-CYPBUD12-DR        Derived
Period 12 Debit        This is the period 12 debit budget.
Budget

FBD-CYPBUD12-CR        Derived
Period 12 Credit       This is the period 12 credit budget.
Budget

FBD-CYPYTD12           Derived
Element: Period 12 BudgCurrent year period year to date
                       period 12.

FBD-CYPBUD13-DR        Derived
Period 13 Debit        This is the period 13 debit budget.
Budget

FBD-CYPBUD13-CR        Derived
Period 13 Credit       This is the period 13 credit budget.
Budget

FBD-CYPYTD13           Derived
Element: Period 13 BudgCurrent year period year to date
                       period 13.

FBD-BLANK              Derived
Element: Blank         This derived field is always blank. It
                       is used in drill around to allow column
                       headings.


FBD-UNT-BEG-BAL        Derived
Element: Unt Beg Bal   This is the unit beginning balance.

FBD-UNTBUD1-DR         Derived
Element: Untbud1 Dr    This is the period 1 debit budget unit.


FBD-UNTBUD1-CR         Derived
Element: Untbud1 Cr    This is the period 1 credit budget
                       unit.


FBD-UNTBUD1            Derived
Element: Untbud1       Units current year period year to date
                       period 1.

FBD-UNTBUD2-DR         Derived
Element: Untbud2 Dr    This is the period 2 debit budget unit.


FBD-UNTBUD2-CR         Derived
Element: Untbud2 Cr    This is the period 2 credit budget
                       unit.


FBD-UNTBUD2            Derived
Element: Untbud2       Units current year period year to date
                       period 2.

FBD-UNTBUD3-DR         Derived
Element: Untbud3 Dr    This is the period 3 debit budget unit.


FBD-UNTBUD3-CR         Derived
Element: Untbud3 Cr    This is the period 3 credit budget unit


FBD-UNTBUD3            Derived
Element: Untbud3       Units current year period year to date
                       period 3.

FBD-UNTBUD4-DR         Derived
Element: Untbud4 Dr    This is the period 4 debit budget unit.


FBD-UNTBUD4-CR         Derived
Element: Untbud4 Cr    This is the period 4 credit budget
                       unit.


FBD-UNTBUD4            Derived
Element: Untbud4       Units current year period year to date
                       period 4.

FBD-UNTBUD5-DR         Derived
Element: Untbud5 Dr    This is the period 5 debit budget unit.


FBD-UNTBUD5-CR         Derived
Element: Untbud5 Cr    This is the period 5 credit budget
                       unit.


FBD-UNTBUD5            Derived
Element: Untbud5       Units current year period year to date
                       period 5.

FBD-UNTBUD6-DR         Derived
Element: Untbud6 Dr    This is the period 6 debit budget unit.


FBD-UNTBUD6-CR         Derived
Element: Untbud6 Cr    This is the period 6 credit budget
                       unit.


FBD-UNTBUD6            Derived
Element: Untbud6       Units current year period year to date
                       period 6.

FBD-UNTBUD7-DR         Derived
Element: Untbud7 Dr    This is the period 7 debit budget unit.


FBD-UNTBUD7-CR         Derived
Element: Untbud7 Cr    This is the period 7 credit budget
                       unit.


FBD-UNTBUD7            Derived
Element: Untbud7       Units current year period year to date
                       period 7.

FBD-UNTBUD8-DR         Derived
Element: Untbud8 Dr    This is the period 8 debit budget unit.


FBD-UNTBUD8-CR         Derived
Element: Untbud8 Cr    This is the period 8 credit budget
                       unit.


FBD-UNTBUD8            Derived
Element: Untbud8       Units current year period year to date
                       period 8.

FBD-UNTBUD9-DR         Derived
Element: Untbud9 Dr    This is the period 9 debit budget unit.


FBD-UNTBUD9-CR         Derived
Element: Untbud9 Cr    This is the period 9 credit budget
                       unit.


FBD-UNTBUD9            Derived
Element: Untbud9       Units current year period year to date
                       period 9.

FBD-UNTBUD10-DR        Derived
Element: Untbud10 Dr   This is the period 10 debut budget
                       unit.


FBD-UNTBUD10-CR        Derived
Element: Untbud10 Cr   This is the period 10 credit budget
                       unit.


FBD-UNTBUD10           Derived
Element: Untbud10      Units current year period year to date
                       period 10.

FBD-UNTBUD11-DR        Derived
Element: Untbud11 Dr   This is the period 11 debit budget
                       unit.


FBD-UNTBUD11-CR        Derived
Element: Untbud11 Cr   This is the period 11 credit budget
                       unit.


FBD-UNTBUD11           Derived
Element: Untbud11      Units current year period year to date
                       period 11.

FBD-UNTBUD12-DR        Derived
Element: Untbud12 Dr   This is the period 12 debit budget
                       unit.


FBD-UNTBUD12-CR        Derived
Element: Untbud12 Cr   This is the period 12 credit budget
                       unit.


FBD-UNTBUD12           Derived
Element: Untbud12      Units current year period year to date
                       period 12.

FBD-UNTBUD13-DR        Derived
Element: Untbud13 Dr   This is the period 13 debit budget
                       unit.


FBD-UNTBUD13-CR        Derived
Element: Untbud13 Cr   This is the period 13 credit budget
                       unit.


FBD-UNTBUD13           Derived
Element: Untbud13      Units current year period year to date
                       period 13.

                         FBDETAIL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FBDSET1   COMPANY                                                CA110   CA195
          FISCAL-YEAR                                            FB100   FB101
          BUDGET-NBR                                             FB11.1  FB111
          ACCT-UNIT                                              FB120   FB121
          ACCOUNT                                                FB122   FB141
          SUB-ACCOUNT                                            FB145   FB160
                                                                 FB165   FB190
                                                                 FB195   FB20.1
                                                                 FB20.2  FB20.3
                                                                 FB20.4  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB220
                                                                 FB295   FB296
                                                                 FB30.1  FB31.1
                                                                 FB40.1  FB40.2
                                                                 ...

FBDSET2   FISCAL-YEAR   KeyChange                                CA195   FB100
          BUDGET-NBR                                             FB101   FB11.1
          COMPANY                                                FB111   FB120
          VAR-LEVELS                                             FB121   FB160
          ACCOUNT                                                FB195   FB211
          SUB-ACCOUNT                                            FB296   FB60.1
          ACCT-UNIT                                              FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL298   GL90.6
                                                                 GL94.1  GL94.2
                                                                 GL94.3  GL94.4
                                                                 GL94.5  GL94.6
                                                                 GL94.7  GL95.1
                                                                 GL95.2  GL95.3
                                                                 ...

FBDSET3   COMPANY                                                AC191   AC40.4
          ACCT-UNIT                                              AC41.4  AC42.1
          ACCOUNT                                                AP125   AP126
          SUB-ACCOUNT                                            AP25.1  AP25.2
          BUDGET-NBR                                             AP26.1  AP27.1
          FISCAL-YEAR                                            AP30.2  BR41.4
                                                                 BR44.1  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB191   CB20.1
                                                                 CB30.1  CB500
                                                                 EE135   EE35.1
                                                                 EE35.2  EE520
                                                                 CA110   FB145
                                                                 FB190   FB40.1
                                                                 FB40.2  FB40.3
                                                                 ...

FBDSET4   COMPANY       Subset                                   FB100   FB230
          FISCAL-YEAR   Where COMPUTE-NAME != Spaces             FB231   RW298
          BUDGET-NBR
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT

FBDSET5   FISCAL-YEAR   KeyChange                                FB100   FB101
          BUDGET-NBR                                             FB231   FB295
          COMPANY                                                GL320   GLSV.1
          ACCOUNT                                                GLRV.1
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT

FBDSET6   FISCAL-YEAR   KeyChange                                GLSV.1  GLRV.1
          BUDGET-NBR
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          COMPANY
          ACCT-UNIT

FBDSET7   FISCAL-YEAR   KeyChange                                GLSV.1  GLRV.1
          BUDGET-NBR
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          COMPANY
          ACCT-UNIT

FBDSET8   COMPANY                                                FB31.1  FB95.2
          FISCAL-YEAR                                            FB95.3
          BUDGET-NBR
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT

FBDSET9   PARENT-VAR-LEV
          FISCAL-YEAR
          BUDGET-NBR
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT

                         FBDETAIL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account        GLMASTER     Required

                            FBD-COMPANY           -> GLM-COMPANY  (GLMSET2)
                            FBD-ACCT-UNIT         -> GLM-ACCT-UNIT
                            FBD-ACCOUNT           -> GLM-ACCOUNT
                            FBD-SUB-ACCOUNT       -> GLM-SUB-ACCOUNT

Acct Unit      GLNAMES      Required

                            FBD-COMPANY           -> GLN-COMPANY
                            FBD-ACCT-UNIT         -> GLN-ACCT-UNIT

Budget         FBHEADER     Required

                            FBD-COMPANY           -> FBH-COMPANY
                            FBD-FISCAL-YEAR       -> FBH-FISCAL-YEAR
                            FBD-BUDGET-NBR        -> FBH-BUDGET-NBR

Chart Detail   GLCHARTDTL   Required

                            FBD-CHART-NAME        -> GDT-CHART-NAME
                            FBD-ACCOUNT           -> GDT-ACCOUNT
                            FBD-SUB-ACCOUNT       -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            FBD-COMPANY           -> GLS-COMPANY

Compute        CMPUTE       Not Required

                            FBD-COMPUTE-NAME      -> CMP-COMPUTE-NAME

Fbspread       FBSPREAD     Not Required

                            FBD-COMPANY           -> FBS-COMPANY
                            FBD-FISCAL-YEAR       -> FBS-FISCAL-YEAR
                            FBD-SPREAD-CODE       -> FBS-SPREAD-CODE

                         FBDETAIL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bud Unt Parent GLCONSOL

                            FBD-PARENT-VAR-LEV    -> GCN-VAR-LEVELS
                            "N"                   -> GCN-TRANS-TYPE
                            FBD-COMPANY           -> GCN-COMPANY
                            FBD-ACCOUNT           -> GCN-ACCOUNT
                            FBD-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                            FBD-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            FBD-BUDGET-NBR        -> GCN-BUDGET-NBR
                                                     GCN-LEVEL-DEPTH
                                                     GCN-CURRENCY-CODE

Budget Parent  GLCONSOL

                            FBD-PARENT-VAR-LEV    -> GCN-VAR-LEVELS
                            "B"                   -> GCN-TRANS-TYPE
                            FBD-COMPANY           -> GCN-COMPANY
                            FBD-ACCOUNT           -> GCN-ACCOUNT
                            FBD-SUB-ACCOUNT       -> GCN-SUB-ACCOUNT
                            FBD-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            FBD-BUDGET-NBR        -> GCN-BUDGET-NBR
                                                     GCN-LEVEL-DEPTH
                                                     GCN-CURRENCY-CODE

Fbtrans        FBTRANS

                            FBD-COMPANY           -> FLT-TO-COMPANY
                            FBD-FISCAL-YEAR       -> FLT-FISCAL-YEAR
                            FBD-BUDGET-NBR        -> FLT-BUDGET-NBR
                            FBD-ACCT-UNIT         -> FLT-ACCT-UNIT
                            FBD-ACCOUNT           -> FLT-ACCOUNT
                            FBD-SUB-ACCOUNT       -> FLT-SUB-ACCOUNT
                                                     FLT-OBJ-ID

Glcommitx      GLCOMMITX

                            FBD-COMPANY           -> GOX-COMPANY
                            FBD-ACCT-UNIT         -> GOX-ACCT-UNIT
                            FBD-ACCOUNT           -> GOX-ACCOUNT
                            FBD-SUB-ACCOUNT       -> GOX-SUB-ACCOUNT
                            FBD-FISCAL-YEAR       -> GOX-FISCAL-YEAR
                                                     GOX-PERIOD
                                                     GOX-SYSTEM
                                                     GOX-CURRENCY-CODE
                                                     GOX-GLT-OBJ-ID

Gltrans        GLTRANS

                            FBD-COMPANY           -> GLT-TO-COMPANY
                            FBD-ACCOUNT           -> GLT-ACCOUNT
                            FBD-SUB-ACCOUNT       -> GLT-SUB-ACCOUNT
                            FBD-ACCT-UNIT         -> GLT-ACCT-UNIT
                            FBD-FISCAL-YEAR       -> GLT-FISCAL-YEAR
                                                     GLT-ACCT-PERIOD
                                                     GLT-SYSTEM
                                                     GLT-CONTROL-GROUP
                                                     GLT-JE-TYPE
                                                     GLT-JE-SEQUENCE
                                                     GLT-LINE-NBR
                                                     GLT-COMPANY