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