Lawson Insight Technical Documentation |
|
AMCONTROL
AMCONTROL FILE
Asset Internal Control
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.
REFERENCED BY
AC10.3 AM01.1 AM01.2 AM01.3 AM185 AM200
AM205 AM212 AM220 AM221 AM222 AM223
AM225 AM235 AM240 AM241 AM245 AM250
AM251 AM255 AM260 AM265 AM267 AM275
AM277 AM278 AM280 AM281 AM285 AM287
AM290 AM292 AM295 AM320 AM35.1 AM41.1
AM41.2 AM501 AM51.1 AM580 AM70.1 AM85.1
AM90.1 AM90.4 AM90.5 AM90.6 AM91.1 AM91.4
AM91.5 AM95.1 AM95.4 AM95.5 AM95.6 AM97.1
AP09.2 AP22.2
UPDATED BY
AC160 AM05.1 AM06.1 AM06.2 AM06.3 AM06.5
AM09.1 AM115 AM118 AM12.1 AM125 AM135
AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM154
AM16.1 AM170 AM18.1 AM18.2 AM180 AM190
AM192 AM195 AM20.1 AM20.2 AM20.3 AM20.4
AM20.5 AM20.6 AM21.1 AM21.2 AM21.3 AM21.4
AM21.5 AM21.6 AM230 AM282 AM30.1 AM30.2
AM40.1 AM40.2 AM40.3 AM500 AM551 AM700
AM88.7 AM96.1 AM98.1 AP125 AP126 AP170
AP193 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 API1.1 API2.1 MA41.2 MA41.7
MA43.2 MA61.1 MA70.1 MA75.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTL-COMPANY Numeric 4 AC160 AM05.1
Element: Company The company number. Represents a AM06.1 AM06.2
general ledger company that is AM06.3 AM06.5
associated with assets processed in the AM09.1 AM115
Asset Management system. AM118 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM170
AM18.1 AM18.2
AM180 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM551 AM88.7
AM96.1 AM98.1
AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
CTL-LAST-ASSET Numeric 10 AM115 AM135
Element: Last Asset The last asset number that was assigned AM15.1 AM15.2
for the company. Assets are AM15.3 AM15.4
automatically numbered. Asset numbers AM154 AM16.1
are used to uniquely identify an asset. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM40.1
AM500 AM551
AM96.1 AM98.1
CTL-LAST-INTER-SEQ Numeric 6 AC160 AM115
Element: Last Sequence The last sequence number that was AM118 AM15.1
assigned for the company. The system AM15.2 AM15.3
automatically assigns sequence numbers AM15.4 AM154
to asset items that are entered in or AM16.1 AM18.1
interfaced to the Asset Management AM18.2 AP125
system. AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
CTL-PROCESS-REL-FL Alpha 1 AC160 AM05.1
Element: Process ReleasThis field indicates whether AM190 AM06.1 AM06.2
(Period Close) has been run with Yes in AM06.3 AM06.5
the Release field to close the period. AM09.1 AM115
The system uses this field to determine AM118 AM12.1
whether AM190 or AM195 (Year End Close) AM125 AM135
can be run. AM195 can be run only after AM145 AM15.1
all periods for a book have been closed AM15.2 AM15.3
by AM190 with the Release option set to AM15.4 AM154
Yes. AM16.1 AM170
N = No AM18.1 AM18.2
Y = Yes AM180 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM551 AM88.7
AM96.1 AM98.1
AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
CTL-PENDING-YE-CNT Numeric 2 AM16.1 AM190
Pending Year-End The pending number of summary AM192 AM195
Count 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.
CTL-GL-NAME Derived
Element: Name The name of the general ledger company.
CTL-GL-CURR-CODE Derived
Element: Currency Code The base currency code assigned to the
general ledger company.
CTL-GL-CHART Derived
Element: Chart The chart name assigned to the general
ledger company.
CTL-HOLD-CODE-DEFT Alpha 1 AM16.1
Element: Hold Code DeftThe default setting for the Accounts
Payable (AP) or Project and Activity
Accounting (AC) hold code. Valid values
are:
N = Not Held
Y = Hold
The default is N.
CTL-ITEM-NBR-DEFT Alpha 1 AM115 AM15.1
Element: Item Nbr Deft The default setting for item numbering. AM15.2 AM15.3
Valid values are: AM15.4 AM16.1
T = Tag (the default) AM20.1 AM20.3
S = System (system-numbered) AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
CTL-EXP-ACT-FLAG Alpha 1 AC160 AM16.1
Element: Exp Act Flag The default setting for populating the AP125 AP126
depreciation expense activity from AP. AP170 AP193
Valid values are: AP20.1 AP20.2
Y = Yes (the default) AP20.3 AP20.4
N = No AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
CTL-REM-LIFE-FLAG Alpha 1 AM115 AM125
Element: Rem Life Flag The default setting indicating whether AM15.1 AM15.2
the remaining life will be calculated AM15.3 AM15.4
for the Compute = Yes option, when the AM16.1 AM20.1
in-service date or asset life is AM20.2 AM20.4
changed. Valid values are: AM21.1 AM21.2
N = No (the default) AM21.4 AM500
Y = Yes AM551 AM98.1
CTL-CONSOL-JE-FLAG Alpha 1 AM145 AM154
Element: Consol Je FlagThe default setting that allows the AM16.1 AM40.1
user to display a consolidated journal AM40.2 AM40.3
entry for asset disposals or display a
detailed journal entry. Valid values
are:
Y = Yes (the default)
No = No (display detail entry)
CTL-DISP-JE-FLAG Alpha 1 AM16.1 AM20.1
Element: Disp Je Flag The default setting that allows the AM20.2 AM20.4
user to either display or not display AM21.1 AM21.2
the AM20.5 journal entries. Valid values AM21.4
are:
Y = Yes (the default)
N = No
Y = Yes
CTL-DEP-EXP-ALLOC Alpha 1 AC160 AM05.1
Element: Dep Exp Alloc AM06.1 AM06.2
AM06.3 AM06.5
AM09.1 AM115
AM118 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM170
AM18.1 AM18.2
AM180 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM551
AM700 AM88.7
AM96.1 AM98.1
AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
...
AMCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTLSET1 COMPANY AC10.3 AC160
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM09.1 AM115
AM118 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM170
AM18.1 AM18.2
AM180 AM185
AM190 AM192
...
AMCONTROL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Not Required
CTL-COMPANY -> GLS-COMPANY
AMCONTROL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amacctgrp AMACCTGRP
CTL-COMPANY -> AAG-COMPANY
AAG-ACCT-GRP
Amasset1 AMASSET
1 -> AST-STATUS
CTL-COMPANY -> AST-COMPANY
AST-DSP-ASSET
AST-ASSET
Amasset2 AMASSET
2 -> AST-STATUS
CTL-COMPANY -> AST-COMPANY
AST-DSP-ASSET
AST-ASSET
Amasset3 AMASSET
3 -> AST-STATUS
CTL-COMPANY -> AST-COMPANY
AST-DSP-ASSET
AST-ASSET
Amasset6 AMASSET
2 -> AST-STATUS
CTL-COMPANY -> AST-COMPANY
AST-ASSET-GROUP
AST-DSP-ASSET
AST-ASSET
Amassetadj AMASSETADJ
CTL-COMPANY -> ASA-COMPANY
ASA-ASSET
ASA-PROCESS-SEQ
Amassetdsp AMASSET
9 -> AST-STATUS
CTL-COMPANY -> AST-COMPANY
AST-DSP-ASSET
AST-ASSET
Amassettrf AMASSETTRF
CTL-COMPANY -> ATF-COMPANY
ATF-ASSET
ATF-PROCESS-SEQ
Amasttype AMASTTYPE
CTL-COMPANY -> ATP-COMPANY
ATP-ASSET-TYPE
ATP-SUB-TYPE
Amaugroup AMAUGROUP
CTL-COMPANY -> AAU-COMPANY
AAU-AU-GROUP
Amcalendar AMCALENDAR
CTL-COMPANY -> AMC-COMPANY
AMC-BOOK
Amsysopts AMSYSOPTS
CTL-COMPANY -> AMO-COMPANY
AMO-CREATION-DATE
AMO-CREATION-TIME
Amtrans AMTRANS
CTL-COMPANY -> AMT-COMPANY
"R" -> AMT-TRANS-STATUS
AMT-ASSET-PROCESS
AMT-ASSET
AMT-SEQ-NUMBER
Amtransumm AMTRANSUMM
CTL-COMPANY -> ATS-COMPANY
ATS-BOOK
ATS-ACCT-UNIT
ATS-ACCOUNT
ATS-SUB-ACCOUNT
ATS-YR-END-DATE
|