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
AM180 AM185 AM205 AM212 AM220 AM221
AM222 AM223 AM225 AM230 AM235 AM240
AM245 AM250 AM255 AM260 AM265 AM275
AM277 AM280 AM285 AM290 AM292 AM295
AM35.1 AM580 AM70.1 AM85.1 AM90.1 AM95.1
UPDATED BY
AC160 AM05.1 AM06.1 AM06.2 AM09.1 AM115
AM118 AM12.1 AM125 AM135 AM145 AM15.1
AM15.2 AM15.3 AM15.4 AM170 AM18.1 AM18.2
AM190 AM192 AM195 AM20.1 AM20.2 AM20.3
AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1
AM40.2 AM40.3 AM500 AM950 AM951 AM956
AM96.1 AM98.1 AP125 AP126 AP170 AP193
AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 MA530
MA540 PO31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTL-COMPANY Numeric 4 AC160 AM05.1
Company The company number. Represents a AM06.1 AM06.2
general ledger company that is AM09.1 AM115
associated with assets processed in the AM118 AM12.1
Asset Management system. AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM18.1 AM18.2
AM190 AM192
AM195 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM950
AM951 AM96.1
AM98.1 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
MA530 MA540
PO31.1
CTL-LAST-ASSET Numeric 10 AM115 AM135
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 AM170 AM20.1
are used to uniquely identify an asset. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM500 AM951
AM956 AM96.1
AM98.1
CTL-LAST-INTER-SEQ Numeric 6 AC160 AM115
Last Sequence Number 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 AM18.1
to asset items that are entered in or AM18.2 AP125
interfaced to the Asset Management AP126 AP170
system. AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
MA530 MA540
PO31.1
CTL-PROCESS-REL-FL Alpha 1 AC160 AM05.1
Process Release Flag This field indicates whether AM190 AM06.1 AM06.2
(Period Close) has been run with Yes in AM09.1 AM115
the Release field to close the period. AM118 AM12.1
The system uses this field to determine AM125 AM135
whether AM190 or AM195 (Year End Close) AM145 AM15.1
can be run. AM195 can be run only after AM15.2 AM15.3
all periods for a book have been closed AM15.4 AM170
by AM190 with the Release option set to AM18.1 AM18.2
Yes. AM190 AM192
AM195 AM20.1
N = No AM20.2 AM20.3
Y = Yes AM20.4 AM20.5
AM20.6 AM30.1
AM30.2 AM40.1
AM40.2 AM40.3
AM500 AM96.1
AM98.1 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
MA530 MA540
PO31.1
CTL-PENDING-YE-CNT Numeric 2 AM190 AM192
Pending Year-End The pending number of summary 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
Name The name of the general ledger company.
CTL-GL-CURR-CODE Derived
Currency Code The base currency code assigned to the
general ledger company.
CTL-GL-CHART Derived
Chart The chart name assigned to the general
ledger company.
AMCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTLSET1 COMPANY AC160 AM05.1
AM06.1 AM06.2
AM09.1 AM115
AM118 AM12.1
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM18.1 AM18.2
AM180 AM185
AM190 AM192
AM195 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM205
...
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
Amtrans AMTRANS
CTL-COMPANY -> AMT-COMPANY
"R" -> AMT-TRANS-STATUS
AMT-ASSET-PROCESS
AMT-ASSET
AMT-SEQ-NUMBER
|