|
|
ARREMIT FILE
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.
REFERENCED BY
AR220
UPDATED BY
AR130 AR21.2 AR21.4 AR21.5 AR21.1 AR21.3
AR29.1 AR29.2 AR300 AR570 AR575 AR580
AR20.1 AR30.1 AR34.1 CB06.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RMI-COMPANY Numeric 4 AR21.4 AR21.5
Element: Company Company number. AR570 AR575
AR580
RMI-BATCH-NBR Numeric 6 AR21.4 AR21.5
Element: Batch Number This number identifies the referenced AR570 AR575
payment batch number to which the AR580
remittance corresponds.
RMI-PAYMENT-SEQ Numeric 6 AR21.4 AR21.5
Record Sequence Payment Sequence. This is the generated AR29.1 AR570
Number sequence number to separate individual AR575 AR580
invoice payment requirements.
RMI-REMIT-SEQ Numeric 7 AR21.4 AR21.5
Element: Remittance SeqThis is the sequence number for this AR570 AR575
remittance record for the payment. AR580
RMI-TRANS-TYPE Alpha 1 AR21.4 AR21.5
Element: Transaction TyType of record the remittance record is AR570 AR575
referencing. Valid values are: AR580
I = Invoice or Debit Memo
C = Credit Memo
RMI-INVOICE Alpha 22 AR21.4 AR21.5
Element: Invoice NumberUsed to identify the invoice. AR570 AR575
AR580
RMI-STATUS Numeric 1 AR130 AR21.4
Element: Status Indicates processing status of the AR21.5
remittance record. Valid values are:
0 = Unapplied
1 = Applied
2 = Applied
RMI-APPLD-AMT Signed 18.2 AR130 AR21.4
Element: Intl Amt The applied amount of the remittance. AR21.5 AR570
AR575 AR580
RMI-PROCESS-FL Alpha 1 AR130 AR21.4
Element: Process Fl N = No AR21.5 AR570
Y = Yes AR575 AR580
ARREMIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RMISET1 COMPANY This path is used for record uniqueness AR130 AR20.1
BATCH-NBR and record selection. AR21.1 AR21.2
PAYMENT-SEQ AR21.3 AR21.4
REMIT-SEQ AR21.5 AR220
AR29.1 AR29.2
AR30.1 AR300
AR34.1 CB06.2
RMISET2 COMPANY This path is used to select records AR130
BATCH-NBR that reference a credit memo.
PAYMENT-SEQ Subset
TRANS-TYPE Where TRANS-TYPE = "C"
REMIT-SEQ
RMISET3 COMPANY This path is used to select records AR130
BATCH-NBR that reference an invoice or debit memo.
PAYMENT-SEQ
TRANS-TYPE Subset
REMIT-SEQ Where TRANS-TYPE = "I"
ARREMIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arpayment ARPAYMENT Required
RMI-COMPANY -> APM-COMPANY
RMI-BATCH-NBR -> APM-BATCH-NBR
RMI-PAYMENT-SEQ -> APM-PAYMENT-SEQ
ARREMIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
