Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARIITEM


                              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

AR560     AR97.5    BRIP.1    BRPI.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARI-COMPANY            Numeric 4                                 AR97.5  BRIP.1
Element: Company       Required. The company number.             BRPI.1

ARI-TRANS-TYPE         Alpha 1                                   AR97.5  BRIP.1
Element: Transaction TyRequired. Transaction type of the item.   BRPI.1

ARI-INVOICE            Alpha 22                                  AR97.5  BRIP.1
Element: Invoice NumberUsed to identify the invoice.             BRPI.1

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

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

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

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

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

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

ARI-ACCT-CATEGORY      Alpha 5                                   AR97.5  BRIP.1
Element: Account CategoThe account category assigned to the      BRPI.1
                       activity.

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

ARI-LINE-TYPE          Alpha 1                                   AR97.5  BRIP.1
Element: Line Type     Indicates the type of the line item.      BRPI.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.     BRPI.1
Number

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

ARI-SORT-1             Alpha 32  (Lower Case)                    AR97.5  BRIP.1
Element: Sort 1                                                  BRPI.1

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

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

ARI-SORT-4             Alpha 32  (Lower Case)                    AR97.5  BRIP.1
Element: Sort 4                                                  BRPI.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