Lawson Insight Technical Documentation |
|
AMTEMPLATE
AMTEMPLATE FILE
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 AC460 AM20.1 AM21.1 AM212 AM520
AP05.3 AP170 AP193 AP520 IC130 MA310
MA540 PO135 PO136 PO190 PO26.1 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQIB.1
RQID.1 RQIF.1 RQIJ.1 WH130 WH132 WH190
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 AM211
UPDATED BY
AC160 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 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ATM-ASSET-TEMPLATE Alpha 10 AC160 AM115
Element: Template Required key. You can use an asset AM117 AM12.1
template to define assets for use in AM15.1 AM15.2
the Asset Management, Accounts Payable, AM15.3 AM15.4
or Activity Management systems. AM19.1 AM19.2
Templates identify the required AP115 AP125
information needed to create asset AP126 AP131
records. They are defined in AM12.1 AP20.1 AP20.2
(Addition Template). AP20.3 AP20.4
AP20.5 AP20.7
The template is a way to create assets AP21.1 AP220
with very little keying; using a AP23.1 AP25.1
template lets you default many of the AP25.2 AP26.1
data items associated with a new asset. AP27.1 AP30.2
An asset template is required when you AP30.4 AP305
define a new asset as the result of API1.1 API2.1
transactions from the Lawson Purchase BL120 BL122
Order, Accounts Payable, or Activity BL130 BL20.1
Management systems. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-DESCRIPTION Alpha 30 (Lower Case) AC160 AM115
Asset Template This is the asset template description. AM117 AM12.1
Description 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-ASSET-CATEGORY Alpha 1 AC160 AM115
Element: Asset CategoryThis is the asset category: depreciable AM117 AM12.1
or nondepreciable. AM15.1 AM15.2
AM15.3 AM15.4
D = Depreciable AM19.1 AM19.2
N = Non Depreciable 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-SIMULATED Alpha 1 AC160 AM115
Element: Simulated This field indicates whether the asset AM117 AM12.1
is simulated. The default is No. AM15.1 AM15.2
AM15.3 AM15.4
N = No AM19.1 AM19.2
Y = Yes 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-WORK-IN-PROC Alpha 1 AC160 AM115
Element: Work-in-ProcesThis field indicates whether the asset AM117 AM12.1
is work-in-process. The default is No. AM15.1 AM15.2
AM15.3 AM15.4
N = No AM19.1 AM19.2
Y = Yes 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-TAX-EXEMPT Alpha 1 AC160 AM115
Element: Tax Exempt This field indicates whether the asset AM117 AM12.1
is tax exempt. The default is No. AM15.1 AM15.2
AM15.3 AM15.4
N = No AM19.1 AM19.2
Y = Yes 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-USED Alpha 1 AC160 AM115
Element: Used This field indicates whether the asset AM117 AM12.1
is used. The default is No. AM15.1 AM15.2
AM15.3 AM15.4
N = No AM19.1 AM19.2
Y = Yes 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-COMPANY Numeric 4 AC160 AM115
Element: Company This is the company number for the AM117 AM12.1
asset. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-LOCATION-NAME Alpha 15 AC160 AM115
Element: Location This is the location for the asset. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-DIVISION Alpha 15 AC160 AM115
Element: Division This is the division for the asset. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-ASSET-TYPE Alpha 10 AC160 AM115
Element: Asset Type This is the asset type. Asset types are AM117 AM12.1
user-defined and represent a grouping of AM15.1 AM15.2
like assets. Asset types are used to AM15.3 AM15.4
group assets into reporting classes and AM19.1 AM19.2
to default common asset definition data. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-SUB-TYPE Alpha 10 AC160 AM115
Element: Asset Subtype This is the subtype for the asset. An AM117 AM12.1
asset subtype represents a more detailed AM15.1 AM15.2
grouping of assets within an asset type. AM15.3 AM15.4
Asset subtypes are used to group assets AM19.1 AM19.2
into reporting classes and allow common AP115 AP125
asset definition data to default. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-ACCT-GRP Alpha 10 AC160 AM115
Element: Account Group This is the account group for the AM117 AM12.1
asset. Account groups are user-defined AM15.1 AM15.2
and are used to identify general ledger AM15.3 AM15.4
accounts used to create journal entries AM19.1 AM19.2
when assets are processed. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-ACCT-UNIT Alpha 15 AC160 AM115
Element: Accounting UniThis is the accounting unit for the AM117 AM12.1
asset. The accounting unit must be AM15.1 AM15.2
defined in the General Ledger Names file AM15.3 AM15.4
as a posting accounting unit. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-AU-GROUP Alpha 10 AC160 AM115
Accounting Unit Accounting unit groups group and AM117 AM12.1
Group identify the accounting units to use AM15.1 AM15.2
when you create journal entries for AM15.3 AM15.4
adding, adjusting, transferring, or AM19.1 AM19.2
disposing of assets. Changes to AP115 AP125
accounting unit groups are dynamic, AP126 AP131
affecting all assets using the AP20.1 AP20.2
accounting unit group. Accounting unit AP20.3 AP20.4
group names are user-definable, and AP20.5 AP20.7
accounting unit groups are set up by AP21.1 AP220
company. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-ACTIVITY Alpha 15 AC160 AM115
Element: Activity Activities are the processes or AM117 AM12.1
procedures that produce work. Cost AM15.1 AM15.2
objects (products, services, customers, AM15.3 AM15.4
and so on) are the reasons for AM19.1 AM19.2
performing the activity. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-DEP-EXP-ACTVTY Alpha 15 AC160 AM115
Depreciation Activities are the processes or AM117 AM12.1
Expense Activity procedures that produce work. Cost AM15.1 AM15.2
objects (products, services, customers, AM15.3 AM15.4
and so on) are the reasons for AM19.1 AM19.2
performing the activity. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-DEP-ACCT-CAT Alpha 5 AC160 AM115
Depr Expense Account categories are groupings of AM117 AM12.1
Account Category costs, revenues, or a combination of AM15.1 AM15.2
both used for reporting and inquiries AM15.3 AM15.4
for activities in the Activity AM19.1 AM19.2
Management system. All transactions are AP115 AP125
posted to an account category within an AP126 AP131
activity. You can assign a specific AP20.1 AP20.2
General Ledger account or range of AP20.3 AP20.4
accounts (company, accounting unit, AP20.5 AP20.7
account, and subaccount) that make up AP21.1 AP220
the transactions posted to an account AP23.1 AP25.1
category using AC07.1 (Account AP25.2 AP26.1
Assignment). AP27.1 AP30.2
AP30.4 AP305
Period-to-date, year-to-date, and API1.1 API2.1
life-to-date balances are maintained by BL120 BL122
account category for activities. Account BL130 BL20.1
categories must be assigned to BL20.3 BL21.2
activities before you do any budgeting BL21.5 BL29.1
or transaction processing. BL29.2 BL520
BL820 BL92.1
Valid account category types are: MA180 MA41.1
cost MA41.2 MA41.4
revenue MA41.7 MA43.1
accrual MA43.2 MA43.3
pass thru MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Creation Date This is the creation date for the asset AM117 AM12.1
template. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Creation Time This is the creation time for the asset AM117 AM12.1
template. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-CREATOR-ID Alpha 10 AC160 AM115
Element: Creator ID This is the identifier of the person AM117 AM12.1
who created the asset template. 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
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
...
ATM-GL-NAME Derived
Element: Company DescriThis is the description of the General
Ledger company.
ATM-GL-CURR-CODE Derived
General Ledger This is the General Ledger currency
Currency Code code.
ATM-ACCT-UNIT-DESC Derived
Accounting Unit This is the accounting unit description.
Description
ATM-ACCT-GRP-DESC Derived
Account Group This is the account group description.
Description
ATM-LOC-DESC Derived
Element: Location DescrThis is the location description.
ATM-DIV-DESC Derived
Element: Division DescrThis is the description of the division.
ATM-TYPE-DESC Derived
Asset Type This is the description of the asset
Description type.
ATM-AU-GROUP-DESC Derived
Element: Au Group Desc
ATM-ACTIVITY-DESC Derived
Element: Activity Desc
AMTEMPLATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ATMSET1 ASSET-TEMPLATE AC10.3 AC160
AC460 AM115
AM117 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM21.1
AM212 AM520
AP05.3 AP115
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
...
ATMSET2 COMPANY
ASSET-TEMPLATE
ATMSET3 COMPANY AM211 AM212
ASSET-TYPE
SUB-TYPE
ASSET-TEMPLATE
AMTEMPLATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ambktemplt AMBKTEMPLT Delete Restricted
ATM-ASSET-TEMPLATE -> BKT-ASSET-TEMPLATE
BKT-BOOK
|