ACBUDHDR – Activity Budget Header

System
Activity Management (AC)
Prefix
BDH
Primary key
ACTIVITY-GRP, ACTIVITY, BUDGET-NBR
Fields
27
Updated by
23 programs
Referenced by
329 programs

ACBUDHDR is the Activity Budget Header table in Lawson Activity Management (prefix BDH). It is indexed by ACTIVITY-GRP, ACTIVITY, BUDGET-NBR (BDHSET1); alternate indexes: BDHSET3. It is related 1:1 to ACACTGRP, ACACTIVITY and ACBUDHDBOD and 1:M to ACBUDDTL, ACCHGORDER and ACCUAMT. It is updated by AC120, AC121, AC123, AC127, AC128, AC20.1, AC20.2, AC20.3 and 15 more and referenced by AC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 and 321 more. The table has 27 fields, 2 indexes and 12 documented relations.

About ACBUDHDR

This file contains activity budget header information from the AC20 (Activity Budget) forms. It includes activity group, activity, budget number, type, total, and description; lock, calculation, and maintenance information; and setup definitions, such as begin and end dates, variable levels, currency code, rate value, units flag, rounding type, and number of decimal positions in the budget currency.

Fields (27)

Column = COBOL field name without the BDH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BDH-ACTIVITY-GRP PK
ACTIVITY_GRP
Alpha 15Required key. This is the activity group for the budget header information.AC120, AC123, AC127, AC20.6, AC20.7
BDH-ACTIVITY PK
ACTIVITY
Alpha 15Required key. This is the activity for the budget header information.AC123, AC127, AC20.6, AC20.7
BDH-BUDGET-NBR PK
BUDGET_NBR
Numeric 3Required key. This is the budget number uniquely defined in budget setup.AC123, AC127, AC20.6, AC20.7
BDH-BEGIN-DATE
BEGIN_DATE
Numeric 8 (yyyymmdd)The beginning date of a date range for the budget.AC123, AC127, AC20.6, AC20.7
BDH-END-DATE
END_DATE
Numeric 8 (yyyymmdd)The end date of a date range for the budget.AC123, AC127, AC20.6, AC20.7
BDH-TOTAL-BUDGET
TOTAL_BUDGET
Signed 18.2This is the total budget amount.AC123, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5, AC20.6, AC20.7 +1 more
BDH-TOT-UNITS-BUD
TOT_UNITS_BUD
Signed 15.2This is the total number of units for the budget.AC20.1, AC20.2, AC20.3, AC20.4, AC20.5, AC20.6, AC20.7, AC21.5
BDH-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This is the currency code for the budget.AC123, AC127, AC20.6, AC20.7
BDH-RATE-VALUE
RATE_VALUE
Signed 14.7This is the budget exchange rate.AC123, AC127, AC20.7
BDH-MAINT-DATE
MAINT_DATE
Numeric 8 (yyyymmdd)This is the date the budget was last changed.AC123, AC127, AC20.6, AC20.7
BDH-MAINT-TIME
MAINT_TIME
Numeric 6 (hhmmss)This is the time the budget was last changed.AC123, AC127, AC20.6, AC20.7
BDH-CALC-DATE
CALC_DATE
Numeric 8 (yyyymmdd)This is the date budget amounts were last calculated.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
BDH-CALC-TIME
CALC_TIME
Numeric 6 (hhmmss)This is the time budget amounts were last calculated.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
BDH-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This is the budget description.AC00.1, AC123, AC127, AC20.6, AC20.7
BDH-ROUND-TYPE
ROUND_TYPE
Alpha 1This field indicates the type of rounding for the budget amount. The default is 2 (2 decimals, or no rounding).
  • 1 1 Decimal
  • 2 2 Decimals
  • W Whole
  • H Hundreds
  • T Thousands
AC123, AC127, AC20.6, AC20.7
BDH-UNT-ROUND-TYPE
UNT_ROUND_TYPE
Alpha 1This field indicates the type of rounding for the units budget. The default is 2 (2 decimals, or no rounding).
  • 1 1 Decimal
  • 2 2 Decimals
  • T Thousands
  • H Hundreds
  • W Whole
AC123, AC127, AC20.6, AC20.7
BDH-LOCK
LOCK
Alpha 1This flag indicates whether the budget is locked.
  • N No
  • Y Yes
AC123, AC127, AC128, AC20.6, AC20.7, AC20.8
BDH-NUM-DECIMALS
NUM_DECIMALS
Numeric 1This is the number of decimal positions to calculate for the budget amount.AC123, AC127, AC20.6, AC20.7
BDH-UNT-NUM-DEC
UNT_NUM_DEC
Numeric 1This is the number of decimal positions to calculate for the units budget.AC123, AC127, AC20.6, AC20.7
BDH-FACTOR
FACTOR
Alpha 15The element that affects the budget change.
BDH-FACTOR-RATE
FACTOR_RATE
Signed 14.7You 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.
BDH-LIFE-ONLY
LIFE_ONLY
Alpha 1This field indicates whether the budget is life-only.
  • Y Yes
  • N No
AC123, AC127, AC20.6, AC20.7
BDH-RELEASED
RELEASED
Alpha 1This field indicates whether a change order associated with the budget has been released. Use Yes for Released and No for Not Released.
  • Y Released
  • N Not Released
AC123, AC127, AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1
BDH-RPT-RATE-1
RPT_RATE_1
Signed 14.7The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).AC123, AC127, AC20.6, AC20.7, AC581
BDH-RPT-RATE-2
RPT_RATE_2
Signed 14.7The exchange rate to convert the transaction amount to Report Currency 1. The exchange rate is defined in CU10.1 (Exchange Rate).AC123, AC127, AC20.6, AC20.7, AC581
BDH-ACT-ACTIVE-BUD
ACT_ACTIVE_BUD
DerivedThis is the active activity budget.
BDH-GRP-ACTIVE-BUD
GRP_ACTIVE_BUD
DerivedThis is the active activity group budget.

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BDHSET1ACTIVITY-GRP, ACTIVITY, BUDGET-NBRPrimaryAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +22 more (list truncated in source)
BDHSET3ACTIVITY-GRP, BUDGET-NBR, ACTIVITYAC00.1, AC20.4, AC200, BR430

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequiredBDH-ACTIVITY-GRPAGP-ACTIVITY-GRP
AcactivityACACTIVITYRequiredBDH-ACTIVITYACV-ACTIVITY
AcbudhdbodACBUDHDBODNot Required, Delete CascadesBDH-ACTIVITY-GRPYAE-ACTIVITY-GRP, BDH-ACTIVITYYAE-ACTIVITY, BDH-BUDGET-NBRYAE-BUDGET-NBR

One to many (9) — child tables

RelationTableRulesConditionField map
AcbuddtlACBUDDTLValid When BDH-ACTIVITY != SpacesBDH-ACTIVITY-GRPBDT-ACTIVITY-GRP, BDH-ACTIVITYBDT-ACTIVITY, BDH-BUDGET-NBRBDT-BUDGET-NBR, BDT-ACCT-CATEGORY, BDT-FISCAL-YEAR
Acbuddtl GrpACBUDDTLValid When BDH-ACTIVITY = SpacesBDH-ACTIVITY-GRPBDT-ACTIVITY-GRP, BDH-ACTIVITYBDT-ACTIVITY, BDH-BUDGET-NBRBDT-BUDGET-NBR, SpacesBDT-ACCT-CATEGORY, BDT-FISCAL-YEAR
AcchgorderACCHGORDERBDH-ACTIVITY-GRPCHO-ACTIVITY-GRP, BDH-ACTIVITYCHO-ACTIVITY, BDH-BUDGET-NBRCHO-BUDGET-NBR, CHO-CHG-ORDER-NBR
AccuamtACCUAMTBDH-ACTIVITY-GRPACU-ACTIVITY-GRP, BDH-ACTIVITYACU-ACTIVITY, BDH-CURRENCY-CODEACU-CURRENCY-CODE, BDH-BUDGET-NBRACU-BUDGET-NBR, ACU-ACCT-CATEGORY, ACU-FISCAL-YEAR
Accuamt GrpACCUAMTBDH-ACTIVITY-GRPACU-ACTIVITY-GRP, SpacesACU-ACTIVITY, BDH-CURRENCY-CODEACU-CURRENCY-CODE, BDH-BUDGET-NBRACU-BUDGET-NBR, ACU-ACCT-CATEGORY, ACU-FISCAL-YEAR
Accuamt Rpt1ACCUAMTBDH-ACTIVITY-GRPACU-ACTIVITY-GRP, BDH-ACTIVITYACU-ACTIVITY, AGP-CURR-CODE-1ACU-CURRENCY-CODE, BDH-BUDGET-NBRACU-BUDGET-NBR, ACU-ACCT-CATEGORY, ACU-FISCAL-YEAR
Accuamt Rpt2ACCUAMTBDH-ACTIVITY-GRPACU-ACTIVITY-GRP, BDH-ACTIVITYACU-ACTIVITY, AGP-CURR-CODE-2ACU-CURRENCY-CODE, BDH-BUDGET-NBRACU-BUDGET-NBR, ACU-ACCT-CATEGORY, ACU-FISCAL-YEAR
Acu Grp Rpt1ACCUAMTBDH-ACTIVITY-GRPACU-ACTIVITY-GRP, SpacesACU-ACTIVITY, AGP-CURR-CODE-1ACU-CURRENCY-CODE, BDH-BUDGET-NBRACU-BUDGET-NBR, ACU-ACCT-CATEGORY, ACU-FISCAL-YEAR
Acu Grp Rpt2ACCUAMTBDH-ACTIVITY-GRPACU-ACTIVITY-GRP, SpacesACU-ACTIVITY, AGP-CURR-CODE-2ACU-CURRENCY-CODE, BDH-BUDGET-NBRACU-BUDGET-NBR, ACU-ACCT-CATEGORY, ACU-FISCAL-YEAR

Programs

Updated by (23)

Referenced by (329)