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

Source

View Text - Preformatted


select DOC_TAX_ID DOC_TAX_ID, TAX_LINE_NO TAX_LINE_NO, TAX_ID TAX_ID, TAX_TYPE TAX_TYPE, CURRENCY_CODE CURRENCY_CODE, TAX_RATE TAX_RATE, QTY_RATE QTY_RATE, UOM UOM, TAX_AMT TAX_AMT, FUNC_TAX_AMT FUNC_TAX_AMT, MODVAT_FLAG MODVAT_FLAG, TAX_CATEGORY_ID TAX_CATEGORY_ID, SOURCE_DOC_TYPE SOURCE_DOC_TYPE, SOURCE_DOC_ID SOURCE_DOC_ID, SOURCE_DOC_LINE_ID SOURCE_DOC_LINE_ID, SOURCE_TABLE_NAME SOURCE_TABLE_NAME, TAX_MODIFIED_BY TAX_MODIFIED_BY, ADHOC_FLAG ADHOC_FLAG, PRECEDENCE_1 PRECEDENCE_1, PRECEDENCE_2 PRECEDENCE_2, PRECEDENCE_3 PRECEDENCE_3, PRECEDENCE_4 PRECEDENCE_4, PRECEDENCE_5 PRECEDENCE_5, PRECEDENCE_6 PRECEDENCE_6, PRECEDENCE_7 PRECEDENCE_7, PRECEDENCE_8 PRECEDENCE_8, PRECEDENCE_9 PRECEDENCE_9, PRECEDENCE_10 PRECEDENCE_10, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, VENDOR_ID VENDOR_ID, SOURCE_DOC_PARENT_LINE_NO SOURCE_DOC_PARENT_LINE_NO from "JA"."JAI_CMN_DOCUMENT_TAXES"

View Text - HTML Formatted

SELECT DOC_TAX_ID DOC_TAX_ID
, TAX_LINE_NO TAX_LINE_NO
, TAX_ID TAX_ID
, TAX_TYPE TAX_TYPE
, CURRENCY_CODE CURRENCY_CODE
, TAX_RATE TAX_RATE
, QTY_RATE QTY_RATE
, UOM UOM
, TAX_AMT TAX_AMT
, FUNC_TAX_AMT FUNC_TAX_AMT
, MODVAT_FLAG MODVAT_FLAG
, TAX_CATEGORY_ID TAX_CATEGORY_ID
, SOURCE_DOC_TYPE SOURCE_DOC_TYPE
, SOURCE_DOC_ID SOURCE_DOC_ID
, SOURCE_DOC_LINE_ID SOURCE_DOC_LINE_ID
, SOURCE_TABLE_NAME SOURCE_TABLE_NAME
, TAX_MODIFIED_BY TAX_MODIFIED_BY
, ADHOC_FLAG ADHOC_FLAG
, PRECEDENCE_1 PRECEDENCE_1
, PRECEDENCE_2 PRECEDENCE_2
, PRECEDENCE_3 PRECEDENCE_3
, PRECEDENCE_4 PRECEDENCE_4
, PRECEDENCE_5 PRECEDENCE_5
, PRECEDENCE_6 PRECEDENCE_6
, PRECEDENCE_7 PRECEDENCE_7
, PRECEDENCE_8 PRECEDENCE_8
, PRECEDENCE_9 PRECEDENCE_9
, PRECEDENCE_10 PRECEDENCE_10
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, VENDOR_ID VENDOR_ID
, SOURCE_DOC_PARENT_LINE_NO SOURCE_DOC_PARENT_LINE_NO
FROM "JA"."JAI_CMN_DOCUMENT_TAXES"