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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2 SET3
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 SET2
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 SET2
INVOICE		Alpha 22This number identifies the invoice.AC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +29 more
#RPI-SUFFIX SET2
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 SET2
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 SET3
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 SET3
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RPISET1
  1. COMPANY
  2. SEQ-NUMBER
PrimaryAM118, AM18.1, AM18.2
RPISET2
  1. COMPANY
  2. VENDOR
  3. INVOICE
  4. SUFFIX
  5. DIST-SEQ-NBR
  6. ASSET
  7. SEQ-NUMBER
KeyChange, SubsetWhere VENDOR != SpacesAC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +22 more (list truncated in source)
RPISET3
  1. COMPANY
  2. ACTIVITY
  3. ACCT-CATEGORY
  4. ASSET
  5. SEQ-NUMBER
KeyChange, SubsetWhere ACTIVITY != SpacesAC160, AM118, AM18.1, AM18.2, AP125, AP126, AP170, AP193 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
AMASSETAMRPRINTER

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETNot Required
RPI-ASSET→AST-ASSET

Programs

Updated by (37)