Lawson Insight Technical Documentation |
|
AMCTLTRANS
AMCTLTRANS FILE
Asset Control Transaction
The Asset Control Transaction file is an internal file that stores general
ledger transaction batch totals and header information. These records are used
to group unreleased asset transactions (additions, adjustments, disposals, and
transfers) and to aid batch release processing. When the transactions are
released, the reference and description information is transferred to the
asset transaction records, and the associated asset control transaction record
is deleted from this file.
UPDATED BY
AM115 AM117 AM125 AM135 AM145 AM15.1
AM15.2 AM15.3 AM15.4 AM154 AM170 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 AM30.1 AM30.2 AM30.3 AM40.1 AM40.2
AM40.3 AM40.4 AM41.1 AM41.2 AM500 AM502
AM551 AM92.1 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACT-ASSET Numeric 10 AM115 AM117
Element: Asset The asset number associated with the AM125 AM135
control record. AM145 AM15.1
AM15.2 AM15.3
The asset number contains up to ten AM15.4 AM154
numeric characters that uniquely AM170 AM190
identify an asset. Assets are AM192 AM20.1
automatically numbered system-wide. 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 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.2 AM500
AM502 AM551
AM92.1 AM96.1
AM98.1
ACT-TRANS-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Transaction DaThe date of the transaction. This date AM125 AM135
is used for posting transactions to the AM145 AM15.1
general ledger. AM15.2 AM15.3
AM15.4 AM154
AM170 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.2 AM500
AM502 AM551
AM92.1 AM96.1
AM98.1
ACT-REFERENCE Alpha 10 (Lower Case) AM115 AM117
Element: Reference The general ledger reference number AM125 AM135
assigned to associated transactions when AM145 AM15.1
they are released. AM15.2 AM15.3
AM15.4 AM154
AM170 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.2 AM500
AM502 AM551
AM92.1 AM96.1
AM98.1
ACT-DESCRIPTION Alpha 30 (Lower Case) AM115 AM117
Element: Description The description assigned to associated AM125 AM135
transactions when they are released. AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.2 AM500
AM502 AM551
AM92.1 AM96.1
AM98.1
ACT-DEBIT-BALANCE Signed 18.2 AM115 AM117
Element: Debit Balance This field stores the total debit AM125 AM135
amount for the batch of asset AM145 AM15.1
transactions. The debit balance must AM15.2 AM15.3
equal the credit balance before asset AM15.4 AM154
transactions can be released. AM170 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.2 AM500
AM502 AM551
AM92.1 AM96.1
AM98.1
ACT-CREDIT-BALANCE Signed 18.2 AM115 AM117
Element: Credit BalanceThis field stores the total credit AM125 AM135
amount for the batch of asset AM145 AM15.1
transactions. The credit balance must AM15.2 AM15.3
equal the debit balance before asset AM15.4 AM154
transactions can be released. AM170 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.2 AM500
AM502 AM551
AM92.1 AM96.1
AM98.1
AMCTLTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACTSET1 ASSET AM115 AM117
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AM170 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 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
...
|