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 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 AM17.1 AM170 AM18.1 AM18.2
AM180 AM19.1 AM19.2 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 AM30.3 AM40.1
AM40.2 AM40.3 AM40.4 AM41.1 AM41.2 AM500
AM502 AM551 AM700 AM88.7 AM92.1 AM96.1
AM98.1 AP115 AP125 AP126 AP131 AP170
AP193 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP220 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP305 AP520
API1.1 API2.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
WH20.2 WH20.7
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
AM17.1 AM170
AM18.1 AM18.2
AM180 AM19.1
AM19.2 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM88.7
AM92.1 AM96.1
AM98.1 AP115
...
CTL-LAST-ASSET Numeric 10 AC160 AM115
Element: Last Asset The last asset number that was assigned AM117 AM135
for the company. Assets are AM15.1 AM15.2
automatically numbered. Asset numbers AM15.3 AM15.4
are used to uniquely identify an asset. AM154 AM16.1
AM170 AM19.1
AM19.2 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
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
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. AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP520 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
...
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 AM17.1 AM170
Y = Yes AM18.1 AM18.2
AM180 AM19.1
AM19.2 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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.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 AC160 AM05.1
Element: Hold Code DeftThe default setting for the Accounts AM06.1 AM06.2
Payable (AP) or Project and Activity AM06.3 AM06.5
Accounting (AC) hold code. Valid values AM09.1 AM115
are: AM117 AM12.1
N = Not Held AM125 AM135
Y = Hold AM145 AM15.1
AM15.2 AM15.3
The default is N. AM15.4 AM154
AM16.1 AM17.1
AM170 AM180
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
...
CTL-ITEM-NBR-DEFT Alpha 1 AC160 AM05.1
Element: Item Nbr Deft The default setting for item numbering. AM06.1 AM06.2
Valid values are: AM06.3 AM06.5
T = Tag (the default) AM09.1 AM115
S = System (system-numbered) AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM17.1
AM170 AM180
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM51.1
AM551 AM88.7
AM92.1 AM96.1
AM97.1 AM98.1
AP115 AP125
...
CTL-EXP-ACT-FLAG Alpha 1 AC160 AM05.1
Element: Exp Act Flag The default setting for populating the AM06.1 AM06.2
depreciation expense activity from AP. AM06.3 AM06.5
Valid values are: AM09.1 AM115
Y = Yes (the default) AM117 AM12.1
N = No AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM17.1
AM170 AM180
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
...
CTL-REM-LIFE-FLAG Alpha 1 AC160 AM05.1
Element: Rem Life Flag The default setting indicating whether AM06.1 AM06.2
the remaining life will be calculated AM06.3 AM06.5
for the Compute = Yes option, when the AM09.1 AM115
in-service date or asset life is AM117 AM12.1
changed. Valid values are: AM125 AM135
N = No (the default) AM145 AM15.1
Y = Yes AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM17.1
AM170 AM180
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
...
CTL-CONSOL-JE-FLAG Alpha 1 AC160 AM05.1
Element: Consol Je FlagThe default setting that allows the AM06.1 AM06.2
user to display a consolidated journal AM06.3 AM06.5
entry for asset disposals or display a AM09.1 AM115
detailed journal entry. Valid values AM117 AM12.1
are: AM125 AM135
Y = Yes (the default) AM145 AM15.1
No = No (display detail entry) AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM17.1
AM170 AM180
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
...
CTL-DISP-JE-FLAG Alpha 1 AC160 AM05.1
Element: Disp Je Flag The default setting that allows the AM06.1 AM06.2
user to either display or not display AM06.3 AM06.5
the AM20.5 journal entries. Valid values AM09.1 AM115
are: AM117 AM12.1
Y = Yes (the default) AM125 AM135
N = No AM145 AM15.1
Y = Yes AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM17.1
AM170 AM180
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
...
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
AM17.1 AM170
AM18.1 AM18.2
AM180 AM19.1
AM19.2 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM700
AM88.7 AM92.1
AM96.1 AM98.1
...
CTL-SPLIT-FLAG Alpha 1 AC160 AM05.1
Element: Split Flag Y = Yes AM06.1 AM06.2
N = No AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM17.1
AM170 AM180
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
...
CTL-AP-DISTRIB-FL Alpha 1 AC160 AM05.1
Element: Ap Distrib Fl D = Detail AM06.1 AM06.2
S = Summary AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM16.1 AM17.1
AM170 AM180
AM19.1 AM19.2
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
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM88.7 AM92.1
AM96.1 AM98.1
AP115 AP125
AP126 AP131
...
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
AM17.1 AM170
AM18.1 AM18.2
AM180 AM185
...
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
|