AMASTTRCNV – Asset Transaction Conversion

System
Asset Management (AM)
Prefix
TNC
Primary key
CONVERSION-NBR, SEQ-NUMBER
Fields
20
Updated by
2 programs
Referenced by
0 programs

AMASTTRCNV is the Asset Transaction Conversion table in Lawson Asset Management (prefix TNC). It is indexed by CONVERSION-NBR, SEQ-NUMBER (TNCSET1). It is related 1:1 to AMASSETCNV and AMCNVASSET and 1:M to AMASTBKCNV, AMASTITCNV and AMASTMXCNV. It is updated by AM500 and AM93.1. The table has 20 fields, 1 index and 5 documented relations.

About AMASTTRCNV

No description in the Lawson data dictionary.

Fields (20)

Column = COBOL field name without the TNC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
TNC-CONVERSION-NBR PK
CONVERSION_NBR		Alpha 22This number associates the transaction with the asset. This number can also be the Lawson-assigned asset number for use when doing just transaction conversion. If using the conversion by asset number option on AM500, be sure to zerofill and right-justify this field.AM93.1
TNC-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be transferred into the Lawson system. This number will not be the same as the number assigned to the AMTRANS record.AM93.1
TNC-COMPANY
COMPANY		Numeric 4This is the asset company number.AM93.1
TNC-BOOK
BOOK		Alpha 10The book to which the transaction is posted.AM93.1
TNC-LEASE-COMPANY
LEASE_COMPANY		Numeric 4The lease company number.AM93.1
TNC-LEASE
LEASE		Alpha 19The name of the lease to which the asset is assigned.AM93.1
TNC-ASSET-GROUP
ASSET_GROUP		Alpha 10The asset group to which the asset belongs.AM93.1
TNC-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)The date the transaction was posted.AM93.1
TNC-TRANS-AMOUNT
TRANS_AMOUNT		Signed 18.2The signed associated with this transaction in the currency of the posting book.AM93.1
TNC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the transaction description.AM93.1
TNC-ACCT-GRP
ACCT_GRP		Alpha 10The account group identifying the general ledger accounts that are used to create journal entries when the asset is processed.AM93.1
TNC-ASSET-TYPE
ASSET_TYPE		Alpha 10The asset type assigned to the asset, identifying the general ledger accounts used to store the asset, depreciation expense, and accumulated depreciation amounts.AM93.1
TNC-SUB-TYPE
SUB_TYPE		Alpha 10The asset type associated with the asset. Must be unique within the asset type.AM93.1
TNC-ACCT-TYPE
ACCT_TYPE		Alpha 3This field contains the type of account to which the transaction is posted. Valid values are:
  • AST Asset
  • ACM Accumulated Depreciation
  • EXP Depreciation Expense
  • PRO Proceeds
  • GAN Gain
  • LOS Loss
  • CLR Clearing
  • COS Disposal Expense
  • DGN Deferred Gain
  • DLS Deferred Loss
AM93.1
TNC-ACCT-UNIT
ACCT_UNIT		Alpha 15The accounting unit used to post the transaction to the General Ledger.AM93.1
TNC-ACCOUNT
ACCOUNT		Numeric 6The account used to post the transaction to the General Ledger.AM93.1
TNC-SUB-ACCT
SUB_ACCT		Numeric 4The subaccount used to post the transaction to the General Ledger.AM93.1
TNC-ASSET-PROCESS
ASSET_PROCESS		Alpha 3The asset process that caused the transaction to be created. Valid values are:
  • ADD Addition
  • ADJ Adjustment
  • DPR Depreciation
  • DSP Disposal
  • TRF Transfer
AM93.1
TNC-ACTIVITY
ACTIVITY		Alpha 15The activity assigned to the transaction.AM93.1
TNC-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The account category assigned to the transaction. The account category assigned to the transaction.AM93.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TNCSET1CONVERSION-NBR, SEQ-NUMBERPrimaryAM500, AM93.1

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmassetcnvAMASSETCNVNot RequiredTNC-CONVERSION-NBR → ACN-CONVERSION-NBR
AmcnvassetAMCNVASSETNot RequiredTNC-CONVERSION-NBR → CVA-CONVERSION-NBR

One to many (3) — child tables

RelationTableRulesConditionField map
AmastbkcnvAMASTBKCNVTNC-CONVERSION-NBR → ABC-CONVERSION-NBR, → ABC-BOOK
AmastitcnvAMASTITCNVTNC-CONVERSION-NBR → ITC-CONVERSION-NBR, → ITC-SEQ-NUMBER
AmastmxcnvAMASTMXCNVTNC-CONVERSION-NBR → MCV-CONVERSION-NBR, → MCV-MATRIX-CAT

Programs

Updated by (2)