AP TDS Details Report
Description
Categories: Custom Reports HDFC
TDS (Tax Deducted at Source) invoice details for India Form 17, joining the HDFC TDS detail table to AP Invoices for the supplier attribute / supplier tax invoice number columns.
The TDS detail table HDFC.XXHDFC_AP_TDS_DETAILS_TBL is not queried directly from your transactional tables. It is first populated for the entered Tax Invoice Due Date by the HDFC_TDS_DETAILS concurrent program (XXH ... more
The TDS detail table HDFC.XXHDFC_AP_TDS_DETAILS_TBL is not queried directly from your transactional tables. It is first populated for the entered Tax Invoice Due Date by the HDFC_TDS_DETAILS concurrent program (XXH ... more
select xatdt.crs_number, xatdt.invoice_id, xatdt.invoice_num, xatdt.invoice_description, xatdt.invoice_date, xatdt.vendor_code, xatdt.vendor_name, xatdt.vendor_site_code, xatdt.vendor_site_id, xatdt.address_line1, xatdt.address_line2, xatdt.address_line3, xatdt.city, xatdt.state, xatdt.zip, xatdt.vendor_pan_no, xatdt.invoice_amount, xatdt.gl_date, xatdt.tax_id, xatdt.tax_name, xatdt.tax_rate, xatdt.basic_tax_rate, xatdt.surcharge_rate, xatdt.cess_rate, xatdt.section_code, xatdt.basic_tax_amount, xatdt.surcharge_amount, xatdt.cess_amount, xatdt.tax_amount, xatdt.gl_ac_number, xatdt.gl_ac_desc, xatdt.tax_invoice_date, xatdt.tax_invoice_due_date, xatdt.tax_authority_vendor_code, xatdt.tax_authority_name, xatdt.tax_authority_site_name, xatdt.tax_vendorsite_id, xatdt.payment_date, xatdt.check_id, xatdt.check_deposit_date, xatdt.deposit_bank_name, xatdt.challan_number, xatdt.payquick_check_number, xatdt.tds_account, xatdt.tds_acct_desc, xatdt.paid, xatdt.tax_invoice_gl_date, decode(aia.attribute_category,'Petty Cash',aia.attribute2,'HR Details',aia.attribute7,'Courier Details',aia.attribute7,'India VAT',aia.attribute7,aia.attribute5) additional_detail, aia.supplier_tax_invoice_number, aia.attribute1, aia.global_attribute15, xatdt.paygroup, xatdt.tax_cat_name, sum(xatdt.pv_number) pv_number, sum(xatdt.tax_cat_id) tax_cat_id from hdfc.xxhdfc_ap_tds_details_tbl xatdt, ap_invoices_all aia where xatdt.invoice_id=aia.invoice_id and :p_tax_inv_due_date=:p_tax_inv_due_date group by xatdt.crs_number, xatdt.invoice_id, xatdt.invoice_num, xatdt.invoice_description, xatdt.invoice_date, xatdt.vendor_code, xatdt.vendor_name, xatdt.vendor_site_code, xatdt.vendor_site_id, xatdt.address_line1, xatdt.address_line2, xatdt.address_line3, xatdt.city, xatdt.state, xatdt.zip, xatdt.vendor_pan_no, xatdt.invoice_amount, xatdt.gl_date, xatdt.tax_id, xatdt.tax_name, xatdt.tax_rate, xatdt.basic_tax_rate, xatdt.surcharge_rate, xatdt.cess_rate, xatdt.section_code, xatdt.basic_tax_amount, xatdt.surcharge_amount, xatdt.cess_amount, xatdt.tax_amount, xatdt.gl_ac_number, xatdt.gl_ac_desc, xatdt.tax_invoice_date, xatdt.tax_invoice_due_date, xatdt.tax_authority_vendor_code, xatdt.tax_authority_name, xatdt.tax_authority_site_name, xatdt.tax_vendorsite_id, xatdt.payment_date, xatdt.check_id, xatdt.check_deposit_date, xatdt.deposit_bank_name, xatdt.challan_number, xatdt.payquick_check_number, xatdt.tds_account, xatdt.tds_acct_desc, xatdt.paid, xatdt.tax_invoice_gl_date, decode(aia.attribute_category,'Petty Cash',aia.attribute2,'HR Details',aia.attribute7,'Courier Details',aia.attribute7,'India VAT',aia.attribute7,aia.attribute5), aia.supplier_tax_invoice_number, aia.attribute1, aia.global_attribute15, xatdt.paygroup, xatdt.tax_cat_name |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Tax Invoice Due Date | Date |