FND Design Data [Home] [Help]

Table: AP_INVOICES_ALL

Product: AP - Payables
Description: Detailed invoice records
Implementation/DBA Data: TableAP.AP_INVOICES_ALL
Primary Key: AP_INVOICES_PK
  1. ColumnINVOICE_ID
Primary Key: AP_INVOICES_UK1
  1. ColumnDOC_SEQUENCE_ID
  2. ColumnDOC_SEQUENCE_VALUE
Primary Key: AP_INVOICES_UK2
  1. ColumnVENDOR_ID
  2. ColumnINVOICE_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
AP_INVOICES_ALL FK Joins to TableAP_BATCHES_ALL AP_INVOICES_ALL.BATCH_ID
AP_INVOICES_ALL FK Joins to TableFND_CURRENCIES AP_INVOICES_ALL.PAYMENT_CURRENCY_CODE
AP_INVOICES_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES AP_INVOICES_ALL.EXCHANGE_RATE_TYPE
AP_INVOICES_ALL FK Joins to TablePO_HEADERS_ALL AP_INVOICES_ALL.PO_HEADER_ID
AP_INVOICES_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_INVOICES_ALL.PA_DEFAULT_DIST_CCID
AP_INVOICES_ALL FK Joins to TableAP_DOC_SEQUENCE_AUDIT AP_INVOICES_ALL.DOC_SEQUENCE_ID
AP_INVOICES_ALL.DOC_SEQUENCE_VALUE
AP_INVOICES_ALL FK Joins to TableFND_DOCUMENT_SEQUENCES AP_INVOICES_ALL.DOC_SEQUENCE_ID
AP_INVOICES_ALL FK Joins to TableAP_AWT_GROUPS AP_INVOICES_ALL.AWT_GROUP_ID
AP_INVOICES_ALL FK Joins to TablePA_TASKS AP_INVOICES_ALL.TASK_ID
AP_INVOICES_ALL FK Joins to TablePA_EXPENDITURE_TYPES AP_INVOICES_ALL.EXPENDITURE_TYPE
AP_INVOICES_ALL FK Joins to TablePA_EXP_ORGS_IT AP_INVOICES_ALL.EXPENDITURE_ORGANIZATION_ID
AP_INVOICES_ALL FK Joins to TablePA_PROJECTS_ALL AP_INVOICES_ALL.PROJECT_ID
AP_INVOICES_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES AP_INVOICES_ALL.PAYMENT_CROSS_RATE_TYPE
AP_INVOICES_ALL FK Joins to TableFND_CONCURRENT_REQUESTS AP_INVOICES_ALL.VALIDATION_REQUEST_ID
AP_INVOICES_ALL FK Joins to TableAP_RECURRING_PAYMENTS_ALL AP_INVOICES_ALL.RECURRING_PAYMENT_ID
AP_INVOICES_ALL FK Joins to TablePO_VENDORS AP_INVOICES_ALL.VENDOR_ID
AP_INVOICES_ALL FK Joins to TablePO_VENDOR_SITES_ALL AP_INVOICES_ALL.VENDOR_SITE_ID
AP_INVOICES_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I AP_INVOICES_ALL.SET_OF_BOOKS_ID
AP_INVOICES_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_INVOICES_ALL.ACCTS_PAY_CODE_COMBINATION_ID
AP_INVOICES_ALL FK Joins to TableFND_CURRENCIES AP_INVOICES_ALL.INVOICE_CURRENCY_CODE
AP_INVOICES_ALL FK Joins to TableAP_SUPPLIER_SITES_ALL AP_INVOICES_ALL.VENDOR_SITE_ID
TableAP_INVOICE_LINES_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_LINES_ALL.INVOICE_ID
TableAP_INVOICE_LINES_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_LINES_ALL.AIL_INVOICE_ID
TableAP_AWT_TAX_RATES_ALL FK Joins to AP_INVOICES_ALL AP_AWT_TAX_RATES_ALL.VENDOR_ID
AP_AWT_TAX_RATES_ALL.INVOICE_NUM
TableAP_AWT_TEMP_DISTRIBUTIONS_ALL FK Joins to AP_INVOICES_ALL AP_AWT_TEMP_DISTRIBUTIONS_ALL.INVOICE_ID
TableAP_EXPENSE_REPORT_HEADERS_ALL FK Joins to AP_INVOICES_ALL AP_EXPENSE_REPORT_HEADERS_ALL.ADVANCE_INVOICE_TO_APPLY
Table% FK Joins to AP_INVOICES_ALL
Table% FK Joins to AP_INVOICES_ALL
TableAP_EXPENSE_REPORT_HEADERS_ALL FK Joins to AP_INVOICES_ALL AP_EXPENSE_REPORT_HEADERS_ALL.VOUCHNO
TableAP_EXPENSE_REPORT_LINES_ALL FK Joins to AP_INVOICES_ALL AP_EXPENSE_REPORT_LINES_ALL.COMPANY_PREPAID_INVOICE_ID
TableAP_HOLDS_ALL FK Joins to AP_INVOICES_ALL AP_HOLDS_ALL.INVOICE_ID
Table% FK Joins to AP_INVOICES_ALL
TableAP_INVOICE_DISTRIBUTIONS_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID
TableAP_INVOICE_DISTRIBUTIONS_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.PARENT_INVOICE_ID
Table% FK Joins to AP_INVOICES_ALL
Table% FK Joins to AP_INVOICES_ALL
TableAP_INVOICE_DISTRIBUTIONS_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_ID
TableAP_INVOICE_DISTRIBUTIONS_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.COMPANY_PREPAID_INVOICE_ID
TableAP_INVOICE_DISTRIBUTIONS_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_CORRECT_INV_ID
TableAP_INVOICE_LINES_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_LINES_ALL.INVOICE_ID
TableAP_INVOICE_PAYMENTS_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_PAYMENTS_ALL.INVOICE_ID
TableAP_INVOICE_PREPAYS_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_PREPAYS_ALL.PREPAY_ID
TableAP_INVOICE_PREPAYS_ALL FK Joins to AP_INVOICES_ALL AP_INVOICE_PREPAYS_ALL.INVOICE_ID
TableAP_INVOICE_RELATIONSHIPS FK Joins to AP_INVOICES_ALL AP_INVOICE_RELATIONSHIPS.RELATED_INVOICE_ID
TableAP_INVOICE_RELATIONSHIPS FK Joins to AP_INVOICES_ALL AP_INVOICE_RELATIONSHIPS.ORIGINAL_INVOICE_ID
TableAP_INV_APRVL_HIST_ALL FK Joins to AP_INVOICES_ALL AP_INV_APRVL_HIST_ALL.INVOICE_ID
TableAP_PAYMENT_SCHEDULES_ALL FK Joins to AP_INVOICES_ALL AP_PAYMENT_SCHEDULES_ALL.INVOICE_ID
TableAP_PURGE_INVOICE_LIST FK Joins to AP_INVOICES_ALL AP_PURGE_INVOICE_LIST.INVOICE_ID
TableAP_SELECTED_INVOICES_ALL FK Joins to AP_INVOICES_ALL AP_SELECTED_INVOICES_ALL.INVOICE_ID
TableAP_TRIAL_BALANCE FK Joins to AP_INVOICES_ALL AP_TRIAL_BALANCE.INVOICE_ID
TableAP_TRIAL_BAL FK Joins to AP_INVOICES_ALL AP_TRIAL_BAL.INVOICE_ID
TableAP_UNSELECTED_INVOICES_ALL FK Joins to AP_INVOICES_ALL AP_UNSELECTED_INVOICES_ALL.INVOICE_ID
TableFA_ASSET_INVOICES FK Joins to AP_INVOICES_ALL FA_ASSET_INVOICES.INVOICE_ID
Table% FK Joins to AP_INVOICES_ALL
TableFA_MASS_ADDITIONS FK Joins to AP_INVOICES_ALL FA_MASS_ADDITIONS.INVOICE_ID
TableFA_MC_ASSET_INVOICES FK Joins to AP_INVOICES_ALL FA_MC_ASSET_INVOICES.INVOICE_ID
TableFV_AAN_MATCHES_TEMP FK Joins to AP_INVOICES_ALL FV_AAN_MATCHES_TEMP.AP_INVOICE_ID
TableFV_DISCOUNTED_INVOICES FK Joins to AP_INVOICES_ALL FV_DISCOUNTED_INVOICES.INVOICE_ID
TableFV_INTERAGENCY_FUNDS_ALL FK Joins to AP_INVOICES_ALL FV_INTERAGENCY_FUNDS_ALL.INVOICE_ID
TableFV_INVOICE_RETURNS_ALL FK Joins to AP_INVOICES_ALL FV_INVOICE_RETURNS_ALL.INVOICE_ID
TableFV_INVOICE_RETURN_DATES_ALL FK Joins to AP_INVOICES_ALL FV_INVOICE_RETURN_DATES_ALL.INVOICE_ID
TableFV_INV_SELECTED_DUEDATE_TEMP FK Joins to AP_INVOICES_ALL FV_INV_SELECTED_DUEDATE_TEMP.INVOICE_ID
TableFV_INV_SELECTED_DUEDATE FK Joins to AP_INVOICES_ALL FV_INV_SELECTED_DUEDATE.INVOICE_ID
TableFV_REFUNDS_VOIDS_ALL FK Joins to AP_INVOICES_ALL FV_REFUNDS_VOIDS_ALL.INVOICE_ID
TableIGI_EXP_AP_TRANS_ALL FK Joins to AP_INVOICES_ALL IGI_EXP_AP_TRANS_ALL.INVOICE_ID
TableJAI_AP_ETDS_T FK Joins to AP_INVOICES_ALL JAI_AP_ETDS_T.BASE_INVOICE_ID
TableJAI_AP_ETDS_T FK Joins to AP_INVOICES_ALL JAI_AP_ETDS_T.TDS_INVOICE_ID
TableJAI_AP_MATCH_ERS_T FK Joins to AP_INVOICES_ALL JAI_AP_MATCH_ERS_T.INVOICE_ID
TableJAI_AP_MATCH_INV_TAXES FK Joins to AP_INVOICES_ALL JAI_AP_MATCH_INV_TAXES.INVOICE_ID
TableJAI_AP_MATCH_INV_TAXES FK Joins to AP_INVOICES_ALL JAI_AP_MATCH_INV_TAXES.PARENT_INVOICE_ID
TableJAI_AP_TDS_F16_DTLS_ALL FK Joins to AP_INVOICES_ALL JAI_AP_TDS_F16_DTLS_ALL.INVOICE_ID
TableJAI_AP_TDS_F16_DTLS_ALL FK Joins to AP_INVOICES_ALL JAI_AP_TDS_F16_DTLS_ALL.TDS_INVOICE_ID
TableJAI_AP_TDS_INVOICES FK Joins to AP_INVOICES_ALL JAI_AP_TDS_INVOICES.INVOICE_ID
TableJAI_AP_TDS_INV_CANCELS FK Joins to AP_INVOICES_ALL JAI_AP_TDS_INV_CANCELS.INVOICE_ID
TableJAI_AP_TDS_INV_PAYMENTS FK Joins to AP_INVOICES_ALL JAI_AP_TDS_INV_PAYMENTS.INVOICE_ID
TableJAI_AP_TDS_INV_TAXES FK Joins to AP_INVOICES_ALL JAI_AP_TDS_INV_TAXES.INVOICE_ID
TableJAI_AP_TDS_PAYMENTS FK Joins to AP_INVOICES_ALL JAI_AP_TDS_PAYMENTS.PARENT_INVOICE_ID
TableJAI_AP_TDS_PREPAYMENTS FK Joins to AP_INVOICES_ALL JAI_AP_TDS_PREPAYMENTS.INVOICE_ID
TableJAI_AP_TDS_THGRP_AUDITS FK Joins to AP_INVOICES_ALL JAI_AP_TDS_THGRP_AUDITS.INVOICE_ID
TableJAI_AP_TDS_THHOLD_TRXS FK Joins to AP_INVOICES_ALL JAI_AP_TDS_THHOLD_TRXS.INVOICE_ID
TableJAI_AP_TDS_THHOLD_TRXS FK Joins to AP_INVOICES_ALL JAI_AP_TDS_THHOLD_TRXS.INVOICE_ID
TableJAI_CMN_ST_FORM_DTLS FK Joins to AP_INVOICES_ALL JAI_CMN_ST_FORM_DTLS.INVOICE_ID
TableJAI_OPM_CM_ADJS_DTL FK Joins to AP_INVOICES_ALL JAI_OPM_CM_ADJS_DTL.INVOICE_ID
TableJAI_PO_REP_PRRG_T FK Joins to AP_INVOICES_ALL JAI_PO_REP_PRRG_T.INVOICE_ID
TableJAI_RCV_TP_INVOICES FK Joins to AP_INVOICES_ALL JAI_RCV_TP_INVOICES.INVOICE_ID
TableJAI_RGM_SETTLEMENTS FK Joins to AP_INVOICES_ALL JAI_RGM_SETTLEMENTS.INVOICE_ID
TableJE_IT_VAT_REPORT_INV FK Joins to AP_INVOICES_ALL JE_IT_VAT_REPORT_INV.TRX_ID
TablePA_BC_COMMITMENTS_ALL FK Joins to AP_INVOICES_ALL PA_BC_COMMITMENTS_ALL.DOCUMENT_HEADER_ID
TablePA_BC_PACKETS FK Joins to AP_INVOICES_ALL PA_BC_PACKETS.DOCUMENT_HEADER_ID
TablePO_ACCRUAL_RECONCILE_TEMP_ALL FK Joins to AP_INVOICES_ALL PO_ACCRUAL_RECONCILE_TEMP_ALL.INVOICE_ID
TablePO_ACCRUAL_WRITE_OFFS_ALL FK Joins to AP_INVOICES_ALL PO_ACCRUAL_WRITE_OFFS_ALL.INVOICE_ID