|
|
REVERSE FILE
AR Payment Reversal Header
The AR Payment Reversal Header file holds the header reverse application
transactions created by the payment application reversal process.
REFERENCED BY
AR82.1 AR198 AR199
UPDATED BY
AR180 AR80.1 AR80.2 AR300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RVH-COMPANY Numeric 4 AR80.1 AR80.2
Element: Company Company number.
RVH-CUSTOMER Alpha 9 (Right Justified) AR80.1 AR80.2
Element: Customer NumbeCustomer number that owns the applied
payment.
RVH-TRANS-TYPE Alpha 1 AR80.1 AR80.2
Element: Transaction TyIndicates the transaction type
associated with the application.
RVH-INVOICE Alpha 22 AR80.1 AR80.2
Element: Invoice NumberUsed to identify the invoice.
RVH-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.
RVH-PAYMENT-SEQ Numeric 6 AR80.1 AR80.2
Payment Sequence
Number
RVH-OPR-CODE Alpha 10 (Lower Case) AR80.1 AR80.2
Element: Requester Operator creating reversal.
RVH-GL-DATE Numeric 8 (yyyymmdd) AR80.1 AR80.2
Element: Posting Date Date the reversal transaction journal
entries will be posted to general
ledger.
REVERSE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RVHSET1 COMPANY This is the primary path used to access AR300 AR80.1
CUSTOMER records. AR80.2 AR82.1
TRANS-TYPE
INVOICE
BATCH-NBR
PAYMENT-SEQ
RVHSET2 COMPANY This path is used for reversal of AR180 AR198
TRANS-TYPE applications and period closing process. AR199 AR300
BATCH-NBR
PAYMENT-SEQ
INVOICE
REVERSE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
RVH-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
RVH-COMPANY -> ACM-COMPANY
RVH-CUSTOMER -> ACM-CUSTOMER
Arpayment ARPAYMENT Required
RVH-COMPANY -> APM-COMPANY
RVH-BATCH-NBR -> APM-BATCH-NBR
RVH-PAYMENT-SEQ -> APM-PAYMENT-SEQ
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
RVH-CUSTOMER -> CUD-CUSTOMER
REVERSE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Reversedtl REVERSEDTL Delete Cascades
RVH-COMPANY -> RVD-CR-COMPANY
RVH-BATCH-NBR -> RVD-CR-BATCH
RVH-PAYMENT-SEQ -> RVD-CR-PYMNT-SEQ
RVD-COMPANY
RVD-TRANS-TYPE
RVD-INVOICE
RVD-PAYMENT-SEQ
RVD-BATCH-NBR
RVD-APP-SEQ
|
