	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

209 COLUMNS | 1 INDEXES | ERP 6.0 | PA0560 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Japan
1	ERP EHP7	6.0	PA0560	209	1	HR Master Record: Infotype 0560	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, ANSAL, ANCUR, ADRTE, WAER1, LGA01, BET01, ANZ01, EIN01, OPK01, LGA02, BET02, ANZ02, EIN02, OPK02, LGA03, BET03, ANZ03, EIN03, OPK03, LGA04, BET04, ANZ04, EIN04, OPK04, LGA05, BET05, ANZ05, EIN05, OPK05, LGA06, BET06, ANZ06, EIN06, OPK06, LGA07, BET07, ANZ07, EIN07, OPK07, LGA08, BET08, ANZ08, EIN08, OPK08, LGA09, BET09, ANZ09, EIN09, OPK09, LGA10, BET10, ANZ10, EIN10, OPK10, LGA11, BET11, ANZ11, EIN11, OPK11, LGA12, BET12, ANZ12, EIN12, OPK12, LGA13, BET13, ANZ13, EIN13, OPK13, LGA14, BET14, ANZ14, EIN14, OPK14, LGA15, BET15, ANZ15, EIN15, OPK15, LGA16, BET16, ANZ16, EIN16, OPK16, LGA17, BET17, ANZ17, EIN17, OPK17, LGA18, BET18, ANZ18, EIN18, OPK18, LGA19, BET19, ANZ19, EIN19, OPK19, LGA20, BET20, ANZ20, EIN20, OPK20, WAER2, LGR01, BER01, ANH01, EIH01, OPE01, LGR02, BER02, ANH02, EIH02, OPE02, LGR03, BER03, ANH03, EIH03, OPE03, LGR04, BER04, ANH04, EIH04, OPE04, LGR05, BER05, ANH05, EIH05, OPE05, LGR06, BER06, ANH06, EIH06, OPE06, LGR07, BER07, ANH07, EIH07, OPE07, LGR08, BER08, ANH08, EIH08, OPE08, LGR09, BER09, ANH09, EIH09, OPE09, LGR10, BER10, ANH10, EIH10, OPE10, IND01, IND02, IND03, IND04, IND05, IND06, IND07, IND08, IND09, IND10, IND11, IND12, IND13, IND14, IND15, IND16, IND17, IND18, IND19, IND20, INB01, INB02, INB03, INB04, INB05, INB06, INB07, INB08, INB09, INB10, PYCLS FROM PA0560

TOP ERP 6.0 | PA0560 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	ANSAL	Annual salary	decimal	15	2	CURR	((0))	Yes		ANSAL_15
25	ANCUR	Currency Key for Annual Salary	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	ANCUR	Allow NULL?
26	ADRTE	Assumed domestic deduction rate (Overseas salary) JP	decimal	4	2	DEC	((0))	Yes		P22J_ADRTE
27	WAER1	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
28	LGA01	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
29	BET01	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
30	ANZ01	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
31	EIN01	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
32	OPK01	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
33	LGA02	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
34	BET02	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
35	ANZ02	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
36	EIN02	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
37	OPK02	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
38	LGA03	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
39	BET03	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
40	ANZ03	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
41	EIN03	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
42	OPK03	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
43	LGA04	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
44	BET04	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
45	ANZ04	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
46	EIN04	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
47	OPK04	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
48	LGA05	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
49	BET05	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
50	ANZ05	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
51	EIN05	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
52	OPK05	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
53	LGA06	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
54	BET06	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
55	ANZ06	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
56	EIN06	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
57	OPK06	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
58	LGA07	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
59	BET07	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
60	ANZ07	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
61	EIN07	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
62	OPK07	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
63	LGA08	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
64	BET08	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
65	ANZ08	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
66	EIN08	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
67	OPK08	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
68	LGA09	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
69	BET09	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
70	ANZ09	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
71	EIN09	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
72	OPK09	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
73	LGA10	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
74	BET10	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
75	ANZ10	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
76	EIN10	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
77	OPK10	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
78	LGA11	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
79	BET11	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
80	ANZ11	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
81	EIN11	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
82	OPK11	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
83	LGA12	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
84	BET12	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
85	ANZ12	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
86	EIN12	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
87	OPK12	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
88	LGA13	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
89	BET13	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
90	ANZ13	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
91	EIN13	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
92	OPK13	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
93	LGA14	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
94	BET14	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
95	ANZ14	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
96	EIN14	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
97	OPK14	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
98	LGA15	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
99	BET15	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
100	ANZ15	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
101	EIN15	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
102	OPK15	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
103	LGA16	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
104	BET16	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
105	ANZ16	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
106	EIN16	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
107	OPK16	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
108	LGA17	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
109	BET17	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
110	ANZ17	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
111	EIN17	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
112	OPK17	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
113	LGA18	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
114	BET18	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
115	ANZ18	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
116	EIN18	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
117	OPK18	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
118	LGA19	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
119	BET19	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
120	ANZ19	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
121	EIN19	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
122	OPK19	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
123	LGA20	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
124	BET20	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
125	ANZ20	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
126	EIN20	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
127	OPK20	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
128	WAER2	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
129	LGR01	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
130	BER01	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
131	ANH01	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
132	EIH01	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
133	OPE01	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
134	LGR02	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
135	BER02	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
136	ANH02	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
137	EIH02	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
138	OPE02	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
139	LGR03	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
140	BER03	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
141	ANH03	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
142	EIH03	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
143	OPE03	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
144	LGR04	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
145	BER04	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
146	ANH04	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
147	EIH04	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
148	OPE04	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
149	LGR05	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
150	BER05	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
151	ANH05	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
152	EIH05	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
153	OPE05	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
154	LGR06	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
155	BER06	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
156	ANH06	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
157	EIH06	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
158	OPE06	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
159	LGR07	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
160	BER07	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
161	ANH07	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
162	EIH07	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
163	OPE07	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
164	LGR08	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
165	BER08	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
166	ANH08	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
167	EIH08	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
168	OPE08	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
169	LGR09	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
170	BER09	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
171	ANH09	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
172	EIH09	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
173	OPE09	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
174	LGR10	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	T512Z	LGART	Allow NULL?
175	BER10	Wage Type Amount for Payments	decimal	13	2	CURR	((0))	Yes		PAD_AMT7S
176	ANH10	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
177	EIH10	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	*	PT_ZEINH	Allow NULL?
178	OPE10	Operation Indicator for Wage Types	char	1	0	CHAR	(N' ')	Yes		OPKEN	Allow NULL?
179	IND01	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
180	IND02	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
181	IND03	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
182	IND04	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
183	IND05	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
184	IND06	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
185	IND07	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
186	IND08	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
187	IND09	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
188	IND10	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
189	IND11	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
190	IND12	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
191	IND13	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
192	IND14	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
193	IND15	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
194	IND16	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
195	IND17	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
196	IND18	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
197	IND19	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
198	IND20	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
199	INB01	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
200	INB02	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
201	INB03	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
202	INB04	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
203	INB05	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
204	INB06	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
205	INB07	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
206	INB08	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
207	INB09	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
208	INB10	Indicator for indirect valuation	char	1	0	CHAR	(N' ')	Yes		INDBW	Allow NULL?
209	PYCLS	Payment class	char	1	0	CHAR	(N' ')	Yes	T5J88	P22J_TXCLS	Allow NULL?

TOP ERP 6.0 | PA0560 INDEXES

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

209 COLUMNS | 1 INDEXES | ERP 6.0 | PA0560 TABLE

TOP ERP 6.0 | PA0560 COLUMNS

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

209 COLUMNS | 1 INDEXES | ERP 6.0 | PA0560 TABLE

TOPERP 6.0 | PA0560 COLUMNS

TOPERP 6.0 | PA0560 INDEXES

TOP ERP 6.0 | PA0560 COLUMNS

TOP ERP 6.0 | PA0560 INDEXES