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     AR30.1
AR30.2    AR30.4    AR30.8    AR80.2    AR80.1    AR198
AR199     AR29.1

UPDATED BY

AR150     AR300     AR82.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

RTM-CUSTOMER           Alpha 9  (Right Justified)                AR82.1
Element: Customer NumbeThe 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 Number  This identifies the batch the returned
                       payment originally belonged to.

RTM-TRANS-TYPE         Alpha 1                                   AR82.1
Element: Transaction TyThis 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
                       2 = Released RTM
                       1 = Released RTM

RTM-RETURN-DATE        Numeric 8  (yyyymmdd)                     AR82.1
Element: Date          The date the check 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 return.

RTM-PAYMNT-AMT         Signed 15.2                               AR82.1
Element: Adj 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 15.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 15.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: Accounting UniGL 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: Subaccount    GL subaccount number for any additional
                       charges.

RTM-COMMENT            Alpha 40  (Lower Case)                    AR82.1
Element: Comment Line  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 system-generated
                       identification value assigned to the
                       transaction to make this 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       This path is used for record uniqueness  AR129   AR130
          CUSTOMER      and selection.                           AR150   AR282
          TRANS-NBR                                              AR286   AR287
          BATCH-NBR                                              AR30.1  AR30.2
                                                                 AR30.4  AR30.8
                                                                 AR300   AR80.2
                                                                 AR82.1

RTMSET2   COMPANY       This path is used to select unreleased   AR198   AR199
          CUSTOMER      records.                                 AR282   AR29.1
          TRANS-NBR     Subset                                   AR80.1
          BATCH-NBR     Where STATUS = Zeroes

RTMSET3   COMPANY       This path is used to select records in   AR282
          GL-DATE       general ledger date and customer order.
          CUSTOMER
          TRANS-NBR
          BATCH-NBR

RTMSET4   COMPANY       This path is used to select records in   AR150
          CUSTOMER      customer and debit memo number order.
          DEBIT-MEMO
          TRANS-NBR
          BATCH-NBR

RTMSET5   RTM-INST-CODE This path is used to allow drill down
          TRANS-IDENT   from cash ledger screens back into the
                        returned payment file.
                        KeyChange, Subset
                        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