	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

279 COLUMNS | 1 INDEXES | ERP 6.0 | PA0706 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Management of Global Employees
1	ERP EHP7	6.0	PA0706	279	1	HR Master Record: Infotype 0706	Management of Global Employees

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, COMP_PACK_PART, CURRENCY, EXCHANGE_RATE, EXCHANGE_DATE, COL_INDEX, COLI_DATE, CPI01, AMOUNT01, CURRENCY01, FREQ01, PAY_TYPE01, CPI_TYPE01, BCPI01, PRCNT01, TAXBLE01, OVRTFL01, OVRTMET01, CPI02, AMOUNT02, CURRENCY02, FREQ02, PAY_TYPE02, CPI_TYPE02, BCPI02, PRCNT02, TAXBLE02, OVRTFL02, OVRTMET02, CPI03, AMOUNT03, CURRENCY03, FREQ03, PAY_TYPE03, CPI_TYPE03, BCPI03, PRCNT03, TAXBLE03, OVRTFL03, OVRTMET03, CPI04, AMOUNT04, CURRENCY04, FREQ04, PAY_TYPE04, CPI_TYPE04, BCPI04, PRCNT04, TAXBLE04, OVRTFL04, OVRTMET04, CPI05, AMOUNT05, CURRENCY05, FREQ05, PAY_TYPE05, CPI_TYPE05, BCPI05, PRCNT05, TAXBLE05, OVRTFL05, OVRTMET05, CPI06, AMOUNT06, CURRENCY06, FREQ06, PAY_TYPE06, CPI_TYPE06, BCPI06, PRCNT06, TAXBLE06, OVRTFL06, OVRTMET06, CPI07, AMOUNT07, CURRENCY07, FREQ07, PAY_TYPE07, CPI_TYPE07, BCPI07, PRCNT07, TAXBLE07, OVRTFL07, OVRTMET07, CPI08, AMOUNT08, CURRENCY08, FREQ08, PAY_TYPE08, CPI_TYPE08, BCPI08, PRCNT08, TAXBLE08, OVRTFL08, OVRTMET08, CPI09, AMOUNT09, CURRENCY09, FREQ09, PAY_TYPE09, CPI_TYPE09, BCPI09, PRCNT09, TAXBLE09, OVRTFL09, OVRTMET09, CPI10, AMOUNT10, CURRENCY10, FREQ10, PAY_TYPE10, CPI_TYPE10, BCPI10, PRCNT10, TAXBLE10, OVRTFL10, OVRTMET10, CPI11, AMOUNT11, CURRENCY11, FREQ11, PAY_TYPE11, CPI_TYPE11, BCPI11, PRCNT11, TAXBLE11, OVRTFL11, OVRTMET11, CPI12, AMOUNT12, CURRENCY12, FREQ12, PAY_TYPE12, CPI_TYPE12, BCPI12, PRCNT12, TAXBLE12, OVRTFL12, OVRTMET12, CPI13, AMOUNT13, CURRENCY13, FREQ13, PAY_TYPE13, CPI_TYPE13, BCPI13, PRCNT13, TAXBLE13, OVRTFL13, OVRTMET13, CPI14, AMOUNT14, CURRENCY14, FREQ14, PAY_TYPE14, CPI_TYPE14, BCPI14, PRCNT14, TAXBLE14, OVRTFL14, OVRTMET14, CPI15, AMOUNT15, CURRENCY15, FREQ15, PAY_TYPE15, CPI_TYPE15, BCPI15, PRCNT15, TAXBLE15, OVRTFL15, OVRTMET15, CPI16, AMOUNT16, CURRENCY16, FREQ16, PAY_TYPE16, CPI_TYPE16, BCPI16, PRCNT16, TAXBLE16, OVRTFL16, OVRTMET16, CPI17, AMOUNT17, CURRENCY17, FREQ17, PAY_TYPE17, CPI_TYPE17, BCPI17, PRCNT17, TAXBLE17, OVRTFL17, OVRTMET17, CPI18, AMOUNT18, CURRENCY18, FREQ18, PAY_TYPE18, CPI_TYPE18, BCPI18, PRCNT18, TAXBLE18, OVRTFL18, OVRTMET18, CPI19, AMOUNT19, CURRENCY19, FREQ19, PAY_TYPE19, CPI_TYPE19, BCPI19, PRCNT19, TAXBLE19, OVRTFL19, OVRTMET19, CPI20, AMOUNT20, CURRENCY20, FREQ20, PAY_TYPE20, CPI_TYPE20, BCPI20, PRCNT20, TAXBLE20, OVRTFL20, OVRTMET20, SYSTEM_DATE, SYSTEM_TIME, USER_DATE, USER_TIME, OVR_COLI, OVR_COLDA, OVR_EXCRA, OVR_EXCDA, ACTIVATION_DATE, STATUS, FACTOR01, FACTOR02, FACTOR03, FACTOR04, FACTOR05, FACTOR06, FACTOR07, FACTOR08, FACTOR09, FACTOR10, FACTOR11, FACTOR12, FACTOR13, FACTOR14, FACTOR15, FACTOR16, FACTOR17, FACTOR18, FACTOR19, FACTOR20 FROM PA0706

TOP ERP 6.0 | PA0706 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	COMP_PACK_PART	Processor	nvarchar	4	0	Allow NULL?
25	CURRENCY	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
26	EXCHANGE_RATE	Exchange Rate for Home to Host Country Conversions	decimal	9	5
27	EXCHANGE_DATE	Key Date for Exchange Rate	nvarchar	8	0	Allow NULL?
28	COL_INDEX	Cost of Living Index	decimal	7	4
29	COLI_DATE	Key Date for Cost of Living Index	nvarchar	8	0	Allow NULL?
30	CPI01	Compensation Package Item	nvarchar	4	0	Allow NULL?
31	AMOUNT01	Compensation Package Amount	decimal	15	2
32	CURRENCY01	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
33	FREQ01	Payroll time units	nvarchar	2	0	Allow NULL?
34	PAY_TYPE01	Payment Type	char	1	0	Allow NULL?
35	CPI_TYPE01	Compensation Package Item Type	char	1	0	Allow NULL?
36	BCPI01	Compensation Package Item	nvarchar	4	0	Allow NULL?
37	PRCNT01	Percentage	decimal	6	3
38	TAXBLE01	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
39	OVRTFL01	Status	char	1	0	Allow NULL?
40	OVRTMET01	Evaluation Method	nvarchar	8	0	Allow NULL?
41	CPI02	Compensation Package Item	nvarchar	4	0	Allow NULL?
42	AMOUNT02	Compensation Package Amount	decimal	15	2
43	CURRENCY02	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
44	FREQ02	Payroll time units	nvarchar	2	0	Allow NULL?
45	PAY_TYPE02	Payment Type	char	1	0	Allow NULL?
46	CPI_TYPE02	Compensation Package Item Type	char	1	0	Allow NULL?
47	BCPI02	Compensation Package Item	nvarchar	4	0	Allow NULL?
48	PRCNT02	Percentage	decimal	6	3
49	TAXBLE02	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
50	OVRTFL02	Status	char	1	0	Allow NULL?
51	OVRTMET02	Evaluation Method	nvarchar	8	0	Allow NULL?
52	CPI03	Compensation Package Item	nvarchar	4	0	Allow NULL?
53	AMOUNT03	Compensation Package Amount	decimal	15	2
54	CURRENCY03	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
55	FREQ03	Payroll time units	nvarchar	2	0	Allow NULL?
56	PAY_TYPE03	Payment Type	char	1	0	Allow NULL?
57	CPI_TYPE03	Compensation Package Item Type	char	1	0	Allow NULL?
58	BCPI03	Compensation Package Item	nvarchar	4	0	Allow NULL?
59	PRCNT03	Percentage	decimal	6	3
60	TAXBLE03	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
61	OVRTFL03	Status	char	1	0	Allow NULL?
62	OVRTMET03	Evaluation Method	nvarchar	8	0	Allow NULL?
63	CPI04	Compensation Package Item	nvarchar	4	0	Allow NULL?
64	AMOUNT04	Compensation Package Amount	decimal	15	2
65	CURRENCY04	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
66	FREQ04	Payroll time units	nvarchar	2	0	Allow NULL?
67	PAY_TYPE04	Payment Type	char	1	0	Allow NULL?
68	CPI_TYPE04	Compensation Package Item Type	char	1	0	Allow NULL?
69	BCPI04	Compensation Package Item	nvarchar	4	0	Allow NULL?
70	PRCNT04	Percentage	decimal	6	3
71	TAXBLE04	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
72	OVRTFL04	Status	char	1	0	Allow NULL?
73	OVRTMET04	Evaluation Method	nvarchar	8	0	Allow NULL?
74	CPI05	Compensation Package Item	nvarchar	4	0	Allow NULL?
75	AMOUNT05	Compensation Package Amount	decimal	15	2
76	CURRENCY05	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
77	FREQ05	Payroll time units	nvarchar	2	0	Allow NULL?
78	PAY_TYPE05	Payment Type	char	1	0	Allow NULL?
79	CPI_TYPE05	Compensation Package Item Type	char	1	0	Allow NULL?
80	BCPI05	Compensation Package Item	nvarchar	4	0	Allow NULL?
81	PRCNT05	Percentage	decimal	6	3
82	TAXBLE05	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
83	OVRTFL05	Status	char	1	0	Allow NULL?
84	OVRTMET05	Evaluation Method	nvarchar	8	0	Allow NULL?
85	CPI06	Compensation Package Item	nvarchar	4	0	Allow NULL?
86	AMOUNT06	Compensation Package Amount	decimal	15	2
87	CURRENCY06	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
88	FREQ06	Payroll time units	nvarchar	2	0	Allow NULL?
89	PAY_TYPE06	Payment Type	char	1	0	Allow NULL?
90	CPI_TYPE06	Compensation Package Item Type	char	1	0	Allow NULL?
91	BCPI06	Compensation Package Item	nvarchar	4	0	Allow NULL?
92	PRCNT06	Percentage	decimal	6	3
93	TAXBLE06	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
94	OVRTFL06	Status	char	1	0	Allow NULL?
95	OVRTMET06	Evaluation Method	nvarchar	8	0	Allow NULL?
96	CPI07	Compensation Package Item	nvarchar	4	0	Allow NULL?
97	AMOUNT07	Compensation Package Amount	decimal	15	2
98	CURRENCY07	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
99	FREQ07	Payroll time units	nvarchar	2	0	Allow NULL?
100	PAY_TYPE07	Payment Type	char	1	0	Allow NULL?
101	CPI_TYPE07	Compensation Package Item Type	char	1	0	Allow NULL?
102	BCPI07	Compensation Package Item	nvarchar	4	0	Allow NULL?
103	PRCNT07	Percentage	decimal	6	3
104	TAXBLE07	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
105	OVRTFL07	Status	char	1	0	Allow NULL?
106	OVRTMET07	Evaluation Method	nvarchar	8	0	Allow NULL?
107	CPI08	Compensation Package Item	nvarchar	4	0	Allow NULL?
108	AMOUNT08	Compensation Package Amount	decimal	15	2
109	CURRENCY08	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
110	FREQ08	Payroll time units	nvarchar	2	0	Allow NULL?
111	PAY_TYPE08	Payment Type	char	1	0	Allow NULL?
112	CPI_TYPE08	Compensation Package Item Type	char	1	0	Allow NULL?
113	BCPI08	Compensation Package Item	nvarchar	4	0	Allow NULL?
114	PRCNT08	Percentage	decimal	6	3
115	TAXBLE08	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
116	OVRTFL08	Status	char	1	0	Allow NULL?
117	OVRTMET08	Evaluation Method	nvarchar	8	0	Allow NULL?
118	CPI09	Compensation Package Item	nvarchar	4	0	Allow NULL?
119	AMOUNT09	Compensation Package Amount	decimal	15	2
120	CURRENCY09	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
121	FREQ09	Payroll time units	nvarchar	2	0	Allow NULL?
122	PAY_TYPE09	Payment Type	char	1	0	Allow NULL?
123	CPI_TYPE09	Compensation Package Item Type	char	1	0	Allow NULL?
124	BCPI09	Compensation Package Item	nvarchar	4	0	Allow NULL?
125	PRCNT09	Percentage	decimal	6	3
126	TAXBLE09	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
127	OVRTFL09	Status	char	1	0	Allow NULL?
128	OVRTMET09	Evaluation Method	nvarchar	8	0	Allow NULL?
129	CPI10	Compensation Package Item	nvarchar	4	0	Allow NULL?
130	AMOUNT10	Compensation Package Amount	decimal	15	2
131	CURRENCY10	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
132	FREQ10	Payroll time units	nvarchar	2	0	Allow NULL?
133	PAY_TYPE10	Payment Type	char	1	0	Allow NULL?
134	CPI_TYPE10	Compensation Package Item Type	char	1	0	Allow NULL?
135	BCPI10	Compensation Package Item	nvarchar	4	0	Allow NULL?
136	PRCNT10	Percentage	decimal	6	3
137	TAXBLE10	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
138	OVRTFL10	Status	char	1	0	Allow NULL?
139	OVRTMET10	Evaluation Method	nvarchar	8	0	Allow NULL?
140	CPI11	Compensation Package Item	nvarchar	4	0	Allow NULL?
141	AMOUNT11	Compensation Package Amount	decimal	15	2
142	CURRENCY11	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
143	FREQ11	Payroll time units	nvarchar	2	0	Allow NULL?
144	PAY_TYPE11	Payment Type	char	1	0	Allow NULL?
145	CPI_TYPE11	Compensation Package Item Type	char	1	0	Allow NULL?
146	BCPI11	Compensation Package Item	nvarchar	4	0	Allow NULL?
147	PRCNT11	Percentage	decimal	6	3
148	TAXBLE11	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
149	OVRTFL11	Status	char	1	0	Allow NULL?
150	OVRTMET11	Evaluation Method	nvarchar	8	0	Allow NULL?
151	CPI12	Compensation Package Item	nvarchar	4	0	Allow NULL?
152	AMOUNT12	Compensation Package Amount	decimal	15	2
153	CURRENCY12	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
154	FREQ12	Payroll time units	nvarchar	2	0	Allow NULL?
155	PAY_TYPE12	Payment Type	char	1	0	Allow NULL?
156	CPI_TYPE12	Compensation Package Item Type	char	1	0	Allow NULL?
157	BCPI12	Compensation Package Item	nvarchar	4	0	Allow NULL?
158	PRCNT12	Percentage	decimal	6	3
159	TAXBLE12	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
160	OVRTFL12	Status	char	1	0	Allow NULL?
161	OVRTMET12	Evaluation Method	nvarchar	8	0	Allow NULL?
162	CPI13	Compensation Package Item	nvarchar	4	0	Allow NULL?
163	AMOUNT13	Compensation Package Amount	decimal	15	2
164	CURRENCY13	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
165	FREQ13	Payroll time units	nvarchar	2	0	Allow NULL?
166	PAY_TYPE13	Payment Type	char	1	0	Allow NULL?
167	CPI_TYPE13	Compensation Package Item Type	char	1	0	Allow NULL?
168	BCPI13	Compensation Package Item	nvarchar	4	0	Allow NULL?
169	PRCNT13	Percentage	decimal	6	3
170	TAXBLE13	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
171	OVRTFL13	Status	char	1	0	Allow NULL?
172	OVRTMET13	Evaluation Method	nvarchar	8	0	Allow NULL?
173	CPI14	Compensation Package Item	nvarchar	4	0	Allow NULL?
174	AMOUNT14	Compensation Package Amount	decimal	15	2
175	CURRENCY14	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
176	FREQ14	Payroll time units	nvarchar	2	0	Allow NULL?
177	PAY_TYPE14	Payment Type	char	1	0	Allow NULL?
178	CPI_TYPE14	Compensation Package Item Type	char	1	0	Allow NULL?
179	BCPI14	Compensation Package Item	nvarchar	4	0	Allow NULL?
180	PRCNT14	Percentage	decimal	6	3
181	TAXBLE14	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
182	OVRTFL14	Status	char	1	0	Allow NULL?
183	OVRTMET14	Evaluation Method	nvarchar	8	0	Allow NULL?
184	CPI15	Compensation Package Item	nvarchar	4	0	Allow NULL?
185	AMOUNT15	Compensation Package Amount	decimal	15	2
186	CURRENCY15	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
187	FREQ15	Payroll time units	nvarchar	2	0	Allow NULL?
188	PAY_TYPE15	Payment Type	char	1	0	Allow NULL?
189	CPI_TYPE15	Compensation Package Item Type	char	1	0	Allow NULL?
190	BCPI15	Compensation Package Item	nvarchar	4	0	Allow NULL?
191	PRCNT15	Percentage	decimal	6	3
192	TAXBLE15	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
193	OVRTFL15	Status	char	1	0	Allow NULL?
194	OVRTMET15	Evaluation Method	nvarchar	8	0	Allow NULL?
195	CPI16	Compensation Package Item	nvarchar	4	0	Allow NULL?
196	AMOUNT16	Compensation Package Amount	decimal	15	2
197	CURRENCY16	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
198	FREQ16	Payroll time units	nvarchar	2	0	Allow NULL?
199	PAY_TYPE16	Payment Type	char	1	0	Allow NULL?
200	CPI_TYPE16	Compensation Package Item Type	char	1	0	Allow NULL?
201	BCPI16	Compensation Package Item	nvarchar	4	0	Allow NULL?
202	PRCNT16	Percentage	decimal	6	3
203	TAXBLE16	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
204	OVRTFL16	Status	char	1	0	Allow NULL?
205	OVRTMET16	Evaluation Method	nvarchar	8	0	Allow NULL?
206	CPI17	Compensation Package Item	nvarchar	4	0	Allow NULL?
207	AMOUNT17	Compensation Package Amount	decimal	15	2
208	CURRENCY17	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
209	FREQ17	Payroll time units	nvarchar	2	0	Allow NULL?
210	PAY_TYPE17	Payment Type	char	1	0	Allow NULL?
211	CPI_TYPE17	Compensation Package Item Type	char	1	0	Allow NULL?
212	BCPI17	Compensation Package Item	nvarchar	4	0	Allow NULL?
213	PRCNT17	Percentage	decimal	6	3
214	TAXBLE17	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
215	OVRTFL17	Status	char	1	0	Allow NULL?
216	OVRTMET17	Evaluation Method	nvarchar	8	0	Allow NULL?
217	CPI18	Compensation Package Item	nvarchar	4	0	Allow NULL?
218	AMOUNT18	Compensation Package Amount	decimal	15	2
219	CURRENCY18	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
220	FREQ18	Payroll time units	nvarchar	2	0	Allow NULL?
221	PAY_TYPE18	Payment Type	char	1	0	Allow NULL?
222	CPI_TYPE18	Compensation Package Item Type	char	1	0	Allow NULL?
223	BCPI18	Compensation Package Item	nvarchar	4	0	Allow NULL?
224	PRCNT18	Percentage	decimal	6	3
225	TAXBLE18	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
226	OVRTFL18	Status	char	1	0	Allow NULL?
227	OVRTMET18	Evaluation Method	nvarchar	8	0	Allow NULL?
228	CPI19	Compensation Package Item	nvarchar	4	0	Allow NULL?
229	AMOUNT19	Compensation Package Amount	decimal	15	2
230	CURRENCY19	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
231	FREQ19	Payroll time units	nvarchar	2	0	Allow NULL?
232	PAY_TYPE19	Payment Type	char	1	0	Allow NULL?
233	CPI_TYPE19	Compensation Package Item Type	char	1	0	Allow NULL?
234	BCPI19	Compensation Package Item	nvarchar	4	0	Allow NULL?
235	PRCNT19	Percentage	decimal	6	3
236	TAXBLE19	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
237	OVRTFL19	Status	char	1	0	Allow NULL?
238	OVRTMET19	Evaluation Method	nvarchar	8	0	Allow NULL?
239	CPI20	Compensation Package Item	nvarchar	4	0	Allow NULL?
240	AMOUNT20	Compensation Package Amount	decimal	15	2
241	CURRENCY20	Currency for Compensation Package	nvarchar	5	0	Allow NULL?
242	FREQ20	Payroll time units	nvarchar	2	0	Allow NULL?
243	PAY_TYPE20	Payment Type	char	1	0	Allow NULL?
244	CPI_TYPE20	Compensation Package Item Type	char	1	0	Allow NULL?
245	BCPI20	Compensation Package Item	nvarchar	4	0	Allow NULL?
246	PRCNT20	Percentage	decimal	6	3
247	TAXBLE20	Taxibility Indicator (for future use)	char	1	0	Allow NULL?
248	OVRTFL20	Status	char	1	0	Allow NULL?
249	OVRTMET20	Evaluation Method	nvarchar	8	0	Allow NULL?
250	SYSTEM_DATE	Offer Date	nvarchar	8	0	Allow NULL?
251	SYSTEM_TIME	Offer Time	nvarchar	6	0	Allow NULL?
252	USER_DATE	Local Offer Date	nvarchar	8	0	Allow NULL?
253	USER_TIME	Local Offer Time	nvarchar	6	0	Allow NULL?
254	OVR_COLI	Change status for COLI and exchange rate	char	1	0	Allow NULL?
255	OVR_COLDA	Change status for COLI and exchange rate	char	1	0	Allow NULL?
256	OVR_EXCRA	Change status for COLI and exchange rate	char	1	0	Allow NULL?
257	OVR_EXCDA	Change status for COLI and exchange rate	char	1	0	Allow NULL?
258	ACTIVATION_DATE	Date of Assignment Activation	nvarchar	8	0	Allow NULL?
259	STATUS	Compensation Package status	char	1	0	Allow NULL?
260	FACTOR01	Factor for CPIs	nvarchar	2	0	Allow NULL?
261	FACTOR02	Factor for CPIs	nvarchar	2	0	Allow NULL?
262	FACTOR03	Factor for CPIs	nvarchar	2	0	Allow NULL?
263	FACTOR04	Factor for CPIs	nvarchar	2	0	Allow NULL?
264	FACTOR05	Factor for CPIs	nvarchar	2	0	Allow NULL?
265	FACTOR06	Factor for CPIs	nvarchar	2	0	Allow NULL?
266	FACTOR07	Factor for CPIs	nvarchar	2	0	Allow NULL?
267	FACTOR08	Factor for CPIs	nvarchar	2	0	Allow NULL?
268	FACTOR09	Factor for CPIs	nvarchar	2	0	Allow NULL?
269	FACTOR10	Factor for CPIs	nvarchar	2	0	Allow NULL?
270	FACTOR11	Factor for CPIs	nvarchar	2	0	Allow NULL?
271	FACTOR12	Factor for CPIs	nvarchar	2	0	Allow NULL?
272	FACTOR13	Factor for CPIs	nvarchar	2	0	Allow NULL?
273	FACTOR14	Factor for CPIs	nvarchar	2	0	Allow NULL?
274	FACTOR15	Factor for CPIs	nvarchar	2	0	Allow NULL?
275	FACTOR16	Factor for CPIs	nvarchar	2	0	Allow NULL?
276	FACTOR17	Factor for CPIs	nvarchar	2	0	Allow NULL?
277	FACTOR18	Factor for CPIs	nvarchar	2	0	Allow NULL?
278	FACTOR19	Factor for CPIs	nvarchar	2	0	Allow NULL?
279	FACTOR20	Factor for CPIs	nvarchar	2	0	Allow NULL?

TOP ERP 6.0 | PA0706 INDEXES

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

279 COLUMNS | 1 INDEXES | ERP 6.0 | PA0706 TABLE

TOP ERP 6.0 | PA0706 COLUMNS

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

279 COLUMNS | 1 INDEXES | ERP 6.0 | PA0706 TABLE

TOPERP 6.0 | PA0706 COLUMNS

TOPERP 6.0 | PA0706 INDEXES

TOP ERP 6.0 | PA0706 COLUMNS

TOP ERP 6.0 | PA0706 INDEXES