ARAPSELECT – No description in the Lawson data dictionary
- System
- Accounts Receivable (AR)
- Prefix
AAI- Primary key
COMPANY,BATCH-NBR,TRANS-TYPE,INVOICE,PAYMENT-SEQ- Fields
- 17
- Updated by
- 1 program
- Referenced by
- 0 programs
ARAPSELECT is a Lawson Accounts Receivable table (prefix AAI); no description in the lawson data dictionary. It is indexed by COMPANY, BATCH-NBR, TRANS-TYPE, INVOICE, PAYMENT-SEQ (AAISET1); alternate indexes: AAISET2, AAISET3 and AAISET4. It is updated by AR17.1. The table has 17 fields, 4 indexes and 0 documented relations.
About ARAPSELECT
No description in the Lawson data dictionary.
Fields (17)
Column = COBOL field name without the AAI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
AAI-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | — |
AAI-CUSTOMERCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | — |
AAI-BATCH-NBR PKBATCH_NBR | Numeric 6 | This identifies the batch the entered invoices, debit memos, and credit memos are a part of. | — |
AAI-TRANS-TYPE PKTRANS_TYPE | Alpha 1 | Determines if amounts or units are processed in each transaction.
| — |
AAI-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice, debit memo, credit memo or payment number. | — |
AAI-PAYMENT-SEQ PKPAYMENT_SEQ | Numeric 6 | Payment Sequence. This is the generated sequence number to separate individual invoice, debit memo, or credit memo payment requirements. It also represents the entered sequence number within a batch for a payment. | — |
AAI-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction.
| — |
AAI-AP-INVOICEAP_INVOICE | Alpha 22 | Contains the AP transaction number related to this ARAPSELECT record. | — |
AAI-BASE-AMTBASE_AMT | Signed 18.2 | — | — |
AAI-ORIG-AMTORIG_AMT | Signed 18.2 | Amount of transaction in original currency amount. | — |
AAI-DISPUTE-FLDISPUTE_FL | Alpha 1 | Contains an indicator if the transaction is in dispute. Valid Values are:
| — |
AAI-COMMENT-FLCOMMENT_FL | Alpha 1 | Contains an indicator if the transaction has an assocaited comment record. Valid values are:
| AR17.1 |
AAI-TRANS-DATETRANS_DATE | Numeric 8 (yyyymmdd) | The date of the transaction. | — |
AAI-DUE-DATEDUE_DATE | Numeric 8 (yyyymmdd) | The transaction due date. | — |
AAI-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | — |
AAI-ACTIVITYACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | — |
AAI-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. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru | — |
Indexes (4)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AAISET1 | COMPANY, BATCH-NBR, TRANS-TYPE, INVOICE, PAYMENT-SEQ | Primary | — | |
AAISET2 | COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ | Subset | Where TRANS-TYPE = "C" Or TRANS-TYPE = "D" Or TRANS-TYPE = "I" | AR17.1 |
AAISET3 | COMPANY, CUSTOMER, BATCH-NBR, PAYMENT-SEQ | Subset | Where TRANS-TYPE = "P" | — |
AAISET4 | COMPANY, CUSTOMER, STATUS, BATCH-NBR, TRANS-TYPE, INVOICE, PAYMENT-SEQ | — |
Programs
Updated by (1)
- AR17.1 Comments