	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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

243 COLUMNS | 1 INDEXES | ERP 6.0 | PA0568 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Payroll :: Australia :: Public Sector
1	ERP EHP7	6.0	PA0568	243	1	HR Master Record: Infotype 0568 for anniversay history	Public Sector

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, DATAR, ANBEG, ANEND, BEG01, END01, DAY01, THV01, NPL01, CON01, PID01, PTP01, BEG02, END02, DAY02, THV02, NPL02, CON02, PID02, PTP02, BEG03, END03, DAY03, THV03, NPL03, CON03, PID03, PTP03, BEG04, END04, DAY04, THV04, NPL04, CON04, PID04, PTP04, BEG05, END05, DAY05, THV05, NPL05, CON05, PID05, PTP05, BEG06, END06, DAY06, THV06, NPL06, CON06, PID06, PTP06, BEG07, END07, DAY07, THV07, NPL07, CON07, PID07, PTP07, BEG08, END08, DAY08, THV08, NPL08, CON08, PID08, PTP08, BEG09, END09, DAY09, THV09, NPL09, CON09, PID09, PTP09, BEG10, END10, DAY10, THV10, NPL10, CON10, PID10, PTP10, BEG11, END11, DAY11, THV11, NPL11, CON11, PID11, PTP11, BEG12, END12, DAY12, THV12, NPL12, CON12, PID12, PTP12, BEG13, END13, DAY13, THV13, NPL13, CON13, PID13, PTP13, BEG14, END14, DAY14, THV14, NPL14, CON14, PID14, PTP14, BEG15, END15, DAY15, THV15, NPL15, CON15, PID15, PTP15, BEG16, END16, DAY16, THV16, NPL16, CON16, PID16, PTP16, BEG17, END17, DAY17, THV17, NPL17, CON17, PID17, PTP17, BEG18, END18, DAY18, THV18, NPL18, CON18, PID18, PTP18, BEG19, END19, DAY19, THV19, NPL19, CON19, PID19, PTP19, BEG20, END20, DAY20, THV20, NPL20, CON20, PID20, PTP20, BEG21, END21, DAY21, THV21, NPL21, CON21, PID21, PTP21, BEG22, END22, DAY22, THV22, NPL22, CON22, PID22, PTP22, BEG23, END23, DAY23, THV23, NPL23, CON23, PID23, PTP23, BEG24, END24, DAY24, THV24, NPL24, CON24, PID24, PTP24, BEG25, END25, DAY25, THV25, NPL25, CON25, PID25, PTP25, BEG26, END26, DAY26, THV26, NPL26, CON26, PID26, PTP26, BEG27, END27, DAY27, THV27, NPL27, CON27, PID27, PTP27, BISDY FROM PA0568

TOP ERP 6.0 | PA0568 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	NUMC	(N'00000000')	No	PA0003	PERSNO	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	CHAR	(N' ')	No		SUBTY	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	CHAR	(N' ')	No		OBJPS	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	CHAR	(N' ')	No		SPRPS	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	DATS	(N'00000000')	No		ENDDA	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	DATS	(N'00000000')	No		BEGDA	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	NUMC	(N'000')	No		SEQNR	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	CHAR	(N' ')	Yes		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	CHAR	(N' ')	Yes		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	CHAR	(N' ')	Yes		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	CHAR	(N' ')	Yes		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	CHAR	(N' ')	Yes		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	CHAR	(N' ')	Yes	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	DATAR	Date Type	nvarchar	2	0	CHAR	(N' ')	Yes	T548Y	PAU_DATAR	Allow NULL?
25	ANBEG	Original anniversary date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ANBEG	Allow NULL?
26	ANEND	End of Anniversary Year	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ANEND	Allow NULL?
27	BEG01	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
28	END01	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
29	DAY01	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
30	THV01	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
31	NPL01	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
32	CON01	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
33	PID01	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
34	PTP01	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
35	BEG02	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
36	END02	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
37	DAY02	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
38	THV02	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
39	NPL02	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
40	CON02	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
41	PID02	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
42	PTP02	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
43	BEG03	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
44	END03	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
45	DAY03	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
46	THV03	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
47	NPL03	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
48	CON03	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
49	PID03	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
50	PTP03	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
51	BEG04	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
52	END04	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
53	DAY04	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
54	THV04	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
55	NPL04	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
56	CON04	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
57	PID04	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
58	PTP04	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
59	BEG05	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
60	END05	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
61	DAY05	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
62	THV05	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
63	NPL05	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
64	CON05	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
65	PID05	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
66	PTP05	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
67	BEG06	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
68	END06	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
69	DAY06	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
70	THV06	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
71	NPL06	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
72	CON06	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
73	PID06	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
74	PTP06	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
75	BEG07	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
76	END07	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
77	DAY07	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
78	THV07	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
79	NPL07	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
80	CON07	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
81	PID07	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
82	PTP07	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
83	BEG08	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
84	END08	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
85	DAY08	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
86	THV08	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
87	NPL08	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
88	CON08	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
89	PID08	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
90	PTP08	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
91	BEG09	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
92	END09	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
93	DAY09	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
94	THV09	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
95	NPL09	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
96	CON09	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
97	PID09	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
98	PTP09	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
99	BEG10	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
100	END10	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
101	DAY10	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
102	THV10	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
103	NPL10	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
104	CON10	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
105	PID10	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
106	PTP10	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
107	BEG11	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
108	END11	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
109	DAY11	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
110	THV11	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
111	NPL11	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
112	CON11	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
113	PID11	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
114	PTP11	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
115	BEG12	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
116	END12	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
117	DAY12	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
118	THV12	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
119	NPL12	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
120	CON12	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
121	PID12	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
122	PTP12	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
123	BEG13	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
124	END13	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
125	DAY13	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
126	THV13	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
127	NPL13	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
128	CON13	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
129	PID13	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
130	PTP13	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
131	BEG14	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
132	END14	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
133	DAY14	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
134	THV14	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
135	NPL14	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
136	CON14	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
137	PID14	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
138	PTP14	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
139	BEG15	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
140	END15	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
141	DAY15	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
142	THV15	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
143	NPL15	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
144	CON15	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
145	PID15	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
146	PTP15	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
147	BEG16	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
148	END16	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
149	DAY16	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
150	THV16	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
151	NPL16	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
152	CON16	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
153	PID16	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
154	PTP16	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
155	BEG17	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
156	END17	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
157	DAY17	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
158	THV17	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
159	NPL17	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
160	CON17	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
161	PID17	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
162	PTP17	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
163	BEG18	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
164	END18	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
165	DAY18	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
166	THV18	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
167	NPL18	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
168	CON18	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
169	PID18	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
170	PTP18	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
171	BEG19	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
172	END19	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
173	DAY19	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
174	THV19	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
175	NPL19	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
176	CON19	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
177	PID19	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
178	PTP19	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
179	BEG20	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
180	END20	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
181	DAY20	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
182	THV20	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
183	NPL20	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
184	CON20	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
185	PID20	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
186	PTP20	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
187	BEG21	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
188	END21	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
189	DAY21	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
190	THV21	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
191	NPL21	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
192	CON21	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
193	PID21	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
194	PTP21	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
195	BEG22	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
196	END22	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
197	DAY22	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
198	THV22	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
199	NPL22	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
200	CON22	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
201	PID22	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
202	PTP22	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
203	BEG23	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
204	END23	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
205	DAY23	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
206	THV23	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
207	NPL23	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
208	CON23	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
209	PID23	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
210	PTP23	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
211	BEG24	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
212	END24	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
213	DAY24	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
214	THV24	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
215	NPL24	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
216	CON24	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
217	PID24	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
218	PTP24	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
219	BEG25	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
220	END25	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
221	DAY25	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
222	THV25	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
223	NPL25	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
224	CON25	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
225	PID25	LWOP or Unauth. leave impact indicator	char	1	0	CHAR	(N' ')	Yes		PAU_IMPID	Allow NULL?
226	PTP25	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
227	BEG26	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
228	END26	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
229	DAY26	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
230	THV26	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
231	NPL26	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes	*	PAU_NPLEN	Allow NULL?
232	CON26	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
233	PID26	Considering total inactive unauthorized leave days/Excess	char	1	0	CHAR	(N' ')	Yes		PAU_UNALU	Allow NULL?
234	PTP26	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
235	BEG27	Period start date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACBEG	Allow NULL?
236	END27	Period end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACEND	Allow NULL?
237	DAY27	Number of unpaid days with given period	decimal	6	2	DEC	((0))	Yes		PAU_NPDAY
238	THV27	LWOP threshold value	decimal	5	2	DEC	((0))	Yes		PAU_LWOPT
239	NPL27	Time unit for threshold value	nvarchar	2	0	CHAR	(N' ')	Yes		PAU_NPLEN	Allow NULL?
240	CON27	Considering total LWOP days/Excess part	char	1	0	CHAR	(N' ')	Yes		PAU_LWOPU	Allow NULL?
241	PID27	Considering total inactive unauthorized leave days/Excess	char	1	0	CHAR	(N' ')	Yes		PAU_UNALU	Allow NULL?
242	PTP27	LWOP or Unauth. leave impact type	char	1	0	CHAR	(N' ')	Yes		PAU_IMPTP	Allow NULL?
243	BISDY	BIS(Break-in-service) days in current anniversary year	decimal	6	2	DEC	((0))	Yes		PAU_BISDY

TOP ERP 6.0 | PA0568 INDEXES

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

243 COLUMNS | 1 INDEXES | ERP 6.0 | PA0568 TABLE

TOP ERP 6.0 | PA0568 COLUMNS

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

243 COLUMNS | 1 INDEXES | ERP 6.0 | PA0568 TABLE

TOPERP 6.0 | PA0568 COLUMNS

TOPERP 6.0 | PA0568 INDEXES

TOP ERP 6.0 | PA0568 COLUMNS

TOP ERP 6.0 | PA0568 INDEXES