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 |
|
||
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 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AAISET1 |
COMPANY BATCH-NBR TRANS-TYPE INVOICE PAYMENT-SEQ |
|
|||||||||||||||||||||||||||
AAISET2 |
COMPANY TRANS-TYPE INVOICE PAYMENT-SEQ |
|
| ||||||||||||||||||||||||||
AAISET3 |
COMPANY CUSTOMER BATCH-NBR PAYMENT-SEQ |
|
|||||||||||||||||||||||||||
AAISET4 |
COMPANY CUSTOMER STATUS BATCH-NBR TRANS-TYPE INVOICE PAYMENT-SEQ |
|
All trademarks and registered trademarks are the property of their
respective owners.