ARRTMADJ FILE

                       AR RTM Payment Adjustment

AR RTM Payment Adjustment

REFERENCED BY

AR282

UPDATED BY

AR300     AR82.1    AR971

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ARJ-COMPANY          Numeric 4                                   AR82.1  AR971
Company              Company number.

ARJ-CUSTOMER         Alpha 9  (Right Justified)                  AR82.1  AR971
Customer Number      Number of the customer that owns the
                     Return-to-Maker payment.

ARJ-TRANS-NBR        Alpha 10  (Right Justified)                 AR82.1  AR971
Transaction Number   Number of the Return-to-Maker check the
                     adjustments were created with.

ARJ-BATCH-NBR        Numeric 6                                   AR82.1  AR971
Batch Number         Batch number of return-to-maker
                     payment.

ARJ-DR-COMPANY       Numeric 4                                   AR82.1  AR971
Transaction Company  AR company to which the debit
                     transaction, paid by the RTM payment,
                     belongs.

ARJ-DR-TYPE          Alpha 1                                     AR82.1  AR971
Transaction Type     Debit transaction type that was
                     originally paid with the RTM payment.
                     Valid values are:

                     D = Debit memo
                     I = Invoice

ARJ-DR-TRANS-NBR     Alpha 10                                    AR82.1  AR971
Transaction Number   Debit transaction number that was
                     originally paid with the RTM payment.

ARJ-DR-PAYMENT-SEQ   Numeric 3                                   AR82.1  AR971
Payment Sequence     This is the Invoice/Debit Memo payment
                     sequence used in the application.

ARJ-DR-BATCH-NBR     Numeric 6                                   AR82.1  AR971
Transaction Batch    The batch number of the invoice or
Number               debit memo.

ARJ-APP-SEQ          Numeric 5                                   AR82.1  AR971
Application Number   Specifies the application number of the
                     original write-off.

ARJ-ADJ-SEQ          Numeric 3                                   AR82.1  AR971
Adjustment Number    Specifies the adjustment number of the
                     original adjustment.

ARJ-DR-CUST          Alpha 9  (Right Justified)                  AR82.1  AR971
Customer             Number of the customer whose invoice
                     and adjustment were exhausted with the
                     RTM payment.

ARJ-DESC             Alpha 30  (Lower Case)                      AR82.1  AR971
Description          Description of the original adjustment.

ARJ-AMOUNT           Currency 15.2                               AR82.1  AR971
Adjustment Amount    The amount of the original adjustment.

                         ARRTMADJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARJSET1   COMPANY       This path is used for record uniqueness  AR282   AR300
          CUSTOMER      and selection.                           AR82.1
          TRANS-NBR
          BATCH-NBR
          DR-COMPANY
          DR-TYPE
          DR-TRANS-NBR
          DR-PAYMENT-SEQ
          DR-BATCH-NBR
          APP-SEQ
          ADJ-SEQ

                         ARRTMADJ FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aradjust       ARADJUST     Required

                            ARJ-DR-COMPANY        -> ADJ-COMPANY
                            ARJ-DR-TYPE           -> ADJ-TRANS-TYPE
                            ARJ-DR-TRANS-NBR      -> ADJ-TRANS-NBR
                            ARJ-DR-PAYMENT-SEQ    -> ADJ-PAYMENT-SEQ
                            ARJ-DR-BATCH-NBR      -> ADJ-BATCH-NBR
                            ARJ-APP-SEQ           -> ADJ-APP-SEQ
                            ARJ-ADJ-SEQ           -> ADJ-ADJ-SEQ

Aroitems       AROITEMS     Required

                            ARJ-COMPANY           -> ARO-COMPANY
                            ARJ-DR-TYPE           -> ARO-TRANS-TYPE
                            ARJ-DR-TRANS-NBR      -> ARO-TRANS-NBR
                            ARJ-DR-PAYMENT-SEQ    -> ARO-PAYMENT-SEQ

Arreason       ARREASON     Not Required

                            ARJ-DR-COMPANY        -> ARR-COMPANY
                            "AD"                  -> ARR-TYPE
                            ADJ-REASON-CODE       -> ARR-REASON-CODE