ACACCTCATX FILE Account Category Detail This file includes detailed information on account categories from AC06.1 (Account Category Assignment). It includes the activity group and activity to which each account category is assigned; the account category class, defined in AC06.2 (Account Category Class); as well as All Activities, Billable, Capitalization, and Error Suspense Account Category flags, and a mark-up percentage. REFERENCED BY AC07.1 AC121 AC123 AC127 AC130 AC14.1 AC15.1 AC15.4 AC16.1 AC16.2 AC16.3 AC16.4 AC16.5 AC160 AC165 AC170 AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC206 AC22.1 AC27.1 AC295 AC297 AC30.1 AC30.2 AC30.3 AC30.4 AC32.1 AC40.1 AC41.1 AC42.1 AC473 AC480 AC50.1 AC500 AC530 AC54.1 AC540 AC65.1 AC65.2 AC70.1 AC70.3 AC90.1 AC90.2 AC95.1 AC95.2 AC97.1 AC97.2 ACAC.1 GL199 AC00.1 AC400 AC410 AC420 AC460 AC05.1 HCAC.1 HAXX.1 AC196 UPDATED BY AC06.1 AC10.1 AC105 AC110 AC120 AC300 AC310 AC730 AC952 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY AXX-ACTIVITY-GRP Alpha 15 AC06.1 AC105 Activity Group Required. This is the activity group AC110 AC120 for the account category. AC730 AC952 AXX-ACTIVITY Alpha 15 AC06.1 AC105 Activity Required. This is the activity for the AC110 AC120 account category. AC730 AC952 If all activities within the activity group have the same account categories, use Yes in the All Activities field. AXX-ACCT-CATEGORY Alpha 5 AC06.1 AC105 Account Category Account categories are groupings of AC110 AC120 costs, revenues, or a combination of AC730 AC952 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. The error suspense account category is automatically assigned to all activities. AXX-ALL-ACT-FLAG Alpha 1 AC06.1 AC105 All Activities Flag Use Yes to assign account categories to AC110 AC120 all activities in the activity group. AC730 AC952 With this option, the Activity field must be blank. Use No to assign account categories not to all activities in the activity group but only to a specific activity. This is the default. With this option, the Activity field must contain the name of a particular activity. AXX-BILLABLE-FLAG Alpha 1 AC06.1 AC105 Billable Flag This flag indicates whether an account AC110 AC120 category is billable. The default is No. AC730 AC952 Y = Billable N = Non-billable AXX-CAPITAL-FLAG Alpha 1 AC06.1 AC105 Capitalization Flag This flag indicates whether an account AC110 AC120 category is to be capitalized. AC730 AC952 Y = Yes N = No AXX-ACCT-CAT-CLASS Alpha 3 AC06.1 AC105 Account Category Optional. This must be a valid account AC110 AC120 Class category class. Account category classes AC473 AC730 are defined in AC06.2 (Account Category AC952 Class). AXX-ES-ACCT-CAT-FL Alpha 1 AC06.1 AC105 Error Suspense This field defines the error suspense AC110 AC120 Accnt Cat Flag account category. Only one account AC730 AC952 category can be flagged as error suspense using Yes. Y = Yes N = No AXX-MARK-UP-PCT Signed 5.2 AC06.1 AC105 Mark-up Percent This field indicates the percentage of AC110 AC120 markup for billing. If an account AC730 AC952 category is billable, a mark-up percentage can be established. A rate schedule is for labor transactions only. Mark-up percentages will increase the amount by the percent entered. ACACCTCATX FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN AXXSET1 ACTIVITY-GRP AC06.1 AC07.1 ACTIVITY AC10.1 AC10.3 ACCT-CATEGORY AC105 AC110 AC120 AC121 AC123 AC127 AC130 AC14.1 AC15.1 AC15.4 AC16.1 AC16.2 AC16.3 AC16.4 AC16.5 AC160 AC165 AC170 AC190 AC20.1 AC20.2 AC20.3 AC20.4 AC206 AC22.1 AC27.1 ... AXXSET2 ACTIVITY-GRP AC00.1 AC20.4 ACCT-CATEGORY AC206 AC295 ACTIVITY AC400 AC410 AC420 AC460 AXXSET3 ACTIVITY-GRP Subset ACAC.1 ACCT-CATEGORY Where (ALL-ACT-FLAG = "Y" ) ACTIVITY AXXSET4 ACCT-CATEGORY AC05.1 ACTIVITY-GRP ACTIVITY AXXSET5 ACCT-CAT-CLASSKeyChange AC06.2 ACTIVITY-GRP ACTIVITY ACCT-CATEGORY AXXSET6 ACTIVITY AC10.1 HCAC.1 ACTIVITY-GRP HAXX.1 ACCT-CATEGORY AXXSET7 ACCT-CAT-CLASSKeyChange ACCT-CATEGORY ACTIVITY ACTIVITY-GRP AXXSET8 ACTIVITY-GRP Subset AC06.1 AC196 ACTIVITY Where (ES-ACCT-CAT-FL != "Y" ) ACCT-CATEGORY ACACCTCATX FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Acacctcat ACACCTCAT Required AXX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY Acacctclss ACACCTCLSS Not Required AXX-ACCT-CAT-CLASS -> AXA-ACCT-CAT-CLASS Acactgrp ACACTGRP Required AXX-ACTIVITY-GRP -> AGP-ACTIVITY-GRP Acactivity ACACTIVITY Not Required AXX-ACTIVITY -> ACV-ACTIVITY Acamcode ACAMCODE Not Required AXX-ACTIVITY -> MCD-ACTIVITY AXX-ACCT-CATEGORY -> MCD-ACCT-CATEGORY Acbudhdr ACBUDHDR Not Required AXX-ACTIVITY-GRP -> BDH-ACTIVITY-GRP AXX-ACTIVITY -> BDH-ACTIVITY ACV-ACTIVE-BUD -> BDH-BUDGET-NBR ACACCTCATX FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Acbuddtl ACBUDDTL AXX-ACTIVITY-GRP -> BDT-ACTIVITY-GRP AXX-ACTIVITY -> BDT-ACTIVITY ACV-ACTIVE-BUD -> BDT-BUDGET-NBR AXX-ACCT-CATEGORY -> BDT-ACCT-CATEGORY BDT-FISCAL-YEAR Accommit ACCOMMIT AXX-ACTIVITY-GRP -> MIT-ACTIVITY-GRP AXX-ACTIVITY -> MIT-ACTIVITY AXX-ACCT-CATEGORY -> MIT-ACCT-CATEGORY MIT-FISCAL-YEAR MIT-PERIOD MIT-SYSTEM MIT-COMPANY MIT-CURRENCY-CODE Accommitx ACCOMMITX AXX-ACTIVITY-GRP -> MIX-ACTIVITY-GRP AXX-ACTIVITY -> MIX-ACTIVITY AXX-ACCT-CATEGORY -> MIX-ACCT-CATEGORY MIX-FISCAL-YEAR MIX-PERIOD MIX-SYSTEM MIX-COMPANY MIX-CURRENCY-CODE MIX-ATN-OBJ-ID Acconsol ACCONSOL AXX-ACTIVITY -> CSL-ACTIVITY Zeroes -> CSL-BUDGET-NBR AXX-ACCT-CATEGORY -> CSL-ACCT-CATEGORY CSL-FISCAL-YEAR Acconsol Bud ACCONSOL AXX-ACTIVITY -> CSL-ACTIVITY ACV-ACTIVE-BUD -> CSL-BUDGET-NBR AXX-ACCT-CATEGORY -> CSL-ACCT-CATEGORY CSL-FISCAL-YEAR Acconsolx ACCONSOLX AXX-ACTIVITY-GRP -> CSX-ACTIVITY-GRP AXX-ACTIVITY -> CSX-ACTIVITY Zeroes -> CSX-BUDGET-NBR AXX-ACCT-CATEGORY -> CSX-ACCT-CATEGORY CSX-FISCAL-YEAR CSX-PERIOD Acconsolx Bud ACCONSOLX AXX-ACTIVITY-GRP -> CSX-ACTIVITY-GRP AXX-ACTIVITY -> CSX-ACTIVITY Zeroes -> CSX-BUDGET-NBR AXX-ACCT-CATEGORY -> CSX-ACCT-CATEGORY CSX-FISCAL-YEAR CSX-PERIOD Accuamt ACCUAMT AXX-ACTIVITY-GRP -> ACU-ACTIVITY-GRP AXX-ACTIVITY -> ACU-ACTIVITY Zeroes -> ACU-BUDGET-NBR AXX-ACCT-CATEGORY -> ACU-ACCT-CATEGORY ACU-FISCAL-YEAR ACU-CURRENCY-CODE Accuamt Bud ACCUAMT AXX-ACTIVITY-GRP -> ACU-ACTIVITY-GRP AXX-ACTIVITY -> ACU-ACTIVITY ACV-ACTIVE-BUD -> ACU-BUDGET-NBR AXX-ACCT-CATEGORY -> ACU-ACCT-CATEGORY ACU-FISCAL-YEAR ACU-CURRENCY-CODE Accuamtx ACCUAMTX AXX-ACTIVITY-GRP -> ACX-ACTIVITY-GRP AXX-ACTIVITY -> ACX-ACTIVITY Zeroes -> ACX-BUDGET-NBR AXX-ACCT-CATEGORY -> ACX-ACCT-CATEGORY ACX-FISCAL-YEAR ACX-CURRENCY-CODE ACX-PERIOD Accuamtx Bud ACCUAMTX AXX-ACTIVITY-GRP -> ACX-ACTIVITY-GRP AXX-ACTIVITY -> ACX-ACTIVITY ACV-ACTIVE-BUD -> ACX-BUDGET-NBR AXX-ACCT-CATEGORY -> ACX-ACCT-CATEGORY ACX-FISCAL-YEAR ACX-CURRENCY-CODE ACX-PERIOD Acglacct ACGLACCT AXX-ACTIVITY-GRP -> AGA-ACTIVITY-GRP AXX-ACTIVITY -> AGA-ACTIVITY AXX-ACCT-CATEGORY -> AGA-ACCT-CATEGORY AGA-SEQ-NUMBER Acmaster ACMASTER AXX-ACTIVITY-GRP -> MST-ACTIVITY-GRP AXX-ACTIVITY -> MST-ACTIVITY AXX-ACCT-CATEGORY -> MST-ACCT-CATEGORY MST-FISCAL-YEAR Acmasterx ACMASTERX AXX-ACTIVITY-GRP -> MSX-ACTIVITY-GRP AXX-ACTIVITY -> MSX-ACTIVITY AXX-ACCT-CATEGORY -> MSX-ACCT-CATEGORY MSX-FISCAL-YEAR MSX-PERIOD |