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: AR_CASH_RECEIPTS_ALL

Product:	AR - Receivables
Description:	Detailed receipt information
Implementation/DBA Data:	AR.AR_CASH_RECEIPTS_ALL

Primary Key: AR_CASH_RECEIPTS_PK

CASH_RECEIPT_ID

Primary Key: AR_CASH_RECEIPT_UK1

PAY_FROM_CUSTOMER
RECEIPT_NUMBER
AMOUNT

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_CASH_RECEIPTS_ALL	AP_BANK_ACCOUNTS_ALL	AR_CASH_RECEIPTS_ALL.REMITTANCE_BANK_ACCOUNT_ID
AR_CASH_RECEIPTS_ALL	IBY_EXT_BANK_ACCOUNTS	AR_CASH_RECEIPTS_ALL.CUSTOMER_BANK_ACCOUNT_ID
AR_CASH_RECEIPTS_ALL	HZ_CUST_SITE_USES_ALL	AR_CASH_RECEIPTS_ALL.CUSTOMER_SITE_USE_ID
AR_CASH_RECEIPTS_ALL	HZ_CUST_ACCOUNTS	AR_CASH_RECEIPTS_ALL.CUSTOMER_SITE_USE_ID
AR_CASH_RECEIPTS_ALL	CE_BANK_ACCT_USES_ALL	AR_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID
AR_CASH_RECEIPTS_ALL	AP_BANK_BRANCHES	AR_CASH_RECEIPTS_ALL.OLD_CUSTOMER_BANK_BRANCH_ID
AR_CASH_RECEIPTS_ALL	AP_BANK_BRANCHES	AR_CASH_RECEIPTS_ALL.OLD_ISSUER_BANK_BRANCH_ID
AR_CASH_RECEIPTS_ALL	IBY_FNDCPT_TX_EXTENSIONS	AR_CASH_RECEIPTS_ALL.PAYMENT_TRXN_EXTENSION_ID
AR_CASH_RECEIPTS_ALL	AR_RECEIPT_METHODS	AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID
AR_CASH_RECEIPTS_ALL	GL_SETS_OF_BOOKS_11I	AR_CASH_RECEIPTS_ALL.SET_OF_BOOKS_ID
AR_CASH_RECEIPTS_ALL	HZ_CUST_SITE_USES_ALL	AR_CASH_RECEIPTS_ALL.PREV_CUSTOMER_SITE_USE_ID
AR_CASH_RECEIPTS_ALL	AR_BATCHES_ALL	AR_CASH_RECEIPTS_ALL.SELECTED_REMITTANCE_BATCH_ID
AR_CASH_RECEIPTS_ALL	HZ_CUST_ACCOUNTS	AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER
AR_CASH_RECEIPTS_ALL	AR_VAT_TAX_ALL_B	AR_CASH_RECEIPTS_ALL.VAT_TAX_ID
AR_CASH_RECEIPTS_ALL	AR_RECEIVABLES_TRX_ALL	AR_CASH_RECEIPTS_ALL.RECEIVABLES_TRX_ID
AR_CASH_RECEIPTS_ALL	AR_DISTRIBUTION_SETS_ALL	AR_CASH_RECEIPTS_ALL.DISTRIBUTION_SET_ID
AR_CASH_RECEIPTS_ALL	FND_CURRENCIES	AR_CASH_RECEIPTS_ALL.CURRENCY_CODE
AR_ADJUSTMENTS_ALL	AR_CASH_RECEIPTS_ALL	AR_ADJUSTMENTS_ALL.ASSOCIATED_CASH_RECEIPT_ID
AR_CASH_RECEIPT_HISTORY_ALL	AR_CASH_RECEIPTS_ALL	AR_CASH_RECEIPT_HISTORY_ALL.CASH_RECEIPT_ID
AR_CC_ERROR_HISTORY	AR_CASH_RECEIPTS_ALL	AR_CC_ERROR_HISTORY.CC_TRX_ID
AR_MC_CASH_RECEIPTS	AR_CASH_RECEIPTS_ALL	AR_MC_CASH_RECEIPTS.CASH_RECEIPT_ID
AR_MC_CASH_RECEIPT_HIST	AR_CASH_RECEIPTS_ALL	AR_MC_CASH_RECEIPT_HIST.CASH_RECEIPT_ID
AR_MC_MISC_CASH_DISTS	AR_CASH_RECEIPTS_ALL	AR_MC_MISC_CASH_DISTS.CASH_RECEIPT_ID
AR_MC_RECEIVABLE_APPS	AR_CASH_RECEIPTS_ALL	AR_MC_RECEIVABLE_APPS.CASH_RECEIPT_ID
AR_MISC_CASH_DISTRIBUTIONS_ALL	AR_CASH_RECEIPTS_ALL	AR_MISC_CASH_DISTRIBUTIONS_ALL.CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_ALL	AR_CASH_RECEIPTS_ALL	AR_PAYMENT_SCHEDULES_ALL.CASH_RECEIPT_ID_LAST
AR_PAYMENT_SCHEDULES_ALL	AR_CASH_RECEIPTS_ALL	AR_PAYMENT_SCHEDULES_ALL.CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_ALL	AR_CASH_RECEIPTS_ALL	AR_PAYMENT_SCHEDULES_ALL.ASSOCIATED_CASH_RECEIPT_ID
AR_PAYMENT_SCHEDULES_ALL	AR_CASH_RECEIPTS_ALL	AR_PAYMENT_SCHEDULES_ALL.REVERSED_CASH_RECEIPT_ID
AR_RATE_ADJUSTMENTS_ALL	AR_CASH_RECEIPTS_ALL	AR_RATE_ADJUSTMENTS_ALL.CASH_RECEIPT_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_CASH_RECEIPTS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_ID
FV_INTERAGENCY_FUNDS_ALL	AR_CASH_RECEIPTS_ALL	FV_INTERAGENCY_FUNDS_ALL.CASH_RECEIPT_ID
FV_REFUNDS_VOIDS_ALL	AR_CASH_RECEIPTS_ALL	FV_REFUNDS_VOIDS_ALL.CASH_RECEIPT_ID
JAI_CMN_DOCUMENT_TAXES	AR_CASH_RECEIPTS_ALL	JAI_CMN_DOCUMENT_TAXES.SOURCE_DOC_ID
JAI_RGM_ITEM_GEN_DOCS	AR_CASH_RECEIPTS_ALL	JAI_RGM_ITEM_GEN_DOCS.SOURCE_DOCUMENT_ID
JAI_RGM_REFS_ALL	AR_CASH_RECEIPTS_ALL	JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID
JAI_RGM_REFS_ALL	AR_CASH_RECEIPTS_ALL	JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID
OKL_EXT_CSH_RCPTS_ALL_B	AR_CASH_RECEIPTS_ALL	OKL_EXT_CSH_RCPTS_ALL_B.ICR_ID
OKL_EXT_CSH_RCPTS_B	AR_CASH_RECEIPTS_ALL	OKL_EXT_CSH_RCPTS_B.ICR_ID