Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCHGORDX


                             ACCHGORDX FILE

                      Activity Change Order Detail

This file contains budget change order detailed information from AC21.1
(Activity Group Budget Change Order) and AC21.2 (Activity Budget Change
Order).

REFERENCED BY

AC10.1    AC10.5    AC421     BR422

UPDATED BY

AC120     AC21.1    AC21.2    AC21.3    AC21.4    AC22.1
AC300     AC310     BR10.1    BR22.1    PW110     AC20.1
AC20.2    AC20.3    AC20.4    AC20.5    AC20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CHX-ACTIVITY-GRP       Alpha 15                                  AC120   AC21.1
Element: Activity GroupRequired key. This is the activity        AC21.2  AC21.3
                       group for the change order.               AC21.4  BR22.1

CHX-ACTIVITY           Alpha 15                                  AC21.1  AC21.2
Element: Activity      Required key. This is the activity for    AC21.3  AC21.4
                       the change order.                         BR22.1

CHX-BUDGET-NBR         Numeric 3                                 AC21.1  AC21.2
Element: Budget Number Required key. This is the budget number   AC21.3  AC21.4
                       uniquely defined in budget setup.

CHX-CHG-ORDER-NBR      Alpha 5                                   AC21.1  AC21.2
Element: Change Order NRequired key. This is the                 AC21.3  AC21.4
                       identification number for the change      BR22.1
                       order.

CHX-ACCT-CATEGORY      Alpha 5                                   AC21.1  AC21.2
Element: Account CategoRequired key. This is the account         AC21.3  AC21.4
                       category for the change order.

CHX-FISCAL-YEAR        Numeric 4                                 AC21.1  AC21.2
Element: Fiscal Year   Required key. This is the fiscal year     AC21.3  AC21.4
                       for the budget.

CHX-PERIOD             Numeric 2                                 AC21.1  AC21.2
Element: Fiscal Period Required key. This is the fiscal period   AC21.3  AC21.4
                       for the budget.

CHX-BASE-ND            Numeric 1                                 AC21.1  AC21.2
Base Number of         Required. This is the number of decimal   AC21.3  AC21.4
Decimals               positions defined for the budget          BR22.1
                       currency.

CHX-AMOUNT             Signed 18.2                               AC21.1  AC21.2
Element: Change Order ARequired. This is the calculated          AC21.3  AC21.4
                       amount, including the change order, for   BR22.1
                       the account category for the period.

CHX-ENTERED-AMT        Signed 18.2                               AC21.1  AC21.2
Element: Intl Amt      This is the new amount, including the     AC21.3  AC21.4
                       change order, as entered for the account  BR22.1
                       category for the period.

CHX-PRIOR-AMOUNT       Signed 18.2                               AC21.1  AC21.2
Element: Prior Amount  This is the period amount for the         AC21.3  AC21.4
                       account category prior to the budget      BR22.1
                       change order.

CHX-UNIT               Signed 15.2                               AC21.1  AC21.2
Element: Unit          This is the calculated units budget,      AC21.3  AC21.4
                       including the change order, for the
                       account category for the period.

CHX-ENTERED-UNIT       Signed 15.2                               AC21.1  AC21.2
Element: Entered Unit  This is the new units budget, including   AC21.3  AC21.4
                       the change order, as entered for the
                       account category for the period.

CHX-PRIOR-UNIT         Signed 15.2                               AC21.1  AC21.2
Element: Prior Unit    This is the period units budget for the   AC21.3  AC21.4
                       account category prior to the budget
                       change order.

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

CHX-FACTOR             Alpha 15                                  AC21.1  AC21.2
Element: Factor        This is the calculated factor,            AC21.3  AC21.4
                       including the change order, for the
                       budget.

CHX-PRIOR-FACTOR       Alpha 15                                  AC21.1  AC21.2
Element: Prior Factor  This is the prior factor for the          AC21.3  AC21.4
                       budget.

CHX-FACTOR-RATE        Signed 14.7                               AC21.1  AC21.2
Element: Factor Rate   This is the calculated factor rate,       AC21.3  AC21.4
                       including the change order, for the
                       budget.

CHX-ENTERED-F-RATE     Signed 14.7                               AC21.1  AC21.2
Element: Acct Rate     This is the factor rate, including the    AC21.3  AC21.4
                       change order, as entered for the budget.


CHX-PRIOR-F-RATE       Signed 14.7                               AC21.1  AC21.2
Element: Acct Rate     This is the prior factor rate for the     AC21.3  AC21.4
                       budget.

CHX-SPREAD-CODE        Alpha 3                                   AC21.2
Element: Spread Code   A spread code is a formula for
                       budgeting spending activity that can be
                       set up in AC23.1 (Spread Codes) for each
                       account category. 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
                       the characteristic spending pattern of
                       each account category.

CHX-CHANGE-AMOUNT      Derived
Element: Change Amount This is the change amount (the change
                       order information) for the account
                       category for the period.

CHX-CHANGE-UNITS       Derived
Element: Change Units  This is the change number of units (the
                       change order information) for the
                       account category for the period.

                         ACCHGORDX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CHXSET1   ACTIVITY-GRP                                           AC10.1  AC10.5
          ACTIVITY                                               AC120   AC20.1
          BUDGET-NBR                                             AC20.2  AC20.3
          CHG-ORDER-NBR                                          AC20.4  AC20.5
          ACCT-CATEGORY                                          AC20.7  AC21.1
          FISCAL-YEAR                                            AC21.2  AC21.3
          PERIOD                                                 AC21.4  AC22.1
                                                                 AC300   AC310
                                                                 AC421   BR10.1
                                                                 BR10.2  BR22.1
                                                                 PW110

CHXSET3   ACTIVITY-GRP  KeyChange                                AC21.4  BR22.1
          ACTIVITY                                               BR422
          BUDGET-NBR
          CHG-ORDER-NBR
          FISCAL-YEAR
          PERIOD
          ACCT-CATEGORY

                         ACCHGORDX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            CHX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acbudhdr       ACBUDHDR     Required

                            CHX-ACTIVITY-GRP     -> BDH-ACTIVITY-GRP
                            CHX-ACTIVITY         -> BDH-ACTIVITY
                            CHX-BUDGET-NBR       -> BDH-BUDGET-NBR

Acchgorder     ACCHGORDER   Required

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