	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

255 COLUMNS | 1 INDEXES | ERP 6.0 | PA0660 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA0660	255	1	HR master record infortype 0660	Personnel Administration

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, EMRTX, SIBEG, SIEND, HIRED, PRYEA, ACYEA, WAERS, MSA01, MSA02, MSA03, MSA04, MSA05, MSA06, MSA07, MSA08, MSA09, MSA10, MSA11, MSA12, MSA13, MSA14, MSA15, MSA16, MSA17, MSA18, MSA19, MSA20, MSA21, MSA22, MSA23, MSA24, ABE01, AEN01, ACO01, ABE02, AEN02, ACO02, ABE03, AEN03, ACO03, ABE04, AEN04, ACO04, ABE05, AEN05, ACO05, ABE06, AEN06, ACO06, ABE07, AEN07, ACO07, ABE08, AEN08, ACO08, ABE09, AEN09, ACO09, ABE10, AEN10, ACO10, ABE11, AEN11, ACO11, ABE12, AEN12, ACO12, ABE13, AEN13, ACO13, ABE14, AEN14, ACO14, ABE15, AEN15, ACO15, ABE16, AEN16, ACO16, ABE17, AEN17, ACO17, ABE18, AEN18, ACO18, ABE19, AEN19, ACO19, ABE20, AEN20, ACO20, NRJ01, NRI01, NRM01, NRD01, NRJ02, NRI02, NRM02, NRD02, NRJ03, NRI03, NRM03, NRD03, NRJ04, NRI04, NRM04, NRD04, NRJ05, NRI05, NRM05, NRD05, NRJ06, NRI06, NRM06, NRD06, NRJ07, NRI07, NRM07, NRD07, NRJ08, NRI08, NRM08, NRD08, NRJ09, NRI09, NRM09, NRD09, NRJ10, NRI10, NRM10, NRD10, NRJ11, NRI11, NRM11, NRD11, NRJ12, NRI12, NRM12, NRD12, NRJ13, NRI13, NRM13, NRD13, NRJ14, NRI14, NRM14, NRD14, NRJ15, NRI15, NRM15, NRD15, NRJ16, NRI16, NRM16, NRD16, NRJ17, NRI17, NRM17, NRD17, NRJ18, NRI18, NRM18, NRD18, NRJ19, NRI19, NRM19, NRD19, NRJ20, NRI20, NRM20, NRD20, KIF01, KIF02, KIF03, KIF04, KIF05, KIF06, KIF07, KIF08, KIF09, KIF10, KIF11, KIF12, KIF13, KIF14, KIF15, KIF16, KIF17, KIF18, KIF19, KIF20, JOGVT, LGA01, LGA02, LGA03, LGA04, LGA05, LGA06, LGA07, LGA08, LGA09, LGA10, LGA11, LGA12, LGA13, LGA14, LGA15, LGA16, LGA17, LGA18, LGA19, LGA20, AWA01, AWA02, AWA03, AWA04, AWA05, AWA06, AWA07, AWA08, AWA09, AWA10, AWA11, AWA12, AWA13, AWA14, AWA15, AWA16, AWA17, AWA18, AWA19, AWA20 FROM PA0660

TOP ERP 6.0 | PA0660 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	EMRTX	Name of employer	nvarchar	50	0	CHAR	(N' ')	Yes		P21_EMRTX	Allow NULL?
25	SIBEG	Insurance relationship from	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_SIBEG	Allow NULL?
26	SIEND	Insurance relationship to	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_SIEND	Allow NULL?
27	HIRED	Entry date	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_HIRED	Allow NULL?
28	PRYEA	Year before entry	nvarchar	4	0	NUMC	(N'0000')	Yes		P21_PRYEA	Allow NULL?
29	ACYEA	Entry year	nvarchar	4	0	NUMC	(N'0000')	Yes		P21_ACYEA	Allow NULL?
30	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
31	MSA01	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
32	MSA02	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
33	MSA03	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
34	MSA04	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
35	MSA05	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
36	MSA06	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
37	MSA07	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
38	MSA08	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
39	MSA09	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
40	MSA10	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
41	MSA11	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
42	MSA12	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
43	MSA13	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
44	MSA14	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
45	MSA15	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
46	MSA16	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
47	MSA17	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
48	MSA18	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
49	MSA19	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
50	MSA20	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
51	MSA21	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
52	MSA22	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
53	MSA23	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
54	MSA24	Monthly income (contribution paid)	decimal	9	2	CURR	((0))	Yes		P21_INCOM
55	ABE01	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
56	AEN01	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
57	ACO01	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
58	ABE02	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
59	AEN02	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
60	ACO02	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
61	ABE03	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
62	AEN03	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
63	ACO03	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
64	ABE04	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
65	AEN04	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
66	ACO04	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
67	ABE05	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
68	AEN05	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
69	ACO05	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
70	ABE06	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
71	AEN06	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
72	ACO06	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
73	ABE07	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
74	AEN07	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
75	ACO07	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
76	ABE08	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
77	AEN08	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
78	ACO08	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
79	ABE09	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
80	AEN09	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
81	ACO09	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
82	ABE10	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
83	AEN10	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
84	ACO10	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
85	ABE11	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
86	AEN11	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
87	ACO11	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
88	ABE12	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
89	AEN12	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
90	ACO12	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
91	ABE13	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
92	AEN13	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
93	ACO13	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
94	ABE14	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
95	AEN14	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
96	ACO14	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
97	ABE15	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
98	AEN15	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
99	ACO15	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
100	ABE16	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
101	AEN16	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
102	ACO16	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
103	ABE17	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
104	AEN17	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
105	ACO17	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
106	ABE18	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
107	AEN18	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
108	ACO18	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
109	ABE19	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
110	AEN19	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
111	ACO19	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
112	ABE20	Absence begin	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABBEG	Allow NULL?
113	AEN20	Absence end	nvarchar	8	0	DATS	(N'00000000')	Yes		P21_ABEND	Allow NULL?
114	ACO20	Absence type	char	1	0	CHAR	(N' ')	Yes		P21_ACODE	Allow NULL?
115	NRJ01	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
116	NRI01	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
117	NRM01	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
118	NRD01	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
119	NRJ02	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
120	NRI02	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
121	NRM02	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
122	NRD02	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
123	NRJ03	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
124	NRI03	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
125	NRM03	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
126	NRD03	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
127	NRJ04	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
128	NRI04	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
129	NRM04	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
130	NRD04	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
131	NRJ05	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
132	NRI05	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
133	NRM05	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
134	NRD05	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
135	NRJ06	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
136	NRI06	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
137	NRM06	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
138	NRD06	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
139	NRJ07	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
140	NRI07	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
141	NRM07	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
142	NRD07	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
143	NRJ08	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
144	NRI08	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
145	NRM08	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
146	NRD08	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
147	NRJ09	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
148	NRI09	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
149	NRM09	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
150	NRD09	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
151	NRJ10	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
152	NRI10	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
153	NRM10	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
154	NRD10	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
155	NRJ11	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
156	NRI11	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
157	NRM11	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
158	NRD11	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
159	NRJ12	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
160	NRI12	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
161	NRM12	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
162	NRD12	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
163	NRJ13	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
164	NRI13	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
165	NRM13	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
166	NRD13	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
167	NRJ14	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
168	NRI14	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
169	NRM14	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
170	NRD14	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
171	NRJ15	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
172	NRI15	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
173	NRM15	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
174	NRD15	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
175	NRJ16	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
176	NRI16	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
177	NRM16	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
178	NRD16	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
179	NRJ17	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
180	NRI17	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
181	NRM17	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
182	NRD17	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
183	NRJ18	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
184	NRI18	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
185	NRM18	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
186	NRD18	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
187	NRJ19	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
188	NRI19	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
189	NRM19	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
190	NRD19	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
191	NRJ20	Irregular income - payment title	nvarchar	15	0	CHAR	(N' ')	Yes		P21_NRJGC	Allow NULL?
192	NRI20	Irregular income - payment amount	decimal	9	2	CURR	((0))	Yes		P21_NRINC
193	NRM20	Irregular income - payment relevance month	nvarchar	6	0	NUMC	(N'000000')	Yes		P21_NRMON	Allow NULL?
194	NRD20	Irregular income - payment relevance duration	nvarchar	5	0	NUMC	(N'00000')	Yes		P21_NRDYS	Allow NULL?
195	KIF01		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
196	KIF02		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
197	KIF03		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
198	KIF04		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
199	KIF05		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
200	KIF06		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
201	KIF07		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
202	KIF08		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
203	KIF09		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
204	KIF10		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
205	KIF11		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
206	KIF12		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
207	KIF13		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
208	KIF14		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
209	KIF15		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
210	KIF16		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
211	KIF17		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
212	KIF18		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
213	KIF19		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
214	KIF20		nvarchar	8	0		(N'00000000')	Yes			Allow NULL?
215	JOGVT		char	1	0		(N' ')	Yes			Allow NULL?
216	LGA01	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
217	LGA02	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
218	LGA03	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
219	LGA04	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
220	LGA05	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
221	LGA06	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
222	LGA07	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
223	LGA08	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
224	LGA09	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
225	LGA10	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
226	LGA11	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
227	LGA12	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
228	LGA13	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
229	LGA14	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
230	LGA15	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
231	LGA16	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
232	LGA17	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
233	LGA18	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
234	LGA19	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
235	LGA20	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T5H4N	LGART	Allow NULL?
236	AWA01	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
237	AWA02	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
238	AWA03	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
239	AWA04	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
240	AWA05	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
241	AWA06	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
242	AWA07	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
243	AWA08	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
244	AWA09	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
245	AWA10	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
246	AWA11	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
247	AWA12	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
248	AWA13	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
249	AWA14	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
250	AWA15	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
251	AWA16	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
252	AWA17	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
253	AWA18	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
254	AWA19	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?
255	AWA20	Attendance or Absence Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	AWART	Allow NULL?

TOP ERP 6.0 | PA0660 INDEXES

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

255 COLUMNS | 1 INDEXES | ERP 6.0 | PA0660 TABLE

TOP ERP 6.0 | PA0660 COLUMNS

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

255 COLUMNS | 1 INDEXES | ERP 6.0 | PA0660 TABLE

TOPERP 6.0 | PA0660 COLUMNS

TOPERP 6.0 | PA0660 INDEXES

TOP ERP 6.0 | PA0660 COLUMNS

TOP ERP 6.0 | PA0660 INDEXES