Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARRTM


                               ARRTM FILE

                       AR Return to Maker Payment

The AR Return-to-maker Payment file contains information about
Return-to-Maker (RTM) payments. An RTM payment will be canceled with all
reversing audit functions provided through the RTM process.

REFERENCED BY

AR129     AR130     AR282     AR286     AR287     AR29.2
AR29.1    AR30.1    AR30.8    AR32.1    AR33.1    AR33.3
AR34.1    AR80.2    AR80.1    AR198     AR199

UPDATED BY

AR150     AR300     AR82.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RTM-COMPANY            Numeric 4                                 AR82.1
Element: Company       The number representing an AR company.

RTM-CUSTOMER           Alpha 9  (Right Justified)                AR82.1
Element: Customer      The customer that submitted the
                       Return-to-Maker payment.

RTM-TRANS-NBR          Alpha 10  (Right Justified)               AR82.1
Element: Transaction NuPayment number that was returned.

RTM-BATCH-NBR          Numeric 6                                 AR82.1
Element: Batch Nbr     This identifies the batch the returned
                       payment originally belonged to.

RTM-TRANS-TYPE         Alpha 1                                   AR82.1
Element: Trans Type    This will indicate the payment type.
                       It will be defaulted from the payment
                       record. Valid value is:

                       P = Customer Payment

RTM-STATUS             Numeric 1                                 AR82.1
Element: Status        This will indicate the status of entry.
                       The returned payment will not be
                       processed until the record is released.
                       Valid values are:

                       0 = Unreleased RTM
                       1 = Released RTM

RTM-RETURN-DATE        Numeric 8  (yyyymmdd)                     AR82.1
Element: Date          The date the payment was returned.

RTM-SALESMAN           Numeric 4                                 AR82.1
Element: SalesRep      Sales representative assigned to the
                       customer.

RTM-CREDIT-ANLYST      Alpha 4                                   AR82.1
Element: Credit AnalystCredit analyst assigned to the
                       customer.

RTM-DESC               Alpha 30  (Lower Case)                    AR82.1
Element: Description   Free form description of returned
                       payment.

RTM-PAYMNT-AMT         Signed 18.2                               AR82.1
Element: Intl Amt      This is the amount of the payment that
                       has been returned.

RTM-DEBIT-MEMO         Alpha 22                                  AR150   AR82.1
Element: Debit Memo    This will be the system-assigned debit
                       number that will be used to request
                       payment from the customer. These debit
                       memo transactions will be distinguished
                       from other debit memos in that the last
                       7 numbers will be prefixed by "RM-".

RTM-BILLBACK           Alpha 1                                   AR82.1
Bill Back              This field indicates whether or not to
Adjustments            bill back all the adjustments made to
                       the invoice (discounts and write-offs).
                       Valid values are:

                       Y = Yes; Bill back all adjusts
                       N = No; Only bill selected adjusts

RTM-CHGE-BANK          Alpha 1                                   AR82.1
Chargeback Bank        This will indicate whether the bank
Charges                charges entered should be charged back
                       to the customer. Valid values are:

                       Y = Yes; charge bank charges
                       N = No; do not charge bank charges

RTM-ADJ-AMT            Signed 18.2                               AR82.1
Element: Adjustment AmoThis is the sum of adjustments taken on
                       applications that were made from the
                       returned payment.

RTM-ADDTNL-AMT         Signed 18.2                               AR82.1
Element: Additional AmoThis is any additional amount to be
                       charged to the customer. Service
                       charges, for example.

RTM-GL-DATE            Numeric 8  (yyyymmdd)                     AR82.1
Element: Posting Date  This is the date the reversing journal
                       entries will be posted to general ledger
                       when a return-to-maker transaction is
                       created.

RTM-ACCT-UNIT          Alpha 15 Occurs 2 Times                   AR82.1
Element: Acct Unit     GL accounting unit. This will be
                       optionally entered to account for any
                       additional charges incurred.

RTM-ACCOUNT            Numeric 6 Occurs 2 Times                  AR82.1
Element: Account       GL account number to be used for any
                       additional charges.

RTM-SUB-ACCT           Numeric 4 Occurs 2 Times                  AR82.1
Element: Sub Acct      GL subaccount number for any additional
                       charges.

RTM-COMMENT            Alpha 40  (Lower Case)                    AR82.1
Element: Comment       Occurs 3 Times
                       The comment narrative for the
                       information that will appear on the
                       Request for Payment Notice form
                       produced.

RTM-RTM-INST-CODE      Alpha 3                                   AR82.1
Element: RTM TransactioThe bank service transaction code for
                       this return-to-maker check. It must
                       exist in the Lawson Cash Ledger system.

RTM-TRANS-IDENT        Numeric 10                                AR82.1
Element: Transaction IDA unique CB system-generated
                       identification value assigned to the
                       transaction to make the interface
                       adjustment record unique.

RTM-JRNL-BOOK-NBR      Alpha 12                                  AR82.1
Element: Journal Book NContains the journal book number for
                       the RTM transaction.

                         ARRTM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RTMSET1   COMPANY                                                AR129   AR130
          CUSTOMER                                               AR150   AR282
          TRANS-NBR                                              AR286   AR287
          BATCH-NBR                                              AR29.2  AR30.1
                                                                 AR30.8  AR300
                                                                 AR32.1  AR33.1
                                                                 AR33.3  AR34.1
                                                                 AR80.2  AR82.1

RTMSET2   COMPANY       Subset                                   AR198   AR199
          CUSTOMER      Where STATUS = Zeroes                    AR282   AR29.1
          TRANS-NBR                                              AR80.1  AR80.2
          BATCH-NBR

RTMSET3   COMPANY                                                AR282
          GL-DATE
          CUSTOMER
          TRANS-NBR
          BATCH-NBR

RTMSET4   COMPANY                                                AR150
          CUSTOMER
          DEBIT-MEMO
          TRANS-NBR
          BATCH-NBR

RTMSET5   RTM-INST-CODE KeyChange, Subset
          TRANS-IDENT   Where RTM-INST-CODE != Spaces

                         ARRTM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ar Pymnt Hdr   ARPYMNTHDR   Required

                            RTM-COMPANY       -> APH-COMPANY  (APHSET1)
                            RTM-BATCH-NBR     -> APH-BATCH-NBR

Arcomp         ARCOMP       Required

                            RTM-COMPANY       -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            RTM-COMPANY       -> ACM-COMPANY
                            RTM-CUSTOMER      -> ACM-CUSTOMER

Arpayment      ARPAYMENT    Required

                            RTM-COMPANY       -> APM-COMPANY
                            RTM-BATCH-NBR     -> APM-BATCH-NBR
                            RTM-TRANS-TYPE    -> APM-TRANS-TYPE
                            RTM-TRANS-NBR     -> APM-TRANS-NBR
                            RTM-CUSTOMER      -> APM-CUSTOMER

Arurtm         ARURTM       Not Required

                            RTM-COMPANY       -> UTM-COMPANY
                            RTM-CUSTOMER      -> UTM-CUSTOMER
                            RTM-TRANS-NBR     -> UTM-TRANS-NBR
                            RTM-BATCH-NBR     -> UTM-BATCH-NBR
                            Zeroes            -> UTM-SEQ

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP    -> CUD-CUST-GROUP
                            RTM-CUSTOMER      -> CUD-CUSTOMER

                         ARRTM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arapplied      ARAPPLIED    Delete Restricted

                            RTM-COMPANY       -> ARA-CR-COMPANY
                            RTM-CUSTOMER      -> ARA-CR-CUSTOMER
                            RTM-TRANS-TYPE    -> ARA-CR-TYPE
                            RTM-TRANS-NBR     -> ARA-CR-NBR
                            Zeroes            -> ARA-CR-PYMNT-SEQ
                            RTM-BATCH-NBR     -> ARA-CR-BATCH
                                                 ARA-CR-SUFFIX
                                                 ARA-CR-CANCEL-SEQ
                                                 ARA-CR-APP-SEQ

Arrtmadj       ARRTMADJ     Delete Cascades

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