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 AM117 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 AM206 AM21.1 AM21.2
AM21.3 AM21.4 AM21.5 AM21.6 AM211 AM230
AM282 AM30.1 AM30.2 AM40.1 AM40.2 AM40.3
AM500 AM502 AM551 AM700 AM88.7 AM92.1
AM96.1 AM98.1 AP125 AP126 AP170 AP193
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
API1.1 API2.1 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. AM117 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 AM206
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM211 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP125
AP126 AP170
AP193 AP25.1
...
CTL-LAST-ASSET Numeric 10 AM115 AM117
Element: Last Asset The last asset number that was assigned AM135 AM15.1
for the company. Assets are AM15.2 AM15.3
automatically numbered. Asset numbers AM15.4 AM154
are used to uniquely identify an asset. AM16.1 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 AM117 AM118
assigned for the company. The system AM15.1 AM15.2
automatically assigns sequence numbers AM15.3 AM15.4
to asset items that are entered in or AM154 AM16.1
interfaced to the Asset Management AM18.1 AM18.2
system. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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 AM117 AM118
whether AM190 or AM195 (Year End Close) AM12.1 AM125
can be run. AM195 can be run only after AM135 AM145
all periods for a book have been closed AM15.1 AM15.2
by AM190 with the Release option set to AM15.3 AM15.4
Yes. AM154 AM16.1
N = No AM170 AM18.1
Y = Yes AM18.2 AM180
AM190 AM192
AM195 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM206
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM211 AM230
AM282 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP125
AP126 AP170
AP193 AP25.1
...
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 AM05.1 AM06.1
Element: Hold Code DeftThe default setting for the Accounts AM06.2 AM06.3
Payable (AP) or Project and Activity AM06.5 AM09.1
Accounting (AC) hold code. Valid values AM115 AM117
are: AM12.1 AM125
N = Not Held AM135 AM145
Y = Hold AM15.1 AM15.2
AM15.3 AM15.4
The default is N. AM154 AM16.1
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
CTL-ITEM-NBR-DEFT Alpha 1 AM05.1 AM06.1
Element: Item Nbr Deft The default setting for item numbering. AM06.2 AM06.3
Valid values are: AM06.5 AM09.1
T = Tag (the default) AM115 AM117
S = System (system-numbered) AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM16.1
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM51.1
AM551 AM88.7
AM92.1 AM96.1
AM97.1 AM98.1
CTL-EXP-ACT-FLAG Alpha 1 AM05.1 AM06.1
Element: Exp Act Flag The default setting for populating the AM06.2 AM06.3
depreciation expense activity from AP. AM06.5 AM09.1
Valid values are: AM115 AM117
Y = Yes (the default) AM12.1 AM125
N = No AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM16.1
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
CTL-REM-LIFE-FLAG Alpha 1 AM05.1 AM06.1
Element: Rem Life Flag The default setting indicating whether AM06.2 AM06.3
the remaining life will be calculated AM06.5 AM09.1
for the Compute = Yes option, when the AM115 AM117
in-service date or asset life is AM12.1 AM125
changed. Valid values are: AM135 AM145
N = No (the default) AM15.1 AM15.2
Y = Yes AM15.3 AM15.4
AM154 AM16.1
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
CTL-CONSOL-JE-FLAG Alpha 1 AM05.1 AM06.1
Element: Consol Je FlagThe default setting that allows the AM06.2 AM06.3
user to display a consolidated journal AM06.5 AM09.1
entry for asset disposals or display a AM115 AM117
detailed journal entry. Valid values AM12.1 AM125
are: AM135 AM145
Y = Yes (the default) AM15.1 AM15.2
No = No (display detail entry) AM15.3 AM15.4
AM154 AM16.1
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
CTL-DISP-JE-FLAG Alpha 1 AM05.1 AM06.1
Element: Disp Je Flag The default setting that allows the AM06.2 AM06.3
user to either display or not display AM06.5 AM09.1
the AM20.5 journal entries. Valid values AM115 AM117
are: AM12.1 AM125
Y = Yes (the default) AM135 AM145
N = No AM15.1 AM15.2
Y = Yes AM15.3 AM15.4
AM154 AM16.1
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
CTL-DEP-EXP-ALLOC Alpha 1 AC160 AM05.1
Element: Dep Exp Alloc N = No AM06.1 AM06.2
Y = Yes AM06.3 AM06.5
AM09.1 AM115
AM117 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
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM700 AM88.7
AM92.1 AM96.1
AM98.1 AP125
AP126 AP170
AP193 AP25.1
...
CTL-SPLIT-FLAG Alpha 1 AM05.1 AM06.1
Element: Split Flag Y = Yes AM06.2 AM06.3
N = No AM06.5 AM09.1
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM16.1
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
CTL-AP-DISTRIB-FL Alpha 1 AM05.1 AM06.1
Element: Ap Distrib Fl D = Detail AM06.2 AM06.3
S = Summary AM06.5 AM09.1
AM115 AM117
AM12.1 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM16.1
AM170 AM180
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM206 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM211
AM230 AM282
AM30.1 AM30.2
AM40.1 AM40.2
AM40.3 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
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
AM117 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
...
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
|