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    AC400     AC410     AC420     AC472
AC473     AC490     AC96.1    AC96.4    AC98.2    ACDL.1
AC295     ACTA.1    AC145     AC190     AC421     AC93.3

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

ACU-FACTOR-RATE        Signed 14.7                               AC121   AC123
Element: 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.

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

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

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

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

ACU-PERIOD-RATE        Signed 14.7 Occurs 13 Times               AC121   AC123
Element: Rate                                                    AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1

ACU-PERIOD-FACTOR      Alpha 15 Occurs 13 Times                  AC121   AC123
Element: Factor                                                  AC127   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC20.6  AC20.7
                                                                 AC22.1  ACDR.1

                         ACCUAMT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACUSET1   ACTIVITY-GRP                                           AC121   AC123
          ACTIVITY                                               AC127   AC130
          CURRENCY-CODE                                          AC20.1  AC20.2
          BUDGET-NBR                                             AC20.3  AC20.4
          FISCAL-YEAR                                            AC20.5  AC20.6
          ACCT-CATEGORY                                          AC20.7  AC21.1
                                                                 AC21.2  AC21.3
                                                                 AC21.4  AC22.1
                                                                 AC220   AC300
                                                                 AC310   AC32.1
                                                                 AC37.1  AC400
                                                                 AC410   AC420
                                                                 AC472   AC473
                                                                 AC490   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
                                                                 AC295   ACDR.1
                                                                 ACTA.1

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
                                                                 AC295   AC32.1
                                                                 AC37.1  AC400
                                                                 AC421   AC473
                                                                 AC490   AC93.3
                                                                 AC96.1  AC96.4
                                                                 AC98.2  ACDR.1
                                                                 ACTA.1

ACUSET4   ACTIVITY-GRP
          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

Aclevel        ACLEVEL      Required

                            ACU-ACTIVITY-GRP     -> LVL-ACTIVITY-GRP
                            ACU-VAR-LEVELS       -> LVL-VAR-LEVELS

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