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.

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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BDTSET1ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEARPrimaryAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +22 more (list truncated in source)
BDTSET2ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, FISCAL-YEAR, ACCT-CATEGORYAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +11 more
BDTSET3ACTIVITY-GRP, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEAR, ACTIVITYAC20.5
BDTSET4SPREAD-CODE, ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEARKeyChangeAC23.1
BDTSET6ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEAR*AC121, AC123, AC127, AC130, AC165, AC20.1, AC20.2, AC20.3 +20 more
BDTSET7ACTIVITY-GRP, PARENT-ACTV, BUDGET-NBR, ACCT-CATEGORY, FISCAL-YEAR, ACTIVITYKeyChange—

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
AcacctcatACACCTCATNot RequiredBDT-ACCT-CATEGORY → AAX-ACCT-CATEGORY (AAXSET1)
AcactgrpACACTGRPRequiredBDT-ACTIVITY-GRP → AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequiredBDT-ACTIVITY-GRP → ACV-ACTIVITY-GRP, BDT-ACTIVITY → ACV-ACTIVITY
AcbudhdrACBUDHDRRequiredBDT-ACTIVITY-GRP → BDH-ACTIVITY-GRP, BDT-ACTIVITY → BDH-ACTIVITY, BDT-BUDGET-NBR → BDH-BUDGET-NBR
AcbudtlbodACBUDTLBODNot Required, Delete CascadesBDT-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 RequiredBDT-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 RequiredBDT-ACTIVITY-GRP → MST-ACTIVITY-GRP, BDT-ACTIVITY → MST-ACTIVITY, BDT-ACCT-CATEGORY → MST-ACCT-CATEGORY, BDT-FISCAL-YEAR → MST-FISCAL-YEAR
AcspreadACSPREADNot RequiredBDT-SPREAD-CODE → SPR-SPREAD-CODE

Programs

Updated by (19)

Referenced by (34)