Lawson Insight Technical Documentation |
|
AMRPRINTER
AMRPRINTER FILE
Asset Repair Interface
This file contains asset repair information interfaced into the Asset
Management system from Activity Management and Accounts Payable. AC160 (Asset
Interface) interfaces the asset repair information from Activity Management.
Various Accounts Payable programs interface asset information from Accounts
Payable when invoices containing assets are released.
You can view and edit interfaced asset repair information in AM18.1 (Repair
Invoice Interface) and 18.2 (Repair Activity Interface). AM118 (Repair
Release) updates the Asset Management system with adjustments to the
interfaced repair information.
UPDATED BY
AC160 AM118 AM18.1 AM18.2 AP125 AP126
AP170 AP193 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 API1.1 API2.1 MA41.2
MA41.7 MA43.2 MA61.1 MA70.1 MA75.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RPI-SYSTEM Alpha 2 AC160 AM118
Element: Sysyem The system code is a two-character code AM18.1 AM18.2
representing an application used within AP125 AP126
the Lawson system. (i.e.: GL = General AP170 AP193
Ledger, AM = Asset Management, AP = AP20.1 AP20.2
Accounts Payable, etc.) AP20.3 AP20.4
AP20.5 AP20.7
PS AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-ASSET Numeric 10 AC160 AM118
Element: Asset This is the asset number for the asset AM18.1 AM18.2
that was repaired. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-COMPANY Numeric 4 AC160 AM118
Element: Company Required key. This is the company AM18.1 AM18.2
number. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-VENDOR Alpha 9 (Right Justified) AC160 AM118
Element: Vendor This is the vendor's identification AM18.1 AM18.2
code. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-INVOICE Alpha 22 AC160 AM118
Element: Invoice This number identifies the invoice. AM18.1 AM18.2
AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-SUFFIX Numeric 3 AC160 AM118
Element: Suffix This is the suffix for the invoice. The AM18.1 AM18.2
suffix represents the occurrence value AP125 AP126
for the invoice. AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-DIST-SEQ-NBR Numeric 4 AC160 AM118
Distribution This is a unique distribution sequence AM18.1 AM18.2
Sequence Number number. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-ACTIVITY Alpha 15 AC160 AM118
Element: Activity Activities and cost object activities AM18.1 AM18.2
are used synonymously in the Lawson AP125 AP126
Activity Management system. Direct costs AP170 AP193
are posted to activities, and indirect AP20.1 AP20.2
costs are allocated to activities based AP20.3 AP20.4
on activity drivers. AP20.5 AP20.7
AP23.1 AP25.1
Activities are grouped or organized by AP25.2 AP26.1
activity levels. There are two types of AP27.1 AP30.2
activities: "posting allowed" and AP30.4 API1.1
"summary only." Use posting level API2.1 MA41.2
activities to budget and maintain all MA41.7 MA43.2
posted transactions. Summary activities MA61.1 MA70.1
or macro activities combine information MA75.1 MAI1.1
and balances from lower level activities
for reporting and inquiries.
RPI-ACCT-CATEGORY Alpha 5 AC160 AM118
Element: Account CategoAccount categories are groupings of AM18.1 AM18.2
costs, revenues, or a combination of AP125 AP126
both used for reporting and inquiries AP170 AP193
for activities in the Lawson Activity AP20.1 AP20.2
Management system. All transactions are AP20.3 AP20.4
posted to an account category within an AP20.5 AP20.7
activity. You can assign a specific AP23.1 AP25.1
General Ledger account or range of AP25.2 AP26.1
accounts (company, accounting unit, AP27.1 AP30.2
account, and subaccount) that make up AP30.4 API1.1
the transactions posted to an account API2.1 MA41.2
category using AC07.1 (Account MA41.7 MA43.2
Assignment). MA61.1 MA70.1
MA75.1 MAI1.1
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.
RPI-DESCRIPTION Alpha 30 (Lower Case) AC160 AM118
Element: Repair DescripThis is the description. AM18.1 AM18.2
AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-REPAIR-BASE Signed 15.2 AC160 AM118
Element: Base Repair This is the repair amount in base AM18.1 AM18.2
currency. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-REPAIR-TX-BASE Signed 15.2 AC160 AM118
Element: Repair Tax This is the tax on the repair amount in AM18.1 AM18.2
base currency. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-REPAIR-TRAN Signed 15.2 AC160 AM118
Element: Repair TransacThis is the repair transaction. AM18.1 AM18.2
AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-REPAIR-TX-TRAN Signed 15.2 AC160 AM118
Repair Tax This is the tax transaction for the AM18.1 AM18.2
Transaction repair. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-BASE-ND Numeric 1 AC160 AM118
Base Number of This is the number of decimal positions AM18.1 AM18.2
Decimals defined for the company base currency. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-TRAN-ND Numeric 1 AC160 AM118
Transaction Number This is the defined number of decimal AM18.1 AM18.2
of Decimals positions used for the transaction. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-CURRENCY-CODE Alpha 5 AC160 AM118
Element: Currency Code This is the base currency defined for AM18.1 AM18.2
the company in the Lawson General Ledger AP125 AP126
system. AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-REPAIR-DATE Numeric 8 (yyyymmdd) AC160 AM118
Element: Repair Date This field contains the date the repair AM18.1 AM18.2
or maintenance was done to this asset. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-PO-NBR Alpha 14 AC160 AM118
Element: PO Number The Purchase Order Number field is for AM18.1 AM18.2
your reference. It contains the number AP125 AP126
of the original purchase order on which AP170 AP193
this asset was included. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-PO-RELEASE Numeric 4 AM118 AM18.1
Element: PO Release Used to identify a purchase order AM18.2
release (created from a Blanket or
Standing order).
RPI-PO-CODE Alpha 4 AM118 AM18.1
Element: PO Code This is the purchase order code. AM18.2
RPI-SEQ-NUMBER Numeric 6 AC160 AM118
Element: Sequence NumbeRequired key. Sequence number is a AM18.1 AM18.2
unique number assigned to each AP125 AP126
transaction to be transferred into the AP170 AP193
Lawson system. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM118
Element: Creation Date This is the date this asset repair AM18.1 AM18.2
record was created. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-CREATION-TIME Numeric 6 (hhmmss) AC160 AM118
Element: Creation Time This is the time this asset repair AM18.1 AM18.2
record was created. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-CREATOR-ID Alpha 10 AC160 AM118
Element: Creator ID This is the identifier of the person AM18.1 AM18.2
who created the asset repair record. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMRPRINTER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RPISET1 COMPANY AM118 AM18.1
SEQ-NUMBER AM18.2
RPISET2 COMPANY KeyChange, Subset AC160 AM118
VENDOR Where VENDOR != Spaces AM18.1 AM18.2
INVOICE AP125 AP126
SUFFIX AP170 AP193
DIST-SEQ-NBR AP20.1 AP20.2
ASSET AP20.3 AP20.4
SEQ-NUMBER AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RPISET3 COMPANY KeyChange, Subset AC160 AM118
ACTIVITY Where ACTIVITY != Spaces AM18.1 AM18.2
ACCT-CATEGORY AP125 AP126
ASSET AP170 AP193
SEQ-NUMBER AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 API1.1
API2.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
AMRPRINTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
RPI-ASSET -> AST-ASSET
|