	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

347 COLUMNS | 1 INDEXES | ERP 6.0 | PA0764 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Netherlands
1	ERP EHP7	6.0	PA0764	347	1	Personnel Master Record Infotype 0764	Netherlands

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, SBMOD, SACHC, LGEDT, VANPW, ACT01, UTD01, END01, BEV01, ACT02, UTD02, END02, BEV02, ACT03, UTD03, END03, BEV03, ACT04, UTD04, END04, BEV04, ACT05, UTD05, END05, BEV05, ACT06, UTD06, END06, BEV06, ACT07, UTD07, END07, BEV07, ACT08, UTD08, END08, BEV08, ACT09, UTD09, END09, BEV09, ACT10, UTD10, END10, BEV10, ACT11, UTD11, END11, BEV11, ACT12, UTD12, END12, BEV12, ACT13, UTD13, END13, BEV13, ACT14, UTD14, END14, BEV14, ACT15, UTD15, END15, BEV15, ACT16, UTD16, END16, BEV16, ACT17, UTD17, END17, BEV17, ACT18, UTD18, END18, BEV18, ACT19, UTD19, END19, BEV19, ACT20, UTD20, END20, BEV20, ACT21, UTD21, END21, BEV21, ACT22, UTD22, END22, BEV22, ACT23, UTD23, END23, BEV23, ACT24, UTD24, END24, BEV24, ACT25, UTD25, END25, BEV25, ACT26, UTD26, END26, BEV26, ACT27, UTD27, END27, BEV27, ACT28, UTD28, END28, BEV28, ACT29, UTD29, END29, BEV29, ACT30, UTD30, END30, BEV30, ACT31, UTD31, END31, BEV31, ACT32, UTD32, END32, BEV32, ACT33, UTD33, END33, BEV33, ACT34, UTD34, END34, BEV34, ACT35, UTD35, END35, BEV35, ACT36, UTD36, END36, BEV36, ACT37, UTD37, END37, BEV37, ACT38, UTD38, END38, BEV38, ACT39, UTD39, END39, BEV39, ACT40, UTD40, END40, BEV40, ACT41, UTD41, END41, BEV41, ACT42, UTD42, END42, BEV42, ACT43, UTD43, END43, BEV43, ACT44, UTD44, END44, BEV44, ACT45, UTD45, END45, BEV45, ACT46, UTD46, END46, BEV46, ACT47, UTD47, END47, BEV47, ACT48, UTD48, END48, BEV48, ACT49, UTD49, END49, BEV49, ACT50, UTD50, END50, BEV50, ACT51, UTD51, END51, BEV51, ACT52, UTD52, END52, BEV52, ACT53, UTD53, END53, BEV53, ACT54, UTD54, END54, BEV54, ACT55, UTD55, END55, BEV55, ACT56, UTD56, END56, BEV56, ACT57, UTD57, END57, BEV57, ACT58, UTD58, END58, BEV58, ACT59, UTD59, END59, BEV59, ACT60, UTD60, END60, BEV60, ACT61, UTD61, END61, BEV61, ACT62, UTD62, END62, BEV62, ACT63, UTD63, END63, BEV63, ACT64, UTD64, END64, BEV64, ACT65, UTD65, END65, BEV65, ACT66, UTD66, END66, BEV66, ACT67, UTD67, END67, BEV67, ACT68, UTD68, END68, BEV68, ACT69, UTD69, END69, BEV69, ACT70, UTD70, END70, BEV70, ACT71, UTD71, END71, BEV71, ACT72, UTD72, END72, BEV72, ACT73, UTD73, END73, BEV73, ACT74, UTD74, END74, BEV74, ACT75, UTD75, END75, BEV75, ACT76, UTD76, END76, BEV76, ACT77, UTD77, END77, BEV77, ACT78, UTD78, END78, BEV78, ACT79, UTD79, END79, BEV79, ACT80, UTD80, END80, BEV80 FROM PA0764

TOP ERP 6.0 | PA0764 COLUMNS

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	Allow NULL?
6	ENDDA	End Date	nvarchar	8	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	Allow NULL?
11	HISTO	Historical Record Flag	char	1	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	Allow NULL?
24	SBMOD	Group Case Manager	nvarchar	4	Allow NULL?
25	SACHC	Case Manager for "Poortwachter" Act	nvarchar	3	Allow NULL?
26	LGEDT	Date of last generation of infotype 'Perm. Inv. Ben. Act'	nvarchar	8	Allow NULL?
27	VANPW	UWV is processing PW for this welfare claimant	char	1	Allow NULL?
28	ACT01	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
29	UTD01	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
30	END01	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
31	BEV01	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
32	ACT02	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
33	UTD02	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
34	END02	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
35	BEV02	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
36	ACT03	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
37	UTD03	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
38	END03	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
39	BEV03	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
40	ACT04	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
41	UTD04	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
42	END04	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
43	BEV04	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
44	ACT05	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
45	UTD05	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
46	END05	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
47	BEV05	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
48	ACT06	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
49	UTD06	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
50	END06	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
51	BEV06	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
52	ACT07	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
53	UTD07	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
54	END07	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
55	BEV07	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
56	ACT08	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
57	UTD08	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
58	END08	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
59	BEV08	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
60	ACT09	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
61	UTD09	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
62	END09	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
63	BEV09	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
64	ACT10	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
65	UTD10	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
66	END10	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
67	BEV10	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
68	ACT11	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
69	UTD11	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
70	END11	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
71	BEV11	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
72	ACT12	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
73	UTD12	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
74	END12	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
75	BEV12	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
76	ACT13	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
77	UTD13	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
78	END13	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
79	BEV13	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
80	ACT14	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
81	UTD14	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
82	END14	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
83	BEV14	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
84	ACT15	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
85	UTD15	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
86	END15	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
87	BEV15	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
88	ACT16	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
89	UTD16	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
90	END16	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
91	BEV16	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
92	ACT17	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
93	UTD17	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
94	END17	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
95	BEV17	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
96	ACT18	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
97	UTD18	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
98	END18	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
99	BEV18	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
100	ACT19	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
101	UTD19	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
102	END19	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
103	BEV19	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
104	ACT20	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
105	UTD20	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
106	END20	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
107	BEV20	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
108	ACT21	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
109	UTD21	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
110	END21	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
111	BEV21	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
112	ACT22	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
113	UTD22	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
114	END22	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
115	BEV22	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
116	ACT23	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
117	UTD23	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
118	END23	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
119	BEV23	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
120	ACT24	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
121	UTD24	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
122	END24	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
123	BEV24	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
124	ACT25	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
125	UTD25	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
126	END25	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
127	BEV25	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
128	ACT26	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
129	UTD26	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
130	END26	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
131	BEV26	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
132	ACT27	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
133	UTD27	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
134	END27	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
135	BEV27	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
136	ACT28	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
137	UTD28	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
138	END28	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
139	BEV28	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
140	ACT29	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
141	UTD29	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
142	END29	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
143	BEV29	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
144	ACT30	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
145	UTD30	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
146	END30	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
147	BEV30	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
148	ACT31	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
149	UTD31	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
150	END31	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
151	BEV31	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
152	ACT32	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
153	UTD32	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
154	END32	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
155	BEV32	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
156	ACT33	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
157	UTD33	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
158	END33	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
159	BEV33	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
160	ACT34	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
161	UTD34	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
162	END34	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
163	BEV34	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
164	ACT35	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
165	UTD35	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
166	END35	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
167	BEV35	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
168	ACT36	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
169	UTD36	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
170	END36	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
171	BEV36	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
172	ACT37	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
173	UTD37	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
174	END37	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
175	BEV37	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
176	ACT38	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
177	UTD38	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
178	END38	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
179	BEV38	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
180	ACT39	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
181	UTD39	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
182	END39	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
183	BEV39	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
184	ACT40	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
185	UTD40	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
186	END40	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
187	BEV40	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
188	ACT41	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
189	UTD41	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
190	END41	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
191	BEV41	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
192	ACT42	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
193	UTD42	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
194	END42	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
195	BEV42	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
196	ACT43	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
197	UTD43	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
198	END43	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
199	BEV43	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
200	ACT44	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
201	UTD44	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
202	END44	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
203	BEV44	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
204	ACT45	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
205	UTD45	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
206	END45	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
207	BEV45	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
208	ACT46	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
209	UTD46	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
210	END46	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
211	BEV46	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
212	ACT47	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
213	UTD47	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
214	END47	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
215	BEV47	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
216	ACT48	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
217	UTD48	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
218	END48	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
219	BEV48	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
220	ACT49	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
221	UTD49	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
222	END49	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
223	BEV49	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
224	ACT50	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
225	UTD50	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
226	END50	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
227	BEV50	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
228	ACT51	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
229	UTD51	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
230	END51	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
231	BEV51	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
232	ACT52	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
233	UTD52	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
234	END52	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
235	BEV52	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
236	ACT53	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
237	UTD53	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
238	END53	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
239	BEV53	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
240	ACT54	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
241	UTD54	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
242	END54	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
243	BEV54	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
244	ACT55	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
245	UTD55	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
246	END55	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
247	BEV55	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
248	ACT56	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
249	UTD56	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
250	END56	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
251	BEV56	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
252	ACT57	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
253	UTD57	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
254	END57	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
255	BEV57	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
256	ACT58	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
257	UTD58	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
258	END58	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
259	BEV58	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
260	ACT59	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
261	UTD59	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
262	END59	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
263	BEV59	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
264	ACT60	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
265	UTD60	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
266	END60	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
267	BEV60	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
268	ACT61	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
269	UTD61	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
270	END61	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
271	BEV61	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
272	ACT62	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
273	UTD62	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
274	END62	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
275	BEV62	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
276	ACT63	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
277	UTD63	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
278	END63	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
279	BEV63	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
280	ACT64	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
281	UTD64	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
282	END64	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
283	BEV64	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
284	ACT65	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
285	UTD65	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
286	END65	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
287	BEV65	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
288	ACT66	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
289	UTD66	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
290	END66	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
291	BEV66	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
292	ACT67	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
293	UTD67	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
294	END67	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
295	BEV67	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
296	ACT68	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
297	UTD68	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
298	END68	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
299	BEV68	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
300	ACT69	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
301	UTD69	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
302	END69	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
303	BEV69	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
304	ACT70	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
305	UTD70	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
306	END70	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
307	BEV70	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
308	ACT71	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
309	UTD71	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
310	END71	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
311	BEV71	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
312	ACT72	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
313	UTD72	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
314	END72	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
315	BEV72	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
316	ACT73	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
317	UTD73	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
318	END73	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
319	BEV73	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
320	ACT74	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
321	UTD74	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
322	END74	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
323	BEV74	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
324	ACT75	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
325	UTD75	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
326	END75	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
327	BEV75	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
328	ACT76	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
329	UTD76	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
330	END76	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
331	BEV76	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
332	ACT77	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
333	UTD77	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
334	END77	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
335	BEV77	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
336	ACT78	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
337	UTD78	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
338	END78	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
339	BEV78	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
340	ACT79	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
341	UTD79	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
342	END79	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
343	BEV79	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?
344	ACT80	'Permanent Invalidity Benefit' activity code	nvarchar	3	Allow NULL?
345	UTD80	Latest date for 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
346	END80	Processing date of 'Permanent Invalidity Benefit' activity	nvarchar	8	Allow NULL?
347	BEV80	Confirmation of 'Permanent Invalidity Benefit' activity	char	1	Allow NULL?

TOP ERP 6.0 | PA0764 INDEXES

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

347 COLUMNS | 1 INDEXES | ERP 6.0 | PA0764 TABLE

TOP ERP 6.0 | PA0764 COLUMNS

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

347 COLUMNS | 1 INDEXES | ERP 6.0 | PA0764 TABLE

TOPERP 6.0 | PA0764 COLUMNS

TOPERP 6.0 | PA0764 INDEXES

TOP ERP 6.0 | PA0764 COLUMNS

TOP ERP 6.0 | PA0764 INDEXES