	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

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