AMCONTROL

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.1 AC10.3 AC56.1 AC560 AC71.1 AM01.1
AM01.2 AM01.3 AM08.1 AM08.2 AM181 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 AM291 AM292 AM295 AM320
AM35.1 AM501 AM51.1 AM55.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 AM12.2
AM125 AM135 AM145 AM15.1 AM15.2 AM15.3
AM15.4 AM154 AM155 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 AM22.1 AM22.2 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 AP510 AP520 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
MA126 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.1 MA42.2 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA44.1 MA44.2 MA53.1
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA69.1 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD570 PO04.1 PO04.2 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO131
PO132 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO222 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO251 PO26.3 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 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 PO54.5 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTL-COMPANY
Element: Company
Numeric 4
The 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
AM117 AM118
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 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 AM22.1
AM22.2 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
CTL-LAST-ASSET
Element: Last Asset
Numeric 10
The 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
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 AM22.1
AM22.2 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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CTL-LAST-INTER-SEQ
Element: Last Sequence Number
Numeric 6
The 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
AM154 AM16.1
AM18.1 AM18.2
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
AP510 AP520
API1.1 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC12.1
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
CTL-PROCESS-REL-FL
Element: Process Release Flag
Alpha 1
This 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
AM117 AM118
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 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
AM22.1 AM22.2
AM230 AM282
AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
CTL-PENDING-YE-CNT
Pending Year-End
Count
Numeric 2
The 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
Element: Name
Derived
The name of the general ledger company.
CTL-GL-CURR-CODE
Element: Currency Code
Derived
The base currency code assigned to the general ledger company.
CTL-GL-CHART
Element: Chart
Derived
The chart name assigned to the general ledger company.
CTL-HOLD-CODE-DEFT
Element: Hold Code Deft
Alpha 1
The 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.
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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-ITEM-NBR-DEFT
Element: Item Nbr Deft
Alpha 1
The 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
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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
CTL-EXP-ACT-FLAG
Element: Exp Act Flag
Alpha 1
The 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
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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-REM-LIFE-FLAG
Element: Rem Life Flag
Alpha 1
The 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
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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-CONSOL-JE-FLAG
Element: Consol Je Flag
Alpha 1
The 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
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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-DISP-JE-FLAG
Element: Disp Je Flag
Alpha 1
The 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
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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-DEP-EXP-ALLOC
Element: Dep Exp Alloc
Alpha 1

N = No
Y = Yes
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM09.1 AM115
AM117 AM118
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 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 AM22.1
AM22.2 AM230
AM282 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM502
AM551 AM700
CTL-SPLIT-FLAG
Element: Split Flag
Alpha 1

Y = Yes
N = No
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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-AP-DISTRIB-FL
Element: Ap Distrib Fl
Alpha 1

D = Detail
S = Summary
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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-EVENT-ACCTS
Element: All Flag
Alpha 1

N = No
Y = Yes
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM115 AM117
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM155 AM16.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
AM22.1 AM22.2
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
CTL-COMPUTE-OPTION
Element: Compute Option
Alpha 1
The 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.
N = No
Y = Yes
" " = No
...
AC160 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM09.1 AM115
AM117 AM12.1
AM12.2 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
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
AM22.1 AM22.2
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-REVALUE-FLAG
Element: All Flag
Alpha 1
AM16.1


AMCONTROL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTLSET1 COMPANY
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM08.1 AM08.2
AM09.1 AM115
AM117 AM118
AM12.1 AM12.2
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154


AMCONTROL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Not Required
CTL-COMPANY->GLS-COMPANY


AMCONTROL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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
Amcntrlau AMCNTRLAU
CTL-COMPANY->AML-COMPANY
  AML-ACTION
  AML-DATE
  AML-TIME
  AML-UNIQUE-I-D
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


File created: Thu Jun 09 02:05:25 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.