AMTEMPLATE

Asset Template

This file contains asset template information. It can be used to interface asset information from the Activity Management or Accounts Payable systems. Asset templates are defined in AM12.1 (Addition Template).

REFERENCED BY
AC10.3 AM20.1 AM21.1 AM288 AM520 AP05.3
AP170 AP193 AP520 MA540


UPDATED BY
AM115 AM117 AM12.1 AM15.1 AM15.2 AM15.3
AM15.4 AM19.1 AM19.2 AP115 AP125 AP126
AP131 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP220 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP305 API1.1
API2.1 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POII.1 POIJ.1 AM212 AM211

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATM-ASSET-TEMPLATE
Element: Template
Alpha 10
Required key. You can use an asset template to define assets for use in the Asset Management, Accounts Payable, or Activity Management systems. Templates identify the required information needed to create asset records. They are defined in AM12.1 (Addition Template). The template is a way to create assets with very little keying; using a template lets you default many of the data items associated with a new asset. An asset template is required when you define a new asset as the result of transactions from the Lawson Purchase Order, Accounts Payable, or Activity Management systems.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-DESCRIPTION
Asset Template
Description
Alpha 30 (Lower Case)
This is the asset template description.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-ASSET-CATEGORY
Element: Asset Category
Alpha 1
This is the asset category: depreciable or nondepreciable.
D = Depreciable
N = Non Depreciable
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-SIMULATED
Element: Simulated
Alpha 1
This field indicates whether the asset is simulated. The default is No.
N = No
Y = Yes
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-WORK-IN-PROC
Element: Work-in-Process
Alpha 1
This field indicates whether the asset is work-in-process. The default is No.
N = No
Y = Yes
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-TAX-EXEMPT
Element: Tax Exempt
Alpha 1
This field indicates whether the asset is tax exempt. The default is No.
N = No
Y = Yes
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-USED
Element: Used
Alpha 1
This field indicates whether the asset is used. The default is No.
N = No
Y = Yes
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-COMPANY
Element: Company
Numeric 4
This is the company number for the asset.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-LOCATION-NAME
Element: Location
Alpha 15
This is the location for the asset.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-DIVISION
Element: Division
Alpha 15
This is the division for the asset.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-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.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-SUB-TYPE
Element: Asset Subtype
Alpha 10
This is the subtype for the asset. 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.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-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 general ledger accounts used to create journal entries when assets are processed.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-ACCT-UNIT
Element: Accounting Unit
Alpha 15
This is the accounting unit for the asset. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-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.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-ACTIVITY
Element: 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.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-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.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-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
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the creation date for the asset template.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
This is the creation time for the asset template.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-CREATOR-ID
Element: Creator ID
Alpha 10
This is the identifier of the person who created the asset template.
AM115 AM117
AM12.1 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
PO136 PO190
PO300 PO520
POCP.1 POI3.1
POII.1 POIJ.1
ATM-GL-NAME
Element: Company Description
Derived
This is the description of the General Ledger company.
ATM-GL-CURR-CODE
General Ledger
Currency Code
Derived
This is the General Ledger currency code.
ATM-ACCT-UNIT-DESC
Accounting Unit
Description
Derived
This is the accounting unit description.
ATM-ACCT-GRP-DESC
Account Group
Description
Derived
This is the account group description.
ATM-LOC-DESC
Element: Location Description
Derived
This is the location description.
ATM-DIV-DESC
Element: Division Description
Derived
This is the description of the division.
ATM-TYPE-DESC
Asset Type
Description
Derived
This is the description of the asset type.
ATM-AU-GROUP-DESC
Element: Au Group Desc
Derived
ATM-ACTIVITY-DESC
Element: Activity Desc
Derived


AMTEMPLATE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATMSET1 ASSET-TEMPLATE
...
AC10.3 AM115
AM117 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM21.1
AM212 AM288
AM520 AP05.3
AP115 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
ATMSET2 COMPANY
ASSET-TEMPLATE
ATMSET3 COMPANY
ASSET-TYPE
SUB-TYPE
ASSET-TEMPLATE
AM211 AM212


AMTEMPLATE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Not Required
ATM-ACTIVITY->ACV-ACTIVITY
Amacctgrp AMACCTGRP Not Required
ATM-COMPANY->AAG-COMPANY
ATM-ACCT-GRP->AAG-ACCT-GRP
Amasttype AMASTTYPE Required
ATM-COMPANY->ATP-COMPANY
ATM-ASSET-TYPE->ATP-ASSET-TYPE
ATM-SUB-TYPE->ATP-SUB-TYPE
Amaugroup AMAUGROUP Not Required
ATM-COMPANY->AAU-COMPANY
ATM-AU-GROUP->AAU-AU-GROUP
Amcontrol AMCONTROL Not Required
ATM-COMPANY->CTL-COMPANY
Amdivision AMDIVISION Not Required
ATM-DIVISION->DIV-DIVISION
Amlocation AMLOCATION Not Required
ATM-LOCATION-NAME->LOC-LOCATION-NAME
Glnames GLNAMES Required
ATM-COMPANY->GLN-COMPANY
ATM-ACCT-UNIT->GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
ATM-COMPANY->GLS-COMPANY


AMTEMPLATE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ambktemplt AMBKTEMPLT Delete Restricted
ATM-ASSET-TEMPLATE->BKT-ASSET-TEMPLATE
  BKT-BOOK


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

Home
Contact Us



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