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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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


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

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

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

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


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


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


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

ARI-LINE-TYPE        Alpha 1                                     AR97.5  BRIP.1
Line Type            Indicates the type of the line item.        PBIP.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  BRIP.1
Line Item Sequence   The sequence number of the line item.       PBIP.1
Number

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

ARI-SORT-1           Alpha 32  (Lower Case)                      AR97.5  BRIP.1
Sort 1                                                           PBIP.1

ARI-SORT-2           Alpha 32  (Lower Case)                      AR97.5  BRIP.1
Sort 2                                                           PBIP.1

ARI-SORT-3           Alpha 32  (Lower Case)                      AR97.5  BRIP.1
Sort 3                                                           PBIP.1

ARI-SORT-4           Alpha 32  (Lower Case)                      AR97.5  BRIP.1
Sort 4                                                           PBIP.1

                         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