AMCONTROL – Asset Internal Control

System
Asset Management (AM)
Prefix
CTL
Primary key
COMPANY
Fields
20
Updated by
301 programs
Referenced by
63 programs

AMCONTROL is the Asset Internal Control table in Lawson Asset Management (prefix CTL). It is indexed by COMPANY (CTLSET1). It is related 1:1 to GLSYSTEM and 1:M to AMACCTGRP, AMASSET, AMASSETADJ, AMASSETTRF, AMASTTYPE, AMAUGROUP, AMCALENDAR, AMCNTRLAU and 3 more. It is updated by AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 and 293 more and referenced by AC10.1, AC10.3, AC56.1, AC560, AC71.1, AM01.1, AM01.2, AM01.3 and 55 more. The table has 20 fields, 1 index and 16 documented relations.

About AMCONTROL

The Asset Internal Control file stores control records for the general ledger companies that are associated with records processed in the Asset Management system. The Asset Management system uses these records to determine the next asset number to assign, determine whether asset books can be closed for a period or year, and so on.

Fields (20)

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

Field / columnTypeDescription & valuesUpdated by
CTL-COMPANY PK
COMPANY		Numeric 4The company number. Represents a general ledger company that is associated with assets processed in the Asset Management system.AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-LAST-ASSET
LAST_ASSET		Numeric 10The last asset number that was assigned for the company. Assets are automatically numbered. Asset numbers are used to uniquely identify an asset.AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
CTL-LAST-INTER-SEQ
LAST_INTER_SEQ		Numeric 6The last sequence number that was assigned for the company. The system automatically assigns sequence numbers to asset items that are entered in or interfaced to the Asset Management system.AC160, AM115, AM117, AM118, AM15.1, AM15.2, AM15.3, AM15.4 +52 more (list truncated in source)
CTL-PROCESS-REL-FL
PROCESS_REL_FL		Alpha 1This field indicates whether AM190 (Period Close) has been run with Yes in the Release field to close the period. The system uses this field to determine whether AM190 or AM195 (Year End Close) can be run. AM195 can be run only after all periods for a book have been closed by AM190 with the Release option set to Yes.
  • N No
  • Y Yes
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-PENDING-YE-CNT
PENDING_YE_CNT		Numeric 2The pending number of summary transactions that AM195 (Year End Close) will post to the general ledger. AM190 (Period Close) updates this field each time AM190 is run with Yes in the Release field. AM195 resets this field to zero.AM16.1, AM190, AM192, AM195
CTL-GL-NAME
GL_NAME		DerivedThe name of the general ledger company.—
CTL-GL-CURR-CODE
GL_CURR_CODE		DerivedThe base currency code assigned to the general ledger company.—
CTL-GL-CHART
GL_CHART		DerivedThe chart name assigned to the general ledger company.—
CTL-HOLD-CODE-DEFT
HOLD_CODE_DEFT		Alpha 1The default setting for the Accounts Payable (AP) or Project and Activity Accounting (AC) hold code. Valid values are: The default is N.
  • N Not Held
  • Y Hold
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-ITEM-NBR-DEFT
ITEM_NBR_DEFT		Alpha 1The default setting for item numbering. Valid values are:
  • T Tag (the default)
  • S System (system-numbered)
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-EXP-ACT-FLAG
EXP_ACT_FLAG		Alpha 1The default setting for populating the depreciation expense activity from AP. Valid values are:
  • Y Yes (the default)
  • N No
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-REM-LIFE-FLAG
REM_LIFE_FLAG		Alpha 1The default setting indicating whether the remaining life will be calculated for the Compute = Yes option, when the in-service date or asset life is changed. Valid values are:
  • N No (the default)
  • Y Yes
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-CONSOL-JE-FLAG
CONSOL_JE_FLAG		Alpha 1The default setting that allows the user to display a consolidated journal entry for asset disposals or display a detailed journal entry. Valid values are:
  • Y Yes (the default)
  • No No (display detail entry)
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-DISP-JE-FLAG
DISP_JE_FLAG		Alpha 1The default setting that allows the user to either display or not display the AM20.5 journal entries. Valid values are:
  • Y Yes (the default)
  • N No
  • Y Yes
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-DEP-EXP-ALLOC
DEP_EXP_ALLOC		Alpha 1—
  • N No
  • Y Yes
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-SPLIT-FLAG
SPLIT_FLAG		Alpha 1—
  • Y Yes
  • N No
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-AP-DISTRIB-FL
AP_DISTRIB_FL		Alpha 1—
  • D Detail
  • S Summary
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-EVENT-ACCTS
EVENT_ACCTS		Alpha 1—
  • N No
  • Y Yes
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM115, AM117 +52 more (list truncated in source)
CTL-COMPUTE-OPTION
COMPUTE_OPTION		Alpha 1The Compute Option calculates the depreciation for an asset. The valid values are Yes and No. The Compute Option in AM16.1 will only be applied to AM20.1 (Quick Addition). If an asset is entered using AM20.2 to AM20.5, the Compute Option should be set in AM20.4. " " = No
  • N No
  • Y Yes
AC160, AM05.1, AM06.1, AM06.2, AM06.3, AM06.5, AM09.1, AM115 +52 more (list truncated in source)
CTL-REVALUE-FLAG
REVALUE_FLAG		Alpha 1—AM16.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CTLSET1COMPANYPrimaryAC10.1, AC10.3, AC160, AC56.1, AC560, AC71.1, AM01.1, AM01.2 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlsystemGLSYSTEMNot RequiredCTL-COMPANY → GLS-COMPANY

One to many (15) — child tables

RelationTableRulesConditionField map
AmacctgrpAMACCTGRPCTL-COMPANY → AAG-COMPANY, → AAG-ACCT-GRP
Amasset1AMASSET1 → AST-STATUS, CTL-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
Amasset2AMASSET2 → AST-STATUS, CTL-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
Amasset3AMASSET3 → AST-STATUS, CTL-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
Amasset6AMASSET2 → AST-STATUS, CTL-COMPANY → AST-COMPANY, → AST-ASSET-GROUP, → AST-DSP-ASSET, → AST-ASSET
AmassetadjAMASSETADJCTL-COMPANY → ASA-COMPANY, → ASA-ASSET, → ASA-PROCESS-SEQ
AmassetdspAMASSET9 → AST-STATUS, CTL-COMPANY → AST-COMPANY, → AST-DSP-ASSET, → AST-ASSET
AmassettrfAMASSETTRFCTL-COMPANY → ATF-COMPANY, → ATF-ASSET, → ATF-PROCESS-SEQ
AmasttypeAMASTTYPECTL-COMPANY → ATP-COMPANY, → ATP-ASSET-TYPE, → ATP-SUB-TYPE
AmaugroupAMAUGROUPCTL-COMPANY → AAU-COMPANY, → AAU-AU-GROUP
AmcalendarAMCALENDARCTL-COMPANY → AMC-COMPANY, → AMC-BOOK
AmcntrlauAMCNTRLAUCTL-COMPANY → AML-COMPANY, → AML-ACTION, → AML-DATE, → AML-TIME, → AML-UNIQUE-I-D
AmsysoptsAMSYSOPTSCTL-COMPANY → AMO-COMPANY, → AMO-CREATION-DATE, → AMO-CREATION-TIME
AmtransAMTRANSCTL-COMPANY → AMT-COMPANY, "R" → AMT-TRANS-STATUS, → AMT-ASSET-PROCESS, → AMT-ASSET, → AMT-SEQ-NUMBER
AmtransummAMTRANSUMMCTL-COMPANY → ATS-COMPANY, → ATS-BOOK, → ATS-ACCT-UNIT, → ATS-ACCOUNT, → ATS-SUB-ACCOUNT, → ATS-YR-END-DATE

Programs

Updated by (301)

Referenced by (63)