Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARRTMADJ


                             ARRTMADJ FILE

                       AR RTM Payment Adjustment

The AR RTM Payment Adjustment file contains adjustments that were taken
against the invoices or debit memos that were paid with the Return-to-Maker
payment. At the user's discretion, these disallowed adjustments will be
included in the return-to-maker payment.

REFERENCED BY

AR282

UPDATED BY

AR300     AR82.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARJ-COMPANY            Numeric 4                                 AR82.1
Element: Company       Company number.

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

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

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

ARJ-DR-COMPANY         Numeric 4                                 AR82.1
Element: Transaction CoAR company to which the debit
                       transaction, paid by the RTM payment,
                       belongs.

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

                       D = Debit memo
                       I = Invoice

ARJ-DR-TRANS-NBR       Alpha 22                                  AR82.1
Element: Transaction NuDebit transaction number that was
                       originally paid with the RTM payment.

ARJ-DR-PAYMENT-SEQ     Numeric 3                                 AR82.1
Element: Payment SequenThis is the Invoice/Debit Memo payment
                       sequence used in the application.

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

ARJ-APP-SEQ            Numeric 7                                 AR82.1
Element: Application NuSpecifies the application number of the
                       original write-off.

ARJ-ADJ-SEQ            Numeric 3                                 AR82.1
Element: Adjustment NumSpecifies the adjustment number of the
                       original adjustment.

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

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

ARJ-AMOUNT             Signed 18.2                               AR82.1
Element: Adjustment AmoThe 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-INVOICE
                            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-INVOICE
                            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