ARIITEM

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
ARLL.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARI-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ARLL.1
ARI-TRANS-TYPE
Element: Transaction Type
Alpha 1
Required. Transaction type of the item.
ARLL.1
ARI-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
ARLL.1
ARI-SEQUENCE
Element: Sequence
Numeric 6
Required. The sequence number of the line item record.
ARLL.1
ARI-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description of the line item.
ARLL.1
ARI-ITEM
Element: Item Number
Alpha 32
The line item number.
ARLL.1
ARI-AMOUNT
Element: Intl Amt
Signed 18.2
Required. The amount of the line item.
ARLL.1
ARI-ITEM-USER1
Element: Item User 1
Alpha 20
The User 1 field associated with the line item.
ARLL.1
ARI-ACTIVITY
Element: Activity
Alpha 15
The activity assigned to the line item.
ARLL.1
ARI-ACCT-CATEGORY
Element: Account Category
Alpha 5
The account category assigned to the activity.
ARLL.1
ARI-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
ARLL.1
ARI-LINE-TYPE
Element: Line Type
Alpha 1
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
ARLL.1
ARI-LINE-SEQ
Line Item Sequence
Number
Numeric 3
The sequence number of the Billing system transaction's line item.
ARLL.1
ARI-INVL-OBJ-ID
Element: Invl Obj Id
Numeric 12
The object ID of the line item record.
ARLL.1
ARI-SORT-1
Element: Sort 1
Alpha 32 (Lower Case)
The transaction User Sort1 value.
ARLL.1
ARI-SORT-2
Element: Sort 2
Alpha 32 (Lower Case)
The transaction User Sort1 value.
ARLL.1
ARI-SORT-3
Element: Sort 3
Alpha 32 (Lower Case)
The transaction User Sort1 value.
ARLL.1
ARI-SORT-4
Element: Sort 4
Alpha 32 (Lower Case)
The transaction User Sort1 value.
ARLL.1
ARI-ADJ-FL
Element: Flag1
Alpha 1
ARI-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
ARLL.1
ARI-ACTIVITY-GRP
Element: Activity Grp
Alpha 15
The activity group is the overall project.
ARLL.1
ARI-TRANS-USER1
Element: Trans User1
Alpha 10
ARI-REASON-CODE
Element: Reason Code
Alpha 4


ARIITEM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARISET1 COMPANY
TRANS-TYPE
INVOICE
SEQUENCE
ARISET2 COMPANY
INVOICE
TRANS-TYPE
SEQUENCE


File created: Thu Jun 09 11:09:02 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.