AMASTTRCNV FILE
UPDATED BY
AM500 AM93.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TNC-CONVERSION-NBR Alpha 22 AM93.1
Conversion Nbr 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.
TNC-SEQ-NUMBER Numeric 6 AM93.1
Record Sequence A unique number assigned to each
Number transaction to be transferred into the
Lawson system. This number will not be
the same as the number assigned to the
AMTRANS record.
TNC-COMPANY Numeric 4 AM93.1
Company This is the asset company number.
TNC-BOOK Alpha 10 AM93.1
Book The book to which the transaction is
posted.
TNC-LEASE-COMPANY Numeric 4 AM93.1
Lease Company The lease company number.
TNC-LEASE Alpha 19 AM93.1
Lease The name of the lease to which the asset
is assigned.
TNC-ASSET-GROUP Alpha 10 AM93.1
Asset Group The asset group to which the asset
belongs.
TNC-TRANS-DATE Numeric 8 (yyyymmdd) AM93.1
Transaction Date The date the transaction was posted.
TNC-TRANS-AMOUNT Signed 15.2 AM93.1
Trans Amount The signed associated with this
transaction in the currency of the
posting book.
TNC-DESCRIPTION Alpha 30 (Lower Case) AM93.1
Description This field contains the transaction
description.
TNC-ACCT-GRP Alpha 10 AM93.1
Account Group The account group identifying the
general ledger accounts that are used
to create journal entries when the
asset is processed.
TNC-ASSET-TYPE Alpha 10 AM93.1
Asset Type The asset type assigned to the asset,
identifying the general ledger accounts
used to store the asset, depreciation
expense, and accumulated depreciation
amounts.
TNC-SUB-TYPE Alpha 10 AM93.1
Sub Type The asset type associated with the
asset. Must be unique within the asset
type.
TNC-ACCT-TYPE Alpha 3 AM93.1
Account Type 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
TNC-ACCT-UNIT Alpha 15 AM93.1
Accounting Unit The accounting unit used to post the
transaction to the General Ledger.
TNC-ACCOUNT Numeric 6 AM93.1
Account The account used to post the transaction
to the General Ledger.
TNC-SUB-ACCT Numeric 4 AM93.1
Subaccount The subaccount used to post the
transaction to the General Ledger.
TNC-ASSET-PROCESS Alpha 3 AM93.1
Asset Process The asset process that caused the
transaction to be created. Valid values
are:
ADD = Addition
ADJ = Adjustment
DPR = Depreciation
DSP = Disposal
TRF = Transfer
TNC-ACTIVITY Alpha 15 AM93.1
Activity The activity assigned to the
transaction.
TNC-ACCT-CATEGORY Alpha 5 AM93.1
Account Category The account category assigned to the
transaction.
The account category assigned to the
transaction.
AMASTTRCNV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TNCSET1 CONVERSION-NBR AM500 AM93.1
SEQ-NUMBER
AMASTTRCNV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
