ARREMIT – Payment Remittance
- System
- Accounts Receivable (AR)
- Prefix
RMI- Primary key
COMPANY,BATCH-NBR,PAYMENT-SEQ,REMIT-SEQ- Fields
- 8
- Updated by
- 1 program
- Referenced by
- 31 programs
ARREMIT is the Payment Remittance table in Lawson Accounts Receivable (prefix RMI). It is indexed by COMPANY, BATCH-NBR, PAYMENT-SEQ, REMIT-SEQ (RMISET1); alternate indexes: RMISET2 and RMISET3. It is related 1:1 to ARPAYMENT and 1:M to AROITEMS. It is updated by CB06.2 and referenced by AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 and 23 more. The table has 8 fields, 3 indexes and 2 documented relations.
About ARREMIT
The AR Payment Remittance file contains remittance records originating from the lock box interface process or online cash entry. Remittance records are used in automatic cash application and act as a reference record to an invoice, debit memo or credit memo.
Fields (8)
Column = COBOL field name without the RMI- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#RMI-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | — |
#RMI-BATCH-NBR PKBATCH_NBR | Numeric 6 | This number identifies the referenced payment batch number to which the remittance corresponds. | — |
#RMI-PAYMENT-SEQ PKPAYMENT_SEQ | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | — |
#RMI-REMIT-SEQ PKREMIT_SEQ | Numeric 7 | This is the sequence number for this remittance record for the payment. | — |
#RMI-TRANS-TYPE SET2 SET3TRANS_TYPE | Alpha 1 | Type of record the remittance record is referencing. Valid values are:
| — |
#RMI-INVOICEINVOICE | Alpha 22 | Used to identify the invoice. | — |
#RMI-STATUSSTATUS | Numeric 1 | Indicates processing status of the remittance record. Valid values are: These values are used by the AR programs and verified in ARREMIT that these values are used. 1
| — |
#RMI-APPLD-AMTAPPLD_AMT | Signed 18.2 | The applied amount of the remittance. | — |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RMISET1 |
| Primary | AR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +22 more (list truncated in source) | |
RMISET2 |
| Subset | Where TRANS-TYPE = "C" | — |
RMISET3 |
| Subset | Where TRANS-TYPE = "I" Or TRANS-TYPE = "D" | — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arpayment | ARPAYMENT | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aroitems | AROITEMS | Required |
|
Programs
Updated by (1)
- CB06.2 Bank Statement Detail Entry
Referenced by (31)
- AR09.1 Customer Group Address
- AR09.4 Bill To
- AR10.1 Customer
- AR11.1 Customer Contacts
- AR12.1 National Account
- AR12.2 National Account Speed Entry
- AR13.1 MICR Customer
- AR13.2 Customer MICR
- AR210 Customer Listing
- AR301 Customer Purge
- AR501 Customer Conversion
- AR550 Customer Interface
- ARLL.1 AR Transaction Interface
- BR02.3 Retainer Invoice Entry
- BR120 Invoice Calculation
- BR121 Invoice Print and Interface
- BR122 Online batch invoice process
- BR123 Product Invoice Cancel
- BR140 Billing and Revenue Backout
- BR151 Product Invoicing
- BR152 Maintenance Invoicing
- BR156 Maintenance Quote
- BR20.1 Invoice Edit Contract
- BR20.2 Invoice Edit Line
- BR20.3 Invoice Edit Activity
- BR20.4 Invoice Edit Activity and Account Category
- BR20.5 Invoice Edit Transaction
- BR420 Billing Invoice Report
- BR521 Billing Import
- CB191 Bank Statement Close
- TX140 Vertex Geocode Update