AMASTITCNV – Asset Item Conversion
- System
- Asset Management (AM)
- Prefix
ITC- Primary key
CONVERSION-NBR,SEQ-NUMBER- Fields
- 26
- Updated by
- 2 programs
- Referenced by
- 2 programs
AMASTITCNV is the Asset Item Conversion table in Lawson Asset Management (prefix ITC). It is indexed by CONVERSION-NBR, SEQ-NUMBER (ITCSET1). It is related 1:1 to AMASSETCNV and AMCNVASSET and 1:M to AMASTBKCNV, AMASTMXCNV and AMASTTRCNV. It is updated by AM500 and AM97.1 and referenced by AM96.1 and AM98.1. The table has 26 fields, 1 index and 5 documented relations.
About AMASTITCNV
This file contains non-Lawson asset item information to be converted to asset items in the Lawson Asset Management system.
Fields (26)
Column = COBOL field name without the ITC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ITC-CONVERSION-NBR PKCONVERSION_NBR | Alpha 22 | Required key. This is the number for the asset to be converted. | AM97.1 |
ITC-SEQ-NUMBER PKSEQ_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-NBRITEM_NBR | 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-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the item description. | AM97.1 |
ITC-PURCHASE-DATEPURCHASE_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-QUANTITYITEM_QUANTITY | Numeric 8 | Item quantity is the number of units that make up the asset item. | AM97.1 |
ITC-ITEM-COST-BASEITEM_COST_BASE | Signed 18.2 | This is the cost for the item in General Ledger base currency. | AM97.1 |
ITC-ITEM-TAX-BASEITEM_TAX_BASE | Signed 18.2 | This is the tax on the item in General Ledger base currency. | AM97.1 |
ITC-ITEM-COST-TRANITEM_COST_TRAN | Signed 18.2 | This is the item cost in transaction (asset) currency. | AM97.1 |
ITC-ITEM-TAX-TRANITEM_TAX_TRAN | Signed 18.2 | This is the tax associated with the item in transaction (asset) currency. | AM97.1 |
ITC-PO-NBRPO_NBR | 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-RELEASEPO_RELEASE | Numeric 4 | Used to identify a purchase order release (created from a Blanket or Standing order). | AM97.1 |
ITC-PO-CODEPO_CODE | Alpha 4 | This is the purchase order code. | AM97.1 |
ITC-VENDORVENDOR | Alpha 9 (Right Justified) | This is the vendor's identification code. | AM97.1 |
ITC-VENDOR-NAMEVENDOR_NAME | Alpha 30 | This is the vendor's name for the asset item. | AM97.1 |
ITC-INVOICEINVOICE | Alpha 22 | This number identifies the invoice for the item. | AM97.1 |
ITC-MODEL-NUMBERMODEL_NUMBER | Alpha 30 | This is the model number of the asset item. | AM97.1 |
ITC-SERIAL-NUMBERSERIAL_NUMBER | Alpha 30 | This is the serial number of the asset item. | AM97.1 |
ITC-ACTIVITYACTIVITY | 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-CATEGORYACCT_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-DTLITEM_LOC_DTL | Alpha 14 | This field contains the location detail assigned to the item. | AM97.1 |
ITC-BAR-CODEBAR_CODE | Alpha 30 | This field contains the bar code assigned to the item. | AM97.1 |
ITC-INV-DATEINV_DATE | Numeric 8 (yyyymmdd) | This field contains the date of the last inventory. | — |
ITC-INV-TIMEINV_TIME | Numeric 6 (hhmmss) | This field contains the time of the last inventory. | — |
ITC-INV-ITEM-CONDINV_ITEM_COND | Alpha 1 | This field contains the assessed condition of the item. Valid values are:
| AM97.1 |
ITC-GRANTGRANT | Alpha 30 | — | AM97.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ITCSET1 | CONVERSION-NBR, SEQ-NUMBER | Primary | AM500, AM96.1, AM97.1, AM98.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Amassetcnv | AMASSETCNV | Not Required | ITC-CONVERSION-NBR → ACN-CONVERSION-NBR | |
| Amcnvasset | AMCNVASSET | Not Required | ITC-CONVERSION-NBR → CVA-CONVERSION-NBR |
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |