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 AC720 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
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
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
AGA-ALL-ACT-FLAG Alpha 1 AC07.1 AC105
All Activities Flag Use the All Activities flag to indicate AC110
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
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
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
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
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
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 ACAC.1
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 AC06.1 AC07.1
ACTIVITY AC10.1 AC105
ACCT-CATEGORY AC120 AC207
SEQ-NUMBER AC300 AC310
AC720 ACAC.1
AGASET2 ACTIVITY-GRP KeyChange AC07.1 AC105
ACTIVITY AC110 AC207
ACCT-CATEGORY ACAC.1
ACCOUNT-GRP
ACCT-FIELD
BEG-VAL
SEQ-NUMBER
AGASET3 ACTIVITY-GRP KeyChange AC07.1 AC110
ACTIVITY AC207
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
|
