NAME: India – Program to Generate eTDS Quarterly Certificates 26Q
SHORT CODE: JAINETDSQ
MODULE: Oracle Asia / Pacific Localizations

Description: Generates a flat file as per legal format that contain eTDS Quarterly Certificate data
Navigation: Oracle Asia / Pacific Localizations Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• P_TAN_NUMBER : Tan Number of Organization
• P_FINANCIAL_YEAR : Shows the available financial years
• P_PERIOD : Shows the quarter information
• P_TAX_AUTHORITY_ID : TDS Authorities
• P_TAX_AUTHORITY_SITE_ID : TDS Authority Sites
• P_ORGANIZATION_ID : useful to fetch address details from the location linked to organization
• P_DEDUCTOR_NAME : Enterable field of Deductor Name
• P_DEDUCTOR_STATE : Shows the Indian States and their Codes
• P_ADDR_CHANGED_SINCE_LAST_RET : selected value tells whether the address of deductor is changed since last return
• P_PERS_RESP_FOR_DEDUCTION : Person who is resposible for tds deduction
• P_DESG_OF_PERS_RESPONSIBLE : Designation of the Person Reposible for TDS Deduction
• P_RESP_FLAT_NO : Flat No of the Person Responsible for TDS Deduction
• P_RESP_PREM_BLG : Name of the Premises/Building of the Person Responsible for TDS Deduction
• P_RESP_RD_ST_LANE : Road/Street/Lane

NAME: India – Program to Generate eTDS Certificates
SHORT CODE: JAINETDS
MODULE: Oracle Asia / Pacific Localizations

Description: Generates a flat file as per legal format that contain eTDS Certificate data
Navigation: Oracle Asia / Pacific Localizations Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• P_TAN_NUMBER : Tan Number of Organization
• P_FINANCIAL_YEAR : Shows the available financial years
• P_ORGANIZATION_ID : useful to fetch address details from the location linked to organization
• P_TAX_AUTHORITY_ID : TDS Authorities
• P_TAX_AUTHORITY_SITE_ID : TDS Authority Sites
• P_DEDUCTOR_NAME : Enterable field of Deductor Name
• P_DEDUCTOR_STATE : Shows the Indian States and their Codes
• P_ADDR_CHANGED_SINCE_LAST_RET : selected value tells whether the address of deductor is changed since last return
• P_DEDUCTOR_STATUS : selected value tells whether the deductor belong to Central or Others
• P_PERS_RESP_FOR_DEDUCTION : Person who is resposible for tds deduction
• P_DESG_OF_PERS_RESPONSIBLE : Designation of the Person Reposible for TDS Deduction
• P_CHALLAN_START_DATE : Start Date filter for TDS Invoices
• P_CHALLAN_END_DATE : End Date filter for TDS Invoices
• P_FILE_PATH : UTL_FILE directory of

NAME: India – Program to Generate eTCS Yearly Returns
SHORT CODE: JAINETCSY
MODULE: Oracle Asia / Pacific Localizations

Description: Generates a flat file as per legal format that contain eTCS Yearly Returns data
Navigation: Oracle Asia / Pacific Localizations Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• P_TAN_NUMBER : Tan Number of Organization
• P_ORGANIZATION_ID : Organization Id
• P_FINANCIAL_YEAR : Shows the available financial years
• P_COLLECTION_CODE : Collection Code
• P_TAX_AUTHORITY_ID : TCS Authorities
• P_TAX_AUTHORITY_SITE_ID : TCS Authority Sites
• P_SELLER_NAME : Enterable field of Deductor Name
• P_SELLER_STATE : Shows the Indian States and their Codes
• P_ADDR_CHANGED_SINCE_LAST_RET : selected value tells whether the address of deductor is changed since last return
• P_PERSRESPFORCOLLECTION : Person who is resposible for tcs collection
• P_DESGOFPERSRESPONSIBLE : Designation of the Person Reposible for TCS Collection
• P_START_DATE : Start Date filter for TCS Invoices
• P_END_DATE : End Date filter for TCS Invoices
• P_PRO_RCPT_NUM_ORG_RET : Provisional Receipt Number for corrected return
• P_FILE_PATH : UTL_FILE directory of Database
• P_FILENAME : Filename in which t