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: JA.JA_CN_CFS_ACTIVITIES_INTERFAC#

Source

View Text - Preformatted


select LEGAL_ENTITY_ID LEGAL_ENTITY_ID, LEDGER_ID LEDGER_ID, ORG_ID ORG_ID, TRX_ID TRX_ID, TRX_NUMBER TRX_NUMBER, TRX_LINE_ID TRX_LINE_ID, SOURCE SOURCE, TRANSACTION_TYPE TRANSACTION_TYPE, DOCUMENT_SEQUENCE_NUMBER DOCUMENT_SEQUENCE_NUMBER, TRANSACTION_DATE TRANSACTION_DATE, GL_DATE GL_DATE, PERIOD_NAME PERIOD_NAME, FUNC_CURR_CODE FUNC_CURR_CODE, FUNC_AMOUNT FUNC_AMOUNT, ORIGINAL_CURR_CODE ORIGINAL_CURR_CODE, ORIGINAL_AMOUNT ORIGINAL_AMOUNT, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, DESCRIPTION DESCRIPTION, DETAILED_CFS_ITEM DETAILED_CFS_ITEM, INTERCOMPANY_FLAG INTERCOMPANY_FLAG, REFERENCE_NUMBER REFERENCE_NUMBER, THIRD_PARTY_NAME THIRD_PARTY_NAME, THIRD_PARTY_NUMBER THIRD_PARTY_NUMBER, EVENT_CLASS_CODE EVENT_CLASS_CODE, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID, ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE, SOURCE_VALUE SOURCE_VALUE, CASH_ITEM_DESC CASH_ITEM_DESC, 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, STATUS STATUS from "JA"."JA_CN_CFS_ACTIVITIES_INTERFACE"

View Text - HTML Formatted

SELECT LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, LEDGER_ID LEDGER_ID
, ORG_ID ORG_ID
, TRX_ID TRX_ID
, TRX_NUMBER TRX_NUMBER
, TRX_LINE_ID TRX_LINE_ID
, SOURCE SOURCE
, TRANSACTION_TYPE TRANSACTION_TYPE
, DOCUMENT_SEQUENCE_NUMBER DOCUMENT_SEQUENCE_NUMBER
, TRANSACTION_DATE TRANSACTION_DATE
, GL_DATE GL_DATE
, PERIOD_NAME PERIOD_NAME
, FUNC_CURR_CODE FUNC_CURR_CODE
, FUNC_AMOUNT FUNC_AMOUNT
, ORIGINAL_CURR_CODE ORIGINAL_CURR_CODE
, ORIGINAL_AMOUNT ORIGINAL_AMOUNT
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, DESCRIPTION DESCRIPTION
, DETAILED_CFS_ITEM DETAILED_CFS_ITEM
, INTERCOMPANY_FLAG INTERCOMPANY_FLAG
, REFERENCE_NUMBER REFERENCE_NUMBER
, THIRD_PARTY_NAME THIRD_PARTY_NAME
, THIRD_PARTY_NUMBER THIRD_PARTY_NUMBER
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, SOURCE_VALUE SOURCE_VALUE
, CASH_ITEM_DESC CASH_ITEM_DESC
, 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
, STATUS STATUS
FROM "JA"."JA_CN_CFS_ACTIVITIES_INTERFACE"