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 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
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 = AP25.1 AP25.2
Accounts Payable, etc.) AP26.1 AP27.1
AP30.2 AP30.4
PS API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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 AP25.1 AP25.2
costs are allocated to activities based AP26.1 AP27.1
on activity drivers. AP30.2 AP30.4
API1.1 API2.1
Activities are grouped or organized by MA61.1 MA70.1
activity levels. There are two types of MA75.1 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.
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 AP25.1 AP25.2
Management system. All transactions are AP26.1 AP27.1
posted to an account category within an AP30.2 AP30.4
activity. You can assign a specific API1.1 API2.1
General Ledger account or range of MA61.1 MA70.1
accounts (company, accounting unit, MA75.1 MAI1.1
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
Element: Repair DescripThis is the description. AM18.1 AM18.2
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
RPI-REPAIR-BASE Signed 18.2 AC160 AM118
Element: Base Repair This is the repair amount in base AM18.1 AM18.2
currency. 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
RPI-REPAIR-TX-BASE Signed 18.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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-REPAIR-TRAN Signed 18.2 AC160 AM118
Element: Repair TransacThis is the repair transaction. AM18.1 AM18.2
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
RPI-REPAIR-TX-TRAN Signed 18.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 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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. AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-PO-RELEASE Numeric 4 AC160 AM118
Element: PO Release Used to identify a purchase order AM18.1 AM18.2
release (created from a Blanket or AP125 AP126
Standing order). 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
RPI-PO-CODE Alpha 4 AC160 AM118
Element: PO Code This is the purchase order code. AM18.1 AM18.2
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
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. AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
MA61.1 MA70.1
MA75.1 MAI1.1
RPI-INV-COMPANY Numeric 4 AC160 AM118
Element: Company AM18.1 AM18.2
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
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 AP27.1
SEQ-NUMBER AP30.2 AP30.4
API1.1 API2.1
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 AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
API1.1 API2.1
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
|