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_RECEIVABLE_APPLICATIONS_ALL

Product:	AR - Receivables
Description:	Accounting information for cash and credit memo applications
Implementation/DBA Data:	AR.AR_RECEIVABLE_APPLICATIONS_ALL

Primary Key: AR_RECEIVABLE_APPLICATIONS_PK

RECEIVABLE_APPLICATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_RECEIVABLE_APPLICATIONS_ALL	AR_CASH_RECEIPTS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_ID
AR_RECEIVABLE_APPLICATIONS_ALL	GL_CODE_COMBINATIONS	AR_RECEIVABLE_APPLICATIONS_ALL.CODE_COMBINATION_ID
AR_RECEIVABLE_APPLICATIONS_ALL	GL_SETS_OF_BOOKS_11I	AR_RECEIVABLE_APPLICATIONS_ALL.SET_OF_BOOKS_ID
AR_RECEIVABLE_APPLICATIONS_ALL	RA_CUSTOMER_TRX_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.PAYMENT_SCHEDULE_ID
AR_RECEIVABLE_APPLICATIONS_ALL	GL_CODE_COMBINATIONS	AR_RECEIVABLE_APPLICATIONS_ALL.CODE_COMBINATION_ID
AR_RECEIVABLE_APPLICATIONS_ALL	RA_CUSTOMER_TRX_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_PAYMENT_SCHEDULES_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_PAYMENT_SCHEDULE_ID
AR_RECEIVABLE_APPLICATIONS_ALL	RA_CUSTOMER_TRX_LINES_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_LINE_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_CASH_RECEIPT_HISTORY_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_HISTORY_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_TRANSACTION_HISTORY_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.LINK_TO_TRX_HIST_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_POSTING_CONTROL	AR_RECEIVABLE_APPLICATIONS_ALL.POSTING_CONTROL_ID
AR_RECEIVABLE_APPLICATIONS_ALL	GL_CODE_COMBINATIONS	AR_RECEIVABLE_APPLICATIONS_ALL.EARNED_DISCOUNT_CCID
AR_RECEIVABLE_APPLICATIONS_ALL	GL_CODE_COMBINATIONS	AR_RECEIVABLE_APPLICATIONS_ALL.UNEARNED_DISCOUNT_CCID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_APP_RULE_SETS	AR_RECEIVABLE_APPLICATIONS_ALL.RULE_SET_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_RECEIVABLES_TRX_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLES_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL	RA_CUSTOMER_TRX_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.LINK_TO_CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL	RA_CUSTOMER_TRX_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.CHARGEBACK_CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_REC_APP_ID
AR_ADJUSTMENTS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_ADJUSTMENTS_ALL.ASSOCIATED_APPLICATION_ID
AR_CASH_BASIS_DISTS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_CASH_BASIS_DISTS_ALL.RECEIVABLE_APPLICATION_ID
AR_CASH_BASIS_DISTS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_CASH_BASIS_DISTS_ALL.RECEIVABLE_APPLICATION_ID_CASH
AR_DISTRIBUTIONS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_DISTRIBUTIONS_ALL.SOURCE_ID
AR_MC_CASH_BASIS_DISTS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_MC_CASH_BASIS_DISTS_ALL.RECEIVABLE_APPLICATION_ID
AR_MC_CASH_BASIS_DISTS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_MC_CASH_BASIS_DISTS_ALL.RECEIVABLE_APPLICATION_ID_CASH
AR_MC_DISTRIBUTIONS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_MC_DISTRIBUTIONS_ALL.SOURCE_ID
AR_MC_RECEIVABLE_APPS	AR_RECEIVABLE_APPLICATIONS_ALL	AR_MC_RECEIVABLE_APPS.RECEIVABLE_APPLICATION_ID
AR_PAYMENT_SCHEDULES_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_PAYMENT_SCHEDULES_ALL.CASH_APPLIED_ID_LAST
AR_RECEIVABLE_APPLICATIONS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL	AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_REC_APP_ID
AR_STATEMENT_LINE_CLUSTERS	AR_RECEIVABLE_APPLICATIONS_ALL	AR_STATEMENT_LINE_CLUSTERS.RECEIVABLE_APPLICATION_ID