|
|
ARAPSELECT FILE
This file contains "Selected" records used for the AR to AP Interface process
within AR48.
REFERENCED BY
AR129 AR130 AR131 AR135 AR251 AR30.1
AR30.2 AR30.6 AR30.8 AR30.3 AR30.7 AR32.1
AR32.3 AR33.1 AR33.3 AR33.6 AR33.5 AR34.1
AR34.2 AR34.3 AR34.4 AR38.1 AR38.2 AR38.3
AR39.1 AR39.2 AR80.2 AR80.1
UPDATED BY
AR17.1 AR300 AR45.1 AR48.1 AR48.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAI-COMPANY Numeric 4 AR48.1
Element: Company The number representing an AR company.
AAI-CUSTOMER Alpha 9 (Right Justified) AR48.1
Element: Customer This field contains the number that
represents a customer.
AAI-BATCH-NBR Numeric 6 AR48.1
Element: Batch Nbr This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
AAI-TRANS-TYPE Alpha 1 AR48.1
Element: Trans Type Determines if amounts or units are
processed in each transaction.
C = Credit Memo
D = Debit memo
I = Invoice
P = Payment
AAI-INVOICE Alpha 22 AR48.1
Element: Invoice Used to identify the invoice, debit
memo, credit memo or payment number.
AAI-PAYMENT-SEQ Numeric 6 AR48.1
Element: Seq Number 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 Numeric 1 AR48.1 AR48.3
Element: Status This field displays the status of the
transaction.
0 = Unreleased
1 = Released
AAI-AP-INVOICE Alpha 22 AR48.3
Element: Ap Invoice Contains the AP transaction number
related to this ARAPSELECT record.
AAI-BASE-AMT Signed 18.2 AR48.1
Element: Intl Amt
AAI-ORIG-AMT Signed 18.2 AR48.1
Element: Intl Amt Amount of transaction in original
currency amount.
AAI-DISPUTE-FL Alpha 1 AR45.1 AR48.1
Element: Dispute Fl Contains an indicator if the transaction
is in dispute.
Valid Values are:
Y = Disputed
N = Not in Dispute
AAI-COMMENT-FL Alpha 1 AR17.1 AR48.1
Element: Comment Fl Contains an indicator if the transaction
has an assocaited comment record. Valid
values are:
Y = Comment exists for transaction
N = No comment exists
AAI-TRANS-DATE Numeric 8 (yyyymmdd) AR48.1
Element: Trans Date The date of the transaction.
AAI-DUE-DATE Numeric 8 (yyyymmdd) AR48.1
Element: Due Date The transaction due date.
AAI-CURRENCY-CODE Alpha 5 AR48.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
AAI-ACTIVITY Alpha 15
Element: Activity 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 Alpha 5
Element: Acct Category 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 AR48.3
BATCH-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
AAISET2 COMPANY Subset AR129 AR130
TRANS-TYPE Where TRANS-TYPE = "C" AR131 AR135
INVOICE Or TRANS-TYPE = "D" AR17.1 AR251
PAYMENT-SEQ Or TRANS-TYPE = "I" AR30.1 AR30.2
AR30.6 AR30.8
AR300 AR32.1
AR32.3 AR33.1
AR33.3 AR33.6
AR34.1 AR34.2
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR45.1
AR48.1 AR80.2
AAISET3 COMPANY Subset AR129 AR130
CUSTOMER Where TRANS-TYPE = "P" AR135 AR251
BATCH-NBR AR30.1 AR30.2
PAYMENT-SEQ AR30.3 AR30.6
AR30.7 AR30.8
AR300 AR32.1
AR33.1 AR33.3
AR33.5 AR33.6
AR34.1 AR34.3
AR34.4 AR48.1
AR80.1
AAISET4 COMPANY AR48.1 AR48.3
CUSTOMER
STATUS
BATCH-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
|
