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]

VIEW: JL.JL_BR_AR_REC_MET_ACCTS_EXT_AL#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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