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: JL_BR_AR_COLLECTION_DOCS_ALL

Product:	JL - Latin America Localizations
Description:	Collection Documents
Implementation/DBA Data:	JL.JL_BR_AR_COLLECTION_DOCS_ALL

Primary Key: JL_BR_AR_COLLEC_DOCS_ALL_PK

DOCUMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.UNAPPLIED_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	JL_BR_AR_BORDEROS_ALL	JL_BR_AR_COLLECTION_DOCS_ALL.BORDERO_ID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.UNEARNED_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.UNIDENTIFIED_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.BANK_CHARGES_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.COLL_ENDORSEMENTS_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.BILLS_COLLECTION_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.OTHER_CREDITS_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.FACTORING_DOCS_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.CALCULATED_INTEREST_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.INTEREST_WRITEOFF_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.FACTORING_INTEREST_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	AR_RECEIPT_METHOD_ACCOUNTS_ALL	JL_BR_AR_COLLECTION_DOCS_ALL.BANK_ACCOUNT_ID JL_BR_AR_COLLECTION_DOCS_ALL.RECEIPT_METHOD_ID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.ABATEMENT_WRITEOFF_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.ABATEMENT_REVENUE_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.INTEREST_REVENUE_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.CALCULATED_INTEREST_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.INTEREST_WRITEOFF_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.INTEREST_REVENUE_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.ABATEMENT_WRITEOFF_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.ABATE_REVENUE_RECTRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL	CE_BANK_ACCT_USES_ALL	JL_BR_AR_COLLECTION_DOCS_ALL.BANK_ACCT_USE_ID
JL_BR_AR_COLLECTION_DOCS_ALL	HZ_PARTIES	JL_BR_AR_COLLECTION_DOCS_ALL.COLLECTOR_BANK_PARTY_ID
JL_BR_AR_COLLECTION_DOCS_ALL	AR_PAYMENT_SCHEDULES_ALL	JL_BR_AR_COLLECTION_DOCS_ALL.PAYMENT_SCHEDULE_ID
JL_BR_AR_COLLECTION_DOCS_ALL	HZ_PARTIES	JL_BR_AR_COLLECTION_DOCS_ALL.COLLECTOR_BRANCH_PARTY_ID
JL_BR_AR_COLLECTION_DOCS_ALL	AR_BATCH_SOURCES_ALL	JL_BR_AR_COLLECTION_DOCS_ALL.BATCH_SOURCE_ID
JL_BR_AR_COLLECTION_DOCS_ALL	RA_CUSTOMER_TRX_ALL	JL_BR_AR_COLLECTION_DOCS_ALL.CUSTOMER_TRX_ID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.CASH_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.EARNED_CCID
JL_BR_AR_COLLECTION_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_COLLECTION_DOCS_ALL.ON_ACCOUNT_CCID
JL_BR_AR_BANK_RETURNS_ALL	JL_BR_AR_COLLECTION_DOCS_ALL	JL_BR_AR_BANK_RETURNS_ALL.DOCUMENT_ID
JL_BR_AR_OCCURRENCE_DOCS_ALL	JL_BR_AR_COLLECTION_DOCS_ALL	JL_BR_AR_OCCURRENCE_DOCS_ALL.DOCUMENT_ID