ARREMIT

AR Payment Remittance

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.
UPDATED BY
CB06.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RMI-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
RMI-BATCH-NBR
Element: Batch Nbr
Numeric 6
This number identifies the referenced payment batch number to which the remittance corresponds.
RMI-PAYMENT-SEQ
Element: Seq Number
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
RMI-REMIT-SEQ
Element: Remittance Sequence
Numeric 7
This is the sequence number for this remittance record for the payment.
RMI-TRANS-TYPE
Element: Trans Type
Alpha 1
Type of record the remittance record is referencing. Valid values are: I = Invoice or Debit Memo C = Credit Memo
D = Debit Memo
RMI-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
RMI-STATUS
Element: Status
Numeric 1
Indicates processing status of the remittance record. Valid values are: 0 = unapplied 1 = application not performed 2 = applied These values are used by the AR programs and verified in ARREMIT that these values are used. 1 1 = Application not performed
RMI-APPLD-AMT
Element: Intl Amt
Signed 18.2
The applied amount of the remittance.


ARREMIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RMISET1 COMPANY
BATCH-NBR
PAYMENT-SEQ
REMIT-SEQ
CB06.2
RMISET2 COMPANY
BATCH-NBR
PAYMENT-SEQ
TRANS-TYPE
REMIT-SEQ
Subset
WhereTRANS-TYPE ="C"
RMISET3 COMPANY
BATCH-NBR
PAYMENT-SEQ
TRANS-TYPE
REMIT-SEQ
Subset
WhereTRANS-TYPE ="I"
OrTRANS-TYPE ="D"


ARREMIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arpayment ARPAYMENT Required
RMI-COMPANY->APM-COMPANY (APMSET1)
RMI-BATCH-NBR->APM-BATCH-NBR
RMI-PAYMENT-SEQ->APM-PAYMENT-SEQ


ARREMIT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Aroitems AROITEMS Required
RMI-COMPANY->ARO-COMPANY
RMI-TRANS-TYPE->ARO-TRANS-TYPE
RMI-INVOICE->ARO-INVOICE
  ARO-PAYMENT-SEQ


File created: Wed Jun 08 20:47:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.