Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARIAPPLIED


                            ARIAPPLIED FILE

                       AR Application Conversion

The AR Application Conversion file contains conversion application records
loaded from an external source for use by AR504 (Application Conversion).
Field data in this file can be accessed and maintained in AR99 (Conversion
Maintenance).

UPDATED BY

AR504     AR99.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IAP-CR-COMPANY         Numeric 4                                 AR99.4
Element: Payment CompanCompany number identifying the payment
                       company.

IAP-CR-CUSTOMER        Alpha 9  (Right Justified)                AR99.4
Element: Payment CustomCustomer number representing the
                       payment customer.

IAP-COMPANY            Numeric 4                                 AR99.4
Element: Company       Required. Transaction company number.

IAP-CUSTOMER           Alpha 9  (Right Justified)                AR99.4
Element: Customer      Required. Transaction customer number.

IAP-CR-TYPE            Alpha 1                                   AR99.4
Element: Payment Type  Indicates payment type. If blank all
                       credit key fields must be blank. Valid
                       values are:

                       Blank = Non payment (write-off)
                       P = Payment
                       C = Credit memo

IAP-CR-NBR             Alpha 22                                  AR99.4
Element: Credit Memo NuPayment or credit memo number of the
                       application.

IAP-CR-PYMNT-SEQ       Numeric 6                                 AR504   AR99.4
Element: Application SePayment sequence number.

IAP-CR-ORIG-AP-AMT     Signed 15.2                               AR504   AR99.4
Element: Adj Amt       The amount of the application in the
                       currency of the payment.

IAP-CR-APP-AMT         Signed 15.2                               AR504   AR99.4
Element: Adj Amt       The amount of the application in the
                       payment company base.

IAP-TRANS-TYPE         Alpha 1                                   AR99.4
Element: Transaction TyRequired. Transaction type indicator.
                       Valid values are:

                       D = Debit Memo
                       I = Invoice
                       C = Credit Memo
                       P = Payment

IAP-INVOICE            Alpha 22                                  AR99.4
Element: Invoice NumberUsed to identify the invoice.

IAP-PAYMENT-SEQ        Numeric 6                                 AR504   AR99.4
Element: Payment SequenRequired. Payment obligation sequence
                       number of the invoice, debit memo, or
                       credit memo. Entry sequence within
                       payment batch.

IAP-APP-SEQ            Numeric 5                                 AR99.4
Element: Application SeRequired. Application sequence of the
                       invoice, credit memo, debit memo or
                       payment.

IAP-APPLD-AMT          Signed 15.2                               AR99.4
Element: Application AmApplication amount. Required field.

IAP-GL-DATE            Numeric 8  (yyyymmdd)                     AR99.4
Element: General LedgerGeneral Ledger posting date of
                       application. Required field.

IAP-OPR-CODE           Alpha 10  (Lower Case)                    AR99.4
Element: Operator Code Operator code. This is set to the user
                       ID of the user who last maintained this
                       record.

IAP-APP-CURR-CD        Alpha 5                                   AR504   AR99.4
Element: Application CuCurrency code representing the currency
                       of the application.

                         ARIAPPLIED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IAPSET1   CR-COMPANY    The path is used to keep the records     AR504   AR99.4
          CR-CUSTOMER   unique.
          COMPANY
          CUSTOMER
          CR-TYPE
          CR-NBR
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          APP-SEQ