AMASTTRCNV

Asset Transaction Conversion
UPDATED BY
AM500 AM93.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TNC-CONVERSION-NBR
Element: Conversion Nbr
Alpha 22
This 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
Element: Seq Number
Numeric 6
A 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
Element: Company
Numeric 4
This is the asset company number.
AM93.1
TNC-BOOK
Element: Book
Alpha 10
The book to which the transaction is posted.
AM93.1
TNC-LEASE-COMPANY
Element: Company
Numeric 4
The lease company number.
AM93.1
TNC-LEASE
Element: Lease
Alpha 19
The name of the lease to which the asset is assigned.
AM93.1
TNC-ASSET-GROUP
Element: Asset Group
Alpha 10
The asset group to which the asset belongs.
AM93.1
TNC-TRANS-DATE
Element: Trans Date
Numeric 8 (yyyymmdd)
The date the transaction was posted.
AM93.1
TNC-TRANS-AMOUNT
Element: Intl Amt
Signed 18.2
The signed associated with this transaction in the currency of the posting book.
AM93.1
TNC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the transaction description.
AM93.1
TNC-ACCT-GRP
Element: Acct Grp Am
Alpha 10
The account group identifying the general ledger accounts that are used to create journal entries when the asset is processed.
AM93.1
TNC-ASSET-TYPE
Element: Asset Type
Alpha 10
The 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
Element: Sub Type
Alpha 10
The asset type associated with the asset. Must be unique within the asset type.
AM93.1
TNC-ACCT-TYPE
Element: Acct Type
Alpha 3
This 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
Element: Acct Unit
Alpha 15
The accounting unit used to post the transaction to the General Ledger.
AM93.1
TNC-ACCOUNT
Element: Account
Numeric 6
The account used to post the transaction to the General Ledger.
AM93.1
TNC-SUB-ACCT
Element: Sub Acct
Numeric 4
The subaccount used to post the transaction to the General Ledger.
AM93.1
TNC-ASSET-PROCESS
Element: Asset Process
Alpha 3
The 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
Element: Activity
Alpha 15
The activity assigned to the transaction.
AM93.1
TNC-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The account category assigned to the transaction. The account category assigned to the transaction.
AM93.1


AMASTTRCNV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TNCSET1 CONVERSION-NBR
SEQ-NUMBER
AM500 AM93.1


AMASTTRCNV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amassetcnv AMASSETCNV Not Required
TNC-CONVERSION-NBR->ACN-CONVERSION-NBR
Amcnvasset AMCNVASSET Not Required
TNC-CONVERSION-NBR->CVA-CONVERSION-NBR


AMASTTRCNV FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amastbkcnv AMASTBKCNV
TNC-CONVERSION-NBR->ABC-CONVERSION-NBR
  ABC-BOOK
Amastitcnv AMASTITCNV
TNC-CONVERSION-NBR->ITC-CONVERSION-NBR
  ITC-SEQ-NUMBER
Amastmxcnv AMASTMXCNV
TNC-CONVERSION-NBR->MCV-CONVERSION-NBR
  MCV-MATRIX-CAT


File created: Thu Jun 09 11:05:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.