eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: AP_CHECKS_ALL

Product:	AP - Payables
Description:	Supplier payment data
Implementation/DBA Data:	AP.AP_CHECKS_ALL

Primary Key: AP_CHECKS_PK

CHECK_ID

Primary Key: AP_CHECKS_UK1

CHECK_STOCK_ID
CHECK_NUMBER

Primary Key: AP_CHECKS_UK2

DOC_SEQUENCE_ID
DOC_SEQUENCE_VALUE

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_CHECKS_ALL	CE_BANK_ACCT_USES_ALL	AP_CHECKS_ALL.CE_BANK_ACCT_USE_ID
AP_CHECKS_ALL	AP_BANK_ACCOUNTS_ALL	AP_CHECKS_ALL.BANK_ACCOUNT_ID
AP_CHECKS_ALL	PO_VENDORS	AP_CHECKS_ALL.VENDOR_ID
AP_CHECKS_ALL	PO_VENDOR_SITES_ALL	AP_CHECKS_ALL.VENDOR_SITE_ID
AP_CHECKS_ALL	GL_DAILY_CONVERSION_TYPES	AP_CHECKS_ALL.EXCHANGE_RATE_TYPE
AP_CHECKS_ALL	GL_DAILY_CONVERSION_TYPES	AP_CHECKS_ALL.CLEARED_EXCHANGE_RATE_TYPE
AP_CHECKS_ALL	GL_DAILY_CONVERSION_TYPES	AP_CHECKS_ALL.MATURITY_EXCHANGE_RATE_TYPE
AP_CHECKS_ALL	AP_BANK_ACCOUNTS_ALL	AP_CHECKS_ALL.EXTERNAL_BANK_ACCOUNT_ID
AP_CHECKS_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_CHECKS_ALL.CHECKRUN_ID
AP_CHECKS_ALL	IBY_PAY_INSTRUCTIONS_ALL	AP_CHECKS_ALL.PAYMENT_INSTRUCTION_ID
AP_CHECKS_ALL	AP_CHECK_FORMATS	AP_CHECKS_ALL.CHECK_FORMAT_ID
AP_CHECKS_ALL	AP_CHECK_STOCKS_ALL	AP_CHECKS_ALL.CHECK_STOCK_ID
AP_CHECKS_ALL	AP_INV_SELECTION_CRITERIA_ALL	AP_CHECKS_ALL.CHECKRUN_NAME
AP_CHECKS_ALL	FND_CURRENCIES	AP_CHECKS_ALL.CURRENCY_CODE
AP_CHECKS_ALL	AP_DOC_SEQUENCE_AUDIT	AP_CHECKS_ALL.DOC_SEQUENCE_ID AP_CHECKS_ALL.DOC_SEQUENCE_VALUE
AP_CHECKS_ALL	FND_DOCUMENT_SEQUENCES	AP_CHECKS_ALL.DOC_SEQUENCE_ID
AP_INVOICE_PAYMENTS_ALL	AP_CHECKS_ALL	AP_INVOICE_PAYMENTS_ALL.CHECK_ID
AP_PAYMENT_HISTORY_ALL	AP_CHECKS_ALL	AP_PAYMENT_HISTORY_ALL.CHECK_ID
AP_SELECTED_INVOICE_CHECKS_ALL	AP_CHECKS_ALL	AP_SELECTED_INVOICE_CHECKS_ALL.CHECK_ID
FV_REFUNDS_VOIDS_ALL	AP_CHECKS_ALL	FV_REFUNDS_VOIDS_ALL.CHECK_ID
JAI_AP_ETDS_T	AP_CHECKS_ALL	JAI_AP_ETDS_T.TDS_CHECK_ID
JAI_AP_ETDS_T	AP_CHECKS_ALL	JAI_AP_ETDS_T.BASE_INVOICE_CHECK_ID
JAI_AP_RGM_PAYMENTS	AP_CHECKS_ALL	JAI_AP_RGM_PAYMENTS.CHECK_ID
JAI_AP_TDS_INV_PAYMENTS	AP_CHECKS_ALL	JAI_AP_TDS_INV_PAYMENTS.CHECK_ID
JAI_AR_ETCS_T	AP_CHECKS_ALL	JAI_AR_ETCS_T.TCS_CHECK_ID