Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ARIADJUST FILE

                     Application Adjust Conversion

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

UPDATED BY

AR504     AR99.5

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

IAD-COMPANY          Numeric 4                                   AR99.5
Company              Required. The transaction company
                     number.


IAD-CUSTOMER         Alpha 9  (Right Justified)                  AR504   AR99.5
Customer             Required. The transaction customer
                     number.


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

                     C = Credit Memo
                     D = Debit Memo
                     I = Invoice


IAD-INVOICE          Alpha 22                                    AR99.5
Invoice Number       Used to identify the invoice.

IAD-PAYMENT-SEQ      Numeric 6                                   AR99.5
Payment Sequence     Required. Payment obligation sequence
                     number. For invoice, debit memo or
                     credit memos that do not have multiple
                     payment obligations, this number will be
                     "1".


IAD-APP-SEQ          Numeric 5                                   AR99.5
Applied Sequence     Required. Application sequence number
                     that this adjustment is dependent on.


IAD-ADJ-SEQ          Numeric 3                                   AR99.5
Adjustment Sequence  Required. Adjustment sequence number
                     that represents this adjustment.


IAD-REASON-CODE      Alpha 4                                     AR99.5
Reason Code          Required. Application adjustment reason
                     code. Used for tracking adjustments.


IAD-ADJ-AMT          Signed 15.2                                 AR99.5
Adjustment Amount    Required. Adjustment amount.

IAD-CR-ORIG-AJ-AMT   Signed 15.2
Cr Orig Aj Amt       The amount of the adjustment in the
                     payment currency.

IAD-DESC             Alpha 30  (Lower Case)                      AR99.5
Description          Description or reason for adjustment.

IAD-ACCT-UNIT        Alpha 15                                    AR99.5
Accounting Unit      The accounting unit of the general
                     ledger account for this adjustment.


IAD-ACCOUNT          Numeric 6                                   AR99.5
Account              The general ledger account for this
                     adjustment.


IAD-SUB-ACCOUNT      Numeric 4                                   AR99.5
Subaccount           The general ledger subaccount for this
                     adjustment.


                         ARIADJUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IADSET1   COMPANY       The path is used to keep the records     AR504   AR99.5
          CUSTOMER      unique.
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          APP-SEQ
          ADJ-SEQ