Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBUDDTL


                             ACBUDDTL FILE

                            Activity Budget

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.

REFERENCED BY

AC00.1    AC08.3    AC08.7    AC10.1    AC21.1    AC21.2
AC21.3    AC21.4    AC220     AC420     AC527     AC56.1
AC560     AC65.2    AC65.1    ACDL.1    ACTA.1    SNAC.1
AC130     AC32.1    AC37.1    AC490     AC23.1    AC165
BR12.2    BR130     BR165     BR530     BR65.1    BR65.2
BR65.3

UPDATED BY

AC120     AC121     AC123     AC127     AC20.1    AC20.2
AC20.3    AC20.4    AC20.5    AC20.6    AC20.7    AC22.1
AC300     AC310     ACDR.1    SB515

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BDT-ACTIVITY-GRP       Alpha 15                                  AC120   AC121
Element: Activity GroupRequired key. This is the activity        AC123   AC127
                       group for the budget information.         AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 AC20.7  AC22.1
                                                                 ACDR.1  SB515

BDT-ACTIVITY           Alpha 15                                  AC121   AC123
Element: Activity      Required key. This is the activity for    AC127   AC20.1
                       the budget information.                   AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-BUDGET-NBR         Numeric 3                                 AC121   AC123
Element: Budget Number Required key. This is the budget number   AC127   AC20.1
                       uniquely defined in budget setup.         AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-ACCT-CATEGORY      Alpha 5                                   AC121   AC123
Element: Account CategoRequired key. This is the account         AC127   AC20.1
                       category for the budget information.      AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-FISCAL-YEAR        Numeric 4                                 AC121   AC123
Element: Fiscal Year   Required key. This is the budget year.    AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-PARENT-ACTV        Alpha 15                                  AC120   AC121
Element: Parent Actv   The parent activity field contains the    AC123   AC127
                       activity name of the member parent.       AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 AC20.7  AC22.1
                                                                 ACDR.1  SB515

BDT-COMPUTE-NAME       Alpha 12                                  AC121   AC123
Element: Compute Name  This is the name for a compute            AC127   AC20.1
                       statement. You can use a compute          AC20.2  AC20.3
                       statement to calculate the budget. Use    AC20.4  AC20.5
                       the Compute action code and define a      AC20.6  AC20.7
                       compute statement, consisting of data     AC22.1  ACDR.1
                       dictionary items and operation symbols.   SB515
                       You can define compute statements in
                       RW50.1 (Compute Statements).

BDT-PARAM-NAME         Alpha 12                                  AC121   AC123
Element: Param Name                                              AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-MAINT-DATE         Numeric 8  (yyyymmdd)                     AC121   AC123
Element: Maintenance DaThis is the date the budget was           AC127   AC20.1
                       changed.                                  AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-MAINT-TIME         Numeric 6  (hhmmss)                       AC121   AC123
Element: Maintenance TiThis is the time the budget was           AC127   AC20.1
                       changed.                                  AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-SPREAD-CODE        Alpha 3                                   AC121   AC123
Element: Spread Code   A spread code is a formula for            AC127   AC20.1
                       budgeting spending activity that can be   AC20.2  AC20.3
                       set up in AC23.1 (Spread Codes). You can  AC20.4  AC20.5
                       use a spread code to schedule spending    AC20.6  AC20.7
                       over the life of the activity or          AC22.1  ACDR.1
                       activity group. Spread codes can be used  SB515
                       to represent characteristic spending
                       patterns.

BDT-BALANCE            Signed 18.2                               AC121   AC123
Element: Budget BalanceThis is the annual balance of the         AC127   AC20.1
                       budget for the indicated year.            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-BALANCE-UNIT       Signed 17.2                               AC121   AC123
Element: Balance Unit  This is the units balance for the         AC127   AC20.1
                       budget for the indicated year.            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-BEGIN-BAL          Signed 18.2                               AC121   AC123
Element: Beginning BalaThis is the beginning balance for the     AC127   AC20.1
                       budget for the indicated year.            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-BEGIN-BAL-UNIT     Signed 15.2                               AC121   AC123
Element: Begin Bal UnitThis is the units balance for the         AC127   AC20.1
                       budget for the indicated year.            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-FACTOR             Alpha 15                                  AC121   AC123
Element: Factor        The element that affects the budget       AC127   AC20.1
                       change.                                   AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-FACTOR-RATE        Signed 14.7                               AC121   AC123
Element: Curr Rate     The currency rate.                        AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-BLANK              Derived
Element: Blank         This derived field is always blank. It
                       is used in the Drill Around feature for
                       column headings.

BDT-AMT-VARIANCE       Derived
Element: Amt Variance  This is the amount of the budget
                       variance.

BDT-UNIT-VARIANCE      Derived
Element: Unit Variance This is the number of units for the
                       budget variance.

BDT-VARIANCE           Derived
Element: Variance      This is the percentage of variance from
                       the budget amount.

BDT-VARIANCE-UNITS     Derived
Element: Variance UnitsThis is the percentage of variance from
                       the units budget.

BDT-OVER-UNDER         Derived
Element: Over Under    This 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     Derived
Element: Over Under UntThis 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      Derived
Element: Acct Cat Type This is the account category type:
                       cost, revenue, or accrual.

BDT-PERIOD-AMT         Signed 18.2 Occurs 13 Times               AC121   AC123
Element: Intl Amt                                                AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-PERIOD-UNIT        Signed 15.2 Occurs 13 Times               AC121   AC123
Element: Unit                                                    AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-PERIOD-FACTOR      Alpha 15 Occurs 13 Times                  AC121   AC123
Element: Factor        The element that affects the budget       AC127   AC20.1
                       change.                                   AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

BDT-PERIOD-RATE        Signed 14.7 Occurs 13 Times               AC121   AC123
Element: Factor Rate   You can type or select the rate that      AC127   AC20.1
                       affects the factor. For example, you      AC20.2  AC20.3
                       could type the inflation rate.            AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                       If you select units and amounts, the      AC22.1  ACDR.1
                       rate is calculated.                       SB515

                         ACBUDDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BDTSET1   ACTIVITY-GRP                                           AC00.1  AC08.3
          ACTIVITY                                               AC08.7  AC10.1
          BUDGET-NBR                                             AC120   AC121
          ACCT-CATEGORY                                          AC123   AC127
          FISCAL-YEAR                                            AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 AC20.7  AC21.1
                                                                 AC21.2  AC21.3
                                                                 AC21.4  AC22.1
                                                                 AC220   AC300
                                                                 AC310   AC420
                                                                 AC527   AC56.1
                                                                 AC560   AC65.2
                                                                 ACDL.1  ACDR.1
                                                                 ...

BDTSET2   ACTIVITY-GRP                                           AC121   AC123
          ACTIVITY                                               AC130   AC20.1
          BUDGET-NBR                                             AC20.2  AC20.3
          FISCAL-YEAR                                            AC20.4  AC20.5
          ACCT-CATEGORY                                          AC20.6  AC20.7
                                                                 AC21.4  AC220
                                                                 AC32.1  AC37.1
                                                                 AC490   AC527

BDTSET3   ACTIVITY-GRP                                           AC20.5
          BUDGET-NBR
          ACCT-CATEGORY
          FISCAL-YEAR
          ACTIVITY

BDTSET4   SPREAD-CODE   KeyChange                                AC23.1
          ACTIVITY-GRP
          ACTIVITY
          BUDGET-NBR
          ACCT-CATEGORY
          FISCAL-YEAR

BDTSET6   ACTIVITY-GRP                                           AC121   AC123
          ACTIVITY                                               AC127   AC130
          BUDGET-NBR                                             AC165   AC20.1
          ACCT-CATEGORY                                          AC20.2  AC20.3
          FISCAL-YEAR*                                           AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC21.1  AC22.1
                                                                 AC32.1  AC37.1
                                                                 AC490   AC65.1
                                                                 AC65.2  ACDR.1
                                                                 ACTA.1  BR12.2
                                                                 BR130   BR165
                                                                 BR530   BR65.1
                                                                 BR65.2  BR65.3
                                                                 SB515

BDTSET7   ACTIVITY-GRP  KeyChange
          PARENT-ACTV
          BUDGET-NBR
          ACCT-CATEGORY
          FISCAL-YEAR
          ACTIVITY

                         ACBUDDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            BDT-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY  (AAXSET1)

Acactgrp       ACACTGRP     Required

                            BDT-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            BDT-ACTIVITY-GRP     -> ACV-ACTIVITY-GRP
                            BDT-ACTIVITY         -> ACV-ACTIVITY

Acbudhdr       ACBUDHDR     Required

                            BDT-ACTIVITY-GRP     -> BDH-ACTIVITY-GRP
                            BDT-ACTIVITY         -> BDH-ACTIVITY
                            BDT-BUDGET-NBR       -> BDH-BUDGET-NBR

Accuamt        ACCUAMT      Not 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

Acmaster       ACMASTER     Not Required

                            BDT-ACTIVITY-GRP     -> MST-ACTIVITY-GRP
                            BDT-ACTIVITY         -> MST-ACTIVITY
                            BDT-ACCT-CATEGORY    -> MST-ACCT-CATEGORY
                            BDT-FISCAL-YEAR      -> MST-FISCAL-YEAR

Acspread       ACSPREAD     Not Required

                            BDT-SPREAD-CODE      -> SPR-SPREAD-CODE