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_INTERFACE_TAX_LINES_ALL#

Source

View Text - Preformatted


select INTERFACE_TAX_LINE_ID INTERFACE_TAX_LINE_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, IMPORT_MODULE IMPORT_MODULE, TRANSACTION_NUM TRANSACTION_NUM, TRANSACTION_LINE_NUM TRANSACTION_LINE_NUM, TAX_LINE_NO TAX_LINE_NO, EXTERNAL_TAX_CODE EXTERNAL_TAX_CODE, QTY_RATE QTY_RATE, 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, TAX_ID TAX_ID, TAX_RATE TAX_RATE, UOM UOM, TAX_AMOUNT TAX_AMOUNT, FUNC_TAX_AMOUNT FUNC_TAX_AMOUNT, BASE_TAX_AMOUNT BASE_TAX_AMOUNT, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG, CODE_COMBINATION_ID CODE_COMBINATION_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY from "JA"."JAI_INTERFACE_TAX_LINES_ALL"

View Text - HTML Formatted

SELECT INTERFACE_TAX_LINE_ID INTERFACE_TAX_LINE_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, IMPORT_MODULE IMPORT_MODULE
, TRANSACTION_NUM TRANSACTION_NUM
, TRANSACTION_LINE_NUM TRANSACTION_LINE_NUM
, TAX_LINE_NO TAX_LINE_NO
, EXTERNAL_TAX_CODE EXTERNAL_TAX_CODE
, QTY_RATE QTY_RATE
, 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
, TAX_ID TAX_ID
, TAX_RATE TAX_RATE
, UOM UOM
, TAX_AMOUNT TAX_AMOUNT
, FUNC_TAX_AMOUNT FUNC_TAX_AMOUNT
, BASE_TAX_AMOUNT BASE_TAX_AMOUNT
, INCLUSIVE_TAX_FLAG INCLUSIVE_TAX_FLAG
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
FROM "JA"."JAI_INTERFACE_TAX_LINES_ALL"