Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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    AP170     AP193
AP30.2    AP30.4    API1.1    API2.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     AP170   AP193
                     the Lawson system. (i.e.: GL = General      AP30.2  AP30.4
                     Ledger, AM = Asset Management, AP =         API1.1  API2.1
                     Accounts Payable, etc.)

                     PS

RPI-ASSET            Numeric 10                                  AC160   AM118
Asset                This is the asset number for the asset      AM18.1  AM18.2
                     that was repaired.                          AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.1

RPI-COMPANY          Numeric 4                                   AC160   AM118
Company              Required key. This is the company           AM18.1  AM18.2
                     number.                                     AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.1

RPI-VENDOR           Alpha 9  (Right Justified)                  AC160   AM118
Vendor               This is the vendor's identification         AM18.1  AM18.2
                     code.                                       AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.1

RPI-INVOICE          Alpha 22                                    AC160   AM118
Invoice              This number identifies the invoice.         AM18.1  AM18.2
                                                                 AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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      AP170   AP193
                     for the invoice.                            AP30.2  AP30.4
                                                                 API1.1  API2.1

RPI-DIST-SEQ-NBR     Numeric 4                                   AC160   AM118
Distribution         This is a unique distribution sequence      AM18.1  AM18.2
Sequence Number      number.                                     AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.1

RPI-ACTIVITY         Alpha 15                                    AC160   AM118
Activity             Activities and cost object activities       AM18.1  AM18.2
                     are used synonymously in the Lawson         AP170   AP193
                     Activity Management system. Direct costs    AP30.2  AP30.4
                     are posted to activities, and indirect      API1.1  API2.1
                     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.



RPI-ACCT-CATEGORY    Alpha 5                                     AC160   AM118
Account Category     Account categories are groupings of         AM18.1  AM18.2
                     costs, revenues, or a combination of        AP170   AP193
                     both used for reporting and inquiries       AP30.2  AP30.4
                     for activities in the Lawson Activity       API1.1  API2.1
                     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.



RPI-DESCRIPTION      Alpha 30  (Lower Case)                      AC160   AM118
Repair Description   This is the description.                    AM18.1  AM18.2
                                                                 AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.1

RPI-REPAIR-BASE      Signed 15.2                                 AC160   AM118
Base Repair          This is the repair amount in base           AM18.1  AM18.2
                     currency.                                   AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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.                              AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.1

RPI-REPAIR-TRAN      Signed 15.2                                 AC160   AM118
Repair Transaction   This is the repair transaction.             AM18.1  AM18.2
                                                                 AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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.                                     AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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.      AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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.         AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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    AP170   AP193
                     system.                                     AP30.2  AP30.4
                                                                 API1.1  API2.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.      AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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      AP170   AP193
                     of the original purchase order on which     AP30.2  AP30.4
                     this asset was included.                    API1.1  API2.1


RPI-PO-RELEASE       Numeric 4                                   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              AP170   AP193
                     transaction to be transferred into the      AP30.2  AP30.4
                     Lawson system.                              API1.1  API2.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.                         AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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.                         AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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.        AP170   AP193
                                                                 AP30.2  AP30.4
                                                                 API1.1  API2.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                                                AP170   AP193
          SUFFIX                                                 AP30.2  AP30.4
          DIST-SEQ-NBR                                           API1.1  API2.1
          ASSET
          SEQ-NUMBER

RPISET3   COMPANY       KeyChange, Subset                        AC160   AM118
          ACTIVITY      Where ACTIVITY != Spaces                 AM18.1  AM18.2
          ACCT-CATEGORY                                          AP170   AP193
          ASSET                                                  AP30.2  AP30.4
          SEQ-NUMBER                                             API1.1  API2.1

                         AMRPRINTER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Not Required

                            RPI-ASSET    -> AST-ASSET