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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RMISET1 |
COMPANY BATCH-NBR PAYMENT-SEQ REMIT-SEQ |
|
| |||||||||||||||||||
RMISET2 |
COMPANY BATCH-NBR PAYMENT-SEQ TRANS-TYPE REMIT-SEQ |
|
||||||||||||||||||||
RMISET3 |
COMPANY BATCH-NBR PAYMENT-SEQ TRANS-TYPE REMIT-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Arpayment | ARPAYMENT |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Aroitems | AROITEMS |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.