Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            AMASTITTRF FILE

                          Asset Item Transfer

This file contains historical asset item information related to transfers.

REFERENCED BY

AM170     AM235

UPDATED BY

AM135     AM30.1    AM30.2    AM300     AM956

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ITR-ASSET            Numeric 10                                  AM135   AM30.1
Asset                Key field. This is the transfer-from        AM30.2  AM956
                     asset. The asset number contains up  to
                     ten numeric characters that uniquely
                     identify an asset. Assets are
                     automatically numbered system-wide.


ITR-TO-ASSET         Numeric 10                                  AM135   AM30.1
To Asset             This is the transfer-to asset. The          AM30.2  AM956
                     asset number contains up to ten numeric
                     characters that uniquely identify an
                     asset. Assets are automatically numbered
                     system-wide.


ITR-PROCESS-SEQ      Numeric 4                                   AM135   AM30.1
Process Sequence     Key field. This is the sequence number      AM30.2  AM956
                     for this transfer process.


ITR-TRANSFER-DATE    Numeric 8  (yyyymmdd)                       AM135   AM30.1
Transfer Date        This is the date of the transfer.           AM30.2  AM956

ITR-TRANSFER-TYPE    Alpha 1                                     AM135   AM30.1
Transfer Type        This is type of the transfer:               AM30.2  AM956
                     intracompany or intercompany

                     T = Intracompany
                     I = Intercompany

ITR-SEQ-NUMBER       Numeric 6                                   AM135   AM30.1
Sequence Number      A unique number assigned to each            AM30.2  AM956
                     transaction in the Lawson system. This
                     is the from-asset sequence number for
                     the transfer.


ITR-TO-SEQ-NUMBER    Numeric 6                                   AM135   AM30.1
To Sequence Number   A unique number assigned to each            AM30.2  AM956
                     transaction in the Lawson system. This
                     is the to-asset sequence number for the
                     transfer.


ITR-ITEM-NBR         Alpha 32                                    AM135   AM30.1
Item Number          The number assigned to the asset item.      AM30.2  AM956
                     The item number must be unique within an
                     asset, but can be duplicated from asset
                     to asset. The item number identifies an
                     item of an asset composed of different
                     elements but depreciated as a common
                     asset unit.


ITR-DESCRIPTION      Alpha 30  (Lower Case)                      AM135   AM30.1
Description          The item description.                       AM30.2  AM956

ITR-PURCHASE-DATE    Numeric 8  (yyyymmdd)                       AM135   AM30.1
Purchase Date        This is the purchase date for the           AM30.2  AM956
                     asset. The purchase date can be
                     different from the in-service dates used
                     for the depreciation books.


ITR-ITEM-QUANTITY    Numeric 8                                   AM135   AM30.1
Item Quantity        The number of units that make up the        AM30.2  AM956
                     from-asset item. Each unit of an item is
                     exactly the same as every other unit of
                     the item.


ITR-TO-IT-QUANTITY   Numeric 8                                   AM135   AM30.1
To Item Quantity     The number of units that make up the        AM30.2  AM956
                     to-asset item. Each unit of an item
                     is exactly the same as every other unit
                     of the item.



ITR-ITEM-COST-BASE   Signed 15.2                                 AM135   AM30.1
Item Cost Base       This is the item cost in the base           AM30.2  AM956
                     currency for the from-asset.


ITR-TO-IT-CST-BASE   Signed 15.2                                 AM135   AM30.1
To Item Cost Base    This is the item cost in the base           AM30.2  AM956
                     currency for the to-asset.

ITR-ITEM-TAX-BASE    Signed 15.2                                 AM135   AM30.1
Item Tax Base        This is the item tax for the from-asset     AM30.2  AM956
                     in the base currency.


ITR-TO-IT-TAX-BASE   Signed 15.2                                 AM135   AM30.1
To Item Tax Base     This is the item tax for the to-asset       AM30.2  AM956
                     in the base currency.


ITR-ITEM-COST-TRAN   Signed 15.2                                 AM135   AM30.1
Item Cost Tran       This is the item cost for the               AM30.2  AM956
                     from-asset in the transaction currency.


ITR-TO-IT-CST-TRAN   Signed 15.2                                 AM135   AM30.1
To Item Cost Tran     This is the item cost for the to-asset     AM30.2  AM956
                     in the transaction currency.


ITR-ITEM-TAX-TRAN    Signed 15.2                                 AM135   AM30.1
Item Tax Tran        This is the item tax for the from-asset     AM30.2  AM956
                     in the transaction currency.


ITR-TO-IT-TAX-TRAN   Signed 15.2                                 AM135   AM30.1
To Item Tax Tran     This is the item tax for the to-asset       AM30.2  AM956
                     in the transaction currency.


ITR-BASE-ND          Numeric 1                                   AM135   AM30.1
Base Number of       The number of decimal positions defined     AM30.2  AM956
Decimals             for the company base currency.


ITR-TRAN-ND          Numeric 1                                   AM135   AM30.1
Tran Number of       The number of decimal positions defined     AM30.2  AM956
Decimals             for the transaction currency.


ITR-PO-NBR           Alpha 14                                    AM135   AM956
PO Number            The purchase order number field is an
                     optional field for your reference. You
                     can enter the original purchase order
                     number on which this asset was included.



ITR-PO-RELEASE       Numeric 6                                   AM135
PO Release           Used to identify a purchase order
                     release (created from a Blanket or
                     Standing order).

ITR-PO-CODE          Alpha 4                                     AM135
PO Code              This is the purchase order code.

ITR-VENDOR           Alpha 9                                     AM135   AM30.1
Vendor               The vendor's identification code.           AM30.2  AM956



ITR-VENDOR-NAME      Alpha 30                                    AM135   AM30.1
Vendor Name          This is the name of the vendor from         AM30.2  AM956
                     whom the asset was purchased.


ITR-INVOICE          Alpha 22                                    AM135   AM30.1
Invoice              This is the invoice identifier.             AM30.2  AM956

ITR-SUFFIX           Numeric 3                                   AM135   AM30.1
Suffix               This is the suffix for the invoice.         AM30.2  AM956

ITR-DIST-SEQ-NBR     Numeric 4                                   AM135   AM30.1
Distribution         This is the distribution sequence           AM30.2  AM956
Sequence Number      number for the item.


ITR-MODEL-NUMBER     Alpha 30                                    AM135   AM30.1
Model Number         This is model number of the item.           AM30.2  AM956

ITR-SERIAL-NUMBER    Alpha 30                                    AM135   AM30.1
Serial Number        This is the serial number of the item.      AM30.2  AM956

ITR-ACTIVITY         Alpha 15                                    AM135   AM30.1
Activity             This is the activity associated with        AM30.2  AM956
                     the asset. Activities are the processes
                     or procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity. Activities and
                     cost object activities are used
                     synonymously in the Lawson Activity
                     Management system. Direct costs are
                     posted to activities, and indirect costs
                     are allocated to activities based on
                     activity drivers.


ITR-ACCT-CATEGORY    Alpha 5                                     AM135   AM956
Account Category     This is the account category associated
                     with the asset. Account categories are
                     groupings of costs, revenues, or a
                     combination of both used for reporting
                     and inquiries for activities in the
                     Lawson Activity Management system. All
                     transactions are  posted to an account
                     category within an activity. You can
                     assign a specific General Ledger account
                     or range of accounts (company,
                     accounting unit, account, and
                     subaccount) that make up the
                     transactions posted to an account
                     category.


                         AMASTITTRF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITRSET1   ASSET                                                  AM135   AM170
          PROCESS-SEQ                                            AM235   AM30.1
          SEQ-NUMBER                                             AM30.2  AM300
                                                                 AM956

                         AMASTITTRF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastitem      AMASTITEM    Required

                            ITR-ASSET         -> ASI-ASSET
                            ITR-SEQ-NUMBER    -> ASI-SEQ-NUMBER