Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ARPREPAY FILE

                     AR Payment Prepay Information

AR Payment Prepay Information

REFERENCED BY

AR28.4

UPDATED BY

AR21.2    AR21.6    AR29.1    AR29.2    AR300

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

APY-COMPANY          Numeric 4                                   AR21.2  AR21.6
Company              Company number.

APY-BATCH-NBR        Numeric 6                                   AR21.2  AR21.6
Batch Number         This identifies the batch of the
                     payment.

APY-SEQ-NBR          Numeric 4                                   AR21.2  AR21.6
Sequence Number      An automatically assigned sequence          AR29.1
                     number.

APY-TRANS-TYPE       Alpha 1                                     AR21.2  AR21.6
Transaction Type     Determines the transaction type. Valid
                     values are:

                     O = Order
                     I = Invoice
                     D = Debit memo

APY-TRANS-NBR        Alpha 10  (Right Justified)                 AR21.2  AR21.6
Transaction Number   Represents a unique user-defined value
                     identifying the transaction.

APY-RESERVED-AMT     Signed 15.2
Reserved Amount      For use in a future release.

APY-APPLIED-AMT      Signed 15.2
Applied Amount       For use in a future release.

                         ARPREPAY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

APYSET1   COMPANY       This path is used for record uniqueness  AR21.2  AR21.6
          BATCH-NBR     and selection.                           AR28.4  AR29.1
          SEQ-NBR                                                AR29.2  AR300

                         ARPREPAY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arpayment      ARPAYMENT    Required

                            APY-COMPANY      -> APM-COMPANY
                            APY-BATCH-NBR    -> APM-BATCH-NBR
                            APY-SEQ-NBR      -> APM-SEQ-NBR