Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCHGORDER


                            ACCHGORDER FILE

                         Activity Change Order

This file contains budget change order information from AC21.1 (Budget Change
Orders). It includes activity group, activity, budget number, change order
number, approval information, maintenance date and time, and a released flag.

REFERENCED BY

AC421

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CHO-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  AC22.1

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

CHO-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.         AC22.1

CHO-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      AC22.1
                       order.

CHO-DESCRIPTION        Alpha 30  (Lower Case)                    AC21.1  AC21.2
Element: Description   This field displays the description.      AC21.3  AC21.4

CHO-APPROVAL-FLAG      Alpha 1                                   AC21.1  AC21.2
Element: Approval Flag This flag indicates whether the change    AC21.3  AC21.4
                       order is approved.. Use Yes if the        AC22.1
                       change order is approved. Use No if the
                       change order is not approved.
                       Y = Approved
                       N = Not Approved

CHO-APPROVAL           Alpha 15                                  AC21.1  AC21.2
Element: Approval      This field is for the name of the         AC21.3  AC21.4
                       person who approved the change order.     AC22.1

CHO-MAINT-DATE         Numeric 8  (yyyymmdd)                     AC21.1  AC21.2
Element: Maintenance DaThis is the date the budget was last      AC21.3  AC21.4
                       changed.                                  AC22.1

CHO-MAINT-TIME         Numeric 6  (hhmmss)                       AC21.1  AC21.2
Element: Maintenance TiThis is the time the budget was last      AC21.3  AC21.4
                       changed.                                  AC22.1

CHO-RELEASED           Alpha 1                                   AC21.1  AC21.2
Element: Released      This flag indicates whether the change    AC21.3  AC21.4
                       order has been released. Budgets are not  AC22.1
                       changed until the change orders are
                       released.
                       Y = Released
                       N = Not Released

CHO-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     AC21.1  AC21.2
Element: Date                                                    AC21.3  AC21.4

CHO-FORMED-USED        Numeric 1                                 AC21.1  AC21.2
Element: Formed Used   This field indicates the form used to     AC21.3  AC21.4
                       define the change order. Use 1 for
                       AC21.1 (Activity Group Budget Change
                       Orders) and use 2 for AC21.2 (Activity
                       Budget Change Orders). You must maintain
                       a change order on the same form where
                       you defined it originally.
                       1 = AC21.1
                       2 = AC21.2

                         ACCHGORDER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CHOSET1   ACTIVITY-GRP                                           AC120   AC20.1
          ACTIVITY                                               AC20.2  AC20.3
          BUDGET-NBR                                             AC20.4  AC20.5
          CHG-ORDER-NBR                                          AC20.6  AC20.7
                                                                 AC21.1  AC21.2
                                                                 AC21.3  AC21.4
                                                                 AC22.1  AC300
                                                                 AC310   AC421

CHOSET2   ACTIVITY-GRP  KeyChange, Subset                        AC21.1  AC21.2
          ACTIVITY      Where (RELEASED = "N" )                  AC21.3  AC21.4
          BUDGET-NBR
          CHG-ORDER-NBR

CHOSET3   ACTIVITY-GRP  KeyChange                                AC421
          ACTIVITY
          BUDGET-NBR
          MAINT-DATE
          MAINT-TIME
          CHG-ORDER-NBR

CHOSET4   ACTIVITY-GRP
          ACTIVITY
          BUDGET-NBR
          EFFECTIVE-DATE
          CHG-ORDER-NBR

                         ACCHGORDER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            CHO-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP  (AGPSET1)

Acactivity     ACACTIVITY   Required

                            CHO-ACTIVITY         -> ACV-ACTIVITY

Acbudhdr       ACBUDHDR     Required

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

                         ACCHGORDER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acchgordx      ACCHGORDX

                            CHO-ACTIVITY-GRP     -> CHX-ACTIVITY-GRP
                            CHO-ACTIVITY         -> CHX-ACTIVITY
                            CHO-BUDGET-NBR       -> CHX-BUDGET-NBR
                            CHO-CHG-ORDER-NBR    -> CHX-CHG-ORDER-NBR
                                                    CHX-ACCT-CATEGORY
                                                    CHX-FISCAL-YEAR
                                                    CHX-PERIOD