FND Design Data [Home] [Help]

Table: AR_RECEIVABLES_TRX_ALL

Product: AR - Receivables
Description: Accounting information for Receivables activities
Implementation/DBA Data: TableAR.AR_RECEIVABLES_TRX_ALL
Primary Key: AR_RECEIVABLES_TRX_PK
  1. ColumnRECEIVABLES_TRX_ID
Primary Key: AR_RECEIVABLES_TRX_UK1
  1. ColumnNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
AR_RECEIVABLES_TRX_ALL FK Joins to TableGL_CODE_COMBINATIONS AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID
AR_RECEIVABLES_TRX_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I AR_RECEIVABLES_TRX_ALL.SET_OF_BOOKS_ID
AR_RECEIVABLES_TRX_ALL FK Joins to TableAR_DISTRIBUTION_SETS_ALL AR_RECEIVABLES_TRX_ALL.DEFAULT_ACCTG_DISTRIBUTION_SET
TableAP_BANK_ACCOUNTS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL AP_BANK_ACCOUNTS_ALL.BR_STD_RECEIVABLES_TRX_ID
TableAR_ADJUSTMENTS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL AR_ADJUSTMENTS_ALL.RECEIVABLES_TRX_ID
TableAR_CASH_RECEIPTS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL AR_CASH_RECEIPTS_ALL.RECEIVABLES_TRX_ID
TableAR_RECEIPT_METHOD_ACCOUNTS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL AR_RECEIPT_METHOD_ACCOUNTS_ALL.EDISC_RECEIVABLES_TRX_ID
TableAR_RECEIPT_METHOD_ACCOUNTS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL AR_RECEIPT_METHOD_ACCOUNTS_ALL.UNEDISC_RECEIVABLES_TRX_ID
TableAR_RECEIPT_METHOD_ACCOUNTS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL AR_RECEIPT_METHOD_ACCOUNTS_ALL.BR_STD_RECEIVABLES_TRX_ID
TableAR_SYSTEM_PARAMETERS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL AR_SYSTEM_PARAMETERS_ALL.PENALTY_REC_TRX_ID
TableAR_SYSTEM_PARAMETERS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL AR_SYSTEM_PARAMETERS_ALL.FINCHRG_RECEIVABLES_TRX_ID
TableAR_SYSTEM_PARAMETERS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL AR_SYSTEM_PARAMETERS_ALL.IREC_SERVICE_CHARGE_REC_TRX_ID
TableCE_BANK_ACCT_USES_ALL FK Joins to AR_RECEIVABLES_TRX_ALL CE_BANK_ACCT_USES_ALL.EDISC_RECEIVABLES_TRX_ID
TableCE_BANK_ACCT_USES_ALL FK Joins to AR_RECEIVABLES_TRX_ALL CE_BANK_ACCT_USES_ALL.UNEDISC_RECEIVABLES_TRX_ID
TableCE_BANK_ACCT_USES_ALL FK Joins to AR_RECEIVABLES_TRX_ALL CE_BANK_ACCT_USES_ALL.BR_STD_RECEIVABLES_TRX_ID
TableCE_BANK_ACCT_USES_ALL FK Joins to AR_RECEIVABLES_TRX_ALL CE_BANK_ACCT_USES_ALL.EDISC_RECEIVABLES_TRX_ID
TableCE_BANK_ACCT_USES_ALL FK Joins to AR_RECEIVABLES_TRX_ALL CE_BANK_ACCT_USES_ALL.UNEDISC_RECEIVABLES_TRX_ID
TableCE_BANK_ACCT_USES_ALL FK Joins to AR_RECEIVABLES_TRX_ALL CE_BANK_ACCT_USES_ALL.BR_STD_RECEIVABLES_TRX_ID
TableCE_SYSTEM_PARAMETERS_ALL FK Joins to AR_RECEIVABLES_TRX_ALL CE_SYSTEM_PARAMETERS_ALL.RECEIVABLES_TRX_ID
TableCE_SYSTEM_PARAMETERS FK Joins to AR_RECEIVABLES_TRX_ALL CE_SYSTEM_PARAMETERS.RECEIVABLES_TRX_ID_OLD
TableCE_TRANSACTION_CODES FK Joins to AR_RECEIVABLES_TRX_ALL CE_TRANSACTION_CODES.RECEIVABLES_TRX_ID
TableJL_BR_AR_REC_MET_ACCTS_EXT_ALL FK Joins to AR_RECEIVABLES_TRX_ALL JL_BR_AR_REC_MET_ACCTS_EXT_ALL.CALCULATED_INTEREST_RECTRX_ID
TableJL_BR_AR_REC_MET_ACCTS_EXT_ALL FK Joins to AR_RECEIVABLES_TRX_ALL JL_BR_AR_REC_MET_ACCTS_EXT_ALL.INTEREST_WRITEOFF_RECTRX_ID
TableJL_BR_AR_REC_MET_ACCTS_EXT_ALL FK Joins to AR_RECEIVABLES_TRX_ALL JL_BR_AR_REC_MET_ACCTS_EXT_ALL.INTEREST_REVENUE_RECTRX_ID
TableJL_BR_AR_REC_MET_ACCTS_EXT_ALL FK Joins to AR_RECEIVABLES_TRX_ALL JL_BR_AR_REC_MET_ACCTS_EXT_ALL.ABATEMENT_WRITEOFF_RECTRX_ID
TableJL_BR_AR_REC_MET_ACCTS_EXT_ALL FK Joins to AR_RECEIVABLES_TRX_ALL JL_BR_AR_REC_MET_ACCTS_EXT_ALL.ABATEMENT_REVENUE_RECTRX_ID