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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#AAI-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.—
#AAI-CUSTOMER SET3 SET4
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.—
#AAI-BATCH-NBR PK
BATCH_NBR		Numeric 6This identifies the batch the entered invoices, debit memos, and credit memos are a part of.—
#AAI-TRANS-TYPE PK
TRANS_TYPE		Alpha 1Determines if amounts or units are processed in each transaction.
  • C Credit Memo
  • D Debit memo
  • I Invoice
  • P Payment
—
#AAI-INVOICE PK
INVOICE		Alpha 22Used to identify the invoice, debit memo, credit memo or payment number.—
#AAI-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6Payment 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-STATUS SET4
STATUS		Numeric 1This field displays the status of the transaction.
  • 0 Unreleased
  • 1 Released
—
#AAI-AP-INVOICE
AP_INVOICE		Alpha 22Contains the AP transaction number related to this ARAPSELECT record.—
#AAI-BASE-AMT
BASE_AMT		Signed 18.2——
#AAI-ORIG-AMT
ORIG_AMT		Signed 18.2Amount of transaction in original currency amount.—
#AAI-DISPUTE-FL
DISPUTE_FL		Alpha 1Contains an indicator if the transaction is in dispute. Valid Values are:
  • Y Disputed
  • N Not in Dispute
—
#AAI-COMMENT-FL
COMMENT_FL		Alpha 1Contains an indicator if the transaction has an assocaited comment record. Valid values are:
  • Y Comment exists for transaction
  • N No comment exists
AR17.1
#AAI-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction.—
#AAI-DUE-DATE
DUE_DATE		Numeric 8 (yyyymmdd)The transaction due date.—
#AAI-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
#AAI-ACTIVITY
ACTIVITY		Alpha 15Activities 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-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AAISET1
  1. COMPANY
  2. BATCH-NBR
  3. TRANS-TYPE
  4. INVOICE
  5. PAYMENT-SEQ
Primary—
AAISET2
  1. COMPANY
  2. TRANS-TYPE
  3. INVOICE
  4. PAYMENT-SEQ
SubsetWhere TRANS-TYPE = "C" Or TRANS-TYPE = "D" Or TRANS-TYPE = "I"AR17.1
AAISET3
  1. COMPANY
  2. CUSTOMER
  3. BATCH-NBR
  4. PAYMENT-SEQ
SubsetWhere TRANS-TYPE = "P"—
AAISET4
  1. COMPANY
  2. CUSTOMER
  3. STATUS
  4. BATCH-NBR
  5. TRANS-TYPE
  6. INVOICE
  7. PAYMENT-SEQ
—

Programs

Updated by (1)