	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

233 COLUMNS | 1 INDEXES | ERP 6.0 | PA0245 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA0245	233	1	Infotype 0245 - Annual tax calculation CZ	Personnel Administration

SQL: selectupdate insert create

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

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, TTJJ, TTJVSA, TTJVSD, TTFB5, TFB5N, TTFB6, TFB6N, WAERS, TTFB7, TTFB8, TTFB9, TTFB10, TTFB11, TTFB12, TTFB101, TTFB102, TTFB103, TTFB104, TTFB105, TTFB106, TTFB107, TTFB108, TTFB109, TTFB110, TTFB111, TTFB112, TTFB201, TTFB202, TTFB203, TTFB204, TTFB205, TTFB206, TTFB207, TTFB208, TTFB209, TTFB210, TTFB211, TTFB212, TTFB301, TTFB302, TTFB303, TTFB304, TTFB305, TTFB306, TTFB307, TTFB308, TTFB309, TTFB310, TTFB311, TTFB312, TTFB401, TTFB402, TTFB403, TTFB404, TTFB405, TTFB406, TTFB407, TTFB408, TTFB409, TTFB410, TTFB411, TTFB412, TTKD0101, TTKD0102, TTKD0103, TTKD0104, TTKD0105, TTKD0106, TTKD0107, TTKD0108, TTKD0109, TTKD0110, TTKD0111, TTKD0112, TTKD0201, TTKD0202, TTKD0203, TTKD0204, TTKD0205, TTKD0206, TTKD0207, TTKD0208, TTKD0209, TTKD0210, TTKD0211, TTKD0212, TTKD0301, TTKD0302, TTKD0303, TTKD0304, TTKD0305, TTKD0306, TTKD0307, TTKD0308, TTKD0309, TTKD0310, TTKD0311, TTKD0312, TTKD0401, TTKD0402, TTKD0403, TTKD0404, TTKD0405, TTKD0406, TTKD0407, TTKD0408, TTKD0409, TTKD0410, TTKD0411, TTKD0412, TTKD0501, TTKD0502, TTKD0503, TTKD0504, TTKD0505, TTKD0506, TTKD0507, TTKD0508, TTKD0509, TTKD0510, TTKD0511, TTKD0512, TTKD0601, TTKD0602, TTKD0603, TTKD0604, TTKD0605, TTKD0606, TTKD0607, TTKD0608, TTKD0609, TTKD0610, TTKD0611, TTKD0612, TTKD0701, TTKD0702, TTKD0703, TTKD0704, TTKD0705, TTKD0706, TTKD0707, TTKD0708, TTKD0709, TTKD0710, TTKD0711, TTKD0712, TTKD0801, TTKD0802, TTKD0803, TTKD0804, TTKD0805, TTKD0806, TTKD0807, TTKD0808, TTKD0809, TTKD0810, TTKD0811, TTKD0812, TTKD0901, TTKD0902, TTKD0903, TTKD0904, TTKD0905, TTKD0906, TTKD0907, TTKD0908, TTKD0909, TTKD0910, TTKD0911, TTKD0912, TTKD1001, TTKD1002, TTKD1003, TTKD1004, TTKD1005, TTKD1006, TTKD1007, TTKD1008, TTKD1009, TTKD1010, TTKD1011, TTKD1012, TTKD01SU, TTKD02SU, TTKD03SU, TTKD04SU, TTKD05SU, TTKD06SU, TTKD07SU, TTKD08SU, TTKD09SU, TTKD10SU, TTKD01OB, TTKD02OB, TTKD03OB, TTKD04OB, TTKD05OB, TTKD06OB, TTKD07OB, TTKD08OB, TTKD09OB, TTKD10OB, TTFB13, TFB14N, TTFB14, TTFB15, TTFB16, TTFB17, TTFB19, TTFB19N FROM PA0245

TOP ERP 6.0 | PA0245 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	Allow NULL?
24	TTJJ	Year for annual tax calculation	nvarchar	4	0	Allow NULL?
25	TTJVSA	Checkbox - Perform annual tax calculation (RZD)	char	1	0	Allow NULL?
26	TTJVSD	Period of annual tax calculation (RZD)	nvarchar	2	0	Allow NULL?
27	TTFB5	Tax free amount - wife	char	1	0	Allow NULL?
28	TFB5N	Tax free months of a wife	nvarchar	2	0	Allow NULL?
29	TTFB6	Tax free amount - wife ZTP-P	char	1	0	Allow NULL?
30	TFB6N	Tax free months of a wife	nvarchar	2	0	Allow NULL?
31	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
32	TTFB7	Tax free amount - pensioners	decimal	9	2
33	TTFB8	Tax free amount - gifts	decimal	9	2
34	TTFB9	Tax free amount for EE	char	1	0	Allow NULL?
35	TTFB10	Inerests of mortgages	decimal	9	2
36	TTFB11	Supplementary pension insuracne	decimal	9	2
37	TTFB12	Private Life Insurance	decimal	9	2
38	TTFB101	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
39	TTFB102	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
40	TTFB103	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
41	TTFB104	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
42	TTFB105	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
43	TTFB106	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
44	TTFB107	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
45	TTFB108	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
46	TTFB109	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
47	TTFB110	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
48	TTFB111	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
49	TTFB112	Tax free amount for partly challenged EE/invalid.1.,2.rate	char	1	0	Allow NULL?
50	TTFB201	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
51	TTFB202	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
52	TTFB203	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
53	TTFB204	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
54	TTFB205	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
55	TTFB206	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
56	TTFB207	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
57	TTFB208	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
58	TTFB209	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
59	TTFB210	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
60	TTFB211	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
61	TTFB212	Tax free amount - full challenged EE/invalidity 3. rate	char	1	0	Allow NULL?
62	TTFB301	Tax free amount ZTP-P	char	1	0	Allow NULL?
63	TTFB302	Tax free amount ZTP-P	char	1	0	Allow NULL?
64	TTFB303	Tax free amount ZTP-P	char	1	0	Allow NULL?
65	TTFB304	Tax free amount ZTP-P	char	1	0	Allow NULL?
66	TTFB305	Tax free amount ZTP-P	char	1	0	Allow NULL?
67	TTFB306	Tax free amount ZTP-P	char	1	0	Allow NULL?
68	TTFB307	Tax free amount ZTP-P	char	1	0	Allow NULL?
69	TTFB308	Tax free amount ZTP-P	char	1	0	Allow NULL?
70	TTFB309	Tax free amount ZTP-P	char	1	0	Allow NULL?
71	TTFB310	Tax free amount ZTP-P	char	1	0	Allow NULL?
72	TTFB311	Tax free amount ZTP-P	char	1	0	Allow NULL?
73	TTFB312	Tax free amount ZTP-P	char	1	0	Allow NULL?
74	TTFB401	Tax free amount - studet	char	1	0	Allow NULL?
75	TTFB402	Tax free amount - studet	char	1	0	Allow NULL?
76	TTFB403	Tax free amount - studet	char	1	0	Allow NULL?
77	TTFB404	Tax free amount - studet	char	1	0	Allow NULL?
78	TTFB405	Tax free amount - studet	char	1	0	Allow NULL?
79	TTFB406	Tax free amount - studet	char	1	0	Allow NULL?
80	TTFB407	Tax free amount - studet	char	1	0	Allow NULL?
81	TTFB408	Tax free amount - studet	char	1	0	Allow NULL?
82	TTFB409	Tax free amount - studet	char	1	0	Allow NULL?
83	TTFB410	Tax free amount - studet	char	1	0	Allow NULL?
84	TTFB411	Tax free amount - studet	char	1	0	Allow NULL?
85	TTFB412	Tax free amount - studet	char	1	0	Allow NULL?
86	TTKD0101	Children tax exepmtion	nvarchar	2	0	Allow NULL?
87	TTKD0102	Children tax exepmtion	nvarchar	2	0	Allow NULL?
88	TTKD0103	Children tax exepmtion	nvarchar	2	0	Allow NULL?
89	TTKD0104	Children tax exepmtion	nvarchar	2	0	Allow NULL?
90	TTKD0105	Children tax exepmtion	nvarchar	2	0	Allow NULL?
91	TTKD0106	Children tax exepmtion	nvarchar	2	0	Allow NULL?
92	TTKD0107	Children tax exepmtion	nvarchar	2	0	Allow NULL?
93	TTKD0108	Children tax exepmtion	nvarchar	2	0	Allow NULL?
94	TTKD0109	Children tax exepmtion	nvarchar	2	0	Allow NULL?
95	TTKD0110	Children tax exepmtion	nvarchar	2	0	Allow NULL?
96	TTKD0111	Children tax exepmtion	nvarchar	2	0	Allow NULL?
97	TTKD0112	Children tax exepmtion	nvarchar	2	0	Allow NULL?
98	TTKD0201	Children tax exepmtion	nvarchar	2	0	Allow NULL?
99	TTKD0202	Children tax exepmtion	nvarchar	2	0	Allow NULL?
100	TTKD0203	Children tax exepmtion	nvarchar	2	0	Allow NULL?
101	TTKD0204	Children tax exepmtion	nvarchar	2	0	Allow NULL?
102	TTKD0205	Children tax exepmtion	nvarchar	2	0	Allow NULL?
103	TTKD0206	Children tax exepmtion	nvarchar	2	0	Allow NULL?
104	TTKD0207	Children tax exepmtion	nvarchar	2	0	Allow NULL?
105	TTKD0208	Children tax exepmtion	nvarchar	2	0	Allow NULL?
106	TTKD0209	Children tax exepmtion	nvarchar	2	0	Allow NULL?
107	TTKD0210	Children tax exepmtion	nvarchar	2	0	Allow NULL?
108	TTKD0211	Children tax exepmtion	nvarchar	2	0	Allow NULL?
109	TTKD0212	Children tax exepmtion	nvarchar	2	0	Allow NULL?
110	TTKD0301	Children tax exepmtion	nvarchar	2	0	Allow NULL?
111	TTKD0302	Children tax exepmtion	nvarchar	2	0	Allow NULL?
112	TTKD0303	Children tax exepmtion	nvarchar	2	0	Allow NULL?
113	TTKD0304	Children tax exepmtion	nvarchar	2	0	Allow NULL?
114	TTKD0305	Children tax exepmtion	nvarchar	2	0	Allow NULL?
115	TTKD0306	Children tax exepmtion	nvarchar	2	0	Allow NULL?
116	TTKD0307	Children tax exepmtion	nvarchar	2	0	Allow NULL?
117	TTKD0308	Children tax exepmtion	nvarchar	2	0	Allow NULL?
118	TTKD0309	Children tax exepmtion	nvarchar	2	0	Allow NULL?
119	TTKD0310	Children tax exepmtion	nvarchar	2	0	Allow NULL?
120	TTKD0311	Children tax exepmtion	nvarchar	2	0	Allow NULL?
121	TTKD0312	Children tax exepmtion	nvarchar	2	0	Allow NULL?
122	TTKD0401	Children tax exepmtion	nvarchar	2	0	Allow NULL?
123	TTKD0402	Children tax exepmtion	nvarchar	2	0	Allow NULL?
124	TTKD0403	Children tax exepmtion	nvarchar	2	0	Allow NULL?
125	TTKD0404	Children tax exepmtion	nvarchar	2	0	Allow NULL?
126	TTKD0405	Children tax exepmtion	nvarchar	2	0	Allow NULL?
127	TTKD0406	Children tax exepmtion	nvarchar	2	0	Allow NULL?
128	TTKD0407	Children tax exepmtion	nvarchar	2	0	Allow NULL?
129	TTKD0408	Children tax exepmtion	nvarchar	2	0	Allow NULL?
130	TTKD0409	Children tax exepmtion	nvarchar	2	0	Allow NULL?
131	TTKD0410	Children tax exepmtion	nvarchar	2	0	Allow NULL?
132	TTKD0411	Children tax exepmtion	nvarchar	2	0	Allow NULL?
133	TTKD0412	Children tax exepmtion	nvarchar	2	0	Allow NULL?
134	TTKD0501	Children tax exepmtion	nvarchar	2	0	Allow NULL?
135	TTKD0502	Children tax exepmtion	nvarchar	2	0	Allow NULL?
136	TTKD0503	Children tax exepmtion	nvarchar	2	0	Allow NULL?
137	TTKD0504	Children tax exepmtion	nvarchar	2	0	Allow NULL?
138	TTKD0505	Children tax exepmtion	nvarchar	2	0	Allow NULL?
139	TTKD0506	Children tax exepmtion	nvarchar	2	0	Allow NULL?
140	TTKD0507	Children tax exepmtion	nvarchar	2	0	Allow NULL?
141	TTKD0508	Children tax exepmtion	nvarchar	2	0	Allow NULL?
142	TTKD0509	Children tax exepmtion	nvarchar	2	0	Allow NULL?
143	TTKD0510	Children tax exepmtion	nvarchar	2	0	Allow NULL?
144	TTKD0511	Children tax exepmtion	nvarchar	2	0	Allow NULL?
145	TTKD0512	Children tax exepmtion	nvarchar	2	0	Allow NULL?
146	TTKD0601	Children tax exepmtion	nvarchar	2	0	Allow NULL?
147	TTKD0602	Children tax exepmtion	nvarchar	2	0	Allow NULL?
148	TTKD0603	Children tax exepmtion	nvarchar	2	0	Allow NULL?
149	TTKD0604	Children tax exepmtion	nvarchar	2	0	Allow NULL?
150	TTKD0605	Children tax exepmtion	nvarchar	2	0	Allow NULL?
151	TTKD0606	Children tax exepmtion	nvarchar	2	0	Allow NULL?
152	TTKD0607	Children tax exepmtion	nvarchar	2	0	Allow NULL?
153	TTKD0608	Children tax exepmtion	nvarchar	2	0	Allow NULL?
154	TTKD0609	Children tax exepmtion	nvarchar	2	0	Allow NULL?
155	TTKD0610	Children tax exepmtion	nvarchar	2	0	Allow NULL?
156	TTKD0611	Children tax exepmtion	nvarchar	2	0	Allow NULL?
157	TTKD0612	Children tax exepmtion	nvarchar	2	0	Allow NULL?
158	TTKD0701	Children tax exepmtion	nvarchar	2	0	Allow NULL?
159	TTKD0702	Children tax exepmtion	nvarchar	2	0	Allow NULL?
160	TTKD0703	Children tax exepmtion	nvarchar	2	0	Allow NULL?
161	TTKD0704	Children tax exepmtion	nvarchar	2	0	Allow NULL?
162	TTKD0705	Children tax exepmtion	nvarchar	2	0	Allow NULL?
163	TTKD0706	Children tax exepmtion	nvarchar	2	0	Allow NULL?
164	TTKD0707	Children tax exepmtion	nvarchar	2	0	Allow NULL?
165	TTKD0708	Children tax exepmtion	nvarchar	2	0	Allow NULL?
166	TTKD0709	Children tax exepmtion	nvarchar	2	0	Allow NULL?
167	TTKD0710	Children tax exepmtion	nvarchar	2	0	Allow NULL?
168	TTKD0711	Children tax exepmtion	nvarchar	2	0	Allow NULL?
169	TTKD0712	Children tax exepmtion	nvarchar	2	0	Allow NULL?
170	TTKD0801	Children tax exepmtion	nvarchar	2	0	Allow NULL?
171	TTKD0802	Children tax exepmtion	nvarchar	2	0	Allow NULL?
172	TTKD0803	Children tax exepmtion	nvarchar	2	0	Allow NULL?
173	TTKD0804	Children tax exepmtion	nvarchar	2	0	Allow NULL?
174	TTKD0805	Children tax exepmtion	nvarchar	2	0	Allow NULL?
175	TTKD0806	Children tax exepmtion	nvarchar	2	0	Allow NULL?
176	TTKD0807	Children tax exepmtion	nvarchar	2	0	Allow NULL?
177	TTKD0808	Children tax exepmtion	nvarchar	2	0	Allow NULL?
178	TTKD0809	Children tax exepmtion	nvarchar	2	0	Allow NULL?
179	TTKD0810	Children tax exepmtion	nvarchar	2	0	Allow NULL?
180	TTKD0811	Children tax exepmtion	nvarchar	2	0	Allow NULL?
181	TTKD0812	Children tax exepmtion	nvarchar	2	0	Allow NULL?
182	TTKD0901	Children tax exepmtion	nvarchar	2	0	Allow NULL?
183	TTKD0902	Children tax exepmtion	nvarchar	2	0	Allow NULL?
184	TTKD0903	Children tax exepmtion	nvarchar	2	0	Allow NULL?
185	TTKD0904	Children tax exepmtion	nvarchar	2	0	Allow NULL?
186	TTKD0905	Children tax exepmtion	nvarchar	2	0	Allow NULL?
187	TTKD0906	Children tax exepmtion	nvarchar	2	0	Allow NULL?
188	TTKD0907	Children tax exepmtion	nvarchar	2	0	Allow NULL?
189	TTKD0908	Children tax exepmtion	nvarchar	2	0	Allow NULL?
190	TTKD0909	Children tax exepmtion	nvarchar	2	0	Allow NULL?
191	TTKD0910	Children tax exepmtion	nvarchar	2	0	Allow NULL?
192	TTKD0911	Children tax exepmtion	nvarchar	2	0	Allow NULL?
193	TTKD0912	Children tax exepmtion	nvarchar	2	0	Allow NULL?
194	TTKD1001	Children tax exepmtion	nvarchar	2	0	Allow NULL?
195	TTKD1002	Children tax exepmtion	nvarchar	2	0	Allow NULL?
196	TTKD1003	Children tax exepmtion	nvarchar	2	0	Allow NULL?
197	TTKD1004	Children tax exepmtion	nvarchar	2	0	Allow NULL?
198	TTKD1005	Children tax exepmtion	nvarchar	2	0	Allow NULL?
199	TTKD1006	Children tax exepmtion	nvarchar	2	0	Allow NULL?
200	TTKD1007	Children tax exepmtion	nvarchar	2	0	Allow NULL?
201	TTKD1008	Children tax exepmtion	nvarchar	2	0	Allow NULL?
202	TTKD1009	Children tax exepmtion	nvarchar	2	0	Allow NULL?
203	TTKD1010	Children tax exepmtion	nvarchar	2	0	Allow NULL?
204	TTKD1011	Children tax exepmtion	nvarchar	2	0	Allow NULL?
205	TTKD1012	Children tax exepmtion	nvarchar	2	0	Allow NULL?
206	TTKD01SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
207	TTKD02SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
208	TTKD03SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
209	TTKD04SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
210	TTKD05SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
211	TTKD06SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
212	TTKD07SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
213	TTKD08SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
214	TTKD09SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
215	TTKD10SU	Subtype IT0021 for IT0245	nvarchar	2	0	Allow NULL?
216	TTKD01OB	Object Identification	nvarchar	2	0	Allow NULL?
217	TTKD02OB	Object Identification	nvarchar	2	0	Allow NULL?
218	TTKD03OB	Object Identification	nvarchar	2	0	Allow NULL?
219	TTKD04OB	Object Identification	nvarchar	2	0	Allow NULL?
220	TTKD05OB	Object Identification	nvarchar	2	0	Allow NULL?
221	TTKD06OB	Object Identification	nvarchar	2	0	Allow NULL?
222	TTKD07OB	Object Identification	nvarchar	2	0	Allow NULL?
223	TTKD08OB	Object Identification	nvarchar	2	0	Allow NULL?
224	TTKD09OB	Object Identification	nvarchar	2	0	Allow NULL?
225	TTKD10OB	Object Identification	nvarchar	2	0	Allow NULL?
226	TTFB13	Non tax - flood gifts	decimal	9	2
227	TFB14N	Tax-free - Trade union fees	decimal	9	2
228	TTFB14	Tax-free - Trade union fees	char	1	0	Allow NULL?
229	TTFB15		decimal	9	0
230	TTFB16		decimal	9	0
231	TTFB17		decimal	9	0
232	TTFB19	Discount for child placement	decimal	9	2
233	TTFB19N	Number of children with relief for child placement	nvarchar	2	0	Allow NULL?

TOP ERP 6.0 | PA0245 INDEXES

Name	Primary	Unique	Type	Columns
PA0245~0	Yes	Yes	CLUSTERED	SEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, 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

233 COLUMNS | 1 INDEXES | ERP 6.0 | PA0245 TABLE

TOP ERP 6.0 | PA0245 COLUMNS

TOP ERP 6.0 | PA0245 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

233 COLUMNS | 1 INDEXES | ERP 6.0 | PA0245 TABLE

TOPERP 6.0 | PA0245 COLUMNS

TOPERP 6.0 | PA0245 INDEXES

TOP ERP 6.0 | PA0245 COLUMNS

TOP ERP 6.0 | PA0245 INDEXES