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.

Field / columnTypeDescription & valuesUpdated by
RMI-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.—
RMI-BATCH-NBR PK
BATCH_NBR		Numeric 6This number identifies the referenced payment batch number to which the remittance corresponds.—
RMI-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.—
RMI-REMIT-SEQ PK
REMIT_SEQ		Numeric 7This is the sequence number for this remittance record for the payment.—
RMI-TRANS-TYPE
TRANS_TYPE		Alpha 1Type of record the remittance record is referencing. Valid values are:
  • I Invoice or Debit Memo
  • C Credit Memo
  • D Debit Memo
—
RMI-INVOICE
INVOICE		Alpha 22Used to identify the invoice.—
RMI-STATUS
STATUS		Numeric 1Indicates 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
  • 0 unapplied
  • 1 application not performed
  • 2 applied
  • 1 Application not performed
—
RMI-APPLD-AMT
APPLD_AMT		Signed 18.2The applied amount of the remittance.—

Indexes (3)

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

IndexKeysFlagsConditionUsed in
RMISET1COMPANY, BATCH-NBR, PAYMENT-SEQ, REMIT-SEQPrimaryAR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +22 more (list truncated in source)
RMISET2COMPANY, BATCH-NBR, PAYMENT-SEQ, TRANS-TYPE, REMIT-SEQSubsetWhere TRANS-TYPE = "C"—
RMISET3COMPANY, BATCH-NBR, PAYMENT-SEQ, TRANS-TYPE, REMIT-SEQSubsetWhere TRANS-TYPE = "I" Or TRANS-TYPE = "D"—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ArpaymentARPAYMENTRequiredRMI-COMPANY → APM-COMPANY (APMSET1), RMI-BATCH-NBR → APM-BATCH-NBR, RMI-PAYMENT-SEQ → APM-PAYMENT-SEQ

One to many (1) — child tables

RelationTableRulesConditionField map
AroitemsAROITEMSRequiredRMI-COMPANY → ARO-COMPANY, RMI-TRANS-TYPE → ARO-TRANS-TYPE, RMI-INVOICE → ARO-INVOICE, → ARO-PAYMENT-SEQ

Programs

Updated by (1)

Referenced by (31)