Lawson Insight Technical Documentation |
|
AMINTER
AMINTER FILE
Asset Interface
This file contains asset information interfaced into the Asset Management
system from Activity Management, Accounts Payable, or a handheld (HHT)
terminal. AC160 (Asset Interface) interfaces asset information from Activity
Management. Various Accounts Payable programs interface asset information
from Accounts Payable when invoices containing assets are released. The
handheld terminal file (x-AMADD.txt) is imported into this file using the
importdb utility.
You can view and adjust interfaced asset information in the AM15 forms: AM15.1
(Single Invoice Interface), AM15.2 (Combine Invoice Interface), AM15.3 (Single
Activity Interface), and AM15.4 (Combine Activity Interface). AM115
(Mass Additions) updates Asset Management with adjustments to the interfaced
asset information.
UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM154 AP125 AP126 AP170 AP193
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 AP30.4
API1.1 API2.1 MA61.1 MA70.1 MA75.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AMI-COMPANY Numeric 4 AC160 AM115
Element: Company Required key. This is the company AM117 AM15.1
number. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-SEQ-NUMBER Numeric 6 AC160 AM115
Element: Sequence NumbeRequired key. The sequence number is a AM117 AM15.1
unique number assigned to each AM15.2 AM15.3
transaction in the Lawson system. AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ASSET-TEMPLATE Alpha 10 AC160 AM115
Element: Template This field contains the asset template AM117 AM15.1
used to create the asset. Templates AM15.2 AM15.3
default the required information needed AM15.4 AM154
to create asset records. Asset templates AP125 AP126
are defined in the Asset Management AP170 AP193
application, but they can be associated AP25.1 AP25.2
with a purchase order and invoice AP26.1 AP27.1
during the procurement process (in RQ, AP30.2 AP30.4
PO, or AP), or with an activity and API1.1 API2.1
account category in the Activity MA61.1 MA70.1
Management application, or with a MA75.1 MAI1.1
scanned asset during the scanning
process.
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 or Accounts Payable systems.
AMI-VENDOR Alpha 9 (Right Justified) AC160 AM115
Element: Vendor This is the identification code for the AM117 AM15.1
vendor. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-INVOICE Alpha 22 AC160 AM115
Element: Invoice This number identifies the invoice. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-SUFFIX Numeric 3 AC160 AM115
Element: Suffix This is the suffix for the invoice. It AM117 AM15.1
represents the occurrence value of the AM15.2 AM15.3
invoice. The suffix can be used to AM15.4 AP125
identify the recurrence value of a AP126 AP170
recurring invoice. AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-DIST-SEQ-NBR Numeric 4 AC160 AM115
Distribution This is a unique distribution sequence AM117 AM15.1
Sequence Number number. AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ACTIVITY Alpha 15 AC160 AM115
Element: Activity This is the activity asset from the AM117 AM15.1
Activity Management system. Activities AM15.2 AM15.3
and cost object activities are used AM15.4 AP125
synonymously in the Lawson Activity AP126 AP170
Management system. Direct costs are AP193 AP25.1
posted to activities, and indirect costs AP25.2 AP26.1
are allocated to activities based on AP27.1 AP30.2
activity drivers. AP30.4 API1.1
API2.1 MA61.1
Activities are grouped or organized by MA70.1 MA75.1
activity levels. There are two types of MAI1.1
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
AMI-ACCT-CATEGORY Alpha 5 AC160 AM115
Element: Account CategoThis is the account category associated AM117 AM15.1
with an activity from the Activity AM15.2 AM15.3
Management system. Account categories AM15.4 AP125
are groupings of costs, revenues, or a AP126 AP170
combination of both used for reporting AP193 AP25.1
and inquiries for activities in the AP25.2 AP26.1
Lawson Activity Management system. All AP27.1 AP30.2
transactions are posted to an account AP30.4 API1.1
category within an activity. You can API2.1 MA61.1
assign a specific General Ledger account MA70.1 MA75.1
or range of accounts (company, MAI1.1
accounting unit, account, and
subaccount) that make up the
transactions posted to an account
category.
AMI-SYSTEM Alpha 2 AC160 AM115
Element: System The system code is a two-character code AM117 AM15.1
representing an application used within AM15.2 AM15.3
the Lawson system. (i.e.: GL = General AM15.4 AP125
Ledger, AC = Activity Management, AM = AP126 AP170
Asset Management, AP = Accounts Payable, AP193 AP25.1
etc.) AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ITEM-QUANTITY Numeric 8 AC160 AM115
Element: Item Quantity This is the number of units that make AM117 AM15.1
up the asset item. Each unit of an item AM15.2 AM15.3
must be exactly the same as every other AM15.4 AM154
unit of the item. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-TAG-NBR Alpha 12 AC160 AM115
Element: Tag This is the user-definable tag number AM117 AM15.1
for the asset item. AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ASSET-GROUP Alpha 10 AC160 AM115
Element: Asset Group This is the asset group for the asset. AM117 AM15.1
An asset group represents a parent asset AM15.2 AM15.3
used to group assets for reporting. AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ASSET-DESC Alpha 30 (Lower Case) AC160 AM115
Element: Asset DescriptThis is the asset description. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-PURCHASE-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Purchase Date This is the date the asset was AM117 AM15.1
purchased. The purchase date can be AM15.2 AM15.3
different from the in-service dates for AM15.4 AM154
the depreciation books. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-INSRV-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: In-Service DatThis is the in-service date for the AM117 AM15.1
asset. AM15.2 AM15.3
AM15.4 AM154
Note: The in-service date can be AP125 AP126
different for each depreciation book AP170 AP193
used. AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ACCT-UNIT Alpha 15 AC160 AM115
Element: Accounting UniThis is the accounting unit for the AM117 AM15.1
asset. The accounting unit must be AM15.2 AM15.3
defined in the General Ledger Names file AM15.4 AP125
as a posting accounting unit. AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-AU-GROUP Alpha 10 AC160 AM115
Accounting Unit Accounting unit groups group and AM117 AM15.1
Group identify the accounting units to use AM15.2 AM15.3
when you create journal entries for AM15.4 AP125
adding, adjusting, transferring, or AP126 AP170
disposing of assets. Changes to AP193 AP25.1
accounting unit groups are dynamic, AP25.2 AP26.1
affecting all assets using the AP27.1 AP30.2
accounting unit group. Accounting unit AP30.4 API1.1
group names are user-definable, and API2.1 MA61.1
accounting unit groups are set up by MA70.1 MA75.1
company. MAI1.1
AMI-DEP-EXP-ACTVTY Alpha 15 AC160 AM115
Depreciation This is the override depreciation AM117 AM15.1
Expense Activity expense activity, which overrides any AM15.2 AM15.3
depreciation expense activity set up for AM15.4 AP125
an asset template on AM12.1 (Addition AP126 AP170
Template). This is the depreciation AP193 AP25.1
expense activity used for posting. AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-DEP-ACCT-CAT Alpha 5 AC160 AM115
Depr Expense This is the override depreciation AM117 AM15.1
Account Category expense account category, which AM15.2 AM15.3
overrides any depreciation expense AM15.4 AP125
account category set up for an asset AP126 AP170
template on AM12.1 (Addition Template). AP193 AP25.1
This is the depreciation expense account AP25.2 AP26.1
used for posting. AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-COMBINE Alpha 10 AC160 AM115
Element: Combine This field indicates whether to combine AM117 AM15.1
items as one asset. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ITEM-NBR Alpha 32 AC160 AM115
Element: Item Number The user-defined number assigned to the AM117 AM15.1
asset item. The item number must be AM15.2 AM15.3
unique within an asset, but can be AM15.4 AP125
duplicated from asset to asset. AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-DESCRIPTION Alpha 30 (Lower Case) AC160 AM115
Element: Item DescriptiThis is the item description. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ITEM-COST-BASE Signed 18.2 AC160 AM115
Item Cost Base This is the cost for the item in AM117 AM15.1
Currency General Ledger base currency. AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ITEM-TAX-BASE Signed 18.2 AC160 AM115
Item Tax Base This is the tax on the item in General AM117 AM15.1
Currency Ledger base currency. AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ITEM-COST-TRAN Signed 18.2 AC160 AM115
Item Cost This is the transaction associated with AM117 AM15.1
Transaction Currency the item, which is in General Ledger AM15.2 AM15.3
base currency. AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ITEM-TAX-TRAN Signed 18.2 AC160 AM115
Item Tax This is the tax transaction associated AM117 AM15.1
Transaction Currency with the item. AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-BASE-ND Numeric 1 AC160 AM115
Base Number of This is the number of decimal positions AM117 AM15.1
Decimals defined for the company base currency. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-TRAN-ND Numeric 1 AC160 AM115
Transaction Number This is the defined number of decimal AM117 AM15.1
of Decimals positions used for the transaction. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-CURRENCY-CODE Alpha 5 AC160 AM115
Element: Currency Code This is the base currency defined for AM117 AM15.1
the company in the Lawson General Ledger AM15.2 AM15.3
system. AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-PO-NBR Alpha 14 AC160 AM115
Purchase Order The Purchase Order Number field is for AM117 AM15.1
Number your reference. It contains the number AM15.2 AM15.3
of the original purchase order on which AM15.4 AP125
this asset was included. AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-PO-RELEASE Numeric 4 AC160 AM115
Element: PO Release Used to identify a purchase order AM117 AM15.1
release (created from a Blanket or AM15.2 AM15.3
Standing order). AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-PO-CODE Alpha 4 AC160 AM115
Element: PO Code This is the purchase order code. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-MODEL-NUMBER Alpha 30 AC160 AM115
Element: Model Number This is the model number of the asset AM117 AM15.1
item. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-SERIAL-NUMBER Alpha 30 AC160 AM115
Element: Serial Number This is the serial number of the asset AM117 AM15.1
item. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-HOLD-AM Alpha 1 AC160 AM115
Element: Hold This field indicates whether to hold AM117 AM15.1
the asset in the Asset Interface file. AM15.2 AM15.3
Being held keeps items from becoming AM15.4 AP125
assets until they are released from AP126 AP170
hold. AP193 AP25.1
N = No AP25.2 AP26.1
Y = Yes AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Creation Date This is the creation date for the asset AM117 AM15.1
interface record. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Creation Time This is the creation time for the asset AM117 AM15.1
interface record. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-CREATOR-ID Alpha 10 AC160 AM115
Element: Creator ID This is the identifier of the person AM117 AM15.1
who created the asset interface record. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ASSET-CATEGORY Alpha 1 AM115 AM117
Element: Category The value in this field overrides the AM15.1 AM15.2
category value defined for the asset in AM15.3 AM15.4
AM12.1 (Addition Template).
AMI-LOCATION-NAME Alpha 15 AC160 AM115
Element: Location A user-defined location name which AM117 AM15.1
represents where an asset is physically AM15.2 AM15.3
located. Locations are used to report AM15.4 AM154
asset information. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-DIVISION Alpha 15 AC160 AM115
Element: Division A user-defined division which is used AM117 AM15.1
for reporting assets. AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-ASSET-TYPE Alpha 10 AM115 AM117
Element: Asset Type An asset type represents a grouping of AM15.1 AM15.2
like assets. Asset types are used to AM15.3 AM15.4
group assets into reporting classes and
to default common asset definition data.
AMI-SUB-TYPE Alpha 10 AM115 AM117
Element: Subtype An asset subtype represents a more AM15.1 AM15.2
detailed grouping of assets within an AM15.3 AM15.4
asset type grouping. Asset subtypes are
used to group assets into reporting
classes and allow common asset
definition data to default. Subtypes
must be unique within an asset type.
AMI-ACCT-GRP Alpha 10 AM115 AM117
Element: Account Group A user-defined account group which AM15.1 AM15.2
identifies the general ledger accounts AM15.3 AM15.4
that are used to create journal entries
when assets are processed (added,
adjusted, transferred, or disposed of).
AMI-WORK-IN-PROC Alpha 1 AM115 AM117
Element: Work in ProcesThe value in this field overrides the AM15.1 AM15.2
work-in-process value defined for the AM15.3 AM15.4
asset in AM12.1 (Addition Template).
AMI-SIMULATED Alpha 1 AM115 AM117
Element: Simulated The value in this field overrides the AM15.1 AM15.2
Simulated value defined for the asset AM15.3 AM15.4
in AM12.1 (Addition Template).
AMI-TAX-EXEMPT Alpha 1 AM115 AM117
Element: Tax Exempt The value in this field overrides the AM15.1 AM15.2
tax exempt value defined for the asset AM15.3 AM15.4
in AM12.1 (Addition Template).
AMI-USED Alpha 1 AM115 AM117
Element: Used The value in this field overrides the AM15.1 AM15.2
Used value defined for the asset in AM15.3 AM15.4
AM12.1 (Addition Template).
AMI-BAR-CODE Alpha 30 AC160 AM115
Element: Bar Code This is the unique bar code assigned to AM117 AM15.1
the item. AM15.2 AM15.3
AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-ITEM-TYPE Alpha 1 AM154
Element: Item Type This field is used for bar-coded items
to indicate whether the item being
scanned is a parent item (that is, the
first or only item to be scanned for the
asset) or a child item (that is the
second or more of several items scanned
for an asset). Valid values are:
P = Parent
C = Child
AMI-PROD-CAT-CODE Alpha 30 AM154
Element: Prod Cat Code This field contains the name of the
product category, scanned from the
Product Category Workbook.
AMI-TEMPLATE-DESC Derived
Element: Template Desc This field contains the asset template
description.
AMI-ASSET-BAR-CODE Alpha 30 AM154
Element: Bar Code This field contains the asset bar code,
which is the parent item bar code (that
is, the first item of an asset to be
scanned).
AMI-ITEM-LOC-DTL Alpha 14 AC160 AM115
Element: Item Loc Dtl This field contains the location detail AM117 AM15.1
associated with the asset item. It can AM15.2 AM15.3
be typed or scanned in. AM15.4 AM154
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
AMI-INV-COMPANY Numeric 4 AC160 AM115
Element: Company AM117 AM15.1
AM15.2 AM15.3
AM15.4 AP125
AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMI-PO-AST-OBJ-ID Numeric 12
Object
Identification
AMINTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AMISET1 COMPANY AM115 AM117
SEQ-NUMBER AM15.1 AM15.2
AM15.3 AM15.4
AM154
AMISET2 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere VENDOR != Spaces AM117 AM15.1
VENDOR AM15.2 AM15.3
INVOICE AM15.4 AP125
SUFFIX AP126 AP170
DIST-SEQ-NBR AP193 AP25.1
SEQ-NUMBER AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMISET3 COMPANY KeyChange, Subset AC160 AM115
ASSET-TEMPLATEWhere ACTIVITY != Spaces AM117 AM15.1
ACTIVITY AM15.2 AM15.3
ACCT-CATEGORY AM15.4 AP125
SEQ-NUMBER AP126 AP170
AP193 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA61.1
MA70.1 MA75.1
MAI1.1
AMISET4 COMPANY KeyChange, Subset AM115 AM117
ASSET-TEMPLATEWhere VENDOR != Spaces AM15.1 AM15.2
COMBINE And COMBINE != Spaces AM15.3 AM15.4
VENDOR
INVOICE
SUFFIX
DIST-SEQ-NBR
SEQ-NUMBER
AMISET5 COMPANY KeyChange, Subset AM115 AM117
ASSET-TEMPLATEWhere ACTIVITY != Spaces AM15.1 AM15.2
COMBINE And COMBINE != Spaces AM15.3 AM15.4
ACTIVITY
ACCT-CATEGORY
SEQ-NUMBER
AMISET6 SYSTEM KeyChange, Subset
COMPANY Where COMBINE != Spaces
ASSET-TEMPLATE
COMBINE
SEQ-NUMBER
AMINTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amtemplate AMTEMPLATE Required
AMI-ASSET-TEMPLATE -> ATM-ASSET-TEMPLATE (ATMSET1)
|