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