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 |
|
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 |
|
CTL-REVALUE-FLAG Element: All Flag | Alpha 1
|
|
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 |
|