	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

246 COLUMNS | 1 INDEXES | ERP 6.0 | PA0508 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Payroll :: Australia :: Public Sector
1	ERP EHP7	6.0	PA0508	246	1	HR-AU-PS: Master Data For Prior Service	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, AGENT, DEPTS, FPFLG, HRPWK, PERCT, CTLSL, CTSKL, CTTER, CTAFP, ACCDT, ELGDT, BLVE1, BOBL1, BFLG1, BLVE2, BOBL2, BFLG2, BLVE3, BOBL3, BFLG3, BLVE4, BOBL4, BFLG4, LVE01, BEG01, END01, MTH01, DAY01, PFT01, PAY01, CAS01, LVE02, BEG02, END02, MTH02, DAY02, PFT02, PAY02, CAS02, LVE03, BEG03, END03, MTH03, DAY03, PFT03, PAY03, CAS03, LVE04, BEG04, END04, MTH04, DAY04, PFT04, PAY04, CAS04, LVE05, BEG05, END05, MTH05, DAY05, PFT05, PAY05, CAS05, LVE06, BEG06, END06, MTH06, DAY06, PFT06, PAY06, CAS06, LVE07, BEG07, END07, MTH07, DAY07, PFT07, PAY07, CAS07, LVE08, BEG08, END08, MTH08, DAY08, PFT08, PAY08, CAS08, LVE09, BEG09, END09, MTH09, DAY09, PFT09, PAY09, CAS09, LVE10, BEG10, END10, MTH10, DAY10, PFT10, PAY10, CAS10, LVE11, BEG11, END11, MTH11, DAY11, PFT11, PAY11, CAS11, LVE12, BEG12, END12, MTH12, DAY12, PFT12, PAY12, CAS12, LVE13, BEG13, END13, MTH13, DAY13, PFT13, PAY13, CAS13, LVE14, BEG14, END14, MTH14, DAY14, PFT14, PAY14, CAS14, LVE15, BEG15, END15, MTH15, DAY15, PFT15, PAY15, CAS15, LVE16, BEG16, END16, MTH16, DAY16, PFT16, PAY16, CAS16, LVE17, BEG17, END17, MTH17, DAY17, PFT17, PAY17, CAS17, LVE18, BEG18, END18, MTH18, DAY18, PFT18, PAY18, CAS18, LVE19, BEG19, END19, MTH19, DAY19, PFT19, PAY19, CAS19, LVE20, BEG20, END20, MTH20, DAY20, PFT20, PAY20, CAS20, LVE21, BEG21, END21, MTH21, DAY21, PFT21, PAY21, CAS21, LVE22, BEG22, END22, MTH22, DAY22, PFT22, PAY22, CAS22, LVE23, BEG23, END23, MTH23, DAY23, PFT23, PAY23, CAS23, LVE24, BEG24, END24, MTH24, DAY24, PFT24, PAY24, CAS24, LVE25, BEG25, END25, MTH25, DAY25, PFT25, PAY25, CAS25 FROM PA0508

TOP ERP 6.0 | PA0508 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	AGENT	Name of agent for the last service	nvarchar	30	0	CHAR	(N' ')	Yes		PAU_AGENT	Allow NULL?
25	DEPTS	Department	nvarchar	20	0	CHAR	(N' ')	Yes		PAU_DEPTS	Allow NULL?
26	FPFLG	Full or part time flag	char	1	0	CHAR	(N' ')	Yes		PAU_FPFLG	Allow NULL?
27	HRPWK	Hours work per week	decimal	5	2	DEC	((0))	Yes		PAU_HRPWK
28	PERCT	Employment percentage	decimal	5	2	DEC	((0))	Yes		PAU_PERCT
29	CTLSL	Count for LSL	char	1	0	CHAR	(N' ')	Yes		PAU_CTLSL	Allow NULL?
30	CTSKL	Count for Sick Leave	char	1	0	CHAR	(N' ')	Yes		PAU_CTSKL	Allow NULL?
31	CTTER	Count for termination	char	1	0	CHAR	(N' ')	Yes		PAU_CTTER	Allow NULL?
32	CTAFP	Customer Specific	char	1	0	CHAR	(N' ')	Yes		PAU_CTAFP	Allow NULL?
33	ACCDT	Accrual anniversary date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ACCDT	Allow NULL?
34	ELGDT	Eligibility Date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ELGDT	Allow NULL?
35	BLVE1	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_PSLVE	Allow NULL?
36	BOBL1	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
37	BFLG1	Opening balance flag ( Full / Part Time balance )	char	1	0	CHAR	(N' ')	Yes		PAU_OBFLG	Allow NULL?
38	BLVE2	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
39	BOBL2	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
40	BFLG2	Opening balance flag ( Full / Part Time balance )	char	1	0	CHAR	(N' ')	Yes		PAU_OBFLG	Allow NULL?
41	BLVE3	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
42	BOBL3	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
43	BFLG3	Opening balance flag ( Full / Part Time balance )	char	1	0	CHAR	(N' ')	Yes		PAU_OBFLG	Allow NULL?
44	BLVE4	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
45	BOBL4	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
46	BFLG4	Opening balance flag ( Full / Part Time balance )	char	1	0	CHAR	(N' ')	Yes		PAU_OBFLG	Allow NULL?
47	LVE01	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
48	BEG01	Begin Day of leave taken	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_LVBEG	Allow NULL?
49	END01	End date of leave taken	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_LVEND	Allow NULL?
50	MTH01	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
51	DAY01	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
52	PFT01	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
53	PAY01	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
54	CAS01	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
55	LVE02	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
56	BEG02	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
57	END02	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
58	MTH02	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
59	DAY02	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
60	PFT02	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
61	PAY02	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
62	CAS02	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
63	LVE03	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
64	BEG03	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
65	END03	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
66	MTH03	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
67	DAY03	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
68	PFT03	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
69	PAY03	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
70	CAS03	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
71	LVE04	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
72	BEG04	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
73	END04	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
74	MTH04	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
75	DAY04	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
76	PFT04	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
77	PAY04	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
78	CAS04	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
79	LVE05	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
80	BEG05	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
81	END05	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
82	MTH05	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
83	DAY05	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
84	PFT05	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
85	PAY05	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
86	CAS05	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
87	LVE06	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
88	BEG06	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
89	END06	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
90	MTH06	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
91	DAY06	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
92	PFT06	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
93	PAY06	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
94	CAS06	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
95	LVE07	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
96	BEG07	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
97	END07	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
98	MTH07	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
99	DAY07	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
100	PFT07	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
101	PAY07	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
102	CAS07	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
103	LVE08	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
104	BEG08	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
105	END08	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
106	MTH08	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
107	DAY08	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
108	PFT08	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
109	PAY08	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
110	CAS08	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
111	LVE09	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
112	BEG09	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
113	END09	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
114	MTH09	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
115	DAY09	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
116	PFT09	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
117	PAY09	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
118	CAS09	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
119	LVE10	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
120	BEG10	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
121	END10	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
122	MTH10	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
123	DAY10	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
124	PFT10	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
125	PAY10	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
126	CAS10	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
127	LVE11	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
128	BEG11	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
129	END11	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
130	MTH11	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
131	DAY11	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
132	PFT11	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
133	PAY11	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
134	CAS11	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
135	LVE12	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
136	BEG12	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
137	END12	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
138	MTH12	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
139	DAY12	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
140	PFT12	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
141	PAY12	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
142	CAS12	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
143	LVE13	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
144	BEG13	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
145	END13	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
146	MTH13	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
147	DAY13	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
148	PFT13	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
149	PAY13	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
150	CAS13	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
151	LVE14	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
152	BEG14	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
153	END14	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
154	MTH14	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
155	DAY14	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
156	PFT14	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
157	PAY14	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
158	CAS14	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
159	LVE15	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
160	BEG15	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
161	END15	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
162	MTH15	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
163	DAY15	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
164	PFT15	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
165	PAY15	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
166	CAS15	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
167	LVE16	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
168	BEG16	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
169	END16	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
170	MTH16	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
171	DAY16	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
172	PFT16	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
173	PAY16	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
174	CAS16	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
175	LVE17	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
176	BEG17	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
177	END17	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
178	MTH17	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
179	DAY17	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
180	PFT17	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
181	PAY17	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
182	CAS17	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
183	LVE18	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
184	BEG18	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
185	END18	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
186	MTH18	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
187	DAY18	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
188	PFT18	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
189	PAY18	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
190	CAS18	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
191	LVE19	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
192	BEG19	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
193	END19	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
194	MTH19	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
195	DAY19	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
196	PFT19	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
197	PAY19	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
198	CAS19	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
199	LVE20	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
200	BEG20	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
201	END20	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
202	MTH20	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
203	DAY20	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
204	PFT20	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
205	PAY20	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
206	CAS20	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
207	LVE21	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
208	BEG21	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
209	END21	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
210	MTH21	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
211	DAY21	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
212	PFT21	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
213	PAY21	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
214	CAS21	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
215	LVE22	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
216	BEG22	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
217	END22	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
218	MTH22	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
219	DAY22	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
220	PFT22	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
221	PAY22	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
222	CAS22	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
223	LVE23	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
224	BEG23	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
225	END23	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
226	MTH23	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
227	DAY23	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
228	PFT23	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
229	PAY23	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
230	CAS23	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
231	LVE24	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
232	BEG24	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
233	END24	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
234	MTH24	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
235	DAY24	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
236	PFT24	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
237	PAY24	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
238	CAS24	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
239	LVE25	Leave type for Prior Service	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_PSLVE	Allow NULL?
240	BEG25	Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		BEGDA	Allow NULL?
241	END25	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
242	MTH25	Leave taken in prior service in months	decimal	8	0	DEC	((0))	Yes		PAU_PSMTH
243	DAY25	Leave taken in prior service in days	decimal	5	2	DEC	((0))	Yes		PAU_PSDAY
244	PFT25	Leave taken in Part or Full time counter	char	1	0	CHAR	(N' ')	Yes		PAU_PFTCT	Allow NULL?
245	PAY25	FULL OR HALF PAY COUNTER	char	1	0	CHAR	(N' ')	Yes		PAU_PAYCT	Allow NULL?
246	CAS25	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?

TOP ERP 6.0 | PA0508 INDEXES

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

246 COLUMNS | 1 INDEXES | ERP 6.0 | PA0508 TABLE

TOP ERP 6.0 | PA0508 COLUMNS

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

246 COLUMNS | 1 INDEXES | ERP 6.0 | PA0508 TABLE

TOPERP 6.0 | PA0508 COLUMNS

TOPERP 6.0 | PA0508 INDEXES

TOP ERP 6.0 | PA0508 COLUMNS

TOP ERP 6.0 | PA0508 INDEXES