REVERSEDTL FILE

                       AR Payment Reversal Detail

AR Payment Reversal Detail

REFERENCED BY

AR135

UPDATED BY

AR180     AR300     AR80.1    AR80.2    AR971     AR42.6

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RVD-CR-COMPANY       Numeric 4                                   AR80.1  AR80.2
Payment Company      The company which owns the payment.         AR971

RVD-CR-BATCH         Numeric 6                                   AR80.1  AR80.2
Batch Number         This identifies the batch the applied       AR971
                     payment belongs to.

RVD-CR-PYMNT-SEQ     Numeric 6                                   AR80.1  AR80.2
Payment Sequence     Original input sequence number of           AR971
                     payment within batch.

RVD-COMPANY          Numeric 4                                   AR80.1  AR80.2
Company              Company number.                             AR971

RVD-TRANS-TYPE       Alpha 1                                     AR80.1  AR80.2
Transaction Type     Indicates the type of open item for         AR971
                     which this reversal was created. Valid
                     values are:

                     D = Debit memo
                     I = Invoice

RVD-TRANS-NBR        Alpha 10  (Right Justified)                 AR80.1  AR80.2
Transaction Number   Transaction number identifying the          AR971
                     invoice or debit memo.

RVD-PAYMENT-SEQ      Numeric 6                                   AR80.1  AR80.2
Payment Sequence     Payment Sequence. This is the generated     AR971
                     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       AR971
                     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      AR971
                     or debit memo.

RVD-CUSTOMER         Alpha 9  (Right Justified)                  AR80.1  AR80.2
Customer Number      Customer of the invoice or debit memo.      AR971

RVD-CR-TYPE          Alpha 1                                     AR80.1  AR80.2
Payment Transaction  The transaction type of the payment.        AR971
Type

RVD-CR-NBR           Alpha 10                                    AR80.1  AR80.2
Payment Transaction  The transaction number of the applied       AR971
Number               payment or credit memo.

RVD-CR-APP-SEQ       Numeric 5                                   AR80.1  AR80.2
Application Sequence Applied sequence of the transaction         AR971
                     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.                                 AR80.1  AR80.2
          CR-PYMNT-SEQ
          COMPANY
          TRANS-TYPE
          TRANS-NBR
          PAYMENT-SEQ
          BATCH-NBR
          APP-SEQ

RVDSET2   COMPANY       This path is used to validate reversal   AR135   AR300
          TRANS-TYPE    of open items.                           AR42.6  AR80.2
          TRANS-NBR
          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-TRANS-NBR       -> ARA-TRANS-NBR
                            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-TRANS-NBR       -> ARO-TRANS-NBR
                            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-SEQ-NBR

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