	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

226 COLUMNS | 1 INDEXES | ERP 6.0 | PA0147 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Japan
1	ERP EHP7	6.0	PA0147	226	1	HR Master Record: Infotype 0147	Japan

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, APPTY, APPID, EVNM1, EVDT1, EVNM2, EVDT2, EVNMF, EVDTF, PSREG, DFGRP, PSCHG, DFLVL, APRT1, APPT1, APRT2, APPT2, APRTF, APPTF, APF0A, APD0A, APR0A, APP0A, APF0B, APD0B, APR0B, APP0B, APF0C, APD0C, APR0C, APP0C, APF0D, APD0D, APR0D, APP0D, APF0E, APD0E, APR0E, APP0E, APF0F, APD0F, APR0F, APP0F, APF01, APD01, APR01, APP01, APF02, APD02, APR02, APP02, APF03, APD03, APR03, APP03, APF04, APD04, APR04, APP04, APF05, APD05, APR05, APP05, APF06, APD06, APR06, APP06, APF07, APD07, APR07, APP07, APF08, APD08, APR08, APP08, APF09, APD09, APR09, APP09, APF10, APD10, APR10, APP10, APF11, APD11, APR11, APP11, APF12, APD12, APR12, APP12, APF13, APD13, APR13, APP13, APF14, APD14, APR14, APP14, APF15, APD15, APR15, APP15, APF16, APD16, APR16, APP16, APF17, APD17, APR17, APP17, APF18, APD18, APR18, APP18, APF19, APD19, APR19, APP19, APF20, APD20, APR20, APP20, APF21, APD21, APR21, APP21, APF22, APD22, APR22, APP22, APF23, APD23, APR23, APP23, APF24, APD24, APR24, APP24, APF25, APD25, APR25, APP25, APF26, APD26, APR26, APP26, APF27, APD27, APR27, APP27, APF28, APD28, APR28, APP28, APF29, APD29, APR29, APP29, APF30, APD30, APR30, APP30, APF31, APD31, APR31, APP31, APF32, APD32, APR32, APP32, APF33, APD33, APR33, APP33, APF34, APD34, APR34, APP34, APF35, APD35, APR35, APP35, APF36, APD36, APR36, APP36, APF37, APD37, APR37, APP37, APF38, APD38, APR38, APP38, APF39, APD39, APR39, APP39, APF40, APD40, APR40, APP40, KTRAT FROM PA0147

TOP ERP 6.0 | PA0147 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	APPTY	Personal appraisal type JP	nvarchar	4	0	CHAR	(N' ')	Yes	*	P22J_APPTY	Allow NULL?
25	APPID	Indicator for Personal Appraisal JP	nvarchar	2	0	CHAR	(N' ')	Yes		P22J_APPID	Allow NULL?
26	EVNM1	Name of 1st evaluator	nvarchar	25	0	CHAR	(N' ')	Yes		P22J_EVNM1	Allow NULL?
27	EVDT1	Date of 1st appraisal evaluation	nvarchar	8	0	DATS	(N'00000000')	Yes		P22J_EVDT1	Allow NULL?
28	EVNM2	Name of 2nd evaluator	nvarchar	25	0	CHAR	(N' ')	Yes		P22J_EVNM2	Allow NULL?
29	EVDT2	Date of 2nd appraisal evaluation	nvarchar	8	0	DATS	(N'00000000')	Yes		P22J_EVDT2	Allow NULL?
30	EVNMF	Name of final evaluator	nvarchar	25	0	CHAR	(N' ')	Yes		P22J_EVNMF	Allow NULL?
31	EVDTF	Date of final appraisal evaluation	nvarchar	8	0	DATS	(N'00000000')	Yes		P22J_EVDTF	Allow NULL?
32	PSREG	Indicator for automatic payscale regrading	char	1	0	CHAR	(N' ')	Yes		P22J_PSREG	Allow NULL?
33	DFGRP	difference of pay scale group	tinyint	3	0	INT1	((0))	Yes		P22J_DFGRP
34	PSCHG	Indicator for payscale group change	char	1	0	CHAR	(N' ')	Yes		P22J_PSCHG	Allow NULL?
35	DFLVL	Difference of pay scale level	tinyint	3	0	INT1	((0))	Yes		P22J_DFLVL
36	APRT1	1st Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APRT1	Allow NULL?
37	APPT1	1st Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPT1
38	APRT2	2nd Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APRT2	Allow NULL?
39	APPT2	2nd Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPT2
40	APRTF	Final Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APRTF	Allow NULL?
41	APPTF	Final Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPTF
42	APF0A	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
43	APD0A	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
44	APR0A	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
45	APP0A	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
46	APF0B	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
47	APD0B	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
48	APR0B	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
49	APP0B	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
50	APF0C	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
51	APD0C	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
52	APR0C	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
53	APP0C	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
54	APF0D	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
55	APD0D	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
56	APR0D	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
57	APP0D	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
58	APF0E	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
59	APD0E	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
60	APR0E	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
61	APP0E	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
62	APF0F	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
63	APD0F	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
64	APR0F	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
65	APP0F	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
66	APF01	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
67	APD01	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
68	APR01	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
69	APP01	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
70	APF02	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
71	APD02	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
72	APR02	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
73	APP02	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
74	APF03	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
75	APD03	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
76	APR03	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
77	APP03	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
78	APF04	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
79	APD04	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
80	APR04	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
81	APP04	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
82	APF05	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
83	APD05	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
84	APR05	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
85	APP05	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
86	APF06	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
87	APD06	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
88	APR06	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
89	APP06	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
90	APF07	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
91	APD07	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
92	APR07	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
93	APP07	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
94	APF08	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
95	APD08	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
96	APR08	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
97	APP08	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
98	APF09	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
99	APD09	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
100	APR09	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
101	APP09	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
102	APF10	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
103	APD10	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
104	APR10	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
105	APP10	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
106	APF11	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
107	APD11	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
108	APR11	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
109	APP11	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
110	APF12	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
111	APD12	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
112	APR12	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
113	APP12	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
114	APF13	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
115	APD13	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
116	APR13	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
117	APP13	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
118	APF14	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
119	APD14	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
120	APR14	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
121	APP14	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
122	APF15	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
123	APD15	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
124	APR15	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
125	APP15	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
126	APF16	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
127	APD16	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
128	APR16	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
129	APP16	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
130	APF17	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
131	APD17	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
132	APR17	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
133	APP17	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
134	APF18	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
135	APD18	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
136	APR18	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
137	APP18	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
138	APF19	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
139	APD19	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
140	APR19	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
141	APP19	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
142	APF20	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
143	APD20	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
144	APR20	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
145	APP20	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
146	APF21	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
147	APD21	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
148	APR21	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
149	APP21	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
150	APF22	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
151	APD22	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
152	APR22	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
153	APP22	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
154	APF23	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
155	APD23	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
156	APR23	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
157	APP23	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
158	APF24	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
159	APD24	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
160	APR24	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
161	APP24	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
162	APF25	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
163	APD25	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
164	APR25	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
165	APP25	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
166	APF26	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
167	APD26	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
168	APR26	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
169	APP26	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
170	APF27	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
171	APD27	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
172	APR27	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
173	APP27	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
174	APF28	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
175	APD28	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
176	APR28	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
177	APP28	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
178	APF29	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
179	APD29	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
180	APR29	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
181	APP29	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
182	APF30	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
183	APD30	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
184	APR30	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
185	APP30	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
186	APF31	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
187	APD31	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
188	APR31	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
189	APP31	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
190	APF32	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
191	APD32	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
192	APR32	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
193	APP32	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
194	APF33	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
195	APD33	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
196	APR33	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
197	APP33	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
198	APF34	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
199	APD34	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
200	APR34	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
201	APP34	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
202	APF35	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
203	APD35	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
204	APR35	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
205	APP35	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
206	APF36	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
207	APD36	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
208	APR36	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
209	APP36	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
210	APF37	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
211	APD37	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
212	APR37	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
213	APP37	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
214	APF38	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
215	APD38	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
216	APR38	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
217	APP38	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
218	APF39	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
219	APD39	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
220	APR39	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
221	APP39	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
222	APF40	Appraisals main feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPFT	Allow NULL?
223	APD40	Appraisal Detail Feature	nvarchar	2	0	CHAR	(N' ')	Yes	*	P22J_APPDT	Allow NULL?
224	APR40	Appraisal Rank Criteria	nvarchar	3	0	CHAR	(N' ')	Yes	T5J46	P22J_APPRK	Allow NULL?
225	APP40	Point value for appraisal criterion	decimal	5	2	DEC	((0))	Yes		P22J_APPPT
226	KTRAT	Reduction rate from attendance	decimal	5	3	DEC	((0))	Yes		P22J_KTRAT

TOP ERP 6.0 | PA0147 INDEXES

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

226 COLUMNS | 1 INDEXES | ERP 6.0 | PA0147 TABLE

TOP ERP 6.0 | PA0147 COLUMNS

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

226 COLUMNS | 1 INDEXES | ERP 6.0 | PA0147 TABLE

TOPERP 6.0 | PA0147 COLUMNS

TOPERP 6.0 | PA0147 INDEXES

TOP ERP 6.0 | PA0147 COLUMNS

TOP ERP 6.0 | PA0147 INDEXES