REVERSE FILE

                       AR Payment Reversal Header

AR Payment Reversal Header

REFERENCED BY

AR82.1    AR199

UPDATED BY

AR180     AR300     AR80.1    AR80.2    AR980

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RVH-COMPANY          Numeric 4                                   AR80.1  AR80.2
Company              Company number.                             AR980

RVH-CUSTOMER         Alpha 9  (Right Justified)                  AR80.1  AR80.2
Customer Number      Customer number that owns the applied       AR980
                     payment.

RVH-TRANS-TYPE       Alpha 1                                     AR80.1  AR80.2
Transaction Type     Indicates the transaction type              AR980
                     associated with the application.

RVH-TRANS-NBR        Alpha 10  (Right Justified)                 AR80.1  AR80.2
Payment Number       Applied payment number.                     AR980

RVH-BATCH-NBR        Numeric 6                                   AR80.1  AR80.2
Batch Number         This identifies the batch the entered       AR980
                     invoices, debit memos, and credit memos
                     are a part of.

RVH-PAYMENT-SEQ      Numeric 6                                   AR80.1  AR80.2
Payment Sequence     Payment Sequence. This is the generated     AR980
Number               sequence number to separate individual
                     invoice payment requirements.

RVH-OPR-CODE         Alpha 10  (Lower Case)                      AR80.1  AR80.2
Operator Code        Operator creating reversal.                 AR980

RVH-GL-DATE          Numeric 8  (yyyymmdd)                       AR80.1  AR80.2
Posting Date         Date the reversal transaction journal       AR980
                     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                                             AR980
          TRANS-NBR
          BATCH-NBR
          PAYMENT-SEQ

RVHSET2   COMPANY       This path is used for reversal of        AR180   AR199
          TRANS-TYPE    applications and period closing process.
          BATCH-NBR
          PAYMENT-SEQ
          TRANS-NBR

                         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-SEQ-NBR

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-TRANS-NBR
                                                  RVD-PAYMENT-SEQ
                                                  RVD-BATCH-NBR
                                                  RVD-APP-SEQ