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

Source

View Text - Preformatted


select TDS_PREPAYMENT_ID TDS_PREPAYMENT_ID, INVOICE_ID INVOICE_ID, INVOICE_DISTRIBUTION_ID_PREPAY INVOICE_DISTRIBUTION_ID_PREPAY, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, APPLICATION_AMOUNT APPLICATION_AMOUNT, APPLICATION_BASIS APPLICATION_BASIS, UNAPPLY_FLAG UNAPPLY_FLAG, TDS_SECTION_CODE_PREPAY TDS_SECTION_CODE_PREPAY, TDS_SECTION_CODE_OTHER TDS_SECTION_CODE_OTHER, TDS_TAX_ID_PREPAY TDS_TAX_ID_PREPAY, TDS_TAX_ID_OTHER TDS_TAX_ID_OTHER, TDS_APPLICABLE_FLAG TDS_APPLICABLE_FLAG, TDS_APPLICATION_AMOUNT TDS_APPLICATION_AMOUNT, TDS_THRESHOLD_TRX_ID_APPLY TDS_THRESHOLD_TRX_ID_APPLY, TDS_THRESHOLD_TRX_ID_UNAPPLY TDS_THRESHOLD_TRX_ID_UNAPPLY, TDS_THRESHOLD_GRP_ID TDS_THRESHOLD_GRP_ID, WCT_TAX_ID_PREPAY WCT_TAX_ID_PREPAY, WCT_TAX_ID_OTHER WCT_TAX_ID_OTHER, WCT_APPLICABLE_FLAG WCT_APPLICABLE_FLAG, WCT_APPLICATION_AMOUNT WCT_APPLICATION_AMOUNT, WCT_THRESHOLD_TRX_ID_APPLY WCT_THRESHOLD_TRX_ID_APPLY, WCT_THRESHOLD_TRX_ID_UNAPPLY WCT_THRESHOLD_TRX_ID_UNAPPLY, ESSI_TAX_ID_PREPAY ESSI_TAX_ID_PREPAY, ESSI_TAX_ID_OTHER ESSI_TAX_ID_OTHER, ESSI_APPLICABLE_FLAG ESSI_APPLICABLE_FLAG, ESSI_APPLICATION_AMOUNT ESSI_APPLICATION_AMOUNT, ESSI_THRESHOLD_TRX_ID_APPLY ESSI_THRESHOLD_TRX_ID_APPLY, ESSI_THRESHOLD_TRX_ID_UNAPPLY ESSI_THRESHOLD_TRX_ID_UNAPPLY, 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, CALC_ESSI_APPLN_AMT CALC_ESSI_APPLN_AMT, CALC_TDS_APPLN_AMT CALC_TDS_APPLN_AMT, CALC_WCT_APPLN_AMT CALC_WCT_APPLN_AMT from "JA"."JAI_AP_TDS_PREPAYMENTS"

View Text - HTML Formatted

SELECT TDS_PREPAYMENT_ID TDS_PREPAYMENT_ID
, INVOICE_ID INVOICE_ID
, INVOICE_DISTRIBUTION_ID_PREPAY INVOICE_DISTRIBUTION_ID_PREPAY
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, APPLICATION_AMOUNT APPLICATION_AMOUNT
, APPLICATION_BASIS APPLICATION_BASIS
, UNAPPLY_FLAG UNAPPLY_FLAG
, TDS_SECTION_CODE_PREPAY TDS_SECTION_CODE_PREPAY
, TDS_SECTION_CODE_OTHER TDS_SECTION_CODE_OTHER
, TDS_TAX_ID_PREPAY TDS_TAX_ID_PREPAY
, TDS_TAX_ID_OTHER TDS_TAX_ID_OTHER
, TDS_APPLICABLE_FLAG TDS_APPLICABLE_FLAG
, TDS_APPLICATION_AMOUNT TDS_APPLICATION_AMOUNT
, TDS_THRESHOLD_TRX_ID_APPLY TDS_THRESHOLD_TRX_ID_APPLY
, TDS_THRESHOLD_TRX_ID_UNAPPLY TDS_THRESHOLD_TRX_ID_UNAPPLY
, TDS_THRESHOLD_GRP_ID TDS_THRESHOLD_GRP_ID
, WCT_TAX_ID_PREPAY WCT_TAX_ID_PREPAY
, WCT_TAX_ID_OTHER WCT_TAX_ID_OTHER
, WCT_APPLICABLE_FLAG WCT_APPLICABLE_FLAG
, WCT_APPLICATION_AMOUNT WCT_APPLICATION_AMOUNT
, WCT_THRESHOLD_TRX_ID_APPLY WCT_THRESHOLD_TRX_ID_APPLY
, WCT_THRESHOLD_TRX_ID_UNAPPLY WCT_THRESHOLD_TRX_ID_UNAPPLY
, ESSI_TAX_ID_PREPAY ESSI_TAX_ID_PREPAY
, ESSI_TAX_ID_OTHER ESSI_TAX_ID_OTHER
, ESSI_APPLICABLE_FLAG ESSI_APPLICABLE_FLAG
, ESSI_APPLICATION_AMOUNT ESSI_APPLICATION_AMOUNT
, ESSI_THRESHOLD_TRX_ID_APPLY ESSI_THRESHOLD_TRX_ID_APPLY
, ESSI_THRESHOLD_TRX_ID_UNAPPLY ESSI_THRESHOLD_TRX_ID_UNAPPLY
, 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
, CALC_ESSI_APPLN_AMT CALC_ESSI_APPLN_AMT
, CALC_TDS_APPLN_AMT CALC_TDS_APPLN_AMT
, CALC_WCT_APPLN_AMT CALC_WCT_APPLN_AMT
FROM "JA"."JAI_AP_TDS_PREPAYMENTS"