ACTEMPGRP – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
AEG
Primary key
TEMPLATE
Fields
50
Updated by
1 program
Referenced by
2 programs

ACTEMPGRP is a Lawson Activity Management table (prefix AEG); no description in the lawson data dictionary. It is indexed by TEMPLATE (AEGSET1). It is updated by AC70.1 and referenced by AC56.1 and AC560. The table has 50 fields, 1 index and 0 documented relations.

About ACTEMPGRP

No description in the Lawson data dictionary.

Fields (50)

Column = COBOL field name without the AEG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AEG-TEMPLATE PK
TEMPLATE
Alpha 15The name of the template the detail records are associated to.AC70.1
AEG-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.AC70.1
AEG-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC70.1
AEG-CALENDAR-NAME
CALENDAR_NAME
Alpha 12AC70.1
AEG-BEGIN-DATE
BEGIN_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AC70.1
AEG-END-DATE
END_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.AC70.1
AEG-SECURITY-CD
SECURITY_CD
Numeric 4AC70.1
AEG-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The status of the account. If Inactive, no posting can be done to the account.
  • O Open
  • C Closed
  • G GL Only
AC70.1
AEG-ACCT-EDIT-FLAG
ACCT_EDIT_FLAG
Alpha 1
  • 1 GL Only Activity
  • 2 No
  • 3 Yes-Substitute Error Suspense
  • 4 Yes-Require Valid Assignment
AC70.1
AEG-INV-AUDIT
INV_AUDIT
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-CHG-ORDER-FL
CHG_ORDER_FL
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-CONSOL-FLAG
CONSOL_FLAG
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-GL-CONSOL-FL
GL_CONSOL_FL
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-BILL-CONSOL-FL
BILL_CONSOL_FL
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-RESOURCE-FL
RESOURCE_FL
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-EDIT-PR
EDIT_PR
Alpha 1Determines whether HR employee resources will be validated in transactions for activities associated with the activity group; if yes, employees must be assigned as resources.
  • 1 Yes-Commitments
  • 2 Yes-No Commitments
  • 3 No-Commitments
  • 4 No-No Commitments
AC70.1
AEG-EDIT-AP-EE
EDIT_AP_EE
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-EDIT-TRANSREL
EDIT_TRANSREL
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-DATE-EDIT
DATE_EDIT
Alpha 1
  • P Posting Date
  • T Transaction Date
AC70.1
AEG-BILL-CALC-DATE
BILL_CALC_DATE
Alpha 1
  • P Posting Date
  • T Transaction Date
AC70.1
AEG-BURDEN-CALC-FL
BURDEN_CALC_FL
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-ASSET-EDIT
ASSET_EDIT
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-BUDGET-EDIT
BUDGET_EDIT
Alpha 1
  • 1 No Edit
  • 2 Period Edit
  • 3 Annual Edit
  • 4 Total Edit
AC70.1
AEG-BUDGET-LEVEL
BUDGET_LEVEL
Alpha 1
  • 1 Activity-Acct Cat
  • 2 Activity Group
  • 3 Activity
  • 4 Activity-Summary Account Cat
AC70.1
AEG-BUD-TOLERANCE
BUD_TOLERANCE
Signed 5.2AC70.1
AEG-TE-ACCT-DF-FL
TE_ACCT_DF_FL
Alpha 1
  • A Activity Expense Account
  • E Employee Expense Account
AC70.1
AEG-TE-ACCT-CAT-DF
TE_ACCT_CAT_DF
Alpha 1
  • A Activity Acct Category
  • E Employee Acct Category
AC70.1
AEG-EXPENSE-FL
EXPENSE_FL
Alpha 1
  • E Employee Company Acct Unit
  • A Activity Company Acct Unit
AC70.1
AEG-ACCOUNT
ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AC70.1
AEG-SUB-ACCOUNT
SUB_ACCOUNT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AC70.1
AEG-GL-CODE
GL_CODE
Alpha 4AC70.1
AEG-LEVEL-DESC
LEVEL_DESC
Alpha 12 (Lower Case)Occurs 5 Times This is the level description.AC70.1
AEG-LEVEL-SIZE
LEVEL_SIZE
Numeric 2 Occurs 5 Times ×5AC70.1
AEG-CURRENCY-TABLE
CURRENCY_TABLE
Alpha 12AC70.1
AEG-CURR-NAME-1
CURR_NAME_1
Alpha 12AC70.1
AEG-CURR-CODE-1
CURR_CODE_1
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC70.1
AEG-CURR-NAME-2
CURR_NAME_2
Alpha 12AC70.1
AEG-CURR-CODE-2
CURR_CODE_2
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC70.1
AEG-ACTIVITY-FLAG
ACTIVITY_FLAG
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-ASSET-FLAG
ASSET_FLAG
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-RESC-ASSIGN-FL
RESC_ASSIGN_FL
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-ATTRIBUTE-FLAG
ATTRIBUTE_FLAG
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-BILLING-FLAG
BILLING_FLAG
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-CONTRACT-FLAG
CONTRACT_FLAG
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-CEILING-FLAG
CEILING_FLAG
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-STRUCTURE
STRUCTURE
Alpha 15The name of the category structure.AC70.1
AEG-CAT-CONSOL-FL
CAT_CONSOL_FL
Alpha 1
  • Y Yes
  • N No
AC70.1
AEG-POP-FLAG
POP_FLAG
Alpha 1Period of Performance flag.
  • Y Yes
  • N No
AC70.1
AEG-BRDN-DATE-EDIT
BRDN_DATE_EDIT
Alpha 1Determines whether burden rates are based on the ACTRANS transaction date or posting date.AC70.1
AEG-PR-COMMIT
PR_COMMIT
Alpha 1Overrides 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.AC70.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AEGSET1TEMPLATEPrimaryAC56.1, AC560, AC70.1

Programs

Updated by (1)

Referenced by (2)