NAME: India – ER1 Report
SHORT CODE: JAINER1
MODULE: Oracle Asia / Pacific Localizations

Description: India ER1 Report
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_ORGANIZATION_ID : Organization Name
• P_LOCATION_ID : Location
• P_START_DATE : Start Date
• P_END_DATE : End Date
• P_REGISTRATION_NUMBER : Primary Registration Number
• P_OPERATING_UNIT : Operating Unit
• P_ASSESSEE_NAME : Name of the Assessee
• P_CITY : Name of the City
• P_GROUP_BY : Group by Item or Item Tariff

NAME: India – Generate Flat File for ER1
SHORT CODE: JAINEER1
MODULE: Oracle Asia / Pacific Localizations

Description: India – Generate Flat File for ER1
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_ORGANIZATION_ID : Organization Id
• P_LOCATION_ID : P_LOCATION_ID
• P_START_DATE :
• P_END_DATE :
• P_REGISTRATION_NUMBER : Registration Number
• P_OPERATING_UNIT :
• P_AUTH_SIGN : Name of the Authorized Signatory
• P_PLACE : Place
• P_FILE_PATH : File Path where the e-ER1 file is stored
• P_FILENAME : File Name
• P_ACTION : Generate Headers (Y/N)

NAME: India – Program to Generate eTDS Quarterly Certificates 27Q
SHORT CODE: JAINE27Q
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/Lan