ARAPSELECT FILE
REFERENCED BY
AR129 AR130 AR131 AR135 AR30.1 AR30.2
AR30.3 AR30.4 AR30.6 AR30.8 AR30.9 AR30.7
AR31.6 AR31.1 AR31.5
UPDATED BY
AR17.1 AR300 AR45.1 AR48.1 AR48.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAI-COMPANY Numeric 4 AR48.1
Company The company number represents an
established company and is entered on
all function codes.
AAI-CUSTOMER Alpha 9 (Right Justified) AR48.1
Customer Number This field contains the number that
represents a customer.
AAI-BATCH-NBR Numeric 6 AR48.1
Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
AAI-TRANS-TYPE Alpha 1 AR48.1
Transaction 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
Invoice Number Used to identify the invoice, debit
memo, credit memo or payment number.
AAI-PAYMENT-SEQ Numeric 6 AR48.1
Payment Seq 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
Status This field displays the status of the
transaction.
0 = Unreleased
1 = Released
AAI-AP-INVOICE Alpha 22 AR48.3
Ap Invoice
AAI-BASE-AMT Signed 15.2 AR48.1
Base Amount This is the amount of the transaction in
the company base amount.
AAI-ORIG-AMT Signed 15.2 AR48.1
Original Amount
AAI-DISPUTE-FL Alpha 1 AR45.1 AR48.1
Dispute Fl
AAI-COMMENT-FL Alpha 1 AR17.1 AR48.1
Comment Flag
AAI-TRANS-DATE Numeric 8 (yyyymmdd) AR48.1
Transaction Date The date of the transaction.
AAI-DUE-DATE Numeric 8 (yyyymmdd) AR48.1
Due Date The transaction due date.
AAI-CURRENCY-CODE Alpha 5 AR48.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
ARAPSELECT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AAISET1 COMPANY
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 AR30.1
PAYMENT-SEQ Or TRANS-TYPE = "I" AR30.2 AR30.3
AR30.4 AR30.6
AR30.8 AR30.9
AR300 AR31.6
AR45.1 AR48.1
AAISET3 COMPANY Subset AR129 AR130
CUSTOMER Where TRANS-TYPE = "P" AR135 AR30.1
BATCH-NBR AR30.2 AR30.3
PAYMENT-SEQ AR30.4 AR30.7
AR30.8 AR30.9
AR300 AR31.1
AR31.5 AR31.6
AR48.1
AAISET4 COMPANY AR48.1 AR48.3
CUSTOMER
STATUS
BATCH-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
|
