|
|
AMASSETCNV FILE
Asset Conversion
This file contains non-Lawson asset information to be converted to the Lawson
Asset Management system.
REFERENCED BY
AM97.1 AM98.1
UPDATED BY
AM500 AM96.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACN-CONVERSION-NBR Alpha 22 AM96.1
Element: Conversion NumRequired key. This is the unique number
to ensure that each record is unique.
This number also determines the order in
which assets are added.
ACN-DESCRIPTION Alpha 30 (Lower Case) AM96.1
Conversion Number This is the conversion number
Description description.
ACN-TAG-NBR Alpha 12 AM96.1
Element: Tag Number This is the tag number for the asset.
ACN-ASSET-GROUP Alpha 10 AM96.1
Element: Asset Group 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.
ACN-ASSET-CATEGORY Alpha 1 AM96.1
Element: Asset CategoryThis is the asset category: depreciable
or nondepreciable.
ACN-SIMULATED Alpha 1 AM96.1
Element: Simulated 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.
ACN-WORK-IN-PROC Alpha 1 AM96.1
Element: Work-in-ProcesThis 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.
ACN-TAX-EXEMPT Alpha 1 AM96.1
Element: Tax Exempt This field indicates whether the asset
is tax exempt. The default is No.
ACN-USED Alpha 1 AM96.1
Element: Used This field indicates whether the asset
is used. The default is No.
ACN-CURRENCY-CODE Alpha 5 AM96.1
Element: Currency Code This is the base currency defined for
the company in the Lawson General Ledger
system.
ACN-COMPANY Numeric 4 AM96.1
Element: Company This is the company number for the
asset.
ACN-LOCATION-NAME Alpha 15 AM96.1
Element: Location Name This is the location for the asset.
ACN-DIVISION Alpha 15 AM96.1
Element: Division This is the division for the asset.
ACN-ASSET-TYPE Alpha 10 AM96.1
Element: Asset Type 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.
ACN-SUB-TYPE Alpha 10 AM96.1
Element: Asset Subtype 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.
ACN-LEASE-COMPANY Numeric 4 AM96.1
Element: Lease Company The lessor company for the converted
leased asset.
ACN-LEASE Alpha 19 AM96.1
Element: Lease The lease number for the converted
leased asset.
ACN-ACCT-GRP Alpha 10 AM96.1
Element: Account Group 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).
ACN-ACCT-UNIT Alpha 15 AM96.1
Element: Accounting UniThis 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.
ACN-AU-GROUP Alpha 10 AM96.1
Accounting Unit Accounting unit groups group and
Group 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.
ACN-DEP-EXP-ACTVTY Alpha 15 AM96.1
Depreciation
Expense Activity
ACN-DEP-ACCT-CAT Alpha 5 AM96.1
Depr Expense
Account Category
ACN-INV-FLAG Alpha 1 AM96.1
Element: Inv Flag 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
ACN-ASSET-OWNER Alpha 10 AM96.1
Element: Asset Owner This field contains the name of the
person responsible for tracking and
managing the asset.
ACN-CLASSIFICATION Alpha 1 AM96.1
Element: ClassificationThis 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
AMASSETCNV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACNSET1 CONVERSION-NBR AM500 AM96.1
AM97.1 AM98.1
ACNSET2 COMPANY KeyChange AM500
CONVERSION-NBR
ACNSET3 LEASE-COMPANY KeyChange AM500
LEASE
CONVERSION-NBR
AMASSETCNV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amcnvasset AMCNVASSET Not Required
ACN-CONVERSION-NBR -> CVA-CONVERSION-NBR
AMASSETCNV FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
