Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARIDISTRIB FILE

                     Distribution Convert/Interface

The AR Distribution Convert/Interface file contains interface and conversion
distribution records for credit memos, debit memos and invoice transactions.
These distribution records may be specified to be posted to the general
ledger, or to serve as a historical reference only.

Conversion - These records are loaded by AR507 (Distribution Conversion) and
can be maintained in AR99.2 (Conversion Distribution).

Interfacing - These records are loaded by AR560 (Transaction Interface) and
can be maintained in AR97.2 (Interfaced Distribution).

UPDATED BY

AR507     AR560     AR97.2    AR99.2    BL123     BRIP.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AID-COMPANY          Numeric 4                                   AR97.2  AR99.2
Company              Required. Transaction company number.       BL123   BRIP.1

AID-CUSTOMER         Alpha 9  (Right Justified)                  BL123   BRIP.1
Customer             Required. Customer number to which this
                     distribution belongs to.

AID-TRANS-TYPE       Alpha 1                                     AR97.2  AR99.2
Transaction Type     Required. Transaction type from which       BL123   BRIP.1
                     this distribution originated. Valid
                     values are:

                     C = Credit Memo
                     D = Debit Memo
                     I = Invoice

AID-INVOICE          Alpha 22                                    AR97.2  AR99.2
Invoice Number       Used to identify the invoice.               BL123   BRIP.1

AID-PROG-SEQ-NBR     Numeric 5                                   AR97.2  AR99.2
Sequence Number      Required. Sequence number used for          BL123   BRIP.1
                     uniqueness.

AID-GL-COMPANY       Numeric 4                                   AR560   AR97.2
General Ledger       General ledger company to which this        AR99.2  BL123
Company              distribution record belongs. Required       BRIP.1
                     field.

AID-ACCT-UNIT        Alpha 15                                    AR97.2  AR99.2
Accounting Unit      The general ledger accounting unit for      BL123   BRIP.1
                     this distribution. Required field.

AID-ACCOUNT          Numeric 6                                   AR97.2  AR99.2
Account              The general ledger account for this         BL123   BRIP.1
                     distribution record. Required field.

AID-SUB-ACCT         Numeric 4                                   AR97.2  AR99.2
Subaccount           The general ledger subaccount for this      BL123   BRIP.1
                     distribution record.

AID-ORIG-AMT         Signed 15.2                                 AR97.2  AR99.2
Transaction Amount   The amount of the distribution in           BL123   BRIP.1
                     transaction currency. Required field.

AID-UNITS            Signed 15.2                                 AR97.2  AR99.2
Units                Quantity of units represented by the        BL123   BRIP.1
                     amount of this distribution record.

AID-DESCRIPTION      Alpha 30  (Lower Case)                      AR97.2  AR99.2
Description          The description of this distribution.       BL123   BRIP.1

AID-ACTIVITY         Alpha 15                                    AR97.2  AR99.2
Activity             The activity associated with the            BL123   BRIP.1
                     distribution.


AID-ACCT-CATEGORY    Alpha 5                                     AR97.2  AR99.2
Category             The account category for the activity.      BL123   BRIP.1

AID-TAX-CODE         Alpha 10                                    AR97.2  AR99.2
Tax Code             A user-defined code representing a          BL123   BRIP.1
                     taxing authority and tax rate. Must be a
                     valid tax code record.

AID-ORIG-TAXABLE     Signed 15.2                                 AR97.2  AR99.2
Original Taxable     The taxable amount of the original          BL123   BRIP.1
Amount               distribution transaction.

AID-JBK-SEQ-NBR      Numeric 10                                  AR99.2
Journal Book         The journal book sequence number
Sequence Number      assigned to a journal book transaction
                     when it is added or interfaced to the
                     Lawson system. Used only when  Auto
                     Journal Book Seq Nbr is set to Yes in
                     GL10.1 (Company).


AID-TAX-POINT        Alpha 1
Tax Point

                         ARIDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AIDSET1   COMPANY       The path is used to keep records unique  AR507   AR560
          TRANS-TYPE    and for the primary processing.          AR97.1  AR97.2
          INVOICE                                                AR99.1  AR99.2
          PROG-SEQ-NBR