Table: AP_INVOICES_ALL

Product:	AP - Payables
Description:	Detailed invoice records
Implementation/DBA Data:	AP.AP_INVOICES_ALL

Primary Key: AP_INVOICES_PK

1. INVOICE_ID

Primary Key: AP_INVOICES_UK1

1. DOC_SEQUENCE_ID
2. DOC_SEQUENCE_VALUE

Primary Key: AP_INVOICES_UK2

1. VENDOR_ID
2. INVOICE_NUM

Foreign Keys

Table		Foreign Table	Foreign Key Column
AP_INVOICES_ALL		AP_BATCHES_ALL	AP_INVOICES_ALL.BATCH_ID
AP_INVOICES_ALL		FND_CURRENCIES	AP_INVOICES_ALL.PAYMENT_CURRENCY_CODE
AP_INVOICES_ALL		GL_DAILY_CONVERSION_TYPES	AP_INVOICES_ALL.EXCHANGE_RATE_TYPE
AP_INVOICES_ALL		PO_HEADERS_ALL	AP_INVOICES_ALL.PO_HEADER_ID
AP_INVOICES_ALL		GL_CODE_COMBINATIONS	AP_INVOICES_ALL.PA_DEFAULT_DIST_CCID
AP_INVOICES_ALL		AP_DOC_SEQUENCE_AUDIT	AP_INVOICES_ALL.DOC_SEQUENCE_ID AP_INVOICES_ALL.DOC_SEQUENCE_VALUE
AP_INVOICES_ALL		FND_DOCUMENT_SEQUENCES	AP_INVOICES_ALL.DOC_SEQUENCE_ID
AP_INVOICES_ALL		AP_AWT_GROUPS	AP_INVOICES_ALL.AWT_GROUP_ID
AP_INVOICES_ALL		PA_TASKS	AP_INVOICES_ALL.TASK_ID
AP_INVOICES_ALL		PA_EXPENDITURE_TYPES	AP_INVOICES_ALL.EXPENDITURE_TYPE
AP_INVOICES_ALL		PA_EXP_ORGS_IT	AP_INVOICES_ALL.EXPENDITURE_ORGANIZATION_ID
AP_INVOICES_ALL		PA_PROJECTS_ALL	AP_INVOICES_ALL.PROJECT_ID
AP_INVOICES_ALL		GL_DAILY_CONVERSION_TYPES	AP_INVOICES_ALL.PAYMENT_CROSS_RATE_TYPE
AP_INVOICES_ALL		FND_CONCURRENT_REQUESTS	AP_INVOICES_ALL.VALIDATION_REQUEST_ID
AP_INVOICES_ALL		AP_RECURRING_PAYMENTS_ALL	AP_INVOICES_ALL.RECURRING_PAYMENT_ID
AP_INVOICES_ALL		PO_VENDORS	AP_INVOICES_ALL.VENDOR_ID
AP_INVOICES_ALL		PO_VENDOR_SITES_ALL	AP_INVOICES_ALL.VENDOR_SITE_ID
AP_INVOICES_ALL		GL_SETS_OF_BOOKS_11I	AP_INVOICES_ALL.SET_OF_BOOKS_ID
AP_INVOICES_ALL		GL_CODE_COMBINATIONS	AP_INVOICES_ALL.ACCTS_PAY_CODE_COMBINATION_ID
AP_INVOICES_ALL		FND_CURRENCIES	AP_INVOICES_ALL.INVOICE_CURRENCY_CODE
AP_INVOICES_ALL		AP_SUPPLIER_SITES_ALL	AP_INVOICES_ALL.VENDOR_SITE_ID
AP_INVOICE_LINES_ALL		AP_INVOICES_ALL	AP_INVOICE_LINES_ALL.INVOICE_ID
AP_INVOICE_LINES_ALL		AP_INVOICES_ALL	AP_INVOICE_LINES_ALL.AIL_INVOICE_ID
AP_AWT_TAX_RATES_ALL		AP_INVOICES_ALL	AP_AWT_TAX_RATES_ALL.VENDOR_ID AP_AWT_TAX_RATES_ALL.INVOICE_NUM
AP_AWT_TEMP_DISTRIBUTIONS_ALL		AP_INVOICES_ALL	AP_AWT_TEMP_DISTRIBUTIONS_ALL.INVOICE_ID
AP_EXPENSE_REPORT_HEADERS_ALL		AP_INVOICES_ALL	AP_EXPENSE_REPORT_HEADERS_ALL.ADVANCE_INVOICE_TO_APPLY
%		AP_INVOICES_ALL
%		AP_INVOICES_ALL
AP_EXPENSE_REPORT_HEADERS_ALL		AP_INVOICES_ALL	AP_EXPENSE_REPORT_HEADERS_ALL.VOUCHNO
AP_EXPENSE_REPORT_LINES_ALL		AP_INVOICES_ALL	AP_EXPENSE_REPORT_LINES_ALL.COMPANY_PREPAID_INVOICE_ID
AP_HOLDS_ALL		AP_INVOICES_ALL	AP_HOLDS_ALL.INVOICE_ID
%		AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL		AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL		AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.PARENT_INVOICE_ID
%		AP_INVOICES_ALL
%		AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL		AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL		AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.COMPANY_PREPAID_INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL		AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_CORRECT_INV_ID
AP_INVOICE_LINES_ALL		AP_INVOICES_ALL	AP_INVOICE_LINES_ALL.INVOICE_ID
AP_INVOICE_PAYMENTS_ALL		AP_INVOICES_ALL	AP_INVOICE_PAYMENTS_ALL.INVOICE_ID
AP_INVOICE_PREPAYS_ALL		AP_INVOICES_ALL	AP_INVOICE_PREPAYS_ALL.PREPAY_ID
AP_INVOICE_PREPAYS_ALL		AP_INVOICES_ALL	AP_INVOICE_PREPAYS_ALL.INVOICE_ID
AP_INVOICE_RELATIONSHIPS		AP_INVOICES_ALL	AP_INVOICE_RELATIONSHIPS.RELATED_INVOICE_ID
AP_INVOICE_RELATIONSHIPS		AP_INVOICES_ALL	AP_INVOICE_RELATIONSHIPS.ORIGINAL_INVOICE_ID
AP_INV_APRVL_HIST_ALL		AP_INVOICES_ALL	AP_INV_APRVL_HIST_ALL.INVOICE_ID
AP_PAYMENT_SCHEDULES_ALL		AP_INVOICES_ALL	AP_PAYMENT_SCHEDULES_ALL.INVOICE_ID
AP_PURGE_INVOICE_LIST		AP_INVOICES_ALL	AP_PURGE_INVOICE_LIST.INVOICE_ID
AP_SELECTED_INVOICES_ALL		AP_INVOICES_ALL	AP_SELECTED_INVOICES_ALL.INVOICE_ID
AP_TRIAL_BALANCE		AP_INVOICES_ALL	AP_TRIAL_BALANCE.INVOICE_ID
AP_TRIAL_BAL		AP_INVOICES_ALL	AP_TRIAL_BAL.INVOICE_ID
AP_UNSELECTED_INVOICES_ALL		AP_INVOICES_ALL	AP_UNSELECTED_INVOICES_ALL.INVOICE_ID
FA_ASSET_INVOICES		AP_INVOICES_ALL	FA_ASSET_INVOICES.INVOICE_ID
%		AP_INVOICES_ALL
FA_MASS_ADDITIONS		AP_INVOICES_ALL	FA_MASS_ADDITIONS.INVOICE_ID
FA_MC_ASSET_INVOICES		AP_INVOICES_ALL	FA_MC_ASSET_INVOICES.INVOICE_ID
FV_AAN_MATCHES_TEMP		AP_INVOICES_ALL	FV_AAN_MATCHES_TEMP.AP_INVOICE_ID
FV_DISCOUNTED_INVOICES		AP_INVOICES_ALL	FV_DISCOUNTED_INVOICES.INVOICE_ID
FV_INTERAGENCY_FUNDS_ALL		AP_INVOICES_ALL	FV_INTERAGENCY_FUNDS_ALL.INVOICE_ID
FV_INVOICE_RETURNS_ALL		AP_INVOICES_ALL	FV_INVOICE_RETURNS_ALL.INVOICE_ID
FV_INVOICE_RETURN_DATES_ALL		AP_INVOICES_ALL	FV_INVOICE_RETURN_DATES_ALL.INVOICE_ID
FV_INV_SELECTED_DUEDATE_TEMP		AP_INVOICES_ALL	FV_INV_SELECTED_DUEDATE_TEMP.INVOICE_ID
FV_INV_SELECTED_DUEDATE		AP_INVOICES_ALL	FV_INV_SELECTED_DUEDATE.INVOICE_ID
FV_REFUNDS_VOIDS_ALL		AP_INVOICES_ALL	FV_REFUNDS_VOIDS_ALL.INVOICE_ID
IGI_EXP_AP_TRANS_ALL		AP_INVOICES_ALL	IGI_EXP_AP_TRANS_ALL.INVOICE_ID
JAI_AP_ETDS_T		AP_INVOICES_ALL	JAI_AP_ETDS_T.BASE_INVOICE_ID
JAI_AP_ETDS_T		AP_INVOICES_ALL	JAI_AP_ETDS_T.TDS_INVOICE_ID
JAI_AP_MATCH_ERS_T		AP_INVOICES_ALL	JAI_AP_MATCH_ERS_T.INVOICE_ID
JAI_AP_MATCH_INV_TAXES		AP_INVOICES_ALL	JAI_AP_MATCH_INV_TAXES.INVOICE_ID
JAI_AP_MATCH_INV_TAXES		AP_INVOICES_ALL	JAI_AP_MATCH_INV_TAXES.PARENT_INVOICE_ID
JAI_AP_TDS_F16_DTLS_ALL		AP_INVOICES_ALL	JAI_AP_TDS_F16_DTLS_ALL.INVOICE_ID
JAI_AP_TDS_F16_DTLS_ALL		AP_INVOICES_ALL	JAI_AP_TDS_F16_DTLS_ALL.TDS_INVOICE_ID
JAI_AP_TDS_INVOICES		AP_INVOICES_ALL	JAI_AP_TDS_INVOICES.INVOICE_ID
JAI_AP_TDS_INV_CANCELS		AP_INVOICES_ALL	JAI_AP_TDS_INV_CANCELS.INVOICE_ID
JAI_AP_TDS_INV_PAYMENTS		AP_INVOICES_ALL	JAI_AP_TDS_INV_PAYMENTS.INVOICE_ID
JAI_AP_TDS_INV_TAXES		AP_INVOICES_ALL	JAI_AP_TDS_INV_TAXES.INVOICE_ID
JAI_AP_TDS_PAYMENTS		AP_INVOICES_ALL	JAI_AP_TDS_PAYMENTS.PARENT_INVOICE_ID
JAI_AP_TDS_PREPAYMENTS		AP_INVOICES_ALL	JAI_AP_TDS_PREPAYMENTS.INVOICE_ID
JAI_AP_TDS_THGRP_AUDITS		AP_INVOICES_ALL	JAI_AP_TDS_THGRP_AUDITS.INVOICE_ID
JAI_AP_TDS_THHOLD_TRXS		AP_INVOICES_ALL	JAI_AP_TDS_THHOLD_TRXS.INVOICE_ID
JAI_AP_TDS_THHOLD_TRXS		AP_INVOICES_ALL	JAI_AP_TDS_THHOLD_TRXS.INVOICE_ID
JAI_CMN_ST_FORM_DTLS		AP_INVOICES_ALL	JAI_CMN_ST_FORM_DTLS.INVOICE_ID
JAI_OPM_CM_ADJS_DTL		AP_INVOICES_ALL	JAI_OPM_CM_ADJS_DTL.INVOICE_ID
JAI_PO_REP_PRRG_T		AP_INVOICES_ALL	JAI_PO_REP_PRRG_T.INVOICE_ID
JAI_RCV_TP_INVOICES		AP_INVOICES_ALL	JAI_RCV_TP_INVOICES.INVOICE_ID
JAI_RGM_SETTLEMENTS		AP_INVOICES_ALL	JAI_RGM_SETTLEMENTS.INVOICE_ID
JE_IT_VAT_REPORT_INV		AP_INVOICES_ALL	JE_IT_VAT_REPORT_INV.TRX_ID
PA_BC_COMMITMENTS_ALL		AP_INVOICES_ALL	PA_BC_COMMITMENTS_ALL.DOCUMENT_HEADER_ID
PA_BC_PACKETS		AP_INVOICES_ALL	PA_BC_PACKETS.DOCUMENT_HEADER_ID
PO_ACCRUAL_RECONCILE_TEMP_ALL		AP_INVOICES_ALL	PO_ACCRUAL_RECONCILE_TEMP_ALL.INVOICE_ID
PO_ACCRUAL_WRITE_OFFS_ALL		AP_INVOICES_ALL	PO_ACCRUAL_WRITE_OFFS_ALL.INVOICE_ID