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
AC00.1 | AC00.3 | AC200 | AC210 | AP211 | GL299 |
MX123 | MX500 | SN02.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
AGP-ACTIVITY-GRP Element: Activity Group | Alpha 15 Required key. An activity group or activity center is a group of activities 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 Project Accounting. 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 Activity Group Description | Alpha 30 (Lower Case) This is the activity group description. |
|
||
AGP-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate activity group attributes to the activity group. |
|
||
AGP-CURRENCY-TABLE Element: Currency Table | Alpha 12 This is the currency table, a table of currency relationships, currency exchange rates, and translation rates. |
|
||
AGP-CURRENCY-CODE Element: Currency Code | Alpha 5 This is the base currency code of the 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 Element: Begin Date | Numeric 8 (yyyymmdd) This is the beginning date for the 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 Element: End Date | Numeric 8 (yyyymmdd) This is the ending date for the 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 Element: Calendar Name | Alpha 12 Required. Enter the name of a calendar that defines the fiscal periods for the activity group. The calendar is defined in AC00.3 (Calendar). |
|
||
AGP-SECURITY-CD Element: Security Code | Numeric 4 You can define a security code for the 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 Element: Level Description | Alpha 12 (Lower Case) Occurs 5 Times 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 Element: Level Size | Numeric 2 Occurs 5 Times This is the level size. Variable levels 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 Element: Active Status | Alpha 1 The status of the activity group. If the activity group is inactive, no activities can be assigned to this activity group. O = Open C = Closed G = GL only |
|
||
AGP-BASE-ND Base Number of Decimals | Numeric 1 This is the number of decimal positions defined for the activity group base currency. |
|
||
AGP-ACTIVE-BUD Element: Active Budget | Numeric 3 This is the budget number for the 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 Element: Total Budget | Signed 18.2 This is the sum of the activity budgets for the activity group. This field is used in editing to determine if the sum of the activity budgets exceeds the budget cap. |
|
||
AGP-BUDGET-CAP Element: Budget Cap | Signed 18.2 This is the budget cap or budget 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 Element: Workflow Flag | Alpha 1 This field will be used in implementing Activity Management Workflow. Y = Yes N = No |
|
||
AGP-CHG-ORDER-FLAG Element: Change Order Flag | Alpha 1 This is the change order flag. 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 Element: Consolidation Flag | Alpha 1 This is the consolidation flag. Use Yes 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 = Yes N = No |
|
||
AGP-ACCT-EDIT-FLAG Element: Account Edit Flag | Alpha 1 This field determines the type of 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 Element: Budget Edit | Alpha 1 This field determines whether to edit budget amounts in the Purchase Order, Requisitions, or Accounts Payable systems. The default is no editing of budget amounts. 1 = No Edit 2 = Period Edit 3 = Annual Edit 4 = Total Edit |
|
||
AGP-BUDGET-LEVEL Element: Budget Level | Alpha 1 This flag determines which level of the 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-Acct Cat 2 = Activity Group 3 = Activity 4 = Activity-Summary Account Cat 5 = Contract Funding |
|
||
AGP-BUD-TOLERANCE Element: Budget Tolerance | Signed 5.2 This field defines what percentage over the budget, if any, is acceptable. Budget Tolerance Percent is required if budgets are edited. |
|
||
AGP-EDIT-PR Element: Edit Payroll | Alpha 1 This field indicates whether to edit employee information in Payroll. Select Yes if you want to edit employee information. Y = Yes N = No |
|
||
AGP-PR-COMMIT Element: Pr Commit | Alpha 1 Overrides the PR Commit flag on the system codes (GL01.4) to determine whether PR commitments are created during PR processing for transactions involving activities associated with the activity group. N = No Y = Yes |
|
||
AGP-EDIT-AP-EE Element: Edit AP and EE | Alpha 1 This field indicates whether to edit 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-EDIT-TRANSREL Element: Edit Transrel | Alpha 1 Y = Yes N = No |
|
||
AGP-LAST-COMMENT Element: Last Comment | Numeric 6 This is the last sequence number used for comments relating to the activity group. |
|
||
AGP-LAST-AGA-SEQ Last Activity Grp Sequence Nbr | Numeric 6 This is the last line added in AC07.1 (Account Assignment). Account assignment records are stored in the Activity GL Accounts file. |
|
||
AGP-RELEASED Element: Released | Alpha 1 This is the change order status for the activity group. Only one change order for the activity group can be unreleased. Y = Released N = Not Released |
|
||
AGP-INV-AUDIT Element: Inv Audit | Alpha 1 Y = Yes N = No |
|
||
AGP-GL-CONSOL-FL Accounting Unit Consolidate | Alpha 1 This flag indicates whether you want to create summary-level activity consolidation records in the Activity CL Accounting Unit Consolidation header and detail files. Y = Yes N = No |
|
||
AGP-RESOURCE-FL Element: All Flag | Alpha 1 Y = Yes N = No |
|
||
AGP-LEVEL-1-DESC Element: Level 1 Description | Derived This is the description for level 1. |
|
||
AGP-LEVEL-2-DESC Element: Level 2 Description | Derived This is the description for level 2. |
|
||
AGP-LEVEL-3-DESC Element: Level 3 Description | Derived This is the description for level 3. |
|
||
AGP-LEVEL-4-DESC Element: Level 4 Description | Derived This is the description for level 4. |
|
||
AGP-LEVEL-5-DESC Element: Level 5 Description | Derived This is the description for level 5. |
|
||
AGP-PURGE-STATUS Element: Purge Status | Alpha 1 This field indicates the purge status for the activity group. Use C for a complete purge. Use B to purge balances only. " " = No Purge B = Balances Only C = Complete |
|
||
AGP-OUTPUT-MEASURE Element: Intl Amt | Signed 18.2 This is the output measurement. |
|
||
AGP-OUTPUT-DESC Element: Output Desc | Alpha 30 This is the output description. |
|
||
AGP-CURR-NAME-1 Element: Curr Name 1 | Alpha 12 Type or select a name that identifies the report currency. You must define exchange rates (CU10.1) and currency relationships (CU02.1) for the report currency with the company base currency. The report currencies are additional non-base currencies that identify a company operating currency. This report currency is for reports and analysis only. The report currencies are calculated in the same manner as base currency. Transaction amounts will always be converted to the Base Currency. If you also use a report currency, amounts will convert to both the Base and Report Currency. Note: The report currency cannot be the same as the company base currency. |
|
||
AGP-CURR-CODE-1 Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||
AGP-CURR-CODE-ND-1 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
AGP-CURR-NAME-2 Element: Curr Name 2 | Alpha 12 Type or select a name that identifies the report currency. You must define exchange rates (CU10.1) and currency relationships (CU02.1) for the report currency with the company base currency. The report currencies are additional non-base currencies that identify a company operating currency. This report currency is for reports and analysis only. The report currencies are calculated in the same manner as base currency. Transaction amounts will always be converted to the Base Currency. If you also use a report currency, amounts will convert to both the Base and Report Currency. Note: The report currency cannot be the same as the company base currency. |
|
||
AGP-CURR-CODE-2 Element: Curr Code 2 | Alpha 5 Type the currency code you want to associate with the report currency name. The currency code must exist in CU01.1 (Currency Codes). |
|
||
AGP-CURR-CODE-ND-2 Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
AGP-BURDEN-CALC-FL Element: Burden Calc Fl | Alpha 1 Y = Yes N = No |
|
||
AGP-ACTIVITY-FLAG Element: Activity Flag | Alpha 1 Y = Yes N = No |
|
||
AGP-ASSET-FLAG Element: Asset Flag | Alpha 1 Y = Yes N = No |
|
||
AGP-RESC-ASSIGN-FL Element: Resc Assign Fl | Alpha 1 Y = Yes N = No |
|
||
AGP-ATTRIBUTE-FLAG Element: Attribute Flag | Alpha 1 Y = Yes N = No |
|
||
AGP-BILLING-FLAG Element: Billing Flag | Alpha 1 Y = Yes N = No |
|
||
AGP-CONTRACT-FLAG Element: Contract Flag | Alpha 1 Y = Yes N = No |
|
||
AGP-CEILING-FLAG Element: Ceiling Flag | Alpha 1 Y = Yes N = No |
|
||
AGP-BILL-CONSOL-FL Element: Bill Consol Fl | Alpha 1 Y = Yes N = No |
|
||
AGP-DATE-EDIT Element: Date Edit | Alpha 1 Used with the ACAC Edit. Valid values are posting and transaction date. P = Posting Date T = Transaction Date |
|
||
AGP-BILL-CALC-DATE Element: Bill Calc Date | Alpha 1 Used with the activity billing calculation logic. Valid values are posting and transaction date. P = Posting Date T = Transaction Date |
|
||
AGP-TE-ACCT-DF-FL Element: Te Acct Df Fl | Alpha 1 A = Activity Expense Account E = Employee Expense Account |
|
||
AGP-TE-ACCT-CAT-DF Element: Te Acct Cat Df | Alpha 1 A = Activity Acct Category E = Employee Acct Category |
|
||
AGP-ACCOUNT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||
AGP-SUB-ACCOUNT Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||
AGP-GL-CODE Element: Gl Code | Alpha 4 |
|
||
AGP-EXPENSE-FL Element: Expense Fl | Alpha 1 |
|
||
AGP-ASSET-EDIT Element: Asset Edit | Alpha 1 Y = Yes N = No |
|
||
AGP-POP-FLAG Element: Pop Flag | Alpha 1 Period of Performance flag. Will indicate the use of period of performance. This will be edited when transactions are added. N = No Y = Yes |
|
||
AGP-BRDN-DATE-EDIT Element: Brdn Date Edit | Alpha 1 Determines whether burden rates are based on the ACTRANS transaction date or posting date. P = Posting Date T = Transaction Date |
|
||
AGP-STRUCTURE Element: Structure | Alpha 15 The name of the category structure. This represents the category structure assigned to the activity group. |
|
||
AGP-CAT-CONSOL-FL Element: Consol Flag | Alpha 1 Y = Yes N = No |
|
||
AGP-BEG-BAL-YEAR Element: Year | Numeric 4 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AGPSET1 |
ACTIVITY-GRP |
|
|||||||||||||||||
AGPSET2 |
OBJ-ID |
|
| ||||||||||||||||
AGPSET3 |
STRUCTURE ACTIVITY-GRP |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Acaddlcntr | ACADDLCNTR |
Not Required
| |||||||||
Acbudhdr Actv | ACBUDHDR |
Not Required
| |||||||||
Cucodes | CUCODES |
Required
| |||||||||
Curr 1 | CUCODES |
Not Required
| |||||||||
Curr 2 | CUCODES |
Not Required
| |||||||||
Cutable | CUTABLE |
Not Required
| |||||||||
Structure | STRUCTURE |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acactivity | ACACTIVITY |
| ||||||||||||||||||||||||
Acactivity Lvl | ACACTIVITY |
| ||||||||||||||||||||||||
Acasnrole | ACASNROLE |
| ||||||||||||||||||||||||
Acassign | ACASSIGN |
| ||||||||||||||||||||||||
Acbrdndtl | ACBRDNDTL |
| ||||||||||||||||||||||||
Acbuddtl Actv | ACBUDDTL |
| ||||||||||||||||||||||||
Acbudhdr | ACBUDHDR |
| ||||||||||||||||||||||||
Accal | ACCAL |
| ||||||||||||||||||||||||
Accatsum | ACCATSUM |
| ||||||||||||||||||||||||
Accatsumx | ACCATSUMX |
| ||||||||||||||||||||||||
Acchgorder | ACCHGORDER |
| ||||||||||||||||||||||||
Accommit | ACCOMMIT |
| ||||||||||||||||||||||||
Acconsol | ACCONSOL |
| ||||||||||||||||||||||||
Acconsol Bud | ACCONSOL |
| ||||||||||||||||||||||||
Acglacct | ACGLACCT |
| ||||||||||||||||||||||||
Acgrpmxval | ACGRPMXVAL |
| ||||||||||||||||||||||||
Acgrpmxvdt | ACGRPMXVDT |
| ||||||||||||||||||||||||
Acprdperf | ACPRDPERF |
| ||||||||||||||||||||||||
Acreshist | ACRESHIST |
| ||||||||||||||||||||||||
Actotbal Base | ACTOTBAL |
| ||||||||||||||||||||||||
Actotbal Cur1 | ACTOTBAL |
| ||||||||||||||||||||||||
Actotbal Cur2 | ACTOTBAL |
| ||||||||||||||||||||||||
Aracpivot | ARACPIVOT |
| ||||||||||||||||||||||||
Histastasgn | ACRESHIST |
| ||||||||||||||||||||||||
Histastrole | ACRESHIST |
| ||||||||||||||||||||||||
Histempasgn | ACRESHIST |
| ||||||||||||||||||||||||
Histemprole | ACRESHIST |
| ||||||||||||||||||||||||
Histeqpasgn | ACRESHIST |
| ||||||||||||||||||||||||
Histeqprole | ACRESHIST |
| ||||||||||||||||||||||||
Histperasgn | ACRESHIST |
| ||||||||||||||||||||||||
Histperrole | ACRESHIST |
| ||||||||||||||||||||||||
Histvenasgn | ACRESHIST |
| ||||||||||||||||||||||||
Histvenrole | ACRESHIST |
| ||||||||||||||||||||||||
Perfhist | ACPRDPERF |
|
All trademarks and registered trademarks are the property of their
respective owners.