FBDTLHIST – Budget Detail History
- System
- General Ledger (GL)
- Prefix
FDH- Primary key
COMPANY,FISCAL-YEAR,BUDGET-NBR,ACCT-UNIT,ACCOUNT,SUB-ACCOUNT,VERSION- Fields
- 23
- Updated by
- 5 programs
- Referenced by
- 9 programs
FBDTLHIST is the Budget Detail History table in Lawson General Ledger (prefix FDH). It is indexed by COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, VERSION (FDHSET1); alternate indexes: FDHSET2 and FDHSET3. It is updated by FB122, GL110, GL120, GL300 and GL500 and referenced by FB215, FB220, FB295, FB296, FB95.2, FB95.3, FB95.4, FB95.5 and 1 more. The table has 23 fields, 3 indexes and 0 documented relations.
About FBDTLHIST
The Budgeting Detail History file stores detail budget records for a version number.
Fields (23)
Column = COBOL field name without the FDH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
FDH-COMPANY PKCOMPANY | Numeric 4 | The company number you are defining budgets for. | FB122, GL110, GL500 |
FDH-FISCAL-YEAR PKFISCAL_YEAR | Numeric 4 | This is the fiscal year budgets are defined in. | FB122, GL500 |
FDH-BUDGET-NBR PKBUDGET_NBR | Numeric 3 | This identifies the budget. | FB122, GL500 |
FDH-ACCT-UNIT PKACCT_UNIT | Alpha 15 | 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. | FB122, GL500 |
FDH-ACCOUNT PKACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | FB122, GL500 |
FDH-SUB-ACCOUNT PKSUB_ACCOUNT | Numeric 4 | This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. | FB122, GL500 |
FDH-VERSION PKVERSION | Numeric 2 | This field displays the budget version number. | FB122, GL500 |
FDH-VAR-LEVELSVAR_LEVELS | Alpha 30 | A level that represents the location of an accounting unit in an organization's level structure. | FB122, GL120, GL500 |
FDH-DB-AMOUNTDB_AMOUNT | Signed 18.2 Occurs 13 Times ×13 | — | FB122, GL500 |
FDH-CR-AMOUNTCR_AMOUNT | Signed 18.2 Occurs 13 Times ×13 | — | FB122, GL500 |
FDH-DB-UNITSDB_UNITS | Signed 15.2 Occurs 13 Times ×13 | The total positive detail auto reversing amounts. | FB122, GL500 |
FDH-CR-UNITSCR_UNITS | Signed 15.2 Occurs 13 Times ×13 | The total negative detail auto reversing amounts. | FB122, GL500 |
FDH-COMPUTE-NAMECOMPUTE_NAME | Alpha 12 | The name assigned to an arithmetic equation created in Compute Statement (RW50.1). A compute statement consists of data dictionary items and operation symbols. | FB122, GL500 |
FDH-CHART-NAMECHART_NAME | Alpha 12 | This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system. | FB122, GL500 |
FDH-SPREAD-CODESPREAD_CODE | Alpha 3 | 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. | FB122, GL500 |
FDH-DB-BEG-BALDB_BEG_BAL | Signed 18.2 | — | FB122, GL500 |
FDH-CR-BEG-BALCR_BEG_BAL | Signed 18.2 | — | FB122, GL500 |
FDH-DB-BEG-BAL-UNTDB_BEG_BAL_UNT | Signed 18.2 | — | FB122, GL500 |
FDH-CR-BEG-BAL-UNTCR_BEG_BAL_UNT | Signed 18.2 | — | FB122, GL500 |
FDH-BEG-BAL-FACTORBEG_BAL_FACTOR | Alpha 15 | The element that affects the budget change. | FB122 |
FDH-BEG-BAL-RATEBEG_BAL_RATE | Signed 14.7 | The currency rate. | FB122 |
FDH-FACTORFACTOR | Alpha 15 Occurs 13 Times ×13 | The element that affects the budget change. | FB122, GL500 |
FDH-FACTOR-RATEFACTOR_RATE | Signed 14.7 Occurs 13 Times ×13 | The currency rate. | FB122, GL500 |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
FDHSET1 | COMPANY*, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, VERSION | Primary | FB122, FB215, FB220, FB95.2, FB95.3, FB95.4, FB95.5, FB95.6 +4 more | |
FDHSET2 | COMPANY, FISCAL-YEAR, BUDGET-NBR, VERSION, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | FB295, FB296, GL120, GL500 | ||
FDHSET3 | FISCAL-YEAR, BUDGET-NBR, COMPANY, VERSION, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNIT | KeyChange | FB295 |
Programs
Updated by (5)
- FB122 Budget Version
- GL110 Company Copy Delete
- GL120 Level Reorganization
- GL300 General Ledger History Delete
- GL500 Fiscal Year Change