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_OCCURRENCE_DOCS_ALL

Product:	JL - Latin America Localizations
Description:	Occurrences for collection documents
Implementation/DBA Data:	JL.JL_BR_AR_OCCURRENCE_DOCS_ALL

Primary Key: JL_BR_AR_OCCUR_DOCS_ALL_PK

OCCURRENCE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
JL_BR_AR_OCCURRENCE_DOCS_ALL	JL_BR_AR_COLLECTION_DOCS_ALL	JL_BR_AR_OCCURRENCE_DOCS_ALL.DOCUMENT_ID
JL_BR_AR_OCCURRENCE_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_OCCURRENCE_DOCS_ALL.DISCOUNT_CRED_ACCT_CCID
JL_BR_AR_OCCURRENCE_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_OCCURRENCE_DOCS_ALL.FACTORING_DEBIT_CCID
JL_BR_AR_OCCURRENCE_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_OCCURRENCE_DOCS_ALL.FACTORING_CREDIT_CCID
JL_BR_AR_OCCURRENCE_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_OCCURRENCE_DOCS_ALL.FACTOR_INTEREST_CREDIT_CCID
JL_BR_AR_OCCURRENCE_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_OCCURRENCE_DOCS_ALL.FACTOR_INTEREST_DEBIT_CCID
JL_BR_AR_OCCURRENCE_DOCS_ALL	HZ_PARTIES	JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_PARTY_ID
JL_BR_AR_OCCURRENCE_DOCS_ALL	JL_BR_AR_BORDEROS_ALL	JL_BR_AR_OCCURRENCE_DOCS_ALL.BORDERO_ID
JL_BR_AR_OCCURRENCE_DOCS_ALL	JL_BR_AR_BANK_OCCURRENCES	JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_OCCURRENCE_CODE JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_NUMBER JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_OCCURRENCE_TYPE
JL_BR_AR_OCCURRENCE_DOCS_ALL	HZ_CUST_ACCOUNTS	JL_BR_AR_OCCURRENCE_DOCS_ALL.CUSTOMER_ID
JL_BR_AR_OCCURRENCE_DOCS_ALL	HZ_CUST_SITE_USES_ALL	JL_BR_AR_OCCURRENCE_DOCS_ALL.SITE_USE_ID
JL_BR_AR_OCCURRENCE_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_OCCURRENCE_DOCS_ALL.ENDORSEMENT_CREDIT_CCID
JL_BR_AR_OCCURRENCE_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_OCCURRENCE_DOCS_ALL.ENDORSEMENT_DEBIT_CCID
JL_BR_AR_OCCURRENCE_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_CHARGES_CREDIT_CCID
JL_BR_AR_OCCURRENCE_DOCS_ALL	GL_CODE_COMBINATIONS	JL_BR_AR_OCCURRENCE_DOCS_ALL.BANK_CHARGES_DEBIT_CCID