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

AC421

UPDATED BY

AC21.1    AC21.2    AC21.3    AC21.4    AC22.1    AC300
AC310     AC20.1    AC20.2    AC20.3    AC20.4    AC20.5
AC20.6    AC20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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
                       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
                       currency.

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

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

CHX-PRIOR-AMOUNT       Signed 15.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
                       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: 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: 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: Factor        This is the prior factor for the          AC21.3  AC21.4
                       budget.

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

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


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

CHX-SPREAD-CODE        Alpha 3                                   AC21.2
Element: Authority Code

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                                           AC20.1  AC20.2
          ACTIVITY                                               AC20.3  AC20.4
          BUDGET-NBR                                             AC20.5  AC20.6
          CHG-ORDER-NBR                                          AC20.7  AC21.1
          ACCT-CATEGORY                                          AC21.2  AC21.3
          FISCAL-YEAR                                            AC21.4  AC22.1
          PERIOD                                                 AC300   AC310
                                                                 AC421

CHXSET2   ACTIVITY-GRP
          ACTIVITY
          BUDGET-NBR
          ACCT-CATEGORY
          CHG-ORDER-NBR
          FISCAL-YEAR
          PERIOD

CHXSET3   ACTIVITY-GRP  KeyChange                                AC21.4
          ACTIVITY
          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