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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: JL.JL_BR_AR_REC_MET_ACCTS_EXT_AL#

Object Details

Object Name:	JL_BR_AR_REC_MET_ACCTS_EXT_AL#
Object Type:	VIEW
Owner:	JL
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BANK_ACCOUNT_ID	NUMBER	(15)
RECEIPT_METHOD_ID	NUMBER	(15)	Yes
BANK_CHARGES_CCID	NUMBER
COLL_ENDORSEMENT_CCID	NUMBER
BILLS_COLLECTION_CCID	NUMBER
OTHER_CREDITS_CCID	NUMBER
FACTORING_DOCS_CCID	NUMBER
PORTFOLIO_CODE	NUMBER
MIN_DOCUMENT_AMOUNT	NUMBER
MAX_DOCUMENT_AMOUNT	NUMBER
MIN_REMITTANCE_AMOUNT	NUMBER
MAX_REMITTANCE_AMOUNT	NUMBER
BANK_INSTRUCTION_CODE1	NUMBER
BANK_INSTRUCTION_CODE2	NUMBER
BANK_CHARGE_AMOUNT	NUMBER
FACTORING_RATE	NUMBER
FACTORING_RATE_PERIOD	NUMBER
BATCH_SOURCE_ID	NUMBER
CALCULATED_INTEREST_CCID	NUMBER
INTEREST_WRITEOFF_CCID	NUMBER
FACTORING_INTEREST_CCID	NUMBER
ABATEMENT_WRITEOFF_CCID	NUMBER	(15)
ABATEMENT_REVENUE_CCID	NUMBER	(15)
INTEREST_REVENUE_CCID	NUMBER	(15)
CALCULATED_INTEREST_RECTRX_ID	NUMBER	(15)
INTEREST_WRITEOFF_RECTRX_ID	NUMBER	(15)
INTEREST_REVENUE_RECTRX_ID	NUMBER	(15)
ABATEMENT_WRITEOFF_RECTRX_ID	NUMBER	(15)
ABATEMENT_REVENUE_RECTRX_ID	NUMBER	(15)
WRITEOFF_PERC_TOLERANCE	NUMBER
WRITEOFF_AMOUNT_TOLERANCE	NUMBER
GL_DATE_BANK_RETURN	VARCHAR2	(15)
FLOATING	NUMBER	(3)
ORG_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
DISC_ENDORSEMENT_CCID	NUMBER	(15)
BILLS_DISCOUNT_CCID	NUMBER	(15)
FACTORING_CHARGES_CCID	NUMBER	(15)
DISCOUNTED_BILLS_CCID	NUMBER	(15)
BANK_ACCT_USE_ID	NUMBER	(15)	Yes
COLL_REMITTANCE_MEDIA	VARCHAR2	(30)
COLL_FORMAT_PGM_ID	NUMBER	(15)
FACTOR_REMITTANCE_MEDIA	VARCHAR2	(30)
FACTOR_FORMAT_PGM_ID	NUMBER	(15)
OCC_REP_FORMAT_PGM_ID	NUMBER	(15)
OCC_FILE_FORMAT_PGM_ID	NUMBER	(15)
MAX_COLLECTION_DOCS	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BANK_ACCOUNT_ID
,      RECEIPT_METHOD_ID
,      BANK_CHARGES_CCID
,      COLL_ENDORSEMENT_CCID
,      BILLS_COLLECTION_CCID
,      OTHER_CREDITS_CCID
,      FACTORING_DOCS_CCID
,      PORTFOLIO_CODE
,      MIN_DOCUMENT_AMOUNT
,      MAX_DOCUMENT_AMOUNT
,      MIN_REMITTANCE_AMOUNT
,      MAX_REMITTANCE_AMOUNT
,      BANK_INSTRUCTION_CODE1
,      BANK_INSTRUCTION_CODE2
,      BANK_CHARGE_AMOUNT
,      FACTORING_RATE
,      FACTORING_RATE_PERIOD
,      BATCH_SOURCE_ID
,      CALCULATED_INTEREST_CCID
,      INTEREST_WRITEOFF_CCID
,      FACTORING_INTEREST_CCID
,      ABATEMENT_WRITEOFF_CCID
,      ABATEMENT_REVENUE_CCID
,      INTEREST_REVENUE_CCID
,      CALCULATED_INTEREST_RECTRX_ID
,      INTEREST_WRITEOFF_RECTRX_ID
,      INTEREST_REVENUE_RECTRX_ID
,      ABATEMENT_WRITEOFF_RECTRX_ID
,      ABATEMENT_REVENUE_RECTRX_ID
,      WRITEOFF_PERC_TOLERANCE
,      WRITEOFF_AMOUNT_TOLERANCE
,      GL_DATE_BANK_RETURN
,      FLOATING
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISC_ENDORSEMENT_CCID
,      BILLS_DISCOUNT_CCID
,      FACTORING_CHARGES_CCID
,      DISCOUNTED_BILLS_CCID
,      BANK_ACCT_USE_ID
,      COLL_REMITTANCE_MEDIA
,      COLL_FORMAT_PGM_ID
,      FACTOR_REMITTANCE_MEDIA
,      FACTOR_FORMAT_PGM_ID
,      OCC_REP_FORMAT_PGM_ID
,      OCC_FILE_FORMAT_PGM_ID
,      MAX_COLLECTION_DOCS
FROM JL.JL_BR_AR_REC_MET_ACCTS_EXT_AL#;

Dependencies

[top of page]

JL.JL_BR_AR_REC_MET_ACCTS_EXT_AL# references the following:

JL: JL_BR_AR_REC_MET_ACCTS_EXT_ALL

JL.JL_BR_AR_REC_MET_ACCTS_EXT_AL# is referenced by following:

APPS: JL_BR_AR_REC_MET_ACCTS_EXT; JL_BR_AR_REC_MET_ACCTS_EXT_ALL