Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARAPSELECT


                            ARAPSELECT FILE

REFERENCED BY

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

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

AAI-BATCH-NBR          Numeric 6                                 AR48.1
Element: 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
Element: Transaction TyDetermines 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
Element: Invoice NumberUsed to identify the invoice, debit
                       memo, credit memo or payment number.

AAI-PAYMENT-SEQ        Numeric 6                                 AR48.1
Record Sequence        Payment Sequence. This is the generated
Number                 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
Element: Status        This field displays the status of the
                       transaction.
                       0 = Unreleased
                       1 = Released

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

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

AAI-ORIG-AMT           Signed 15.2                               AR48.1
Element: Adj Amt

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

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

AAI-TRANS-DATE         Numeric 8  (yyyymmdd)                     AR48.1
Element: Date

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

AAI-CURRENCY-CODE      Alpha 5                                   AR48.1
Element: 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"                   AR131   AR135
          INVOICE       Or    TRANS-TYPE = "D"                   AR17.1  AR30.1
          PAYMENT-SEQ   Or    TRANS-TYPE = "I"                   AR30.2  AR30.3
                                                                 AR30.4  AR30.6
                                                                 AR30.8  AR30.9
                                                                 AR300   AR31.6
                                                                 AR45.1  AR48.1
                                                                 AR80.2

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

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