AMRPRINTER – Asset Repair Interface

System
Asset Management (AM)
Prefix
RPI
Primary key
COMPANY, SEQ-NUMBER
Fields
26
Updated by
37 programs
Referenced by
0 programs

AMRPRINTER is the Asset Repair Interface table in Lawson Asset Management (prefix RPI). It is indexed by COMPANY, SEQ-NUMBER (RPISET1); alternate indexes: RPISET2 and RPISET3. It is related 1:1 to AMASSET. It is updated by AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 and 29 more. The table has 26 fields, 3 indexes and 1 documented relation.

About AMRPRINTER

No description in the Lawson data dictionary.

Fields (26)

Column = COBOL field name without the RPI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RPI-SYSTEM
SYSTEM		Alpha 2The 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.) PSAC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-ASSET
ASSET		Numeric 10This is the asset number for the asset that was repaired.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-COMPANY PK
COMPANY		Numeric 4Required key. This is the company number.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-VENDOR
VENDOR		Alpha 9 (Right Justified)This is the vendor's identification code.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-INVOICE
INVOICE		Alpha 22This number identifies the invoice.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-SUFFIX
SUFFIX		Numeric 3This is the suffix for the invoice. The suffix represents the occurrence value for the invoice.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-DIST-SEQ-NBR
DIST_SEQ_NBR		Numeric 6This is a unique distribution sequence number.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-ACTIVITY
ACTIVITY		Alpha 15Activities 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.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the description.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-REPAIR-BASE
REPAIR_BASE		Signed 18.2This is the repair amount in base currency.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-REPAIR-TX-BASE
REPAIR_TX_BASE		Signed 18.2This is the tax on the repair amount in base currency.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-REPAIR-TRAN
REPAIR_TRAN		Signed 18.2This is the repair transaction.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-REPAIR-TX-TRAN
REPAIR_TX_TRAN		Signed 18.2This is the tax transaction for the repair.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-BASE-ND
BASE_ND		Numeric 1This is the number of decimal positions defined for the company base currency.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-TRAN-ND
TRAN_ND		Numeric 1This is the defined number of decimal positions used for the transaction.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This is the base currency defined for the company in the Lawson General Ledger system.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-REPAIR-DATE
REPAIR_DATE		Numeric 8 (yyyymmdd)This field contains the date the repair or maintenance was done to this asset.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-PO-NBR
PO_NBR		Alpha 14The Purchase Order Number field is for your reference. It contains the number of the original purchase order on which this asset was included.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6Required key. Sequence number is a unique number assigned to each transaction to be transferred into the Lawson system.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date this asset repair record was created.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)This is the time this asset repair record was created.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-CREATOR-ID
CREATOR_ID		Alpha 10This is the identifier of the person who created the asset repair record.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
RPI-INV-COMPANY
INV_COMPANY		Numeric 4Identifies 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.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RPISET1COMPANY, SEQ-NUMBERPrimaryAM118, AM18.1, AM18.2
RPISET2COMPANY, VENDOR, INVOICE, SUFFIX, DIST-SEQ-NBR, ASSET, SEQ-NUMBERKeyChange, SubsetWhere VENDOR != SpacesAC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +22 more (list truncated in source)
RPISET3COMPANY, ACTIVITY, ACCT-CATEGORY, ASSET, SEQ-NUMBERKeyChange, SubsetWhere ACTIVITY != SpacesAC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETNot RequiredRPI-ASSET → AST-ASSET

Programs

Updated by (37)