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