|
|
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. Each line item will
represent an an open item transaction, each referencing the same transaction
number.
UPDATED BY
AR560 AR97.5 ARLL.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARI-COMPANY Numeric 4 AR97.5 ARLL.1
Element: Company The number representing an AR company.
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 Used 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 Nbr This field contains the line number.
ARI-LINE-TYPE Alpha 1 AR97.5 ARLL.1
Element: Line Type Indicates the Billing system line 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 Billing
Number system transaction's line item.
ARI-INVL-OBJ-ID Numeric 12 ARLL.1
Element: Invl Obj Id The object ID of the line item record.
ARI-SORT-1 Alpha 32 (Lower Case) AR560 AR97.5
Element: Sort 1 The transaction User Sort1 value. ARLL.1
ARI-SORT-2 Alpha 32 (Lower Case) AR560 AR97.5
Element: Sort 2 The transaction User Sort1 value. ARLL.1
ARI-SORT-3 Alpha 32 (Lower Case) AR560 AR97.5
Element: Sort 3 The transaction User Sort1 value. ARLL.1
ARI-SORT-4 Alpha 32 (Lower Case) AR560 AR97.5
Element: Sort 4 The transaction User Sort1 value. ARLL.1
ARI-ADJ-FL Alpha 1 AR97.5
Element: Flag1
ARI-CONTRACT Alpha 15 AR97.5 ARLL.1
Element: Contract Activity Management contract.
ARI-ACTIVITY-GRP Alpha 15 AR97.5 ARLL.1
Element: Activity Grp The activity group is the overall
project.
ARI-TRANS-USER1 Alpha 10 AR97.5
Element: Trans User1
ARIITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARISET1 COMPANY AR97.5
TRANS-TYPE
INVOICE
SEQUENCE
ARISET2 COMPANY AR560
INVOICE
TRANS-TYPE
SEQUENCE
|
