	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

222 COLUMNS | 1 INDEXES | ERP 6.0 | PA0812 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Korea
1	ERP EHP7	6.0	PA0812	222	1	HR Master Record: Infotype 0812	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, SUB01, OBJ01, NUM01, NAM01, CNT01, AMT01, CUR01, SUB02, OBJ02, NUM02, NAM02, CNT02, AMT02, CUR02, SUB03, OBJ03, NUM03, NAM03, CNT03, AMT03, CUR03, SUB04, OBJ04, NUM04, NAM04, CNT04, AMT04, CUR04, SUB05, OBJ05, NUM05, NAM05, CNT05, AMT05, CUR05, SUB06, OBJ06, NUM06, NAM06, CNT06, AMT06, CUR06, SUB07, OBJ07, NUM07, NAM07, CNT07, AMT07, CUR07, SUB08, OBJ08, NUM08, NAM08, CNT08, AMT08, CUR08, SUB09, OBJ09, NUM09, NAM09, CNT09, AMT09, CUR09, SUB10, OBJ10, NUM10, NAM10, CNT10, AMT10, CUR10, SUB11, OBJ11, NUM11, NAM11, CNT11, AMT11, CUR11, SUB12, OBJ12, NUM12, NAM12, CNT12, AMT12, CUR12, SUB13, OBJ13, NUM13, NAM13, CNT13, AMT13, CUR13, SUB14, OBJ14, NUM14, NAM14, CNT14, AMT14, CUR14, SUB15, OBJ15, NUM15, NAM15, CNT15, AMT15, CUR15, SUB16, OBJ16, NUM16, NAM16, CNT16, AMT16, CUR16, SUB17, OBJ17, NUM17, NAM17, CNT17, AMT17, CUR17, SUB18, OBJ18, NUM18, NAM18, CNT18, AMT18, CUR18, CDT01, CDA01, CDT02, CDA02, CDT03, CDA03, CDT04, CDA04, CDT05, CDA05, CDT06, CDA06, CDT07, CDA07, CDT08, CDA08, CDT09, CDA09, CDT10, CDA10, CDT11, CDA11, CDT12, CDA12, CDT13, CDA13, CDT14, CDA14, CDT15, CDA15, CDT16, CDA16, CDT17, CDA17, CDT18, CDA18, FLNTS, PCD01, PCD02, PCD03, PCD04, PCD05, PCD06, PCD07, PCD08, PCD09, PCD10, PCD11, PCD12, PCD13, PCD14, PCD15, PCD16, PCD17, PCD18, STY01, STY02, STY03, STY04, STY05, STY06, STY07, STY08, STY09, STY10, STY11, STY12, STY13, STY14, STY15, STY16, STY17, STY18 FROM PA0812

TOP ERP 6.0 | PA0812 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	SUB01	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
25	OBJ01	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
26	NUM01	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
27	NAM01	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
28	CNT01	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
29	AMT01	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
30	CUR01	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
31	SUB02	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
32	OBJ02	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
33	NUM02	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
34	NAM02	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
35	CNT02	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
36	AMT02	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
37	CUR02	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
38	SUB03	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
39	OBJ03	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
40	NUM03	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
41	NAM03	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
42	CNT03	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
43	AMT03	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
44	CUR03	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
45	SUB04	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
46	OBJ04	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
47	NUM04	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
48	NAM04	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
49	CNT04	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
50	AMT04	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
51	CUR04	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
52	SUB05	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
53	OBJ05	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
54	NUM05	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
55	NAM05	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
56	CNT05	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
57	AMT05	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
58	CUR05	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
59	SUB06	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
60	OBJ06	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
61	NUM06	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
62	NAM06	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
63	CNT06	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
64	AMT06	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
65	CUR06	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
66	SUB07	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
67	OBJ07	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
68	NUM07	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
69	NAM07	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
70	CNT07	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
71	AMT07	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
72	CUR07	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
73	SUB08	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
74	OBJ08	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
75	NUM08	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
76	NAM08	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
77	CNT08	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
78	AMT08	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
79	CUR08	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
80	SUB09	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
81	OBJ09	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
82	NUM09	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
83	NAM09	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
84	CNT09	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
85	AMT09	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
86	CUR09	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
87	SUB10	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
88	OBJ10	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
89	NUM10	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
90	NAM10	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
91	CNT10	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
92	AMT10	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
93	CUR10	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	PKR_MECUR	Allow NULL?
94	SUB11	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
95	OBJ11	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
96	NUM11	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
97	NAM11	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
98	CNT11	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
99	AMT11	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
100	CUR11	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
101	SUB12	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
102	OBJ12	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
103	NUM12	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
104	NAM12	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
105	CNT12	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
106	AMT12	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
107	CUR12	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
108	SUB13	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
109	OBJ13	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
110	NUM13	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
111	NAM13	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
112	CNT13	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
113	AMT13	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
114	CUR13	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
115	SUB14	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
116	OBJ14	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
117	NUM14	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
118	NAM14	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
119	CNT14	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
120	AMT14	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
121	CUR14	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
122	SUB15	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
123	OBJ15	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
124	NUM15	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
125	NAM15	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
126	CNT15	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
127	AMT15	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
128	CUR15	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
129	SUB16	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
130	OBJ16	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
131	NUM16	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
132	NAM16	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
133	CNT16	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
134	AMT16	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
135	CUR16	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
136	SUB17	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
137	OBJ17	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
138	NUM17	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
139	NAM17	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
140	CNT17	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
141	AMT17	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
142	CUR17	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
143	SUB18	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
144	OBJ18	Object Identification	nvarchar	2	0	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
145	NUM18	Biz number of supply	nvarchar	10	0	CHAR	(N' ')	Yes		PKR_SUPNR	Allow NULL?
146	NAM18	Name of supply	nvarchar	40	0	CHAR	(N' ')	Yes		PKR_SUPNM	Allow NULL?
147	CNT18	Count for medical expense by cash	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECNT	Allow NULL?
148	AMT18	Amount for medical expense paid by cash	decimal	10	2	CURR	((0))	Yes		PKR_MEAMT
149	CUR18	Medical expense currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	PKR_MECUR	Allow NULL?
150	CDT01	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
151	CDA01	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
152	CDT02	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
153	CDA02	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
154	CDT03	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
155	CDA03	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
156	CDT04	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
157	CDA04	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
158	CDT05	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
159	CDA05	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
160	CDT06	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
161	CDA06	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
162	CDT07	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
163	CDA07	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
164	CDT08	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
165	CDA08	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
166	CDT09	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
167	CDA09	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
168	CDT10	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
169	CDA10	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
170	CDT11	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
171	CDA11	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
172	CDT12	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
173	CDA12	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
174	CDT13	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
175	CDA13	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
176	CDT14	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
177	CDA14	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
178	CDT15	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
179	CDA15	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
180	CDT16	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
181	CDA16	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
182	CDT17	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
183	CDA17	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
184	CDT18	Credit Card count for medical exp	nvarchar	5	0	NUMC	(N'00000')	Yes		PKR_MECDT	Allow NULL?
185	CDA18	Credit amount for medical expense	decimal	9	2	CURR	((0))	Yes		PKR_MECDA
186	FLNTS	Flag for NTS data or others	char	1	0	CHAR	(N' ')	Yes		PKR_FLNTS	Allow NULL?
187	PCD01	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
188	PCD02	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
189	PCD03	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
190	PCD04	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
191	PCD05	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
192	PCD06	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
193	PCD07	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
194	PCD08	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
195	PCD09	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
196	PCD10	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
197	PCD11	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
198	PCD12	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
199	PCD13	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
200	PCD14	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
201	PCD15	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
202	PCD16	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
203	PCD17	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
204	PCD18	Proof Code for Medical Expense Classification	char	1	0	CHAR	(N' ')	Yes		PKR_MEPCD	Allow NULL?
205	STY01	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
206	STY02	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
207	STY03	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
208	STY04	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
209	STY05	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
210	STY06	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
211	STY07	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
212	STY08	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
213	STY09	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
214	STY10	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
215	STY11	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
216	STY12	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
217	STY13	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
218	STY14	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
219	STY15	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
220	STY16	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
221	STY17	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?
222	STY18	Expense Category	char	1	0	CHAR	(N' ')	Yes		PKR_EXSTY	Allow NULL?

TOP ERP 6.0 | PA0812 INDEXES

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

222 COLUMNS | 1 INDEXES | ERP 6.0 | PA0812 TABLE

TOP ERP 6.0 | PA0812 COLUMNS

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

222 COLUMNS | 1 INDEXES | ERP 6.0 | PA0812 TABLE

TOPERP 6.0 | PA0812 COLUMNS

TOPERP 6.0 | PA0812 INDEXES

TOP ERP 6.0 | PA0812 COLUMNS

TOP ERP 6.0 | PA0812 INDEXES