ACBUDDTL – Activity Budget

System
Activity Management (AC)
Prefix
BDT
Primary key
ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEAR
Fields
29
Updated by
19 programs
Referenced by
34 programs

ACBUDDTL is the Activity Budget table in Lawson Activity Management (prefix BDT). It is indexed by ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEAR (BDTSET1); alternate indexes: BDTSET2, BDTSET3, BDTSET4, BDTSET6 and BDTSET7. It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTIVITY, ACBUDHDR, ACBUDTLBOD, ACCUAMT, ACMASTER and ACSPREAD. It is updated by AC08.3, AC08.7, AC120, AC121, AC123, AC127, AC20.1, AC20.2 and 11 more and referenced by AC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC10.1, AC130 and 26 more. The table has 29 fields, 6 indexes and 8 documented relations.

About ACBUDDTL

This file contains activity budget information from the AC20 (Activity Budget) forms. It includes activity group, activity, budget number, beginning balance, account category, fiscal year, spread code, compute name, as well as maintenance time and date.

Fields (29)

Column = COBOL field name without the BDT- 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
#BDT-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15Required key. This is the activity group for the budget information.AC120, AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4 +6 more
#BDT-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity for the budget information.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-BUDGET-NBR PK
BUDGET_NBR		Numeric 3Required key. This is the budget number uniquely defined in budget setup.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-ACCT-CATEGORY PK
ACCT_CATEGORY		Alpha 5Required key. This is the account category for the budget information.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Required key. This is the budget year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-PARENT-ACTV SET7
PARENT_ACTV		Alpha 15The parent activity field contains the activity name of the member parent.AC120, AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4 +6 more
#BDT-COMPUTE-NAME
COMPUTE_NAME		Alpha 12This is the name for a compute statement. You can use a compute statement to calculate the budget. Use the Compute action code and define a compute statement, consisting of data dictionary items and operation symbols. You can define compute statements in RW50.1 (Compute Statements).AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-PARAM-NAME
PARAM_NAME		Alpha 12—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)This is the date the budget was changed.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)This is the time the budget was changed.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-SPREAD-CODE SET4
SPREAD_CODE		Alpha 3A spread code is a formula for budgeting spending activity that can be set up in AC23.1 (Spread Codes). 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 characteristic spending patterns.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-BALANCE
BALANCE		Signed 18.2This is the annual balance of the budget for the indicated year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-BALANCE-UNIT
BALANCE_UNIT		Signed 17.2This is the units balance for the budget for the indicated year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-BEGIN-BAL
BEGIN_BAL		Signed 18.2This is the beginning balance for the budget for the indicated year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-BEGIN-BAL-UNIT
BEGIN_BAL_UNIT		Signed 15.2This is the units balance for the budget for the indicated year.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-FACTOR
FACTOR		Alpha 15The element that affects the budget change.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-FACTOR-RATE
FACTOR_RATE		Signed 14.7The currency rate.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-BLANK
BLANK		DerivedThis derived field is always blank. It is used in the Drill Around feature for column headings.—
#BDT-AMT-VARIANCE
AMT_VARIANCE		DerivedThis is the amount of the budget variance.—
#BDT-UNIT-VARIANCE
UNIT_VARIANCE		DerivedThis is the number of units for the budget variance.—
#BDT-VARIANCE
VARIANCE		DerivedThis is the percentage of variance from the budget amount.—
#BDT-VARIANCE-UNITS
VARIANCE_UNITS		DerivedThis is the percentage of variance from the units budget.—
#BDT-OVER-UNDER
OVER_UNDER		DerivedThis field indicates whether there is a variance, either over or under, the budgeted amount. If there is no variance, the field is blank.—
#BDT-OVER-UNDER-UNT
OVER_UNDER_UNT		DerivedThis field indicates whether there is a variance, either over or under, the budgeted number of units. If there is no variance, the field is blank.—
#BDT-ACCT-CAT-TYPE
ACCT_CAT_TYPE		DerivedThis is the account category type: cost, revenue, or accrual.—
#BDT-PERIOD-AMT
PERIOD_AMT		Signed 18.2 Occurs 13 Times ×13—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-PERIOD-UNIT
PERIOD_UNIT		Signed 15.2 Occurs 13 Times ×13—AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-PERIOD-FACTOR
PERIOD_FACTOR		Alpha 15 Occurs 13 Times ×13The element that affects the budget change.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more
#BDT-PERIOD-RATE
PERIOD_RATE		Signed 14.7 Occurs 13 Times ×13You 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.AC121, AC123, AC127, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +5 more

Indexes (6)

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
BDTSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. BUDGET-NBR
  4. ACCT-CATEGORY
  5. FISCAL-YEAR
PrimaryAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +22 more (list truncated in source)
BDTSET2
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. BUDGET-NBR
  4. FISCAL-YEAR
  5. ACCT-CATEGORY
AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
BDTSET3
  1. ACTIVITY-GRP
  2. BUDGET-NBR
  3. ACCT-CATEGORY
  4. FISCAL-YEAR
  5. ACTIVITY
AC20.5
BDTSET4
  1. SPREAD-CODE
  2. ACTIVITY-GRP
  3. ACTIVITY
  4. BUDGET-NBR
  5. ACCT-CATEGORY
  6. FISCAL-YEAR
KeyChangeAC23.1
BDTSET6
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. BUDGET-NBR
  4. ACCT-CATEGORY
  5. FISCAL-YEAR ↓
AC121, AC123, AC127, AC130, AC165, AC20.1, AC20.2, AC20.3 +20 more
BDTSET7
  1. ACTIVITY-GRP
  2. PARENT-ACTV
  3. BUDGET-NBR
  4. ACCT-CATEGORY
  5. FISCAL-YEAR
  6. ACTIVITY
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACCTCATACACTGRPACACTIVITYACBUDHDRACBUDTLBODACCUAMTACMASTERACSPREADACBUDDTL

One to one (8) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot Required
BDT-ACCT-CATEGORY→AAX-ACCT-CATEGORY (AAXSET1)
AcactgrpACACTGRPRequired
BDT-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
BDT-ACTIVITY-GRP→ACV-ACTIVITY-GRP
BDT-ACTIVITY→ACV-ACTIVITY
AcbudhdrACBUDHDRRequired
BDT-ACTIVITY-GRP→BDH-ACTIVITY-GRP
BDT-ACTIVITY→BDH-ACTIVITY
BDT-BUDGET-NBR→BDH-BUDGET-NBR
AcbudtlbodACBUDTLBODNot Required, Delete Cascades
BDT-ACTIVITY-GRP→YAD-ACTIVITY-GRP
BDT-ACTIVITY→YAD-ACTIVITY
BDT-BUDGET-NBR→YAD-BUDGET-NBR
BDT-ACCT-CATEGORY→YAD-ACCT-CATEGORY
BDT-FISCAL-YEAR→YAD-FISCAL-YEAR
AccuamtACCUAMTNot Required
BDT-ACTIVITY-GRP→ACU-ACTIVITY-GRP
BDT-ACTIVITY→ACU-ACTIVITY
BDH-CURRENCY-CODE→ACU-CURRENCY-CODE
BDT-BUDGET-NBR→ACU-BUDGET-NBR
BDT-FISCAL-YEAR→ACU-FISCAL-YEAR
BDT-ACCT-CATEGORY→ACU-ACCT-CATEGORY
AcmasterACMASTERNot Required
BDT-ACTIVITY-GRP→MST-ACTIVITY-GRP
BDT-ACTIVITY→MST-ACTIVITY
BDT-ACCT-CATEGORY→MST-ACCT-CATEGORY
BDT-FISCAL-YEAR→MST-FISCAL-YEAR
AcspreadACSPREADNot Required
BDT-SPREAD-CODE→SPR-SPREAD-CODE

Programs

Updated by (19)

Referenced by (34)