|
|
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 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 company number represents an
established company and is entered on
all function codes.
AAI-CUSTOMER Alpha 9 (Right Justified) AR48.1
Element: Customer NumbeThis field contains the number that
represents a customer.
AAI-BATCH-NBR Numeric 6 AR48.1
Element: 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
Element: Transaction TyDetermines 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 NumberUsed to identify the invoice, debit
memo, credit memo or payment number.
AAI-PAYMENT-SEQ Numeric 6 AR48.1
Record Sequence Payment Sequence. This is the generated
Number 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
AAI-BASE-AMT Signed 15.2 AR48.1
Element: Base Amount This is the amount of the transaction in
the company base amount.
AAI-ORIG-AMT Signed 15.2 AR48.1
Element: Adj Amt
AAI-DISPUTE-FL Alpha 1 AR45.1 AR48.1
Element: Dispute Fl
AAI-COMMENT-FL Alpha 1 AR17.1 AR48.1
Element: Comment Flag
AAI-TRANS-DATE Numeric 8 (yyyymmdd) AR48.1
Element: Date
AAI-DUE-DATE Numeric 8 (yyyymmdd) AR48.1
Element: 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 ).
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 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
AR80.2
AAISET3 COMPANY Subset AR129 AR130
CUSTOMER Where TRANS-TYPE = "P" AR135 AR30.1
BATCH-NBR AR30.2 AR30.3
PAYMENT-SEQ AR30.4 AR30.6
AR30.7 AR30.8
AR30.9 AR300
AR31.1 AR31.5
AR31.6 AR48.1
AR80.1
AAISET4 COMPANY AR48.1 AR48.3
CUSTOMER
STATUS
BATCH-NBR
TRANS-TYPE
INVOICE
PAYMENT-SEQ
|
