	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

261 COLUMNS | 1 INDEXES | ERP 6.0 | T5ITT7 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Italy
1	ERP EHP7	6.0	T5ITT7	261	1	Data settlement according to 730	Italy

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, MO730, ENDDA, BEGDA, WTNPA, WTRIR, WTRCS, WTRAD, WTRAC, WTRCD, WTRCC, INTER, INTRE, RATA1, WT1RT, WT1DF, WT1IN, WT1II, RATA2, WT2RT, WT2IN, MFRA1, MFRA2, WTTIR, WTIDF, WTIIN, WTIII, WTTCS, WTCDF, WTICS, WTTRC, WTCRC, WTIRC, WTDRC, WTTRD, WTCRD, WTIRD, WTDRD, WTTAC, WTADF, WTIAC, WTDAC, WTTAD, WTADD, WTIAD, WTDDD, WTTCC, WTCCC, WTICC, WTDCC, WTTCD, WTCCD, WTICD, WTDCD, WT1RD, WT1RC, WT2RD, WT2RC, W1DFD, W1DFC, W1IID, W1IIC, W1IND, W1INC, W2IND, W2INC, WTNP2, W2DFD, W2DFC, WSRIR, WSRAD, WSRCD, WSRAC, WSRCC, WS1RD, WSIND, WSIID, WS1RC, WSINC, WSIIC, WS2RD, WS2ND, WS2RC, WS2NC, WSTIR, WSII1, WSIII, WSTRD, WSXRD, WSDRD, WSTRC, WSXRC, WSDRC, WSTCD, WSXCD, WSDCD, WSXCC, WSTCC, WSDCC, WSTAD, WSXAD, WSDDD, WSTAC, WSIAC, WSDAC, WSRXC, WSRXD, WSRXE, WSRXF, WSRXG, WSRXH, WSRXI, WSRXJ, WSRXK, WSRXL, WSRXM, WSRXN, WSRXO, WSRXP, WSRXQ, MEINT, LC005, WTRID, WTRIC, WTTID, WTTIC, WTIDD, WTIDC, WTIND, WTINC, WTACD, WTACC, WTACT, WSACD, WSACC, WSACT, WSAXD, WSAXC, WSAXT, WSDDA, WSDCA, WSDTA, WTAID, WTAIC, WTAIT, WTTDD, WTTDC, WTTDT, WTDDA, WTDCA, WTDTA, WSTID, WSTIC, WSID1, WSIC1, WSRDX, WSRCX, WSRDD, WSRDC, WSRID, WSRIC, WTIDI, WTICI, WTDII, WTCII, WTCLR, WTCLT, WTLSD, WTLSC, WILSD, WILSC, WIISD, WIISC, WINSD, WINSC, WSISD, WSISC, WSNSD, WSNSC, WRLSD, WRLSC, WRTAD, WRTAC, WSLSC, WSLSD, WISLD, WISLC, WIILD, WIILC, WSILD, WSILC, WRILD, WRILC, WINLD, WINLC, WSSLD, WSSLC, WSLID, WSLIC, WRLID, WRLIC, WTII1RCC, WTII1RCD, WTI2RCC, WTII2RCD, WTIICD, WTIICC, WTIIRICD, WTIIRICC, WTIR1RC, WTIR1RD, WTIRCD, WTIRCC, WTS1RCC, WTS2RCC, WTS1RCD, WTS2RCD, WTSCD, WTSCC, WTSRCD, WTSRCC, WTSII1RCC, WTSII1RCD, WTSIICD, WTSIIC, WTSIR1CC, WTSIR1CD, WTSIRCD, WTSIRCC, WTCSD, WTCSC, WTISRCSD, WTISRCSC, WTSCSD, WTSCSC, WTSIRCSD, WTSIRCSC, WTICSD, WTICSC, WTISICSD, WTISICSC, WTSIICSD, WTSIICSC, WTRCSD, WTRCSC, WTIRICC, WT1RCC, WT1RCD, WT2RCC, WT2RCD, WTCC, WTCD, WTRICC, WTRICD, WTI1RCC, WTI1RCD, WTI2RCD, WTIRICD, WTICCD, WTICCC, WTII2RCC FROM T5ITT7

TOP ERP 6.0 | T5ITT7 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	MO730	Grouping for Form 730	nvarchar	4	0	Allow NULL?
3	ENDDA	End Date	nvarchar	8	0	Allow NULL?
4	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
5	WTNPA	Wage type for net pay	nvarchar	4	0	Allow NULL?
6	WTRIR	WT IRPEF amount to be refunded	nvarchar	4	0	Allow NULL?
7	WTRCS	WT Amount to be refunded C.S.S.N.	nvarchar	4	0	Allow NULL?
8	WTRAD	WT Employee regional surcharge - Amount to be refunded	nvarchar	4	0	Allow NULL?
9	WTRAC	WT Husband/wife regional surcharge. Amount to be refunded	nvarchar	4	0	Allow NULL?
10	WTRCD	WT Employee municipal addit. charge - Amount to be refunded	nvarchar	4	0	Allow NULL?
11	WTRCC	WT H/W municipal additional charge - Amount to be refunded	nvarchar	4	0	Allow NULL?
12	INTER	Interest rate	decimal	5	2
13	INTRE	Percentage rate for deferred payment	decimal	5	2
14	RATA1	Settlement month of first down payment instalment	nvarchar	2	0	Allow NULL?
15	WT1RT	WT first down payment instalment - settlement year	nvarchar	4	0	Allow NULL?
16	WT1DF	WT 1st instalment: deficit difference	nvarchar	4	0	Allow NULL?
17	WT1IN	WT 1st instalment - interest	nvarchar	4	0	Allow NULL?
18	WT1II	Wt 1st instalment: deficit interest	nvarchar	4	0	Allow NULL?
19	RATA2	Settlement month for 2nd down payment instalment	nvarchar	2	0	Allow NULL?
20	WT2RT	WT 2nd or single down payment instalment - settlement year	nvarchar	4	0	Allow NULL?
21	WT2IN	WT 2nd instalment - interest	nvarchar	4	0	Allow NULL?
22	MFRA1	Final payment month for I/II advance payment instalment	nvarchar	2	0	Allow NULL?
23	MFRA2	Final payment month for I/II advance payment instalment	nvarchar	2	0	Allow NULL?
24	WTTIR	WT Personal Income Tax payroll instalment	nvarchar	4	0	Allow NULL?
25	WTIDF	WT IRPEF instalment for deficit difference	nvarchar	4	0	Allow NULL?
26	WTIIN	WT IRPEF instalment interest	nvarchar	4	0	Allow NULL?
27	WTIII	Wt 1st instalment: deficit interest	nvarchar	4	0	Allow NULL?
28	WTTCS	WT CSSN payroll instalment	nvarchar	4	0	Allow NULL?
29	WTCDF	WT CSSN instalment deficit difference	nvarchar	4	0	Allow NULL?
30	WTICS	WT CSSN interest instalment	nvarchar	4	0	Allow NULL?
31	WTTRC	WT Regional withholding - Husband/Wife	nvarchar	4	0	Allow NULL?
32	WTCRC	WT regional surcharge deficit for husband/wife	nvarchar	4	0	Allow NULL?
33	WTIRC	WT Regional surcharge interest for husband/wife	nvarchar	4	0	Allow NULL?
34	WTDRC	Wt deficit interest	nvarchar	4	0	Allow NULL?
35	WTTRD	WT Regional withholding - Employee	nvarchar	4	0	Allow NULL?
36	WTCRD	WT employee regional surcharge deficit	nvarchar	4	0	Allow NULL?
37	WTIRD	WT Regional surcharge interest for employee	nvarchar	4	0	Allow NULL?
38	WTDRD	Wt deficit interest	nvarchar	4	0	Allow NULL?
39	WTTAC	WT Payroll instalment for separate taxation down payment	nvarchar	4	0	Allow NULL?
40	WTADF	WT d.p. instalment for deficit difference separate taxation	nvarchar	4	0	Allow NULL?
41	WTIAC	WT interest instalment for separate taxation down payment	nvarchar	4	0	Allow NULL?
42	WTDAC	Wt deficit interest	nvarchar	4	0	Allow NULL?
43	WTTAD	WT Payroll amount of employee separate taxation down payment	nvarchar	4	0	Allow NULL?
44	WTADD	Wt dwn pmnt instalm.separ.taxation employee deficit differ.	nvarchar	4	0	Allow NULL?
45	WTIAD	WT down payment instalment for EE interest separate taxation	nvarchar	4	0	Allow NULL?
46	WTDDD	Wt deficit interest	nvarchar	4	0	Allow NULL?
47	WTTCC	WT municipal withholding - Husband/Wife	nvarchar	4	0	Allow NULL?
48	WTCCC	WT Husband/Wife municipal additional charge deficit	nvarchar	4	0	Allow NULL?
49	WTICC	WT Municipal add. charge interest for husband/wife	nvarchar	4	0	Allow NULL?
50	WTDCC	Wt deficit interest	nvarchar	4	0	Allow NULL?
51	WTTCD	WT municipal withholding for employee	nvarchar	4	0	Allow NULL?
52	WTCCD	WT Employee Municipal Additional Charge deficit	nvarchar	4	0	Allow NULL?
53	WTICD	WT Municipal additional charge interest for employee	nvarchar	4	0	Allow NULL?
54	WTDCD	Wt deficit interest	nvarchar	4	0	Allow NULL?
55	WT1RD	WT 1st down pymnt instalment f. severance pay year-Tax Payer	nvarchar	4	0	Allow NULL?
56	WT1RC	WT first down payment instalment for severance pay year-H/W	nvarchar	4	0	Allow NULL?
57	WT2RD	WT 2nd or single DP instalment for severance pay year-TP	nvarchar	4	0	Allow NULL?
58	WT2RC	WT 2nd or single DP instalment for severance pay year-H/W	nvarchar	4	0	Allow NULL?
59	W1DFD	WT first difference instalment for deficit - Tax payer	nvarchar	4	0	Allow NULL?
60	W1DFC	WT first difference instalment for deficit - Husband/Wife	nvarchar	4	0	Allow NULL?
61	W1IID	WT first interest instalment for deficit - Tax Payer	nvarchar	4	0	Allow NULL?
62	W1IIC	WT first interest instalment for deficit - Husband/Wife	nvarchar	4	0	Allow NULL?
63	W1IND	WT first interest instalment - tax payer	nvarchar	4	0	Allow NULL?
64	W1INC	WT first interest instalment - Husband/Wife	nvarchar	4	0	Allow NULL?
65	W2IND	WT second interest instalment - Tax Payer	nvarchar	4	0	Allow NULL?
66	W2INC	WT second interest instalment - Husband/Wife	nvarchar	4	0	Allow NULL?
67	WTNP2	Wage-type net pay 2	nvarchar	4	0	Allow NULL?
68	W2DFD	WT 2nd instalment of deficit difference - taxpayer	nvarchar	4	0	Allow NULL?
69	W2DFC	WT 2nd instalment of deficit difference - husband/wife	nvarchar	4	0	Allow NULL?
70	WSRIR	WT reversal PIT refundable amount	nvarchar	4	0	Allow NULL?
71	WSRAD	WT reversal Regional Surcharge refundable amount - EE	nvarchar	4	0	Allow NULL?
72	WSRCD	WT reversal Municipal Surcharge refundable amount EE	nvarchar	4	0	Allow NULL?
73	WSRAC	WT reversal Regional Surcharge refundable amount - H/W	nvarchar	4	0	Allow NULL?
74	WSRCC	WT reversal Municipal Surcharge refundable amount - H/W	nvarchar	4	0	Allow NULL?
75	WS1RD	WT reversal 1st down payment installment - tax payer	nvarchar	4	0	Allow NULL?
76	WSIND	WT reversal 1st interest installment - tax payer	nvarchar	4	0	Allow NULL?
77	WSIID	WT reversal 1st deficit interest install. - tax payer	nvarchar	4	0	Allow NULL?
78	WS1RC	WT reversal 1st payment installment - settlement year - H/W	nvarchar	4	0	Allow NULL?
79	WSINC	WT reversal interest installment - H/W	nvarchar	4	0	Allow NULL?
80	WSIIC	Wt reversal 1st deficit interest installment - h/w	nvarchar	4	0	Allow NULL?
81	WS2RD	WT reversal 2nd or single down payment install. - tax payer	nvarchar	4	0	Allow NULL?
82	WS2ND	WT reversal 2nd interest installment - tax payer	nvarchar	4	0	Allow NULL?
83	WS2RC	WT reversal 2nd or single down payment install. - H/W	nvarchar	4	0	Allow NULL?
84	WS2NC	WT reversal 2nd interest installment - H/W	nvarchar	4	0	Allow NULL?
85	WSTIR	WT reversal PIT installment	nvarchar	4	0	Allow NULL?
86	WSII1	WT reversal personal income tax installment - interest	nvarchar	4	0	Allow NULL?
87	WSIII	WT revrsal 1st deficit interest installment	nvarchar	4	0	Allow NULL?
88	WSTRD	WT reversal Regional Withholding EE	nvarchar	4	0	Allow NULL?
89	WSXRD	Reversal of WT Employee Regional Surcharge Interest	nvarchar	4	0	Allow NULL?
90	WSDRD	WT reversal interest deficit	nvarchar	4	0	Allow NULL?
91	WSTRC	WT reversal Regional Withholding H/W	nvarchar	4	0	Allow NULL?
92	WSXRC	Reversal of WT Wife/Husband Regional Surcharge Interest	nvarchar	4	0	Allow NULL?
93	WSDRC	WT reversal interest deficit	nvarchar	4	0	Allow NULL?
94	WSTCD	WT reversal Municipal Withholding EE	nvarchar	4	0	Allow NULL?
95	WSXCD	Reversal of WT Employee Municipal Surcharge Interest	nvarchar	4	0	Allow NULL?
96	WSDCD	WT reversal interest deficit	nvarchar	4	0	Allow NULL?
97	WSXCC	Reversal of WT Wife/Husband Municipal Surcharge Interest	nvarchar	4	0	Allow NULL?
98	WSTCC	WT reversal Municipal Withholding H/W	nvarchar	4	0	Allow NULL?
99	WSDCC	WT reversal interest deficit	nvarchar	4	0	Allow NULL?
100	WSTAD	WT reversal separate taxation down payment installment-EE	nvarchar	4	0	Allow NULL?
101	WSXAD	Reversal of WT EE interest separate taxation instalment	nvarchar	4	0	Allow NULL?
102	WSDDD	WT reversal interest deficit	nvarchar	4	0	Allow NULL?
103	WSTAC	WT reversal separate taxation down payment installment	nvarchar	4	0	Allow NULL?
104	WSIAC	WT rev.separate taxation down payment installment-interest	nvarchar	4	0	Allow NULL?
105	WSDAC	WT reversal interest deficit	nvarchar	4	0	Allow NULL?
106	WSRXC	WT deficit - PIT refund reversal	nvarchar	4	0	Allow NULL?
107	WSRXD	WT interest deficit PIT refund reversal	nvarchar	4	0	Allow NULL?
108	WSRXE	WT deficit Regional Surcharge refund reversal - EE	nvarchar	4	0	Allow NULL?
109	WSRXF	WT interest deficit Regional Surcharge refund reversal - EE	nvarchar	4	0	Allow NULL?
110	WSRXG	WT deficit Municipal Surcharge refund reversal EE	nvarchar	4	0	Allow NULL?
111	WSRXH	WT interest deficit Municipal Surcharge refund reversal EE	nvarchar	4	0	Allow NULL?
112	WSRXI	WT deficit Regional Surcharge refund reversal H/W	nvarchar	4	0	Allow NULL?
113	WSRXJ	WT interest deficit Regional Surcharge refund reversal H/W	nvarchar	4	0	Allow NULL?
114	WSRXK	WT deficit Municipal Surcharge refund reversal H/W	nvarchar	4	0	Allow NULL?
115	WSRXL	Wt interest deficit Municipal Surcharge refund reversal H/W	nvarchar	4	0	Allow NULL?
116	WSRXM	WT interest PIT refund reversal	nvarchar	4	0	Allow NULL?
117	WSRXN	WT interest Regional Surcharge refund reversal EE	nvarchar	4	0	Allow NULL?
118	WSRXO	WT interest Municipal Surcharge refund reversal EE	nvarchar	4	0	Allow NULL?
119	WSRXP	WT interest Regional Surcharge refund reversal H/W	nvarchar	4	0	Allow NULL?
120	WSRXQ	WT interest Municipal Surcharge refund reversal H/W	nvarchar	4	0	Allow NULL?
121	MEINT	Integration month	nvarchar	2	0	Allow NULL?
122	LC005	Accrual from delayed adjust./stlmnt mnth (Legal Change 2005)	char	1	0	Allow NULL?
123	WTRID	IRPEF amount to be refunded WT for declarant	nvarchar	4	0	Allow NULL?
124	WTRIC	IRPEF amount to be refunded WT for H/W	nvarchar	4	0	Allow NULL?
125	WTTID	Installment WT in IRPEF coupon for declarant	nvarchar	4	0	Allow NULL?
126	WTTIC	IRPEF coupon intstallment WT for H/W	nvarchar	4	0	Allow NULL?
127	WTIDD	PIT installment WT difference for deficit for declarant	nvarchar	4	0	Allow NULL?
128	WTIDC	PIT installment WT difference for deficit for H/W	nvarchar	4	0	Allow NULL?
129	WTIND	Interest PIT installment WT for declarant	nvarchar	4	0	Allow NULL?
130	WTINC	Interest PIT installment WT for spouse	nvarchar	4	0	Allow NULL?
131	WTACD	Municipal surcharge down payment WT for declarant	nvarchar	4	0	Allow NULL?
132	WTACC	Municipal surcharge down payment WT for H/W	nvarchar	4	0	Allow NULL?
133	WTACT	Total municipal surcharge down payment WT	nvarchar	4	0	Allow NULL?
134	WSACD	PIT municipal surcharge down payment reversal for declarant	nvarchar	4	0	Allow NULL?
135	WSACC	PIT municipal surcharge down payment reversal for H/W	nvarchar	4	0	Allow NULL?
136	WSACT	Total PIT municipal surcharge down payment reversal	nvarchar	4	0	Allow NULL?
137	WSAXD	PIT municipal surcharge int. reversal for declarant	nvarchar	4	0	Allow NULL?
138	WSAXC	PIT municipal surcharge int. reversal for H/W	nvarchar	4	0	Allow NULL?
139	WSAXT	Total PIT municipal surcharge int. reversal	nvarchar	4	0	Allow NULL?
140	WSDDA	PIT municipal surcharge int. deficit reversal for declarant	nvarchar	4	0	Allow NULL?
141	WSDCA	PIT municipal surcharge int. deficit reversal for H/W	nvarchar	4	0	Allow NULL?
142	WSDTA	Total PIT municipal surcharge int. deficit reversal	nvarchar	4	0	Allow NULL?
143	WTAID	PIT municipal surcharge down payment interest for declarant	nvarchar	4	0	Allow NULL?
144	WTAIC	PIT municipal surcharge down payment interest for H/W	nvarchar	4	0	Allow NULL?
145	WTAIT	Total PIT municipal surcharge down payment interest	nvarchar	4	0	Allow NULL?
146	WTTDD	PIT municipal surcharge down payment deficit for declarant	nvarchar	4	0	Allow NULL?
147	WTTDC	PIT municipal surcharge down payment deficit for H/W	nvarchar	4	0	Allow NULL?
148	WTTDT	Total PIT municipal surcharge down payment deficit	nvarchar	4	0	Allow NULL?
149	WTDDA	PIT municipal surcharge DP deficit interest for declarant	nvarchar	4	0	Allow NULL?
150	WTDCA	PIT municipal surcharge down payment deficit interest f. H/W	nvarchar	4	0	Allow NULL?
151	WTDTA	Total PIT municipal surcharge DP deficit interest	nvarchar	4	0	Allow NULL?
152	WSTID	PIT reversal installment WT for declarant	nvarchar	4	0	Allow NULL?
153	WSTIC	PIT reversal installment WT for H/W	nvarchar	4	0	Allow NULL?
154	WSID1	Interest PIT installment WT reversal for declarant	nvarchar	4	0	Allow NULL?
155	WSIC1	Interest PIT installment WT reversal for H/W	nvarchar	4	0	Allow NULL?
156	WSRDX	PIT refund reversal deficit WT for declarant	nvarchar	4	0	Allow NULL?
157	WSRCX	PIT refund reversal deficit WT for H/W	nvarchar	4	0	Allow NULL?
158	WSRDD	PIT refund reversal deficit interest WT for declarant	nvarchar	4	0	Allow NULL?
159	WSRDC	PIT refund reversal deficit interest WT for H/W	nvarchar	4	0	Allow NULL?
160	WSRID	PIT amount to be refunded reversal WT for declarant	nvarchar	4	0	Allow NULL?
161	WSRIC	PIT amount to be refunded reversal WT for H/W	nvarchar	4	0	Allow NULL?
162	WTIDI	Deficit interest PIT WT for declarant	nvarchar	4	0	Allow NULL?
163	WTICI	Deficit interest PIT WT for H/W	nvarchar	4	0	Allow NULL?
164	WTDII	Personal Income Tax Deficit Interest Status WT for declarant	nvarchar	4	0	Allow NULL?
165	WTCII	Personal Income Tax Deficit Interest Status WT for H/W	nvarchar	4	0	Allow NULL?
166	WTCLR	WT Tax Declaration in July to be repaid	nvarchar	4	0	Allow NULL?
167	WTCLT	WT Tax Declaration in July to be withdrawn	nvarchar	4	0	Allow NULL?
168	WTLSD	Substitute Tax Withholding for Extra Work (Declarant)	nvarchar	4	0	Allow NULL?
169	WTLSC	Substitute Tax Withholding for Extra Work (Spouse)	nvarchar	4	0	Allow NULL?
170	WILSD	Substitute Tax Deficit for Extra Work (Declarant)	nvarchar	4	0	Allow NULL?
171	WILSC	Substitute Tax Deficit for Extra Work (Spouse)	nvarchar	4	0	Allow NULL?
172	WIISD	Deficit Interest of Substitute Tax on Extra Work (Declarant)	nvarchar	4	0	Allow NULL?
173	WIISC	Deficit Interest of Substitute Tax on Extra Work (Spouse)	nvarchar	4	0	Allow NULL?
174	WINSD	Interest on Substitute Tax for Extra Work (Declarant)	nvarchar	4	0	Allow NULL?
175	WINSC	Interest on Substitute Tax for Extra Work (Spouse)	nvarchar	4	0	Allow NULL?
176	WSISD	Subst.Deficit Reversal for Extra Work (Declarant)	nvarchar	4	0	Allow NULL?
177	WSISC	Subst.Deficit Reversal for Extra Work (Spouse)	nvarchar	4	0	Allow NULL?
178	WSNSD	Subst. Interest Reversal for Extra Work (Employee)	nvarchar	4	0	Allow NULL?
179	WSNSC	Subst. Interest Reversal for Extra Work (Spouse)	nvarchar	4	0	Allow NULL?
180	WRLSD	Substitute Refund for Extra Work (Declarant)	nvarchar	4	0	Allow NULL?
181	WRLSC	Substitute Refund for Extra Work (Spouse)	nvarchar	4	0	Allow NULL?
182	WRTAD	Refund on Separate Taxation (Employee)	nvarchar	4	0	Allow NULL?
183	WRTAC	Refund on Separate Taxation (Spouse)	nvarchar	4	0	Allow NULL?
184	WSLSC	Substitute Tax Reversal for Extra Work (Spouse)	nvarchar	4	0	Allow NULL?
185	WSLSD	Substitute Tax Reversal for Extra Work (Declarant)	nvarchar	4	0	Allow NULL?
186	WISLD	Declarant rent substitute tax	nvarchar	4	0	Allow NULL?
187	WISLC	Spouse rent substitute tax	nvarchar	4	0	Allow NULL?
188	WIILD	Declarant rent tax int.	nvarchar	4	0	Allow NULL?
189	WIILC	Spouse rent tax int.	nvarchar	4	0	Allow NULL?
190	WSILD	Declarant Rent Tax reversal	nvarchar	4	0	Allow NULL?
191	WSILC	Spouse Rent Tax reversal	nvarchar	4	0	Allow NULL?
192	WRILD	Declarant int. rentals reversal	nvarchar	4	0	Allow NULL?
193	WRILC	Spouse int. rentals reversal	nvarchar	4	0	Allow NULL?
194	WINLD	Declarant rent tax incap.	nvarchar	4	0	Allow NULL?
195	WINLC	Spouse rent tax incap.	nvarchar	4	0	Allow NULL?
196	WSSLD	Declarant rent tax incap. interest	nvarchar	4	0	Allow NULL?
197	WSSLC	Spouse Rental incap. interest	nvarchar	4	0	Allow NULL?
198	WSLID	Declarant Rental incap. reversal	nvarchar	4	0	Allow NULL?
199	WSLIC	Spouse Rental incap. reversal	nvarchar	4	0	Allow NULL?
200	WRLID	Declarant rental reimbursement	nvarchar	4	0	Allow NULL?
201	WRLIC	Spouse rental reimbursement	nvarchar	4	0	Allow NULL?
202	WTII1RCC	WT inter. def. 1st down payment inst. FlatTax RentInc Spouse	nvarchar	4	0	Allow NULL?
203	WTII1RCD	WT inter. def. 1st down payment inst. FlatTax RentInc Decl.	nvarchar	4	0	Allow NULL?
204	WTI2RCC	WT Deficit 2nd installment Flat Tax on rental income Spouse	nvarchar	4	0	Allow NULL?
205	WTII2RCD	WT inter. def. 2nd down paym. install. Decl FlatTaxRentalInc	nvarchar	4	0	Allow NULL?
206	WTIICD	WT inter. def. of Declarant Flat Tax on rental income	nvarchar	4	0	Allow NULL?
207	WTIICC	WT inter. def. of Spouse Flat Tax on rental income	nvarchar	4	0	Allow NULL?
208	WTIIRICD	WT Inter. reversal def. of Declarant Flat Tax on rental inc.	nvarchar	4	0	Allow NULL?
209	WTIIRICC	WT Inter. reversal def. of Spouse Flat Tax on rental income	nvarchar	4	0	Allow NULL?
210	WTIR1RC	WT Interests on installments 1st inst. Spouse FlatTaxRentInc	nvarchar	4	0	Allow NULL?
211	WTIR1RD	WT Interests on installments 1st inst. Decl. FlatTaxRentInc	nvarchar	4	0	Allow NULL?
212	WTIRCD	WT Interests on installments of Decl. Flat Tax on rent.inc.	nvarchar	4	0	Allow NULL?
213	WTIRCC	WT Interests on installments of spouse Flat Tax on rent.inc.	nvarchar	4	0	Allow NULL?
214	WTS1RCC	WT Reversal 1st down paym. inst. Flat Tax on rent.income Sp.	nvarchar	4	0	Allow NULL?
215	WTS2RCC	WT Reversal 2nd down paym. inst. Flat Tax on rent. inc. Sp.	nvarchar	4	0	Allow NULL?
216	WTS1RCD	WT Reversal 1st down paym. inst. Flat Tax on rent.inc. Decl.	nvarchar	4	0	Allow NULL?
217	WTS2RCD	WT Reversal 2nd down payment inst. Flat Tax rental inc.Decl.	nvarchar	4	0	Allow NULL?
218	WTSCD	WT Reversal of Flat Tax on rental income Declarant	nvarchar	4	0	Allow NULL?
219	WTSCC	WT Reversal of Flat Tax on rental income Spouse	nvarchar	4	0	Allow NULL?
220	WTSRCD	WT Refund of declarant flat tax on rental income	nvarchar	4	0	Allow NULL?
221	WTSRCC	WT Refund of Spouse Flat Tax on rental income	nvarchar	4	0	Allow NULL?
222	WTSII1RCC	WT Inter. rev. def. 1st down paym. inst. FlatTax RentInc Sp.	nvarchar	4	0	Allow NULL?
223	WTSII1RCD	WT Rev. inter. def. 1st down paym.inst. FlatTaxRentInc Decl.	nvarchar	4	0	Allow NULL?
224	WTSIICD	WT Reversal inter. def. Flat Tax on rental income Declarant	nvarchar	4	0	Allow NULL?
225	WTSIIC	WT Reversal int. def. FlatTax RentInc Decl.	nvarchar	4	0	Allow NULL?
226	WTSIR1CC	WT Rev. inter. on installments 1st DP inst. FlatTaxRentIncSp	nvarchar	4	0	Allow NULL?
227	WTSIR1CD	WT Rev. int. inst. 1st DP inst. FlatTaxRentInc Decl.	nvarchar	4	0	Allow NULL?
228	WTSIRCD	WT Reversal int. installments Flat Tax on rent.inc. Decl.	nvarchar	4	0	Allow NULL?
229	WTSIRCC	WT Reversal int. installm. Flat Tax RentInc Sp.	nvarchar	4	0	Allow NULL?
230	WTCSD	WT for Declarant Solidarity Contribution	nvarchar	4	0	Allow NULL?
231	WTCSC	Wage type for Spouse Solidarity Contribution	nvarchar	4	0	Allow NULL?
232	WTISRCSD	WT Int. installments of Declarant Solidarity Contribution	nvarchar	4	0	Allow NULL?
233	WTISRCSC	WT Int. on installments of Spouse Solidarity Contribution	nvarchar	4	0	Allow NULL?
234	WTSCSD	Wage type Reversal of Declarant Solidarity Contribution	nvarchar	4	0	Allow NULL?
235	WTSCSC	Wage type Reversal of Spouse Solidarity Contribution	nvarchar	4	0	Allow NULL?
236	WTSIRCSD	Wage type Reversal int. inst. Decl. Solidarity Contribution	nvarchar	4	0	Allow NULL?
237	WTSIRCSC	Wage type Reversal int. inst. Spouse Solidarity Contribution	nvarchar	4	0	Allow NULL?
238	WTICSD	Wage type Deficit of Declarant Solidarity Contribution	nvarchar	4	0	Allow NULL?
239	WTICSC	Wage type deficit of Spouse Solidarity Contribution	nvarchar	4	0	Allow NULL?
240	WTISICSD	Wage type interests def. Declarant Solidarity Contribution	nvarchar	4	0	Allow NULL?
241	WTISICSC	Wage type interests def. Spouse Solidarity Contribution	nvarchar	4	0	Allow NULL?
242	WTSIICSD	Wage type rev. interests def. Decl. Solidarity Contribution	nvarchar	4	0	Allow NULL?
243	WTSIICSC	Wage type Reversal interests def. Spouse Solidarity Contrib.	nvarchar	4	0	Allow NULL?
244	WTRCSD	Wage type Refund of Declarant Solidarity Contribution	nvarchar	4	0	Allow NULL?
245	WTRCSC	Wage type Refund of Spouse Solidarity Contribution	nvarchar	4	0	Allow NULL?
246	WTIRICC	WT Refund reversal deficit of Flat Tax on rental inc. Spouse	nvarchar	4	0	Allow NULL?
247	WT1RCC	WT 1st down payment install. of flat tax on rent.inc. Spouse	nvarchar	4	0	Allow NULL?
248	WT1RCD	WT 1st down payment install. of flat tax on rent.inc. Decl.	nvarchar	4	0	Allow NULL?
249	WT2RCC	WT 2nd down payment install. of flat tax on rent.inc. Spouse	nvarchar	4	0	Allow NULL?
250	WT2RCD	WT 2nd down payment installment of decl. flat tax on RentInc	nvarchar	4	0	Allow NULL?
251	WTCC	WT Spouse Flat Tax on rental income	nvarchar	4	0	Allow NULL?
252	WTCD	WT Declarant Flat Tax on rental income	nvarchar	4	0	Allow NULL?
253	WTRICC	WT Refund of Spouse Flat Tax on rental income	nvarchar	4	0	Allow NULL?
254	WTRICD	WT Refund of Flat Tax on rental income Declarant	nvarchar	4	0	Allow NULL?
255	WTI1RCC	WT 1st installment deficit of Spouse Flat Tax on rent.income	nvarchar	4	0	Allow NULL?
256	WTI1RCD	WT Deficit 1st installment Flat Tax on rental income Decl.	nvarchar	4	0	Allow NULL?
257	WTI2RCD	WT Deficit 2nd down paym. inst. Flat Tax on rent.inc. decl.	nvarchar	4	0	Allow NULL?
258	WTIRICD	WT Reversal refund def. Flat Tax on rental income Declarant	nvarchar	4	0	Allow NULL?
259	WTICCD	WT deficit of Declarant Flat Tax on rental income	nvarchar	4	0	Allow NULL?
260	WTICCC	WT Deficit of Spouse Flat Tax on rental income	nvarchar	4	0	Allow NULL?
261	WTII2RCC	WT inter. def. 2nd down payment inst. FlatTax RentInc spouse	nvarchar	4	0	Allow NULL?

TOP ERP 6.0 | T5ITT7 INDEXES

Name	Primary	Unique	Type	Columns
T5ITT7~0	Yes	Yes	CLUSTERED	ENDDA, MO730, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

261 COLUMNS | 1 INDEXES | ERP 6.0 | T5ITT7 TABLE

TOP ERP 6.0 | T5ITT7 COLUMNS

TOP ERP 6.0 | T5ITT7 INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

261 COLUMNS | 1 INDEXES | ERP 6.0 | T5ITT7 TABLE

TOPERP 6.0 | T5ITT7 COLUMNS

TOPERP 6.0 | T5ITT7 INDEXES

TOP ERP 6.0 | T5ITT7 COLUMNS

TOP ERP 6.0 | T5ITT7 INDEXES