Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARTRNRVDTL


                            ARTRNRVDTL FILE

This table contains transaction (Invoice, Debit Memo, Credit Memo) based
application reversal detail records.  This table will be created by AR80.2
Transaction Application Reversal, and relates to application reversal header
records.

REFERENCED BY

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

UPDATED BY

AR180     AR300     AR80.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

VTD-COMPANY            Numeric 4                                 AR80.2
Element: Company       The number representing an AR company.

VTD-TRANS-TYPE         Alpha 1                                   AR80.2
Element: Trans Type    Transaction type of record.  Denotes
                       either an Invoice, Debit Memo, or Credit
                       Memo.

VTD-INVOICE            Alpha 22                                  AR80.2
Element: Invoice       Used to identify the invoice, debit
                       memo, or credit memo.

VTD-PAYMENT-SEQ        Numeric 6                                 AR80.2
Element: Seq Number    Payment Sequence. This is the generated
                       sequence number to separate individual
                       payment requirements of the invoice,
                       debit memo, or credit memo.

VTD-APP-SEQ            Numeric 7                                 AR80.2
Element: App Seq       The application sequence number of the
                       invoice, debit memo, or credit memo.
                       This identifies the application record
                       to be reversed.

VTD-CR-COMPANY         Numeric 4                                 AR80.2
Element: Company       The payment or credit memo company.
                       For write-offs, this field wil be blank.

VTD-CR-BATCH-NBR       Numeric 6                                 AR80.2
Element: Cr Batch Nbr  The payment or credit memo batch number.
                       For write-offs, this field will be
                       blank.

VTD-CR-TRANS-TYPE      Alpha 1                                   AR80.2
Element: Cr Trans Type Transaction type referencing a payment
                       or credit memo.  For write-offs, this
                       field will be blank.  Valid values are:
                       "P" = Payment
                       "C" = Credit Memo
                       " " = Write-off

VTD-CR-TRANS-NBR       Alpha 10  (Right Justified)               AR80.2
Element: Cr Trans Nbr  The payment number of the payment
                       application, otherwise this value will
                       be blank.

VTD-CR-INVOICE         Alpha 22                                  AR80.2
Element: Cr Invoice    The credit memo number of the
                       application, otherwise this value will
                       be blank.

VTD-CR-PAYMENT-SEQ     Numeric 6                                 AR80.2
Element: Cr Payment SeqThe sequence number of the payment or
                       credit memo.  For write-offs, this
                       value will be blank.

VTD-CR-APP-SEQ         Numeric 7                                 AR80.2
Element: Cr App Seq    The application sequence number of the
                       payment or credit memo. For write-offs,
                       this value will be blank.

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

                         ARTRNRVDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

VTDSET1   COMPANY       KeyChange                                AR135   AR180
          TRANS-TYPE                                             AR251   AR300
          INVOICE                                                AR42.6  AR48.1
          PAYMENT-SEQ                                            AR80.1  AR80.2
          APP-SEQ

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

                         ARTRNRVDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Artrnrvhdr     ARTRNRVHDR   Required

                            VTD-COMPANY        -> TRV-COMPANY
                            VTD-TRANS-TYPE     -> TRV-TRANS-TYPE
                            VTD-INVOICE        -> TRV-INVOICE
                            VTD-PAYMENT-SEQ    -> TRV-PAYMENT-SEQ