VIEW: JA.JAI_AP_TDS_INVOICES#

Source

View Text - Preformatted

select INVOICE_ID INVOICE_ID, INVOICE_AMOUNT INVOICE_AMOUNT, DM_INVOICE_NUM DM_INVOICE_NUM, TDS_INVOICE_NUM TDS_INVOICE_NUM, TDS_TAX_ID TDS_TAX_ID, TDS_SECTION TDS_SECTION, TDS_TAX_RATE TDS_TAX_RATE, TDS_AMOUNT TDS_AMOUNT, AMT_REVERSED AMT_REVERSED, AMT_APPLIED AMT_APPLIED, ORGANIZATION_ID ORGANIZATION_ID, CERTIFICATE_NUMBER CERTIFICATE_NUMBER, SOURCE_ATTRIBUTE SOURCE_ATTRIBUTE, TDS_INVOICE_ID TDS_INVOICE_ID, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AMT_OF_SH_CESS AMT_OF_SH_CESS, TAX_CATEGORY_ID TAX_CATEGORY_ID from "JA"."JAI_AP_TDS_INVOICES"

View Text - HTML Formatted

SELECT INVOICE_ID INVOICE_ID
, INVOICE_AMOUNT INVOICE_AMOUNT
, DM_INVOICE_NUM DM_INVOICE_NUM
, TDS_INVOICE_NUM TDS_INVOICE_NUM
, TDS_TAX_ID TDS_TAX_ID
, TDS_SECTION TDS_SECTION
, TDS_TAX_RATE TDS_TAX_RATE
, TDS_AMOUNT TDS_AMOUNT
, AMT_REVERSED AMT_REVERSED
, AMT_APPLIED AMT_APPLIED
, ORGANIZATION_ID ORGANIZATION_ID
, CERTIFICATE_NUMBER CERTIFICATE_NUMBER
, SOURCE_ATTRIBUTE SOURCE_ATTRIBUTE
, TDS_INVOICE_ID TDS_INVOICE_ID
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AMT_OF_SH_CESS AMT_OF_SH_CESS
, TAX_CATEGORY_ID TAX_CATEGORY_ID
FROM "JA"."JAI_AP_TDS_INVOICES"