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