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.
| 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.
|
|
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.
|
|
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.
|
|
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 |
|
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.
|
|
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.
|
|
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)
|
|
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
|
|
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
|
|
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)
|
|
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 |
|
CTL-DEP-EXP-ALLOC
Element: Dep Exp Alloc | Alpha 1
N = No
Y = Yes |
|
CTL-SPLIT-FLAG
Element: Split Flag | Alpha 1
Y = Yes
N = No |
|
CTL-AP-DISTRIB-FL
Element: Ap Distrib Fl | Alpha 1
D = Detail
S = Summary |
|
CTL-EVENT-ACCTS
Element: All Flag | Alpha 1
N = No
Y = Yes |
|
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 |
|
| 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 |
|
