1. Tables and Views for Financials
  2. AP_INVOICES_ALL

AP_INVOICES_ALL

AP_INVOICES_ALL contains records for invoices you enter. There is one row for each invoice youenter. An invoice can have one or more invoice distribution lines. An invoice can also have one or more scheduled payments. An invoice of type EXPENSE REPORT must relate to a row in AP_EXPENSE_REPORT_HEADERS_ALL unless the record has been purged from AP_EXPENSE_REPORT_HEADERS_ALL. Your Oracle Payables application uses the INTEREST type invoice for interest that it calculates on invoices that are overdue. Your Oracle Payables application links the interest invoice to the original invoice by inserting the INVOICE_ID in the AP_INVOICE_RELATIONSHIPS table. This table corresponds to the Invoices window.

Details

  • Schema: FUSION

  • Object owner: AP

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

AP_INVOICES_ALL_PK

INVOICE_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
INVOICE_ID NUMBER 18 Yes Unique invoice identifier. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
VENDOR_ID NUMBER 18 Invoice supplier identifier. Active
INVOICE_NUM VARCHAR2 50 Yes Unique number for supplier invoice. Active
SET_OF_BOOKS_ID NUMBER 18 Yes Ledger identifier of the invoice. Active
INVOICE_CURRENCY_CODE VARCHAR2 15 Yes Currency code used on the invoice. Active
PAYMENT_CURRENCY_CODE VARCHAR2 15 Yes Currency code of payment (must be same as INVOICE_CURRENCY_CODE or have a fixed rate relationship) Active
PAYMENT_CROSS_RATE NUMBER Yes Exchange rate between invoice and payment; in Release 11 the value is always 1 unless they are associated fixed-rate currencies Active
INVOICE_AMOUNT NUMBER Invoice amount in transaction currency. Active
VENDOR_SITE_ID NUMBER 18 Physical location of the supplier. Active
AMOUNT_PAID NUMBER Amount paid against an invoice. Active
DISCOUNT_AMOUNT_TAKEN NUMBER Discount amount on an invoice. Active
INVOICE_DATE DATE Date when an event will occur or occurred. Active
SOURCE VARCHAR2 25 Feeder system from which an invoice is imported. Active
INVOICE_TYPE_LOOKUP_CODE VARCHAR2 25 Invoice category, such as standard, credit memo, or prepayment. Active
DESCRIPTION VARCHAR2 240 Statement that describes the invoice. Active
BATCH_ID NUMBER 18 Unique invoice group identifier. Active
AMOUNT_APPLICABLE_TO_DISCOUNT NUMBER Amount of invoice applicable to a discount Active
TERMS_ID NUMBER 18 Payment terms identifier used on the invoice. Active
TERMS_DATE DATE Date used with payment terms to calculate scheduled payment of an invoice Active
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 25 Indicates the payment method of the invoice. Active
PAY_GROUP_LOOKUP_CODE VARCHAR2 25 Groups a category of suppliers or invoices for single pay run. For example, employees, merchandise, nonmerchandise, government, domestic, and international. Active
ACCTS_PAY_CODE_COMBINATION_ID NUMBER 18 Accounting Flexfield identifier for accounts payable liability account Active
PAYMENT_STATUS_FLAG VARCHAR2 1 Flag that indicates if invoice has been paid (Y, N, or P) Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
BASE_AMOUNT NUMBER When the Calculate User Exchange Rate option is enabled and when the exchange rate type is User, the user can enter a value for BASE_AMOUNT so the system can calculate the exchange rate. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 1 Pay invoice on separate payment document flag Active
PO_HEADER_ID NUMBER 18 the PO number the invoice is matched to. Active
FREIGHT_AMOUNT NUMBER Total freight amount for an invoice. Active
GOODS_RECEIVED_DATE DATE Date when goods on the invoice were received. Active
INVOICE_RECEIVED_DATE DATE Date when the invoice was received. This is used to calculate when the invoice is due. Active
VOUCHER_NUM VARCHAR2 50 Voucher number; validated (Sequential Numbering enabled) or non-validated (Sequential Numbering not enabled) Active
APPROVED_AMOUNT NUMBER Invoice amount approved through manual authorization for payment (used for reference purposes only). Active
RECURRING_PAYMENT_ID NUMBER 18 Recurring invoice identifier. Active
EARLIEST_SETTLEMENT_DATE DATE Date associated with a prepayment after which you can apply the prepayment against invoices. Only used for temporary prepayments. Column is null for permanent prepayments and other invoice types Active
DOC_SEQUENCE_ID NUMBER Sequential Numbering (voucher number) document sequence identifier Active
DOC_SEQUENCE_VALUE NUMBER Voucher number (Sequential Numbering) for invoice Active
DOC_CATEGORY_CODE VARCHAR2 30 Sequential Numbering (voucher number) document category Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE15 VARCHAR2 1000 Descriptive Flexfield: segment of the user descriptive flexfield. Invoices (AP_INVOICES) Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Invoices (AP_INVOICES) Active
APPROVAL_STATUS VARCHAR2 25 Status of manual authorization invoice approval (used for reference purposes only). Active
APPROVAL_DESCRIPTION VARCHAR2 240 Description of manual authorization invoice approval (used for reference purposes only). Active
POSTING_STATUS VARCHAR2 15 Status that indicates if invoice can be posted (either Available or N - column is populated, but not used) Active
CANCELLED_DATE DATE Date when the invoice was canceled. Active
CANCELLED_BY VARCHAR2 64 User ID of person who canceled an invoice. Active
CANCELLED_AMOUNT NUMBER Original amount of canceled invoice. Active
TEMP_CANCELLED_AMOUNT NUMBER Column for recording the original amount of an invoice until cancellation completes successfully Active
USSGL_TRANSACTION_CODE VARCHAR2 30 Default transaction code for creating US Standard General Ledger journal entries (Oracle Public Sector Payables) Active
USSGL_TRX_CODE_CONTEXT VARCHAR2 30 USSGL Transaction Code Descriptive Flexfield context column Active
PROJECT_ID NUMBER 18 Identifier for project used to build default Accounting Flexfield Active
TASK_ID NUMBER 18 Identifier for project task used to build default Accounting Flexfield Active
EXPENDITURE_TYPE VARCHAR2 30 Project expenditure type used to build default Accounting Flexfield Active
EXPENDITURE_ITEM_DATE DATE Project expenditure item date used to build default Accounting Flexfield Active
PA_QUANTITY NUMBER Project item quantity used to build default Accounting Flexfield Active
EXPENDITURE_ORGANIZATION_ID NUMBER 18 Identifier for project organization used to build default Accounting Flexfield Active
PA_DEFAULT_DIST_CCID NUMBER 18 Identifier for project-related invoice default Accounting Flexfield (defaults to invoice distribution lines) Active
PAYMENT_AMOUNT_TOTAL NUMBER Amount of invoice that has been paid Active
AWT_FLAG VARCHAR2 1 Flag to indicate if Automatic Withholding Tax has been calculated automatically (A), or manually (M) Active
AWT_GROUP_ID NUMBER 18 Withholding tax group identifier Active
REFERENCE_1 VARCHAR2 30 Reference information from Oracle Projects expense reports Active
REFERENCE_2 VARCHAR2 30 Reference information from Oracle Projects expense reports Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
PRE_WITHHOLDING_AMOUNT NUMBER Reserved for future use Active
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
PAYMENT_CROSS_RATE_TYPE VARCHAR2 30 Cross currency payment rate type (only valid value in this release is EMU Fixed) Active
PAYMENT_CROSS_RATE_DATE DATE Cross currency payment rate date Active
PAY_CURR_INVOICE_AMOUNT NUMBER Invoice amount in the payment currency Active
MRC_BASE_AMOUNT VARCHAR2 2000 Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and invoice amount in the reporting currency pairs Active
MRC_EXCHANGE_RATE VARCHAR2 2000 Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and currency conversion rate pairs Active
MRC_EXCHANGE_RATE_TYPE VARCHAR2 2000 Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and currency conversion rate type pairs Active
MRC_EXCHANGE_DATE VARCHAR2 2000 Multiple Reporting Currencies only: Concatenated string of reporting set of books ID and currency conversion date pairs Active
MRC_POSTING_STATUS VARCHAR2 2000 Multiple Reporting Currencies only: Concatenated string of reporting set of books ID Active
GL_DATE DATE Yes Accounting date to default to invoice distributions Active
AWARD_ID NUMBER 18 If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information Active
PAID_ON_BEHALF_EMPLOYEE_ID NUMBER 18 When an expense report gets split in Both Pay scenario, the new expense report's paid_on_behalf_employee_id gets populated with the original expense report's employee_id. Active
AMT_DUE_CCARD_COMPANY NUMBER Amount that is due to credit card company Active
AMT_DUE_EMPLOYEE NUMBER Amount that is due to an employee. Active
APPROVAL_READY_FLAG VARCHAR2 1 Yes Indicates whether invoice is ready for the Invoice Approval Workflow process (Y or N) Active
APPROVAL_ITERATION NUMBER 9 Count of times invoice has passed through the Invoice Approval Workflow process Active
WFAPPROVAL_STATUS VARCHAR2 50 Yes Status of invoice in the Invoice Approval Workflow process Active
REQUESTER_ID NUMBER 18 Requester of invoice is used by the Invoice Approval Workflow process to generate the list of approvers Active
VALIDATION_REQUEST_ID NUMBER 18 Identifier for the invoice validation concurrent request that is currently processing the invoice. Active
VALIDATED_TAX_AMOUNT NUMBER Total tax amount excluded from the discountable amount Active
QUICK_CREDIT VARCHAR2 1 Indicates whether a Credit or Debit Memo was created as a Quick Credit Active
CREDITED_INVOICE_ID NUMBER 18 Identifier for invoice to be fully reversed by a Credit or Debit Memo Active
DISTRIBUTION_SET_ID NUMBER 18 Distribution set identifier to be used in the generation of an invoice line and corresponding distributions for the line Active
APPLICATION_ID NUMBER 18 Unique identifier that identifies the application from where the invoice originated. Active
PRODUCT_TABLE VARCHAR2 30 Name of the product source table used for generating an invoice. Active
REFERENCE_KEY1 VARCHAR2 4000 Primary key information that will uniquely identify a record in other products view Active
REFERENCE_KEY2 VARCHAR2 150 Primary key information that will uniquely identify a record in other products view Active
REFERENCE_KEY3 VARCHAR2 150 Primary key information that will uniquely identify a record in other products view Active
REFERENCE_KEY4 VARCHAR2 150 Primary key information that will uniquely identify a record in other products view Active
REFERENCE_KEY5 VARCHAR2 150 Primary key information that will uniquely identify a record in other products view Active
TOTAL_TAX_AMOUNT NUMBER Total tax charged on an invoice. Active
SELF_ASSESSED_TAX_AMOUNT NUMBER Total self-assessed tax amount on the invoice. Active
TAX_RELATED_INVOICE_ID NUMBER 18 Tax related to an invoice. Active
TRX_BUSINESS_CATEGORY VARCHAR2 240 Identifies the taxable nature of a transaction based on the business. Active
USER_DEFINED_FISC_CLASS VARCHAR2 240 User Defined Fiscal Classification Active
TAXATION_COUNTRY VARCHAR2 30 Country in which the transaction occurred. Oracle Fusion tax sets the context of other tax drivers, such as Product Fiscal Classification based on this value. Active
DOCUMENT_SUB_TYPE VARCHAR2 240 Classification to categorize a document associated with a transaction for tax. This affects the taxability of the transaction. Active
SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 150 Invoice supplier tax invoice number. Active
SUPPLIER_TAX_INVOICE_DATE DATE Date when the supplier charged tax, as shown on the purchase order. Active
SUPPLIER_TAX_EXCHANGE_RATE NUMBER Conversion rate for taxes on a supplier invoice. Active
TAX_INVOICE_RECORDING_DATE DATE Date when the invoice was recorded. Active
TAX_INVOICE_INTERNAL_SEQ VARCHAR2 150 Invoice internal sequence number. Active
LEGAL_ENTITY_ID NUMBER 18 Unique identifier of the legal entity. Active
HISTORICAL_FLAG VARCHAR2 1 Flag that indicates whether a document or invoice is upgraded from a prior release or is newly created. Active
FORCE_REVALIDATION_FLAG VARCHAR2 1 Indicator to enable revalidation of the invoice. Active
BANK_CHARGE_BEARER VARCHAR2 30 Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER Active
REMITTANCE_MESSAGE1 VARCHAR2 150 Remittance message for use in payment processing Active
REMITTANCE_MESSAGE2 VARCHAR2 150 Remittance message for use in payment processing Active
REMITTANCE_MESSAGE3 VARCHAR2 150 Remittance message for use in payment processing Active
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 256 Unique remittance identifier provided by the payee Active
URI_CHECK_DIGIT VARCHAR2 2 Unique remittance identifier check digit Active
SETTLEMENT_PRIORITY VARCHAR2 30 The priority with which the financial institution or payment system should settle payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY Active
PAYMENT_REASON_CODE VARCHAR2 30 Codes provided by the government or central bank of a country. These codes provide the payment system or bank with additional details about the reason for the payment and are used for regulatory reporting purposes. Active
PAYMENT_REASON_COMMENTS VARCHAR2 240 Free text field available for entering a reason for the payment Active
PAYMENT_METHOD_CODE VARCHAR2 30 Indicates the payment method, such as check, cash, or credit. Active
DELIVERY_CHANNEL_CODE VARCHAR2 30 Text on electronic payment that instructs the bank about the execution of payment. For example, print a check and hold it for collection by the payee. Active
QUICK_PO_HEADER_ID NUMBER 18 PO Number ID is used for QuickMatch and to default values from the purchase order to the invoice header. Active
NET_OF_RETAINAGE_FLAG VARCHAR2 1 Flag to indicate invoice amount is net of retainage Active
RELEASE_AMOUNT_NET_OF_TAX NUMBER Invoice amount net of tax for retainage release invoices Active
CONTROL_AMOUNT NUMBER User-enterable value to ensure that the calculated tax will be the same as on the physical document. Active
PARTY_ID NUMBER 18 An entity that can enter into business relationships with other entities and that submits invoices or other requests for payment. In some cases, goods or services or both are provided in return for payment. Active
PARTY_SITE_ID NUMBER 18 Unique identity of the party site. Active
PAY_PROC_TRXN_TYPE_CODE VARCHAR2 30 Type of payment processing transaction or document Active
PAYMENT_FUNCTION VARCHAR2 30 The function or purpose of the payment Active
CUST_REGISTRATION_CODE VARCHAR2 50 Customer legal registration code Active
CUST_REGISTRATION_NUMBER VARCHAR2 30 Customer legal registration number Active
PORT_OF_ENTRY_CODE VARCHAR2 30 Code that identifies the location or port through which the invoiced goods entered the country. Active
EXTERNAL_BANK_ACCOUNT_ID NUMBER 18 External bank account identifier Active
VENDOR_CONTACT_ID NUMBER 18 Foreign Key to PO_VENDOR_CONTACTS Active
INTERNAL_CONTACT_EMAIL VARCHAR2 2000 Email address of possible internal contact Active
DISC_IS_INV_LESS_TAX_FLAG VARCHAR2 1 Flag that indicates if tax amount is excluded from the discountable amount when invoice amount applicable to discount is calculated (Y or N) Active
EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 1 Flag that indicates whether the freight amount is excluded from the discountable amount when calculating the discount (Y or N) Active
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. Active
EXCHANGE_RATE_TYPE VARCHAR2 30 Source of currency conversion rate for an invoice. For example, user defined, spot, or corporate. Active
EXCHANGE_RATE NUMBER Ratio at which the principal unit of one currency is converted into another currency for an invoice. Active
EXCHANGE_DATE DATE Date when a conversion rate is used to convert an amount into another currency for an invoice. Active
EMPLOYEE_ADDRESS_CODE VARCHAR2 15 Address Code for the Employee. Can be either 'HOME' or 'OFFICE Active
INTERCOMPANY_FLAG VARCHAR2 1 Intercompany flag added to incorporate FUN team's intercompany feature. Active
IMPORT_DOCUMENT_NUMBER VARCHAR2 50 Import declaration number or import manifest number provided by Customs when goods are imported. In countries, such as Israel, the common business practice is to report the details of the import invoice when the payable tax is demanded for the tax paid on the invoice that was obtained from the Customs Agent. The VAT percentage that is included in the invoice from the Customs Agent varies and consequently cannot be calculated from the total amount on the invoice. The Bill of Lading and Import Manifest represent the Import Declaration document which will include the name and legal entity number of the importer and the supplier and an unequivocal description of the goods including their four digit classification code. This field is used for VAT Tax reporting.
IMPORT_DOCUMENT_DATE DATE Import declaration date associated with the import document number.
CORRECTION_YEAR NUMBER 4 The tax declaration year of a purchase transaction that is being corrected.
CORRECTION_PERIOD VARCHAR2 2 The tax declaration period of a purchase transaction that is being corrected.
CHECK_VAT_AMOUNT_PAID VARCHAR2 1 Indicator used to determine if a partially paid purchase transaction is reportable for tax. Used for tax reporting in eastern and central Europe.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
TRANSACTION_DEADLINE NUMBER Number of days to perform an intra-EU transaction. Used for Modelo reports for Spain.
MERGE_REQUEST_ID NUMBER Supplier or Party merge request identifier
BUDGET_DATE DATE Budgetary Calendar Period Date applicable for funds check
DATA_SET_ID NUMBER Transaction Identifier for XCC Engine
FUNDS_STATUS VARCHAR2 30 Indicator to check and reserve funds for the invoice.
FIRST_PARTY_REGISTRATION_ID NUMBER 18 First party tax registration identifier.
THIRD_PARTY_REGISTRATION_ID NUMBER 18 Third party tax registration identifier.
ROUTING_ATTRIBUTE1 VARCHAR2 270 Captures additional attributes information that may have been used for routing payables invoice images.
ROUTING_ATTRIBUTE2 VARCHAR2 270 Captures additional attributes information that may have been used for routing payables invoice images.
ROUTING_ATTRIBUTE3 VARCHAR2 270 Captures additional attributes information that may have been used for routing payables invoice images.
ROUTING_ATTRIBUTE4 VARCHAR2 270 Captures additional attributes information that may have been used for routing payables invoice images.
ROUTING_ATTRIBUTE5 VARCHAR2 270 Captures additional attributes information that may have been used for routing payables invoice images.
IMAGE_DOCUMENT_NUM VARCHAR2 50 Oracle internal use only.
FISCAL_DOC_ACCESS_KEY VARCHAR2 50 Fiscal document unique identifier, which is generated by concatenating multiple attributes of fiscal document.
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
RELATIONSHIP_ID NUMBER 18 Third party relationship identifier
PO_MATCHED_FLAG VARCHAR2 1 Temporary identifier to determine whether an invoice is purchase order matched in Payables Invoice Validation batch program.
VALIDATION_WORKER_ID NUMBER 18 Temporary identifier to set the worker assignment numnber in Payables Invoice Validation batch program.
LOCKED_BY VARCHAR2 64 User who has locked the invoice for edit
LOCK_TIME TIMESTAMP Time when invoice is locked for edit
ROUTING_STATUS_LOOKUP_CODE VARCHAR2 30 This value indicates the routing status of the invoice. The invoice can be in the process of routing or complete.
ACC_REFERENCE_VALUE1 VARCHAR2 4000 This column is reserved for future internal use.
ADDITIONAL_NOTE VARCHAR2 4000 Captures additional information for the invoice.

Foreign Keys

Table Foreign Table Foreign Key Column
AP_INVOICES_ALL ap_batches_all BATCH_ID
AP_INVOICES_ALL po_headers_all PO_HEADER_ID
AP_INVOICES_ALL gl_code_combinations PA_DEFAULT_DIST_CCID
AP_INVOICES_ALL ap_doc_sequence_audit DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE
AP_INVOICES_ALL ap_awt_groups AWT_GROUP_ID
AP_INVOICES_ALL gl_ussgl_transaction_codes SET_OF_BOOKS_ID, USSGL_TRANSACTION_CODE
AP_INVOICES_ALL poz_supplier_contacts VENDOR_CONTACT_ID
AP_INVOICES_ALL poz_suppliers VENDOR_ID
AP_INVOICES_ALL gl_daily_conversion_types PAYMENT_CROSS_RATE_TYPE
AP_INVOICES_ALL gl_ledgers SET_OF_BOOKS_ID
AP_INVOICES_ALL hz_parties PARTY_ID
AP_INVOICES_ALL ap_distribution_sets_all DISTRIBUTION_SET_ID
AP_INVOICES_ALL ap_invoices_all TAX_RELATED_INVOICE_ID
AP_INVOICES_ALL hz_party_sites PARTY_SITE_ID
AP_INVOICES_ALL per_persons REQUESTER_ID
AP_INVOICES_ALL xle_entity_profiles LEGAL_ENTITY_ID
AP_INVOICES_ALL poz_suppliers REMIT_TO_SUPPLIER_ID
AP_INVOICES_ALL hz_party_sites REMIT_TO_ADDRESS_ID
AP_INVOICES_ALL poz_sup_thirdparty_payment_rel RELATIONSHIP_ID
AP_INVOICES_ALL ap_terms_b TERMS_ID
AP_INVOICES_ALL pjf_projects_all_b PROJECT_ID
AP_INVOICES_ALL gl_code_combinations ACCTS_PAY_CODE_COMBINATION_ID
AP_INVOICES_ALL fnd_currencies_b INVOICE_CURRENCY_CODE, ORG_ID
fa_adj_src_lines_t ap_invoices_all INVOICE_ID
fa_asset_invoices ap_invoices_all INVOICE_ID
ap_checks_all ap_invoices_all ESCHEATMENT_INVOICE_ID
ap_invoice_payments_all ap_invoices_all INVOICE_ID
fun_trx_headers ap_invoices_all AP_INVOICE_ID
ap_prepay_history_all ap_invoices_all INVOICE_ID
ap_interface_rejections ap_invoices_all INVOICE_ID
ap_selected_invoices_all ap_invoices_all INVOICE_ID
ap_selected_invoices_all ap_invoices_all ORIGINAL_INVOICE_ID
ap_apinv_approvers ap_invoices_all INVOICE_ID
ap_invoice_lines_all ap_invoices_all INVOICE_ID
ap_invoice_lines_all ap_invoices_all CORRECTED_INV_ID
ap_invoice_lines_all ap_invoices_all PA_CC_AR_INVOICE_ID
ap_invoice_lines_all ap_invoices_all RETAINED_INVOICE_ID
ap_invoice_lines_all ap_invoices_all PREPAY_INVOICE_ID
ap_holds_all ap_invoices_all INVOICE_ID
fa_mc_asset_invoices ap_invoices_all INVOICE_ID
ap_inv_aprvl_hist_all ap_invoices_all INVOICE_ID
ap_self_assessed_tax_dist_all ap_invoices_all INVOICE_ID
ap_unselected_invoices_all ap_invoices_all INVOICE_ID
ap_invoices_all ap_invoices_all TAX_RELATED_INVOICE_ID
fa_mass_additions ap_invoices_all INVOICE_ID
ap_payment_schedules_all ap_invoices_all INVOICE_ID
ap_awt_tax_rates_all ap_invoices_all VENDOR_ID, INVOICE_NUM, ORG_ID
ap_invoice_distributions_all ap_invoices_all INVOICE_ID
ap_invoice_distributions_all ap_invoices_all PARENT_INVOICE_ID
ap_invoice_distributions_all ap_invoices_all AWT_INVOICE_ID
ap_invoice_distributions_all ap_invoices_all COMPANY_PREPAID_INVOICE_ID
ap_invoice_relationships ap_invoices_all RELATED_INVOICE_ID
ap_invoice_relationships ap_invoices_all ORIGINAL_INVOICE_ID
ap_awt_temp_distributions_all ap_invoices_all INVOICE_ID

Indexes

Index Uniqueness Tablespace Columns Status
AP_INVOICES_ALL_U1 Unique Default INVOICE_ID
AP_INVOICES_ALL_U2 Unique Default DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE
AP_INVOICES_ALL_U3 Unique Default VENDOR_ID, INVOICE_NUM, ORG_ID, PARTY_ID
AP_INVOICES_N1 Non Unique FUSION_TS_TX_IDX BATCH_ID
AP_INVOICES_N10 Non Unique FUSION_TS_TX_IDX PO_HEADER_ID Active
AP_INVOICES_N11 Non Unique FUSION_TS_TX_IDX PROJECT_ID, TASK_ID Active
AP_INVOICES_N12 Non Unique FUSION_TS_TX_IDX VOUCHER_NUM Active
AP_INVOICES_N13 Non Unique FUSION_TS_TX_IDX DOC_SEQUENCE_VALUE Obsolete
AP_INVOICES_N14 Non Unique FUSION_TS_TX_IDX GLOBAL_ATTRIBUTE1 Obsolete
AP_INVOICES_N15 Non Unique FUSION_TS_TX_IDX PAID_ON_BEHALF_EMPLOYEE_ID Obsolete
AP_INVOICES_N16 Non Unique FUSION_TS_TX_IDX WFAPPROVAL_STATUS, ORG_ID Active
AP_INVOICES_N17 Non Unique FUSION_TS_TX_IDX VALIDATION_REQUEST_ID Active
AP_INVOICES_N19 Non Unique FUSION_TS_TX_IDX CREDITED_INVOICE_ID Obsolete
AP_INVOICES_N2 Non Unique FUSION_TS_TX_IDX VENDOR_ID, INVOICE_TYPE_LOOKUP_CODE Active
AP_INVOICES_N20 Non Unique FUSION_TS_TX_IDX ORG_ID Obsolete
AP_INVOICES_N21 Non Unique Default UPPER("INVOICE_NUM"), INVOICE_TYPE_LOOKUP_CODE
AP_INVOICES_N22 Non Unique Default PARTY_ID
AP_INVOICES_N23 Non Unique Default SOURCE, APPROVAL_STATUS, CREATION_DATE, ORG_ID, ROUTING_ATTRIBUTE5
AP_INVOICES_N24 Non Unique Default ORG_ID, APPROVAL_READY_FLAG, VALIDATION_REQUEST_ID, PAYMENT_STATUS_FLAG, HISTORICAL_FLAG
AP_INVOICES_N25 Non Unique Default INVOICE_NUM, PARTY_ID, PAYMENT_STATUS_FLAG
AP_INVOICES_N26 Non Unique Default PAYMENT_STATUS_FLAG Obsolete
AP_INVOICES_N27 Non Unique Default DATA_SET_ID
AP_INVOICES_N28 Non Unique Default LAST_UPDATE_DATE, ORG_ID
AP_INVOICES_N3 Non Unique FUSION_TS_TX_IDX PAYMENT_STATUS_FLAG, PAY_GROUP_LOOKUP_CODE, ORG_ID Active
AP_INVOICES_N4 Non Unique FUSION_TS_TX_IDX INVOICE_AMOUNT Obsolete
AP_INVOICES_N5 Non Unique FUSION_TS_TX_IDX INVOICE_DATE, ORG_ID Active
AP_INVOICES_N6 Non Unique FUSION_TS_TX_IDX INVOICE_NUM Obsolete
AP_INVOICES_N7 Non Unique FUSION_TS_TX_IDX VENDOR_SITE_ID Active
AP_INVOICES_N8 Non Unique FUSION_TS_TX_IDX CREATION_DATE Active
AP_INVOICES_N9 Non Unique FUSION_TS_TX_IDX INVOICE_TYPE_LOOKUP_CODE Obsolete