Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBUDHDR


                             ACBUDHDR FILE

                         Activity Budget Header

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.

REFERENCED BY

AC00.1    AC10.1    AC165     AC190     AC210     AC220
AC225     AC25.1    AC27.1    AC30.1    AC40.1    AC40.4
AC401     AC41.1    AC41.4    AC42.1    AC420     AC421
AC45.1    AC65.1    AC65.2    AC81.1    AC97.2    AC97.4
AC97.6    ACAC.1    ACDL.1    ACDR.1    ACVW.1    SE10.1
SE90.1    AP125     AP126     AP25.1    AP25.2    AP26.1
AP27.1    AP520     BR165     BR41.1    BR41.4    BR43.1
BR65.1    BRCC.1    CB10.1    CB191     CB20.1    CB30.1
EE135     EE20.3    EE35.1    EE35.2    EE520     GL146
GL165     GL170     GL197     GL40.1    GL40.2    GL40.3
GL40.7    GL40.8    GL44.1    GL45.1    GL75.1    MA65.1
POIG.1    AC200     BR430

UPDATED BY

AC120     AC121     AC123     AC127     AC20.1    AC20.2
AC20.3    AC20.4    AC20.5    AC20.6    AC20.7    AC20.8
AC21.1    AC21.2    AC21.3    AC21.4    AC22.1    AC300
AC310     AC581

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BDH-ACTIVITY-GRP       Alpha 15                                  AC120   AC123
Element: Activity GroupRequired key. This is the activity        AC127   AC20.6
                       group for the budget header information.  AC20.7


BDH-ACTIVITY           Alpha 15                                  AC123   AC127
Element: Activity      Required key. This is the activity for    AC20.6  AC20.7
                       the budget header information.

BDH-BUDGET-NBR         Numeric 3                                 AC123   AC127
Element: Budget Number Required key. This is the budget number   AC20.6  AC20.7
                       uniquely defined in budget setup.

BDH-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC123   AC127
Element: Begin Date    The beginning date of a date range for    AC20.6  AC20.7
                       the budget.

BDH-END-DATE           Numeric 8  (yyyymmdd)                     AC123   AC127
Element: End Date      The end date of a date range for the      AC20.6  AC20.7
                       budget.

BDH-TOTAL-BUDGET       Signed 15.2                               AC121   AC123
Element: Total Budget  This is the total budget amount.          AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.7  AC22.1
                                                                 AC300

BDH-TOT-UNITS-BUD      Signed 15.2                               AC121   AC123
Element: Detail Total  This is the total number of units for     AC127   AC20.1
                       the budget.                               AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC22.1  AC300

BDH-CURRENCY-CODE      Alpha 5                                   AC123   AC127
Element: Currency Code This is the currency code for the         AC20.6  AC20.7
                       budget.

BDH-RATE-VALUE         Signed 12.6                               AC123   AC127
Element: Rate Value    This is the budget exchange rate.         AC20.7

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

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

BDH-CALC-DATE          Numeric 8  (yyyymmdd)                     AC121   AC123
Element: Calculation DaThis is the date budget amounts were      AC127   AC20.1
                       last calculated.                          AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC22.1

BDH-CALC-TIME          Numeric 6  (hhmmss)                       AC121   AC123
Element: Calculation TiThis is the time budget amounts were      AC127   AC20.1
                       last calculated.                          AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC22.1

BDH-DESCRIPTION        Alpha 30  (Lower Case)                    AC00.1  AC123
Element: Budget DescripThis is the budget description.           AC127   AC20.6
                                                                 AC20.7

BDH-ROUND-TYPE         Alpha 1                                   AC123   AC127
Element: Rounding Type This field indicates the type of          AC20.6  AC20.7
                       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

BDH-UNT-ROUND-TYPE     Alpha 1                                   AC123   AC127
Element: Round Type    This field indicates the type of          AC20.6  AC20.7
                       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

BDH-LOCK               Alpha 1                                   AC123   AC127
Element: All Flag      This flag indicates whether the budget    AC20.6  AC20.7
                       is locked.                                AC20.8  AC300
                       N = No
                       Y = Yes

BDH-NUM-DECIMALS       Numeric 1                                 AC123   AC127
Element: Number of DeciThis is the number of decimal positions   AC20.6  AC20.7
                       to calculate for the budget amount.

BDH-UNT-NUM-DEC        Numeric 1                                 AC123   AC127
Element: Num Decimals  This is the number of decimal positions   AC20.6  AC20.7
                       to calculate for the units budget.

BDH-FACTOR             Alpha 15                                  AC300
Element: Factor        The element that affects the budget
                       change.

BDH-FACTOR-RATE        Signed 12.6                               AC300
Element: Account Rate

BDH-LIFE-ONLY          Alpha 1                                   AC123   AC127
Element: All Flag      This field indicates whether the budget   AC20.6  AC20.7
                       is life-only.
                       Y = Yes
                       N = No

BDH-RELEASED           Alpha 1                                   AC123   AC127
Element: Released      This field indicates whether a change     AC21.1  AC21.2
                       order associated with the budget has      AC21.3  AC21.4
                       been released. Use Yes for Released and   AC22.1  AC300
                       No for Not Released.
                       Y = Released
                       N = Not Released

BDH-RPT-RATE-1         Signed 12.6                               AC123   AC127
Element: Rpt Rate 1    The exchange rate to convert the          AC20.6  AC20.7
                       transaction amount to Report Currency 1.  AC581
                       The exchange rate is defined in CU10.1
                       (Exchange Rate).

BDH-RPT-RATE-2         Signed 12.6                               AC123   AC127
Element: Rpt Rate 1                                              AC20.6  AC20.7
                                                                 AC581

BDH-ACT-ACTIVE-BUD     Derived
Element: Act Active BudThis is the active activity budget.

BDH-GRP-ACTIVE-BUD     Derived
Element: Grp Active BudThis is the active activity group
                       budget.

                         ACBUDHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BDHSET1   ACTIVITY-GRP                                           AC00.1  AC10.1
          ACTIVITY                                               AC120   AC121
          BUDGET-NBR                                             AC123   AC127
                                                                 AC165   AC190
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 AC20.7  AC20.8
                                                                 AC21.1  AC21.2
                                                                 AC21.3  AC21.4
                                                                 AC210   AC22.1
                                                                 AC220   AC225
                                                                 AC25.1  AC27.1
                                                                 AC30.1  AC300
                                                                 AC310   AC40.1
                                                                 ...

BDHSET3   ACTIVITY-GRP                                           AC00.1  AC20.4
          BUDGET-NBR                                             AC200   BR430
          ACTIVITY

                         ACBUDHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            BDH-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            BDH-ACTIVITY         -> ACV-ACTIVITY

                         ACBUDHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbuddtl       ACBUDDTL
                            Valid When BDH-ACTIVITY != Spaces

                            BDH-ACTIVITY-GRP     -> BDT-ACTIVITY-GRP
                            BDH-ACTIVITY         -> BDT-ACTIVITY
                            BDH-BUDGET-NBR       -> BDT-BUDGET-NBR
                                                    BDT-ACCT-CATEGORY
                                                    BDT-FISCAL-YEAR

Acbuddtl Grp   ACBUDDTL
                            Valid When BDH-ACTIVITY = Spaces

                            BDH-ACTIVITY-GRP     -> BDT-ACTIVITY-GRP
                            BDH-ACTIVITY         -> BDT-ACTIVITY
                            BDH-BUDGET-NBR       -> BDT-BUDGET-NBR
                            Spaces               -> BDT-ACCT-CATEGORY
                                                    BDT-FISCAL-YEAR

Acchgorder     ACCHGORDER

                            BDH-ACTIVITY-GRP     -> CHO-ACTIVITY-GRP
                            BDH-ACTIVITY         -> CHO-ACTIVITY
                            BDH-BUDGET-NBR       -> CHO-BUDGET-NBR
                                                    CHO-CHG-ORDER-NBR

Accuamt        ACCUAMT

                            BDH-ACTIVITY-GRP     -> ACU-ACTIVITY-GRP
                            BDH-ACTIVITY         -> ACU-ACTIVITY
                            BDH-CURRENCY-CODE    -> ACU-CURRENCY-CODE
                            BDH-BUDGET-NBR       -> ACU-BUDGET-NBR
                                                    ACU-ACCT-CATEGORY
                                                    ACU-FISCAL-YEAR

Accuamt Grp    ACCUAMT

                            BDH-ACTIVITY-GRP     -> ACU-ACTIVITY-GRP
                            Spaces               -> ACU-ACTIVITY
                            BDH-CURRENCY-CODE    -> ACU-CURRENCY-CODE
                            BDH-BUDGET-NBR       -> ACU-BUDGET-NBR
                                                    ACU-ACCT-CATEGORY
                                                    ACU-FISCAL-YEAR

Accuamt Rpt1   ACCUAMT

                            BDH-ACTIVITY-GRP     -> ACU-ACTIVITY-GRP
                            BDH-ACTIVITY         -> ACU-ACTIVITY
                            AGP-CURR-CODE-1      -> ACU-CURRENCY-CODE
                            BDH-BUDGET-NBR       -> ACU-BUDGET-NBR
                                                    ACU-ACCT-CATEGORY
                                                    ACU-FISCAL-YEAR

Accuamt Rpt2   ACCUAMT

                            BDH-ACTIVITY-GRP     -> ACU-ACTIVITY-GRP
                            BDH-ACTIVITY         -> ACU-ACTIVITY
                            AGP-CURR-CODE-2      -> ACU-CURRENCY-CODE
                            BDH-BUDGET-NBR       -> ACU-BUDGET-NBR
                                                    ACU-ACCT-CATEGORY
                                                    ACU-FISCAL-YEAR

Acu Grp Rpt1   ACCUAMT

                            BDH-ACTIVITY-GRP     -> ACU-ACTIVITY-GRP
                            Spaces               -> ACU-ACTIVITY
                            AGP-CURR-CODE-1      -> ACU-CURRENCY-CODE
                            BDH-BUDGET-NBR       -> ACU-BUDGET-NBR
                                                    ACU-ACCT-CATEGORY
                                                    ACU-FISCAL-YEAR

Acu Grp Rpt2   ACCUAMT

                            BDH-ACTIVITY-GRP     -> ACU-ACTIVITY-GRP
                            Spaces               -> ACU-ACTIVITY
                            AGP-CURR-CODE-2      -> ACU-CURRENCY-CODE
                            BDH-BUDGET-NBR       -> ACU-BUDGET-NBR
                                                    ACU-ACCT-CATEGORY
                                                    ACU-FISCAL-YEAR