Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            ARIAPPLIED FILE

                       AR Application Conversion

AR Application Conversion

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 10                                    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
Credit Application   The amount of the application in the
Orig Amt             currency of the payment.

IAP-CR-APP-AMT       Signed 15.2                                 AR504   AR99.4
Credit Application   The amount of the application in the
Amount               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-TRANS-NBR        Alpha 10  (Right Justified)                 AR99.4
Transaction Type     Required. Transaction number of the
                     invoice, credit memo, debit memo, or
                     payment.

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
          TRANS-NBR
          PAYMENT-SEQ
          APP-SEQ