1. Tables and Views for Financials
  2. AP_SELECTED_INVOICES_ALL

AP_SELECTED_INVOICES_ALL

AP_SELECTED_INVOICES_ALL is a temporary table that stores information about invoices selected for payment in a payment batch. Your Oracle Payables application inserts into this table after you initiate a payment batch. There will be one row for each invoice that Payables selects for payment in the current payment batch. When you build payments in a payment batch, your Oracle Payables application uses information in this table to create rows in AP_SELECTED_INVOICE_CHECKS. Information from this table appears in the Modify Payment Batch window.

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

AP_SELECTED_INVOICES_PK

CHECKRUN_NAME, INVOICE_ID, PAYMENT_NUM

Columns

Name Datatype Length Precision Not-null Comments
CHECKRUN_NAME VARCHAR2 255 Yes Name of payment process request submitted.
INVOICE_ID NUMBER 18 Yes Identifier of the invoice that is selected for payment.
PAYMENT_NUM NUMBER 18 Yes Payment number of the invoice that is selected for payment.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
SET_OF_BOOKS_ID NUMBER 18 Ledger identifier of the invoice selected for payment.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
VENDOR_ID NUMBER 18 Unique supplier identifier from the supplier tables.
VENDOR_SITE_ID NUMBER 18 Supplier site identifier of the invoice that is selected for payment.
VENDOR_NUM VARCHAR2 30 Supplier number of the invoice selected for payment.
VENDOR_NAME VARCHAR2 240 Supplier or employee who receives payment.
VENDOR_SITE_CODE VARCHAR2 240 Name of the supplier site of the invoice selected for payment.
CUSTOMER_NUM VARCHAR2 25 Customer number supplier uses for your company
ADDRESS_LINE1 VARCHAR2 240 First line of supplier site street address
ADDRESS_LINE2 VARCHAR2 240 Second line of supplier site street address
ADDRESS_LINE3 VARCHAR2 240 Third line of supplier site street address
CITY VARCHAR2 60 City of supplier site of the invoice selected for payment.
STATE VARCHAR2 150 State of supplier site of the invoice selected for payment.
ZIP VARCHAR2 60 Postal code of supplier site of the invoice selected for payment.
PROVINCE VARCHAR2 150 Province of supplier site address
COUNTRY VARCHAR2 60 Country of supplier site address
WITHHOLDING_STATUS_LOOKUP_CODE VARCHAR2 25 (Not currently used) Status that indicates if taxes should be withheld from supplier invoice payments
ATTENTION_AR_FLAG VARCHAR2 1 Flag that indicates if legend Attention Accounts Receivable will appear on payments (Y or N)
INVOICE_NUM VARCHAR2 50 Unique number for supplier invoice.
INVOICE_DATE DATE Invoice date on the invoice that is selected for payment.
VOUCHER_NUM VARCHAR2 50 Internal voucher number of the invoice selected for payment.
INVOICE_AMOUNT NUMBER Invoice amount selected for payment.
AMOUNT_PAID NUMBER Amount already paid on the invoice selected for payment.
DISCOUNT_AMOUNT_TAKEN NUMBER Discount amount previously taken
DUE_DATE DATE Date when the invoice or installment is due for payment.
DISCOUNT_DATE DATE Date from when the next discount is available.
INVOICE_DESCRIPTION VARCHAR2 240 Description entered for the invoice.
PAYMENT_PRIORITY NUMBER 2 Number representing payment priority of a scheduled payment (1 to 99)
AMOUNT_REMAINING NUMBER Invoice amount remaining for payment
DISCOUNT_AMOUNT_REMAINING NUMBER Amount available for discount on invoice amount remaining for payment
PAYMENT_AMOUNT NUMBER Amount to pay for invoice in payment batch
DISCOUNT_AMOUNT NUMBER Discount amount taken on invoice in payment batch
SEQUENCE_NUM NUMBER 18 Order in which Oracle Payables pays supplier invoices
OK_TO_PAY_FLAG VARCHAR2 1 Flag that indicates if invoices can be paid in a payment batch (Y or N)
DONT_PAY_REASON_CODE VARCHAR2 25 Reason that OK_TO_PAY_FLAG is N
ALWAYS_TAKE_DISCOUNT_FLAG VARCHAR2 1 Flag that indicates if discount taken regardless of when payment is made (Y or N)
AMOUNT_MODIFIED_FLAG VARCHAR2 1 Flag that indicates if selected amount has been modified (Y or N)
CHECK_NUMBER NUMBER 18 Payment document number of the invoice selected for payment.
INVOICE_EXCHANGE_RATE NUMBER Foreign currency exchange rate used for an invoice
PAYMENT_CROSS_RATE NUMBER If invoice currency and payment currency are associated fixed-rate currencies, this is the fixed-rate. Otherwise the value is 1
BANK_ACCOUNT_TYPE VARCHAR2 25 Bank account type that is used for invoice payment.
ORIGINAL_INVOICE_ID NUMBER Original invoice identifier, used for mapping an interest invoice back to invoice that it is based on in accordance with the terms of the Prompt Payment Act
ORIGINAL_PAYMENT_NUM NUMBER 18 Original payment number used for mapping an interest invoice back to invoice that it is based on in accordance with the terms of the Prompt Payment Act
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
BANK_ACCOUNT_NUM VARCHAR2 30 Bank account number of the bank account.
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 1 Flag that indicates invoice must be paid on separate payment document
PROPOSED_PAYMENT_AMOUNT NUMBER Payment amount for invoice in payment batch/Credit amount that will be applied to supplier's invoices in payment batch
PAY_SELECTED_CHECK_ID NUMBER 18 Identifier for negotiable check created for payment batch
PRINT_SELECTED_CHECK_ID NUMBER 18 Identifier for check on which invoice printed (same as PAY_SELECTED_CHECK_ID, except for overflow documents)
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
WITHHOLDING_AMOUNT NUMBER Amount withheld from an invoice
INVOICE_PAYMENT_ID NUMBER 18 Invoice payment identifier for an invoice payment in a payment batch
DONT_PAY_DESCRIPTION VARCHAR2 255 Reason that an invoice cannot be paid
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
TRANSFER_PRIORITY VARCHAR2 25 Transfer priority of the invoice selected for payment.
EXTERNAL_BANK_ACCOUNT_ID NUMBER 18 External bank account identifier
ADDRESS_LINE4 VARCHAR2 240 Fourth line of supplier site street address
IBAN_NUMBER VARCHAR2 40 International bank account number. Used internationally to uniquely identify the account of a customer at a financial institution. During bank entry, the system validates the value to ensure that it is a valid IBAN.
CHECKRUN_ID NUMBER 18 Payment Process Request Identifier
LEGAL_ENTITY_ID NUMBER 18 Identifier of the legal entity on invoice selected for payment.
PAYMENT_CURRENCY_CODE VARCHAR2 15 Payment currency code of the invoice selected for payment.
PAYMENT_GROUPING_NUMBER NUMBER 18 Logical grouping number of the payment.
PAYMENT_EXCHANGE_RATE NUMBER Exchange rate for a foreign currency payment
PAYMENT_EXCHANGE_RATE_TYPE VARCHAR2 30 Exchange rate type for a foreign currency payment
PAYMENT_EXCHANGE_DATE DATE Date for which exchange rate is obtained from daily rates table
AP_CCID NUMBER 18 Payables cross check identifier
FUTURE_PAY_DUE_DATE DATE Future payment due date for the invoice selected for payment.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
INVOICE_CURRENCY_CODE VARCHAR2 15 The currency in which a supplier invoice is received.
X_CURR_RATE NUMBER The conversion rate used to convert the invoice currency to payment currency.
PAYMENT_AMOUNT_INV_CURR NUMBER Payment Amount in Invoice Currency.
DISCOUNT_TAKEN_INV_CURR NUMBER The amount of discount taken in invoice currency.
INV_ORG_ID NUMBER 18 Invoicing Business Unit
WHT_AMOUNT_INV_CURR NUMBER Withholding tax amount in invoice currency.
BANK_COLLECTION_ID NUMBER 18 Collection document unique identifier associated with the invoice installment that is used to group payments.
REMIT_TO_SUPPLIER_NAME VARCHAR2 240 Third party supplier
REMIT_TO_SUPPLIER_ID NUMBER 18 Third party supplier identifier
REMIT_TO_ADDRESS_NAME VARCHAR2 240 Remit-to address where the payment should be sent
REMIT_TO_ADDRESS_ID NUMBER 18 Remit-to address identifier where the payment should be sent
BALANCING_SEGMENT_VALUE VARCHAR2 25 Balancing segment value of the charge distribution on the invoice. It will be null if multiple balancing segment values are available for an invoice.
ANNUAL_PERCENTAGE_RATE NUMBER Active discount percent rate for the dynamic discount calculation.
DAYS_ACCELERATED NUMBER Number of days used for the dynamic discount calculation.
APR_ASSIGNMENT_ID NUMBER 18 Unique identifier of the annual percentage rate associated with the supplier.
INSTALLMENT_RANK NUMBER System determined rank of an installment during selection process.
INCLUDED_CODE VARCHAR2 30 Whether selected installment is included for payment or not. Possible values are Y - included by system, N - excluded by system, I - included by user, E - excluded by user.
RANK_REASON_CODE VARCHAR2 30 Reason for system determined rank.
ANNUAL_INTEREST_RATE NUMBER Annual percentage rate of interest payable on overdue installments.
INTERIM_GROUPING_NUMBER NUMBER 18 Interim grouping number assigned to installments representing initial grouping without considering options related to maximizing credit and maximum documents per payment.
ASSIGNMENT_TYPE_CODE VARCHAR2 30 Type of assignment. Possible values are ASSIGNED, STANDING_OFFER, and UNSUBSCRIBED. ASSIGNED represents the supplier assigned to the campaign, STANDING_OFFER represents that the supplier has accepted the standing offer, and UNSUBSCRIBED represents that the supplier has unsubscribed from the campaign.
CAMPAIGN_NAME VARCHAR2 60 Name of the discount offer made to the supplier.

Foreign Keys

Table Foreign Table Foreign Key Column
AP_SELECTED_INVOICES_ALL ap_inv_selection_criteria_all CHECKRUN_ID
AP_SELECTED_INVOICES_ALL jl_br_ap_collection_docs_all BANK_COLLECTION_ID
AP_SELECTED_INVOICES_ALL poz_suppliers REMIT_TO_SUPPLIER_ID
AP_SELECTED_INVOICES_ALL hz_party_sites REMIT_TO_ADDRESS_ID
AP_SELECTED_INVOICES_ALL ap_invoices_all INVOICE_ID
AP_SELECTED_INVOICES_ALL gl_ledgers SET_OF_BOOKS_ID
AP_SELECTED_INVOICES_ALL poz_suppliers VENDOR_ID
AP_SELECTED_INVOICES_ALL ap_invoices_all ORIGINAL_INVOICE_ID
AP_SELECTED_INVOICES_ALL xle_entity_profiles LEGAL_ENTITY_ID
AP_SELECTED_INVOICES_ALL gl_code_combinations AP_CCID

Indexes

Index Uniqueness Tablespace Columns
AP_SELECTED_INVOICES_ALL_U1 Unique Default CHECKRUN_NAME, INVOICE_ID, PAYMENT_NUM
AP_SELECTED_INVOICES_N1 Non Unique Default INVOICE_ID, PAYMENT_NUM
AP_SELECTED_INVOICES_N2 Non Unique Default PRINT_SELECTED_CHECK_ID
AP_SELECTED_INVOICES_N3 Non Unique Default PAY_SELECTED_CHECK_ID
AP_SELECTED_INVOICES_N4 Non Unique Default ORIGINAL_INVOICE_ID, ORIGINAL_PAYMENT_NUM
AP_SELECTED_INVOICES_N5 Non Unique Default CHECKRUN_NAME, TO_CHAR("INVOICE_ID")
AP_SELECTED_INVOICES_N6 Non Unique Default VENDOR_SITE_ID
AP_SELECTED_INVOICES_N7 Non Unique Default CHECKRUN_ID, PAYMENT_GROUPING_NUMBER, OK_TO_PAY_FLAG