Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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