	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

391 COLUMNS | 1 INDEXES | ERP 6.0 | PA0146 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Japan
1	ERP EHP7	6.0	PA0146	391	1	HR Master Record: Infotype 0146 (Y.E.A. Data JP)	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, 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, AQUDT, HSDED, CCC01, CCT01, CPR01, CCN01, CNF01, CCC02, CCT02, CPR02, CCN02, CNF02, CCC03, CCT03, CPR03, CCN03, CNF03, CCC04, CCT04, CPR04, CCN04, CNF04, CCC05, CCT05, CPR05, CCN05, CNF05, CCC06, CCT06, CPR06, CCN06, CNF06, CCC07, CCT07, CPR07, CCN07, CNF07, CCC08, CCT08, CPR08, CCN08, CNF08, CCC09, CCT09, CPR09, CCN09, CNF09, CCC10, CCT10, CPR10, CCN10, CNF10, CCC11, CCT11, CPR11, CCN11, CNF11, CCC12, CCT12, CPR12, CCN12, CNF12, CCC13, CCT13, CPR13, CCN13, CNF13, CCC14, CCT14, CPR14, CCN14, CNF14, CCC15, CCT15, CPR15, CCN15, CNF15, CTP01, CTP02, CTP03, CTP04, CTP05, CTP06, CTP07, CTP08, CTP09, CTP10, CTP11, CTP12, CTP13, CTP14, CTP15, COF01, COF02, COF03, COF04, COF05, COF06, COF07, COF08, COF09, COF10, COF11, COF12, COF13, COF14, COF15, CLTOT, PCC01, PCT01, PPR01, PCN01, PNF01, PSD01, PCC02, PCT02, PPR02, PCN02, PNF02, PSD02, PCC03, PCT03, PPR03, PCN03, PNF03, PSD03, PCC04, PCT04, PPR04, PCN04, PNF04, PSD04, PCC05, PCT05, PPR05, PCN05, PNF05, PSD05, PTP01, PTP02, PTP03, PTP04, PTP05, PEF01, PEF02, PEF03, PEF04, PEF05, PPTOT, LCC01, LCT01, LPR01, LCN01, LRM01, LNF01, LCC02, LCT02, LPR02, LCN02, LRM02, LNF02, LCC03, LCT03, LPR03, LCN03, LRM03, LNF03, LCC04, LCT04, LPR04, LCN04, LRM04, LNF04, LCC05, LCT05, LPR05, LCN05, LRM05, LNF05, LAF01, LAF02, LAF03, LAF04, LAF05, LATOT, SCC01, SCT01, SPR01, SCN01, SRM01, SNF01, SCC02, SCT02, SPR02, SCN02, SRM02, SNF02, SCC03, SCT03, SPR03, SCN03, SRM03, SNF03, SCC04, SCT04, SPR04, SCN04, SRM04, SNF04, SCC05, SCT05, SPR05, SCN05, SRM05, SNF05, SAF01, SAF02, SAF03, SAF04, SAF05, SATOT, SPIID, SPINC, HSTY1, HSDE1, HSDA2, HSTY2, HSDE2, HSDA3, HSTY3, HSDE3, HOF01, HOF02, HOF03, NLTOT, NPTOT, NCC01, NCT01, NPR01, NCN01, NNF01, NCC02, NCT02, NPR02, NCN02, NNF02, NCC03, NCT03, NPR03, NCN03, NNF03, NCC04, NCT04, NPR04, NCN04, NNF04, NCC05, NCT05, NPR05, NCN05, NNF05, NUF01, NUF02, NUF03, NUF04, NUF05, NSTOT, REFNM FROM PA0146

TOP ERP 6.0 | PA0146 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	LGA01	Wage Type	nvarchar	4	0	Allow NULL?
25	BET01	Amount	decimal	9	2
26	ANZ01	Number	decimal	7	2
27	EIN01	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
28	OPK01	Operation Indicator for Wage Types	char	1	0	Allow NULL?
29	LGA02	Wage Type	nvarchar	4	0	Allow NULL?
30	BET02	Amount	decimal	9	2
31	ANZ02	Number	decimal	7	2
32	EIN02	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
33	OPK02	Operation Indicator for Wage Types	char	1	0	Allow NULL?
34	LGA03	Wage Type	nvarchar	4	0	Allow NULL?
35	BET03	Amount	decimal	9	2
36	ANZ03	Number	decimal	7	2
37	EIN03	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
38	OPK03	Operation Indicator for Wage Types	char	1	0	Allow NULL?
39	LGA04	Wage Type	nvarchar	4	0	Allow NULL?
40	BET04	Amount	decimal	9	2
41	ANZ04	Number	decimal	7	2
42	EIN04	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
43	OPK04	Operation Indicator for Wage Types	char	1	0	Allow NULL?
44	LGA05	Wage Type	nvarchar	4	0	Allow NULL?
45	BET05	Amount	decimal	9	2
46	ANZ05	Number	decimal	7	2
47	EIN05	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
48	OPK05	Operation Indicator for Wage Types	char	1	0	Allow NULL?
49	LGA06	Wage Type	nvarchar	4	0	Allow NULL?
50	BET06	Amount	decimal	9	2
51	ANZ06	Number	decimal	7	2
52	EIN06	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
53	OPK06	Operation Indicator for Wage Types	char	1	0	Allow NULL?
54	LGA07	Wage Type	nvarchar	4	0	Allow NULL?
55	BET07	Amount	decimal	9	2
56	ANZ07	Number	decimal	7	2
57	EIN07	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
58	OPK07	Operation Indicator for Wage Types	char	1	0	Allow NULL?
59	LGA08	Wage Type	nvarchar	4	0	Allow NULL?
60	BET08	Amount	decimal	9	2
61	ANZ08	Number	decimal	7	2
62	EIN08	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
63	OPK08	Operation Indicator for Wage Types	char	1	0	Allow NULL?
64	LGA09	Wage Type	nvarchar	4	0	Allow NULL?
65	BET09	Amount	decimal	9	2
66	ANZ09	Number	decimal	7	2
67	EIN09	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
68	OPK09	Operation Indicator for Wage Types	char	1	0	Allow NULL?
69	LGA10	Wage Type	nvarchar	4	0	Allow NULL?
70	BET10	Amount	decimal	9	2
71	ANZ10	Number	decimal	7	2
72	EIN10	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
73	OPK10	Operation Indicator for Wage Types	char	1	0	Allow NULL?
74	LGA11	Wage Type	nvarchar	4	0	Allow NULL?
75	BET11	Amount	decimal	9	2
76	ANZ11	Number	decimal	7	2
77	EIN11	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
78	OPK11	Operation Indicator for Wage Types	char	1	0	Allow NULL?
79	LGA12	Wage Type	nvarchar	4	0	Allow NULL?
80	BET12	Amount	decimal	9	2
81	ANZ12	Number	decimal	7	2
82	EIN12	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
83	OPK12	Operation Indicator for Wage Types	char	1	0	Allow NULL?
84	LGA13	Wage Type	nvarchar	4	0	Allow NULL?
85	BET13	Amount	decimal	9	2
86	ANZ13	Number	decimal	7	2
87	EIN13	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
88	OPK13	Operation Indicator for Wage Types	char	1	0	Allow NULL?
89	LGA14	Wage Type	nvarchar	4	0	Allow NULL?
90	BET14	Amount	decimal	9	2
91	ANZ14	Number	decimal	7	2
92	EIN14	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
93	OPK14	Operation Indicator for Wage Types	char	1	0	Allow NULL?
94	LGA15	Wage Type	nvarchar	4	0	Allow NULL?
95	BET15	Amount	decimal	9	2
96	ANZ15	Number	decimal	7	2
97	EIN15	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
98	OPK15	Operation Indicator for Wage Types	char	1	0	Allow NULL?
99	LGA16	Wage Type	nvarchar	4	0	Allow NULL?
100	BET16	Amount	decimal	9	2
101	ANZ16	Number	decimal	7	2
102	EIN16	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
103	OPK16	Operation Indicator for Wage Types	char	1	0	Allow NULL?
104	LGA17	Wage Type	nvarchar	4	0	Allow NULL?
105	BET17	Amount	decimal	9	2
106	ANZ17	Number	decimal	7	2
107	EIN17	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
108	OPK17	Operation Indicator for Wage Types	char	1	0	Allow NULL?
109	LGA18	Wage Type	nvarchar	4	0	Allow NULL?
110	BET18	Amount	decimal	9	2
111	ANZ18	Number	decimal	7	2
112	EIN18	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
113	OPK18	Operation Indicator for Wage Types	char	1	0	Allow NULL?
114	LGA19	Wage Type	nvarchar	4	0	Allow NULL?
115	BET19	Amount	decimal	9	2
116	ANZ19	Number	decimal	7	2
117	EIN19	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
118	OPK19	Operation Indicator for Wage Types	char	1	0	Allow NULL?
119	LGA20	Wage Type	nvarchar	4	0	Allow NULL?
120	BET20	Amount	decimal	9	2
121	ANZ20	Number	decimal	7	2
122	EIN20	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
123	OPK20	Operation Indicator for Wage Types	char	1	0	Allow NULL?
124	AQUDT	Start Living Date	nvarchar	8	0	Allow NULL?
125	HSDED	Deductible Amount for Housing Loan	decimal	13	2
126	CCC01	Insurance company master JPN	nvarchar	2	0	Allow NULL?
127	CCT01	Insurance Contract Type	nvarchar	2	0	Allow NULL?
128	CPR01	Period of deduction	nvarchar	2	0	Allow NULL?
129	CCN01	Insurance contractor name	nvarchar	18	0	Allow NULL?
130	CNF01	Insurance fee without dividend	decimal	7	2
131	CCC02	Insurance company master JPN	nvarchar	2	0	Allow NULL?
132	CCT02	Insurance Contract Type	nvarchar	2	0	Allow NULL?
133	CPR02	Period of deduction	nvarchar	2	0	Allow NULL?
134	CCN02	Insurance contractor name	nvarchar	18	0	Allow NULL?
135	CNF02	Insurance fee without dividend	decimal	7	2
136	CCC03	Insurance company master JPN	nvarchar	2	0	Allow NULL?
137	CCT03	Insurance Contract Type	nvarchar	2	0	Allow NULL?
138	CPR03	Period of deduction	nvarchar	2	0	Allow NULL?
139	CCN03	Insurance contractor name	nvarchar	18	0	Allow NULL?
140	CNF03	Insurance fee without dividend	decimal	7	2
141	CCC04	Insurance company master JPN	nvarchar	2	0	Allow NULL?
142	CCT04	Insurance Contract Type	nvarchar	2	0	Allow NULL?
143	CPR04	Period of deduction	nvarchar	2	0	Allow NULL?
144	CCN04	Insurance contractor name	nvarchar	18	0	Allow NULL?
145	CNF04	Insurance fee without dividend	decimal	7	2
146	CCC05	Insurance company master JPN	nvarchar	2	0	Allow NULL?
147	CCT05	Insurance Contract Type	nvarchar	2	0	Allow NULL?
148	CPR05	Period of deduction	nvarchar	2	0	Allow NULL?
149	CCN05	Insurance contractor name	nvarchar	18	0	Allow NULL?
150	CNF05	Insurance fee without dividend	decimal	7	2
151	CCC06	Insurance company master JPN	nvarchar	2	0	Allow NULL?
152	CCT06	Insurance Contract Type	nvarchar	2	0	Allow NULL?
153	CPR06	Period of deduction	nvarchar	2	0	Allow NULL?
154	CCN06	Insurance contractor name	nvarchar	18	0	Allow NULL?
155	CNF06	Insurance fee without dividend	decimal	7	2
156	CCC07	Insurance company master JPN	nvarchar	2	0	Allow NULL?
157	CCT07	Insurance Contract Type	nvarchar	2	0	Allow NULL?
158	CPR07	Period of deduction	nvarchar	2	0	Allow NULL?
159	CCN07	Insurance contractor name	nvarchar	18	0	Allow NULL?
160	CNF07	Insurance fee without dividend	decimal	7	2
161	CCC08	Insurance company master JPN	nvarchar	2	0	Allow NULL?
162	CCT08	Insurance Contract Type	nvarchar	2	0	Allow NULL?
163	CPR08	Period of deduction	nvarchar	2	0	Allow NULL?
164	CCN08	Insurance contractor name	nvarchar	18	0	Allow NULL?
165	CNF08	Insurance fee without dividend	decimal	7	2
166	CCC09	Insurance company master JPN	nvarchar	2	0	Allow NULL?
167	CCT09	Insurance Contract Type	nvarchar	2	0	Allow NULL?
168	CPR09	Period of deduction	nvarchar	2	0	Allow NULL?
169	CCN09	Insurance contractor name	nvarchar	18	0	Allow NULL?
170	CNF09	Insurance fee without dividend	decimal	7	2
171	CCC10	Insurance company master JPN	nvarchar	2	0	Allow NULL?
172	CCT10	Insurance Contract Type	nvarchar	2	0	Allow NULL?
173	CPR10	Period of deduction	nvarchar	2	0	Allow NULL?
174	CCN10	Insurance contractor name	nvarchar	18	0	Allow NULL?
175	CNF10	Insurance fee without dividend	decimal	7	2
176	CCC11	Insurance company master JPN	nvarchar	2	0	Allow NULL?
177	CCT11	Insurance Contract Type	nvarchar	2	0	Allow NULL?
178	CPR11	Period of deduction	nvarchar	2	0	Allow NULL?
179	CCN11	Insurance contractor name	nvarchar	18	0	Allow NULL?
180	CNF11	Insurance fee without dividend	decimal	7	2
181	CCC12	Insurance company master JPN	nvarchar	2	0	Allow NULL?
182	CCT12	Insurance Contract Type	nvarchar	2	0	Allow NULL?
183	CPR12	Period of deduction	nvarchar	2	0	Allow NULL?
184	CCN12	Insurance contractor name	nvarchar	18	0	Allow NULL?
185	CNF12	Insurance fee without dividend	decimal	7	2
186	CCC13	Insurance company master JPN	nvarchar	2	0	Allow NULL?
187	CCT13	Insurance Contract Type	nvarchar	2	0	Allow NULL?
188	CPR13	Period of deduction	nvarchar	2	0	Allow NULL?
189	CCN13	Insurance contractor name	nvarchar	18	0	Allow NULL?
190	CNF13	Insurance fee without dividend	decimal	7	2
191	CCC14	Insurance company master JPN	nvarchar	2	0	Allow NULL?
192	CCT14	Insurance Contract Type	nvarchar	2	0	Allow NULL?
193	CPR14	Period of deduction	nvarchar	2	0	Allow NULL?
194	CCN14	Insurance contractor name	nvarchar	18	0	Allow NULL?
195	CNF14	Insurance fee without dividend	decimal	7	2
196	CCC15	Insurance company master JPN	nvarchar	2	0	Allow NULL?
197	CCT15	Insurance Contract Type	nvarchar	2	0	Allow NULL?
198	CPR15	Period of deduction	nvarchar	2	0	Allow NULL?
199	CCN15	Insurance contractor name	nvarchar	18	0	Allow NULL?
200	CNF15	Insurance fee without dividend	decimal	7	2
201	CTP01	New Contract	char	1	0	Allow NULL?
202	CTP02	New Contract	char	1	0	Allow NULL?
203	CTP03	New Contract	char	1	0	Allow NULL?
204	CTP04	New Contract	char	1	0	Allow NULL?
205	CTP05	New Contract	char	1	0	Allow NULL?
206	CTP06	New Contract	char	1	0	Allow NULL?
207	CTP07	New Contract	char	1	0	Allow NULL?
208	CTP08	New Contract	char	1	0	Allow NULL?
209	CTP09	New Contract	char	1	0	Allow NULL?
210	CTP10	New Contract	char	1	0	Allow NULL?
211	CTP11	New Contract	char	1	0	Allow NULL?
212	CTP12	New Contract	char	1	0	Allow NULL?
213	CTP13	New Contract	char	1	0	Allow NULL?
214	CTP14	New Contract	char	1	0	Allow NULL?
215	CTP15	New Contract	char	1	0	Allow NULL?
216	COF01	LINC&VAN Imported	char	1	0	Allow NULL?
217	COF02	LINC&VAN Imported	char	1	0	Allow NULL?
218	COF03	LINC&VAN Imported	char	1	0	Allow NULL?
219	COF04	LINC&VAN Imported	char	1	0	Allow NULL?
220	COF05	LINC&VAN Imported	char	1	0	Allow NULL?
221	COF06	LINC&VAN Imported	char	1	0	Allow NULL?
222	COF07	LINC&VAN Imported	char	1	0	Allow NULL?
223	COF08	LINC&VAN Imported	char	1	0	Allow NULL?
224	COF09	LINC&VAN Imported	char	1	0	Allow NULL?
225	COF10	LINC&VAN Imported	char	1	0	Allow NULL?
226	COF11	LINC&VAN Imported	char	1	0	Allow NULL?
227	COF12	LINC&VAN Imported	char	1	0	Allow NULL?
228	COF13	LINC&VAN Imported	char	1	0	Allow NULL?
229	COF14	LINC&VAN Imported	char	1	0	Allow NULL?
230	COF15	LINC&VAN Imported	char	1	0	Allow NULL?
231	CLTOT	Total Premium of Common Life Insurance (Old Contract)	decimal	13	2
232	PCC01	Insurance company master JPN	nvarchar	2	0	Allow NULL?
233	PCT01	Insurance Contract Type	nvarchar	2	0	Allow NULL?
234	PPR01	Period of deduction	nvarchar	2	0	Allow NULL?
235	PCN01	Insurance contractor name	nvarchar	18	0	Allow NULL?
236	PNF01	Insurance fee without dividend	decimal	7	2
237	PSD01	Start date of payment of each personal pension	nvarchar	8	0	Allow NULL?
238	PCC02	Insurance company master JPN	nvarchar	2	0	Allow NULL?
239	PCT02	Insurance Contract Type	nvarchar	2	0	Allow NULL?
240	PPR02	Period of deduction	nvarchar	2	0	Allow NULL?
241	PCN02	Insurance contractor name	nvarchar	18	0	Allow NULL?
242	PNF02	Insurance fee without dividend	decimal	7	2
243	PSD02	Start date of payment of each personal pension	nvarchar	8	0	Allow NULL?
244	PCC03	Insurance company master JPN	nvarchar	2	0	Allow NULL?
245	PCT03	Insurance Contract Type	nvarchar	2	0	Allow NULL?
246	PPR03	Period of deduction	nvarchar	2	0	Allow NULL?
247	PCN03	Insurance contractor name	nvarchar	18	0	Allow NULL?
248	PNF03	Insurance fee without dividend	decimal	7	2
249	PSD03	Start date of payment of each personal pension	nvarchar	8	0	Allow NULL?
250	PCC04	Insurance company master JPN	nvarchar	2	0	Allow NULL?
251	PCT04	Insurance Contract Type	nvarchar	2	0	Allow NULL?
252	PPR04	Period of deduction	nvarchar	2	0	Allow NULL?
253	PCN04	Insurance contractor name	nvarchar	18	0	Allow NULL?
254	PNF04	Insurance fee without dividend	decimal	7	2
255	PSD04	Start date of payment of each personal pension	nvarchar	8	0	Allow NULL?
256	PCC05	Insurance company master JPN	nvarchar	2	0	Allow NULL?
257	PCT05	Insurance Contract Type	nvarchar	2	0	Allow NULL?
258	PPR05	Period of deduction	nvarchar	2	0	Allow NULL?
259	PCN05	Insurance contractor name	nvarchar	18	0	Allow NULL?
260	PNF05	Insurance fee without dividend	decimal	7	2
261	PSD05	Start date of payment of each personal pension	nvarchar	8	0	Allow NULL?
262	PTP01	New Contract	char	1	0	Allow NULL?
263	PTP02	New Contract	char	1	0	Allow NULL?
264	PTP03	New Contract	char	1	0	Allow NULL?
265	PTP04	New Contract	char	1	0	Allow NULL?
266	PTP05	New Contract	char	1	0	Allow NULL?
267	PEF01	LINC&VAN Imported	char	1	0	Allow NULL?
268	PEF02	LINC&VAN Imported	char	1	0	Allow NULL?
269	PEF03	LINC&VAN Imported	char	1	0	Allow NULL?
270	PEF04	LINC&VAN Imported	char	1	0	Allow NULL?
271	PEF05	LINC&VAN Imported	char	1	0	Allow NULL?
272	PPTOT	Total Premium of Personal Pension Insurance (Old Contract)	decimal	13	2
273	LCC01	Insurance company master JPN	nvarchar	2	0	Allow NULL?
274	LCT01	Insurance Contract Type	nvarchar	2	0	Allow NULL?
275	LPR01	Period of deduction	nvarchar	2	0	Allow NULL?
276	LCN01	Insurance contractor name	nvarchar	18	0	Allow NULL?
277	LRM01	Refund on maturity indicator	char	1	0	Allow NULL?
278	LNF01	Insurance fee without dividend	decimal	7	2
279	LCC02	Insurance company master JPN	nvarchar	2	0	Allow NULL?
280	LCT02	Insurance Contract Type	nvarchar	2	0	Allow NULL?
281	LPR02	Period of deduction	nvarchar	2	0	Allow NULL?
282	LCN02	Insurance contractor name	nvarchar	18	0	Allow NULL?
283	LRM02	Refund on maturity indicator	char	1	0	Allow NULL?
284	LNF02	Insurance fee without dividend	decimal	7	2
285	LCC03	Insurance company master JPN	nvarchar	2	0	Allow NULL?
286	LCT03	Insurance Contract Type	nvarchar	2	0	Allow NULL?
287	LPR03	Period of deduction	nvarchar	2	0	Allow NULL?
288	LCN03	Insurance contractor name	nvarchar	18	0	Allow NULL?
289	LRM03	Refund on maturity indicator	char	1	0	Allow NULL?
290	LNF03	Insurance fee without dividend	decimal	7	2
291	LCC04	Insurance company master JPN	nvarchar	2	0	Allow NULL?
292	LCT04	Insurance Contract Type	nvarchar	2	0	Allow NULL?
293	LPR04	Period of deduction	nvarchar	2	0	Allow NULL?
294	LCN04	Insurance contractor name	nvarchar	18	0	Allow NULL?
295	LRM04	Refund on maturity indicator	char	1	0	Allow NULL?
296	LNF04	Insurance fee without dividend	decimal	7	2
297	LCC05	Insurance company master JPN	nvarchar	2	0	Allow NULL?
298	LCT05	Insurance Contract Type	nvarchar	2	0	Allow NULL?
299	LPR05	Period of deduction	nvarchar	2	0	Allow NULL?
300	LCN05	Insurance contractor name	nvarchar	18	0	Allow NULL?
301	LRM05	Refund on maturity indicator	char	1	0	Allow NULL?
302	LNF05	Insurance fee without dividend	decimal	7	2
303	LAF01	LINC&VAN Imported	char	1	0	Allow NULL?
304	LAF02	LINC&VAN Imported	char	1	0	Allow NULL?
305	LAF03	LINC&VAN Imported	char	1	0	Allow NULL?
306	LAF04	LINC&VAN Imported	char	1	0	Allow NULL?
307	LAF05	LINC&VAN Imported	char	1	0	Allow NULL?
308	LATOT	Total of annual fee of long-term accident insurances in YEA	decimal	13	2
309	SCC01	Insurance company master JPN	nvarchar	2	0	Allow NULL?
310	SCT01	Insurance Contract Type	nvarchar	2	0	Allow NULL?
311	SPR01	Period of deduction	nvarchar	2	0	Allow NULL?
312	SCN01	Insurance contractor name	nvarchar	18	0	Allow NULL?
313	SRM01	Refund on maturity indicator	char	1	0	Allow NULL?
314	SNF01	Insurance fee without dividend	decimal	7	2
315	SCC02	Insurance company master JPN	nvarchar	2	0	Allow NULL?
316	SCT02	Insurance Contract Type	nvarchar	2	0	Allow NULL?
317	SPR02	Period of deduction	nvarchar	2	0	Allow NULL?
318	SCN02	Insurance contractor name	nvarchar	18	0	Allow NULL?
319	SRM02	Refund on maturity indicator	char	1	0	Allow NULL?
320	SNF02	Insurance fee without dividend	decimal	7	2
321	SCC03	Insurance company master JPN	nvarchar	2	0	Allow NULL?
322	SCT03	Insurance Contract Type	nvarchar	2	0	Allow NULL?
323	SPR03	Period of deduction	nvarchar	2	0	Allow NULL?
324	SCN03	Insurance contractor name	nvarchar	18	0	Allow NULL?
325	SRM03	Refund on maturity indicator	char	1	0	Allow NULL?
326	SNF03	Insurance fee without dividend	decimal	7	2
327	SCC04	Insurance company master JPN	nvarchar	2	0	Allow NULL?
328	SCT04	Insurance Contract Type	nvarchar	2	0	Allow NULL?
329	SPR04	Period of deduction	nvarchar	2	0	Allow NULL?
330	SCN04	Insurance contractor name	nvarchar	18	0	Allow NULL?
331	SRM04	Refund on maturity indicator	char	1	0	Allow NULL?
332	SNF04	Insurance fee without dividend	decimal	7	2
333	SCC05	Insurance company master JPN	nvarchar	2	0	Allow NULL?
334	SCT05	Insurance Contract Type	nvarchar	2	0	Allow NULL?
335	SPR05	Period of deduction	nvarchar	2	0	Allow NULL?
336	SCN05	Insurance contractor name	nvarchar	18	0	Allow NULL?
337	SRM05	Refund on maturity indicator	char	1	0	Allow NULL?
338	SNF05	Insurance fee without dividend	decimal	7	2
339	SAF01	LINC&VAN Imported	char	1	0	Allow NULL?
340	SAF02	LINC&VAN Imported	char	1	0	Allow NULL?
341	SAF03	LINC&VAN Imported	char	1	0	Allow NULL?
342	SAF04	LINC&VAN Imported	char	1	0	Allow NULL?
343	SAF05	LINC&VAN Imported	char	1	0	Allow NULL?
344	SATOT	Annual Fee for Short-Term Accident or Earthquake Insurance	decimal	13	2
345	SPIID	The indicator of application for the spouse's income in YEA	char	1	0	Allow NULL?
346	SPINC	The spouse's income for YEA	decimal	13	2
347	HSTY1	Deduction Type for Housing Loan	nvarchar	2	0	Allow NULL?
348	HSDE1	Loan Balance of Housing Loan	decimal	8	2
349	HSDA2	Start Living Date	nvarchar	8	0	Allow NULL?
350	HSTY2	Deduction Type for Housing Loan	nvarchar	2	0	Allow NULL?
351	HSDE2	Loan Balance of Housing Loan	decimal	8	2
352	HSDA3	Start Living Date	nvarchar	8	0	Allow NULL?
353	HSTY3	Deduction Type for Housing Loan	nvarchar	2	0	Allow NULL?
354	HSDE3	Loan Balance of Housing Loan	decimal	8	2
355	HOF01	LINC&VAN Imported	char	1	0	Allow NULL?
356	HOF02	LINC&VAN Imported	char	1	0	Allow NULL?
357	HOF03	LINC&VAN Imported	char	1	0	Allow NULL?
358	NLTOT	Total Premium of Common Life Insurance (New Contract)	decimal	13	2
359	NPTOT	Total Premium of Personal Pension Insurance (New Contract)	decimal	13	2
360	NCC01	Insurance company master JPN	nvarchar	2	0	Allow NULL?
361	NCT01	Insurance Contract Type	nvarchar	2	0	Allow NULL?
362	NPR01	Period of deduction	nvarchar	2	0	Allow NULL?
363	NCN01	Insurance contractor name	nvarchar	18	0	Allow NULL?
364	NNF01	Insurance fee without dividend	decimal	7	2
365	NCC02	Insurance company master JPN	nvarchar	2	0	Allow NULL?
366	NCT02	Insurance Contract Type	nvarchar	2	0	Allow NULL?
367	NPR02	Period of deduction	nvarchar	2	0	Allow NULL?
368	NCN02	Insurance contractor name	nvarchar	18	0	Allow NULL?
369	NNF02	Insurance fee without dividend	decimal	7	2
370	NCC03	Insurance company master JPN	nvarchar	2	0	Allow NULL?
371	NCT03	Insurance Contract Type	nvarchar	2	0	Allow NULL?
372	NPR03	Period of deduction	nvarchar	2	0	Allow NULL?
373	NCN03	Insurance contractor name	nvarchar	18	0	Allow NULL?
374	NNF03	Insurance fee without dividend	decimal	7	2
375	NCC04	Insurance company master JPN	nvarchar	2	0	Allow NULL?
376	NCT04	Insurance Contract Type	nvarchar	2	0	Allow NULL?
377	NPR04	Period of deduction	nvarchar	2	0	Allow NULL?
378	NCN04	Insurance contractor name	nvarchar	18	0	Allow NULL?
379	NNF04	Insurance fee without dividend	decimal	7	2
380	NCC05	Insurance company master JPN	nvarchar	2	0	Allow NULL?
381	NCT05	Insurance Contract Type	nvarchar	2	0	Allow NULL?
382	NPR05	Period of deduction	nvarchar	2	0	Allow NULL?
383	NCN05	Insurance contractor name	nvarchar	18	0	Allow NULL?
384	NNF05	Insurance fee without dividend	decimal	7	2
385	NUF01	LINC&VAN Imported	char	1	0	Allow NULL?
386	NUF02	LINC&VAN Imported	char	1	0	Allow NULL?
387	NUF03	LINC&VAN Imported	char	1	0	Allow NULL?
388	NUF04	LINC&VAN Imported	char	1	0	Allow NULL?
389	NUF05	LINC&VAN Imported	char	1	0	Allow NULL?
390	NSTOT	Premium of Nursing and Medical Care Insurance	decimal	13	2
391	REFNM	Process Reference Number	nvarchar	32	0	Allow NULL?

TOP ERP 6.0 | PA0146 INDEXES

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

391 COLUMNS | 1 INDEXES | ERP 6.0 | PA0146 TABLE

TOP ERP 6.0 | PA0146 COLUMNS

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

391 COLUMNS | 1 INDEXES | ERP 6.0 | PA0146 TABLE

TOPERP 6.0 | PA0146 COLUMNS

TOPERP 6.0 | PA0146 INDEXES

TOP ERP 6.0 | PA0146 COLUMNS

TOP ERP 6.0 | PA0146 INDEXES