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: CE.CE_CASHFLOWS#

Source

View Text - Preformatted


select CASHFLOW_ID CASHFLOW_ID, CASHFLOW_LEDGER_ID CASHFLOW_LEDGER_ID, CASHFLOW_LEGAL_ENTITY_ID CASHFLOW_LEGAL_ENTITY_ID, CASHFLOW_BANK_ACCOUNT_ID CASHFLOW_BANK_ACCOUNT_ID, CASHFLOW_DIRECTION CASHFLOW_DIRECTION, CASHFLOW_CURRENCY_CODE CASHFLOW_CURRENCY_CODE, CASHFLOW_DATE CASHFLOW_DATE, CASHFLOW_AMOUNT CASHFLOW_AMOUNT, BASE_AMOUNT BASE_AMOUNT, DESCRIPTION DESCRIPTION, CASHFLOW_EXCHANGE_RATE CASHFLOW_EXCHANGE_RATE, CASHFLOW_EXCHANGE_DATE CASHFLOW_EXCHANGE_DATE, CASHFLOW_EXCHANGE_RATE_TYPE CASHFLOW_EXCHANGE_RATE_TYPE, TRXN_REFERENCE_NUMBER TRXN_REFERENCE_NUMBER, BANK_TRXN_NUMBER BANK_TRXN_NUMBER, SOURCE_TRXN_TYPE SOURCE_TRXN_TYPE, SOURCE_TRXN_SUBTYPE_CODE_ID SOURCE_TRXN_SUBTYPE_CODE_ID, STATEMENT_LINE_ID STATEMENT_LINE_ID, ACTUAL_VALUE_DATE ACTUAL_VALUE_DATE, COUNTERPARTY_PARTY_ID COUNTERPARTY_PARTY_ID, COUNTERPARTY_BANK_ACCOUNT_ID COUNTERPARTY_BANK_ACCOUNT_ID, OFFSET_CCID OFFSET_CCID, CASHFLOW_STATUS_CODE CASHFLOW_STATUS_CODE, CLEARED_DATE CLEARED_DATE, CLEARED_AMOUNT CLEARED_AMOUNT, CLEARED_EXCHANGE_RATE CLEARED_EXCHANGE_RATE, CLEARED_EXCHANGE_DATE CLEARED_EXCHANGE_DATE, CLEARED_EXCHANGE_RATE_TYPE CLEARED_EXCHANGE_RATE_TYPE, CLEARING_CHARGES_AMOUNT CLEARING_CHARGES_AMOUNT, CLEARING_ERROR_AMOUNT CLEARING_ERROR_AMOUNT, CLEARED_BY_FLAG CLEARED_BY_FLAG, REFERENCE_TEXT REFERENCE_TEXT, BANK_ACCOUNT_TEXT#1 BANK_ACCOUNT_TEXT, CUSTOMER_TEXT CUSTOMER_TEXT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "CE"."CE_CASHFLOWS"

View Text - HTML Formatted

SELECT CASHFLOW_ID CASHFLOW_ID
, CASHFLOW_LEDGER_ID CASHFLOW_LEDGER_ID
, CASHFLOW_LEGAL_ENTITY_ID CASHFLOW_LEGAL_ENTITY_ID
, CASHFLOW_BANK_ACCOUNT_ID CASHFLOW_BANK_ACCOUNT_ID
, CASHFLOW_DIRECTION CASHFLOW_DIRECTION
, CASHFLOW_CURRENCY_CODE CASHFLOW_CURRENCY_CODE
, CASHFLOW_DATE CASHFLOW_DATE
, CASHFLOW_AMOUNT CASHFLOW_AMOUNT
, BASE_AMOUNT BASE_AMOUNT
, DESCRIPTION DESCRIPTION
, CASHFLOW_EXCHANGE_RATE CASHFLOW_EXCHANGE_RATE
, CASHFLOW_EXCHANGE_DATE CASHFLOW_EXCHANGE_DATE
, CASHFLOW_EXCHANGE_RATE_TYPE CASHFLOW_EXCHANGE_RATE_TYPE
, TRXN_REFERENCE_NUMBER TRXN_REFERENCE_NUMBER
, BANK_TRXN_NUMBER BANK_TRXN_NUMBER
, SOURCE_TRXN_TYPE SOURCE_TRXN_TYPE
, SOURCE_TRXN_SUBTYPE_CODE_ID SOURCE_TRXN_SUBTYPE_CODE_ID
, STATEMENT_LINE_ID STATEMENT_LINE_ID
, ACTUAL_VALUE_DATE ACTUAL_VALUE_DATE
, COUNTERPARTY_PARTY_ID COUNTERPARTY_PARTY_ID
, COUNTERPARTY_BANK_ACCOUNT_ID COUNTERPARTY_BANK_ACCOUNT_ID
, OFFSET_CCID OFFSET_CCID
, CASHFLOW_STATUS_CODE CASHFLOW_STATUS_CODE
, CLEARED_DATE CLEARED_DATE
, CLEARED_AMOUNT CLEARED_AMOUNT
, CLEARED_EXCHANGE_RATE CLEARED_EXCHANGE_RATE
, CLEARED_EXCHANGE_DATE CLEARED_EXCHANGE_DATE
, CLEARED_EXCHANGE_RATE_TYPE CLEARED_EXCHANGE_RATE_TYPE
, CLEARING_CHARGES_AMOUNT CLEARING_CHARGES_AMOUNT
, CLEARING_ERROR_AMOUNT CLEARING_ERROR_AMOUNT
, CLEARED_BY_FLAG CLEARED_BY_FLAG
, REFERENCE_TEXT REFERENCE_TEXT
, BANK_ACCOUNT_TEXT#1 BANK_ACCOUNT_TEXT
, CUSTOMER_TEXT CUSTOMER_TEXT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "CE"."CE_CASHFLOWS"