ACGLCONSLX FILE AC GL Acct Unit Consol Detail This detail file maintains summary-level activity consolidation balances by account category, company, accounting unit, year, and period in the activity group base currency. Whether this file is updated depends on the value in the Accounting Unit Detail field on AC00.1 (Activity Group), which is stored in the Activity Group file. This file is updated by AC191 (AC Accounting Unit Posting). REFERENCED BY AC94.1 AC94.2 AC94.3 AC94.4 AC94.5 AC94.6 UPDATED BY AC120 AC191 AC300 AC310 AC580 AC980 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY GCX-FISCAL-YEAR Numeric 4 AC120 AC191 Year Required key. This is the fiscal year. AC580 AC980 GCX-ACTIVITY-GRP Alpha 15 AC120 AC191 Activity Group Required key. An activity group or AC580 AC980 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 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. GCX-ACTIVITY Alpha 15 AC120 AC191 Activity Required key. Activities are the AC580 AC980 processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. Activities and cost object activities are used synonymously in the Lawson Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. Activities are grouped or organized by activity levels. There are two types of activities: "posting allowed" and "summary only." Use posting level activities to budget and maintain all posted transactions. Summary activities or macro activities combine information and balances from lower level activities for reporting and inquiries. GCX-ACCT-CATEGORY Alpha 5 AC120 AC191 Account Category Required key. Account categories are AC580 AC980 groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Lawson Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. GCX-COMPANY Numeric 4 AC120 AC191 Company Required key. This is the company AC580 AC980 number the transaction was posted to in the general ledger. GCX-ACCT-UNIT Alpha 15 AC120 AC191 Accounting Unit Required key. This is the accounting AC580 AC980 unit the transaction was posted to in the general ledger. An accounting unit is a shorthand notation representing the variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit. GCX-PERIOD Numeric 2 AC120 AC191 Period Required key. This is the fiscal AC580 AC980 period. GCX-AMOUNT Currency 15.2 AC120 AC191 Amount This is the period amount balance for AC580 AC980 the current fiscal year. GCX-UNIT Signed 15.2 AC120 AC191 Units This is the period units balance for AC580 AC980 the current fiscal year. ACGLCONSLX FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN GCXSET1 FISCAL-YEAR AC120 AC191 ACTIVITY-GRP AC580 AC94.1 ACTIVITY AC94.2 AC94.3 ACCT-CATEGORY AC94.4 AC94.5 COMPANY AC94.6 AC980 ACCT-UNIT PERIOD GCXSET2 ACTIVITY-GRP AC120 AC300 ACTIVITY AC310 AC580 ACCT-CATEGORY COMPANY ACCT-UNIT FISCAL-YEAR PERIOD ACGLCONSLX FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Acacctcat ACACCTCAT Required GCX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY Acactgrp ACACTGRP Required GCX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP Acactivity ACACTIVITY Required GCX-ACTIVITY -> ACV-ACTIVITY Acglconsl ACGLCONSL Required GCX-ACTIVITY-GRP -> GCO-ACTIVITY-GRP GCX-ACTIVITY -> GCO-ACTIVITY GCX-ACCT-CATEGORY -> GCO-ACCT-CATEGORY GCX-COMPANY -> GCO-COMPANY GCX-ACCT-UNIT -> GCO-ACCT-UNIT GCX-FISCAL-YEAR -> GCO-FISCAL-YEAR Glnames GLNAMES Not Required GCX-COMPANY -> GLN-COMPANY GCX-ACCT-UNIT -> GLN-ACCT-UNIT Glsystem GLSYSTEM Not Required GCX-COMPANY -> GLS-COMPANY |