Asset Item Conversion

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

AM97.1

AM500

AM96.1

AM98.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ITC-CONVERSION-NBR Element: Conversion Number	Alpha 22 Required key. This is the number for the asset to be converted.	AM97.1
ITC-SEQ-NUMBER Element: Sequence Number	Numeric 6 Required key. The sequence number is a unique number assigned to each transaction to be transferred into the Lawson system.	AM97.1
ITC-ITEM-NBR Element: Item Number	Alpha 32 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.	AM97.1
ITC-DESCRIPTION Element: Item Description	Alpha 30 (Lower Case) This is the item description.	AM97.1
ITC-PURCHASE-DATE Element: Purchase Date	Numeric 8 (yyyymmdd) This is the date the asset was purchased. The purchase date can be different from the in-service dates for the depreciation books.	AM97.1
ITC-ITEM-QUANTITY Element: Item Quantity	Numeric 8 Item quantity is the number of units that make up the asset item.	AM97.1
ITC-ITEM-COST-BASE Item Cost Base Currency	Signed 18.2 This is the cost for the item in General Ledger base currency.	AM97.1
ITC-ITEM-TAX-BASE Item Tax Base Currency	Signed 18.2 This is the tax on the item in General Ledger base currency.	AM97.1
ITC-ITEM-COST-TRAN Item Cost Transaction Currency	Signed 18.2 This is the item cost in transaction (asset) currency.	AM97.1
ITC-ITEM-TAX-TRAN Item Tax Transaction Currency	Signed 18.2 This is the tax associated with the item in transaction (asset) currency.	AM97.1
ITC-PO-NBR Purchase Order Number	Alpha 14 The Purchase Order Number field is for your reference. It contains the original purchase order number on which this asset item was included.	AM97.1
ITC-PO-RELEASE Element: PO Release	Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order).	AM97.1
ITC-PO-CODE Element: PO Code	Alpha 4 This is the purchase order code.	AM97.1
ITC-VENDOR Element: Vendor	Alpha 9 (Right Justified) This is the vendor's identification code.	AM97.1
ITC-VENDOR-NAME Element: Vendor Name	Alpha 30 This is the vendor's name for the asset item.	AM97.1
ITC-INVOICE Element: Invoice	Alpha 22 This number identifies the invoice for the item.	AM97.1
ITC-MODEL-NUMBER Element: Model Number	Alpha 30 This is the model number of the asset item.	AM97.1
ITC-SERIAL-NUMBER Element: Serial Number	Alpha 30 This is the serial number of the asset item.	AM97.1
ITC-ACTIVITY Element: Activity	Alpha 15 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.	AM97.1
ITC-ACCT-CATEGORY Element: Account Category	Alpha 5 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.	AM97.1
ITC-ITEM-LOC-DTL Element: Item Loc Dtl	Alpha 14 This field contains the location detail assigned to the item.	AM97.1
ITC-BAR-CODE Element: Bar Code	Alpha 30 This field contains the bar code assigned to the item.	AM97.1
ITC-INV-DATE Element: Inv Date	Numeric 8 (yyyymmdd) This field contains the date of the last inventory.
ITC-INV-TIME Element: Inv Time	Numeric 6 (hhmmss) This field contains the time of the last inventory.
ITC-INV-ITEM-COND Element: Inv Item Cond	Alpha 1 This field contains the assessed condition of the item. Valid values are: G = Good F = Fair D = Damaged	AM97.1
ITC-GRANT Element: Grant	Alpha 30	AM97.1

AMASTITCNV FILE INDEX

AMASTITCNV FILE RELATIONS

ONE TO ONE RELATIONS

AMASTITCNV FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.