FND Design Data [Home] [Help]

Table: AR_RECEIVABLE_APPLICATIONS_ALL

Product: AR - Receivables
Description: Accounting information for cash and credit memo applications
Implementation/DBA Data: TableAR.AR_RECEIVABLE_APPLICATIONS_ALL
Primary Key: AR_RECEIVABLE_APPLICATIONS_PK
  1. ColumnRECEIVABLE_APPLICATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableAR_CASH_RECEIPTS_ALL AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS AR_RECEIVABLE_APPLICATIONS_ALL.CODE_COMBINATION_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I AR_RECEIVABLE_APPLICATIONS_ALL.SET_OF_BOOKS_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL AR_RECEIVABLE_APPLICATIONS_ALL.CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableAR_PAYMENT_SCHEDULES_ALL AR_RECEIVABLE_APPLICATIONS_ALL.PAYMENT_SCHEDULE_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS AR_RECEIVABLE_APPLICATIONS_ALL.CODE_COMBINATION_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableAR_PAYMENT_SCHEDULES_ALL AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_PAYMENT_SCHEDULE_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableRA_CUSTOMER_TRX_LINES_ALL AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_CUSTOMER_TRX_LINE_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableAR_CASH_RECEIPT_HISTORY_ALL AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_HISTORY_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableAR_TRANSACTION_HISTORY_ALL AR_RECEIVABLE_APPLICATIONS_ALL.LINK_TO_TRX_HIST_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableAR_POSTING_CONTROL AR_RECEIVABLE_APPLICATIONS_ALL.POSTING_CONTROL_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS AR_RECEIVABLE_APPLICATIONS_ALL.EARNED_DISCOUNT_CCID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS AR_RECEIVABLE_APPLICATIONS_ALL.UNEARNED_DISCOUNT_CCID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableAR_APP_RULE_SETS AR_RECEIVABLE_APPLICATIONS_ALL.RULE_SET_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableAR_RECEIVABLES_TRX_ALL AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLES_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL AR_RECEIVABLE_APPLICATIONS_ALL.LINK_TO_CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL AR_RECEIVABLE_APPLICATIONS_ALL.CHARGEBACK_CUSTOMER_TRX_ID
AR_RECEIVABLE_APPLICATIONS_ALL FK Joins to TableAR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_REC_APP_ID
TableAR_ADJUSTMENTS_ALL FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_ADJUSTMENTS_ALL.ASSOCIATED_APPLICATION_ID
TableAR_CASH_BASIS_DISTS_ALL FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_CASH_BASIS_DISTS_ALL.RECEIVABLE_APPLICATION_ID
TableAR_CASH_BASIS_DISTS_ALL FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_CASH_BASIS_DISTS_ALL.RECEIVABLE_APPLICATION_ID_CASH
TableAR_DISTRIBUTIONS_ALL FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_DISTRIBUTIONS_ALL.SOURCE_ID
TableAR_MC_CASH_BASIS_DISTS_ALL FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_MC_CASH_BASIS_DISTS_ALL.RECEIVABLE_APPLICATION_ID
TableAR_MC_CASH_BASIS_DISTS_ALL FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_MC_CASH_BASIS_DISTS_ALL.RECEIVABLE_APPLICATION_ID_CASH
TableAR_MC_DISTRIBUTIONS_ALL FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_MC_DISTRIBUTIONS_ALL.SOURCE_ID
TableAR_MC_RECEIVABLE_APPS FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_MC_RECEIVABLE_APPS.RECEIVABLE_APPLICATION_ID
TableAR_PAYMENT_SCHEDULES_ALL FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_PAYMENT_SCHEDULES_ALL.CASH_APPLIED_ID_LAST
TableAR_RECEIVABLE_APPLICATIONS_ALL FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_RECEIVABLE_APPLICATIONS_ALL.APPLIED_REC_APP_ID
TableAR_STATEMENT_LINE_CLUSTERS FK Joins to AR_RECEIVABLE_APPLICATIONS_ALL AR_STATEMENT_LINE_CLUSTERS.RECEIVABLE_APPLICATION_ID