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: JE.JE_IT_LIST_LINES_ALL#

Source

View Text - Preformatted


select PERIOD_NAME PERIOD_NAME, ORG_ID ORG_ID, APPLICATION_ID APPLICATION_ID, PARTY_ID PARTY_ID, TRX_TYPE_CODE TRX_TYPE_CODE, TRX_TYPE_ID TRX_TYPE_ID, DOC_SEQ_ID DOC_SEQ_ID, DOC_SEQ_NUM DOC_SEQ_NUM, TRX_DATE TRX_DATE, TRX_ID TRX_ID, TRX_NUM TRX_NUM, TRX_DIST_ID TRX_DIST_ID, TRX_LINE_TYPE_CODE TRX_LINE_TYPE_CODE, TRX_LINE_TAX_CODE_ID TRX_LINE_TAX_CODE_ID, TAXABLE_AMT TAXABLE_AMT, VAT_AMT VAT_AMT, NON_TAXABLE_AMT NON_TAXABLE_AMT, EXEMPT_AMT EXEMPT_AMT, TAXABLE_VAT_AMT TAXABLE_VAT_AMT, TAXABLE_VAT_INV_AMT TAXABLE_VAT_INV_AMT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, VAT_REPORTING_ENTITY_ID VAT_REPORTING_ENTITY_ID, YEAR_OF_DECLARATION YEAR_OF_DECLARATION, CM_TAXABLE_AMT CM_TAXABLE_AMT, CM_VAT_AMT CM_VAT_AMT, CM_NON_TAXABLE_AMT CM_NON_TAXABLE_AMT, CM_EXEMPT_AMT CM_EXEMPT_AMT, CM_TAXABLE_VAT_AMT CM_TAXABLE_VAT_AMT, CM_TAXABLE_VAT_INV_AMT CM_TAXABLE_VAT_INV_AMT, TAX_RATE_ID TAX_RATE_ID from "JE"."JE_IT_LIST_LINES_ALL"

View Text - HTML Formatted

SELECT PERIOD_NAME PERIOD_NAME
, ORG_ID ORG_ID
, APPLICATION_ID APPLICATION_ID
, PARTY_ID PARTY_ID
, TRX_TYPE_CODE TRX_TYPE_CODE
, TRX_TYPE_ID TRX_TYPE_ID
, DOC_SEQ_ID DOC_SEQ_ID
, DOC_SEQ_NUM DOC_SEQ_NUM
, TRX_DATE TRX_DATE
, TRX_ID TRX_ID
, TRX_NUM TRX_NUM
, TRX_DIST_ID TRX_DIST_ID
, TRX_LINE_TYPE_CODE TRX_LINE_TYPE_CODE
, TRX_LINE_TAX_CODE_ID TRX_LINE_TAX_CODE_ID
, TAXABLE_AMT TAXABLE_AMT
, VAT_AMT VAT_AMT
, NON_TAXABLE_AMT NON_TAXABLE_AMT
, EXEMPT_AMT EXEMPT_AMT
, TAXABLE_VAT_AMT TAXABLE_VAT_AMT
, TAXABLE_VAT_INV_AMT TAXABLE_VAT_INV_AMT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, VAT_REPORTING_ENTITY_ID VAT_REPORTING_ENTITY_ID
, YEAR_OF_DECLARATION YEAR_OF_DECLARATION
, CM_TAXABLE_AMT CM_TAXABLE_AMT
, CM_VAT_AMT CM_VAT_AMT
, CM_NON_TAXABLE_AMT CM_NON_TAXABLE_AMT
, CM_EXEMPT_AMT CM_EXEMPT_AMT
, CM_TAXABLE_VAT_AMT CM_TAXABLE_VAT_AMT
, CM_TAXABLE_VAT_INV_AMT CM_TAXABLE_VAT_INV_AMT
, TAX_RATE_ID TAX_RATE_ID
FROM "JE"."JE_IT_LIST_LINES_ALL"