	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

332 COLUMNS | 1 INDEXES | ERP 6.0 | PA0701 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Australia
1	ERP EHP7	6.0	PA0701	332	1	HR Terminations Data Container : Infotype 0701	Australia

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, TDATE, MASSG, NDATE, PMTHD, CHQDT, OFFCY, BONDT, OCRSN, PAYID, GCERT, PRETP, TSTPR, KTA01, ENT01, ACC01, ZEIN1, KTA02, ENT02, ACC02, ZEIN2, KTA03, ENT03, ACC03, ZEIN3, KTA04, ENT04, ACC04, ZEIN4, KTA05, ENT05, ACC05, ZEIN5, KTA06, ENT06, ACC06, ZEIN6, KTA07, ENT07, ACC07, ZEIN7, KTA08, ENT08, ACC08, ZEIN8, AMONT, NUMBR, ZEINH, UNDLV, SVP78, USDLV, SVPTL, USD78, SVP93, USD93, LLG01, LBT01, LAN01, LZE01, LLG02, LBT02, LAN02, LZE02, LLG03, LBT03, LAN03, LZE03, LLG04, LBT04, LAN04, LZE04, LLG05, LBT05, LAN05, LZE05, LGA01, BET01, ANZ01, ZEN01, LGA02, BET02, ANZ02, ZEN02, LGA03, BET03, ANZ03, ZEN03, LGA04, BET04, ANZ04, ZEN04, LGA05, BET05, ANZ05, ZEN05, LGA06, BET06, ANZ06, ZEN06, LGA07, BET07, ANZ07, ZEN07, LGA08, BET08, ANZ08, ZEN08, LGA09, BET09, ANZ09, ZEN09, LGA10, BET10, ANZ10, ZEN10, ELG01, EBT01, EAN01, EZE01, ELG02, EBT02, EAN02, EZE02, ELG03, EBT03, EAN03, EZE03, ELG04, EBT04, EAN04, EZE04, ELG05, EBT05, EAN05, EZE05, ELG06, EBT06, EAN06, EZE06, SVPTO, SVP83, SVA83, PYE83, PYT83, PYI94, PYEGR, ETPPD, FUN01, ROA01, P9401, FUN02, ROA02, P9402, FUN03, ROA03, P9403, FUN04, ROA04, P9404, FUN05, ROA05, P9405, FUN06, ROA06, P9406, FLRDL, PYTOT, PYINV, ROAMT, RAP94, WAERS, INSTIGATOR, ETPTP, SPLIT, APSFR, TTLEP, TRA01, TRA02, TRA03, TRA04, TRA05, TRA06, TRA07, TRA08, TRA09, TRA10, ELG07, EBT07, EAN07, EZE07, ELG08, EBT08, EAN08, EZE08, ELG09, EBT09, EAN09, EZE09, ELG10, EBT10, EAN10, EZE10, ELG11, EBT11, EAN11, EZE11, ELG12, EBT12, EAN12, EZE12, BTR01, BTR02, BTR03, BTR04, BTR05, BTR06, BTR07, BTR08, BTR09, BTR10, CTR01, CTR02, CTR03, CTR04, CTR05, CTR06, CTR07, CTR08, CTR09, CTR10, CTR11, CTR12, CTR13, CTR14, CTR15, CTR16, CTR17, CTR18, CTR19, CTR20, ELG13, EBT13, EAN13, EZE13, ELG14, EBT14, EAN14, EZE14, ELG15, EBT15, EAN15, EZE15, ELG16, EBT16, EAN16, EZE16, ELG17, EBT17, EAN17, EZE17, ELG18, EBT18, EAN18, EZE18, ELG19, EBT19, EAN19, EZE19, ELG20, EBT20, EAN20, EZE20, MEM01, TAX01, TXF01, MEM02, TAX02, TXF02, MEM03, TAX03, TXF03, MEM04, TAX04, TXF04, MEM05, TAX05, TXF05, MEM06, TAX06, TXF06, EXL01, EXL02, EXL03, EXL04, EXL05, EXL06, EXL07, EXL08, EXL09, EXL10, EXT01, EXT02, EXT03, EXT04, EXT05, EXT06, EXT07, EXT08, EXT09, EXT10 FROM PA0701

TOP ERP 6.0 | PA0701 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	Allow NULL?
24	TDATE	Employee's Termination Date	nvarchar	8	0	Allow NULL?
25	MASSG	Reason for Action	nvarchar	2	0	Allow NULL?
26	NDATE	Notice Date for in Lieu of Notice Payments	nvarchar	8	0	Allow NULL?
27	PMTHD	Payment method by cheque	char	1	0	Allow NULL?
28	CHQDT	date for payment by cheque	nvarchar	8	0	Allow NULL?
29	OFFCY	Payment method by offcycle	char	1	0	Allow NULL?
30	BONDT	Off-cycle payroll payment date	nvarchar	8	0	Allow NULL?
31	OCRSN	Reason for Off-Cycle Payroll	nvarchar	4	0	Allow NULL?
32	PAYID	Payroll Identifier	char	1	0	Allow NULL?
33	GCERT	Print Payment summaries/Group cert (Terminations Australia)	char	1	0	Allow NULL?
34	PRETP	Print ETP Payment sum./Group cert (Terminations Australia)	char	1	0	Allow NULL?
35	TSTPR	Test Run (no update)	char	1	0	Allow NULL?
36	KTA01	Absence Quota Type	nvarchar	2	0	Allow NULL?
37	ENT01	Number of Employee Time Quota	decimal	10	5
38	ACC01	Quota number in transfer pool	decimal	10	5
39	ZEIN1	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
40	KTA02	Absence Quota Type	nvarchar	2	0	Allow NULL?
41	ENT02	Number of Employee Time Quota	decimal	10	5
42	ACC02	Quota number in transfer pool	decimal	10	5
43	ZEIN2	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
44	KTA03	Absence Quota Type	nvarchar	2	0	Allow NULL?
45	ENT03	Number of Employee Time Quota	decimal	10	5
46	ACC03	Quota number in transfer pool	decimal	10	5
47	ZEIN3	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
48	KTA04	Absence Quota Type	nvarchar	2	0	Allow NULL?
49	ENT04	Number of Employee Time Quota	decimal	10	5
50	ACC04	Quota number in transfer pool	decimal	10	5
51	ZEIN4	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
52	KTA05	Absence Quota Type	nvarchar	2	0	Allow NULL?
53	ENT05	Number of Employee Time Quota	decimal	10	5
54	ACC05	Quota number in transfer pool	decimal	10	5
55	ZEIN5	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
56	KTA06	Absence Quota Type	nvarchar	2	0	Allow NULL?
57	ENT06	Number of Employee Time Quota	decimal	10	5
58	ACC06	Quota number in transfer pool	decimal	10	5
59	ZEIN6	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
60	KTA07	Absence Quota Type	nvarchar	2	0	Allow NULL?
61	ENT07	Number of Employee Time Quota	decimal	10	5
62	ACC07	Quota number in transfer pool	decimal	10	5
63	ZEIN7	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
64	KTA08	Absence Quota Type	nvarchar	2	0	Allow NULL?
65	ENT08	Number of Employee Time Quota	decimal	10	5
66	ACC08	Quota number in transfer pool	decimal	10	5
67	ZEIN8	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
68	AMONT	Amount for time quota compensation	decimal	9	2
69	NUMBR	Quota Number Compensated	decimal	10	5
70	ZEINH	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
71	UNDLV	Number of leave days	decimal	6	2
72	SVP78	Number of service days	decimal	8	2
73	USDLV	Number of leave days	decimal	6	2
74	SVPTL	Number of service days	decimal	8	2
75	USD78	Number of leave days	decimal	6	2
76	SVP93	Number of service days	decimal	8	2
77	USD93	Number of leave days	decimal	6	2
78	LLG01	Wage Type	nvarchar	4	0	Allow NULL?
79	LBT01	amount for payment	decimal	10	2
80	LAN01	Number	decimal	7	2
81	LZE01	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
82	LLG02	Wage Type	nvarchar	4	0	Allow NULL?
83	LBT02	amount for payment	decimal	10	2
84	LAN02	Number	decimal	7	2
85	LZE02	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
86	LLG03	Wage Type	nvarchar	4	0	Allow NULL?
87	LBT03	amount for payment	decimal	10	2
88	LAN03	Number	decimal	7	2
89	LZE03	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
90	LLG04	Wage Type	nvarchar	4	0	Allow NULL?
91	LBT04	amount for payment	decimal	10	2
92	LAN04	Number	decimal	7	2
93	LZE04	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
94	LLG05	Wage Type	nvarchar	4	0	Allow NULL?
95	LBT05	amount for payment	decimal	10	2
96	LAN05	Number	decimal	7	2
97	LZE05	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
98	LGA01	Wage Type	nvarchar	4	0	Allow NULL?
99	BET01	amount for payment	decimal	10	2
100	ANZ01	Number	decimal	7	2
101	ZEN01	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
102	LGA02	Wage Type	nvarchar	4	0	Allow NULL?
103	BET02	amount for payment	decimal	10	2
104	ANZ02	Number	decimal	7	2
105	ZEN02	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
106	LGA03	Wage Type	nvarchar	4	0	Allow NULL?
107	BET03	amount for payment	decimal	10	2
108	ANZ03	Number	decimal	7	2
109	ZEN03	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
110	LGA04	Wage Type	nvarchar	4	0	Allow NULL?
111	BET04	amount for payment	decimal	10	2
112	ANZ04	Number	decimal	7	2
113	ZEN04	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
114	LGA05	Wage Type	nvarchar	4	0	Allow NULL?
115	BET05	amount for payment	decimal	10	2
116	ANZ05	Number	decimal	7	2
117	ZEN05	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
118	LGA06	Wage Type	nvarchar	4	0	Allow NULL?
119	BET06	amount for payment	decimal	10	2
120	ANZ06	Number	decimal	7	2
121	ZEN06	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
122	LGA07	Wage Type	nvarchar	4	0	Allow NULL?
123	BET07	amount for payment	decimal	10	2
124	ANZ07	Number	decimal	7	2
125	ZEN07	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
126	LGA08	Wage Type	nvarchar	4	0	Allow NULL?
127	BET08	amount for payment	decimal	10	2
128	ANZ08	Number	decimal	7	2
129	ZEN08	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
130	LGA09	Wage Type	nvarchar	4	0	Allow NULL?
131	BET09	amount for payment	decimal	10	2
132	ANZ09	Number	decimal	7	2
133	ZEN09	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
134	LGA10	Wage Type	nvarchar	4	0	Allow NULL?
135	BET10	amount for payment	decimal	10	2
136	ANZ10	Number	decimal	7	2
137	ZEN10	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
138	ELG01	Wage Type	nvarchar	4	0	Allow NULL?
139	EBT01	amount for payment	decimal	10	2
140	EAN01	Number	decimal	7	2
141	EZE01	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
142	ELG02	Wage Type	nvarchar	4	0	Allow NULL?
143	EBT02	amount for payment	decimal	10	2
144	EAN02	Number	decimal	7	2
145	EZE02	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
146	ELG03	Wage Type	nvarchar	4	0	Allow NULL?
147	EBT03	amount for payment	decimal	10	2
148	EAN03	Number	decimal	7	2
149	EZE03	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
150	ELG04	Wage Type	nvarchar	4	0	Allow NULL?
151	EBT04	amount for payment	decimal	10	2
152	EAN04	Number	decimal	7	2
153	EZE04	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
154	ELG05	Wage Type	nvarchar	4	0	Allow NULL?
155	EBT05	amount for payment	decimal	10	2
156	EAN05	Number	decimal	7	2
157	EZE05	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
158	ELG06	Wage Type	nvarchar	4	0	Allow NULL?
159	EBT06	amount for payment	decimal	10	2
160	EAN06	Number	decimal	7	2
161	EZE06	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
162	SVPTO	Number of service days	decimal	8	2
163	SVP83	Number of service days	decimal	8	2
164	SVA83	Number of service days	decimal	8	2
165	PYE83	Pre July 1983 Component	decimal	10	2
166	PYT83	Post June 1983 Taxed Element	decimal	10	2
167	PYI94	Post June 1994 Invalidity Component	decimal	10	2
168	PYEGR	Gross Amount of Payment	decimal	10	2
169	ETPPD	ETP paid (Terminations Australia)	char	1	0	Allow NULL?
170	FUN01	Subtype	nvarchar	4	0	Allow NULL?
171	ROA01	Total rollover amount	decimal	9	2
172	P9401	Post 94 roll Amount	decimal	9	2
173	FUN02	Subtype	nvarchar	4	0	Allow NULL?
174	ROA02	Total rollover amount	decimal	9	2
175	P9402	Post 94 roll Amount	decimal	9	2
176	FUN03	Subtype	nvarchar	4	0	Allow NULL?
177	ROA03	Total rollover amount	decimal	9	2
178	P9403	Post 94 roll Amount	decimal	9	2
179	FUN04	Subtype	nvarchar	4	0	Allow NULL?
180	ROA04	Total rollover amount	decimal	9	2
181	P9404	Post 94 roll Amount	decimal	9	2
182	FUN05	Subtype	nvarchar	4	0	Allow NULL?
183	ROA05	Total rollover amount	decimal	9	2
184	P9405	Post 94 roll Amount	decimal	9	2
185	FUN06	Subtype	nvarchar	4	0	Allow NULL?
186	ROA06	Total rollover amount	decimal	9	2
187	P9406	Post 94 roll Amount	decimal	9	2
188	FLRDL	Enter Rollover Details later	char	1	0	Allow NULL?
189	PYTOT	Gross Amount of Payment	decimal	10	2
190	PYINV	Post June 1994 Invalidity Component	decimal	10	2
191	ROAMT	Total rollover amount	decimal	9	2
192	RAP94	Post 94 roll Amount	decimal	9	2
193	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
194	INSTIGATOR	Termination Instigator's Name	nvarchar	40	0	Allow NULL?
195	ETPTP	Test Run (no update)	char	1	0	Allow NULL?
196	SPLIT	Test Run (no update)	char	1	0	Allow NULL?
197	APSFR	Gross Amount of Payment	decimal	10	2
198	TTLEP	Gross Amount of Payment	decimal	10	2
199	TRA01	Indicator for Transitional Payment	char	1	0	Allow NULL?
200	TRA02	Indicator for Transitional Payment	char	1	0	Allow NULL?
201	TRA03	Indicator for Transitional Payment	char	1	0	Allow NULL?
202	TRA04	Indicator for Transitional Payment	char	1	0	Allow NULL?
203	TRA05	Indicator for Transitional Payment	char	1	0	Allow NULL?
204	TRA06	Indicator for Transitional Payment	char	1	0	Allow NULL?
205	TRA07	Indicator for Transitional Payment	char	1	0	Allow NULL?
206	TRA08	Indicator for Transitional Payment	char	1	0	Allow NULL?
207	TRA09	Indicator for Transitional Payment	char	1	0	Allow NULL?
208	TRA10	Indicator for Transitional Payment	char	1	0	Allow NULL?
209	ELG07	Wage Type	nvarchar	4	0	Allow NULL?
210	EBT07	amount for payment	decimal	10	2
211	EAN07	Number	decimal	7	2
212	EZE07	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
213	ELG08	Wage Type	nvarchar	4	0	Allow NULL?
214	EBT08	amount for payment	decimal	10	2
215	EAN08	Number	decimal	7	2
216	EZE08	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
217	ELG09	Wage Type	nvarchar	4	0	Allow NULL?
218	EBT09	amount for payment	decimal	10	2
219	EAN09	Number	decimal	7	2
220	EZE09	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
221	ELG10	Wage Type	nvarchar	4	0	Allow NULL?
222	EBT10	amount for payment	decimal	10	2
223	EAN10	Number	decimal	7	2
224	EZE10	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
225	ELG11	Wage Type	nvarchar	4	0	Allow NULL?
226	EBT11	amount for payment	decimal	10	2
227	EAN11	Number	decimal	7	2
228	EZE11	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
229	ELG12	Wage Type	nvarchar	4	0	Allow NULL?
230	EBT12	amount for payment	decimal	10	2
231	EAN12	Number	decimal	7	2
232	EZE12	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
233	BTR01	amount for payment	decimal	10	2
234	BTR02	amount for payment	decimal	10	2
235	BTR03	amount for payment	decimal	10	2
236	BTR04	amount for payment	decimal	10	2
237	BTR05	amount for payment	decimal	10	2
238	BTR06	amount for payment	decimal	10	2
239	BTR07	amount for payment	decimal	10	2
240	BTR08	amount for payment	decimal	10	2
241	BTR09	amount for payment	decimal	10	2
242	BTR10	amount for payment	decimal	10	2
243	CTR01	Split ETP Counter	tinyint	3	0
244	CTR02	Split ETP Counter	tinyint	3	0
245	CTR03	Split ETP Counter	tinyint	3	0
246	CTR04	Split ETP Counter	tinyint	3	0
247	CTR05	Split ETP Counter	tinyint	3	0
248	CTR06	Split ETP Counter	tinyint	3	0
249	CTR07	Split ETP Counter	tinyint	3	0
250	CTR08	Split ETP Counter	tinyint	3	0
251	CTR09	Split ETP Counter	tinyint	3	0
252	CTR10	Split ETP Counter	tinyint	3	0
253	CTR11	Split ETP Counter	tinyint	3	0
254	CTR12	Split ETP Counter	tinyint	3	0
255	CTR13	Split ETP Counter	tinyint	3	0
256	CTR14	Split ETP Counter	tinyint	3	0
257	CTR15	Split ETP Counter	tinyint	3	0
258	CTR16	Split ETP Counter	tinyint	3	0
259	CTR17	Split ETP Counter	tinyint	3	0
260	CTR18	Split ETP Counter	tinyint	3	0
261	CTR19	Split ETP Counter	tinyint	3	0
262	CTR20	Split ETP Counter	tinyint	3	0
263	ELG13	Wage Type	nvarchar	4	0	Allow NULL?
264	EBT13	amount for payment	decimal	10	2
265	EAN13	Number	decimal	7	2
266	EZE13	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
267	ELG14	Wage Type	nvarchar	4	0	Allow NULL?
268	EBT14	amount for payment	decimal	10	2
269	EAN14	Number	decimal	7	2
270	EZE14	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
271	ELG15	Wage Type	nvarchar	4	0	Allow NULL?
272	EBT15	amount for payment	decimal	10	2
273	EAN15	Number	decimal	7	2
274	EZE15	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
275	ELG16	Wage Type	nvarchar	4	0	Allow NULL?
276	EBT16	amount for payment	decimal	10	2
277	EAN16	Number	decimal	7	2
278	EZE16	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
279	ELG17	Wage Type	nvarchar	4	0	Allow NULL?
280	EBT17	amount for payment	decimal	10	2
281	EAN17	Number	decimal	7	2
282	EZE17	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
283	ELG18	Wage Type	nvarchar	4	0	Allow NULL?
284	EBT18	amount for payment	decimal	10	2
285	EAN18	Number	decimal	7	2
286	EZE18	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
287	ELG19	Wage Type	nvarchar	4	0	Allow NULL?
288	EBT19	amount for payment	decimal	10	2
289	EAN19	Number	decimal	7	2
290	EZE19	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
291	ELG20	Wage Type	nvarchar	4	0	Allow NULL?
292	EBT20	amount for payment	decimal	10	2
293	EAN20	Number	decimal	7	2
294	EZE20	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
295	MEM01	Superannuation Fund Membership Number Australia	nvarchar	20	0	Allow NULL?
296	TAX01	Total taxable amount	decimal	9	2
297	TXF01	Total taxfree amount	decimal	9	2
298	MEM02	Superannuation Fund Membership Number Australia	nvarchar	20	0	Allow NULL?
299	TAX02	Total taxable amount	decimal	9	2
300	TXF02	Total taxfree amount	decimal	9	2
301	MEM03	Superannuation Fund Membership Number Australia	nvarchar	20	0	Allow NULL?
302	TAX03	Total taxable amount	decimal	9	2
303	TXF03	Total taxfree amount	decimal	9	2
304	MEM04	Superannuation Fund Membership Number Australia	nvarchar	20	0	Allow NULL?
305	TAX04	Total taxable amount	decimal	9	2
306	TXF04	Total taxfree amount	decimal	9	2
307	MEM05	Superannuation Fund Membership Number Australia	nvarchar	20	0	Allow NULL?
308	TAX05	Total taxable amount	decimal	9	2
309	TXF05	Total taxfree amount	decimal	9	2
310	MEM06	Superannuation Fund Membership Number Australia	nvarchar	20	0	Allow NULL?
311	TAX06	Total taxable amount	decimal	9	2
312	TXF06	Total taxfree amount	decimal	9	2
313	EXL01	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
314	EXL02	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
315	EXL03	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
316	EXL04	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
317	EXL05	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
318	EXL06	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
319	EXL07	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
320	EXL08	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
321	EXL09	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
322	EXL10	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
323	EXT01	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
324	EXT02	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
325	EXT03	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
326	EXT04	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
327	EXT05	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
328	EXT06	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
329	EXT07	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
330	EXT08	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
331	EXT09	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?
332	EXT10	Flag in Termination Organizer to set a payment as Excluded	char	1	0	Allow NULL?

TOP ERP 6.0 | PA0701 INDEXES

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

332 COLUMNS | 1 INDEXES | ERP 6.0 | PA0701 TABLE

TOP ERP 6.0 | PA0701 COLUMNS

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

332 COLUMNS | 1 INDEXES | ERP 6.0 | PA0701 TABLE

TOPERP 6.0 | PA0701 COLUMNS

TOPERP 6.0 | PA0701 INDEXES

TOP ERP 6.0 | PA0701 COLUMNS

TOP ERP 6.0 | PA0701 INDEXES