DBA Data[Home] [Help]

VIEW: IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES#

Source

View Text - Preformatted

select CBC_JE_BATCH_ID CBC_JE_BATCH_ID, REPORTING_SET_OF_BOOKS_ID REPORTING_SET_OF_BOOKS_ID, REPORTING_CURRENCY_CODE REPORTING_CURRENCY_CODE, RUNNING_TOTAL_DR RUNNING_TOTAL_DR, RUNNING_TOTAL_CR RUNNING_TOTAL_CR, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_DATE CONVERSION_DATE, CONVERSION_RATE CONVERSION_RATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY from "IGC"."IGC_CBC_ARCHIVE_MC_JE_BATCHES"
View Text - HTML Formatted

SELECT CBC_JE_BATCH_ID CBC_JE_BATCH_ID
, REPORTING_SET_OF_BOOKS_ID REPORTING_SET_OF_BOOKS_ID
, REPORTING_CURRENCY_CODE REPORTING_CURRENCY_CODE
, RUNNING_TOTAL_DR RUNNING_TOTAL_DR
, RUNNING_TOTAL_CR RUNNING_TOTAL_CR
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_DATE CONVERSION_DATE
, CONVERSION_RATE CONVERSION_RATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
FROM "IGC"."IGC_CBC_ARCHIVE_MC_JE_BATCHES"