AMRPRINTER

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
AM118 AM18.1 AM18.2 AP125 AP126 AP170
AP193 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP21.1 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP520 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MAI1.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RPI-SYSTEM
Element: Sysyem
Alpha 2
The system code is a two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AM = Asset Management, AP = Accounts Payable, etc.)
PS
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-ASSET
Element: Asset
Numeric 10
This is the asset number for the asset that was repaired.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-COMPANY
Element: Company
Numeric 4
Required key. This is the company number.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
This is the vendor's identification code.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-INVOICE
Element: Invoice
Alpha 22
This number identifies the invoice.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-SUFFIX
Element: Suffix
Numeric 3
This is the suffix for the invoice. The suffix represents the occurrence value for the invoice.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-DIST-SEQ-NBR
Distribution
Sequence Number
Numeric 6
This is a unique distribution sequence number.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-ACTIVITY
Element: Activity
Alpha 15
Activities and cost object activities are used synonymously in the Lawson Activity Management system. Direct costs are posted to activities, and indirect costs are allocated to activities based on activity drivers. 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.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-ACCT-CATEGORY
Element: Account Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Lawson Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific 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.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-DESCRIPTION
Element: Repair Description
Alpha 30 (Lower Case)
This is the description.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-REPAIR-BASE
Element: Base Repair
Signed 18.2
This is the repair amount in base currency.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-REPAIR-TX-BASE
Element: Repair Tax
Signed 18.2
This is the tax on the repair amount in base currency.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-REPAIR-TRAN
Element: Repair Transaction
Signed 18.2
This is the repair transaction.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-REPAIR-TX-TRAN
Repair Tax
Transaction
Signed 18.2
This is the tax transaction for the repair.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-BASE-ND
Base Number of
Decimals
Numeric 1
This is the number of decimal positions defined for the company base currency.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-TRAN-ND
Transaction Number
of Decimals
Numeric 1
This is the defined number of decimal positions used for the transaction.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-CURRENCY-CODE
Element: Currency Code
Alpha 5
This is the base currency defined for the company in the Lawson General Ledger system.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-REPAIR-DATE
Element: Repair Date
Numeric 8 (yyyymmdd)
This field contains the date the repair or maintenance was done to this asset.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-PO-NBR
Element: PO Number
Alpha 14
The Purchase Order Number field is for your reference. It contains the number of the original purchase order on which this asset was included.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-PO-RELEASE
Element: PO Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-PO-CODE
Element: PO Code
Alpha 4
This is the purchase order code.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-SEQ-NUMBER
Element: Sequence Number
Numeric 6
Required key. Sequence number is a unique number assigned to each transaction to be transferred into the Lawson system.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the date this asset repair record was created.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
This is the time this asset repair record was created.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-CREATOR-ID
Element: Creator ID
Alpha 10
This is the identifier of the person who created the asset repair record.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1
RPI-INV-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MAI1.1


AMRPRINTER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RPISET1 COMPANY
SEQ-NUMBER
AM118 AM18.1
AM18.2
RPISET2 COMPANY
VENDOR
INVOICE
SUFFIX
DIST-SEQ-NBR
ASSET
SEQ-NUMBER
KeyChange, Subset
WhereVENDOR !=Spaces
...
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
RPISET3 COMPANY
ACTIVITY
ACCT-CATEGORY
ASSET
SEQ-NUMBER
KeyChange, Subset
WhereACTIVITY !=Spaces
...
AM118 AM18.1
AM18.2 AP125
AP126 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2


AMRPRINTER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
RPI-ASSET->AST-ASSET


File created: Wed Jun 08 20:47:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.