Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ARIITEM FILE

                       Line Item Detail Interface

The Line Item Detail Interface file contains line item detail for invoice,
debit memo, and credit memo open items that have been interfaced from an
external source to the Accounts Receivable system.

UPDATED BY

AR97.5    BL123     BRIP.1    AR560

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ARI-COMPANY          Numeric 4                                   AR97.5  BL123
Company              Required. The company number.               BRIP.1

ARI-TRANS-TYPE       Alpha 1                                     AR97.5  BL123
Transaction Type     Required. Transaction type of the item.     BRIP.1

ARI-INVOICE          Alpha 22                                    AR97.5  BL123
Invoice Number       Used to identify the invoice.               BRIP.1

ARI-SEQUENCE         Numeric 6                                   AR97.5  BL123
Sequence             Required. The sequence number of the        BRIP.1
                     line item record.


ARI-DESCRIPTION      Alpha 30  (Lower Case)                      AR97.5  BL123
Description          The description of the line item.           BRIP.1

ARI-ITEM             Alpha 32                                    AR97.5  BL123
Item Number          The line item number.                       BRIP.1

ARI-AMOUNT           Currency 15.2                               AR97.5  BL123
Amount               Required. The amount of the line item.      BRIP.1

ARI-ITEM-USER1       Alpha 20                                    AR97.5  BL123
Item User 1          The User 1 field associated with the        BRIP.1
                     line item.


ARI-ACTIVITY         Alpha 15                                    AR97.5  BL123
Activity             The activity assigned to the line item.     BRIP.1


ARI-ACCT-CATEGORY    Alpha 5                                     AR97.5  BL123
Account Category     The account category assigned to the        BRIP.1
                     activity.


ARI-LINE-NBR         Numeric 6                                   AR97.5  BL123
Line Number          This field contains the line number.        BRIP.1

ARI-LINE-TYPE        Alpha 1                                     AR97.5  BL123
Line Type            Indicates the type of the line item.        BRIP.1
                     Valid values are:

                     Blank = Non-Lawson BL generated
                     A = Add on charges item
                     I = Inventoried item
                     N = Non stock item
                     X = Special order item


ARI-LINE-SEQ         Numeric 3                                   AR97.5  BL123
Line Item Sequence   The sequence number of the line item.       BRIP.1
Number

ARI-INVL-OBJ-ID      Numeric 12
Invl Obj Id

                         ARIITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARISET1   COMPANY       This path is used for record uniqueness. AR97.5
          TRANS-TYPE
          INVOICE
          SEQUENCE

ARISET2   COMPANY                                                AR560
          INVOICE
          TRANS-TYPE
          SEQUENCE