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    BRIP.1    PBIP.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

AID-CUSTOMER         Alpha 9  (Right Justified)                  BRIP.1  PBIP.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       BRIP.1  PBIP.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.               BRIP.1  PBIP.1

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

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

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

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

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

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

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

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

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


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

AID-TAX-CODE         Alpha 10                                    AR97.2  AR99.2
Tax Code             A user-defined code representing a          BRIP.1  PBIP.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          BRIP.1  PBIP.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