ACTEMPACT – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
AEC
Primary key
TEMPLATE
Fields
31
Updated by
1 program
Referenced by
4 programs

ACTEMPACT is a Lawson Activity Management table (prefix AEC); no description in the lawson data dictionary. It is indexed by TEMPLATE (AECSET1). It is updated by AC71.1 and referenced by AC19.1, AC19.3, AC56.1 and AC560. The table has 31 fields, 1 index and 0 documented relations.

About ACTEMPACT

No description in the Lawson data dictionary.

Fields (31)

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

Field / columnTypeDescription & valuesUpdated by
AEC-TEMPLATE PK
TEMPLATE		Alpha 15The name of the template the detail records are associated to.AC71.1
AEC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AC71.1
AEC-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AC71.1
AEC-COMPANY
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AC71.1
AEC-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AC71.1
AEC-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.AC71.1
AEC-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AC71.1
AEC-USR-STATUS
USR_STATUS		Alpha 2—AC71.1
AEC-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the 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. Valid account category types are: cost revenue accrual pass thruAC71.1
AEC-BEGIN-DATE
BEGIN_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AC71.1
AEC-END-DATE
END_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AC71.1
AEC-BILLABLE-FLAG
BILLABLE_FLAG		Alpha 1—
  • Y Yes
  • N No
AC71.1
AEC-BILL-WBS-CODE
BILL_WBS_CODE		Alpha 3—AC71.1
AEC-LOCATION-NAME
LOCATION_NAME		Alpha 15—AC71.1
AEC-DIVISION
DIVISION		Alpha 15A user-defined division which is used for reporting assets.AC71.1
AEC-ACT-SEG-BLOCK
ACT_SEG_BLOCK		Alpha 103This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.AC71.1
AEC-BUDGET-EDIT
BUDGET_EDIT		Alpha 1—
  • 1 No Edit
  • 2 Period Edit
  • 3 Annual Edit
  • 4 Total Edit
AC71.1
AEC-BUDGET-LEVEL
BUDGET_LEVEL		Alpha 1—
  • 1 Activity-Acct Cat
  • 3 Activity
  • 4 Activity-Summary Account Cat
AC71.1
AEC-BUD-TOLERANCE
BUD_TOLERANCE		Signed 5.2—AC71.1
AEC-AWARD-FLAG
AWARD_FLAG		Alpha 1Flag to indicate whether this activity is an award for the GM system or a posting level activity within an award.
  • Y Yes
  • N No
AC71.1
AEC-EFFORT-FLAG
EFFORT_FLAG		Alpha 1Flag to indicate whether this activity is subject to effort reporting, and if it is, whether it prints in the sponsored or non-sponsored section of the report for effort reporting.
  • Y Yes
  • N No
AC71.1
AEC-SALARY-CAP-FL
SALARY_CAP_FL		Alpha 1This flag indicates whether the salary cap applies to this grant/project. The actual salary cap amount is stored on the GMSALCAP record.
  • Y Yes
  • N No
AC71.1
AEC-SCHEDULE
SCHEDULE		Alpha 9—AC71.1
AEC-CURRENT-CAP
CURRENT_CAP		Alpha 1—
  • Y Yes
  • N No
AC71.1
AEC-CAP-ACTIVITY
CAP_ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AC71.1
AEC-CAP-ACCT-CAT
CAP_ACCT_CAT		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the 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. Valid account category types are: cost revenue accrual pass thruAC71.1
AEC-CAP-COMPANY
CAP_COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AC71.1
AEC-CAP-ACCT-UNIT
CAP_ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AC71.1
AEC-CAP-ACCOUNT
CAP_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AC71.1
AEC-CAP-SUB-ACCT
CAP_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AC71.1
AEC-CAP-SEG-BLOCK
CAP_SEG_BLOCK		Alpha 103This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.AC71.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
AECSET1TEMPLATEPrimaryAC19.1, AC19.3, AC56.1, AC560, AC71.1

Programs

Updated by (1)

Referenced by (4)