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

Source

View Text - Preformatted


select THRESHOLD_GRP_AUDIT_ID THRESHOLD_GRP_AUDIT_ID, THRESHOLD_GRP_ID THRESHOLD_GRP_ID, OLD_INVOICE_AMOUNT OLD_INVOICE_AMOUNT, OLD_INVOICE_CANCEL_AMOUNT OLD_INVOICE_CANCEL_AMOUNT, OLD_INVOICE_APPLY_AMOUNT OLD_INVOICE_APPLY_AMOUNT, OLD_INVOICE_UNAPPLY_AMOUNT OLD_INVOICE_UNAPPLY_AMOUNT, OLD_TAX_PAID OLD_TAX_PAID, OLD_THHOLD_CHANGE_TAX_PAID OLD_THHOLD_CHANGE_TAX_PAID, OLD_THRESHOLD_SLAB_ID OLD_THRESHOLD_SLAB_ID, TRX_INVOICE_AMOUNT TRX_INVOICE_AMOUNT, TRX_INVOICE_CANCEL_AMOUNT TRX_INVOICE_CANCEL_AMOUNT, TRX_INVOICE_APPLY_AMOUNT TRX_INVOICE_APPLY_AMOUNT, TRX_INVOICE_UNAPPLY_AMOUNT TRX_INVOICE_UNAPPLY_AMOUNT, TRX_TAX_PAID TRX_TAX_PAID, TRX_THHOLD_CHANGE_TAX_PAID TRX_THHOLD_CHANGE_TAX_PAID, TRX_THRESHOLD_SLAB_ID TRX_THRESHOLD_SLAB_ID, NEW_INVOICE_AMOUNT NEW_INVOICE_AMOUNT, NEW_INVOICE_CANCEL_AMOUNT NEW_INVOICE_CANCEL_AMOUNT, NEW_INVOICE_APPLY_AMOUNT NEW_INVOICE_APPLY_AMOUNT, NEW_INVOICE_UNAPPLY_AMOUNT NEW_INVOICE_UNAPPLY_AMOUNT, NEW_TAX_PAID NEW_TAX_PAID, NEW_THHOLD_CHANGE_TAX_PAID NEW_THHOLD_CHANGE_TAX_PAID, NEW_THRESHOLD_SLAB_ID NEW_THRESHOLD_SLAB_ID, TDS_EVENT TDS_EVENT, INVOICE_ID INVOICE_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, REMARKS REMARKS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, CALC_OLD_TAX_PAID CALC_OLD_TAX_PAID, CALC_TRX_TAX_PAID CALC_TRX_TAX_PAID, CALC_NEW_TAX_PAID CALC_NEW_TAX_PAID from "JA"."JAI_AP_TDS_THGRP_AUDITS"

View Text - HTML Formatted

SELECT THRESHOLD_GRP_AUDIT_ID THRESHOLD_GRP_AUDIT_ID
, THRESHOLD_GRP_ID THRESHOLD_GRP_ID
, OLD_INVOICE_AMOUNT OLD_INVOICE_AMOUNT
, OLD_INVOICE_CANCEL_AMOUNT OLD_INVOICE_CANCEL_AMOUNT
, OLD_INVOICE_APPLY_AMOUNT OLD_INVOICE_APPLY_AMOUNT
, OLD_INVOICE_UNAPPLY_AMOUNT OLD_INVOICE_UNAPPLY_AMOUNT
, OLD_TAX_PAID OLD_TAX_PAID
, OLD_THHOLD_CHANGE_TAX_PAID OLD_THHOLD_CHANGE_TAX_PAID
, OLD_THRESHOLD_SLAB_ID OLD_THRESHOLD_SLAB_ID
, TRX_INVOICE_AMOUNT TRX_INVOICE_AMOUNT
, TRX_INVOICE_CANCEL_AMOUNT TRX_INVOICE_CANCEL_AMOUNT
, TRX_INVOICE_APPLY_AMOUNT TRX_INVOICE_APPLY_AMOUNT
, TRX_INVOICE_UNAPPLY_AMOUNT TRX_INVOICE_UNAPPLY_AMOUNT
, TRX_TAX_PAID TRX_TAX_PAID
, TRX_THHOLD_CHANGE_TAX_PAID TRX_THHOLD_CHANGE_TAX_PAID
, TRX_THRESHOLD_SLAB_ID TRX_THRESHOLD_SLAB_ID
, NEW_INVOICE_AMOUNT NEW_INVOICE_AMOUNT
, NEW_INVOICE_CANCEL_AMOUNT NEW_INVOICE_CANCEL_AMOUNT
, NEW_INVOICE_APPLY_AMOUNT NEW_INVOICE_APPLY_AMOUNT
, NEW_INVOICE_UNAPPLY_AMOUNT NEW_INVOICE_UNAPPLY_AMOUNT
, NEW_TAX_PAID NEW_TAX_PAID
, NEW_THHOLD_CHANGE_TAX_PAID NEW_THHOLD_CHANGE_TAX_PAID
, NEW_THRESHOLD_SLAB_ID NEW_THRESHOLD_SLAB_ID
, TDS_EVENT TDS_EVENT
, INVOICE_ID INVOICE_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, REMARKS REMARKS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, CALC_OLD_TAX_PAID CALC_OLD_TAX_PAID
, CALC_TRX_TAX_PAID CALC_TRX_TAX_PAID
, CALC_NEW_TAX_PAID CALC_NEW_TAX_PAID
FROM "JA"."JAI_AP_TDS_THGRP_AUDITS"