Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              ARIITEM FILE

                       Line Item Detail Interface

Line Item Detail Interface

UPDATED BY

AR560     AR97.5    BL123     PBIP.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

ARI-TRANS-NBR        Alpha 10  (Right Justified)                 AR97.5  BL123
Transaction Number   Required. A unique, user-defined value      PBIP.1
                     used to identify the transaction.

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

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

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

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

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

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

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

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

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

                         ARIITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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