	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

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