SAP ABAP Table FIWTIN_QEFILE (Quarterly returns e-file)

Hierarchy

☛

SAP_FIN (Software Component) SAP_FIN
⤷

FI-LOC (Application Component) Localization
⤷

J1ICIN30A (Package) Development class for cin30a

Basic Data

Table Category	INTTAB	Structure
Structure	FIWTIN_QEFILE	Table Relationship Diagram
Short Description	Quarterly returns e-file

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description
1	FIWTIN_QHEADER	FIWTIN_QHEADER		STRU	0	0
2	.INCLUDE				0	0	Structure to store header details
3	RECTYPE	FIWTIN_RECTYPE		CHAR	2	0	Record Type
4	FILETYPE	FIWTIN_FILETYPE		CHAR	4	0	File Type
5	UPLDTYPE	FIWTIN_UPLDTYPE		CHAR	2	0	Upload Type
6	FCDATE	FIWTIN_FCDATE	DATUM	DATS	8	0	File creation date
7	FSEQNUMBER	FIWTIN_FSEQNUMBER		NUMC	9	0	File sequence number
8	UPLRTYPE	FIWTIN_UPLDRTYPE		CHAR	1	0	Uploader type
9	DEDTAN	FIWTIN_TANNO		CHAR	10	0	Tan Number
10	NOBATCHES	FIWTIN_NOBATCHES		NUMC	9	0	Total number of batches
11	UTILNAME	FIWTIN_UTILNAME		CHAR	75	0	Name of Return Preparation Utility
12	.INCLUDE				0	0	Structure to hold batch header details
13	BRECTYP	FIWTIN_RECTYPE		CHAR	2	0	Record Type
14	BATCHNO	FIWTIN_BATCHNUM		NUMC	9	0	Batch number
15	CHALLANCNT	FIWTIN_CHLNCNT		NUMC	9	0	Challan Count
16	FORMNO	FIWTIN_FORMNO	FIWTIN_FORMNO	CHAR	4	0	Form Number
17	PRERRRNO	FIWTIN_PRERRNO	FIWTIN_PRERRNO	CHAR	15	0	Previous Statement Token Number
18	TANNO	FIWTIN_TANNO		CHAR	10	0	Tan Number
19	RECEIPTNO	FIWTIN_RECEIPT		CHAR	8	0	Receipt Number
20	PANNO	FIWTIN_PANNO		CHAR	10	0	PAN Number
21	ASSESMENTYEAR	FIWTIN_ASYEAR		NUMC	6	0	Assesment year
22	FISCALYEAR	FIWTIN_YEAR		NUMC	6	0	Fiscal Year
23	PERIOD	FIWTIN_PERIOD		CHAR	2	0	Reporting Period
24	DEDU_NAME	FIWTIN_NAME		CHAR	75	0	Name
25	DEDU_BRANCH	FIWTIN_BRANCH		CHAR	75	0	Deductor Branch
26	DEDU_ADDR1	FIWTIN_ADDRESS		CHAR	25	0	Address
27	DEDU_ADDR2	FIWTIN_ADDRESS		CHAR	25	0	Address
28	DEDU_ADDR3	FIWTIN_ADDRESS		CHAR	25	0	Address
29	DEDU_ADDR4	FIWTIN_ADDRESS		CHAR	25	0	Address
30	DEDU_ADDR5	FIWTIN_ADDRESS		CHAR	25	0	Address
31	DEDU_STATE	FIWTIN_STATE		NUMC	2	0	State
32	DEDU_PINCODE	FIWTIN_PIN		NUMC	6	0	PIN Code
33	DEDU_MAILID	FIWTIN_MAIL		CHAR	75	0	Mail ID
34	DEDU_STD	FIWTIN_STD		CHAR	6	0	STD Code
35	DEDU_TELNO	FIWTIN_TEL		NUMC	10	0	Telephone Number
36	DEDU_ADDRCHANGE	FIWTIN_ADRCHNG		CHAR	1	0	Address change
37	DEDU_TYPE	FIWTIN_DEDTYPE		CHAR	1	0	Deductor Type
38	RESP_NAME	FIWTIN_NAME		CHAR	75	0	Name
39	RESP_DESIG	FIWTIN_DESIG		CHAR	20	0	Designation
40	RESP_ADDR1	FIWTIN_ADDRESS		CHAR	25	0	Address
41	RESP_ADDR2	FIWTIN_ADDRESS		CHAR	25	0	Address
42	RESP_ADDR3	FIWTIN_ADDRESS		CHAR	25	0	Address
43	RESP_ADDR4	FIWTIN_ADDRESS		CHAR	25	0	Address
44	RESP_ADDR5	FIWTIN_ADDRESS		CHAR	25	0	Address
45	RESP_STATE	FIWTIN_STATE		NUMC	2	0	State
46	RESP_PINCODE	FIWTIN_PIN		NUMC	6	0	PIN Code
47	RESP_EMAILID	FIWTIN_MAIL		CHAR	75	0	Mail ID
48	RESP_MOBILE	FIWTIN_MOBILE		CHAR	10	0	Mobile Number
49	RESP_STD	FIWTIN_STD		CHAR	6	0	STD Code
50	RESP_TELNO	FIWTIN_TEL		NUMC	10	0	Telephone Number
51	RESP_ADDRCHANGE	FIWTIN_ADRCHNG		CHAR	1	0	Address change
52	TOTDEPAMT	FIWTIN_TOTDEPAMT		CURR	15	2	Total Deposit Amount
53	CHALLAN_UNMATCH	FIWTIN_CHLNUNMAT		CHAR	9	0	Challan Unmatched
54	AOAPPROVAL	FIWTIN_APPROVAL		CHAR	1	0	AO Approval
55	AOAPPROVALNO	FIWTIN_APPRNO		CHAR	15	0	Approval Number
56	LASTDEDTYPE	FIWTIN_LASTDEDTYPE	FIWTIN_LASTDEDTYPE	CHAR	1	0	Last Deductor Type
57	STATE	FIWTIN_STATECODE		CHAR	2	0	State
58	PAOCODE	FIWTIN_PAOCODE		CHAR	20	0	PAO Code
59	DDOCODE	FIWTIN_DDOCODE		CHAR	20	0	DDO Code
60	MINISTRY	FIWTIN_MINISTRY		CHAR	3	0	Ministry Code
61	MINISTRYNAME	FIWTIN_MINNAME		CHAR	150	0	Ministry Name
62	PAOREGNO	FIWTIN_PAONO		CHAR	7	0	PAO Registration Number
63	DDOREGNO	FIWTIN_DDONO		CHAR	10	0	DDO Registration Number
64	ALT_DEDU_STD	FIWTIN_STD		CHAR	6	0	STD Code
65	ALT_DEDU_TELNO	FIWTIN_TEL		NUMC	10	0	Telephone Number
66	ALT_DEDU_EMAILID	FIWTIN_MAIL		CHAR	75	0	Mail ID
67	ALT_RESP_STD	FIWTIN_STD		CHAR	6	0	STD Code
68	ALT_RESP_TELNO	FIWTIN_TEL		NUMC	10	0	Telephone Number
69	ALT_RESP_EMAILID	FIWTIN_MAIL		CHAR	75	0	Mail ID
70	AIN	FIWTIN_AIN		CHAR	7	0	Account Office Identification Number
71	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key
72	FIWTIN_QCHALLAN	FIWTIN_QCHALLAN		STRU	0	0
73	RECTYPE	FIWTIN_RECTYPE		CHAR	2	0	Record Type
74	BATCHNO	FIWTIN_BATCHNUM		NUMC	9	0	Batch number
75	RECNUM	FIWTIN_RECNUM		NUMC	9	0	Challan Record Number
76	CNTDEDREC	FIWTIN_CNTDEDREC		NUMC	9	0	Deductee / Party Detail Record Number
77	CHLIND	FIWTIN_CHLIND		CHAR	1	0	NIL Challan Indicator
78	BNKCHLNNO	FIWTIN_BNKCHLNNO		CHAR	5	0	Bank Challan Number
79	TRNSVOUCHNUM	FIWTIN_TRNSVOUCHNUM		NUMC	9	0	Transfer Voucher Number
80	BNKBRCHCD	FIWTIN_BNKBRCHCD		NUMC	7	0	Bank-Branch Code/ Form 24G Receipt Number
81	CHLNDT	FIWTIN_CHLNDT	DATUM	DATS	8	0	Bank Challan Number/Transfer Voucher Number Date
82	SECTIONCD	FIWTIN_SECTION		CHAR	3	0	Section Code
83	OLTASTDS	FIWTIN_OLTASTDS		CURR	15	2	Oltas TDS /TCS -Income Tax
84	OLTASURC	FIWTIN_OLTASURC		CURR	15	2	Oltas TDS /TCS-Surcharge
85	OLTASCESS	FIWTIN_OLTASCESS		CURR	15	2	Oltas TDS / TCS - Cess
86	OLTASINT	FIWTIN_OLTASINT		CURR	15	2	Oltas TDS /TCS -Interest Amount
87	OLTASOTH	FIWTIN_OLTASOTH		CURR	15	2	Oltas TDS / TCS - Others (amount)
88	TOTDEPAMT	FIWTIN_TOTDEPAMT		CURR	15	2	Total Deposit Amount
89	TOTTAXDEP	FIWTIN_TOTTAXDEP		CURR	15	2	Total Tax Deposit Amount
90	SUMINCTAX	FIWTIN_SUMINCTAX		CURR	15	2	TDS / TCS -Income Tax
91	SUMSURC	FIWTIN_SUMSURC		CURR	15	2	TDS / TCS -Surcharge
92	SUMCESS	FIWTIN_SUMCESS		CURR	15	2	TDS / TCS - Cess
93	AMTDED	FIWTIN_AMTDED		CURR	15	2	Sum of Total Income Tax Deducted at Source
94	AMTINT	FIWTIN_AMTINT		CURR	15	2	TDS / TCS - Interest Amount
95	AMTOTH	FIWTIN_AMTOTH		CURR	15	2	TDS / TCS - Others (amount)
96	CHEQUENO	FIWTIN_CHEQUENO		NUMC	15	0	Cheque/DD Number
97	BOOKENTRY	FIWTIN_BOOKENTRY		CHAR	1	0	By Book entry / Cash
98	REMARKS	FIWTIN_REMARKS		CHAR	14	0	Remarks
99	FEE	FIWTIN_FEE		CURR	15	2	Fee paid under section 234E
100	MINORCHALLAN	FIWTIN_MINORCHALLAN		CHAR	3	0	Minor head of Challan
101	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key
102	FIWTIN_QDED_DET	FIWTIN_QDED_DET		STRU	0	0
103	RECTYPE	FIWTIN_RECTYPE		CHAR	2	0	Record Type
104	BATCHNO	FIWTIN_BATCHNUM		NUMC	9	0	Batch number
105	RECNUM	FIWTIN_RECNUM		NUMC	9	0	Challan Record Number
106	DEDRECNUM	FIWTIN_CNTDEDREC		NUMC	9	0	Deductee / Party Detail Record Number
107	MOD	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
108	DEDCODE	FIWTIN_DEDCODE		CHAR	1	0	Deductee Code
109	PANNO	FIWTIN_PANNO		CHAR	10	0	PAN Number
110	DEDU_NAME	FIWTIN_NAME		CHAR	75	0	Name
111	TDSAMT	FIWTIN_AMOUNT		CURR	15	2	Amount of Payment / Credit
112	SUMINCTAX	FIWTIN_SUMINCTAX		CURR	15	2	TDS / TCS -Income Tax
113	SUMSURC	FIWTIN_SUMSURC		CURR	15	2	TDS / TCS -Surcharge
114	SUMCESS	FIWTIN_SUMCESS		CURR	15	2	TDS / TCS - Cess
115	AMTDED	FIWTIN_AMTDED		CURR	15	2	Sum of Total Income Tax Deducted at Source
116	TOTTAXDEP	FIWTIN_TOTTAXDEP		CURR	15	2	Total Tax Deposit Amount
117	TOTPURVALUE	FIWTIN_AMOUNT		CURR	15	2	Amount of Payment / Credit
118	AMOUNT	FIWTIN_AMOUNT		CURR	15	2	Amount of Payment / Credit
119	AMTDATE	FIWTIN_AMTDATE	DATUM	DATS	8	0	Date on which Amount paid /Credited
120	TAXDATE	FIWTIN_TAXDATE	DATUM	DATS	8	0	Date on which tax Deducted / Collected
121	TAXRATE	FIWTIN_TAXRATE		CHAR	7	0	Rate at which Tax Deducted / Collected
122	GROSSUP	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
123	BOOKENTRY	FIWTIN_BOOKENTRY		CHAR	1	0	By Book entry / Cash
124	RSNCODE	FIWTIN_RSNCODE	CHAR1	CHAR	1	0	Reason Code
125	REMARKS	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
126	SECTIONCD	FIWTIN_SECTION		CHAR	3	0	Section Code
127	CERTINO	FIWTIN_CERTINO		CHAR	20	0	Certificate Number
128	TDSRATE	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
129	NATUREREM	FIWTIN_NATUREREM		CHAR	3	0	Nature of remittance
130	UNIQACKN	FIWTIN_UNIQACKN		CHAR	12	0	Unique acknowledgement
131	COUNRTY	FIWTIN_COUNTRY		CHAR	3	0	Country
132	WAERS	WAERS	WAERS	CUKY	5	0	Currency Key