	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	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	OINM	101	Whse Journal

225 COLUMNS | 1 INDEXES | ERP 6.0 | PA0542 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Korea
1	ERP EHP7	6.0	PA0542	225	1	Y.E.A. KR	Korea

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, COM01, BUS01, SAL01, BON01, INT01, RET01, OUT01, OVR01, OTH01, MED01, NPM01, EIM01, FLD01, FRI01, FRE01, COM02, BUS02, SAL02, BON02, INT02, RET02, OUT02, OVR02, OTH02, MED02, NPM02, EIM02, FLD02, FRI02, FRE02, COM03, BUS03, SAL03, BON03, INT03, RET03, OUT03, OVR03, OTH03, MED03, NPM03, EIM03, FLD03, FRI03, FRE03, COM04, BUS04, SAL04, BON04, INT04, RET04, OUT04, OVR04, OTH04, MED04, NPM04, EIM04, FLD04, FRI04, FRE04, COM05, BUS05, SAL05, BON05, INT05, RET05, OUT05, OVR05, OTH05, MED05, NPM05, EIM05, FLD05, FRI05, FRE05, FOTIS, SUBIS, FMDOH, FMDED, SUBME, FCEEE, FCECU, SUBCE, FLGDO, FDSDO, FPRDO, SUBRD, SAVNM, SAVAM, ACQDT, REPAY, APPDT, CRDCD, ABPLA, ABJOB, ABDUR, ABPAY, TAXCT, KORCR, GETDT, PUTDT, FTCHI, FTCES, FPERP, FPERN, FINVT, FINVS, ABN01, SPT01, ABN02, SPT02, ABN03, SPT03, ABN04, SPT04, ABN05, SPT05, FTCLS, FOHIS, FHADI, FTCLP, COMST, SPCDO, FCEWF, FCEHD, DRTCD, HSINS, HSSAV, EEHSS, LHSSV, DON30, POLDN, CONMA, CONRE, CONFU, CRDDP, GIROE, CASHE, FORCT, FORCK, INTTL, DUPEX, RETPE, TINVS, PINVS, OTHPI, ONP01, ONP02, ONP03, ONP04, ONP05, RSN01, RSN02, RSN03, RSN04, RSN05, STK01, STK02, STK03, STK04, STK05, FOR01, CLD01, FOR02, CLD02, FOR03, CLD03, FOR04, CLD04, FOR05, CLD05, REP01, REP02, REP03, REP04, REP05, TPA01, TPA02, TPA03, TPA04, TPA05, DESDO, RELDO, SMBFI, LTSF1, LTSF2, LTSF3, NINVS, INDIF, INSLN, SFENP, SFEHI, MRNTD, INDPL, PDCID, HSHLD, VINVS, INTFN, INTOT, INVST, IRLWL, EXTAX FROM PA0542

TOP ERP 6.0 | PA0542 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	NUMC	(N'00000000')	No	PA0003	PERSNO	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	CHAR	(N' ')	No		SUBTY	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	CHAR	(N' ')	No		OBJPS	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	CHAR	(N' ')	No		SPRPS	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	DATS	(N'00000000')	No		ENDDA	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	DATS	(N'00000000')	No		BEGDA	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	NUMC	(N'000')	No		SEQNR	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	CHAR	(N' ')	Yes		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	CHAR	(N' ')	Yes		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	CHAR	(N' ')	Yes		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	CHAR	(N' ')	Yes		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	CHAR	(N' ')	Yes		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	CHAR	(N' ')	Yes	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	COM01	Previous Company / Taxpayer Association Name	nvarchar	24	0	CHAR	(N' ')	Yes		PKR_COMNM	Allow NULL?
25	BUS01	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	CHAR	(N' ')	Yes	T7KRP0	PKR_BIZNO	Allow NULL?
26	SAL01	Regular salary from the previous company	decimal	11	2	CURR	((0))	Yes		PKR_SAL01
27	BON01	Previous company's bonus	decimal	11	2	CURR	((0))	Yes		PKR_BON01
28	INT01	Income tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_INT01
29	RET01	Resident tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_RET01
30	OUT01	Non-taxable overseas income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OUT01
31	OVR01	Non-taxable overtime from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OVR01
32	OTH01	Other non-taxable income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OTH01
33	MED01	Medical insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_MED01
34	NPM01	National pension premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_NPM01
35	EIM01	Employment insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_EIM01
36	FLD01	Field engineer deduction	decimal	9	2	CURR	((0))	Yes		PKR_FLD01
37	FRI01	Exemption by income tax law in previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRI01
38	FRE01	Exempted tax amount by tax exemption law	decimal	9	2	CURR	((0))	Yes		PKR_FRE01
39	COM02	Previous Company / Taxpayer Association Name	nvarchar	24	0	CHAR	(N' ')	Yes		PKR_COMNM	Allow NULL?
40	BUS02	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	CHAR	(N' ')	Yes	T7KRP0	PKR_BIZNO	Allow NULL?
41	SAL02	Regular salary from the previous company	decimal	11	2	CURR	((0))	Yes		PKR_SAL01
42	BON02	Previous company's bonus	decimal	11	2	CURR	((0))	Yes		PKR_BON01
43	INT02	Income tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_INT01
44	RET02	Resident tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_RET01
45	OUT02	Non-taxable overseas income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OUT01
46	OVR02	Non-taxable overtime from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OVR01
47	OTH02	Other non-taxable income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OTH01
48	MED02	Medical insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_MED01
49	NPM02	National pension premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_NPM01
50	EIM02	Employment insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_EIM01
51	FLD02	Field engineer deduction	decimal	9	2	CURR	((0))	Yes		PKR_FLD01
52	FRI02	Exemption by income tax law in previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRI01
53	FRE02	Exempted tax amount by tax exemption law	decimal	9	2	CURR	((0))	Yes		PKR_FRE01
54	COM03	Previous Company / Taxpayer Association Name	nvarchar	24	0	CHAR	(N' ')	Yes		PKR_COMNM	Allow NULL?
55	BUS03	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	CHAR	(N' ')	Yes	T7KRP0	PKR_BIZNO	Allow NULL?
56	SAL03	Regular salary from the previous company	decimal	11	2	CURR	((0))	Yes		PKR_SAL01
57	BON03	Previous company's bonus	decimal	11	2	CURR	((0))	Yes		PKR_BON01
58	INT03	Income tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_INT01
59	RET03	Resident tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_RET01
60	OUT03	Non-taxable overseas income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OUT01
61	OVR03	Non-taxable overtime from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OVR01
62	OTH03	Other non-taxable income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OTH01
63	MED03	Medical insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_MED01
64	NPM03	National pension premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_NPM01
65	EIM03	Employment insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_EIM01
66	FLD03	Field engineer deduction	decimal	9	2	CURR	((0))	Yes		PKR_FLD01
67	FRI03	Exemption by income tax law in previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRI01
68	FRE03	Exempted tax amount by tax exemption law	decimal	9	2	CURR	((0))	Yes		PKR_FRE01
69	COM04	Previous Company / Taxpayer Association Name	nvarchar	24	0	CHAR	(N' ')	Yes		PKR_COMNM	Allow NULL?
70	BUS04	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	CHAR	(N' ')	Yes	T7KRP0	PKR_BIZNO	Allow NULL?
71	SAL04	Regular salary from the previous company	decimal	11	2	CURR	((0))	Yes		PKR_SAL01
72	BON04	Previous company's bonus	decimal	11	2	CURR	((0))	Yes		PKR_BON01
73	INT04	Income tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_INT01
74	RET04	Resident tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_RET01
75	OUT04	Non-taxable overseas income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OUT01
76	OVR04	Non-taxable overtime from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OVR01
77	OTH04	Other non-taxable income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OTH01
78	MED04	Medical insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_MED01
79	NPM04	National pension premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_NPM01
80	EIM04	Employment insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_EIM01
81	FLD04	Field engineer deduction	decimal	9	2	CURR	((0))	Yes		PKR_FLD01
82	FRI04	Exemption by income tax law in previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRI01
83	FRE04	Exempted tax amount by tax exemption law	decimal	9	2	CURR	((0))	Yes		PKR_FRE01
84	COM05	Previous Company / Taxpayer Association Name	nvarchar	24	0	CHAR	(N' ')	Yes		PKR_COMNM	Allow NULL?
85	BUS05	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	CHAR	(N' ')	Yes	T7KRP0	PKR_BIZNO	Allow NULL?
86	SAL05	Regular salary from the previous company	decimal	11	2	CURR	((0))	Yes		PKR_SAL01
87	BON05	Previous company's bonus	decimal	11	2	CURR	((0))	Yes		PKR_BON01
88	INT05	Income tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_INT01
89	RET05	Resident tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_RET01
90	OUT05	Non-taxable overseas income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OUT01
91	OVR05	Non-taxable overtime from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OVR01
92	OTH05	Other non-taxable income from previous company	decimal	9	2	CURR	((0))	Yes		PKR_OTH01
93	MED05	Medical insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_MED01
94	NPM05	National pension premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_NPM01
95	EIM05	Employment insurance premium from previous company	decimal	9	2	CURR	((0))	Yes		PKR_EIM01
96	FLD05	Field engineer deduction	decimal	9	2	CURR	((0))	Yes		PKR_FLD01
97	FRI05	Exemption by income tax law in previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRI01
98	FRE05	Exempted tax amount by tax exemption law	decimal	9	2	CURR	((0))	Yes		PKR_FRE01
99	FOTIS	Insurance premium expense	decimal	10	2	CURR	((0))	Yes		PKR_FOTIS
100	SUBIS	Date of submitting application for other insurance premium	nvarchar	8	0	DATS	(N'00000000')	Yes		PKR_SUBIS	Allow NULL?
101	FMDOH	Medical expenses for the aged	decimal	10	2	CURR	((0))	Yes		PKR_FMDOH
102	FMDED	Medical expense for the employee or dependents	decimal	10	2	CURR	((0))	Yes		PKR_FMDED
103	SUBME	Date of submitting application for medical expense	nvarchar	8	0	DATS	(N'00000000')	Yes		PKR_SUBME	Allow NULL?
104	FCEEE	Education expense for employee him/herself	decimal	10	2	CURR	((0))	Yes		PKR_FCEEE
105	FCECU	Educational expenses for dependents	decimal	9	2	CURR	((0))	Yes		PKR_FCECU
106	SUBCE	Date of application for cultural & educational expense	nvarchar	8	0	DATS	(N'00000000')	Yes		PKR_SUBCE	Allow NULL?
107	FLGDO	Legal donations	decimal	9	2	CURR	((0))	Yes		PKR_FLGDO
108	FDSDO	Donations to appointed associations	decimal	9	2	CURR	((0))	Yes		PKR_FDSDO
109	FPRDO	Interest Payment for Housing Loan (6M)	decimal	9	2	CURR	((0))	Yes		PKR_FPRDO
110	SUBRD	Date of submitting receipt for donation	nvarchar	8	0	DATS	(N'00000000')	Yes		PKR_SUBRD	Allow NULL?
111	SAVNM	House savings name	nvarchar	30	0	CHAR	(N' ')	Yes		PKR_SAVNM	Allow NULL?
112	SAVAM	The saving amount for housing	decimal	9	2	CURR	((0))	Yes		PKR_SAVAM
113	ACQDT	Date of buying or renting a house	nvarchar	8	0	DATS	(N'00000000')	Yes		PKR_ACQDT	Allow NULL?
114	REPAY	Annual repayment for the principal of housing loan	decimal	9	2	CURR	((0))	Yes		PKR_REPAY
115	APPDT	Date of application for housing fee	nvarchar	8	0	DATS	(N'00000000')	Yes		PKR_APPDT	Allow NULL?
116	CRDCD	Expense for credit card	decimal	10	2	CURR	((0))	Yes		PKR_CRDCD
117	ABPLA	Working place for overseas employee	nvarchar	30	0	CHAR	(N' ')	Yes		PKR_ABPLA	Allow NULL?
118	ABJOB	Employee's job during working overseas	nvarchar	30	0	CHAR	(N' ')	Yes		PKR_ABJOB	Allow NULL?
119	ABDUR	The number of months during working overseas	nvarchar	3	0	CHAR	(N' ')	Yes		PKR_ABDUR	Allow NULL?
120	ABPAY	Total earned income during working overseas	decimal	11	2	CURR	((0))	Yes		PKR_ABPAY
121	TAXCT	Tax paid country	nvarchar	3	0	CHAR	(N' ')	Yes	T005T	PKR_TAXCT	Allow NULL?
122	KORCR	Tax paid oversea in Korean WON	decimal	11	2	CURR	((0))	Yes		PKR_KORCR
123	GETDT	Date of getting application for overseas tax credit	nvarchar	8	0	DATS	(N'00000000')	Yes		PKR_GETDT	Allow NULL?
124	PUTDT	Date of submitting application for overseas tax credit	nvarchar	8	0	DATS	(N'00000000')	Yes		PKR_PUTDT	Allow NULL?
125	FTCHI	Payment for the housing loan interest	decimal	13	2	CURR	((0))	Yes		PKR_FTCHI
126	FTCES	Payment for employee stock saving	decimal	13	2	CURR	((0))	Yes		PKR_FTCES
127	FPERP	Payment for personal pension savings	decimal	11	2	CURR	((0))	Yes		PKR_FPERP
128	FPERN	Payment for pension savings (from 2001.01.01)	decimal	11	2	CURR	((0))	Yes		PKR_FPERN
129	FINVT	Investment (30%)	decimal	11	2	CURR	((0))	Yes		PKR_FINVT
130	FINVS	Investment (15%)	decimal	11	2	CURR	((0))	Yes		PKR_FINVS
131	ABN01	Previous company's acknowledged bonus	decimal	11	2	CURR	((0))	Yes		PKR_ABN01
132	SPT01	Special tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_SPT01
133	ABN02	Previous company's acknowledged bonus	decimal	11	2	CURR	((0))	Yes		PKR_ABN01
134	SPT02	Special tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_SPT01
135	ABN03	Previous company's acknowledged bonus	decimal	11	2	CURR	((0))	Yes		PKR_ABN01
136	SPT03	Special tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_SPT01
137	ABN04	Previous company's acknowledged bonus	decimal	11	2	CURR	((0))	Yes		PKR_ABN01
138	SPT04	Special tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_SPT01
139	ABN05	Previous company's acknowledged bonus	decimal	11	2	CURR	((0))	Yes		PKR_ABN01
140	SPT05	Special tax paid in the previous company	decimal	9	2	CURR	((0))	Yes		PKR_SPT01
141	FTCLS	Long term stock saving for current year	decimal	11	2	CURR	((0))	Yes		PKR_FTCLS
142	FOHIS	Insurance premium for handicapped person	decimal	10	2	CURR	((0))	Yes		PKR_FOHIS
143	FHADI	Medical expenses for the handicapped	decimal	9	2	CURR	((0))	Yes		PKR_FHADI
144	FTCLP	long term stock savings for previous year	decimal	11	2	CURR	((0))	Yes		PKR_FTCLP
145	COMST	Company stock	decimal	11	2	CURR	((0))	Yes		PKR_COMST
146	SPCDO	Special donation	decimal	9	2	CURR	((0))	Yes		PKR_SPCDO
147	FCEWF	Educational expense for employee's spouse	decimal	9	2	CURR	((0))	Yes		PKR_FCEWF
148	FCEHD	Educational expense for the handicapped	decimal	10	2	CURR	((0))	Yes		PKR_FCEHD
149	DRTCD	Expense for direct card	decimal	9	2	CURR	((0))	Yes		PKR_DRTCD
150	HSINS	Housing installment amount	decimal	9	2	CURR	((0))	Yes		PKR_HSINS
151	HSSAV	Housing saving amount	decimal	10	2	CURR	((0))	Yes		PKR_HSSAV
152	EEHSS	Employee housing saving amount	decimal	10	2	CURR	((0))	Yes		PKR_EEHSS
153	LHSSV	Long-term housing saving amount	decimal	9	2	CURR	((0))	Yes		PKR_LHSSV
154	DON30	30% deduction donation amount	decimal	9	2	CURR	((0))	Yes		PKR_DON30
155	POLDN	Political donation amount	decimal	9	2	CURR	((0))	Yes		PKR_POLDN
156	CONMA	Congratulations and condo-lences: times of marriage	char	1	0	NUMC	(N'0')	Yes		PKR_CONMA	Allow NULL?
157	CONRE	Congratulations and condo-lences: times of removal	char	1	0	NUMC	(N'0')	Yes		PKR_CONRE	Allow NULL?
158	CONFU	Congratulations and condo-lences: times of funeral	char	1	0	NUMC	(N'0')	Yes		PKR_CONFU	Allow NULL?
159	CRDDP	Expense paid by dependant's credit card	decimal	9	2	CURR	((0))	Yes		PKR_CRDDP
160	GIROE	Expense paid by giro institution	decimal	9	2	CURR	((0))	Yes		PKR_GIROE
161	CASHE	Expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_CASHE
162	FORCT	Pre-paid tax amount in foreign currency	decimal	9	2	CURR	((0))	Yes		PKR_FORCT
163	FORCK	Pre-paid tax currency in foreign currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_FORCK	Allow NULL?
164	INTTL	Interest Payment for Housing Loan (10M)	decimal	9	2	CURR	((0))	Yes		PKR_INTHL
165	DUPEX	Medical Expense for Non-dependents	decimal	9	2	CURR	((0))	Yes		PKR_DUPEX
166	RETPE	Retirement pension	decimal	10	2	CURR	((0))	Yes		PKR_RETPE
167	TINVS	Investment Since Jan. 2007	decimal	11	2	CURR	((0))	Yes		PKR_TINVS
168	PINVS	Investment Till Dec. 2006	decimal	11	2	CURR	((0))	Yes		PKR_PINVS
169	OTHPI	Other Pension Insurance	decimal	10	2	CURR	((0))	Yes		PKR_OTHPI
170	ONP01	Other NP Premium from Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_OTHNP
171	ONP02	Other NP Premium from Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_OTHNP
172	ONP03	Other NP Premium from Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_OTHNP
173	ONP04	Other NP Premium from Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_OTHNP
174	ONP05	Other NP Premium from Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_OTHNP
175	RSN01	Research non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_RSNTX
176	RSN02	Research non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_RSNTX
177	RSN03	Research non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_RSNTX
178	RSN04	Research non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_RSNTX
179	RSN05	Research non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_RSNTX
180	STK01	Previous Company's Stock Option	decimal	11	2	CURR	((0))	Yes		PKR_STOPT
181	STK02	Previous Company's Stock Option	decimal	11	2	CURR	((0))	Yes		PKR_STOPT
182	STK03	Previous Company's Stock Option	decimal	11	2	CURR	((0))	Yes		PKR_STOPT
183	STK04	Previous Company's Stock Option	decimal	11	2	CURR	((0))	Yes		PKR_STOPT
184	STK05	Previous Company's Stock Option	decimal	11	2	CURR	((0))	Yes		PKR_STOPT
185	FOR01	Foreigner non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRNTX
186	CLD01	Childcare non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_CLNTX
187	FOR02	Foreigner non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRNTX
188	CLD02	Childcare non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_CLNTX
189	FOR03	Foreigner non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRNTX
190	CLD03	Childcare non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_CLNTX
191	FOR04	Foreigner non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRNTX
192	CLD04	Childcare non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_CLNTX
193	FOR05	Foreigner non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_FRNTX
194	CLD05	Childcare non-taxable from previous company	decimal	9	2	CURR	((0))	Yes		PKR_CLNTX
195	REP01	Retirement Pension From Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_REPPC
196	REP02	Retirement Pension From Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_REPPC
197	REP03	Retirement Pension From Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_REPPC
198	REP04	Retirement Pension From Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_REPPC
199	REP05	Retirement Pension From Previous Company	decimal	10	2	CURR	((0))	Yes		PKR_REPPC
200	TPA01	Indicator for Taxpayer Association	char	1	0	CHAR	(N' ')	Yes		PKR_TXPAS	Allow NULL?
201	TPA02	Indicator for Taxpayer Association	char	1	0	CHAR	(N' ')	Yes		PKR_TXPAS	Allow NULL?
202	TPA03	Indicator for Taxpayer Association	char	1	0	CHAR	(N' ')	Yes		PKR_TXPAS	Allow NULL?
203	TPA04	Indicator for Taxpayer Association	char	1	0	CHAR	(N' ')	Yes		PKR_TXPAS	Allow NULL?
204	TPA05	Indicator for Taxpayer Association	char	1	0	CHAR	(N' ')	Yes		PKR_TXPAS	Allow NULL?
205	DESDO	Other Designation Donation	decimal	9	2	CURR	((0))	Yes		PKR_DESDO
206	RELDO	Religious Donation	decimal	9	2	CURR	((0))	Yes		PKR_RELDO
207	SMBFI	Small Biz Insurance Funds	decimal	11	2	CURR	((0))	Yes		PKR_SMBFI
208	LTSF1	Investment in Long-Term Stock Fund (First Year)	decimal	11	2	CURR	((0))	Yes		PKR_LTSF1
209	LTSF2	Investment in Long-Term Stock Fund (Second Year)	decimal	11	2	CURR	((0))	Yes		PKR_LTSF2
210	LTSF3	Investment in Long-Term Stock Fund (Third Year)	decimal	11	2	CURR	((0))	Yes		PKR_LTSF3
211	NINVS	Investment Since Jan. 2009	decimal	11	2	CURR	((0))	Yes		PKR_NINVS
212	INDIF	Income Reduction for Job Keeping	decimal	13	2	CURR	((0))	Yes		PKR_INDIF
213	INSLN	Interest Payment for Housing Loan (15M)	decimal	11	2	CURR	((0))	Yes		PKR_INSLN
214	SFENP	National Pension Premium for Self-Insured Employee	decimal	9	2	CURR	((0))	Yes		PKR_SFENP
215	SFEHI	Health Insurance Premium for Self-Insured Employee	decimal	9	2	CURR	((0))	Yes		PKR_SFEHI
216	MRNTD	Total Monthly Rent Amount	decimal	11	2	CURR	((0))	Yes		PKR_MRNTD
217	INDPL	Repayment to Individual Lender	decimal	9	2	CURR	((0))	Yes		PKR_INDPL
218	PDCID	Personal Deduction Changed Indicator	char	1	0	CHAR	(N' ')	Yes		PKR_PDCID	Allow NULL?
219	HSHLD	Householder Indicator	char	1	0	CHAR	(N' ')	Yes		PKR_HSHLD	Allow NULL?
220	VINVS	Investment Since Jan. 2012 for Venture Enterprises	decimal	11	2	CURR	((0))	Yes		PKR_VINVS
221	INTFN	Fix interest/Non-deferred loan payment (15M)	decimal	11	2	CURR	((0))	Yes		PKR_INTFN
222	INTOT	Other Housing Interest Loan Payment (5M)	decimal	9	2	CURR	((0))	Yes		PKR_INTOT
223	INVST	Investment Since January 2012	decimal	11	2	CURR	((0))	Yes		PKR_INVST
224	IRLWL	Interest Payment for Housing Rental Loan without a Lump-sum	decimal	11	2	CURR	((0))	Yes		PKR_IRLWL
225	EXTAX	Exception Tax	char	1	0	CHAR	(N' ')	Yes		PKR_EXTAX	Allow NULL?

TOP ERP 6.0 | PA0542 INDEXES

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

225 COLUMNS | 1 INDEXES | ERP 6.0 | PA0542 TABLE

TOP ERP 6.0 | PA0542 COLUMNS

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

225 COLUMNS | 1 INDEXES | ERP 6.0 | PA0542 TABLE

TOPERP 6.0 | PA0542 COLUMNS

TOPERP 6.0 | PA0542 INDEXES

TOP ERP 6.0 | PA0542 COLUMNS

TOP ERP 6.0 | PA0542 INDEXES