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