Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARPMTRVHDR


                            ARPMTRVHDR FILE

This table will contain pyment based application reversal header records.
This table will be created by AR80.1 Payment Application Reversal, and relates
to the ARPMTRVDTL table in a one to many fashion.

REFERENCED BY

AR135     AR198     AR199     AR48.1    AR82.1

UPDATED BY

AR180     AR80.1    AR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

ARV-CR-CUSTOMER        Alpha 9  (Right Justified)                AR80.1
Element: Customer NumbeThe payment customer number.

ARV-CR-TRANS-NBR       Alpha 10  (Right Justified)               AR80.1
Element: Cr Trans Nbr  The payment number or identifier.

ARV-OPR-CODE           Alpha 10  (Lower Case)                    AR80.1
Element: Operator Code This field contains the operator code.
                       This is the user ID of the person who
                       last maintained this record.

ARV-GL-DATE            Numeric 8  (yyyymmdd)                     AR80.1
Element: General LedgerThis field contains the general ledger
                       posting date.

                         ARPMTRVHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARVSET1   CR-COMPANY    KeyChange                                AR135   AR180
          CR-BATCH-NBR                                           AR198   AR199
          CR-PAYMENT-SEQ                                         AR300   AR48.1
                                                                 AR80.1  AR82.1

                         ARPMTRVHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arpmtrvdtl     ARPMTRVDTL   Delete Cascades

                            ARV-CR-COMPANY        -> RVT-CR-COMPANY
                            ARV-CR-BATCH-NBR      -> RVT-CR-BATCH-NBR
                            ARV-CR-PAYMENT-SEQ    -> RVT-CR-PAYMENT-SEQ
                                                     RVT-CR-APP-SEQ