	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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

	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

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