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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#FDH-COMPANY PK
COMPANY		Numeric 4The company number you are defining budgets for.FB122, GL110, GL500
#FDH-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4This is the fiscal year budgets are defined in.FB122, GL500
#FDH-BUDGET-NBR PK
BUDGET_NBR		Numeric 3This identifies the budget.FB122, GL500
#FDH-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The 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 PK
ACCOUNT		Numeric 6This 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 PK
SUB_ACCOUNT		Numeric 4This 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 PK
VERSION		Numeric 2This field displays the budget version number.FB122, GL500
#FDH-VAR-LEVELS SET3
VAR_LEVELS		Alpha 30A level that represents the location of an accounting unit in an organization's level structure.FB122, GL120, GL500
#FDH-DB-AMOUNT
DB_AMOUNT		Signed 18.2 Occurs 13 Times ×13—FB122, GL500
#FDH-CR-AMOUNT
CR_AMOUNT		Signed 18.2 Occurs 13 Times ×13—FB122, GL500
#FDH-DB-UNITS
DB_UNITS		Signed 15.2 Occurs 13 Times ×13The total positive detail auto reversing amounts.FB122, GL500
#FDH-CR-UNITS
CR_UNITS		Signed 15.2 Occurs 13 Times ×13The total negative detail auto reversing amounts.FB122, GL500
#FDH-COMPUTE-NAME
COMPUTE_NAME		Alpha 12The 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-NAME
CHART_NAME		Alpha 12This 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-CODE
SPREAD_CODE		Alpha 3A 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-BAL
DB_BEG_BAL		Signed 18.2—FB122, GL500
#FDH-CR-BEG-BAL
CR_BEG_BAL		Signed 18.2—FB122, GL500
#FDH-DB-BEG-BAL-UNT
DB_BEG_BAL_UNT		Signed 18.2—FB122, GL500
#FDH-CR-BEG-BAL-UNT
CR_BEG_BAL_UNT		Signed 18.2—FB122, GL500
#FDH-BEG-BAL-FACTOR
BEG_BAL_FACTOR		Alpha 15The element that affects the budget change.FB122
#FDH-BEG-BAL-RATE
BEG_BAL_RATE		Signed 14.7The currency rate.FB122
#FDH-FACTOR
FACTOR		Alpha 15 Occurs 13 Times ×13The element that affects the budget change.FB122, GL500
#FDH-FACTOR-RATE
FACTOR_RATE		Signed 14.7 Occurs 13 Times ×13The currency rate.FB122, GL500

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FDHSET1
  1. COMPANY ↓
  2. FISCAL-YEAR
  3. BUDGET-NBR
  4. ACCT-UNIT
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. VERSION
PrimaryFB122, FB215, FB220, FB95.2, FB95.3, FB95.4, FB95.5, FB95.6 +4 more
FDHSET2
  1. COMPANY
  2. FISCAL-YEAR
  3. BUDGET-NBR
  4. VERSION
  5. ACCT-UNIT
  6. ACCOUNT
  7. SUB-ACCOUNT
FB295, FB296, GL120, GL500
FDHSET3
  1. FISCAL-YEAR
  2. BUDGET-NBR
  3. COMPANY
  4. VERSION
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. VAR-LEVELS
  8. ACCT-UNIT
KeyChangeFB295

Programs

Updated by (5)

Referenced by (9)