TMI BlogData StructureX X X X Extracts X X X X X X X X Extracts X X X X ..... Y VARCHAR (75) Please provide name of stock exchange 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) PAN Format AAAA1111A 8. Financial Year Y VARCHAR (7) Transaction to be reported for FY YYYY-YY 9. Total Value of taxable Securities transactions (In Rs.) (Code 01) Y DECIMAL (25,0) Value should match with total field of schedule A(9) File Detail ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... Y VARCHAR (15) 6. Client Name N VARCHAR (250) 7. PAN of Client Y VARCHAR (10) 8. Mapin of Client N DECIMAL (9,0) 9. Value of taxable Securities transactions (In Rs.) (Code 01) Y DECIMAL (25,0) 10. Value of taxable Securities transactions (In Rs.) (Code 02) Y DECIMAL (25,0) 11. Value of taxable Securities transactions (In Rs.) (Code 03) Y DECIMAL (25,0) 12. Securities transaction tax Collectible (In Rs.) (Code 01) ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... ode 05) Y DECIMAL (25,0) Value should match with total field of schedule B(10) File Detail 11. Total Securities Transaction tax collectible (In Rs.) (Code 04) Y DECIMAL (25,0) Value should match with total field of schedule B(11) File Detail 12. Total Securities Transaction tax collectible (In Rs.) (Code 05) Y DECIMAL (25,0) Value should match with total field of schedule B(12) File Detail 13. Total Number of Transaction Details Records Y DECIMAL (15,0) S.4 Form-1 Schedule-B File Detail (SE_FORM1_SCH_B_FD.TXT) This file contains file details of Securities Transaction Tax - Form 1 (Schedule-B) S. No. Field Name Mandatory Format Remarks 1. Record ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... 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. Financial Year Y VARCHAR (7) Transaction to be reported for FY YYYY-YY 9. Total Value of taxable Securities transactions during the month Y ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... Value of taxable securities during the month (In Rs.) Y DECIMAL (25,0) 6. Securities transaction tax collectible (In Rs.) Y DECIMAL (20,0) 7. Securities transaction tax collected (In Rs.) Y DECIMAL (20,0) 8. Securities transaction tax paid (In Rs) Y DECIMAL (20,0) 9. Interest payable u/s 104 (In Rs.) Y DECIMAL (20,0) 10. Interest paid u/s 104 (In Rs.) Y DECIMAL (20,0) 11. Particulars of payment of securities transaction tax/interest u/s 104 ( Tax/Interest ) Y DECIMAL (20,0) ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... 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. Financ ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... DD/MM/YYYY 5. City of the asset management company for fund Y VARCHAR (30) 6. Pin Code asset management company for fund Y VARCHAR (6) 7. PAN of the asset management company for fund Y VARCHAR (10) 8. Financial Year Y VARCHAR (6) YYYY-YY 9. Number of equity-oriented funds Y VARCHAR (13) 10. Total value of taxable securities transactions (In Rs.) Y DECIMAL (20,0) Value should match with total field of schedule B(9) File Detail 11. Total securities transaction tax collectible (In Rs.) Y ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... n tax collectible (In Rs.) 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 .1 ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... 17. Total Interest paid u/s 104 (In Rs.) Y DECIMAL (20,0) Value should match with total field of schedule C(11) File Detail 20. Total Number of Transaction Detail Records Y DECIMAL (13,0) MF.6 Form-2 Schedule-C File Detail (MF_FORM2_SCH_C_FD.TXT) This file contains file 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 Detail (FD) 2. S.No. Y DECIMAL (13,0) 3. Month Y DECIMAL (2,0) MM 4. Name ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... es - File Type # Code Description 1. STTMFA Schedule A Data 2. STTMFB Schedule B Data 3. STTMFC Schedule C Data Permissible Values - Record Type # Code Description 1. FH File Header 2. FD File Detail Form No. 2A (Return of Taxable Securities Transactions) For Insurance Company IN.1 Form-2A Row 14 File Header (IN_FORM2A_ROW14_1_FH.TXT) This file contains file header and other details of Securities Transaction Tax - Form 2A (Row 14) Sl. No. Field Name Mandatory Type Remarks 1. Record Type ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... #. Field Name Mandatory Format Remarks 1. Record type Y VARCHAR (2) Type of Record- File Detail (FD) 2. S.No. Y DECIMAL (13,0) 3. Name of equity-oriented fund Y VARCHAR (75) 4. Unique Client Code of the fund Y VARCHAR (15) 5. Folio number of Person from whom units purchased Y VARCHAR (20) 6. Name of person from whom units purchased Y VARCHAR (250) Name of seller 7. PAN of person from whom units purchased Y VARCHAR (10) PAN of seller 8. ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... Total securities transaction tax collected Y DECIMAL (20,0) Value should match with total field of Row 15 (8) File Detail 12. Total securities transaction tax paid Y DECIMAL (20,0) Value should match with total field of Row 15 (9) File Detail 13. Total Interest payable under section 104 Y DECIMAL (20,0) Value should match with total field of Row 15 (10) File Detail 14. Total Interest paid under section 104 Y DECIMAL (20,0) Value should match with total field of Row 15 (11) File Detail IN.3 Form-2A Row 15 File Detail (IN_FORM2A_ROW15_FD.TXT) This file contains file details of Securities Transaction Tax Form No. 2A (Row 15) S.No. Field Name Mandatory Type Remarks 1. Record type Y VARCHAR ..... X X X X Extracts X X X X X X X X Extracts X X X X ..... nt Account Number (PAN) Y VARCHAR (10) 6. Financial Year Y VARCHAR (4) 7. Jurisdictional Assessing Officer Y VARCHAR (10) 8. Number of equity-oriented funds Y VARCHAR (13) IN.6 Form-2A Row 16 File Detail (IN_FORM2A_Row 16_FD.TXT) This file contains file details of Securities Transaction Tax - Form 2A (Row 16) Details of securities transaction tax/interest paid S.No. Field Name Mandatory Type Remarks 1. Record type File Y VARCHAR (2) Type of Record- Detail (FD) 2. Tax/Interest Y DECIMAL (13,0) 3. Name of the bank branch Y DE ..... X X X X Extracts X X X X X X X X Extracts X X X X
|
