ARAPSELECT

This file contains "Selected" records used for the AR to AP Interface process within AR48.
UPDATED BY
AR17.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAI-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
AAI-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AAI-BATCH-NBR
Element: Batch Nbr
Numeric 6
This identifies the batch the entered invoices, debit memos, and credit memos are a part of.
AAI-TRANS-TYPE
Element: Trans Type
Alpha 1
Determines if amounts or units are processed in each transaction.
C = Credit Memo
D = Debit memo
I = Invoice
P = Payment
AAI-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice, debit memo, credit memo or payment number.
AAI-PAYMENT-SEQ
Element: Seq Number
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-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
0 = Unreleased
1 = Released
AAI-AP-INVOICE
Element: Ap Invoice
Alpha 22
Contains the AP transaction number related to this ARAPSELECT record.
AAI-BASE-AMT
Element: Intl Amt
Signed 18.2
AAI-ORIG-AMT
Element: Intl Amt
Signed 18.2
Amount of transaction in original currency amount.
AAI-DISPUTE-FL
Element: Dispute Fl
Alpha 1
Contains an indicator if the transaction is in dispute. Valid Values are: Y = Disputed N = Not in Dispute
AAI-COMMENT-FL
Element: Comment Fl
Alpha 1
Contains 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
Element: Trans Date
Numeric 8 (yyyymmdd)
The date of the transaction.
AAI-DUE-DATE
Element: Due Date
Numeric 8 (yyyymmdd)
The transaction due date.
AAI-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AAI-ACTIVITY
Element: Activity
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-CATEGORY
Element: Acct 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


ARAPSELECT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AAISET1 COMPANY
BATCH-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AAISET2 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
Subset
WhereTRANS-TYPE ="C"
OrTRANS-TYPE ="D"
OrTRANS-TYPE ="I"
AR17.1
AAISET3 COMPANY
CUSTOMER
BATCH-NBR
PAYMENT-SEQ
Subset
WhereTRANS-TYPE ="P"
AAISET4 COMPANY
CUSTOMER
STATUS
BATCH-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ


File created: Thu Jun 09 02:08:57 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.