|
|
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 AR82.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
Element: Payment CompanThe company which owns the payment.
RVD-CR-BATCH Numeric 6 AR80.1 AR80.2
Element: Batch Number This identifies the batch the applied
payment belongs to.
RVD-CR-PYMNT-SEQ Numeric 6 AR80.1 AR80.2
Element: Payment SequenOriginal input sequence number of
payment within batch.
RVD-COMPANY Numeric 4 AR80.1 AR80.2
Element: Company Company number.
RVD-TRANS-TYPE Alpha 1 AR80.1 AR80.2
Element: Transaction TyIndicates 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
Element: Invoice NumberUsed to identify the invoice.
RVD-PAYMENT-SEQ Numeric 6 AR80.1 AR80.2
Element: Payment Sequence
RVD-BATCH-NBR Numeric 6 AR80.1 AR80.2
Element: 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
Element: Applied SequenApplied sequence number of the invoice
or debit memo.
RVD-CUSTOMER Alpha 9 (Right Justified) AR80.1 AR80.2
Element: Customer NumbeCustomer 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
Element: Application SeApplied 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.1 AR80.2
PAYMENT-SEQ AR82.1
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
|
