ARIITEM – Line Item Detail Interface
- System
- Accounts Receivable (AR)
- Prefix
ARI- Primary key
COMPANY,TRANS-TYPE,INVOICE,SEQUENCE- Fields
- 24
- Updated by
- 1 program
- Referenced by
- 0 programs
ARIITEM is the Line Item Detail Interface table in Lawson Accounts Receivable (prefix ARI). It is indexed by COMPANY, TRANS-TYPE, INVOICE, SEQUENCE (ARISET1); alternate indexes: ARISET2. It is updated by ARLL.1. The table has 24 fields, 2 indexes and 0 documented relations.
About ARIITEM
No description in the Lawson data dictionary.
Fields (24)
Column = COBOL field name without the ARI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ARI-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | ARLL.1 |
#ARI-TRANS-TYPE PKTRANS_TYPE | Alpha 1 | Required. Transaction type of the item. | ARLL.1 |
#ARI-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | ARLL.1 |
#ARI-SEQUENCE PKSEQUENCE | Numeric 6 | Required. The sequence number of the line item record. | ARLL.1 |
#ARI-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The description of the line item. | ARLL.1 |
#ARI-ITEMITEM | Alpha 32 | The line item number. | ARLL.1 |
#ARI-AMOUNTAMOUNT | Signed 18.2 | Required. The amount of the line item. | ARLL.1 |
#ARI-ITEM-USER1ITEM_USER1 | Alpha 20 | The User 1 field associated with the line item. | ARLL.1 |
#ARI-ACTIVITYACTIVITY | Alpha 15 | The activity assigned to the line item. | ARLL.1 |
#ARI-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | The account category assigned to the activity. | ARLL.1 |
#ARI-LINE-NBRLINE_NBR | Numeric 6 | This field contains the line number. | ARLL.1 |
#ARI-LINE-TYPELINE_TYPE | Alpha 1 | Indicates the Billing system line type of the line item. Valid values are:
| ARLL.1 |
#ARI-LINE-SEQLINE_SEQ | Numeric 3 | The sequence number of the Billing system transaction's line item. | ARLL.1 |
#ARI-INVL-OBJ-IDINVL_OBJ_ID | Numeric 12 | The object ID of the line item record. | ARLL.1 |
#ARI-SORT-1SORT_1 | Alpha 32 (Lower Case) | The transaction User Sort1 value. | ARLL.1 |
#ARI-SORT-2SORT_2 | Alpha 32 (Lower Case) | The transaction User Sort1 value. | ARLL.1 |
#ARI-SORT-3SORT_3 | Alpha 32 (Lower Case) | The transaction User Sort1 value. | ARLL.1 |
#ARI-SORT-4SORT_4 | Alpha 32 (Lower Case) | The transaction User Sort1 value. | ARLL.1 |
#ARI-ADJ-FLADJ_FL | Alpha 1 | — | — |
#ARI-CONTRACTCONTRACT | Alpha 15 | Activity Management contract. | ARLL.1 |
#ARI-ACTIVITY-GRPACTIVITY_GRP | Alpha 15 | The activity group is the overall project. | ARLL.1 |
#ARI-TRANS-USER1TRANS_USER1 | Alpha 10 | — | — |
#ARI-REASON-CODEREASON_CODE | Alpha 4 | — | — |
#ARI-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | — |
Indexes (2)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ARISET1 |
| Primary | — | |
ARISET2 |
| — |
Programs
Updated by (1)
- ARLL.1 AR Transaction Interface