Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACGLACCT


                             ACGLACCT FILE

                          Activity GL Accounts

This file contains valid general ledger accounts in the Activity Management
system. The file contains activity group, activity, account category, the
account field, and account group, as well as beginning and ending values and
an Include/Exclude flag.

Activity Management system general ledger account records are created by
AC07.1 (Account Assignment).

All Lawson subsystems verify accounts in this file if general ledger account
editing in Activity Management is specified.

This file can be listed by running AC207 (Account Assignment Listing).

REFERENCED BY

ACAC.1    AC207

UPDATED BY

AC07.1    AC105     AC110     AC120     AC300     AC310
AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AGA-ACTIVITY-GRP       Alpha 15                                  AC07.1  AC105
Element: Activity GroupKey field. This is the activity group     AC110   AC120
                       for the general ledger accounts.

AGA-ACTIVITY           Alpha 15                                  AC07.1  AC105
Element: Activity      Required key. This is the activity for    AC110   AC120
                       the general ledger accounts.

                       The All Activities flag is valid. Use
                       All to signify all activities in the
                       activity group.

AGA-ACCT-CATEGORY      Alpha 5                                   AC07.1  AC105
Element: Account CategoRequired key. This is the account
                       category for the general ledger
                       accounts.

                       The All Account Categories flag is
                       valid. Use All to signify all account
                       categories for the activity group and
                       activity.

AGA-SEQ-NUMBER         Numeric 6                                 AC07.1  AC105
Element: Sequence NumbeKey field. This is the sequence number.

AGA-ACCT-FIELD         Numeric 1                                 AC07.1  AC105
Element: Account Field Required. This field indicates the
                       account field you are defining values
                       for.
                       1 = Company
                       2 = Accounting Unit
                       3 = Account
                       4 = Sub Account

AGA-INC-EXC-FLAG       Alpha 1                                   AC07.1  AC105
Include / Exclude      Required. Select Include or Exclude to
Flag                   indicate whether the value or value
                       range is included in or excluded from an
                       account. List values and ranges to be
                       excluded first.
                       I = Include
                       E = Exclude

AGA-BEG-VAL            Alpha 15                                  AC07.1  AC105
Element: Beginning ValuRequired. Enter a beginning value that
                       is valid for the account field you are
                       defining. For example, if you select
                       Accounting Unit in the Account field,
                       the value in this field must be a valid
                       accounting unit.

AGA-END-VAL            Alpha 15                                  AC07.1  AC105
Element: Ending Value  Optional. An ending value is only
                       required if you define a range of more
                       than one value. You can enter an ending
                       value that is valid for the account
                       field you are defining. For example, if
                       you select Accounting Unit in the
                       Account field, the value in this field
                       must be a valid accounting unit.

AGA-ACCOUNT-GRP        Alpha 1                                   AC07.1  AC105
Element: Account Group Required. Use the account group to
                       group Account field definitions into
                       groups of values and ranges that define
                       conditions. Within an account group, all
                       value and range criteria associated with
                       the group must be met for the condition.


                       An account only needs to meet the value
                       and range criteria of one account group
                       (although the account can meet criteria
                       for more than one group).

                         ACGLACCT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AGASET1   ACTIVITY-GRP                                           AC07.1  AC10.1
          ACTIVITY                                               AC110   AC120
          ACCT-CATEGORY                                          AC300   AC310
          SEQ-NUMBER                                             ACAC.1

AGASET2   ACTIVITY-GRP  KeyChange                                AC07.1  AC105
          ACTIVITY                                               AC207   ACAC.1
          ACCT-CATEGORY
          ACCOUNT-GRP
          ACCT-FIELD
          BEG-VAL
          SEQ-NUMBER

AGASET3   ACTIVITY-GRP  KeyChange                                AC07.1  AC105
          ACTIVITY
          ACCT-CATEGORY
          ACCOUNT-GRP
          ACCT-FIELD
          INC-EXC-FLAG
          SEQ-NUMBER

                         ACGLACCT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            AGA-ACTIVITY-GRP    -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Not Required

                            AGA-ACTIVITY-GRP    -> ACV-ACTIVITY-GRP
                            AGA-ACTIVITY        -> ACV-ACTIVITY