Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARAPSELECT FILE

REFERENCED BY

AR129     AR130     AR135     AR30.1    AR30.2    AR30.3
AR30.4    AR30.6    AR30.8    AR30.9    AR30.7    AR31.6
AR31.1    AR31.5

UPDATED BY

AR17.1    AR300     AR45.1    AR48.1    AR48.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AAI-COMPANY          Numeric 4                                   AR48.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


AAI-CUSTOMER         Alpha 9  (Right Justified)                  AR48.1
Customer Number      This field contains the number that
                     represents a customer.

AAI-BATCH-NBR        Numeric 6                                   AR48.1
Batch Number         This identifies the batch the entered
                     invoices, debit memos, and credit memos
                     are a part of.

AAI-TRANS-TYPE       Alpha 1                                     AR48.1
Transaction Type     Determines if amounts or units are
                     processed in each transaction.
                     C = Credit Memo
                     D = Debit memo
                     I = Invoice
                     P = Payment

AAI-INVOICE          Alpha 22                                    AR48.1
Invoice Number       Used to identify the invoice, debit
                     memo, credit memo or payment number.

AAI-PAYMENT-SEQ      Numeric 6                                   AR48.1
Payment Seq          Payment Sequence. This is the generated
                     sequence number to separate individual
                     invoice, debit memo, or credit memo
                     payment requirements. It also represents
                     the entered sequence number within a
                     batch for a payment.

AAI-STATUS           Numeric 1                                   AR48.1  AR48.3
Status               This field displays the status of the
                     transaction.

                     0 = Unreleased
                     1 = Released

AAI-AP-INVOICE       Alpha 22                                    AR48.3
Ap Invoice

AAI-BASE-AMT         Signed 15.2                                 AR48.1
Base Amount          This is the amount of the transaction in
                     the company base amount.

AAI-ORIG-AMT         Signed 15.2                                 AR48.1
Original Amount

AAI-DISPUTE-FL       Alpha 1                                     AR45.1  AR48.1
Dispute Fl

AAI-COMMENT-FL       Alpha 1                                     AR17.1  AR48.1
Comment Flag

AAI-TRANS-DATE       Numeric 8  (yyyymmdd)                       AR48.1
Transaction Date     The date of the transaction.

AAI-DUE-DATE         Numeric 8  (yyyymmdd)                       AR48.1
Due Date             The transaction due date.

AAI-CURRENCY-CODE    Alpha 5                                     AR48.1
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).


                         ARAPSELECT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AAISET1   COMPANY                                                AR48.3
          BATCH-NBR
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ

AAISET2   COMPANY       Subset                                   AR129   AR130
          TRANS-TYPE    Where TRANS-TYPE = "C"                   AR135   AR17.1
          INVOICE       Or    TRANS-TYPE = "D"                   AR30.1  AR30.2
          PAYMENT-SEQ   Or    TRANS-TYPE = "I"                   AR30.3  AR30.4
                                                                 AR30.6  AR30.8
                                                                 AR30.9  AR300
                                                                 AR31.6  AR45.1
                                                                 AR48.1

AAISET3   COMPANY       Subset                                   AR129   AR130
          CUSTOMER      Where TRANS-TYPE = "P"                   AR135   AR30.1
          BATCH-NBR                                              AR30.2  AR30.3
          PAYMENT-SEQ                                            AR30.4  AR30.7
                                                                 AR30.8  AR30.9
                                                                 AR300   AR31.1
                                                                 AR31.5  AR31.6
                                                                 AR48.1

AAISET4   COMPANY                                                AR48.1  AR48.3
          CUSTOMER
          STATUS
          BATCH-NBR
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ