Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTTRCNV


                            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