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.

VIEW: CE.CE_GL_ACCOUNTS_CCID#

Source

View Text - Preformatted


select BANK_ACCT_USE_ID BANK_ACCT_USE_ID, ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID, AP_ASSET_CCID AP_ASSET_CCID, AR_ASSET_CCID AR_ASSET_CCID, CASH_CLEARING_CCID CASH_CLEARING_CCID, BANK_CHARGES_CCID BANK_CHARGES_CCID, BANK_ERRORS_CCID BANK_ERRORS_CCID, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID, ON_ACCOUNT_CCID ON_ACCOUNT_CCID, UNAPPLIED_CCID UNAPPLIED_CCID, UNIDENTIFIED_CCID UNIDENTIFIED_CCID, FACTOR_CCID FACTOR_CCID, RECEIPT_CLEARING_CCID RECEIPT_CLEARING_CCID, REMITTANCE_CCID REMITTANCE_CCID, AR_SHORT_TERM_DEPOSIT_CCID AR_SHORT_TERM_DEPOSIT_CCID, BR_SHORT_TERM_DEPOSIT_CCID BR_SHORT_TERM_DEPOSIT_CCID, FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID, 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, BR_REMITTANCE_CCID BR_REMITTANCE_CCID, BR_FACTOR_CCID BR_FACTOR_CCID, BANK_INTEREST_EXPENSE_CCID BANK_INTEREST_EXPENSE_CCID, BANK_INTEREST_INCOME_CCID BANK_INTEREST_INCOME_CCID, XTR_ASSET_CCID XTR_ASSET_CCID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AR_BANK_CHARGES_CCID AR_BANK_CHARGES_CCID from "CE"."CE_GL_ACCOUNTS_CCID"

View Text - HTML Formatted

SELECT BANK_ACCT_USE_ID BANK_ACCT_USE_ID
, ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID
, AP_ASSET_CCID AP_ASSET_CCID
, AR_ASSET_CCID AR_ASSET_CCID
, CASH_CLEARING_CCID CASH_CLEARING_CCID
, BANK_CHARGES_CCID BANK_CHARGES_CCID
, BANK_ERRORS_CCID BANK_ERRORS_CCID
, GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID
, LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID
, ON_ACCOUNT_CCID ON_ACCOUNT_CCID
, UNAPPLIED_CCID UNAPPLIED_CCID
, UNIDENTIFIED_CCID UNIDENTIFIED_CCID
, FACTOR_CCID FACTOR_CCID
, RECEIPT_CLEARING_CCID RECEIPT_CLEARING_CCID
, REMITTANCE_CCID REMITTANCE_CCID
, AR_SHORT_TERM_DEPOSIT_CCID AR_SHORT_TERM_DEPOSIT_CCID
, BR_SHORT_TERM_DEPOSIT_CCID BR_SHORT_TERM_DEPOSIT_CCID
, FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID
, 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
, BR_REMITTANCE_CCID BR_REMITTANCE_CCID
, BR_FACTOR_CCID BR_FACTOR_CCID
, BANK_INTEREST_EXPENSE_CCID BANK_INTEREST_EXPENSE_CCID
, BANK_INTEREST_INCOME_CCID BANK_INTEREST_INCOME_CCID
, XTR_ASSET_CCID XTR_ASSET_CCID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AR_BANK_CHARGES_CCID AR_BANK_CHARGES_CCID
FROM "CE"."CE_GL_ACCOUNTS_CCID"