REVERSEDTL FILE
AR Payment Reversal Detail
The AR Payment Reverse Detail file holds the detail reverse records created
by the payment application reversal process.
REFERENCED BY
AR135 AR48.1
UPDATED BY
AR180 AR300 AR42.6 AR80.1 AR80.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RVD-CR-COMPANY Numeric 4 AR80.1 AR80.2
Payment Company The company which owns the payment.
RVD-CR-BATCH Numeric 6 AR80.1 AR80.2
Batch Number This identifies the batch the applied
payment belongs to.
RVD-CR-PYMNT-SEQ Numeric 6 AR80.1 AR80.2
Payment Sequence Original input sequence number of
payment within batch.
RVD-COMPANY Numeric 4 AR80.1 AR80.2
Company Company number.
RVD-TRANS-TYPE Alpha 1 AR80.1 AR80.2
Transaction Type Indicates the type of open item for
which this reversal was created. Valid
values are:
D = Debit memo
I = Invoice
RVD-INVOICE Alpha 22 AR80.1 AR80.2
Invoice Number Used to identify the invoice.
RVD-PAYMENT-SEQ Numeric 6 AR80.1 AR80.2
Payment Sequence Payment Sequence. This is the generated
sequence number to separate individual
invoice payment requirements.
RVD-BATCH-NBR Numeric 6 AR80.1 AR80.2
Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
RVD-APP-SEQ Numeric 5 AR80.1 AR80.2
Applied Sequence Applied sequence number of the invoice
or debit memo.
RVD-CUSTOMER Alpha 9 (Right Justified) AR80.1 AR80.2
Customer Number Customer of the invoice or debit memo.
RVD-CR-TYPE Alpha 1 AR80.1 AR80.2
Payment Transaction The transaction type of the payment.
Type
RVD-CR-NBR Alpha 22 AR80.1 AR80.2
Payment Transaction The transaction number of the applied
Number payment or credit memo.
RVD-CR-APP-SEQ Numeric 5 AR80.1 AR80.2
Application Sequence Applied sequence of the transaction
whose applications are being reversed.
REVERSEDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RVDSET1 CR-COMPANY This is the primary path used to access AR135 AR180
CR-BATCH records. AR48.1 AR80.1
CR-PYMNT-SEQ AR80.2
COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
RVDSET2 COMPANY This path is used to validate reversal AR135 AR300
TRANS-TYPE of open items. AR42.6 AR48.1
INVOICE AR80.2
PAYMENT-SEQ
BATCH-NBR
APP-SEQ
REVERSEDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arapplied ARAPPLIED Required
RVD-CR-COMPANY -> ARA-CR-COMPANY
RVD-CR-BATCH -> ARA-CR-BATCH
RVD-CR-PYMNT-SEQ -> ARA-CR-PYMNT-SEQ
RVD-COMPANY -> ARA-COMPANY
RVD-TRANS-TYPE -> ARA-TRANS-TYPE
RVD-INVOICE -> ARA-INVOICE
RVD-PAYMENT-SEQ -> ARA-PAYMENT-SEQ
RVD-BATCH-NBR -> ARA-BATCH-NBR
RVD-APP-SEQ -> ARA-APP-SEQ
Aroitems AROITEMS Required
RVD-COMPANY -> ARO-COMPANY
RVD-TRANS-TYPE -> ARO-TRANS-TYPE
RVD-INVOICE -> ARO-INVOICE
RVD-PAYMENT-SEQ -> ARO-PAYMENT-SEQ
Arpayment ARPAYMENT Required
RVD-CR-COMPANY -> APM-COMPANY
RVD-CR-BATCH -> APM-BATCH-NBR
RVD-CR-PYMNT-SEQ -> APM-PAYMENT-SEQ
REVERSEDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aradjust ARADJUST
RVD-COMPANY -> ADJ-COMPANY
RVD-TRANS-TYPE -> ADJ-TRANS-TYPE
RVD-INVOICE -> ADJ-INVOICE
RVD-PAYMENT-SEQ -> ADJ-PAYMENT-SEQ
RVD-BATCH-NBR -> ADJ-BATCH-NBR
RVD-APP-SEQ -> ADJ-APP-SEQ
ADJ-ADJ-SEQ
|
