Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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

AC207     ACAC.1

UPDATED BY

AC07.1    AC105     AC110     AC120     AC300     AC310
AC06.1    AC10.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

AGA-ACTIVITY         Alpha 15                                    AC07.1  AC105
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
Account Category     Required key. This is the account           AC110   AC120
                     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
Sequence Number      Key field. This is the sequence number.     AC110   AC120

AGA-ALL-ACT-FLAG     Alpha 1                                     AC07.1  AC105
All Activities Flag  Use the All Activities flag to indicate     AC110   AC120
                     whether an account category applies to
                     all activities. If the account category
                     applies to only one activity, enter the
                     activity name in the Activity field, and
                     use the No option for this flag.

                     Yes indicates that the account category
                     applies to all activities. No indicates
                     that the account category does not apply
                     to all activities.

AGA-ALL-ACCT-CAT     Alpha 1                                     AC07.1  AC105
All Account          Use the All Account Categories flag to      AC110   AC120
Categories           indicate whether all account categories
                     are assigned to an activity or
                     activities in the activity group. If all
                     account categories do not apply to an
                     activity, enter the name of the account
                     category that does apply in the Account
                     Category field, and use the No option
                     for this flag.

                     Yes indicates that all account
                     categories apply to the activity or
                     activities in the activity group. No
                     indicates that not all account
                     categories apply to an activity or
                     activities in the activity group.

AGA-ACCT-FIELD       Numeric 1                                   AC07.1  AC105
Account Field        Required. This field indicates the          AC110   AC120
                     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      AC110   AC120
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
Beginning Value      Required. Enter a beginning value that      AC110   AC120
                     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
Ending Value         Optional. An ending value is only           AC110   AC120
                     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
Account Group        Required. Use the account group to          AC110   AC120
                     group Account field definitions into        ACAC.1
                     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                                           AC06.1  AC07.1
          ACTIVITY                                               AC10.1  AC105
          ACCT-CATEGORY                                          AC110   AC120
          SEQ-NUMBER                                             AC207   AC300
                                                                 AC310   ACAC.1

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

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

AGASET4   ACTIVITY      KeyChange                                AC207
          ACTIVITY-GRP
          ACCT-CATEGORY
          ACCOUNT-GRP
          ACCT-FIELD
          BEG-VAL
          SEQ-NUMBER

AGASET5   ACCT-CATEGORY KeyChange                                AC207
          ACTIVITY-GRP
          ACTIVITY
          ACCOUNT-GRP
          ACCT-FIELD
          BEG-VAL
          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