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 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 AM300 AM40.1
AM40.2 AM40.3 AM40.4 AM41.1 AM41.2 AM500
AM502 AM520 AM551 AM92.1 AM96.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMT-ASSET Numeric 10 AM115 AM117
Element: Asset The asset number associated with the AM125 AM135
asset transaction. 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
AMT-COMPANY Numeric 4 AM115 AM117
Element: Company The general ledger company number used AM125 AM135
for posting the asset transaction. 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-BOOK Alpha 10 AM115 AM117
Element: Book The posting book associated with the AM125 AM135
asset transaction. Books are used by AM145 AM15.1
assets for calculating depreciation, AM15.2 AM15.3
replacement cost, and insurance values, AM15.4 AM154
and for reporting. 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.2
AM500 AM502
AM520 AM551
AM92.1 AM98.1
AMT-SEQ-NUMBER Numeric 6 AM115 AM117
Element: Sequence NumbeA unique number assigned to the asset AM125 AM135
transaction to keep records unique. 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
AMT-LEASE-COMPANY Numeric 4 AM115 AM117
Element: Company The lessor company for a leased asset. AM125 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-LEASE Alpha 19 AM115 AM117
Element: Lease The lease number associated with a AM125 AM135
leased asset. 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.2
AM500 AM502
AM551 AM92.1
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 AM117
Element: Transaction DaThe date of the transaction. Used for AM125 AM135
posting the asset transaction 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.1 AM41.2
AM500 AM502
AM551 AM92.1
AM96.1 AM98.1
AMT-PROCESS-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Date 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
AMT-REFERENCE Alpha 10 (Lower Case) AM115 AM117
Element: Reference The reference number associated with AM125 AM135
the transaction. 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
AMT-DESCRIPTION Alpha 30 (Lower Case) AM115 AM117
Element: Description A description of the asset transaction. 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
AMT-TRANS-STATUS Alpha 1 AM115 AM117
Element: Transaction StThe status of the asset transaction. AM125 AM135
Transactions must have a Released status AM145 AM15.1
before they can be posted to the general AM15.2 AM15.3
ledger. Valid values are: AM15.4 AM154
AM170 AM190
M = Memo AM192 AM20.1
U = Unreleased AM20.2 AM20.3
R = Released AM20.4 AM20.5
H = Historical 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
AMT-ACCT-GRP Alpha 10 AM115 AM117
Element: Acct Grp Am A user-defined account group which AM125 AM135
identifies the general ledger accounts AM145 AM15.1
that are used to create journal entries AM15.2 AM15.3
when assets are processed (added, AM15.4 AM154
adjusted, transferred, or disposed of). 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-ASSET-TYPE Alpha 10 AM115 AM117
Element: Asset Type An asset type represents a grouping of AM125 AM135
like assets. Asset types are used to AM145 AM15.1
group assets into reporting classes and AM15.2 AM15.3
to default common asset definition data. 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-SUB-TYPE Alpha 10 AM115 AM117
Element: Sub Type An asset subtype represents a more AM125 AM135
detailed grouping of assets within an AM145 AM15.1
asset type grouping. Asset subtypes are AM15.2 AM15.3
used to group assets into reporting AM15.4 AM154
classes and allow common asset AM190 AM192
definition data to default. Subtypes AM20.1 AM20.2
must be unique within an asset type. 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-ACCT-TYPE Alpha 3 AM115 AM117
Element: Account Type 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
AMT-ACCT-UNIT Alpha 15 AM115 AM117
Element: Accounting UniThe accounting unit used for posting AM125 AM135
the asset transaction to the general AM145 AM15.1
ledger. 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-ACCOUNT Numeric 6 AM115 AM117
Element: Account The account number used for posting the AM125 AM135
asset transaction to the general ledger. 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-SUB-ACCT Numeric 4 AM115 AM117
Element: Subaccount The subaccount number used for posting AM125 AM135
the asset transaction to the general AM145 AM15.1
ledger. 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-ASSET-PROCESS Alpha 3 AM115 AM117
Element: Asset Process This field identifies the type of Asset AM125 AM135
Management process that caused this AM145 AM15.1
record to be created. Valid values are: AM15.2 AM15.3
AM15.4 AM154
ADD = Addition AM190 AM192
ADJ = Adjustment AM20.1 AM20.2
DPR = Depreciation AM20.4 AM20.5
DSP = Disposal AM21.1 AM21.2
TRF = Transfer AM21.4 AM21.5
AM30.1 AM30.2
RIN = Reinstate AM30.3 AM40.1
RAD = Readd AM40.2 AM40.3
AM40.4 AM41.1
AM41.2 AM500
AM502 AM551
AM92.1 AM98.1
AMT-ATN-OBJ-ID Numeric 12 AM115 AM117
Element: Object ID A subsystem activity interface AM125 AM135
identification number. Used for Drill AM145 AM15.1
Around purposes. 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
AMT-ACTIVITY Alpha 15 AM115 AM117
Element: Activity The activity assigned to the asset AM125 AM135
transaction. AM145 AM15.1
AM15.2 AM15.3
Activities are the processes or AM15.4 AM154
procedures that produce work. Cost AM190 AM192
objects (products, services, customers, AM20.1 AM20.2
and so on) are the reasons for AM20.4 AM20.5
performing the activity. Activities and AM21.1 AM21.2
cost object activities are used AM21.4 AM21.5
synonymously in the Lawson Activity AM30.1 AM30.2
Management system. AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-ACCT-CATEGORY Alpha 5 AM115 AM117
Element: Account CategoThe account category assigned to the AM125 AM135
asset transaction. AM145 AM15.1
AM15.2 AM15.3
Account categories are groupings of AM15.4 AM154
costs, revenues, or a combination of AM190 AM192
both used for reporting and inquiries AM20.1 AM20.2
for activities in the Lawson Activity AM20.4 AM20.5
Management system. All transactions are AM21.1 AM21.2
posted to an account category within an AM21.4 AM21.5
activity. AM30.1 AM30.2
AM30.3 AM40.1
AM40.2 AM40.3
AM40.4 AM41.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-TRAN-ND Numeric 1 AM115 AM117
Transaction Number The number of decimal positions defined AM125 AM135
of Decimals for the transaction currency. 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
AMT-TRANS-AMOUNT Signed 18.2 AM115 AM117
Element: Transaction AmThe amount of the asset transaction in AM125 AM135
the currency of the posting book AM145 AM15.1
transaction. 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
AMT-PROCESS-ASSET Numeric 10 AM115 AM117
Element: Process Asset This field identifies the asset record AM125 AM135
that caused the transaction to be AM145 AM15.1
created. This field contains the same AM15.2 AM15.3
value as the Asset field in this file, AM15.4 AM154
except in the case of a partial AM190 AM192
transfer. 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-PROCESS-SEQ Numeric 6 AM115 AM117
Element: Process SequenA system-generated number that is AM125 AM135
assigned to all asset transactions for a AM145 AM15.1
given process. 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.2
AM500 AM502
AM551 AM92.1
AM98.1
AMT-GLT-OBJ-ID Numeric 12 AM115 AM117
Element: Object ID This is a subsystem GL interface AM125 AM135
identification number. It is used for AM145 AM15.1
Drill Around purposes. 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
AMT-CREATION-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Creation Date The date the asset transaction was AM125 AM135
created. 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
AMT-CREATION-TIME Numeric 6 (hhmmss) AM115 AM117
Element: Creation Time The time the asset transaction was AM125 AM135
created. 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
AMT-CREATOR-ID Alpha 10 AM115 AM117
Element: Creator ID The operator responsible for creating AM125 AM135
the asset transaction. 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
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 AM117
TRANS-STATUS AM125 AM135
COMPANY AM145 AM15.1
BOOK AM15.2 AM15.3
SEQ-NUMBER 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 AM40.1
...
AMTSET10 ASSET KeyChange AM115 AM117
COMPANY AM125 AM135
BOOK AM145 AM15.1
SEQ-NUMBER* AM15.2 AM15.3
TRANS-STATUS 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 AM320
AM40.1 AM40.2
AM40.3 AM40.4
AM41.2 AM500
...
AMTSET2 COMPANY KeyChange AM135 AM170
TRANS-STATUS AM190 AM192
ASSET-PROCESS AM20.4 AM20.5
ASSET AM21.4 AM21.5
SEQ-NUMBER AM275 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 AM117
PROCESS-SEQ Where TRANS-STATUS = "M" AM125 AM135
TRANS-STATUS Or TRANS-STATUS = "U" AM145 AM15.1
ASSET AM15.2 AM15.3
SEQ-NUMBER 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
...
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 KeyChange, Subset
ASSET Where GLT-OBJ-ID != Zeroes
SEQ-NUMBER
AMTSET9 ATN-OBJ-ID KeyChange, 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
|