	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

329 COLUMNS | 1 INDEXES | ERP 6.0 | PA3214 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Payroll :: Italy
1	ERP EHP7	6.0	PA3214	329	1	HR Master Record: Infotype 3214	Italy

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, WAERS, LGA01, BET01, ANZ01, EIN01, OPK01, IND01, LGA02, BET02, ANZ02, EIN02, OPK02, IND02, LGA03, BET03, ANZ03, EIN03, OPK03, IND03, LGA04, BET04, ANZ04, EIN04, OPK04, IND04, LGA05, BET05, ANZ05, EIN05, OPK05, IND05, LGA06, BET06, ANZ06, EIN06, OPK06, IND06, LGA07, BET07, ANZ07, EIN07, OPK07, IND07, LGA08, BET08, ANZ08, EIN08, OPK08, IND08, LGA09, BET09, ANZ09, EIN09, OPK09, IND09, LGA10, BET10, ANZ10, EIN10, OPK10, IND10, LGA11, BET11, ANZ11, EIN11, OPK11, IND11, LGA12, BET12, ANZ12, EIN12, OPK12, IND12, LGA13, BET13, ANZ13, EIN13, OPK13, IND13, LGA14, BET14, ANZ14, EIN14, OPK14, IND14, LGA15, BET15, ANZ15, EIN15, OPK15, IND15, LGA16, BET16, ANZ16, EIN16, OPK16, IND16, LGA17, BET17, ANZ17, EIN17, OPK17, IND17, LGA18, BET18, ANZ18, EIN18, OPK18, IND18, LGA19, BET19, ANZ19, EIN19, OPK19, IND19, LGA20, BET20, ANZ20, EIN20, OPK20, IND20, LGA21, BET21, ANZ21, EIN21, OPK21, IND21, LGA22, BET22, ANZ22, EIN22, OPK22, IND22, LGA23, BET23, ANZ23, EIN23, OPK23, IND23, LGA24, BET24, ANZ24, EIN24, OPK24, IND24, LGA25, BET25, ANZ25, EIN25, OPK25, IND25, LGA26, BET26, ANZ26, EIN26, OPK26, IND26, LGA27, BET27, ANZ27, EIN27, OPK27, IND27, LGA28, BET28, ANZ28, EIN28, OPK28, IND28, LGA29, BET29, ANZ29, EIN29, OPK29, IND29, LGA30, BET30, ANZ30, EIN30, OPK30, IND30, LGA31, BET31, ANZ31, EIN31, OPK31, IND31, LGA32, BET32, ANZ32, EIN32, OPK32, IND32, LGA33, BET33, ANZ33, EIN33, OPK33, IND33, LGA34, BET34, ANZ34, EIN34, OPK34, IND34, LGA35, BET35, ANZ35, EIN35, OPK35, IND35, LGA36, BET36, ANZ36, EIN36, OPK36, IND36, LGA37, BET37, ANZ37, EIN37, OPK37, IND37, LGA38, BET38, ANZ38, EIN38, OPK38, IND38, LGA39, BET39, ANZ39, EIN39, OPK39, IND39, LGA40, BET40, ANZ40, EIN40, OPK40, IND40, SCHKZ, WERKS, BTRTL, PERSG, PERSK, ORGEH, PLANS, STELL, TRFAR, TRFGB, TRFGR, TRFST, BSGRD, COSCA, DASCA, IND00, WERMS, BTRMS, PLAMS, STEMS, TRFGR_S, LGM01, INDM1, LGM02, INDM2, LGM03, INDM3, LGM04, INDM4, LGM05, INDM5, LGM06, INDM6, LGM07, INDM7, LGM08, INDM8, LGM09, INDM9, LGM10, INDM10, LGM11, INDM11, LGM12, INDM12, LGM13, INDM13, LGM14, INDM14, LGM15, INDM15, LGM16, INDM16, LGM17, INDM17, LGM18, INDM18, LGM19, INDM19, LGM20, INDM20, ZUORD, REFDATE, DOC_NUM0014, DOC_NUM0015 FROM PA3214

TOP ERP 6.0 | PA3214 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	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
25	LGA01	Wage Type	nvarchar	4	0	Allow NULL?
26	BET01	Wage Type Amount for Payments	decimal	13	2
27	ANZ01	Number	decimal	7	2
28	EIN01	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
29	OPK01	Operation Indicator for Wage Types	char	1	0	Allow NULL?
30	IND01	Indicator for indirect valuation	char	1	0	Allow NULL?
31	LGA02	Wage type	nvarchar	4	0	Allow NULL?
32	BET02	Wage Type Amount for Payments	decimal	13	2
33	ANZ02	Number	decimal	7	2
34	EIN02	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
35	OPK02	Operation Indicator for Wage Types	char	1	0	Allow NULL?
36	IND02	Indicator for indirect valuation	char	1	0	Allow NULL?
37	LGA03	Wage type	nvarchar	4	0	Allow NULL?
38	BET03	Wage Type Amount for Payments	decimal	13	2
39	ANZ03	Number	decimal	7	2
40	EIN03	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
41	OPK03	Operation Indicator for Wage Types	char	1	0	Allow NULL?
42	IND03	Indicator for indirect valuation	char	1	0	Allow NULL?
43	LGA04	Wage type	nvarchar	4	0	Allow NULL?
44	BET04	Wage Type Amount for Payments	decimal	13	2
45	ANZ04	Number	decimal	7	2
46	EIN04	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
47	OPK04	Operation Indicator for Wage Types	char	1	0	Allow NULL?
48	IND04	Indicator for indirect valuation	char	1	0	Allow NULL?
49	LGA05	Wage type	nvarchar	4	0	Allow NULL?
50	BET05	Wage Type Amount for Payments	decimal	13	2
51	ANZ05	Number	decimal	7	2
52	EIN05	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
53	OPK05	Operation Indicator for Wage Types	char	1	0	Allow NULL?
54	IND05	Indicator for indirect valuation	char	1	0	Allow NULL?
55	LGA06	Wage type	nvarchar	4	0	Allow NULL?
56	BET06	Wage Type Amount for Payments	decimal	13	2
57	ANZ06	Number	decimal	7	2
58	EIN06	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
59	OPK06	Operation Indicator for Wage Types	char	1	0	Allow NULL?
60	IND06	Indicator for indirect valuation	char	1	0	Allow NULL?
61	LGA07	Wage type	nvarchar	4	0	Allow NULL?
62	BET07	Wage Type Amount for Payments	decimal	13	2
63	ANZ07	Number	decimal	7	2
64	EIN07	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
65	OPK07	Operation Indicator for Wage Types	char	1	0	Allow NULL?
66	IND07	Indicator for indirect valuation	char	1	0	Allow NULL?
67	LGA08	Wage type	nvarchar	4	0	Allow NULL?
68	BET08	Wage Type Amount for Payments	decimal	13	2
69	ANZ08	Number	decimal	7	2
70	EIN08	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
71	OPK08	Operation Indicator for Wage Types	char	1	0	Allow NULL?
72	IND08	Indicator for indirect valuation	char	1	0	Allow NULL?
73	LGA09	Wage type	nvarchar	4	0	Allow NULL?
74	BET09	Wage Type Amount for Payments	decimal	13	2
75	ANZ09	Number	decimal	7	2
76	EIN09	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
77	OPK09	Operation Indicator for Wage Types	char	1	0	Allow NULL?
78	IND09	Indicator for indirect valuation	char	1	0	Allow NULL?
79	LGA10	Wage type	nvarchar	4	0	Allow NULL?
80	BET10	Wage Type Amount for Payments	decimal	13	2
81	ANZ10	Number	decimal	7	2
82	EIN10	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
83	OPK10	Operation Indicator for Wage Types	char	1	0	Allow NULL?
84	IND10	Indicator for indirect valuation	char	1	0	Allow NULL?
85	LGA11	Wage type	nvarchar	4	0	Allow NULL?
86	BET11	Wage Type Amount for Payments	decimal	13	2
87	ANZ11	Number	decimal	7	2
88	EIN11	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
89	OPK11	Operation Indicator for Wage Types	char	1	0	Allow NULL?
90	IND11	Indicator for indirect valuation	char	1	0	Allow NULL?
91	LGA12	Wage type	nvarchar	4	0	Allow NULL?
92	BET12	Wage Type Amount for Payments	decimal	13	2
93	ANZ12	Number	decimal	7	2
94	EIN12	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
95	OPK12	Operation Indicator for Wage Types	char	1	0	Allow NULL?
96	IND12	Indicator for indirect valuation	char	1	0	Allow NULL?
97	LGA13	Wage type	nvarchar	4	0	Allow NULL?
98	BET13	Wage Type Amount for Payments	decimal	13	2
99	ANZ13	Number	decimal	7	2
100	EIN13	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
101	OPK13	Operation Indicator for Wage Types	char	1	0	Allow NULL?
102	IND13	Indicator for indirect valuation	char	1	0	Allow NULL?
103	LGA14	Wage type	nvarchar	4	0	Allow NULL?
104	BET14	Wage Type Amount for Payments	decimal	13	2
105	ANZ14	Number	decimal	7	2
106	EIN14	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
107	OPK14	Operation Indicator for Wage Types	char	1	0	Allow NULL?
108	IND14	Indicator for indirect valuation	char	1	0	Allow NULL?
109	LGA15	Wage type	nvarchar	4	0	Allow NULL?
110	BET15	Wage Type Amount for Payments	decimal	13	2
111	ANZ15	Number	decimal	7	2
112	EIN15	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
113	OPK15	Operation Indicator for Wage Types	char	1	0	Allow NULL?
114	IND15	Indicator for indirect valuation	char	1	0	Allow NULL?
115	LGA16	Wage type	nvarchar	4	0	Allow NULL?
116	BET16	Wage Type Amount for Payments	decimal	13	2
117	ANZ16	Number	decimal	7	2
118	EIN16	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
119	OPK16	Operation Indicator for Wage Types	char	1	0	Allow NULL?
120	IND16	Indicator for indirect valuation	char	1	0	Allow NULL?
121	LGA17	Wage type	nvarchar	4	0	Allow NULL?
122	BET17	Wage Type Amount for Payments	decimal	13	2
123	ANZ17	Number	decimal	7	2
124	EIN17	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
125	OPK17	Operation Indicator for Wage Types	char	1	0	Allow NULL?
126	IND17	Indicator for indirect valuation	char	1	0	Allow NULL?
127	LGA18	Wage type	nvarchar	4	0	Allow NULL?
128	BET18	Wage Type Amount for Payments	decimal	13	2
129	ANZ18	Number	decimal	7	2
130	EIN18	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
131	OPK18	Operation Indicator for Wage Types	char	1	0	Allow NULL?
132	IND18	Indicator for indirect valuation	char	1	0	Allow NULL?
133	LGA19	Wage type	nvarchar	4	0	Allow NULL?
134	BET19	Wage Type Amount for Payments	decimal	13	2
135	ANZ19	Number	decimal	7	2
136	EIN19	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
137	OPK19	Operation Indicator for Wage Types	char	1	0	Allow NULL?
138	IND19	Indicator for indirect valuation	char	1	0	Allow NULL?
139	LGA20	Wage type	nvarchar	4	0	Allow NULL?
140	BET20	Wage Type Amount for Payments	decimal	13	2
141	ANZ20	Number	decimal	7	2
142	EIN20	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
143	OPK20	Operation Indicator for Wage Types	char	1	0	Allow NULL?
144	IND20	Indicator for indirect valuation	char	1	0	Allow NULL?
145	LGA21	Wage type	nvarchar	4	0	Allow NULL?
146	BET21	Wage Type Amount for Payments	decimal	13	2
147	ANZ21	Number	decimal	7	2
148	EIN21	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
149	OPK21	Operation Indicator for Wage Types	char	1	0	Allow NULL?
150	IND21	Indicator for indirect valuation	char	1	0	Allow NULL?
151	LGA22	Wage type	nvarchar	4	0	Allow NULL?
152	BET22	Wage Type Amount for Payments	decimal	13	2
153	ANZ22	Number	decimal	7	2
154	EIN22	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
155	OPK22	Operation Indicator for Wage Types	char	1	0	Allow NULL?
156	IND22	Indicator for indirect valuation	char	1	0	Allow NULL?
157	LGA23	Wage type	nvarchar	4	0	Allow NULL?
158	BET23	Wage Type Amount for Payments	decimal	13	2
159	ANZ23	Number	decimal	7	2
160	EIN23	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
161	OPK23	Operation Indicator for Wage Types	char	1	0	Allow NULL?
162	IND23	Indicator for indirect valuation	char	1	0	Allow NULL?
163	LGA24	Wage type	nvarchar	4	0	Allow NULL?
164	BET24	Wage Type Amount for Payments	decimal	13	2
165	ANZ24	Number	decimal	7	2
166	EIN24	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
167	OPK24	Operation Indicator for Wage Types	char	1	0	Allow NULL?
168	IND24	Indicator for indirect valuation	char	1	0	Allow NULL?
169	LGA25	Wage type	nvarchar	4	0	Allow NULL?
170	BET25	Wage Type Amount for Payments	decimal	13	2
171	ANZ25	Number	decimal	7	2
172	EIN25	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
173	OPK25	Operation Indicator for Wage Types	char	1	0	Allow NULL?
174	IND25	Indicator for indirect valuation	char	1	0	Allow NULL?
175	LGA26	Wage type	nvarchar	4	0	Allow NULL?
176	BET26	Wage Type Amount for Payments	decimal	13	2
177	ANZ26	Number	decimal	7	2
178	EIN26	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
179	OPK26	Operation Indicator for Wage Types	char	1	0	Allow NULL?
180	IND26	Indicator for indirect valuation	char	1	0	Allow NULL?
181	LGA27	Wage type	nvarchar	4	0	Allow NULL?
182	BET27	Wage Type Amount for Payments	decimal	13	2
183	ANZ27	Number	decimal	7	2
184	EIN27	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
185	OPK27	Operation Indicator for Wage Types	char	1	0	Allow NULL?
186	IND27	Indicator for indirect valuation	char	1	0	Allow NULL?
187	LGA28	Wage type	nvarchar	4	0	Allow NULL?
188	BET28	Wage Type Amount for Payments	decimal	13	2
189	ANZ28	Number	decimal	7	2
190	EIN28	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
191	OPK28	Operation Indicator for Wage Types	char	1	0	Allow NULL?
192	IND28	Indicator for indirect valuation	char	1	0	Allow NULL?
193	LGA29	Wage type	nvarchar	4	0	Allow NULL?
194	BET29	Wage Type Amount for Payments	decimal	13	2
195	ANZ29	Number	decimal	7	2
196	EIN29	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
197	OPK29	Operation Indicator for Wage Types	char	1	0	Allow NULL?
198	IND29	Indicator for indirect valuation	char	1	0	Allow NULL?
199	LGA30	Wage type	nvarchar	4	0	Allow NULL?
200	BET30	Wage Type Amount for Payments	decimal	13	2
201	ANZ30	Number	decimal	7	2
202	EIN30	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
203	OPK30	Operation Indicator for Wage Types	char	1	0	Allow NULL?
204	IND30	Indicator for indirect valuation	char	1	0	Allow NULL?
205	LGA31	Wage type	nvarchar	4	0	Allow NULL?
206	BET31	Wage Type Amount for Payments	decimal	13	2
207	ANZ31	Number	decimal	7	2
208	EIN31	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
209	OPK31	Operation Indicator for Wage Types	char	1	0	Allow NULL?
210	IND31	Indicator for indirect valuation	char	1	0	Allow NULL?
211	LGA32	Wage type	nvarchar	4	0	Allow NULL?
212	BET32	Wage Type Amount for Payments	decimal	13	2
213	ANZ32	Number	decimal	7	2
214	EIN32	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
215	OPK32	Operation Indicator for Wage Types	char	1	0	Allow NULL?
216	IND32	Indicator for indirect valuation	char	1	0	Allow NULL?
217	LGA33	Wage type	nvarchar	4	0	Allow NULL?
218	BET33	Wage Type Amount for Payments	decimal	13	2
219	ANZ33	Number	decimal	7	2
220	EIN33	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
221	OPK33	Operation Indicator for Wage Types	char	1	0	Allow NULL?
222	IND33	Indicator for indirect valuation	char	1	0	Allow NULL?
223	LGA34	Wage type	nvarchar	4	0	Allow NULL?
224	BET34	Wage Type Amount for Payments	decimal	13	2
225	ANZ34	Number	decimal	7	2
226	EIN34	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
227	OPK34	Operation Indicator for Wage Types	char	1	0	Allow NULL?
228	IND34	Indicator for indirect valuation	char	1	0	Allow NULL?
229	LGA35	Wage type	nvarchar	4	0	Allow NULL?
230	BET35	Wage Type Amount for Payments	decimal	13	2
231	ANZ35	Number	decimal	7	2
232	EIN35	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
233	OPK35	Operation Indicator for Wage Types	char	1	0	Allow NULL?
234	IND35	Indicator for indirect valuation	char	1	0	Allow NULL?
235	LGA36	Wage type	nvarchar	4	0	Allow NULL?
236	BET36	Wage Type Amount for Payments	decimal	13	2
237	ANZ36	Number	decimal	7	2
238	EIN36	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
239	OPK36	Operation Indicator for Wage Types	char	1	0	Allow NULL?
240	IND36	Indicator for indirect valuation	char	1	0	Allow NULL?
241	LGA37	Wage type	nvarchar	4	0	Allow NULL?
242	BET37	Wage Type Amount for Payments	decimal	13	2
243	ANZ37	Number	decimal	7	2
244	EIN37	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
245	OPK37	Operation Indicator for Wage Types	char	1	0	Allow NULL?
246	IND37	Indicator for indirect valuation	char	1	0	Allow NULL?
247	LGA38	Wage type	nvarchar	4	0	Allow NULL?
248	BET38	Wage Type Amount for Payments	decimal	13	2
249	ANZ38	Number	decimal	7	2
250	EIN38	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
251	OPK38	Operation Indicator for Wage Types	char	1	0	Allow NULL?
252	IND38	Indicator for indirect valuation	char	1	0	Allow NULL?
253	LGA39	Wage type	nvarchar	4	0	Allow NULL?
254	BET39	Wage Type Amount for Payments	decimal	13	2
255	ANZ39	Number	decimal	7	2
256	EIN39	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
257	OPK39	Operation Indicator for Wage Types	char	1	0	Allow NULL?
258	IND39	Indicator for indirect valuation	char	1	0	Allow NULL?
259	LGA40	Wage type	nvarchar	4	0	Allow NULL?
260	BET40	Wage Type Amount for Payments	decimal	13	2
261	ANZ40	Number	decimal	7	2
262	EIN40	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
263	OPK40	Operation Indicator for Wage Types	char	1	0	Allow NULL?
264	IND40	Indicator for indirect valuation	char	1	0	Allow NULL?
265	SCHKZ	Work Schedule Rule	nvarchar	8	0	Allow NULL?
266	WERKS	Personnel Area	nvarchar	4	0	Allow NULL?
267	BTRTL	Personnel Subarea	nvarchar	4	0	Allow NULL?
268	PERSG	Employee Group	char	1	0	Allow NULL?
269	PERSK	Employee Subgroup	nvarchar	2	0	Allow NULL?
270	ORGEH	Organizational Unit	nvarchar	8	0	Allow NULL?
271	PLANS	Position	nvarchar	8	0	Allow NULL?
272	STELL	Job	nvarchar	8	0	Allow NULL?
273	TRFAR	Pay scale type	nvarchar	2	0	Allow NULL?
274	TRFGB	Pay Scale Area	nvarchar	2	0	Allow NULL?
275	TRFGR	Pay Scale Group	nvarchar	8	0	Allow NULL?
276	TRFST	Pay Scale Level	nvarchar	2	0	Allow NULL?
277	BSGRD	Capacity Utilization Level	decimal	5	2
278	COSCA	Pay scale jump ind.	nvarchar	3	0	Allow NULL?
279	DASCA	Next PayScaleJmp date	nvarchar	8	0	Allow NULL?
280	IND00	Checkbox	char	1	0	Allow NULL?
281	WERMS	Personnel Area	nvarchar	4	0	Allow NULL?
282	BTRMS	Personnel Subarea	nvarchar	4	0	Allow NULL?
283	PLAMS	Position	nvarchar	8	0	Allow NULL?
284	STEMS	Job	nvarchar	8	0	Allow NULL?
285	TRFGR_S	Pay Scale Group	nvarchar	8	0	Allow NULL?
286	LGM01	Wage type	nvarchar	4	0	Allow NULL?
287	INDM1	Checkbox	char	1	0	Allow NULL?
288	LGM02	Wage type	nvarchar	4	0	Allow NULL?
289	INDM2	Checkbox	char	1	0	Allow NULL?
290	LGM03	Wage type	nvarchar	4	0	Allow NULL?
291	INDM3	Checkbox	char	1	0	Allow NULL?
292	LGM04	Wage type	nvarchar	4	0	Allow NULL?
293	INDM4	Checkbox	char	1	0	Allow NULL?
294	LGM05	Wage type	nvarchar	4	0	Allow NULL?
295	INDM5	Checkbox	char	1	0	Allow NULL?
296	LGM06	Wage type	nvarchar	4	0	Allow NULL?
297	INDM6	Checkbox	char	1	0	Allow NULL?
298	LGM07	Wage type	nvarchar	4	0	Allow NULL?
299	INDM7	Checkbox	char	1	0	Allow NULL?
300	LGM08	Wage type	nvarchar	4	0	Allow NULL?
301	INDM8	Checkbox	char	1	0	Allow NULL?
302	LGM09	Wage type	nvarchar	4	0	Allow NULL?
303	INDM9	Checkbox	char	1	0	Allow NULL?
304	LGM10	Wage type	nvarchar	4	0	Allow NULL?
305	INDM10	Checkbox	char	1	0	Allow NULL?
306	LGM11	Wage type	nvarchar	4	0	Allow NULL?
307	INDM11	Checkbox	char	1	0	Allow NULL?
308	LGM12	Wage type	nvarchar	4	0	Allow NULL?
309	INDM12	Checkbox	char	1	0	Allow NULL?
310	LGM13	Wage type	nvarchar	4	0	Allow NULL?
311	INDM13	Checkbox	char	1	0	Allow NULL?
312	LGM14	Wage type	nvarchar	4	0	Allow NULL?
313	INDM14	Checkbox	char	1	0	Allow NULL?
314	LGM15	Wage type	nvarchar	4	0	Allow NULL?
315	INDM15	Checkbox	char	1	0	Allow NULL?
316	LGM16	Wage type	nvarchar	4	0	Allow NULL?
317	INDM16	Checkbox	char	1	0	Allow NULL?
318	LGM17	Wage type	nvarchar	4	0	Allow NULL?
319	INDM17	Checkbox	char	1	0	Allow NULL?
320	LGM18	Wage type	nvarchar	4	0	Allow NULL?
321	INDM18	Checkbox	char	1	0	Allow NULL?
322	LGM19	Wage type	nvarchar	4	0	Allow NULL?
323	INDM19	Checkbox	char	1	0	Allow NULL?
324	LGM20	Wage type	nvarchar	4	0	Allow NULL?
325	INDM20	Checkbox	char	1	0	Allow NULL?
326	ZUORD	Legal Act Assignment Number	nvarchar	20	0	Allow NULL?
327	REFDATE	Field of type DATS	nvarchar	8	0	Allow NULL?
328	DOC_NUM0014		nvarchar	20	0	Allow NULL?
329	DOC_NUM0015		nvarchar	20	0	Allow NULL?

TOP ERP 6.0 | PA3214 INDEXES

Name	Primary	Unique	Type	Columns
PA3214~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

329 COLUMNS | 1 INDEXES | ERP 6.0 | PA3214 TABLE

TOP ERP 6.0 | PA3214 COLUMNS

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

329 COLUMNS | 1 INDEXES | ERP 6.0 | PA3214 TABLE

TOPERP 6.0 | PA3214 COLUMNS

TOPERP 6.0 | PA3214 INDEXES

TOP ERP 6.0 | PA3214 COLUMNS

TOP ERP 6.0 | PA3214 INDEXES