Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTITCNV


                            AMASTITCNV FILE

                         Asset Item Conversion

This file contains non-Lawson asset item information to be converted to asset
items in the Lawson Asset Management system.


REFERENCED BY

AM96.1    AM98.1

UPDATED BY

AM97.1    AM500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ITC-CONVERSION-NBR     Alpha 22                                  AM97.1
Element: Conversion NumRequired key. This is the number for
                       the asset to be converted.


ITC-SEQ-NUMBER         Numeric 6                                 AM97.1
Element: Sequence NumbeRequired key. The sequence number is a
                       unique number assigned to each
                       transaction to be transferred into the
                       Lawson system.


ITC-ITEM-NBR           Alpha 32                                  AM97.1
Element: Item Number   The user-defined number assigned to the
                       asset item. The item number must be
                       unique within an asset, but can be
                       duplicated from asset to asset.


ITC-DESCRIPTION        Alpha 30  (Lower Case)                    AM97.1
Element: Item DescriptiThis is the item description.

ITC-PURCHASE-DATE      Numeric 8  (yyyymmdd)                     AM97.1
Element: Purchase Date This is the date the asset was
                       purchased. The purchase date can be
                       different from the in-service dates for
                       the depreciation books.


ITC-ITEM-QUANTITY      Numeric 8                                 AM97.1
Element: Item Quantity Item quantity is the number of units
                       that make up the asset item.

ITC-ITEM-COST-BASE     Signed 15.2                               AM97.1
Item Cost Base         This is the cost for the item in
Currency               General Ledger base currency.


ITC-ITEM-TAX-BASE      Signed 15.2                               AM97.1
Item Tax Base          This is the tax on the item in General
Currency               Ledger base currency.

ITC-ITEM-COST-TRAN     Signed 15.2                               AM97.1
Item Cost              This is the item cost in transaction
Transaction Currency   (asset) currency.

ITC-ITEM-TAX-TRAN      Signed 15.2                               AM97.1
Item Tax               This is the tax associated with the
Transaction Currency   item in transaction (asset) currency.

ITC-PO-NBR             Alpha 14                                  AM97.1
Purchase Order         The Purchase Order Number field is for
Number                 your reference. It contains the original
                       purchase order number on which this
                       asset item was included.

ITC-PO-RELEASE         Numeric 4                                 AM97.1
Element: PO Release    Used to identify a purchase order
                       release (created from a Blanket or
                       Standing order).

ITC-PO-CODE            Alpha 4                                   AM97.1
Element: PO Code       This is the purchase order code.

ITC-VENDOR             Alpha 9  (Right Justified)                AM97.1
Element: Vendor        This is the vendor's identification
                       code.

ITC-VENDOR-NAME        Alpha 30                                  AM97.1
Element: Vendor Name   This is the vendor's name for the asset
                       item.


ITC-INVOICE            Alpha 22                                  AM97.1
Element: Invoice       This number identifies the invoice for
                       the item.


ITC-MODEL-NUMBER       Alpha 30                                  AM97.1
Element: Model Number  This is the model number of the asset
                       item.

ITC-SERIAL-NUMBER      Alpha 30                                  AM97.1
Element: Serial Number This is the serial number of the asset
                       item.

ITC-ACTIVITY           Alpha 15                                  AM97.1
Element: 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.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: "posting allowed" and
                       "summary only." Use posting level
                       activities to budget and maintain all
                       posted transactions. Summary activities
                       or macro activities combine information
                       and balances from lower level activities
                       for reporting and inquiries.



ITC-ACCT-CATEGORY      Alpha 5                                   AM97.1
Element: Account CategoAccount 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.


ITC-ITEM-LOC-DTL       Alpha 14                                  AM97.1
Element: Item Loc Dtl  This field contains the location detail
                       assigned to the item.

ITC-BAR-CODE           Alpha 30                                  AM97.1
Element: Bar Code      This field contains the bar code
                       assigned to the item.

ITC-INV-DATE           Numeric 8  (yyyymmdd)
Element: Invoice Date  This field contains the date of the last
                       inventory.

ITC-INV-TIME           Numeric 6  (hhmmss)
Element: Inv Time      This field contains the time of the last
                       inventory.

ITC-INV-ITEM-COND      Alpha 1                                   AM97.1
Element: Inv Item Cond This field contains the assessed
                       condition of the item.  Valid values
                       are:

                       G = Good
                       F = Fair
                       D = Damaged

                         AMASTITCNV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITCSET1   CONVERSION-NBR                                         AM500   AM96.1
          SEQ-NUMBER                                             AM97.1  AM98.1

                         AMASTITCNV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amassetcnv     AMASSETCNV   Not Required

                            ITC-CONVERSION-NBR    -> ACN-CONVERSION-NBR

Amcnvasset     AMCNVASSET   Not Required

                            ITC-CONVERSION-NBR    -> CVA-CONVERSION-NBR

                         AMASTITCNV FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastbkcnv     AMASTBKCNV

                            ITC-CONVERSION-NBR    -> ABC-CONVERSION-NBR
                                                     ABC-BOOK

Amastmxcnv     AMASTMXCNV

                            ITC-CONVERSION-NBR    -> MCV-CONVERSION-NBR
                                                     MCV-MATRIX-CAT

Amasttrcnv     AMASTTRCNV

                            ITC-CONVERSION-NBR    -> TNC-CONVERSION-NBR
                                                     TNC-SEQ-NUMBER