Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCUAMT


                              ACCUAMT FILE

                        Activity Currency Amount

This file holds values for both budgets and actual amounts only when
multicurrency is an issue because the activity currency is different from the
activity group currency.

Budget information is stored in the budget's currency because the base
currency values are stored in the Activity Budget and Activity Budget Detail
files.

Actual amount information is stored in the base (activity group) currency
because the transaction currency values are stored in the Activity Master
file.

REFERENCED BY

AC130     AC21.1    AC21.2    AC21.3    AC21.4    AC220
AC32.1    AC37.1    AC420     AC472     AC473     AC490
AC527     AC96.1    AC96.4    AC98.2    ACDL.1    ACTA.1
AC145     AC190     AC421     AC93.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

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

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

ACU-BUDGET-NBR         Numeric 3                                 AC121   AC123
Element: Budget Number Required key. This is the budget number   AC127   AC20.1
                       for the budget and actual amount          AC20.2  AC20.3
                       information.                              AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

ACU-FISCAL-YEAR        Numeric 4                                 AC121   AC123
Element: Fiscal Year   Required key. This is the fiscal year     AC127   AC20.1
                       for the budget and actual amount          AC20.2  AC20.3
                       information..                             AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

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

ACU-CURRENCY-CODE      Alpha 5                                   AC121   AC123
Element: Currency Code Required key. This field contains the     AC127   AC20.1
                       base currency code for the activity       AC20.2  AC20.3
                       group. It is defined in AC00.1 (Activity  AC20.4  AC20.5
                       Group).                                   AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

ACU-VAR-LEVELS         Alpha 30                                  AC120   AC121
Element: Variable LevelThis is the variable level for the        AC123   AC127
                       budget and actual amount information.     AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC20.6
                                                                 AC20.7  AC22.1
                                                                 ACDR.1  SB515

ACU-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

ACU-CURR-ND            Numeric 1                                 AC121   AC123
Currency Number of     This field defines the number of          AC127   AC20.1
Decimals               decimals for the budget currency.         AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

ACU-BALANCE-AMOUNT     Signed 18.2                               AC121   AC123
Element: Amount BalanceThis is the amount balance for the        AC127   AC20.1
                       current year.                             AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

ACU-BALANCE-UNIT       Signed 17.2                               AC121   AC123
Element: Units Balance This is the unit balance for the          AC127   AC20.1
                       current year.                             AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

ACU-BEGIN-BAL-AMT      Signed 18.2                               AC121   AC123
Amount Beginning       This is the life-to-date amount up        AC127   AC20.1
Balance                until the start of the current year.      AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

ACU-BEGIN-BAL-UNT      Signed 15.2                               AC121   AC123
Units Beginning        This is the life-to-date units up until   AC127   AC20.1
Balance                the start of the current year.            AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

ACU-LTD-AMOUNT         Derived
Element: Life-to-Date AThis is the sum of the Amount Balance
                       and the Amount Beginning Balance fields
                       for the fiscal year.

ACU-LTD-UNIT           Derived
Element: Life-to-Date UThis is the sum of the Unit Balance and
                       the Unit Beginning Balance fields for
                       the fiscal year.

ACU-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

ACU-FACTOR-RATE        Signed 14.7                               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

ACU-MAINT-DATE         Numeric 8  (yyyymmdd)                     AC121   AC123
Element: Maint Date    The date last changed.                    AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

ACU-MAINT-TIME         Numeric 6  (hhmmss)                       AC121   AC123
Element: Sys Time                                                AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1
                                                                 SB515

ACU-ACCT-CAT-TYPE      Derived
Element: Acct Cat Type

ACU-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

ACU-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

ACU-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

ACU-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

                         ACCUAMT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACUSET1   ACTIVITY-GRP                                           AC120   AC121
          ACTIVITY                                               AC123   AC127
          CURRENCY-CODE                                          AC130   AC20.1
          BUDGET-NBR                                             AC20.2  AC20.3
          FISCAL-YEAR                                            AC20.4  AC20.5
          ACCT-CATEGORY                                          AC20.6  AC20.7
                                                                 AC21.1  AC21.2
                                                                 AC21.3  AC21.4
                                                                 AC22.1  AC220
                                                                 AC300   AC310
                                                                 AC32.1  AC37.1
                                                                 AC420   AC472
                                                                 AC473   AC490
                                                                 AC527   AC96.1
                                                                 AC96.4  AC98.2
                                                                 ...

ACUSET2   ACTIVITY-GRP                                           AC121   AC123
          ACTIVITY                                               AC127   AC20.1
          CURRENCY-CODE                                          AC20.2  AC20.3
          BUDGET-NBR                                             AC20.4  AC20.5
          ACCT-CATEGORY                                          AC20.6  AC20.7
          FISCAL-YEAR                                            AC22.1  AC220
                                                                 ACDR.1  ACTA.1
                                                                 SB515

ACUSET3   ACTIVITY-GRP                                           AC121   AC123
          ACTIVITY                                               AC127   AC130
          CURRENCY-CODE                                          AC145   AC190
          BUDGET-NBR                                             AC20.1  AC20.2
          ACCT-CATEGORY                                          AC20.3  AC20.4
          FISCAL-YEAR*                                           AC20.5  AC20.6
                                                                 AC20.7  AC22.1
                                                                 AC32.1  AC37.1
                                                                 AC421   AC473
                                                                 AC490   AC93.3
                                                                 AC96.1  AC96.4
                                                                 AC98.2  ACDR.1
                                                                 ACTA.1  SB515

ACUSET4   ACTIVITY-GRP                                           AC20.6  AC20.7
          ACTIVITY
          BUDGET-NBR
          CURRENCY-CODE
          FISCAL-YEAR
          ACCT-CATEGORY

ACUSET5   ACTIVITY-GRP  KeyChange
          PARENT-ACTV
          CURRENCY-CODE
          BUDGET-NBR
          ACCT-CATEGORY
          FISCAL-YEAR
          ACTIVITY

                         ACCUAMT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

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

Acactgrp       ACACTGRP     Required

                            ACU-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            ACU-ACTIVITY-GRP     -> ACV-ACTIVITY-GRP
                            ACU-ACTIVITY         -> ACV-ACTIVITY

Acbuddtl       ACBUDDTL     Not Required

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

Acbudhdr       ACBUDHDR     Required

                            ACU-ACTIVITY-GRP     -> BDH-ACTIVITY-GRP
                            ACU-ACTIVITY         -> BDH-ACTIVITY
                            ACU-BUDGET-NBR       -> BDH-BUDGET-NBR

Acmaster       ACMASTER     Not Required

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

Cucodes        CUCODES      Not Required

                            ACU-CURRENCY-CODE    -> CUC-CURRENCY-CODE

                         ACCUAMT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accommit       ACCOMMIT

                            ACU-ACTIVITY-GRP     -> MIT-ACTIVITY-GRP
                            ACU-ACTIVITY         -> MIT-ACTIVITY
                            ACU-ACCT-CATEGORY    -> MIT-ACCT-CATEGORY
                            ACU-FISCAL-YEAR      -> MIT-FISCAL-YEAR
                                                    MIT-PERIOD
                                                    MIT-SYSTEM
                                                    MIT-COMPANY
                                                    MIT-CURRENCY-CODE

Accommitx      ACCOMMITX

                            ACU-ACTIVITY-GRP     -> MIX-ACTIVITY-GRP
                            ACU-ACTIVITY         -> MIX-ACTIVITY
                            ACU-ACCT-CATEGORY    -> MIX-ACCT-CATEGORY
                            ACU-FISCAL-YEAR      -> MIX-FISCAL-YEAR
                                                    MIX-PERIOD
                                                    MIX-SYSTEM
                                                    MIX-COMPANY
                                                    MIX-CURRENCY-CODE
                                                    MIX-ATN-OBJ-ID

Actrans        ACTRANS

                            ACU-ACTIVITY         -> ATN-ACTIVITY
                            ACU-ACCT-CATEGORY    -> ATN-ACCT-CATEGORY
                            ACU-FISCAL-YEAR      -> ATN-FISCAL-YEAR
                                                    ATN-PERIOD
                                                    ATN-OBJ-ID