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_RECEIVABLES_TRX_ALL

Product:	AR - Receivables
Description:	Accounting information for Receivables activities
Implementation/DBA Data:	AR.AR_RECEIVABLES_TRX_ALL

Primary Key: AR_RECEIVABLES_TRX_PK

RECEIVABLES_TRX_ID

Primary Key: AR_RECEIVABLES_TRX_UK1

NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_RECEIVABLES_TRX_ALL	GL_CODE_COMBINATIONS	AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID
AR_RECEIVABLES_TRX_ALL	GL_SETS_OF_BOOKS_11I	AR_RECEIVABLES_TRX_ALL.SET_OF_BOOKS_ID
AR_RECEIVABLES_TRX_ALL	AR_DISTRIBUTION_SETS_ALL	AR_RECEIVABLES_TRX_ALL.DEFAULT_ACCTG_DISTRIBUTION_SET
AP_BANK_ACCOUNTS_ALL	AR_RECEIVABLES_TRX_ALL	AP_BANK_ACCOUNTS_ALL.BR_STD_RECEIVABLES_TRX_ID
AR_ADJUSTMENTS_ALL	AR_RECEIVABLES_TRX_ALL	AR_ADJUSTMENTS_ALL.RECEIVABLES_TRX_ID
AR_CASH_RECEIPTS_ALL	AR_RECEIVABLES_TRX_ALL	AR_CASH_RECEIPTS_ALL.RECEIVABLES_TRX_ID
AR_RECEIPT_METHOD_ACCOUNTS_ALL	AR_RECEIVABLES_TRX_ALL	AR_RECEIPT_METHOD_ACCOUNTS_ALL.EDISC_RECEIVABLES_TRX_ID
AR_RECEIPT_METHOD_ACCOUNTS_ALL	AR_RECEIVABLES_TRX_ALL	AR_RECEIPT_METHOD_ACCOUNTS_ALL.UNEDISC_RECEIVABLES_TRX_ID
AR_RECEIPT_METHOD_ACCOUNTS_ALL	AR_RECEIVABLES_TRX_ALL	AR_RECEIPT_METHOD_ACCOUNTS_ALL.BR_STD_RECEIVABLES_TRX_ID
AR_SYSTEM_PARAMETERS_ALL	AR_RECEIVABLES_TRX_ALL	AR_SYSTEM_PARAMETERS_ALL.PENALTY_REC_TRX_ID
AR_SYSTEM_PARAMETERS_ALL	AR_RECEIVABLES_TRX_ALL	AR_SYSTEM_PARAMETERS_ALL.FINCHRG_RECEIVABLES_TRX_ID
AR_SYSTEM_PARAMETERS_ALL	AR_RECEIVABLES_TRX_ALL	AR_SYSTEM_PARAMETERS_ALL.IREC_SERVICE_CHARGE_REC_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.EDISC_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.UNEDISC_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.BR_STD_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.EDISC_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.UNEDISC_RECEIVABLES_TRX_ID
CE_BANK_ACCT_USES_ALL	AR_RECEIVABLES_TRX_ALL	CE_BANK_ACCT_USES_ALL.BR_STD_RECEIVABLES_TRX_ID
CE_SYSTEM_PARAMETERS_ALL	AR_RECEIVABLES_TRX_ALL	CE_SYSTEM_PARAMETERS_ALL.RECEIVABLES_TRX_ID
CE_SYSTEM_PARAMETERS	AR_RECEIVABLES_TRX_ALL	CE_SYSTEM_PARAMETERS.RECEIVABLES_TRX_ID_OLD
CE_TRANSACTION_CODES	AR_RECEIVABLES_TRX_ALL	CE_TRANSACTION_CODES.RECEIVABLES_TRX_ID
JL_BR_AR_REC_MET_ACCTS_EXT_ALL	AR_RECEIVABLES_TRX_ALL	JL_BR_AR_REC_MET_ACCTS_EXT_ALL.CALCULATED_INTEREST_RECTRX_ID
JL_BR_AR_REC_MET_ACCTS_EXT_ALL	AR_RECEIVABLES_TRX_ALL	JL_BR_AR_REC_MET_ACCTS_EXT_ALL.INTEREST_WRITEOFF_RECTRX_ID
JL_BR_AR_REC_MET_ACCTS_EXT_ALL	AR_RECEIVABLES_TRX_ALL	JL_BR_AR_REC_MET_ACCTS_EXT_ALL.INTEREST_REVENUE_RECTRX_ID
JL_BR_AR_REC_MET_ACCTS_EXT_ALL	AR_RECEIVABLES_TRX_ALL	JL_BR_AR_REC_MET_ACCTS_EXT_ALL.ABATEMENT_WRITEOFF_RECTRX_ID
JL_BR_AR_REC_MET_ACCTS_EXT_ALL	AR_RECEIVABLES_TRX_ALL	JL_BR_AR_REC_MET_ACCTS_EXT_ALL.ABATEMENT_REVENUE_RECTRX_ID