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 header based payment application reversal records.

REFERENCED BY

AR135     AR251     AR42.6    AR48.1    AR38.1    AR38.2
AR38.3

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: Trans Type    Transaction 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       The 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
Element: Seq Number    Payment Sequence. This is the generated
                       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 Nbr     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                                           AR251   AR300
          CR-PAYMENT-SEQ                                         AR42.6  AR48.1
          CR-APP-SEQ                                             AR80.1  AR80.2

RVTSET2   COMPANY                                                AR251   AR38.1
          TRANS-TYPE                                             AR38.2  AR38.3
          INVOICE
          PAYMENT-SEQ
          APP-SEQ
          CR-COMPANY
          CR-BATCH-NBR
          CR-PAYMENT-SEQ
          CR-APP-SEQ