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 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 AM551 AM96.1
AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACT-ASSET Numeric 10 AM115 AM125
Element: 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 AM190 AM192
identify an asset. Assets are AM20.1 AM20.2
automatically numbered system-wide. 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
AM551 AM96.1
AM98.1
ACT-TRANS-DATE Numeric 8 (yyyymmdd) AM115 AM125
Element: Transaction DaThe 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
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
AM551 AM96.1
AM98.1
ACT-REFERENCE Alpha 10 (Lower Case) AM115 AM125
Element: 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
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
AM551 AM96.1
AM98.1
ACT-DESCRIPTION Alpha 30 (Lower Case) AM115 AM125
Element: Description The description assigned to associated AM135 AM145
transactions when they are released. 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
AM551 AM96.1
AM98.1
ACT-DEBIT-BALANCE Signed 15.2 AM115 AM125
Element: 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. 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
AM551 AM96.1
AM98.1
ACT-CREDIT-BALANCE Signed 15.2 AM115 AM125
Element: Credit BalanceThis 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. 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
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
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
...
|