VIEW: JA.JAI_AP_ETDS_T#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, CHALLAN_LINE_NUM CHALLAN_LINE_NUM, DEDUCTEE_LINE_NUM DEDUCTEE_LINE_NUM, BASE_INVOICE_ID BASE_INVOICE_ID, TDS_INVOICE_ID TDS_INVOICE_ID, TDS_INVOICE_NUM TDS_INVOICE_NUM, TDS_INVOICE_DATE TDS_INVOICE_DATE, TDS_SECTION TDS_SECTION, BASE_TAXABALE_AMOUNT BASE_TAXABALE_AMOUNT, TDS_TAX_ID TDS_TAX_ID, TDS_TAX_RATE TDS_TAX_RATE, TDS_AMOUNT TDS_AMOUNT, TDS_CHECK_ID TDS_CHECK_ID, CHALLAN_NUM CHALLAN_NUM, CHALLAN_DATE CHALLAN_DATE, BANK_BRANCH_CODE BANK_BRANCH_CODE, BASE_INVOICE_TYPE_LOOKUP_CODE BASE_INVOICE_TYPE_LOOKUP_CODE, PREPAYMENT_AMOUNT_APPLIED PREPAYMENT_AMOUNT_APPLIED, BASE_VENDOR_ID BASE_VENDOR_ID, BASE_VENDOR_SITE_ID BASE_VENDOR_SITE_ID, BASE_INVOICE_CHECK_ID BASE_INVOICE_CHECK_ID, CONSIDER_FOR_CHALLAN CONSIDER_FOR_CHALLAN, CONSIDER_FOR_DEDUCTEE CONSIDER_FOR_DEDUCTEE, CHALLAN_ERROR CHALLAN_ERROR, DEDUCTEE_ERROR DEDUCTEE_ERROR, 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, AMT_OF_TDS AMT_OF_TDS, AMT_OF_SURCHARGE AMT_OF_SURCHARGE, AMT_OF_CESS AMT_OF_CESS, BASE_INVOICE_DATE BASE_INVOICE_DATE, CERTIFICATE_ISSUE_DATE CERTIFICATE_ISSUE_DATE, TDS_CHECK_DATE TDS_CHECK_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CHECK_NUMBER CHECK_NUMBER, TDS_VENDOR_CLASSIFICATION TDS_VENDOR_CLASSIFICATION from "JA"."JAI_AP_ETDS_T"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, CHALLAN_LINE_NUM CHALLAN_LINE_NUM
, DEDUCTEE_LINE_NUM DEDUCTEE_LINE_NUM
, BASE_INVOICE_ID BASE_INVOICE_ID
, TDS_INVOICE_ID TDS_INVOICE_ID
, TDS_INVOICE_NUM TDS_INVOICE_NUM
, TDS_INVOICE_DATE TDS_INVOICE_DATE
, TDS_SECTION TDS_SECTION
, BASE_TAXABALE_AMOUNT BASE_TAXABALE_AMOUNT
, TDS_TAX_ID TDS_TAX_ID
, TDS_TAX_RATE TDS_TAX_RATE
, TDS_AMOUNT TDS_AMOUNT
, TDS_CHECK_ID TDS_CHECK_ID
, CHALLAN_NUM CHALLAN_NUM
, CHALLAN_DATE CHALLAN_DATE
, BANK_BRANCH_CODE BANK_BRANCH_CODE
, BASE_INVOICE_TYPE_LOOKUP_CODE BASE_INVOICE_TYPE_LOOKUP_CODE
, PREPAYMENT_AMOUNT_APPLIED PREPAYMENT_AMOUNT_APPLIED
, BASE_VENDOR_ID BASE_VENDOR_ID
, BASE_VENDOR_SITE_ID BASE_VENDOR_SITE_ID
, BASE_INVOICE_CHECK_ID BASE_INVOICE_CHECK_ID
, CONSIDER_FOR_CHALLAN CONSIDER_FOR_CHALLAN
, CONSIDER_FOR_DEDUCTEE CONSIDER_FOR_DEDUCTEE
, CHALLAN_ERROR CHALLAN_ERROR
, DEDUCTEE_ERROR DEDUCTEE_ERROR
, 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
, AMT_OF_TDS AMT_OF_TDS
, AMT_OF_SURCHARGE AMT_OF_SURCHARGE
, AMT_OF_CESS AMT_OF_CESS
, BASE_INVOICE_DATE BASE_INVOICE_DATE
, CERTIFICATE_ISSUE_DATE CERTIFICATE_ISSUE_DATE
, TDS_CHECK_DATE TDS_CHECK_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CHECK_NUMBER CHECK_NUMBER
, TDS_VENDOR_CLASSIFICATION TDS_VENDOR_CLASSIFICATION
FROM "JA"."JAI_AP_ETDS_T"