	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

251 COLUMNS | 1 INDEXES | ERP 6.0 | PA3743 TABLE

ERP EHP7

6.0

251

HR Master Record: Infotype 3743

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, OFFDT, OFFSR, INVDT, DIACD, DAKCR, OFFC1, OFFC2, OFFC3, OFFC4, OFFC5, INBD1, INED1, INRE1, SUBSA1, INBD2, INED2, INRE2, SUBSA2, INBD3, INED3, INRE3, SUBSA3, INVPR, CORES1, ISSDT1, RESDT1, CORES2, ISSDT2, RESDT2, CORES3, ISSDT3, RESDT3, CORES4, ISSDT4, RESDT4, DPREQ, AREPTY1, AOBJTY1, APERNR1, AREPTY2, AOBJTY2, APERNR2, AREPTY3, AOBJTY3, APERNR3, AREPTY4, AOBJTY4, APERNR4, AREPTY5, AOBJTY5, APERNR5, AREPTY6, AOBJTY6, APERNR6, AREPTY7, AOBJTY7, APERNR7, A_HEABD, A_HEAED, A_STATUS, A_NHEDB, AOUCD1, AOUCD2, AOUCD3, AOUCD4, AOUDE1, AOUDF1, AOUDR1, AOUMT1, AOUAT1, AOUDE2, AOUDF2, AOUDR2, AOUMT2, AOUAT2, AOUDE3, AOUDF3, AOUDR3, AOUMT3, AOUAT3, AOUDE4, AOUDF4, AOUDR4, AOUMT4, AOUAT4, FOUCD1, FOUCD2, FOUCD3, FOUCD4, FOUDE1, FOUDF1, FOUDR1, FOUMT1, FOUAT1, FOUDE2, FOUDF2, FOUDR2, FOUMT2, FOUAT2, FOUDE3, FOUDF3, FOUDR3, FOUMT3, FOUAT3, FOUDE4, FOUDF4, FOUDR4, FOUMT4, FOUAT4, WAERS, BREPTY1, BOBJTY1, BPERNR1, BREPTY2, BOBJTY2, BPERNR2, BREPTY3, BOBJTY3, BPERNR3, BREPTY4, BOBJTY4, BPERNR4, BREPTY5, BOBJTY5, BPERNR5, BREPTY6, BOBJTY6, BPERNR6, BREPTY7, BOBJTY7, BPERNR7, B_HEABD, B_HEAED, B_STATUS, B_NHEDB, BOUCD1, BOUCD2, BOUCD3, BOUCD4, BOUDE1, BOUDF1, BOUDR1, BOUMT1, BOUAT1, BOUDE2, BOUDF2, BOUDR2, BOUMT2, BOUAT2, BOUDE3, BOUDF3, BOUDR3, BOUMT3, BOUAT3, BOUDE4, BOUDF4, BOUDR4, BOUMT4, BOUAT4, CREPTY1, COBJTY1, CPERNR1, CREPTY2, COBJTY2, CPERNR2, CREPTY3, COBJTY3, CPERNR3, CREPTY4, COBJTY4, CPERNR4, CREPTY5, COBJTY5, CPERNR5, CREPTY6, COBJTY6, CPERNR6, CREPTY7, COBJTY7, CPERNR7, C_HEABD, C_HEAED, C_STATUS, C_NHEDB, COUCD1, COUCD2, COUCD3, COUCD4, COUDE1, COUDF1, COUDR1, COUMT1, COUAT1, COUDE2, COUDF2, COUDR2, COUMT2, COUAT2, COUDE3, COUDF3, COUDR3, COUMT3, COUAT3, COUDE4, COUDF4, COUDR4, COUMT4, COUAT4, CASNR, AWAERS1, AWAERS2, AWAERS3, AWAERS4, BWAERS1, BWAERS2, BWAERS3, BWAERS4, CWAERS1, CWAERS2, CWAERS3, CWAERS4, FWAERS1, FWAERS2, FWAERS3, FWAERS4, INVPR2, INVPR3, INVPR4 FROM PA3743

TOP ERP 6.0 | PA3743 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	*	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	OFFDT	Date of offence	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OFFDT	Allow NULL?
25	OFFSR	HR IN PS: Offence Details Source	nvarchar	2	0	CHAR	(N' ')	Yes	*	PIN_OFFSR	Allow NULL?
26	INVDT	Begin date of investigation	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INVDT	Allow NULL?
27	DIACD	Type of Disciplinary Action	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_DIACD	Allow NULL?
28	DAKCR	Date of acknowledgement of charge	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_DAKCR	Allow NULL?
29	OFFC1	Offence code	nvarchar	4	0	CHAR	(N' ')	Yes	*	PIN_OFFCD	Allow NULL?
30	OFFC2	Offence code	nvarchar	4	0	CHAR	(N' ')	Yes	*	PIN_OFFCD	Allow NULL?
31	OFFC3	Offence code	nvarchar	4	0	CHAR	(N' ')	Yes	*	PIN_OFFCD	Allow NULL?
32	OFFC4	Offence code	nvarchar	4	0	CHAR	(N' ')	Yes	*	PIN_OFFCD	Allow NULL?
33	OFFC5	Offence code	nvarchar	4	0	CHAR	(N' ')	Yes	*	PIN_OFFCD	Allow NULL?
34	INBD1	Begin date of Suspension	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INTBD	Allow NULL?
35	INED1	End date of Suspension	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INTED	Allow NULL?
36	INRE1	Effective date of restoration	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INTRE	Allow NULL?
37	SUBSA1	HR IN PS: Subsistence Allowance.	char	1	0	CHAR	(N' ')	Yes		PIN_SUBSA	Allow NULL?
38	INBD2	Begin date of Suspension	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INTBD	Allow NULL?
39	INED2	End date of Suspension	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INTED	Allow NULL?
40	INRE2	Effective date of restoration	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INTRE	Allow NULL?
41	SUBSA2	HR IN PS: Subsistence Allowance.	char	1	0	CHAR	(N' ')	Yes		PIN_SUBSA	Allow NULL?
42	INBD3	Begin date of Suspension	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INTBD	Allow NULL?
43	INED3	End date of Suspension	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INTED	Allow NULL?
44	INRE3	Effective date of restoration	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_INTRE	Allow NULL?
45	SUBSA3	HR IN PS: Subsistence Allowance.	char	1	0	CHAR	(N' ')	Yes		PIN_SUBSA	Allow NULL?
46	INVPR	Investigating officer's per no.	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PIN_INVPR	Allow NULL?
47	CORES1	HR IN PS: Correspondence	char	1	0	CHAR	(N' ')	Yes	*	PIN_CORES	Allow NULL?
48	ISSDT1	HR IN PS: Notification Issue date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_ISDT	Allow NULL?
49	RESDT1	HR IN PS: Response Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_RSDT	Allow NULL?
50	CORES2	HR IN PS: Correspondence	char	1	0	CHAR	(N' ')	Yes	*	PIN_CORES	Allow NULL?
51	ISSDT2	HR IN PS: Notification Issue date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_ISDT	Allow NULL?
52	RESDT2	HR IN PS: Response Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_RSDT	Allow NULL?
53	CORES3	HR IN PS: Correspondence	char	1	0	CHAR	(N' ')	Yes	*	PIN_CORES	Allow NULL?
54	ISSDT3	HR IN PS: Notification Issue date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_ISDT	Allow NULL?
55	RESDT3	HR IN PS: Response Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_RSDT	Allow NULL?
56	CORES4	HR IN PS: Correspondence	char	1	0	CHAR	(N' ')	Yes	*	PIN_CORES	Allow NULL?
57	ISSDT4	HR IN PS: Notification Issue date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_ISDT	Allow NULL?
58	RESDT4	HR IN PS: Response Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_RSDT	Allow NULL?
59	DPREQ	HR IN PS: Disciplinary Proceeding Required	char	1	0	CHAR	(N' ')	Yes		PIN_DPREQ	Allow NULL?
60	AREPTY1	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
61	AOBJTY1	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
62	APERNR1	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
63	AREPTY2	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
64	AOBJTY2	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
65	APERNR2	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
66	AREPTY3	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
67	AOBJTY3	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
68	APERNR3	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
69	AREPTY4	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
70	AOBJTY4	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
71	APERNR4	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
72	AREPTY5	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
73	AOBJTY5	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
74	APERNR5	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
75	AREPTY6	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
76	AOBJTY6	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
77	APERNR6	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
78	AREPTY7	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
79	AOBJTY7	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
80	APERNR7	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
81	A_HEABD	Start date of Inquiry Period	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_HEABD	Allow NULL?
82	A_HEAED	End date of Inquiry Period	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_HEAED	Allow NULL?
83	A_STATUS	Status of the Disciplinary Action	nvarchar	3	0	NUMC	(N'000')	Yes	*	PIN_STAT	Allow NULL?
84	A_NHEDB	HR IN PS: Next Hearing Begin Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_NHEBD	Allow NULL?
85	AOUCD1	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
86	AOUCD2	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
87	AOUCD3	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
88	AOUCD4	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
89	AOUDE1	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
90	AOUDF1	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
91	AOUDR1	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
92	AOUMT1	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
93	AOUAT1	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
94	AOUDE2	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
95	AOUDF2	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
96	AOUDR2	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
97	AOUMT2	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
98	AOUAT2	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
99	AOUDE3	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
100	AOUDF3	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
101	AOUDR3	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
102	AOUMT3	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
103	AOUAT3	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
104	AOUDE4	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
105	AOUDF4	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
106	AOUDR4	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
107	AOUMT4	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
108	AOUAT4	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
109	FOUCD1	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
110	FOUCD2	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
111	FOUCD3	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
112	FOUCD4	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
113	FOUDE1	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
114	FOUDF1	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
115	FOUDR1	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
116	FOUMT1	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
117	FOUAT1	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
118	FOUDE2	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
119	FOUDF2	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
120	FOUDR2	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
121	FOUMT2	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
122	FOUAT2	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
123	FOUDE3	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
124	FOUDF3	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
125	FOUDR3	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
126	FOUMT3	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
127	FOUAT3	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
128	FOUDE4	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
129	FOUDF4	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
130	FOUDR4	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
131	FOUMT4	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
132	FOUAT4	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
133	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
134	BREPTY1	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
135	BOBJTY1	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
136	BPERNR1	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
137	BREPTY2	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
138	BOBJTY2	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
139	BPERNR2	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
140	BREPTY3	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
141	BOBJTY3	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
142	BPERNR3	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
143	BREPTY4	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
144	BOBJTY4	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
145	BPERNR4	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
146	BREPTY5	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
147	BOBJTY5	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
148	BPERNR5	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
149	BREPTY6	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
150	BOBJTY6	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
151	BPERNR6	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
152	BREPTY7	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
153	BOBJTY7	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
154	BPERNR7	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
155	B_HEABD	Start date of Inquiry Period	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_HEABD	Allow NULL?
156	B_HEAED	End date of Inquiry Period	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_HEAED	Allow NULL?
157	B_STATUS	Status of the Disciplinary Action	nvarchar	3	0	NUMC	(N'000')	Yes	*	PIN_STAT	Allow NULL?
158	B_NHEDB	HR IN PS: Next Hearing Begin Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_NHEBD	Allow NULL?
159	BOUCD1	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
160	BOUCD2	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
161	BOUCD3	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
162	BOUCD4	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
163	BOUDE1	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
164	BOUDF1	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
165	BOUDR1	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
166	BOUMT1	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
167	BOUAT1	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
168	BOUDE2	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
169	BOUDF2	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
170	BOUDR2	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
171	BOUMT2	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
172	BOUAT2	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
173	BOUDE3	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
174	BOUDF3	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
175	BOUDR3	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
176	BOUMT3	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
177	BOUAT3	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
178	BOUDE4	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
179	BOUDF4	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
180	BOUDR4	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
181	BOUMT4	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
182	BOUAT4	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
183	CREPTY1	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
184	COBJTY1	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
185	CPERNR1	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
186	CREPTY2	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
187	COBJTY2	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
188	CPERNR2	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
189	CREPTY3	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
190	COBJTY3	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
191	CPERNR3	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
192	CREPTY4	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
193	COBJTY4	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
194	CPERNR4	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
195	CREPTY5	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
196	COBJTY5	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
197	CPERNR5	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
198	CREPTY6	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
199	COBJTY6	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
200	CPERNR6	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
201	CREPTY7	Type of representation for officer	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_TYPER	Allow NULL?
202	COBJTY7	HR IN PS: Internal / External	char	1	0	CHAR	(N' ')	Yes		PIN_OBJTY	Allow NULL?
203	CPERNR7	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	Yes		P_PERNR	Allow NULL?
204	C_HEABD	Start date of Inquiry Period	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_HEABD	Allow NULL?
205	C_HEAED	End date of Inquiry Period	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_HEAED	Allow NULL?
206	C_STATUS	Status of the Disciplinary Action	nvarchar	3	0	NUMC	(N'000')	Yes	*	PIN_STAT	Allow NULL?
207	C_NHEDB	HR IN PS: Next Hearing Begin Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_NHEBD	Allow NULL?
208	COUCD1	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
209	COUCD2	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
210	COUCD3	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
211	COUCD4	Outcome code	nvarchar	3	0	CHAR	(N' ')	Yes	*	PIN_OUTCD	Allow NULL?
212	COUDE1	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
213	COUDF1	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
214	COUDR1	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
215	COUMT1	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
216	COUAT1	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
217	COUDE2	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
218	COUDF2	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
219	COUDR2	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
220	COUMT2	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
221	COUAT2	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
222	COUDE3	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
223	COUDF3	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
224	COUDR3	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
225	COUMT3	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
226	COUAT3	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
227	COUDE4	Begin date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDE	Allow NULL?
228	COUDF4	End date of Outcome	nvarchar	8	0	DATS	(N'00000000')	Yes		PIN_OUTDF	Allow NULL?
229	COUDR4	Duration of outcome	nvarchar	3	0	NUMC	(N'000')	Yes		PIN_OUTDR	Allow NULL?
230	COUMT4	Unit of Time/Measurement	nvarchar	3	0	CHAR	(N' ')	Yes		PIN_OUTMT	Allow NULL?
231	COUAT4	Amount of Penalty	decimal	13	2	CURR	((0))	Yes		PIN_OUTAT
232	CASNR	Case Number for DA proceeding	nvarchar	20	0	CHAR	(N' ')	Yes		PIN_CASNR	Allow NULL?
233	AWAERS1	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
234	AWAERS2	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
235	AWAERS3	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
236	AWAERS4	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
237	BWAERS1	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
238	BWAERS2	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
239	BWAERS3	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
240	BWAERS4	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
241	CWAERS1	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
242	CWAERS2	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
243	CWAERS3	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
244	CWAERS4	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
245	FWAERS1	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
246	FWAERS2	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
247	FWAERS3	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
248	FWAERS4	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
249	INVPR2	Investigating officer's per no.	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PIN_INVPR	Allow NULL?
250	INVPR3	Investigating officer's per no.	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PIN_INVPR	Allow NULL?
251	INVPR4	Investigating officer's per no.	nvarchar	8	0	NUMC	(N'00000000')	Yes	*	PIN_INVPR	Allow NULL?

TOP ERP 6.0 | PA3743 INDEXES

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

251 COLUMNS | 1 INDEXES | ERP 6.0 | PA3743 TABLE

TOP ERP 6.0 | PA3743 COLUMNS

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

251 COLUMNS | 1 INDEXES | ERP 6.0 | PA3743 TABLE

TOPERP 6.0 | PA3743 COLUMNS

TOPERP 6.0 | PA3743 INDEXES

TOP ERP 6.0 | PA3743 COLUMNS

TOP ERP 6.0 | PA3743 INDEXES