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.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
AMT-ASSET
Element: Asset | Numeric 10
The asset number associated with the
asset transaction.
The asset number contains up to ten
numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
|
|
AMT-COMPANY
Element: Company | Numeric 4
The general ledger company number used
for posting the asset transaction.
|
|
AMT-BOOK
Element: Book | Alpha 10
The posting book associated with the
asset transaction. Books are used by
assets for calculating depreciation,
replacement cost, and insurance values,
and for reporting.
|
|
AMT-SEQ-NUMBER
Element: Sequence Number | Numeric 6
A unique number assigned to the asset
transaction to keep records unique.
|
|
AMT-LEASE-COMPANY
Element: Company | Numeric 4
The lessor company for a leased asset.
|
|
AMT-LEASE
Element: Lease | Alpha 19
The lease number associated with a
leased asset.
|
|
AMT-ASSET-GROUP
Element: Asset Group | Alpha 10
The asset group with which the asset is
associated.
|
|
AMT-TRANS-DATE
Element: Transaction Date | Numeric 8 (yyyymmdd)
The date of the transaction. Used for
posting the asset transaction to the
general ledger.
|
|
AMT-PROCESS-DATE
Element: Date | Numeric 8 (yyyymmdd)
This field displays the system date
when this was created.
|
|
AMT-REFERENCE
Element: Reference | Alpha 10 (Lower Case)
The reference number associated with
the transaction.
|
|
AMT-DESCRIPTION
Element: Description | Alpha 30 (Lower Case)
A description of the asset transaction.
|
|
AMT-TRANS-STATUS
Element: Transaction Status | Alpha 1
The status of the asset transaction.
Transactions must have a Released status
before they can be posted to the general
ledger. Valid values are:
M = Memo
U = Unreleased
R = Released
H = Historical
|
|
AMT-ACCT-GRP
Element: Acct Grp Am | Alpha 10
|
|
AMT-ASSET-TYPE
Element: Asset Type | Alpha 10
An asset type represents a grouping of
like assets. Asset types are used to
group assets into reporting classes and
to default common asset definition data.
|
|
AMT-SUB-TYPE
Element: Sub Type | Alpha 10
An asset subtype represents a more
detailed grouping of assets within an
asset type grouping. Asset subtypes are
used to group assets into reporting
classes and allow common asset
definition data to default. Subtypes
must be unique within an asset type.
|
|
AMT-ACCT-TYPE
Element: Acct Type | Alpha 3
|
|
AMT-ACCT-UNIT
Element: Accounting Unit | Alpha 15
The accounting unit used for posting
the asset transaction to the general
ledger.
|
|
AMT-ACCOUNT
Element: Account | Numeric 6
The account number used for posting the
asset transaction to the general ledger.
|
|
AMT-SUB-ACCT
Element: Subaccount | Numeric 4
The subaccount number used for posting
the asset transaction to the general
ledger.
|
|
AMT-ASSET-PROCESS
Element: Asset Process | Alpha 3
This field identifies the type of Asset
Management process that caused this
record to be created. Valid values are:
ADD = Addition
ADJ = Adjustment
DPR = Depreciation
DSP = Disposal
TRF = Transfer
RIN = Reinstate
RAD = Readd |
|
AMT-ATN-OBJ-ID
Element: Object ID | Numeric 12
A subsystem activity interface
identification number. Used for Drill
Around purposes.
|
|
AMT-ACTIVITY
Element: Activity | Alpha 15
The activity assigned to the asset
transaction.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Lawson Activity
Management system.
|
|
AMT-ACCT-CATEGORY
Element: Account Category | Alpha 5
The account category assigned to the
asset transaction.
Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Lawson Activity
Management system. All transactions are
posted to an account category within an
activity.
|
|
AMT-TRAN-ND
Transaction Number
of Decimals | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
AMT-TRANS-AMOUNT
Element: Transaction Amount | Signed 18.2
The amount of the asset transaction in
the currency of the posting book
transaction.
|
|
AMT-PROCESS-ASSET
Element: Process Asset | Numeric 10
This field identifies the asset record
that caused the transaction to be
created. This field contains the same
value as the Asset field in this file,
except in the case of a partial
transfer.
|
|
AMT-PROCESS-SEQ
Element: Process Sequence | Numeric 6
A system-generated number that is
assigned to all asset transactions for a
given process.
|
|
AMT-GLT-OBJ-ID
Element: Object ID | Numeric 12
This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
|
|
AMT-CREATION-DATE
Element: Creation Date | Numeric 8 (yyyymmdd)
The date the asset transaction was
created.
|
|
AMT-CREATION-TIME
Element: Creation Time | Numeric 6 (hhmmss)
The time the asset transaction was
created.
|
|
AMT-CREATOR-ID
Element: Creator ID | Alpha 10
The operator responsible for creating
the asset transaction.
|
|
AMT-TAG
Element: Tag | Derived
The tag number associated with the
asset transaction.
|
|
AMT-BOOK-CURRENCY
Element: Book Currency | Derived
The currency assigned to the posting
book.
|
|
AMT-AST-LOCATION
Element: Ast Location | Derived
|
|
AMT-AST-DIVISION
Element: Ast Division | Derived
|
|
AMT-AST-TYPE
Element: Ast Type | Derived
|
|
AMT-AST-SUBTYPE
Element: Ast Subtype | Derived
|
|
| NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
| AMTSET1 |
ASSET
TRANS-STATUS
COMPANY
BOOK
SEQ-NUMBER
|
|
|
| AMTSET10 |
ASSET
SEQ-NUMBER*
COMPANY
BOOK
TRANS-STATUS
|
|
|
| AMTSET2 |
COMPANY
TRANS-STATUS
ASSET-PROCESS
ASSET
SEQ-NUMBER
|
|
|
| AMTSET3 |
COMPANY
TRANS-STATUS
ACTIVITY
ACCT-CATEGORY
ASSET
SEQ-NUMBER
|
|
|
| AMTSET4 |
PROCESS-ASSET
PROCESS-SEQ
TRANS-STATUS
ASSET
SEQ-NUMBER
|
|
KeyChange, Subset |
| Where | | TRANS-STATUS |
= | "M" | |
| Or | | TRANS-STATUS |
= | "U" | |
|
|
| AMTSET5 |
TRANS-STATUS
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCT
TRANS-DATE
ASSET
SEQ-NUMBER
|
|
|
| AMTSET6 |
TRANS-STATUS
COMPANY
ASSET-PROCESS
ASSET
SEQ-NUMBER
|
|
|
| AMTSET8 |
GLT-OBJ-ID
ASSET
SEQ-NUMBER
|
|
KeyChange, Subset |
| Where | | GLT-OBJ-ID |
!= | Zeroes | |
|
|
| AMTSET9 |
ATN-OBJ-ID
ASSET
SEQ-NUMBER
COMPANY
|
|
KeyChange, Subset |
| Where | | ATN-OBJ-ID |
!= | Zeroes | |
|
|
