FND Design Data [Home] [Help]

Table: AR_CASH_RECEIPTS_ALL

Product: AR - Receivables
Description: Detailed receipt information
Implementation/DBA Data: TableAR.AR_CASH_RECEIPTS_ALL
Primary Key: AR_CASH_RECEIPTS_PK
  1. ColumnCASH_RECEIPT_ID
Primary Key: AR_CASH_RECEIPT_UK1
  1. ColumnPAY_FROM_CUSTOMER
  2. ColumnRECEIPT_NUMBER
  3. ColumnAMOUNT
Foreign Keys
Table
Foreign Table Foreign Key Column
AR_CASH_RECEIPTS_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL AR_CASH_RECEIPTS_ALL.REMITTANCE_BANK_ACCOUNT_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableIBY_EXT_BANK_ACCOUNTS AR_CASH_RECEIPTS_ALL.CUSTOMER_BANK_ACCOUNT_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL AR_CASH_RECEIPTS_ALL.CUSTOMER_SITE_USE_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableHZ_CUST_ACCOUNTS AR_CASH_RECEIPTS_ALL.CUSTOMER_SITE_USE_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableCE_BANK_ACCT_USES_ALL AR_CASH_RECEIPTS_ALL.REMIT_BANK_ACCT_USE_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableAP_BANK_BRANCHES AR_CASH_RECEIPTS_ALL.OLD_CUSTOMER_BANK_BRANCH_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableAP_BANK_BRANCHES AR_CASH_RECEIPTS_ALL.OLD_ISSUER_BANK_BRANCH_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableIBY_FNDCPT_TX_EXTENSIONS AR_CASH_RECEIPTS_ALL.PAYMENT_TRXN_EXTENSION_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableAR_RECEIPT_METHODS AR_CASH_RECEIPTS_ALL.RECEIPT_METHOD_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I AR_CASH_RECEIPTS_ALL.SET_OF_BOOKS_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL AR_CASH_RECEIPTS_ALL.PREV_CUSTOMER_SITE_USE_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableAR_BATCHES_ALL AR_CASH_RECEIPTS_ALL.SELECTED_REMITTANCE_BATCH_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableHZ_CUST_ACCOUNTS AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER
AR_CASH_RECEIPTS_ALL FK Joins to TableAR_VAT_TAX_ALL_B AR_CASH_RECEIPTS_ALL.VAT_TAX_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableAR_RECEIVABLES_TRX_ALL AR_CASH_RECEIPTS_ALL.RECEIVABLES_TRX_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableAR_DISTRIBUTION_SETS_ALL AR_CASH_RECEIPTS_ALL.DISTRIBUTION_SET_ID
AR_CASH_RECEIPTS_ALL FK Joins to TableFND_CURRENCIES AR_CASH_RECEIPTS_ALL.CURRENCY_CODE
TableAR_ADJUSTMENTS_ALL FK Joins to AR_CASH_RECEIPTS_ALL AR_ADJUSTMENTS_ALL.ASSOCIATED_CASH_RECEIPT_ID
TableAR_CASH_RECEIPT_HISTORY_ALL FK Joins to AR_CASH_RECEIPTS_ALL AR_CASH_RECEIPT_HISTORY_ALL.CASH_RECEIPT_ID
TableAR_CC_ERROR_HISTORY FK Joins to AR_CASH_RECEIPTS_ALL AR_CC_ERROR_HISTORY.CC_TRX_ID
TableAR_MC_CASH_RECEIPTS FK Joins to AR_CASH_RECEIPTS_ALL AR_MC_CASH_RECEIPTS.CASH_RECEIPT_ID
TableAR_MC_CASH_RECEIPT_HIST FK Joins to AR_CASH_RECEIPTS_ALL AR_MC_CASH_RECEIPT_HIST.CASH_RECEIPT_ID
TableAR_MC_MISC_CASH_DISTS FK Joins to AR_CASH_RECEIPTS_ALL AR_MC_MISC_CASH_DISTS.CASH_RECEIPT_ID
TableAR_MC_RECEIVABLE_APPS FK Joins to AR_CASH_RECEIPTS_ALL AR_MC_RECEIVABLE_APPS.CASH_RECEIPT_ID
TableAR_MISC_CASH_DISTRIBUTIONS_ALL FK Joins to AR_CASH_RECEIPTS_ALL AR_MISC_CASH_DISTRIBUTIONS_ALL.CASH_RECEIPT_ID
TableAR_PAYMENT_SCHEDULES_ALL FK Joins to AR_CASH_RECEIPTS_ALL AR_PAYMENT_SCHEDULES_ALL.CASH_RECEIPT_ID_LAST
TableAR_PAYMENT_SCHEDULES_ALL FK Joins to AR_CASH_RECEIPTS_ALL AR_PAYMENT_SCHEDULES_ALL.CASH_RECEIPT_ID
TableAR_PAYMENT_SCHEDULES_ALL FK Joins to AR_CASH_RECEIPTS_ALL AR_PAYMENT_SCHEDULES_ALL.ASSOCIATED_CASH_RECEIPT_ID
TableAR_PAYMENT_SCHEDULES_ALL FK Joins to AR_CASH_RECEIPTS_ALL AR_PAYMENT_SCHEDULES_ALL.REVERSED_CASH_RECEIPT_ID
TableAR_RATE_ADJUSTMENTS_ALL FK Joins to AR_CASH_RECEIPTS_ALL AR_RATE_ADJUSTMENTS_ALL.CASH_RECEIPT_ID
TableAR_RECEIVABLE_APPLICATIONS_ALL FK Joins to AR_CASH_RECEIPTS_ALL AR_RECEIVABLE_APPLICATIONS_ALL.CASH_RECEIPT_ID
TableFV_INTERAGENCY_FUNDS_ALL FK Joins to AR_CASH_RECEIPTS_ALL FV_INTERAGENCY_FUNDS_ALL.CASH_RECEIPT_ID
TableFV_REFUNDS_VOIDS_ALL FK Joins to AR_CASH_RECEIPTS_ALL FV_REFUNDS_VOIDS_ALL.CASH_RECEIPT_ID
TableJAI_CMN_DOCUMENT_TAXES FK Joins to AR_CASH_RECEIPTS_ALL JAI_CMN_DOCUMENT_TAXES.SOURCE_DOC_ID
TableJAI_RGM_ITEM_GEN_DOCS FK Joins to AR_CASH_RECEIPTS_ALL JAI_RGM_ITEM_GEN_DOCS.SOURCE_DOCUMENT_ID
TableJAI_RGM_REFS_ALL FK Joins to AR_CASH_RECEIPTS_ALL JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID
TableJAI_RGM_REFS_ALL FK Joins to AR_CASH_RECEIPTS_ALL JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID
TableOKL_EXT_CSH_RCPTS_ALL_B FK Joins to AR_CASH_RECEIPTS_ALL OKL_EXT_CSH_RCPTS_ALL_B.ICR_ID
TableOKL_EXT_CSH_RCPTS_B FK Joins to AR_CASH_RECEIPTS_ALL OKL_EXT_CSH_RCPTS_B.ICR_ID