|
|
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 ARLL.1 AR560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARI-COMPANY Numeric 4 AR97.5 ARLL.1
Element: Company Required. The company number.
ARI-TRANS-TYPE Alpha 1 AR97.5 ARLL.1
Element: Transaction TyRequired. Transaction type of the item.
ARI-INVOICE Alpha 22 AR97.5 ARLL.1
Element: Invoice NumberUsed to identify the invoice.
ARI-SEQUENCE Numeric 6 AR97.5 ARLL.1
Element: Sequence Required. The sequence number of the
line item record.
ARI-DESCRIPTION Alpha 30 (Lower Case) AR97.5 ARLL.1
Element: Description The description of the line item.
ARI-ITEM Alpha 32 AR97.5 ARLL.1
Element: Item Number The line item number.
ARI-AMOUNT Signed 18.2 AR97.5 ARLL.1
Element: Intl Amt Required. The amount of the line item.
ARI-ITEM-USER1 Alpha 20 AR97.5 ARLL.1
Element: Item User 1 The User 1 field associated with the
line item.
ARI-ACTIVITY Alpha 15 AR97.5 ARLL.1
Element: Activity The activity assigned to the line item.
ARI-ACCT-CATEGORY Alpha 5 AR97.5 ARLL.1
Element: Account CategoThe account category assigned to the
activity.
ARI-LINE-NBR Numeric 6 AR97.5 ARLL.1
Element: Line Number This field contains the line number.
ARI-LINE-TYPE Alpha 1 AR97.5 ARLL.1
Element: Line Type Indicates the type of the line item.
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 ARLL.1
Line Item Sequence The sequence number of the line item.
Number
ARI-INVL-OBJ-ID Numeric 12 ARLL.1
Element: Invl Obj Id
ARI-SORT-1 Alpha 32 (Lower Case) AR97.5 ARLL.1
Element: Sort 1
ARI-SORT-2 Alpha 32 (Lower Case) AR97.5 ARLL.1
Element: Sort 2
ARI-SORT-3 Alpha 32 (Lower Case) AR97.5 ARLL.1
Element: Sort 3
ARI-SORT-4 Alpha 32 (Lower Case) AR97.5 ARLL.1
Element: Sort 4
ARI-ADJ-FL Alpha 1 AR97.5
Tax Distrib. Flag -
Tax Code 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
|
