|
|
ACACTGRP FILE
Activity Group
This file contains information from AC00.1 (Activity Group) about activity
group set up and definitions. The activity group is the highest reporting
level in the Activity Management system. This file also includes information
about the activity processing and reporting structure (work breakdown
structure) and the appearance and function of the activity group in
the Activity Management system.
REFERENCED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC06.1
AC08.2 AC10.1 AC10.3 AC10.5 AC11.1 AC112
AC115 AC13.1 AC130 AC14.1 AC15.1 AC15.2
AC15.4 AC16.1 AC160 AC165 AC170 AC176
AC190 AC191 AC196 AC200 AC203 AC206
AC207 AC208 AC21.1 AC21.2 AC21.3 AC210
AC214 AC215 AC216 AC220 AC225 AC240
AC25.1 AC255 AC256 AC265 AC27.1 AC290
AC295 AC297 AC30.2 AC30.3 AC32.1 AC400
AC401 AC410 AC412 AC415 AC416 AC420
AC421 AC440 AC45.1 AC45.2 AC450 AC460
AC470 AC471 AC472 AC473 AC480 AC490
AC50.1 AC500 AC510 AC520 AC530 AC54.1
AC540 AC55.1 AC65.1 AC65.2 AC70.1 AC70.3
AC70.4 AC79.1 AC800 AC87.1 AC90.1 AC90.2
AC94.1 AC94.2 AC94.3 AC94.4 AC94.5 AC94.6
AC95.1 AC95.2 AC952 AC96.1 AC97.1 AC97.2
ACAC.1 ACBA.1 ACDL.1 AP125 AP126 AP170
AP193 AP225 AP226 AP25.1 AP25.2 AP26.1
AP30.2 AP30.4 AP32.2 AP520 AP95.3 AP981
AR115 AR124 AR190 AR20.1 AR21.1 AR21.2
AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4
AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570
AR575 AR580 BL120 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 BL940 BN150 CB10.1 CB180 CB191
CB20.1 CB30.1 CB80.1 CB980 EE135 EE35.1
EE35.2 EE520 GL199 DR100 IC130 IC141
IC142 IC83.1 IFGT.1 IN20.1 MA40.1 MA41.4
MA41.6 MA43.3 MA43.4 MA520 MA530 MA540
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE113 OE114 OE129 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE810 OE830 OE920 OE950
PO100 PO135 PO180 PO20.1 PO21.1 PO21.2
PO21.3 PO21.5 PO21.6 PO22.1 PO22.2 PO22.3
PO25.1 PO25.2 PO25.4 PO26.1 PO28.6 PO30.1
PO31.1 PO32.1 PO33.1 PO34.1 PO35.1 PO530
PO821 PO990 PR128 PR131 PR132 PR134
PR136 PR137 PR140 PR150 PR195 PR199
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR37.1 PR38.1 PR45.1 PR530 PR80.1
PR82.1 PR85.1 PRSA.1 UK102 UK330 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1
RQ20.3 RQ20.4 RQ35.1 RQ500 RQ990 UK120
WH130 WH132 WH190 WH20.2 WH20.7 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WO132 WO140
UPDATED BY
AC00.1 AC00.3 AC01.1 AC07.1 AC105 AC110
AC120 AC121 AC123 AC127 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC22.1 AC300
AC310 AC40.1 AC41.1 AC42.1 AC580 AC701
AC730 AC950 AC951 AC959 AC980
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGP-ACTIVITY-GRP Alpha 15 AC00.1 AC110
Activity Group Required key. An activity group or AC730 AC950
activity center is a group of activities AC951
related by process or function. An
activity group is the highest entity for
which you can inquire and report on
costs, revenues, and budgets in the
Activity Management system.
An activity group is set up to budget
for, report on, process, and store
information common to one or more
activities. You must set up an activity
group before you can set up activities,
budgets, transactions, and inquiries. To
collect costs and revenues, at least one
activity must be linked to an activity
group.
AGP-DESCRIPTION Alpha 30 (Lower Case) AC00.1 AC110
Activity Group This is the activity group description. AC730 AC950
Description
AGP-CURRENCY-TABLE Alpha 12 AC00.1 AC730
Currency Table This is the currency table, a table of AC950
currency relationships, currency
exchange rates, and translation rates.
AGP-CURRENCY-CODE Alpha 5 AC00.1 AC730
Currency Code This is the base currency code of the AC950
activity group. You define the base
currency code in AC00.1 (Activity
Group). Consolidation amounts are
reported in activity group base
currency.
AGP-BEGIN-DATE Numeric 8 (yyyymmdd) AC00.1 AC730
Begin Date This is the beginning date for the AC950
activity group. If you leave this field
blank, the activity group date range
defaults to the activity date range.
Activity dates cannot be outside the
activity group date range.
AGP-END-DATE Numeric 8 (yyyymmdd) AC00.1 AC730
End Date This is the ending date for the AC950
activity group. If you leave this field
blank, the activity group date range
defaults to the activity date range.
The activity date range cannot be
outside the activity group date range.
AGP-CALENDAR-NAME Alpha 12 AC00.1 AC730
Calendar Name Required. Enter the name of a calendar AC950
that defines the fiscal periods for the
activity group. The calendar is defined
in AC00.3 (Calendar).
AGP-SECURITY-CD Numeric 4 AC00.1 AC730
Security Code You can define a security code for the AC950
activity group. The security code is
used with the Lawson Security module.
Security in Activity Management is
established by security code and
activity.
AGP-LEVEL-DESC Alpha 12 (Lower Case) AC00.1 AC730
Level Description Occurs 5 Times AC950
This is the level description. Levels
define an addressing system that
organizes activities into a reporting
hierarchy. Level names are defined for
an activity group and should be able to
be used across all activities in an
activity group. Levels facilitate rollup
or consolidation of budgets, costs, and
revenues from activities at lower levels
to macro activities at a higher level
within the hierarchy.
AGP-LEVEL-SIZE Numeric 2 Occurs 5 Times AC00.1 AC730
Level Size This is the level size. Variable levels AC950
make up a hierarchical numbering scheme
that allows detail to be aggregated or
"rolled-up" in summarized form. Five
levels are available in the Activity
Management system. No one level can be
greater than 15; all of the levels taken
together cannot exceed 30.
AGP-ACTIVE-STATUS Alpha 1 AC00.1 AC00.3
Active Status The status of the activity group. If AC730 AC950
the activity group is inactive, no AC951
activities can be assigned to this
activity group.
O = Open
C = Closed
G = GL only
AGP-BASE-ND Numeric 1 AC00.1 AC730
Base Number of This is the number of decimal positions AC950
Decimals defined for the activity group base
currency.
AGP-ACTIVE-BUD Numeric 3 AC110 AC20.5
Active Budget This is the budget number for the AC730
activity group's active budget. The
active budget is the default budget used
for inquiries and reporting. It is also
used for calculating percentage complete
in AC65.1 (Account Category Percent of
Completion). You can change the activity
group active budget in AC20.4 (New
Activity Group Budget).
AGP-TOTAL-BUDGET Signed 15.2 AC00.1 AC110
Total Budget This is the sum of the activity budgets AC120 AC121
for the activity group. This field is AC123 AC127
used in editing to determine if the sum AC20.1 AC20.2
of the activity budgets exceeds the AC20.3 AC20.4
budget cap. AC20.6 AC22.1
AC580 AC701
AC730 AC950
AC980
AGP-BUDGET-CAP Signed 15.2 AC00.1 AC730
Budget Cap This is the budget cap or budget AC950
maximum for the activity group. It is
used in editing budget programs and in
determining if the sum of the activity
budgets exceeds the budget cap. If the
sum of the activity budgets exceeds the
budget cap, a warning message displays.
AGP-WORKFLOW-FLAG Alpha 1 AC00.1 AC730
Workflow Flag This field will be used in implementing AC950
Activity Management Workflow.
Y = Yes
N = No
AGP-CHG-ORDER-FLAG Alpha 1 AC00.1 AC730
Change Order Flag This is the change order flag. AC950
Yes = Change order records are kept on
file to provide an audit trail of budget
change order revisions.
No = Change order detail records are
deleted after the change order is
released.
AGP-CONSOL-FLAG Alpha 1 AC00.1 AC730
Consolidation Flag This is the consolidation flag. Use Yes AC950
to create consolidation files for
actuals and budgets at the activity
level within the activity group. Use No
if you do not want to create
consolidation files at the activity
level. Consolidation files keep
consolidated balances for summary level
activities and for reporting summary
balances. Consolidation records are
always kept at the activity group level.
Y = Create ACCONSOL Records
N = Do Not Create ACCONSOL Records
AGP-ACCT-EDIT-FLAG Alpha 1 AC00.1 AC730
Account Edit Flag This field determines the type of AC950 AC951
activity editing to be done in the
Lawson subsystems. 1 is valid only for
GL-only activity groups.
Valid values are
1 = Activity
2 = Activity and Account Category
3 = Activity, Account Category, and
Activity Account (Soft Errors)
4 = Activity, Account Category, and
Activity Account (Hard Errors)
AGP-BUDGET-EDIT Alpha 1 AC00.1 AC730
Budget Edit This field determines whether to edit AC950
budget amounts in the Purchase Order,
Requisitions, or Accounts Payable
systems.
The default is no editing of budget
amounts.
1 = No Budget Amount Edit
2 = Period Budget Amount
3 = Edit Annual Budget Amount
4 = Edit Total Budget Amount
AGP-BUDGET-LEVEL Alpha 1 AC00.1 AC730
Budget Level This flag determines which level of the AC950
budget to edit in Purchase Order,
Requisitions, or Accounts Payable: the
activity (posting) or the activity group
(summary) level.
This field is required if budgets are
edited.
1 = Activity and Acct Category
2 = Activity Group
3 = Activity
AGP-BUD-TOLERANCE Signed 5.2 AC00.1 AC730
Budget Tolerance This field defines what percentage over AC950
the budget, if any, is acceptable.
Budget Tolerance Percent is required if
budgets are edited.
AGP-EDIT-PR Alpha 1 AC00.1 AC730
Edit Payroll This field indicates whether to edit AC950
employee information in Payroll. Select
Yes if you want to edit employee
information.
1 = Yes-Commitments
2 = Yes-No Commitments
3 = No-Commitments
4 = No-No Commitments
AGP-EDIT-AP-EE Alpha 1 AC00.1 AC730
Edit AP and EE This field indicates whether to edit AC950
vendor information in Accounts Payable
(AP) and Employee Expense (EE). Select
Yes if you want to edit vendor
information. The default is No.
Y = Yes
N = No
AGP-LAST-COMMENT Numeric 6 AC01.1 AC110
Last Comment This is the last sequence number used AC120 AC580
for comments relating to the activity AC730 AC950
group. AC980
AGP-FRINGE-PCT Signed 5.2 AC00.1 AC730
Fringe Percentage Enter a percentage by which to multiply AC950
Payroll paywage amounts for commitment
reporting. Since fringe benefits are not
known at the time Payroll time records
(gross amounts) update commitments, you
can enter a fringe percentage to
multiple Payroll transactions by to get
a more accurate commitment amount.
AGP-LAST-AGA-SEQ Numeric 6 AC07.1 AC105
Last Activity Grp This is the last line added in AC07.1 AC110 AC120
Sequence Nbr (Account Assignment). Account assignment AC730 AC959
records are stored in the Activity GL
Accounts file.
AGP-LAST-BATCH Numeric 6 AC110 AC310
Last Batch This is the last batch of transactions AC40.1 AC41.1
processed for the activity group using AC42.1
AC40.1 (Journal Entry).
AGP-RELEASED Alpha 1 AC701 AC730
Released This is the change order status for the AC950
activity group. Only one change order
for the activity group can be
unreleased.
Y = Released
N = Not Released
AGP-REVENUE-LEVEL Numeric 1 AC00.1 AC950
Revenue Level This is the level at which revenue
recognition takes place for all revenue-
recognizing activities in the activity
group. Use AC14.1 (Activity Revenue) to
recognize revenue.
1 = Level One
2 = Level Two
3 = Level Three
4 = Level Four
5 = Level Five
AGP-BEGIN-YR Derived
Begin Year This is the year in which activities in
the activity group begin.
AGP-END-YR Derived
End Year This is the year in which the
activities in the activity group end.
AGP-GL-CONSOL-FL Alpha 1 AC00.1 AC730
Accounting Unit This flag indicates whether you want to AC950
Consolidate create summary-level activity
consolidation records in the Activity CL
Accounting Unit Consolidation header and
detail files.
Y = Yes
N = No
AGP-LEVEL-1-DESC Derived
Level 1 Description This is the description for level 1.
AGP-LEVEL-2-DESC Derived
Level 2 Description This is the description for level 2.
AGP-LEVEL-3-DESC Derived
Level 3 Description This is the description for level 3.
AGP-LEVEL-4-DESC Derived
Level 4 Description This is the description for level 4.
AGP-LEVEL-5-DESC Derived
Level 5 Description This is the description for level 5.
AGP-PURGE-STATUS Alpha 1 AC00.3 AC300
Purge Status This field indicates the purge status AC730
for the activity group. Use C for a
complete purge. Use B to purge balances
only.
C = Complete
B = Balances Only
AGP-OUTPUT-MEASURE Signed 15.2 AC00.1 AC730
Output Measure This is the output measurement.
AGP-OUTPUT-DESC Alpha 30 AC00.1 AC730
Output Desc This is the output description.
ACACTGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGPSET1 ACTIVITY-GRP AC00.1 AC00.3
AC01.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC06.1 AC07.1
AC08.2 AC10.1
AC10.3 AC10.5
AC105 AC11.1
AC110 AC112
AC115 AC120
AC121 AC123
AC127 AC13.1
AC130 AC14.1
AC15.1 AC15.2
AC15.4 AC16.1
...
ACACTGRP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acbudhdr Actv ACBUDHDR Not Required
AGP-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
Spaces -> BDH-ACTIVITY
AGP-ACTIVE-BUD -> BDH-BUDGET-NBR
Cucodes CUCODES Required
AGP-CURRENCY-CODE -> CUC-CURRENCY-CODE
Cutable CUTABLE Required
AGP-CURRENCY-TABLE -> CTB-CURRENCY-TABLE
ACACTGRP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcatx ACACCTCATX
AGP-ACTIVITY-GRP -> AXX-ACTIVITY-GRP
AXX-ACCT-CATEGORY
AXX-ACTIVITY
Acactivity ACACTIVITY
AGP-ACTIVITY-GRP -> ACV-ACTIVITY-GRP
ACV-ACTIVITY
Acactivity Lvl ACACTIVITY
AGP-ACTIVITY-GRP -> ACV-ACTIVITY-GRP
ACV-VAR-LEVELS
Acassign ACASSIGN
AGP-ACTIVITY-GRP -> AAN-ACTIVITY-GRP
Spaces -> AAN-ACTIVITY
AAN-RESOURCE-TYPE
AAN-RESOURCE-CODE
Acbuddtl Actv ACBUDDTL
AGP-ACTIVITY-GRP -> BDT-ACTIVITY-GRP
Spaces -> BDT-ACTIVITY
AGP-ACTIVE-BUD -> BDT-BUDGET-NBR
BDT-ACCT-CATEGORY
BDT-FISCAL-YEAR
Acbudhdr ACBUDHDR
AGP-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
Spaces -> BDH-ACTIVITY
BDH-BUDGET-NBR
Accal ACCAL
AGP-CALENDAR-NAME -> CDH-CALENDAR-NAME
CDH-FISCAL-YEAR
Acchgorder ACCHGORDER
AGP-ACTIVITY-GRP -> CHO-ACTIVITY-GRP
Spaces -> CHO-ACTIVITY
AGP-ACTIVE-BUD -> CHO-BUDGET-NBR
CHO-CHG-ORDER-NBR
Accomments ACCOMMENTS
AGP-ACTIVITY-GRP -> CMN-ACTIVITY-GRP
Spaces -> CMN-ACTIVITY
CMN-COMMENT-TYP
CMN-SEQ-NBR
Accommit ACCOMMIT
AGP-ACTIVITY-GRP -> MIT-ACTIVITY-GRP
MIT-ACTIVITY
MIT-ACCT-CATEGORY
MIT-FISCAL-YEAR
MIT-PERIOD
MIT-SYSTEM
MIT-COMPANY
MIT-CURRENCY-CODE
Acconsol ACCONSOL
AGP-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
Spaces -> CSL-ACTIVITY
CSL-ACCT-CATEGORY
CSL-BUDGET-NBR
CSL-FISCAL-YEAR
Acconsol Bud ACCONSOL
AGP-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
Spaces -> CSL-ACTIVITY
CSL-ACCT-CATEGORY
CSL-BUDGET-NBR
CSL-FISCAL-YEAR
Acglacct ACGLACCT
AGP-ACTIVITY-GRP -> AGA-ACTIVITY-GRP
Spaces -> AGA-ACTIVITY
AGA-ACCT-CATEGORY
AGA-SEQ-NUMBER
Acglconsl ACGLCONSL
AGP-ACTIVITY-GRP -> GCO-ACTIVITY-GRP
GCO-ACTIVITY
GCO-ACCT-CATEGORY
GCO-COMPANY
GCO-ACCT-UNIT
GCO-FISCAL-YEAR
|