Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARIDISTRIB


                            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     AR97.2    AR99.2    BRIP.1    BRPI.1    PBIP.1
AR560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

AID-TRANS-TYPE         Alpha 1                                   AR97.2  AR99.2
Element: Transaction TyRequired. Transaction type from which     BRIP.1  BRPI.1
                       this distribution originated. Valid       PBIP.1
                       values are:

                       C = Credit Memo
                       D = Debit Memo
                       I = Invoice

AID-INVOICE            Alpha 22                                  AR97.2  AR99.2
Element: Invoice NumberUsed to identify the invoice.             BRIP.1  BRPI.1
                                                                 PBIP.1

AID-PROG-SEQ-NBR       Numeric 7                                 AR97.2  AR99.2
Element: Sequence NumbeRequired. Sequence number used for        BRIP.1  BRPI.1
                       uniqueness.                               PBIP.1

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     BRPI.1  PBIP.1
                       field.

AID-ACCT-UNIT          Alpha 15                                  AR97.2  AR99.2
Element: Accounting UniThe general ledger accounting unit for    BRIP.1  BRPI.1
                       this distribution. Required field.        PBIP.1

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

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

AID-ORIG-AMT           Signed 15.2                               AR97.2  AR99.2
Element: Transaction AmThe amount of the distribution in         BRIP.1  BRPI.1
                       transaction currency. Required field.     PBIP.1

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

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

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

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

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

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

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
Element: 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