TaxTMI 
TaxTMI 
Data Structure
X X X X Extracts X X X X
X X X X Extracts X X X X
....ns (In Rs.) (Code 01) Y DECIMAL (25,0) Value should match with total field of schedule A(9) File Detail 10. Total Value of taxable Securities transactions (In Rs.) (Code 02) Y DECIMAL (25,0) Value should match with total field of schedule A(10) File Detail 11. Total Value of taxable Securities transactions (In Rs.) (Code 03) Y DECIMAL (25,0) Value should match with total field of schedule A(11) File Detail 12. Total Securities Transaction tax collectible (In Rs.) (Code 01) Y DECIMAL (25,0) Value should match with total field of schedule A(12) File Detail 13. Total Securities Transaction tax collectible (In Rs.) (Code 02) Y DECIMAL (25,0) Value should match with total field of schedule A(13) File Detail 14. Total Securities Transaction tax collectible (In Rs.) (Code 03) Y DECIMAL (25,0) Value should match with total field of schedule A(14) File Detail 15. Total Number of Transaction Details Records Y DECIMAL (15,0) S.2 Form-1 Schedule-A File Detail (SE_FORM1_SCH_A_FD.TXT) This file contains file details of Securities Transaction Tax - Form 1 (Schedule-A) S.No. Field Name Mandatory Format Remarks 1. Record type Y VARCHAR (2) Type of Record-....
X X X X Extracts X X X X
X X X X Extracts X X X X
....il (FD) 2. S.No. Y DECIMAL (13,0) 3. Clearing Member Code N VARCHAR (15) 4. Stock Broker Code Y VARCHAR (15) 5. Trading Client Code Y VARCHAR (15) 6. Client Name N VARCHAR (250) 7. PAN of Client N VARCHAR (10) 8. MAPIN of Client N DECIMAL (9,0) 9. Value of taxable Securities transactions (In Rs.) (Code 04) Y DECIMAL (25,0) 10. Value of taxable Securities transactions (In Rs.) (Code 05) Y DECIMAL (25,0) 11. Securities transaction tax Collectible (In Rs.) (Code 04) Y DECIMAL (20,0) 12. Securities transaction tax Collectible (In Rs.) (Code 05) Y DECIMAL (20,0) S.5 Form-1 Schedule-C File Header (SE_FORM1_SCH_C_FH.TXT) This file contains file header and other details of Securities Transaction Tax - Form 1 (Schedule-C) S.No. Field Name Mandatory Format Remarks 1. Record Type Y VARCHAR (2) Type of Record- File Header (FH) 2. File Type Y VARCHAR (6) Type of File- STTSEC 3. Name of the Stock Exchange Y VARCHAR (75) 4. Address of the Stock Exchange Y VARCHAR (120) 5. City of the Stock Exchange Y VARCHAR (30) 6. Pin code Y DECIMAL (6,0) Pin code of Address 7. PAN of the Stock Exchange Y VARCHAR (10) 8. Fin....
X X X X Extracts X X X X
X X X X Extracts X X X X
.... Type # Code Description 1. FH File Header 2. FD File Detail Form No. 2 (Return of Taxable Securities Transactions) For Mutual Funds MF.1 Form-2 Schedule-A File Header (MF_FORM2_SCH_A_FH.TXT) This file contains file header and other details of Securities Transaction Tax - Form 2 (Schedule-A) S.No. Field Name Mandatory Type Remarks 1. Record Type Y VARCHAR (2) Type of Record- File Header (FH) 2. File Type Y VARCHAR (6) Type of File- STTMFA 3. Name of the Mutual Fund Y VARCHAR (75) 4. Date of registration of trust Deed for Mutual Fund under the Indian Registration Act .1908 Y DATE DD/MM/YYYY 5. Name of asset management company for fund Y VARCHAR (75) 6. Address of asset management company for fund Y VARCHAR (120) 7. City of the asset management company for fund Y VARCHAR (30) 8. Pin Code asset management company for fund Y VARCHAR (6) 9. PAN of the asset management company for fund Y VARCHAR (10) 10. Financial Year Y VARCHAR (6) YYYY-YY 11. Number of equity-oriented funds Y VARCHAR (13) 12. Total Number of Transaction Detail Records Y DECIMAL (13,0) MF.2 Form-2 Schedule-A File Detail (MF_FORM2_SCH_A_FD.TXT) Thi....
X X X X Extracts X X X X
X X X X Extracts X X X X
.... Y DECIMAL (13,0) 11. Securities transaction tax collected (In Rs.) Y DECIMAL (13,0) MF.5 Form-2 Schedule-C File Header (MF_FORM2_SCH_C_FH.TXT) This file contains file header and other details of Securities Transaction Tax - Form 2 (Schedule-C) S.No. Field Name Mandatory Type Remarks 1. Record Type Y VARCHAR (2) Type of Record- File Header (FH) 2. File Type Y VARCHAR (6) STTMFC 3. Name of the Mutual Fund Y VARCHAR (75) 4. Date of registration of trust Deed for Mutual Fund under the Indian Registration Act .1908 Y DATE DD/MM/YYYY 5. Name of asset management company for fund Y VARCHAR (75) 6. Address of asset management company for fund Y VARCHAR (120) 7. City of the asset management company for fund Y VARCHAR (30) 8. Pin Code asset management company for fund Y VARCHAR (6) 9. PAN of the asset management company for fund Y VARCHAR (10) 10. Financial Year Y VARCHAR (6) YYYY-YY 11. Number of equity-oriented funds Y VARCHAR (13) 12. Total value of taxable securities transactions during the month (In Rs.) Y DECIMAL (20,0) 13. Total securities transaction tax collectible (In Rs.) Y DECIMAL (20,0) Value should match with....
X X X X Extracts X X X X
X X X X Extracts X X X X
....ecurities Transaction Tax - Form 2A (Row 14) Sl. No. Field Name Mandatory Type Remarks 1. Record Type Y VARCHAR (2) Type of Record- File Header (FH) 2. File Type Y VARCHAR (6) Type of File- STTIN14 3. Name of the Insurance Company Y VARCHAR (75) 4. Date of Registration/ Incorporation under the Companies Act, 2013 Y DATE DD/MM/YYYY 5. Permanent Account Number (PAN) Y VARCHAR (10) 6. Financial Year Y VARCHAR (6) YYYY-YY 7. Jurisdictional Assessing Officer Y VARCHAR (10) 8. Number of equity-oriented funds Y VARCHAR (13) 9. Total Value of taxable securities transactions Y DECIMAL (20,0) Value should match with total field of Row 14 (8) File Detail 10. Total securities transaction tax collectible Y DECIMAL (20,0) Value should match with total field of Row 14 (9) File Detail 11. Total securities transaction tax collected Y DECIMAL (20,0) Value should match with total field of Row 14 (10) File Detail 12. Total Number of Transaction Detail Records Y DECIMAL (13,0) IN.2 Form-2A Row 14 File Detail (IN_FORM2A_ROW14_FD.TXT) This file contains file details of Securities Transaction Tax - Form 2A (ROW 14) Details of Equity Oriented F....