Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARPMTRVDTL


                            ARPMTRVDTL FILE

This table will contain payment based application reversal detail records.
This table will be created by AR80.1 Payment Application Reversal, and relate
to the ARPMTRVHDR table in a one to one fashion.

REFERENCED BY

AR135     AR42.6    AR48.1

UPDATED BY

AR180     AR300     AR80.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RVT-CR-COMPANY         Numeric 4                                 AR80.1
Element: Company       The payment company.

RVT-CR-BATCH-NBR       Numeric 6                                 AR80.1
Element: Cr Batch Nbr  The payment batch number.

RVT-CR-PAYMENT-SEQ     Numeric 6                                 AR80.1
Element: Cr Payment SeqThe payment sequence number within the
                       payment batch number.

RVT-CR-APP-SEQ         Numeric 7                                 AR80.1
Element: Cr App Seq    The payment's application sequence
                       number. This identifies the application
                       record to be reversed.

RVT-COMPANY            Numeric 4                                 AR80.1
Element: Company       The company number of the invoice, debit
                       memo, or credit memo.  For write-offs,
                       this field will be blank.

RVT-TRANS-TYPE         Alpha 1                                   AR80.1
Element: Transaction TyTransaction type of record that the
                       payment was applied to; either an
                       Invoice, Debit Memo, or Credit Memo.
                       For write-offs, this field will be
                       blank.
                       I = Invoice
                       C = Credit Memo
                       D = Debit Memo

RVT-INVOICE            Alpha 22                                  AR80.1
Element: Invoice NumberThe transaction number used to identify
                       the invoice,  debit memo, or credit
                       memo. For write-offs, this field will be
                       blank.

RVT-PAYMENT-SEQ        Numeric 6                                 AR80.1
Record Sequence        Payment Sequence. This is the generated
Number                 sequence number to separate individual
                       invoice payment requirements of the
                       invoice, credit memo, or debit memo.
                       For write-offs, this field will be
                       blank.

RVT-APP-SEQ            Numeric 7                                 AR80.1
Element: App Seq       The application sequence number of the
                       Invoice, Debit Memo, or Credit Memo.
                       For write-offs, this field will be
                       blank.

RVT-BATCH-NBR          Numeric 6                                 AR80.1
Element: Batch Number  This identifies the batch the entered
                       invoices, debit memos, and credit memos
                       are a part of.

                         ARPMTRVDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RVTSET1   CR-COMPANY    KeyChange                                AR135   AR180
          CR-BATCH-NBR                                           AR300   AR42.6
          CR-PAYMENT-SEQ                                         AR48.1  AR80.1
          CR-APP-SEQ                                             AR80.2