AMASTITCNV

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITCSET1 CONVERSION-NBR
SEQ-NUMBER
AM500 AM96.1
AM97.1 AM98.1


AMASTITCNV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:47:06 2016

Home
Contact Us



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