	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

183 COLUMNS | 1 INDEXES | ERP 6.0 | PA0573 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Payroll :: Australia :: Public Sector
1	ERP EHP7	6.0	PA0573	183	1	Master leave code for Public Sector Australia	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, BEGUZ, ENDUZ, VTKEN, LCODE, FFLAG, FHPAY, DEDFP, CONFH, NTCAS, SPLIT, SUPER, APDAT, ADVNC, AFLAG, PFLAG, QUOT1, QUOT2, QUAMT, SLAMT, LVE01, BEG01, END01, BONU1, LOAD1, LVE02, BEG02, END02, BONU2, LOAD2, LVE03, BEG03, END03, BONU3, LOAD3, LVE04, BEG04, END04, BONU4, LOAD4, LVE05, BEG05, END05, BONU5, LOAD5, LVE06, BEG06, END06, BONU6, LOAD6, BTM01, ETM01, BTM02, ETM02, BTM03, ETM03, BTM04, ETM04, BTM05, ETM05, BTM06, ETM06, LVE07, BEG07, END07, BTM07, ETM07, LVE08, BEG08, END08, BTM08, ETM08, LVE09, BEG09, END09, BTM09, ETM09, LVE10, BEG10, END10, BTM10, ETM10, LVE11, BEG11, END11, BTM11, ETM11, LVE12, BEG12, END12, BTM12, ETM12, LVE13, BEG13, END13, BTM13, ETM13, LVE14, BEG14, END14, BTM14, ETM14, LVE15, BEG15, END15, BTM15, ETM15, LVE16, BEG16, END16, BTM16, ETM16, LVE17, BEG17, END17, BTM17, ETM17, LVE18, BEG18, END18, BTM18, ETM18, LVE19, BEG19, END19, BTM19, ETM19, LVE20, BEG20, END20, BTM20, ETM20, LVE21, BEG21, END21, BTM21, ETM21, LVE22, BEG22, END22, BTM22, ETM22, AIN01, LCD01, AIN02, LCD02, AIN03, LCD03, AIN04, LCD04, AIN05, LCD05, TRSDT, ENTIL, QUT01, ENT01, QUT02, ENT02, PQUOT, FUTUR, PDIND FROM PA0573

TOP ERP 6.0 | PA0573 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	*	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	BEGUZ	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
25	ENDUZ	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
26	VTKEN	Previous Day Indicator	char	1	0	CHAR	(N' ')	Yes		VTKEN	Allow NULL?
27	LCODE	Master leave code	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_LCODE	Allow NULL?
28	FFLAG	Discard minimum criteria check	char	1	0	CHAR	(N' ')	Yes		PAU_FFLAG	Allow NULL?
29	FHPAY	Deduct from Full/Half Pay Quota	char	1	0	CHAR	(N' ')	Yes		PAU_FHPAY	Allow NULL?
30	DEDFP	Deduction From Full/Part Time Quota	char	1	0	CHAR	(N' ')	Yes		PAU_DEDFP	Allow NULL?
31	CONFH	Convert to Full or Half Pay Flag.	char	1	0	CHAR	(N' ')	Yes		PAU_CONFH	Allow NULL?
32	NTCAS	Not to count as service	char	1	0	CHAR	(N' ')	Yes		PAU_NTCAS	Allow NULL?
33	SPLIT	Split across financial year check box	char	1	0	CHAR	(N' ')	Yes		PAU_SPLIT	Allow NULL?
34	SUPER	Supervisor Name	nvarchar	30	0	CHAR	(N' ')	Yes		PAU_SUPER	Allow NULL?
35	APDAT	Approval date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_APDAT	Allow NULL?
36	ADVNC	Leave advance Payment	char	1	0	CHAR	(N' ')	Yes		PAU_ADVNC	Allow NULL?
37	AFLAG	Anticipation allowd	char	1	0	CHAR	(N' ')	Yes		PAU_AFLAG	Allow NULL?
38	PFLAG	Purchase Leave allowed ?	char	1	0	CHAR	(N' ')	Yes		PAU_PFLAG	Allow NULL?
39	QUOT1	Quota type for anticipation	nvarchar	2	0	NUMC	(N'00')	Yes	*	PAU_DEDQT	Allow NULL?
40	QUOT2	Flexi Time quota for 2006	nvarchar	2	0	NUMC	(N'00')	Yes	*	PAU_FLEXQ	Allow NULL?
41	QUAMT	Purchase Leave Amount	decimal	5	2	DEC	((0))	Yes		PAU_QUAMT
42	SLAMT	Parallel deduction for sick leave	decimal	5	2	DEC	((0))	Yes		PAU_SLAMT
43	LVE01	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	T554S	PAU_LEAVE	Allow NULL?
44	BEG01	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
45	END01	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
46	BONU1	Taxation tick box for leave loading	char	1	0	CHAR	(N' ')	Yes		PAU_BONUS	Allow NULL?
47	LOAD1	Leave Loading	char	1	0	CHAR	(N' ')	Yes		PAU_LLOAD	Allow NULL?
48	LVE02	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	T554S	PAU_LEAVE	Allow NULL?
49	BEG02	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
50	END02	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
51	BONU2	Taxation tick box for leave loading	char	1	0	CHAR	(N' ')	Yes		PAU_BONUS	Allow NULL?
52	LOAD2	Leave Loading	char	1	0	CHAR	(N' ')	Yes		PAU_LLOAD	Allow NULL?
53	LVE03	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	T554S	PAU_LEAVE	Allow NULL?
54	BEG03	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
55	END03	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
56	BONU3	Taxation tick box for leave loading	char	1	0	CHAR	(N' ')	Yes		PAU_BONUS	Allow NULL?
57	LOAD3	Leave Loading	char	1	0	CHAR	(N' ')	Yes		PAU_LLOAD	Allow NULL?
58	LVE04	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	T554S	PAU_LEAVE	Allow NULL?
59	BEG04	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
60	END04	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
61	BONU4	Taxation tick box for leave loading	char	1	0	CHAR	(N' ')	Yes		PAU_BONUS	Allow NULL?
62	LOAD4	Leave Loading	char	1	0	CHAR	(N' ')	Yes		PAU_LLOAD	Allow NULL?
63	LVE05	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	T554S	PAU_LEAVE	Allow NULL?
64	BEG05	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
65	END05	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
66	BONU5	Taxation tick box for leave loading	char	1	0	CHAR	(N' ')	Yes		PAU_BONUS	Allow NULL?
67	LOAD5	Leave Loading	char	1	0	CHAR	(N' ')	Yes		PAU_LLOAD	Allow NULL?
68	LVE06	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	T554S	PAU_LEAVE	Allow NULL?
69	BEG06	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
70	END06	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
71	BONU6	Taxation tick box for leave loading	char	1	0	CHAR	(N' ')	Yes		PAU_BONUS	Allow NULL?
72	LOAD6	Leave Loading	char	1	0	CHAR	(N' ')	Yes		PAU_LLOAD	Allow NULL?
73	BTM01	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
74	ETM01	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
75	BTM02	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
76	ETM02	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
77	BTM03	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
78	ETM03	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
79	BTM04	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
80	ETM04	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
81	BTM05	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
82	ETM05	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
83	BTM06	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
84	ETM06	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
85	LVE07	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
86	BEG07	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
87	END07	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
88	BTM07	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
89	ETM07	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
90	LVE08	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
91	BEG08	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
92	END08	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
93	BTM08	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
94	ETM08	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
95	LVE09	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
96	BEG09	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
97	END09	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
98	BTM09	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
99	ETM09	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
100	LVE10	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
101	BEG10	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
102	END10	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
103	BTM10	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
104	ETM10	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
105	LVE11	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
106	BEG11	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
107	END11	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
108	BTM11	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
109	ETM11	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
110	LVE12	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
111	BEG12	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
112	END12	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
113	BTM12	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
114	ETM12	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
115	LVE13	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
116	BEG13	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
117	END13	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
118	BTM13	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
119	ETM13	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
120	LVE14	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
121	BEG14	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
122	END14	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
123	BTM14	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
124	ETM14	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
125	LVE15	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
126	BEG15	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
127	END15	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
128	BTM15	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
129	ETM15	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
130	LVE16	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
131	BEG16	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
132	END16	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
133	BTM16	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
134	ETM16	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
135	LVE17	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
136	BEG17	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
137	END17	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
138	BTM17	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
139	ETM17	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
140	LVE18	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
141	BEG18	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
142	END18	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
143	BTM18	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
144	ETM18	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
145	LVE19	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
146	BEG19	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
147	END19	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
148	BTM19	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
149	ETM19	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
150	LVE20	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
151	BEG20	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
152	END20	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
153	BTM20	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
154	ETM20	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
155	LVE21	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
156	BEG21	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
157	END21	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
158	BTM21	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
159	ETM21	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
160	LVE22	Leave type stored in 2001	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LEAVE	Allow NULL?
161	BEG22	Leave begin date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_BEGDA	Allow NULL?
162	END22	Leave end date	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_ENDDA	Allow NULL?
163	BTM22	Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		BEGTI	Allow NULL?
164	ETM22	End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		ENDTI	Allow NULL?
165	AIN01	Leave type stored in 2001 indicator	nvarchar	2	0	CHAR	(N' ')	Yes		PAU_ABSIND	Allow NULL?
166	LCD01	Original split leave code	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_LSPLT	Allow NULL?
167	AIN02	Leave type stored in 2001 indicator	nvarchar	2	0	CHAR	(N' ')	Yes		PAU_ABSIND	Allow NULL?
168	LCD02	Original split leave code	nvarchar	4	0	CHAR	(N' ')	Yes	T5QPBS2C	PAU_LSPLT	Allow NULL?
169	AIN03	Leave type stored in 2001 indicator	nvarchar	2	0	CHAR	(N' ')	Yes		PAU_ABSIND	Allow NULL?
170	LCD03	Original split leave code	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LSPLT	Allow NULL?
171	AIN04	Leave type stored in 2001 indicator	nvarchar	2	0	CHAR	(N' ')	Yes		PAU_ABSIND	Allow NULL?
172	LCD04	Original split leave code	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LSPLT	Allow NULL?
173	AIN05	Leave type stored in 2001 indicator	nvarchar	2	0	CHAR	(N' ')	Yes		PAU_ABSIND	Allow NULL?
174	LCD05	Original split leave code	nvarchar	4	0	CHAR	(N' ')	Yes	*	PAU_LSPLT	Allow NULL?
175	TRSDT	Transfer date for anticipation	nvarchar	8	0	DATS	(N'00000000')	Yes		PAU_TRSDT	Allow NULL?
176	ENTIL	Entitlement for anticipation	decimal	10	5	DEC	((0))	Yes		PAU_ENTIL
177	QUT01	Quota type for parallel deduction	nvarchar	2	0	NUMC	(N'00')	Yes	*	PAU_QUOT3	Allow NULL?
178	ENT01	Entitlement for parallel deduction quota	decimal	10	5	DEC	((0))	Yes		PAU_ENTPR
179	QUT02	Quota type for parallel deduction	nvarchar	2	0	NUMC	(N'00')	Yes	*	PAU_QUOT3	Allow NULL?
180	ENT02	Entitlement for parallel deduction quota	decimal	10	5	DEC	((0))	Yes		PAU_ENTPR
181	PQUOT	Purchase Leave quota type	nvarchar	2	0	NUMC	(N'00')	Yes	*	PAU_PQUOT	Allow NULL?
182	FUTUR	Future leave exists or not	char	1	0	CHAR	(N' ')	Yes		PAU_FUTUR	Allow NULL?
183	PDIND	Day Indicator	nvarchar	2	0	CHAR	(N' ')	Yes		PAU_PDIND	Allow NULL?

TOP ERP 6.0 | PA0573 INDEXES

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

183 COLUMNS | 1 INDEXES | ERP 6.0 | PA0573 TABLE

TOP ERP 6.0 | PA0573 COLUMNS

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

183 COLUMNS | 1 INDEXES | ERP 6.0 | PA0573 TABLE

TOPERP 6.0 | PA0573 COLUMNS

TOPERP 6.0 | PA0573 INDEXES

TOP ERP 6.0 | PA0573 COLUMNS

TOP ERP 6.0 | PA0573 INDEXES