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 AP25.1 AP25.2 AP26.1 AP30.2
AP30.4 MA530 MA540 PO31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RPI-SYSTEM Alpha 2 AC160 AM118
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 = AP25.1 AP25.2
Accounts Payable, etc.) AP26.1 AP30.2
AP30.4 MA530
PS MA540 PO31.1
RPI-ASSET Numeric 10 AC160 AM118
Asset This is the asset number for the asset AM18.1 AM18.2
that was repaired. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-COMPANY Numeric 4 AC160 AM118
Company Required key. This is the company AM18.1 AM18.2
number. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-VENDOR Alpha 9 AC160 AM118
Vendor This is the vendor's identification AM18.1 AM18.2
code. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-INVOICE Alpha 22 AC160 AM118
Invoice This number identifies the invoice. AM18.1 AM18.2
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-SUFFIX Numeric 3 AC160 AM118
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
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.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
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-ACTIVITY Alpha 15 AC160 AM118
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 AP25.1 AP25.2
costs are allocated to activities based AP26.1 AP30.2
on activity drivers. AP30.4 MA530
MA540 PO31.1
Activities are grouped or organized by
activity levels. There are two types of
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.
RPI-ACCT-CATEGORY Alpha 5 AC160 AM118
Account Category Account 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 AP25.1 AP25.2
Management system. All transactions are AP26.1 AP30.2
posted to an account category within an AP30.4 MA530
activity. You can assign a specific MA540 PO31.1
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.
RPI-DESCRIPTION Alpha 30 (Lower Case) AC160 AM118
Repair Description This is the description. AM18.1 AM18.2
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-REPAIR-BASE Signed 15.2 AC160 AM118
Base Repair This is the repair amount in base AM18.1 AM18.2
currency. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-REPAIR-TX-BASE Signed 15.2 AC160 AM118
Repair Tax This is the tax on the repair amount in AM18.1 AM18.2
base currency. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-REPAIR-TRAN Signed 15.2 AC160 AM118
Repair Transaction This is the repair transaction. AM18.1 AM18.2
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.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
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.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
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.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
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-CURRENCY-CODE Alpha 5 AC160 AM118
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
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-REPAIR-DATE Numeric 8 (yyyymmdd) AC160 AM118
Repair Date This field contains the date the repair AM18.1 AM18.2
or maintenance was done to this asset. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-PO-NBR Alpha 14 AC160 AM118
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. AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-PO-RELEASE Numeric 6 AM118 AM18.1
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
PO Code This is the purchase order code. AM18.2
RPI-SEQ-NUMBER Numeric 6 AC160 AM118
Sequence Number Required 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. AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-CREATION-DATE Numeric 8 (yyyymmdd) AC160 AM118
Creation Date This is the date this asset repair AM18.1 AM18.2
record was created. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-CREATION-TIME Numeric 6 (hhmmss) AC160 AM118
Creation Time This is the time this asset repair AM18.1 AM18.2
record was created. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
RPI-CREATOR-ID Alpha 10 AC160 AM118
Creator ID This is the identifier of the person AM18.1 AM18.2
who created the asset repair record. AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.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 AP25.1 AP25.2
ASSET AP26.1 AP30.2
SEQ-NUMBER AP30.4 MA530
MA540 PO31.1
RPISET3 COMPANY KeyChange, Subset AC160 AM118
ACTIVITY Where ACTIVITY != Spaces AM18.1 AM18.2
ACCT-CATEGORY AP125 AP126
ASSET AP170 AP193
SEQ-NUMBER AP25.1 AP25.2
AP26.1 AP30.2
AP30.4 MA530
MA540 PO31.1
AMRPRINTER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
RPI-ASSET -> AST-ASSET
|