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
|