AMASSETCNV – Asset Conversion
- System
- Asset Management (AM)
- Prefix
ACN- Primary key
CONVERSION-NBR- Fields
- 25
- Updated by
- 2 programs
- Referenced by
- 3 programs
AMASSETCNV is the Asset Conversion table in Lawson Asset Management (prefix ACN). It is indexed by CONVERSION-NBR (ACNSET1); alternate indexes: ACNSET2 and ACNSET3. It is related 1:1 to AMASTCVBOD and AMCNVASSET and 1:M to AMASTBKCNV, AMASTITCNV, AMASTMXCNV and AMASTTRCNV. It is updated by AM500 and AM96.1 and referenced by AM97.1, AM98.1 and AMBD.2. The table has 25 fields, 3 indexes and 6 documented relations.
About AMASSETCNV
This file contains non-Lawson asset information to be converted to the Lawson Asset Management system.
Fields (25)
Column = COBOL field name without the ACN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ACN-CONVERSION-NBR PKCONVERSION_NBR | Alpha 22 | Required key. This is the unique number to ensure that each record is unique. This number also determines the order in which assets are added. | AM96.1 |
ACN-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This is the conversion number description. | AM96.1 |
ACN-TAG-NBRTAG_NBR | Alpha 12 | This is the tag number for the asset. | AM96.1 |
ACN-ASSET-GROUPASSET_GROUP | Alpha 10 | An asset group allows you to group related assets that need to depreciate separately; for example, a new roof on a factory building. The building is depreciated over 30 years, but the new roof is depreciated over 15 years. | AM96.1 |
ACN-ASSET-CATEGORYASSET_CATEGORY | Alpha 1 | This is the asset category: depreciable or nondepreciable. | AM96.1 |
ACN-SIMULATEDSIMULATED | Alpha 1 | This field indicates whether the asset is simulated. Simulated assets are imitative representations, not real assets. They can be used to experiment and test strategies. The default for this field is No. | AM96.1 |
ACN-WORK-IN-PROCWORK_IN_PROC | Alpha 1 | This field indicates whether the asset is a work-in-process asset. Work-in-process assets are real but not yet complete. If this field is Yes, the asset is on hold and cannot be released. The default for this field is No. | AM96.1 |
ACN-TAX-EXEMPTTAX_EXEMPT | Alpha 1 | This field indicates whether the asset is tax exempt. The default is No. | AM96.1 |
ACN-USEDUSED | Alpha 1 | This field indicates whether the asset is used. The default is No. | AM96.1 |
ACN-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This is the base currency defined for the company in the Lawson General Ledger system. | AM96.1 |
ACN-COMPANYCOMPANY | Numeric 4 | This is the company number for the asset. | AM96.1 |
ACN-LOCATION-NAMELOCATION_NAME | Alpha 15 | This is the location for the asset. | AM96.1 |
ACN-DIVISIONDIVISION | Alpha 15 | This is the division for the asset. | AM96.1 |
ACN-ASSET-TYPEASSET_TYPE | Alpha 10 | This is the asset type. Asset types are user-defined and represent a grouping of like assets. Asset types are used to group assets into reporting classes and to default common asset definition data. | AM96.1 |
ACN-SUB-TYPESUB_TYPE | Alpha 10 | This is the asset subtype. An asset subtype represents a more detailed grouping of assets within an asset type. Asset subtypes are used to group assets into reporting classes and allow common asset definition data to default. | AM96.1 |
ACN-LEASE-COMPANYLEASE_COMPANY | Numeric 4 | The lessor company for the converted leased asset. | AM96.1 |
ACN-LEASELEASE | Alpha 19 | The lease number for the converted leased asset. | AM96.1 |
ACN-ACCT-GRPACCT_GRP | Alpha 10 | This is the account group for the asset. Account groups are user-defined and are used to identify the general ledger accounts used to create journal entries when assets are processed (added, adjusted, transferred, or disposed of). | AM96.1 |
ACN-ACCT-UNITACCT_UNIT | Alpha 15 | This is the accounting unit associated with the asset. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | AM96.1 |
ACN-AU-GROUPAU_GROUP | Alpha 10 | Accounting unit groups group and identify the accounting units to use when you create journal entries for adding, adjusting, transferring, or disposing of assets. Changes to accounting unit groups are dynamic, affecting all assets using the accounting unit group. Accounting unit group names are user-definable, and accounting unit groups are set up by company. | AM96.1 |
ACN-DEP-EXP-ACTVTYDEP_EXP_ACTVTY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | AM96.1 |
ACN-DEP-ACCT-CATDEP_ACCT_CAT | Alpha 5 | Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the 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 using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru | AM96.1 |
ACN-INV-FLAGINV_FLAG | Alpha 1 | This field indicates whether the asset should be included as part of the physical inventory. If it is not part of the physical inventory, the asset will be ignored in inventory reconciliation reports. Valid values are:
| AM96.1 |
ACN-ASSET-OWNERASSET_OWNER | Alpha 10 | This field contains the name of the person responsible for tracking and managing the asset. | AM96.1 |
ACN-CLASSIFICATIONCLASSIFICATION | Alpha 1 | This field indicates whether the asset is purchased, associated with an operating lease, or associated with a capital lease. Valid values are:
| AM96.1 |
Indexes (3)
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 |
|---|---|---|---|---|
ACNSET1 | CONVERSION-NBR | Primary | AM500, AM96.1, AM97.1, AM98.1, AMBD.2 | |
ACNSET2 | COMPANY, CONVERSION-NBR | KeyChange | AM500 | |
ACNSET3 | LEASE-COMPANY, LEASE, CONVERSION-NBR | KeyChange | AM500 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Amastcvbod | AMASTCVBOD | Not Required, Delete Cascades | ACN-CONVERSION-NBR → YAQ-CONVERSION-NBR | |
| Amcnvasset | AMCNVASSET | Not Required | ACN-CONVERSION-NBR → CVA-CONVERSION-NBR |
One to many (4) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Amastbkcnv | AMASTBKCNV | ACN-CONVERSION-NBR → ABC-CONVERSION-NBR, ABC-BOOK | ||
| Amastitcnv | AMASTITCNV | ACN-CONVERSION-NBR → ITC-CONVERSION-NBR, ITC-SEQ-NUMBER | ||
| Amastmxcnv | AMASTMXCNV | ACN-CONVERSION-NBR → MCV-CONVERSION-NBR, MCV-MATRIX-CAT | ||
| Amasttrcnv | AMASTTRCNV | ACN-CONVERSION-NBR → TNC-CONVERSION-NBR, TNC-SEQ-NUMBER |