	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

186 COLUMNS | 2 INDEXES | ERP 6.0 | PA0056 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Austria
1	ERP EHP7	6.0	PA0056	186	2	HR Master Record: Infotype 0056 (Sick Certificates A)	Austria

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, FAMSA, OBJID, MACOD, DOC01, ADT01, UVN01, UBS01, ULD01, DOC02, ADT02, UVN02, UBS02, ULD02, DOC03, ADT03, UVN03, UBS03, ULD03, DOC04, ADT04, UVN04, UBS04, ULD04, DOC05, ADT05, UVN05, UBS05, ULD05, DOC06, ADT06, UVN06, UBS06, ULD06, DOC07, ADT07, UVN07, UBS07, ULD07, DOC08, ADT08, UVN08, UBS08, ULD08, DOC09, ADT09, UVN09, UBS09, ULD09, DOC10, ADT10, UVN10, UBS10, ULD10, DOC11, ADT11, UVN11, UBS11, ULD11, DOC12, ADT12, UVN12, UBS12, ULD12, DOC13, ADT13, UVN13, UBS13, ULD13, DOC14, ADT14, UVN14, UBS14, ULD14, DOC15, ADT15, UVN15, UBS15, ULD15, DOC16, ADT16, UVN16, UBS16, ULD16, DOC17, ADT17, UVN17, UBS17, ULD17, DOC18, ADT18, UVN18, UBS18, ULD18, DOC19, ADT19, UVN19, UBS19, ULD19, DOC20, ADT20, UVN20, UBS20, ULD20, PRT01, DPL01, ADR01, PRT02, DPL02, ADR02, PRT03, DPL03, ADR03, PRT04, DPL04, ADR04, PRT05, DPL05, ADR05, PRT06, DPL06, ADR06, PRT07, DPL07, ADR07, PRT08, DPL08, ADR08, PRT09, DPL09, ADR09, PRT10, DPL10, ADR10, PRT11, DPL11, ADR11, PRT12, DPL12, ADR12, PRT13, DPL13, ADR13, PRT14, DPL14, ADR14, PRT15, DPL15, ADR15, PRT16, DPL16, ADR16, PRT17, DPL17, ADR17, PRT18, DPL18, ADR18, PRT19, DPL19, ADR19, PRT20, DPL20, ADR20 FROM PA0056

TOP ERP 6.0 | PA0056 COLUMNS

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	NUMC	(N'00000000')	No	PA0003	PERSNO	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	CHAR	(N' ')	No		SUBTY	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	CHAR	(N' ')	No		OBJPS	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	CHAR	(N' ')	No		SPRPS	Allow NULL?
6	ENDDA	End Date	nvarchar	8	DATS	(N'00000000')	No		ENDDA	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	DATS	(N'00000000')	No		BEGDA	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	NUMC	(N'000')	No		SEQNR	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	CHAR	(N' ')	Yes		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	CHAR	(N' ')	Yes		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	CHAR	(N' ')	Yes		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	CHAR	(N' ')	Yes		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	CHAR	(N' ')	Yes		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	CHAR	(N' ')	Yes		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	CHAR	(N' ')	Yes	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	CHAR	(N' ')	Yes		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	FAMSA	Type of Family Record	nvarchar	4	CHAR	(N' ')	Yes		FAMSA	Allow NULL?
25	OBJID	Object Identification	nvarchar	2	CHAR	(N' ')	Yes		OBJPS	Allow NULL?
26	MACOD	Field containing 'X' or blank	char	1	CHAR	(N' ')	Yes		MACOD	Allow NULL?
27	DOC01	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	T578A	DOCID	Allow NULL?
28	ADT01	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
29	UVN01	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
30	UBS01	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
31	ULD01	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
32	DOC02	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
33	ADT02	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
34	UVN02	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
35	UBS02	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
36	ULD02	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
37	DOC03	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
38	ADT03	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
39	UVN03	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
40	UBS03	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
41	ULD03	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
42	DOC04	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
43	ADT04	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
44	UVN04	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
45	UBS04	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
46	ULD04	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
47	DOC05	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
48	ADT05	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
49	UVN05	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
50	UBS05	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
51	ULD05	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
52	DOC06	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
53	ADT06	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
54	UVN06	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
55	UBS06	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
56	ULD06	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
57	DOC07	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
58	ADT07	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
59	UVN07	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
60	UBS07	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
61	ULD07	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
62	DOC08	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
63	ADT08	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
64	UVN08	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
65	UBS08	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
66	ULD08	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
67	DOC09	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
68	ADT09	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
69	UVN09	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
70	UBS09	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
71	ULD09	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
72	DOC10	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
73	ADT10	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
74	UVN10	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
75	UBS10	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
76	ULD10	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
77	DOC11	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
78	ADT11	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
79	UVN11	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
80	UBS11	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
81	ULD11	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
82	DOC12	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
83	ADT12	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
84	UVN12	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
85	UBS12	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
86	ULD12	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
87	DOC13	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
88	ADT13	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
89	UVN13	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
90	UBS13	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
91	ULD13	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
92	DOC14	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
93	ADT14	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
94	UVN14	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
95	UBS14	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
96	ULD14	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
97	DOC15	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
98	ADT15	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
99	UVN15	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
100	UBS15	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
101	ULD15	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
102	DOC16	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
103	ADT16	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
104	UVN16	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
105	UBS16	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
106	ULD16	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
107	DOC17	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
108	ADT17	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
109	UVN17	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
110	UBS17	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
111	ULD17	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
112	DOC18	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
113	ADT18	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
114	UVN18	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
115	UBS18	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
116	ULD18	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
117	DOC19	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
118	ADT19	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
119	UVN19	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
120	UBS19	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
121	ULD19	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
122	DOC20	Doctor key	nvarchar	4	CHAR	(N' ')	Yes	*	DOCID	Allow NULL?
123	ADT20	Date of issue of sickness certificate	nvarchar	8	DATS	(N'00000000')	Yes		ASDAT	Allow NULL?
124	UVN20	Start of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URVON	Allow NULL?
125	UBS20	End of Leave	nvarchar	8	DATS	(N'00000000')	Yes		URBIS	Allow NULL?
126	ULD20	Country Where Leave Is Spent	nvarchar	3	CHAR	(N' ')	Yes	T005	URLND	Allow NULL?
127	PRT01	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
128	DPL01	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
129	ADR01	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
130	PRT02	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
131	DPL02	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
132	ADR02	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
133	PRT03	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
134	DPL03	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
135	ADR03	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
136	PRT04	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
137	DPL04	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
138	ADR04	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
139	PRT05	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
140	DPL05	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
141	ADR05	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
142	PRT06	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
143	DPL06	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
144	ADR06	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
145	PRT07	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
146	DPL07	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
147	ADR07	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
148	PRT08	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
149	DPL08	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
150	ADR08	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
151	PRT09	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
152	DPL09	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
153	ADR09	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
154	PRT10	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
155	DPL10	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
156	ADR10	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
157	PRT11	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
158	DPL11	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
159	ADR11	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
160	PRT12	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
161	DPL12	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
162	ADR12	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
163	PRT13	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
164	DPL13	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
165	ADR13	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
166	PRT14	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
167	DPL14	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
168	ADR14	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
169	PRT15	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
170	DPL15	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
171	ADR15	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
172	PRT16	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
173	DPL16	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
174	ADR16	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
175	PRT17	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
176	DPL17	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
177	ADR17	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
178	PRT18	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
179	DPL18	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
180	ADR18	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
181	PRT19	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
182	DPL19	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
183	ADR19	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?
184	PRT20	Indicator: Sickness Certificate Printed/Only Created	char	1	CHAR	(N' ')	Yes		KRPRT	Allow NULL?
185	DPL20	Indicator: Duplicate	char	1	CHAR	(N' ')	Yes		DPLKT	Allow NULL?
186	ADR20	Address Record Type	nvarchar	4	CHAR	(N' ')	Yes	*	ANSSA	Allow NULL?

TOP ERP 6.0 | PA0056 INDEXES

Name	Primary	Unique	Type	Columns
PA0056~0	Yes	Yes	CLUSTERED	SEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT
PA0056~MCH	No	No	NONCLUSTERED	MACOD, 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

186 COLUMNS | 2 INDEXES | ERP 6.0 | PA0056 TABLE

TOP ERP 6.0 | PA0056 COLUMNS

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

186 COLUMNS | 2 INDEXES | ERP 6.0 | PA0056 TABLE

TOPERP 6.0 | PA0056 COLUMNS

TOPERP 6.0 | PA0056 INDEXES

TOP ERP 6.0 | PA0056 COLUMNS

TOP ERP 6.0 | PA0056 INDEXES