ARITEM – Line Item Detail
- System
- Accounts Receivable (AR)
- Prefix
AIR- Primary key
COMPANY,TRANS-TYPE,INVOICE,SEQUENCE- Fields
- 16
- Updated by
- 0 programs
- Referenced by
- 0 programs
ARITEM is the Line Item Detail table in Lawson Accounts Receivable (prefix AIR). It is indexed by COMPANY, TRANS-TYPE, INVOICE, SEQUENCE (AIRSET1). The table has 16 fields, 1 index and 0 documented relations.
About ARITEM
The AR Line Item file is a temporary file and is used for online entry of open item line items in AR43 Transaction Entry. Upon release, each line item will become a separate open item referencing the transaction number, and is kept unique by a payment sequence number. The AR Line Item record is deleted upon release.
Fields (16)
Column = COBOL field name without the AIR- 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 |
|---|---|---|---|
#AIR-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | — |
#AIR-TRANS-TYPE PKTRANS_TYPE | Alpha 1 | Indicates the transaction type. | — |
#AIR-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | — |
#AIR-SEQUENCE PKSEQUENCE | Numeric 6 | The sequence number of the line item record. | — |
#AIR-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Contains the description of the line item. | — |
#AIR-ITEMITEM | Alpha 32 | This field contains the item identifier. | — |
#AIR-ACTIVITYACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are exapmle reasons for performing the activity. | — |
#AIR-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. | — |
#AIR-ITEM-USER1ITEM_USER1 | Alpha 20 | The User 1 field associated with the line item. This becomes the open item's trans user 1 field used primarily for cash application sorting of open items. | — |
#AIR-AMOUNTAMOUNT | Signed 18.2 | The amount associated with the line item. | — |
#AIR-SORT-1SORT_1 | Alpha 32 (Lower Case) | The custom sort 1 value used for sorting purposes in cash application and credit management inquiry. | — |
#AIR-SORT-2SORT_2 | Alpha 32 (Lower Case) | The custom sort 2 value used for sorting purposes in cash application and credit management inquiry. | — |
#AIR-SORT-3SORT_3 | Alpha 32 (Lower Case) | The custom sort 3 value used for sorting purposes in cash application and credit management inquiry. | — |
#AIR-SORT-4SORT_4 | Alpha 32 (Lower Case) | The custom sort 4 value used for sorting purposes in cash application and credit management inquiry. | — |
#AIR-TRANS-USER1TRANS_USER1 | Alpha 10 | — | — |
#AIR-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | — |
Indexes (1)
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 |
|---|---|---|---|---|
AIRSET1 |
| Primary | ARLL.1 |
Programs
No Lawson programs are documented as updating or referencing this table.