Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARPREPAY


                             ARPREPAY FILE

                     AR Payment Prepay Information

The AR Payment Prepay Information file contains prepayment records that were
created from the payment release logic. Prepayment records allow a payment to
credit a different AR GL Code than that of the batch header, and will be used
in a future release enabling prepayment processing with the Lawson Order Entry
system.

REFERENCED BY

AR129     AR223     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
Element: Company       Company number.

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

APY-PAYMENT-SEQ        Numeric 6                                 AR21.2  AR21.6
Record Sequence                                                  AR29.1
Number

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

                       O = Order
                       I = Invoice
                       D = Debit memo
                       C = Credit Memo
                       B = Billing Invoice
                       M = Mixed
                       N = Non Lawson
                       " "

APY-INVOICE            Alpha 22                                  AR21.2  AR21.6
Element: Invoice NumberUsed to identify the invoice.

APY-ORDER-NBR          Numeric 8                                 AR21.6
Element: Order Number  This field contains the order number.

APY-AUTO-APP-FL        Alpha 1                                   AR21.6
Element: Auto App Fl   N = No
                       Y = Yes

APY-PREPAYMENT-NBR     Alpha 10  (Right Justified)               AR21.2  AR21.6
Element: Prepayment Nbr

                         ARPREPAY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

APYSET2   COMPANY       Subset
          BATCH-NBR     Where TRANS-TYPE = "O"
          PAYMENT-SEQ
          ORDER-NBR

APYSET3   COMPANY       Subset
          BATCH-NBR     Where TRANS-TYPE != "O"
          PAYMENT-SEQ   And   TRANS-TYPE != Spaces
          TRANS-TYPE
          INVOICE

                         ARPREPAY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arpayment      ARPAYMENT    Required

                            APY-COMPANY        -> APM-COMPANY  (APMSET1)
                            APY-BATCH-NBR      -> APM-BATCH-NBR
                            APY-PAYMENT-SEQ    -> APM-PAYMENT-SEQ

Custorder      CUSTORDER    Not Required

                            APY-COMPANY        -> COR-COMPANY
                            APY-ORDER-NBR      -> COR-ORDER-NBR

                         ARPREPAY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aroitems       AROITEMS

                            APY-COMPANY        -> ARO-COMPANY
                            APY-TRANS-TYPE     -> ARO-TRANS-TYPE
                            APY-INVOICE        -> ARO-INVOICE
                                                  ARO-PAYMENT-SEQ