Lawson Insight Technical Documentation |
|
AMTRANS
AMTRANS FILE
Asset Transaction
The Asset Transaction file stores detailed records of asset transactions that
update the general ledger. A record is created or updated in this file each
time an asset is added, transferred, disposed of, or retired, or when
depreciation is calculated.
When they are posted, records in this file are updated to a posted status and
are used for reporting in the Asset Management system.
REFERENCED BY
AM75.1 AM75.2 AM80.1 AM80.2 AM85.1 AM85.2
AM320 AM275 AM277 AM270
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 AM300 AM330 AM40.1
AM40.2 AM40.3 AM40.4 AM41.1 AM41.2 AM500
AM520 AM551 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMT-ASSET Numeric 10 AM115 AM125
Element: Asset The asset number associated with the AM135 AM145
asset transaction. 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
AMT-COMPANY Numeric 4 AM115 AM125
Element: Company The general ledger company number used AM135 AM145
for posting the asset transaction. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-BOOK Alpha 10 AM115 AM125
Element: Book The posting book associated with the AM135 AM145
asset transaction. Books are used by AM15.1 AM15.2
assets for calculating depreciation, AM15.3 AM15.4
replacement cost, and insurance values, AM154 AM190
and for reporting. AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM520
AM551 AM98.1
AMT-SEQ-NUMBER Numeric 6 AM115 AM125
Element: Sequence NumbeA unique number assigned to the asset AM135 AM145
transaction to keep records unique. 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
AMT-LEASE-COMPANY Numeric 4 AM115 AM125
Element: Lease Company The lessor company for a leased asset. AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-LEASE Alpha 19 AM115 AM125
Element: Lease The lease number associated with a AM135 AM145
leased asset. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-ASSET-GROUP Alpha 10
Element: Asset Group The asset group with which the asset is
associated.
AMT-TRANS-DATE Numeric 8 (yyyymmdd) AM115 AM125
Element: Transaction DaThe date of the transaction. Used for AM135 AM145
posting the asset transaction 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
AMT-REFERENCE Alpha 10 (Lower Case) AM115 AM125
Element: Reference The reference number associated with AM135 AM145
the transaction. 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
AMT-DESCRIPTION Alpha 30 (Lower Case) AM115 AM125
Element: Description A description of the asset transaction. 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
AMT-TRANS-STATUS Alpha 1 AM115 AM125
Element: Transaction StThe status of the asset transaction. AM135 AM145
Transactions must have a Released status AM15.1 AM15.2
before they can be posted to the general AM15.3 AM15.4
ledger. Valid values are: AM154 AM170
AM190 AM192
M = Memo AM20.1 AM20.2
U = Unreleased AM20.3 AM20.4
R = Released AM20.5 AM20.6
H = Historical 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
AMT-ACCT-GRP Alpha 10 AM115 AM125
Element: Account Group A user-defined account group which AM135 AM145
identifies the general ledger accounts AM15.1 AM15.2
that are used to create journal entries AM15.3 AM15.4
when assets are processed (added, AM154 AM190
adjusted, transferred, or disposed of). AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-ASSET-TYPE Alpha 10 AM115 AM125
Element: Asset Type An asset type represents a grouping of AM135 AM145
like assets. Asset types are used to AM15.1 AM15.2
group assets into reporting classes and AM15.3 AM15.4
to default common asset definition data. AM154 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-SUB-TYPE Alpha 10 AM115 AM125
Element: Sub Type An asset subtype represents a more AM135 AM145
detailed grouping of assets within an AM15.1 AM15.2
asset type grouping. Asset subtypes are AM15.3 AM15.4
used to group assets into reporting AM154 AM190
classes and allow common asset AM192 AM20.1
definition data to default. Subtypes AM20.2 AM20.4
must be unique within an asset type. AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-ACCT-TYPE Alpha 3 AM115 AM125
Element: Account Type 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
AMT-ACCT-UNIT Alpha 15 AM115 AM125
Element: Accounting UniThe accounting unit used for posting AM135 AM145
the asset transaction to the general AM15.1 AM15.2
ledger. AM15.3 AM15.4
AM154 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-ACCOUNT Numeric 6 AM115 AM125
Element: Account The account number used for posting the AM135 AM145
asset transaction to the general ledger. AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-SUB-ACCT Numeric 4 AM115 AM125
Element: Subaccount The subaccount number used for posting AM135 AM145
the asset transaction to the general AM15.1 AM15.2
ledger. AM15.3 AM15.4
AM154 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-ASSET-PROCESS Alpha 3 AM115 AM125
Element: Asset Process This field identifies the type of Asset AM135 AM145
Management process that caused this AM15.1 AM15.2
record to be created. Valid values are: AM15.3 AM15.4
AM154 AM190
ADD = Addition AM192 AM20.1
ADJ = Adjustment AM20.2 AM20.4
DPR = Depreciation AM20.5 AM21.1
DSP = Disposal AM21.2 AM21.4
TRF = Transfer AM21.5 AM30.1
AM30.2 AM30.3
RIN = Reinstate AM40.1 AM40.2
RAD = Readd AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-ATN-OBJ-ID Numeric 12 AM115 AM125
Element: Object ID A subsystem activity interface AM135 AM145
identification number. Used for Drill AM15.1 AM15.2
Around purposes. 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
AMT-ACTIVITY Alpha 15 AM115 AM125
Element: Activity The activity assigned to the asset AM135 AM145
transaction. AM15.1 AM15.2
AM15.3 AM15.4
Activities are the processes or AM154 AM190
procedures that produce work. Cost AM192 AM20.1
objects (products, services, customers, AM20.2 AM20.4
and so on) are the reasons for AM20.5 AM21.1
performing the activity. Activities and AM21.2 AM21.4
cost object activities are used AM21.5 AM30.1
synonymously in the Lawson Activity AM30.2 AM30.3
Management system. AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-ACCT-CATEGORY Alpha 5 AM115 AM125
Element: Account CategoThe account category assigned to the AM135 AM145
asset transaction. AM15.1 AM15.2
AM15.3 AM15.4
Account categories are groupings of AM154 AM190
costs, revenues, or a combination of AM192 AM20.1
both used for reporting and inquiries AM20.2 AM20.4
for activities in the Lawson Activity AM20.5 AM21.1
Management system. All transactions are AM21.2 AM21.4
posted to an account category within an AM21.5 AM30.1
activity. AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-TRAN-ND Numeric 1 AM115 AM125
Transaction Number AM135 AM145
of Decimals 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
AMT-TRANS-AMOUNT Signed 15.2 AM115 AM125
Element: Transaction AmThe amount of the asset transaction in AM135 AM145
the currency of the transaction. 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
AMT-PROCESS-ASSET Numeric 10 AM115 AM125
Element: Process Asset This field identifies the asset record AM135 AM145
that caused the transaction to be AM15.1 AM15.2
created. This field contains the same AM15.3 AM15.4
value as the Asset field in this file, AM154 AM190
except in the case of a partial AM192 AM20.1
transfer. AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-PROCESS-SEQ Numeric 4 AM115 AM125
Element: Process SequenA system-generated number that is AM135 AM145
assigned to all asset transactions for a AM15.1 AM15.2
given process. AM15.3 AM15.4
AM154 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM40.1 AM40.2
AM40.3 AM40.4
AM41.1 AM41.2
AM500 AM551
AM98.1
AMT-GLT-OBJ-ID Numeric 12 AM115 AM125
Element: Object ID 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
AMT-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM125
Element: Creation Date The date the asset transaction was AM135 AM145
created. 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
AMT-CREATION-TIME Numeric 6 (hhmmss) AM115 AM125
Element: Creation Time The time the asset transaction was AM135 AM145
created. 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
AMT-CREATOR-ID Alpha 10 AM115 AM125
Element: Creator ID The operator responsible for creating AM135 AM145
the asset transaction. 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
AMT-TAG Derived
Element: Tag The tag number associated with the
asset transaction.
AMT-BOOK-CURRENCY Derived
Element: Book Currency The currency assigned to the posting
book.
AMT-AST-LOCATION Derived
Element: Ast Location
AMT-AST-DIVISION Derived
Element: Ast Division
AMT-AST-TYPE Derived
Element: Ast Type
AMT-AST-SUBTYPE Derived
Element: Ast Subtype
AMTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMTSET1 ASSET KeyChange AM115 AM125
TRANS-STATUS AM135 AM145
COMPANY AM15.1 AM15.2
BOOK AM15.3 AM15.4
SEQ-NUMBER 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 AM300
AM330 AM40.1
...
AMTSET10 ASSET KeyChange AM115 AM125
COMPANY AM135 AM145
BOOK AM15.1 AM15.2
SEQ-NUMBER* AM15.3 AM15.4
TRANS-STATUS AM154 AM190
AM192 AM20.1
AM20.2 AM20.4
AM20.5 AM21.1
AM21.2 AM21.4
AM21.5 AM30.1
AM30.2 AM30.3
AM320 AM40.1
AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
...
AMTSET2 COMPANY KeyChange AM135 AM170
TRANS-STATUS AM192 AM20.4
ASSET-PROCESS AM20.5 AM21.4
ASSET AM21.5 AM275
SEQ-NUMBER AM277 AM300
AM40.4 AM41.1
AM41.2 AM520
AMTSET3 COMPANY KeyChange AM85.1 AM85.2
TRANS-STATUS
ACTIVITY
ACCT-CATEGORY
ASSET
SEQ-NUMBER
AMTSET4 PROCESS-ASSET KeyChange, Subset AM115 AM125
PROCESS-SEQ Where TRANS-STATUS = "M" AM135 AM145
TRANS-STATUS Or TRANS-STATUS = "U" AM15.1 AM15.2
ASSET AM15.3 AM15.4
SEQ-NUMBER 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
...
AMTSET5 TRANS-STATUS KeyChange AM270 AM75.1
COMPANY AM75.2
ACCT-UNIT
ACCOUNT
SUB-ACCT
TRANS-DATE
ASSET
SEQ-NUMBER
AMTSET6 TRANS-STATUS KeyChange AM80.1 AM80.2
COMPANY
ASSET-PROCESS
ASSET
SEQ-NUMBER
AMTSET8 GLT-OBJ-ID Subset
ASSET Where GLT-OBJ-ID != Zeroes
SEQ-NUMBER
AMTSET9 ATN-OBJ-ID Subset
ASSET Where ATN-OBJ-ID != Zeroes
SEQ-NUMBER
COMPANY
AMTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
AMT-ASSET -> AST-ASSET (ASTSET1)
Amassetpartial AMASSET Not Required
AMT-PROCESS-ASSET -> AST-ASSET
Ambook AMBOOK Required
AMT-BOOK -> AMB-BOOK
Gltrans GLTRANS Not Required
AMT-GLT-OBJ-ID -> GLT-OBJ-ID
AMTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastmxval AMASTMXVAL
AST-OBJ-ID -> MXT-OBJ-ID
MXT-MATRIX-CAT
Ambktrans AMBKTRANS
AMT-ASSET -> ABK-ASSET
AMT-BOOK -> ABK-BOOK
AMT-COMPANY -> ABK-COMPANY
ABK-TRANS-STATUS
ABK-SEQ-NUMBER
Sltrans SLTRANS
AMT-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|