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.JAI_AR_SUP_TAXES#

Source

View Text - Preformatted


select TAX_LINE_NO TAX_LINE_NO, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, LINK_TO_CUST_TRX_LINE_ID LINK_TO_CUST_TRX_LINE_ID, SUP_INV_TYPE SUP_INV_TYPE, OLD_TAX_ID OLD_TAX_ID, OLD_RATE OLD_RATE, OLD_UOM OLD_UOM, OLD_QTY_RATE OLD_QTY_RATE, NEW_TAX_ID NEW_TAX_ID, NEW_RATE NEW_RATE, NEW_UOM NEW_UOM, NEW_QTY_RATE NEW_QTY_RATE, MAPPING_ID MAPPING_ID, PRECEDENCE_1 PRECEDENCE_1, PRECEDENCE_2 PRECEDENCE_2, PRECEDENCE_3 PRECEDENCE_3, PRECEDENCE_4 PRECEDENCE_4, PRECEDENCE_5 PRECEDENCE_5, EXIST_TAX_AMT EXIST_TAX_AMT, NEW_TAX_AMT NEW_TAX_AMT, OLD_BASE_TAX_AMT OLD_BASE_TAX_AMT, NEW_BASE_TAX_AMT NEW_BASE_TAX_AMT, OLD_FUNC_TAX_AMT OLD_FUNC_TAX_AMT, NEW_FUNC_TAX_AMT NEW_FUNC_TAX_AMT, DIFF_AMT DIFF_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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PRECEDENCE_6 PRECEDENCE_6, PRECEDENCE_7 PRECEDENCE_7, PRECEDENCE_8 PRECEDENCE_8, PRECEDENCE_9 PRECEDENCE_9, PRECEDENCE_10 PRECEDENCE_10 from "JA"."JAI_AR_SUP_TAXES"

View Text - HTML Formatted

SELECT TAX_LINE_NO TAX_LINE_NO
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, LINK_TO_CUST_TRX_LINE_ID LINK_TO_CUST_TRX_LINE_ID
, SUP_INV_TYPE SUP_INV_TYPE
, OLD_TAX_ID OLD_TAX_ID
, OLD_RATE OLD_RATE
, OLD_UOM OLD_UOM
, OLD_QTY_RATE OLD_QTY_RATE
, NEW_TAX_ID NEW_TAX_ID
, NEW_RATE NEW_RATE
, NEW_UOM NEW_UOM
, NEW_QTY_RATE NEW_QTY_RATE
, MAPPING_ID MAPPING_ID
, PRECEDENCE_1 PRECEDENCE_1
, PRECEDENCE_2 PRECEDENCE_2
, PRECEDENCE_3 PRECEDENCE_3
, PRECEDENCE_4 PRECEDENCE_4
, PRECEDENCE_5 PRECEDENCE_5
, EXIST_TAX_AMT EXIST_TAX_AMT
, NEW_TAX_AMT NEW_TAX_AMT
, OLD_BASE_TAX_AMT OLD_BASE_TAX_AMT
, NEW_BASE_TAX_AMT NEW_BASE_TAX_AMT
, OLD_FUNC_TAX_AMT OLD_FUNC_TAX_AMT
, NEW_FUNC_TAX_AMT NEW_FUNC_TAX_AMT
, DIFF_AMT DIFF_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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PRECEDENCE_6 PRECEDENCE_6
, PRECEDENCE_7 PRECEDENCE_7
, PRECEDENCE_8 PRECEDENCE_8
, PRECEDENCE_9 PRECEDENCE_9
, PRECEDENCE_10 PRECEDENCE_10
FROM "JA"."JAI_AR_SUP_TAXES"