	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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

154 COLUMNS | 1 INDEXES | ERP 6.0 | PA0074 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Denmark
1	ERP EHP7	6.0	PA0074	154	1	HR Master Record: Infotype 0074 (Leave Processing - DK)	Denmark

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, FEORD, FGPCT, FTPCT, FPFRE, SHORD, SHPCT, SHBEU, SHBEO, SHFRE, SHNEG, OFKOD, FZTAG, FETAG, F6TAG, CALJ0, DELJ0, ABMET, CALZU, CALEX, SHCLR, SHTCO, FKNUM, FKSIC, FKFRE, CALDAT, SHIND, SHPOR, SHDKK, SHCUR, SHCSA, SHOR2, TPROM, FERIE, UKBRP, UKBRJ, CALJ1, CALJ2, DELJ1, DELJ2, UTYPE, ASME0, ARWT0, CVM1, CVM2, CVM3, VMTXD, TXSH, TXRT0, BPA0, FRIK0, VM1, VM2, VM3, CVADA, SMTDT, VADA0, CXVS0, XVS0, CCARE, ASME1, ARWT1, TXRT1, BPA1, FRIK1, VACSU, VADA1, VARE1, CXVS1, XVS1, FERK1, ASME2, ARWT2, TXRT2, BPA2, FRIK2, VADA2, VARE2, CXVS2, XVS2, FERK2, IGNJ0, IGNJ1, IGNJ2, SVM1, SVM2, SVM3, STAX0, SVD0, SXVS0, SSD, STAX1, SVD1, SVS, SXVS1, SVR1, SFK1, STAX2, SVD2, SXVS2, SVR2, SFK2, FWV0N, FWV0F, FWV0K, FWV0C, FWV0S, FWV0A, FWV0B, FWV1N, FWV1F, FWV1K, FWV1C, FWV1S, FWV1A, FWV1B, FWV2N, FWV2F, FWV2K, FWV2C, FWV2S, FWV2A, FWV2B, PAYTY, PAYID, FTUBT, NODIF, URLJJ, OBJP0, UAR00, UAR01, UAN00 FROM PA0074

TOP ERP 6.0 | PA0074 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')	No		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	No		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	CHAR	(N' ')	No		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	CHAR	(N' ')	No		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	CHAR	(N' ')	No		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	CHAR	(N' ')	No		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	CHAR	(N' ')	No		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	CHAR	(N' ')	No	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	No		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	No		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	No		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	No		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	No		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	No		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	FEORD	Leave provision - Denmark	nvarchar	2	0	CHAR	(N' ')	No		FEORD	Allow NULL?
25	FGPCT	Vacation Bonus Savings Percentage Rate - Denmark	decimal	5	2	DEC	((0))	No		FGPCT
26	FTPCT	Percentage of Vacation Bonus (Denmark)	decimal	5	2	DEC	((0))	No		FTPCT
27	FPFRE	Vacation Bonus / Transfer / Payment Frequency	nvarchar	2	0	CHAR	(N' ')	No		FPFRE	Allow NULL?
28	SHORD	SH agreement	nvarchar	2	0	CHAR	(N' ')	No		SHORD	Allow NULL?
29	SHPCT	Percentage for holiday pay allowance (Denmark)	decimal	5	2	DEC	((0))	No		SHPCT
30	SHBEU	SH-Money net pay per day (upto 18 years old)	decimal	7	2	DEC	((0))	No		SHBEU
31	SHBEO	SH-Money net pay per day (over 18)	decimal	7	2	DEC	((0))	No		SHBEO
32	SHFRE	SH-Money/frequency of transfer/payments	nvarchar	2	0	CHAR	(N' ')	No		SHFRE	Allow NULL?
33	SHNEG	Negative SH balance allowed	char	1	0	CHAR	(N' ')	No		SHNEG	Allow NULL?
34	OFKOD	Leave schema Denmark	nvarchar	2	0	CHAR	(N' ')	No	*	P09_OFKOD	Allow NULL?
35	FZTAG	Number of additional leave days Denmark	decimal	5	2	DEC	((0))	No		P09_FZTAG
36	FETAG	Number of additional leave days Denmark	decimal	5	2	DEC	((0))	No		P09_FETAG
37	F6TAG	Number of leave days guaranteed in §6A (DK)	decimal	5	2	DEC	((0))	No		P09_F6TAG
38	CALJ0	Processing leave account, year 0	char	1	0	CHAR	(N' ')	No		P09_CALJ0	Allow NULL?
39	DELJ0	Reset leave, year 0	char	1	0	CHAR	(N' ')	No		P09_DELJ0	Allow NULL?
40	ABMET	Payroll method - PBS field (DK)	char	1	0	CHAR	(N' ')	No		P09_ABMET	Allow NULL?
41	CALZU	Indicator: Payroll accounting savings percentage rate (DK)	char	1	0	CHAR	(N' ')	Yes		P09_CALZU	Allow NULL?
42	CALEX	Indicator: Payroll accounting bonus percentage rate (DK)	char	1	0	CHAR	(N' ')	Yes		P09_CALEX	Allow NULL?
43	SHCLR	Indicator: Closing SH balance (DK)	char	1	0	CHAR	(N' ')	Yes		P09_SHCLR	Allow NULL?
44	SHTCO	Leave account transaction key (DK)	char	1	0	CHAR	(N' ')	Yes		P09_SHTCO	Allow NULL?
45	FKNUM	Leave account, daily exception factor, FORM40 col.40	decimal	4	2	DEC	((0))	Yes		P09_FKNUM
46	FKSIC	Indicator: calculate sick/leave hours (DK)	char	1	0	CHAR	(N' ')	Yes		P09_FKSIC	Allow NULL?
47	FKFRE	Indicator: Leave account, exemption card (DK)	char	1	0	CHAR	(N' ')	Yes		P09_FKFRE	Allow NULL?
48	CALDAT	Action date, for one-off payroll actions (DK)	nvarchar	8	0	DATS	(N'00000000')	Yes		P09_AKDAT	Allow NULL?
49	SHIND	Action date, for one-off payroll actions (DK)	nvarchar	8	0	DATS	(N'00000000')	Yes		P09_AKDAT	Allow NULL?
50	SHPOR	SH individual payment percentage rate (DK)	decimal	6	0	DEC	((0))	Yes		P09_SHPOR
51	SHDKK	SH individual payment amount (DK)	decimal	9	2	CURR	((0))	Yes		P09_SHDKK
52	SHCUR	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
53	SHCSA	Indicator: SH individual closing (DK)	char	1	0	CHAR	(N' ')	Yes		P09_SHCSA	Allow NULL?
54	SHOR2	SH regulations (DK)	char	1	0	CHAR	(N' ')	Yes		P09_SHOR2	Allow NULL?
55	TPROM	Days per period of the leave basis (DK)	decimal	4	2	DEC	((0))	Yes		P09_TPROM
56	FERIE	Indicator: Pay into FerieKonto for each period (DK)	char	1	0	CHAR	(N' ')	Yes		P09_FERIE	Allow NULL?
57	UKBRP	Payroll period for determining time period	nvarchar	2	0	NUMC	(N'00')	Yes		PNPPABRP	Allow NULL?
58	UKBRJ	Payroll year for determining time period	nvarchar	4	0	NUMC	(N'0000')	Yes		PNPPABRJ	Allow NULL?
59	CALJ1	Processing leave account, year 1	char	1	0	CHAR	(N' ')	Yes		P09_CALJ1	Allow NULL?
60	CALJ2	Processing leave account, year 2	char	1	0	CHAR	(N' ')	Yes		P09_CALJ2	Allow NULL?
61	DELJ1	Reset leave, year-1	char	1	0	CHAR	(N' ')	Yes		P09_DELJ1	Allow NULL?
62	DELJ2	Reset leave, year-2	char	1	0	CHAR	(N' ')	Yes		P09_DELJ2	Allow NULL?
63	UTYPE	Leave type, duplicate of SUPTYPE DK	nvarchar	4	0	CHAR	(N' ')	Yes		P09_URLHA	Allow NULL?
64	ASME0	Payment method year 0	char	1	0	CHAR	(N' ')	Yes		P09_ASME0	Allow NULL?
65	ARWT0	Garnishment Wage Type for Vacation Bonus Deduction, Year 0	nvarchar	4	0	CHAR	(N' ')	Yes	*	P09_ARWT0	Allow NULL?
66	CVM1	Code for Vacation Bonus Taxation and Payment, Base Value 1	char	1	0	CHAR	(N' ')	Yes		P09_CVM1	Allow NULL?
67	CVM2	Code for Vacation Bonus Taxation and Payment, Bse Val. 2	char	1	0	CHAR	(N' ')	Yes		P09_CVM2	Allow NULL?
68	CVM3	Code for Vacation Bonus Taxation and Pymnt, Bse Val. 3	char	1	0	CHAR	(N' ')	Yes		P09_CVM3	Allow NULL?
69	VMTXD	Code for Vacation Bonus Payment that is already Taxed	char	1	0	CHAR	(N' ')	Yes		P09_VMTXD	Allow NULL?
70	TXSH	Code for SH balance taxation and payment	char	1	0	CHAR	(N' ')	Yes		P09_TXSH	Allow NULL?
71	TXRT0	Percentage for Taxing Vacation Bonus, Year 0	decimal	2	0	DEC	((0))	Yes		P09_TXRT0
72	BPA0	Basic tax exemption, year 0	decimal	7	2	CURR	((0))	Yes		P09_BPA0
73	FRIK0	EE taxation with exemption card, year 0	char	1	0	CHAR	(N' ')	Yes		P09_FRIK0	Allow NULL?
74	VM1	Vacation Bonus to be Calculated, Base Value 1	decimal	8	2	CURR	((0))	Yes		P09_VM1
75	VM2	Vacation Bonus to be Calculated, Base Value 2	decimal	8	2	CURR	((0))	Yes		P09_VM2
76	VM3	Vacation Bonus to be Calculated, Base Value 3	decimal	8	2	CURR	((0))	Yes		P09_VM3
77	CVADA	Code for payment of leave days	char	1	0	CHAR	(N' ')	Yes		P09_CVADA	Allow NULL?
78	SMTDT	Payroll Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P09_SMTDT	Allow NULL?
79	VADA0	No. of leave days, year 0	decimal	4	2	DEC	((0))	Yes		P09_VADA0
80	CXVS0	Code for performing payroll for extra leave bonus, year 0	char	1	0	CHAR	(N' ')	Yes		P09_CXVS0	Allow NULL?
81	XVS0	Extra leave bonus to be calculated, year 0	decimal	8	2	CURR	((0))	Yes		P09_XVS0
82	CCARE	Code for payment of support days not used	char	1	0	CHAR	(N' ')	Yes		P09_CCARE	Allow NULL?
83	ASME1	Payment method year 1	char	1	0	CHAR	(N' ')	Yes		P09_ASME1	Allow NULL?
84	ARWT1	Garnishment Wage Types for Deducting Vac.Bonus Year 1	nvarchar	4	0	CHAR	(N' ')	Yes	*	P09_ARWT1	Allow NULL?
85	TXRT1	Percentage for Vacation Bonus Taxation, Year-1	decimal	2	0	DEC	((0))	Yes		P09_TXRT1
86	BPA1	Basic tax exemption, year-1	decimal	7	2	CURR	((0))	Yes		P09_BPA1
87	FRIK1	EE taxation with exemption card, year-1	char	1	0	CHAR	(N' ')	Yes		P09_FRIK1	Allow NULL?
88	VACSU	Leave bonus to be calculated	decimal	8	2	CURR	((0))	Yes		P09_VACSU
89	VADA1	No. of leave days, year-1	decimal	4	2	DEC	((0))	Yes		P09_VADA1
90	VARE1	Leave remuneration, year-1	decimal	8	2	CURR	((0))	Yes		P09_VARE1
91	CXVS1	Code for calculating extra leave bonus, year-1	char	1	0	CHAR	(N' ')	Yes		P09_CXVS1	Allow NULL?
92	XVS1	Extra leave bonus to be calculated, year-1	decimal	8	2	CURR	((0))	Yes		P09_XVS1
93	FERK1	Number of leave days on leave card, year-1	decimal	4	2	DEC	((0))	Yes		P09_FERK1
94	ASME2	Payment method year-2	char	1	0	CHAR	(N' ')	Yes		P09_ASME2	Allow NULL?
95	ARWT2	Garn. Wage Type for Deducting Vac. Bonus, Year 2	nvarchar	4	0	CHAR	(N' ')	Yes	*	P09_ARWT2	Allow NULL?
96	TXRT2	Percentage for Vacation Bonus Taxation, Year-2	decimal	2	0	DEC	((0))	Yes		P09_TXRT2
97	BPA2	Basic tax exemption, year-2	decimal	7	2	CURR	((0))	Yes		P09_BPA2
98	FRIK2	EE taxation with exemption card (Frikort), year-2	char	1	0	CHAR	(N' ')	Yes		P09_FRIK2	Allow NULL?
99	VADA2	No. of leave days, year-2	decimal	4	2	DEC	((0))	Yes		P09_VADA2
100	VARE2	Leave remuneration, year-2	decimal	8	2	CURR	((0))	Yes		P09_VARE2
101	CXVS2	Code for calculating extra leave bonus, year-2	char	1	0	CHAR	(N' ')	Yes		P09_CXVS2	Allow NULL?
102	XVS2	Extra leave bonus to be calculated, year-2	decimal	8	2	CURR	((0))	Yes		P09_XVS2
103	FERK2	Number of leave days on leave card, year-2	decimal	4	2	DEC	((0))	Yes		P09_FERK2
104	IGNJ0	No processing of leave, year 0	char	1	0	CHAR	(N' ')	Yes		P09_IGNJ0	Allow NULL?
105	IGNJ1	No processing of leave, year 1	char	1	0	CHAR	(N' ')	Yes		P09_IGNJ1	Allow NULL?
106	IGNJ2	No processing of leave, year 2	char	1	0	CHAR	(N' ')	Yes		P09_IGNJ2	Allow NULL?
107	SVM1	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SVM1	Allow NULL?
108	SVM2	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SVM2	Allow NULL?
109	SVM3	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SVM3	Allow NULL?
110	STAX0	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_STAX0	Allow NULL?
111	SVD0	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SVD0	Allow NULL?
112	SXVS0	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SXVS0	Allow NULL?
113	SSD	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SSD	Allow NULL?
114	STAX1	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_STAX1	Allow NULL?
115	SVD1	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SVD1	Allow NULL?
116	SVS	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SVS	Allow NULL?
117	SXVS1	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SXVS1	Allow NULL?
118	SVR1	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SVR1	Allow NULL?
119	SFK1	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SFK1	Allow NULL?
120	STAX2	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_STAX2	Allow NULL?
121	SVD2	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SVD2	Allow NULL?
122	SXVS2	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SXVS2	Allow NULL?
123	SVR2	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SVR2	Allow NULL?
124	SFK2	Default identifier for leave handling	char	1	0	CHAR	(N' ')	Yes		P09_SFK2	Allow NULL?
125	FWV0N	No Payment 1/2 % Leave Accumulation for Year - 0	char	1	0	CHAR	(N' ')	Yes		P09_FWV0N	Allow NULL?
126	FWV0F	Payment 1/2 % Leave Accumulation Year - 0 for Holiday Acct	char	1	0	CHAR	(N' ')	Yes		P09_FWV0F	Allow NULL?
127	FWV0K	Payment 1/2 % Leave Accumulation for Leave Card Y-0	char	1	0	CHAR	(N' ')	Yes		P09_FWV0K	Allow NULL?
128	FWV0C	Payment for 1/2 % Leave Accumulation in Cash Y-0	char	1	0	CHAR	(N' ')	Yes		P09_FWV0C	Allow NULL?
129	FWV0S	Standard Amount for Payment 1/2 % Leave Accumulation Y-0	char	1	0	CHAR	(N' ')	Yes		P09_FWV0S	Allow NULL?
130	FWV0A	Special Payment Amount for 1/2 % Leave Accumulation Y-0	char	1	0	CHAR	(N' ')	Yes		P09_FWV0A	Allow NULL?
131	FWV0B	Special Payment Amount for 1/2 % Leave Accumulation Year-0	decimal	8	2	CURR	((0))	Yes		P09_FWV0B
132	FWV1N	No Payment 1/2 % Leave Accumulation for Year - 1	char	1	0	CHAR	(N' ')	Yes		P09_FWV1N	Allow NULL?
133	FWV1F	Payment 1/2 % Leave Accumulation Year - 1 for Holiday Acct.	char	1	0	CHAR	(N' ')	Yes		P09_FWV1F	Allow NULL?
134	FWV1K	Payment 1/2 % Leave Accumulation for Leave Card Y-1	char	1	0	CHAR	(N' ')	Yes		P09_FWV1K	Allow NULL?
135	FWV1C	Payment 1/2 % Leave Accumulation in Cash Year-1	char	1	0	CHAR	(N' ')	Yes		P09_FWV1C	Allow NULL?
136	FWV1S	Standard Amount for Payment 1/2 % Leave Accumulation Y-1	char	1	0	CHAR	(N' ')	Yes		P09_FWV1S	Allow NULL?
137	FWV1A	Special Payment Amount 1/2 % Leave Accumulation Y-1	char	1	0	CHAR	(N' ')	Yes		P09_FWV1A	Allow NULL?
138	FWV1B	Special Payment Amount 1/2 % Leave Accumulation Year-1	decimal	8	2	CURR	((0))	Yes		P09_FWV1B
139	FWV2N	No Payment 1/2 % Leave Accumulation Year - 2	char	1	0	CHAR	(N' ')	Yes		P09_FWV2N	Allow NULL?
140	FWV2F	Payment 1/2 % Leave Accumulation Year - 2 for Holiday Acct.	char	1	0	CHAR	(N' ')	Yes		P09_FWV2F	Allow NULL?
141	FWV2K	Payment 1/2 % Leave Accumulation for Leave Card Y-2	char	1	0	CHAR	(N' ')	Yes		P09_FWV2K	Allow NULL?
142	FWV2C	Payment 1/2 % Leave Accumulation in Cash Year-2	char	1	0	CHAR	(N' ')	Yes		P09_FWV2C	Allow NULL?
143	FWV2S	Standard Amount for Payment 1/2 % Leave Accum. Y-2	char	1	0	CHAR	(N' ')	Yes		P09_FWV2S	Allow NULL?
144	FWV2A	Special Payment Amount 1/2 % Leave Accumulation Y-2	char	1	0	CHAR	(N' ')	Yes		P09_FWV2A	Allow NULL?
145	FWV2B	Special Payment Amount 1/2 % Leave Accumulation Year-2	decimal	8	2	CURR	((0))	Yes		P09_FWV2B
146	PAYTY	Payroll type	char	1	0	CHAR	(N' ')	Yes		PAYTY	Allow NULL?
147	PAYID	Payroll Identifier	char	1	0	CHAR	(N' ')	Yes		PAYID	Allow NULL?
148	FTUBT	Payment of Leave Bonus	char	1	0	CHAR	(N' ')	Yes		P09_FTUBT	Allow NULL?
149	NODIF	No Calculation of Leave Difference	char	1	0	CHAR	(N' ')	Yes		P09_NODIF	Allow NULL?
150	URLJJ	Leave year	nvarchar	4	0	NUMC	(N'0000')	Yes		URLJJ	Allow NULL?
151	OBJP0	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
152	UAR00	Leave type	nvarchar	2	0	CHAR	(N' ')	Yes	*	URART	Allow NULL?
153	UAR01	Leave type	nvarchar	2	0	CHAR	(N' ')	Yes	*	URART	Allow NULL?
154	UAN00	Leave entitlement	decimal	10	5	DEC	((0))	Yes		PTM_HENTITLE

TOP ERP 6.0 | PA0074 INDEXES

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

154 COLUMNS | 1 INDEXES | ERP 6.0 | PA0074 TABLE

TOP ERP 6.0 | PA0074 COLUMNS

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

154 COLUMNS | 1 INDEXES | ERP 6.0 | PA0074 TABLE

TOPERP 6.0 | PA0074 COLUMNS

TOPERP 6.0 | PA0074 INDEXES

TOP ERP 6.0 | PA0074 COLUMNS

TOP ERP 6.0 | PA0074 INDEXES