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     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