Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
Payment Company      Company number identifying the payment
                     company.


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


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

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

IAP-CR-TYPE          Alpha 1                                     AR99.4
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
Credit Memo Number   Payment or credit memo number of the
                     application.


IAP-CR-PYMNT-SEQ     Numeric 6                                   AR504   AR99.4
Application Sequence Payment sequence number.

IAP-CR-ORIG-AP-AMT   Signed 15.2                                 AR504   AR99.4
Cr Orig Ap Amt       The amount of the application in the
                     currency of the payment.


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


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

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


IAP-INVOICE          Alpha 22                                    AR99.4
Invoice Number       Used to identify the invoice.

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


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


IAP-APPLD-AMT        Signed 15.2                                 AR99.4
Application Amount   Application amount. Required field.

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


IAP-OPR-CODE         Alpha 10  (Lower Case)                      AR99.4
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
Application Currency Currency 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