	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

239 COLUMNS | 1 INDEXES | ERP 6.0 | PA3202 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: South Africa
1	ERP EHP7	6.0	PA3202	239	1	HR Master Record: Infotype 3202	South Africa

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, LRTYP, STATU, CASNR, REASN, DATEP, EXTRF, PARES01, PAOBT01, PAOBJ01, PAROL01, PABEG01, PAEND01, PARES02, PAOBT02, PAOBJ02, PAROL02, PABEG02, PAEND02, PARES03, PAOBT03, PAOBJ03, PAROL03, PABEG03, PAEND03, PARES04, PAOBT04, PAOBJ04, PAROL04, PABEG04, PAEND04, PARES05, PAOBT05, PAOBJ05, PAROL05, PABEG05, PAEND05, PARES06, PAOBT06, PAOBJ06, PAROL06, PABEG06, PAEND06, PARES07, PAOBT07, PAOBJ07, PAROL07, PABEG07, PAEND07, PARES08, PAOBT08, PAOBJ08, PAROL08, PABEG08, PAEND08, PARES09, PAOBT09, PAOBJ09, PAROL09, PABEG09, PAEND09, PARES10, PAOBT10, PAOBJ10, PAROL10, PABEG10, PAEND10, PARES11, PAOBT11, PAOBJ11, PAROL11, PABEG11, PAEND11, PARES12, PAOBT12, PAOBJ12, PAROL12, PABEG12, PAEND12, PARES13, PAOBT13, PAOBJ13, PAROL13, PABEG13, PAEND13, PARES14, PAOBT14, PAOBJ14, PAROL14, PABEG14, PAEND14, PARES15, PAOBT15, PAOBJ15, PAROL15, PABEG15, PAEND15, PRSTA01, PRBEG01, PREND01, PRREA01, PRSTA02, PRBEG02, PREND02, PRREA02, PRSTA03, PRBEG03, PREND03, PRREA03, PRSTA04, PRBEG04, PREND04, PRREA04, PRSTA05, PRBEG05, PREND05, PRREA05, PRSTA06, PRBEG06, PREND06, PRREA06, PRSTA07, PRBEG07, PREND07, PRREA07, PRSTA08, PRBEG08, PREND08, PRREA08, PRSTA09, PRBEG09, PREND09, PRREA09, PRSTA10, PRBEG10, PREND10, PRREA10, PRSTA11, PRBEG11, PREND11, PRREA11, PRSTA12, PRBEG12, PREND12, PRREA12, PRSTA13, PRBEG13, PREND13, PRREA13, PRSTA14, PRBEG14, PREND14, PRREA14, PRSTA15, PRBEG15, PREND15, PRREA15, OCTYP01, OCBEG01, OCEND01, OCAGR01, OCTYP02, OCBEG02, OCEND02, OCAGR02, OCTYP03, OCBEG03, OCEND03, OCAGR03, OCTYP04, OCBEG04, OCEND04, OCAGR04, OCTYP05, OCBEG05, OCEND05, OCAGR05, OCTYP06, OCBEG06, OCEND06, OCAGR06, OCTYP07, OCBEG07, OCEND07, OCAGR07, OCTYP08, OCBEG08, OCEND08, OCAGR08, OCTYP09, OCBEG09, OCEND09, OCAGR09, OCTYP10, OCBEG10, OCEND10, OCAGR10, OCTYP11, OCBEG11, OCEND11, OCAGR11, OCTYP12, OCBEG12, OCEND12, OCAGR12, OCTYP13, OCBEG13, OCEND13, OCAGR13, OCTYP14, OCBEG14, OCEND14, OCAGR14, OCTYP15, OCBEG15, OCEND15, OCAGR15 FROM PA3202

TOP ERP 6.0 | PA3202 COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	NUMC	(N'00000000')	No	PA0003	PERSNO	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	CHAR	(N' ')	No		SUBTY	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	CHAR	(N' ')	No		OBJPS	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	CHAR	(N' ')	No		SPRPS	Allow NULL?
6	ENDDA	End Date	nvarchar	8	DATS	(N'00000000')	No		ENDDA	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	DATS	(N'00000000')	No		BEGDA	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	NUMC	(N'000')	No		SEQNR	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	CHAR	(N' ')	Yes		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	CHAR	(N' ')	Yes		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	CHAR	(N' ')	Yes		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	CHAR	(N' ')	Yes		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	CHAR	(N' ')	Yes		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	CHAR	(N' ')	Yes		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	CHAR	(N' ')	Yes	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	LRTYP	Labour Relations Type	nvarchar	4	CHAR	(N' ')	Yes	*	P16_LRTYP	Allow NULL?
25	STATU	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	T5W9S	P16_LRSTAT	Allow NULL?
26	CASNR	Case Number (Labour Relations ZA)	nvarchar	12	NUMC	(N'000000000000')	Yes		P16_LRCASNR	Allow NULL?
27	REASN	Reason for / Nature of Labour Relations intervention	nvarchar	3	NUMC	(N'000')	Yes	T5W9R	P16_LRREAS	Allow NULL?
28	DATEP	Actual date of act/omission/misconduct	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRDATEP	Allow NULL?
29	EXTRF	External Case/Reference number	nvarchar	20	CHAR	(N' ')	Yes		P16_LREXTRF	Allow NULL?
30	PARES01	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
31	PAOBT01	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
32	PAOBJ01	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
33	PAROL01	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
34	PABEG01	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
35	PAEND01	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
36	PARES02	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
37	PAOBT02	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
38	PAOBJ02	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
39	PAROL02	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
40	PABEG02	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
41	PAEND02	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
42	PARES03	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
43	PAOBT03	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
44	PAOBJ03	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
45	PAROL03	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
46	PABEG03	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
47	PAEND03	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
48	PARES04	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
49	PAOBT04	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
50	PAOBJ04	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
51	PAROL04	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
52	PABEG04	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
53	PAEND04	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
54	PARES05	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
55	PAOBT05	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
56	PAOBJ05	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
57	PAROL05	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
58	PABEG05	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
59	PAEND05	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
60	PARES06	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
61	PAOBT06	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
62	PAOBJ06	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
63	PAROL06	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
64	PABEG06	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
65	PAEND06	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
66	PARES07	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
67	PAOBT07	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
68	PAOBJ07	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
69	PAROL07	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
70	PABEG07	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
71	PAEND07	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
72	PARES08	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
73	PAOBT08	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
74	PAOBJ08	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
75	PAROL08	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
76	PABEG08	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
77	PAEND08	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
78	PARES09	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
79	PAOBT09	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
80	PAOBJ09	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
81	PAROL09	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
82	PABEG09	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
83	PAEND09	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
84	PARES10	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
85	PAOBT10	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
86	PAOBJ10	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
87	PAROL10	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
88	PABEG10	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
89	PAEND10	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
90	PARES11	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
91	PAOBT11	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
92	PAOBJ11	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
93	PAROL11	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
94	PABEG11	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
95	PAEND11	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
96	PARES12	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
97	PAOBT12	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
98	PAOBJ12	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
99	PAROL12	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
100	PABEG12	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
101	PAEND12	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
102	PARES13	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
103	PAOBT13	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
104	PAOBJ13	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
105	PAROL13	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
106	PABEG13	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
107	PAEND13	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
108	PARES14	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
109	PAOBT14	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
110	PAOBJ14	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
111	PAROL14	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
112	PABEG14	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
113	PAEND14	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
114	PARES15	Current responsible party for a Lab.Rel case	char	1	CHAR	(N' ')	Yes		P16_LRRESPO	Allow NULL?
115	PAOBT15	Object Type	nvarchar	2	CHAR	(N' ')	Yes	*	OTYPE	Allow NULL?
116	PAOBJ15	Object ID	nvarchar	8	NUMC	(N'00000000')	Yes	*	HROBJID	Allow NULL?
117	PAROL15	Participating Role in Labour Relation Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRROLE	Allow NULL?
118	PABEG15	LR Participant : Begin date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPABEG	Allow NULL?
119	PAEND15	LR Participant : End date of participation	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPAEND	Allow NULL?
120	PRSTA01	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
121	PRBEG01	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
122	PREND01	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
123	PRREA01	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
124	PRSTA02	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
125	PRBEG02	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
126	PREND02	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
127	PRREA02	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
128	PRSTA03	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
129	PRBEG03	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
130	PREND03	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
131	PRREA03	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
132	PRSTA04	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
133	PRBEG04	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
134	PREND04	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
135	PRREA04	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
136	PRSTA05	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
137	PRBEG05	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
138	PREND05	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
139	PRREA05	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
140	PRSTA06	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
141	PRBEG06	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
142	PREND06	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
143	PRREA06	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
144	PRSTA07	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
145	PRBEG07	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
146	PREND07	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
147	PRREA07	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
148	PRSTA08	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
149	PRBEG08	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
150	PREND08	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
151	PRREA08	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
152	PRSTA09	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
153	PRBEG09	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
154	PREND09	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
155	PRREA09	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
156	PRSTA10	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
157	PRBEG10	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
158	PREND10	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
159	PRREA10	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
160	PRSTA11	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
161	PRBEG11	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
162	PREND11	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
163	PRREA11	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
164	PRSTA12	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
165	PRBEG12	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
166	PREND12	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
167	PRREA12	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
168	PRSTA13	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
169	PRBEG13	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
170	PREND13	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
171	PRREA13	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
172	PRSTA14	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
173	PRBEG14	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
174	PREND14	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
175	PRREA14	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
176	PRSTA15	Status/Level of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LRSTAT	Allow NULL?
177	PRBEG15	LR Process : Begin Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPRBEG	Allow NULL?
178	PREND15	LR Process : End Date of an intervention	nvarchar	8	DATS	(N'00000000')	Yes		P16_LRPREND	Allow NULL?
179	PRREA15	LR Process : Reaction Timeframe (days)	nvarchar	4	NUMC	(N'0000')	Yes		P16_LRREATF	Allow NULL?
180	OCTYP01	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
181	OCBEG01	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
182	OCEND01	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
183	OCAGR01	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
184	OCTYP02	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
185	OCBEG02	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
186	OCEND02	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
187	OCAGR02	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
188	OCTYP03	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
189	OCBEG03	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
190	OCEND03	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
191	OCAGR03	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
192	OCTYP04	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
193	OCBEG04	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
194	OCEND04	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
195	OCAGR04	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
196	OCTYP05	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
197	OCBEG05	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
198	OCEND05	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
199	OCAGR05	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
200	OCTYP06	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
201	OCBEG06	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
202	OCEND06	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
203	OCAGR06	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
204	OCTYP07	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
205	OCBEG07	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
206	OCEND07	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
207	OCAGR07	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
208	OCTYP08	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
209	OCBEG08	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
210	OCEND08	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
211	OCAGR08	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
212	OCTYP09	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
213	OCBEG09	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
214	OCEND09	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
215	OCAGR09	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
216	OCTYP10	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
217	OCBEG10	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
218	OCEND10	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
219	OCAGR10	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
220	OCTYP11	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
221	OCBEG11	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
222	OCEND11	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
223	OCAGR11	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
224	OCTYP12	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
225	OCBEG12	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
226	OCEND12	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
227	OCAGR12	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
228	OCTYP13	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
229	OCBEG13	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
230	OCEND13	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
231	OCAGR13	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
232	OCTYP14	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
233	OCBEG14	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
234	OCEND14	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
235	OCAGR14	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?
236	OCTYP15	Outcome of Labour Relations Intervention	nvarchar	3	NUMC	(N'000')	Yes	*	P16_LROUCT	Allow NULL?
237	OCBEG15	LR Outcome : Begin date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCBEG	Allow NULL?
238	OCEND15	LR Outcome : End date of an outcome/resolution	nvarchar	8	DATS	(N'00000000')	Yes		P16_OCEND	Allow NULL?
239	OCAGR15	LR Outcome : Employee accepted Outcome	char	1	CHAR	(N' ')	Yes		P16_OCAGR	Allow NULL?

TOP ERP 6.0 | PA3202 INDEXES

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

239 COLUMNS | 1 INDEXES | ERP 6.0 | PA3202 TABLE

TOP ERP 6.0 | PA3202 COLUMNS

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

239 COLUMNS | 1 INDEXES | ERP 6.0 | PA3202 TABLE

TOPERP 6.0 | PA3202 COLUMNS

TOPERP 6.0 | PA3202 INDEXES

TOP ERP 6.0 | PA3202 COLUMNS

TOP ERP 6.0 | PA3202 INDEXES