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

Source

View Text - Preformatted


select THRESHOLD_TRX_ID THRESHOLD_TRX_ID, INVOICE_ID INVOICE_ID, THRESHOLD_GRP_ID THRESHOLD_GRP_ID, THRESHOLD_HDR_ID THRESHOLD_HDR_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, TDS_EVENT TDS_EVENT, TAX_ID TAX_ID, TAX_RATE TAX_RATE, TAXABLE_AMOUNT TAXABLE_AMOUNT, TAX_AMOUNT TAX_AMOUNT, TDS_AUTHORITY_VENDOR_ID TDS_AUTHORITY_VENDOR_ID, TDS_AUTHORITY_VENDOR_SITE_ID TDS_AUTHORITY_VENDOR_SITE_ID, INVOICE_TO_TDS_AUTHORITY_NUM INVOICE_TO_TDS_AUTHORITY_NUM, INVOICE_TO_TDS_AUTHORITY_TYPE INVOICE_TO_TDS_AUTHORITY_TYPE, INVOICE_TO_TDS_AUTHORITY_CURR INVOICE_TO_TDS_AUTHORITY_CURR, INVOICE_TO_TDS_AUTHORITY_AMT INVOICE_TO_TDS_AUTHORITY_AMT, INVOICE_TO_TDS_AUTHORITY_ID INVOICE_TO_TDS_AUTHORITY_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, INVOICE_TO_VENDOR_NUM INVOICE_TO_VENDOR_NUM, INVOICE_TO_VENDOR_TYPE INVOICE_TO_VENDOR_TYPE, INVOICE_TO_VENDOR_CURR INVOICE_TO_VENDOR_CURR, INVOICE_TO_VENDOR_AMT INVOICE_TO_VENDOR_AMT, INVOICE_TO_VENDOR_ID INVOICE_TO_VENDOR_ID, PARENT_INV_PAYMENT_PRIORITY PARENT_INV_PAYMENT_PRIORITY, PARENT_INV_EXCHANGE_RATE PARENT_INV_EXCHANGE_RATE, 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_TAX_AMOUNT CALC_TAX_AMOUNT, TDS_ROUNDING_FACTOR TDS_ROUNDING_FACTOR, TDS_ROLLBACKED TDS_ROLLBACKED, ROLLBACK_REVERSED ROLLBACK_REVERSED, TDS_SECTION_CODE TDS_SECTION_CODE, TAX_CATEGORY_ID TAX_CATEGORY_ID from "JA"."JAI_AP_TDS_THHOLD_TRXS"

View Text - HTML Formatted

SELECT THRESHOLD_TRX_ID THRESHOLD_TRX_ID
, INVOICE_ID INVOICE_ID
, THRESHOLD_GRP_ID THRESHOLD_GRP_ID
, THRESHOLD_HDR_ID THRESHOLD_HDR_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, TDS_EVENT TDS_EVENT
, TAX_ID TAX_ID
, TAX_RATE TAX_RATE
, TAXABLE_AMOUNT TAXABLE_AMOUNT
, TAX_AMOUNT TAX_AMOUNT
, TDS_AUTHORITY_VENDOR_ID TDS_AUTHORITY_VENDOR_ID
, TDS_AUTHORITY_VENDOR_SITE_ID TDS_AUTHORITY_VENDOR_SITE_ID
, INVOICE_TO_TDS_AUTHORITY_NUM INVOICE_TO_TDS_AUTHORITY_NUM
, INVOICE_TO_TDS_AUTHORITY_TYPE INVOICE_TO_TDS_AUTHORITY_TYPE
, INVOICE_TO_TDS_AUTHORITY_CURR INVOICE_TO_TDS_AUTHORITY_CURR
, INVOICE_TO_TDS_AUTHORITY_AMT INVOICE_TO_TDS_AUTHORITY_AMT
, INVOICE_TO_TDS_AUTHORITY_ID INVOICE_TO_TDS_AUTHORITY_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, INVOICE_TO_VENDOR_NUM INVOICE_TO_VENDOR_NUM
, INVOICE_TO_VENDOR_TYPE INVOICE_TO_VENDOR_TYPE
, INVOICE_TO_VENDOR_CURR INVOICE_TO_VENDOR_CURR
, INVOICE_TO_VENDOR_AMT INVOICE_TO_VENDOR_AMT
, INVOICE_TO_VENDOR_ID INVOICE_TO_VENDOR_ID
, PARENT_INV_PAYMENT_PRIORITY PARENT_INV_PAYMENT_PRIORITY
, PARENT_INV_EXCHANGE_RATE PARENT_INV_EXCHANGE_RATE
, 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_TAX_AMOUNT CALC_TAX_AMOUNT
, TDS_ROUNDING_FACTOR TDS_ROUNDING_FACTOR
, TDS_ROLLBACKED TDS_ROLLBACKED
, ROLLBACK_REVERSED ROLLBACK_REVERSED
, TDS_SECTION_CODE TDS_SECTION_CODE
, TAX_CATEGORY_ID TAX_CATEGORY_ID
FROM "JA"."JAI_AP_TDS_THHOLD_TRXS"