AMASSETCNV

Asset Conversion

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

REFERENCED BY
AM97.1 AM98.1 AMBD.2


UPDATED BY
AM500 AM96.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACN-CONVERSION-NBR
Element: Conversion Number
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-DESCRIPTION
Conversion Number
Description
Alpha 30 (Lower Case)
This is the conversion number description.
AM96.1
ACN-TAG-NBR
Element: Tag Number
Alpha 12
This is the tag number for the asset.
AM96.1
ACN-ASSET-GROUP
Element: Asset 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-CATEGORY
Element: Asset Category
Alpha 1
This is the asset category: depreciable or nondepreciable.
AM96.1
ACN-SIMULATED
Element: Simulated
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-PROC
Element: Work-in-Process
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-EXEMPT
Element: Tax Exempt
Alpha 1
This field indicates whether the asset is tax exempt. The default is No.
AM96.1
ACN-USED
Element: Used
Alpha 1
This field indicates whether the asset is used. The default is No.
AM96.1
ACN-CURRENCY-CODE
Element: Currency Code
Alpha 5
This is the base currency defined for the company in the Lawson General Ledger system.
AM96.1
ACN-COMPANY
Element: Company
Numeric 4
This is the company number for the asset.
AM96.1
ACN-LOCATION-NAME
Element: Location Name
Alpha 15
This is the location for the asset.
AM96.1
ACN-DIVISION
Element: Division
Alpha 15
This is the division for the asset.
AM96.1
ACN-ASSET-TYPE
Element: Asset 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-TYPE
Element: Asset Subtype
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-COMPANY
Element: Company
Numeric 4
The lessor company for the converted leased asset.
AM96.1
ACN-LEASE
Element: Lease
Alpha 19
The lease number for the converted leased asset.
AM96.1
ACN-ACCT-GRP
Element: Account Group
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-UNIT
Element: Accounting 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-GROUP
Accounting Unit
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-ACTVTY
Depreciation
Expense Activity
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-CAT
Depr Expense
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 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-FLAG
Element: Inv 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: Y = Yes N = No
AM96.1
ACN-ASSET-OWNER
Element: Asset Owner
Alpha 10
This field contains the name of the person responsible for tracking and managing the asset.
AM96.1
ACN-CLASSIFICATION
Element: Classification
Alpha 1
This field indicates whether the asset is purchased, associated with an operating lease, or associated with a capital lease. Valid values are: P = Purchased C = Capital O = Operating
AM96.1


AMASSETCNV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACNSET1 CONVERSION-NBR
AM500 AM96.1
AM97.1 AM98.1
AMBD.2
ACNSET2 COMPANY
CONVERSION-NBR
KeyChange
AM500
ACNSET3 LEASE-COMPANY
LEASE
CONVERSION-NBR
KeyChange
AM500


AMASSETCNV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amastcvbod AMASTCVBOD Not Required, Delete Cascades
ACN-CONVERSION-NBR->YAQ-CONVERSION-NBR
Amcnvasset AMCNVASSET Not Required
ACN-CONVERSION-NBR->CVA-CONVERSION-NBR


AMASSETCNV FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 02:04:51 2016

Home
Contact Us



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