 |
Lawson Insight Technical Documentation |
|
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 AM125 AM135 AM145 AM15.1 AM15.2
AM15.3 AM15.4 AM154 AM170 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 AM41.1 AM500 AM551
AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACT-ASSET Numeric 10 AM115 AM125
Asset The asset number associated with the AM135 AM145
control record. AM15.1 AM15.2
AM15.3 AM15.4
The asset number contains up to ten AM154 AM170
numeric characters that uniquely AM20.1 AM20.2
identify an asset. Assets are AM20.3 AM20.4
automatically numbered system-wide. AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM30.1 AM30.2
AM40.1 AM40.2
AM500 AM551
AM96.1 AM98.1
ACT-TRANS-DATE Numeric 8 (yyyymmdd) AM115 AM125
Transaction Date The date of the transaction. This date AM135 AM145
is used for posting transactions to the AM15.1 AM15.2
general ledger. AM15.3 AM15.4
AM154 AM170
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
AM40.1 AM40.2
AM500 AM551
AM96.1 AM98.1
ACT-REFERENCE Alpha 10 (Lower Case) AM115 AM125
Reference The general ledger reference number AM135 AM145
assigned to associated transactions when AM15.1 AM15.2
they are released. AM15.3 AM15.4
AM154 AM170
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
AM40.1 AM40.2
AM500 AM551
AM96.1 AM98.1
ACT-DESCRIPTION Alpha 30 (Lower Case) AM115 AM125
Description The description assigned to associated AM135 AM145
transactions when they are released. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
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
AM40.1 AM40.2
AM500 AM551
AM96.1 AM98.1
ACT-DEBIT-BALANCE Signed 15.2 AM115 AM125
Debit Balance This field stores the total debit AM135 AM145
amount for the batch of asset AM15.1 AM15.2
transactions. The debit balance must AM15.3 AM15.4
equal the credit balance before asset AM154 AM170
transactions can be released. 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 AM500
AM551 AM96.1
AM98.1
ACT-CREDIT-BALANCE Signed 15.2 AM115 AM125
Credit Balance This field stores the total credit AM135 AM145
amount for the batch of asset AM15.1 AM15.2
transactions. The credit balance must AM15.3 AM15.4
equal the debit balance before asset AM154 AM170
transactions can be released. 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 AM500
AM551 AM96.1
AM98.1
AMCTLTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACTSET1 ASSET AM115 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
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 AM41.1
AM500 AM551
...
|