ARREMIT FILE
AR Payment Remittance
AR Payment Remittance
REFERENCED BY
AR220
UPDATED BY
AR130 AR21.2 AR21.4 AR21.5 AR21.1 AR21.3
AR29.1 AR29.2 AR300 AR570 AR575 AR580
AR700 AR971 AR980 AR20.1 AR30.1 AR30.2
AR30.4 CB06.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RMI-COMPANY Numeric 4 AR21.4 AR21.5
Company Company number. AR570 AR575
AR580 AR971
RMI-BATCH-NBR Numeric 6 AR21.4 AR21.5
Batch Number This number identifies the referenced AR570 AR575
payment batch number to which the AR580 AR971
remittance corresponds.
RMI-SEQ-NBR Numeric 4 AR21.4 AR21.5
Sequence Number Sequence number of the referenced AR29.1 AR570
payment within the batch. AR575 AR580
AR971
RMI-REMIT-SEQ Numeric 5 AR21.4 AR21.5
Remittance Sequence This is the sequence number for this AR570 AR575
remittance record for the payment. AR580 AR971
RMI-TRANS-TYPE Alpha 1 AR21.4 AR21.5
Transaction Type Type of record the remittance record is AR570 AR575
referencing. Valid values are: AR580 AR971
I = Invoice or Debit Memo
C = Credit Memo
RMI-TRANS-NBR Alpha 10 (Right Justified) AR21.4 AR21.5
Transaction Number Invoice/debit memo or credit memo AR570 AR575
number AR580 AR971
referenced by this remittance record.
RMI-STATUS Numeric 1 AR130 AR21.4
Status Indicates processing status of the AR21.5 AR971
remittance record. Valid values are:
0 = Unapplied
1 = Applied
RMI-APPLD-AMT Signed 15.2 AR130 AR21.4
Applied Amount The applied amount of the remittance. AR21.5 AR570
AR575 AR580
AR971
RMI-PROCESS-FL Alpha 1 AR130 AR21.4
Remittance Determines if the remittance record has AR21.5 AR570
Processed Flag been processed yet. AR575 AR580
N = No AR700 AR980
Y = Yes
ARREMIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RMISET1 COMPANY This path is used for record uniqueness AR20.1 AR21.1
BATCH-NBR and record selection. AR21.2 AR21.3
SEQ-NBR AR21.4 AR21.5
REMIT-SEQ AR220 AR29.1
AR29.2 AR30.1
AR30.2 AR30.4
AR300 AR700
AR980 CB06.2
RMISET2 COMPANY This path is used to select records AR130
BATCH-NBR that reference a credit memo.
SEQ-NBR 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.
SEQ-NBR
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-SEQ-NBR -> APM-SEQ-NBR
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-TRANS-NBR -> ARO-TRANS-NBR
ARO-PAYMENT-SEQ
|