	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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

266 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA05 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N2CA05	266	1	PMD: N8CA_SEC i.s.h.med Cardiology:	Clinical System

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DOKAR, DOKNR, DOKVR, DOKTL, GSDKPATKPF, ISHMPATNAM, ISHMPATNUM, ISHMPATGES, ISHMPATFAL, ISHMPATFAT, ISHMPATGEB, ISHMPATAPO, N8CAEXAROO, ISHMPATALT, N8CAPATALE, N8CAPATGEW, N8CAPATGRO, N8CAPATBMI, N8CAPATBSA, N8CAANFVMA, N8CAANFDAT, N8CAANFTIM, X00MKANAM, X00MFRGST, N8CASECIND, N8CAPATEIN, N8CATSTUD, N8CA_NYHA, N8CA_CCS, N8CAXSCHRI, N8CAXICD, N8CAXKEBE, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CA_RDSCH, N8CARBUBPS, N8CARBUBAP, N8CARBUBSC, N8CAEKDOKV, N8CAEKDOKD, N8CAEKDOKS, N8CAXIDIAG, N8CAXVDIAG, N8CAEXADAT, N8CAEXATIM, GSDKEXGP, ISHMVMAKRZ, ISHMVMARNG, N8CAEXANAM, ISHMVMAFAR, GSDKEXGP2, X00MVMAKRZ, X00MVMARNG, N8CAEXANA2, X00MVMAFAR, GSDKASGP, X01MVMAKRZ, X01MVMARNG, N8CAASNAM1, X01MVMAFAR, GSDKASGP2, X02MVMAKRZ, X02MVMARNG, N8CAASNAM2, X02MVMAFAR, N8CAEK_DEV, N8CA_APOSI, N8CAAWPULS, N8CAAW_SYS, N8CAAW_DIA, N8CAAWMHF, N8CA_BELTY, N8CAEBS_V, N8CAEBS_B, N8CAEBBELD, N8CADOB_V, N8CADOB_B, N8CADOBELD, N8CABELAV, N8CABELZME, N8CABELATR, N8CABELBBL, N8CABELESM, N8CAEWPULS, N8CAEW_SYS, N8CAEW_DIA, N8CAEW_AGR, N8CAUEPULS, N8CAUE_SYS, N8CAUE_DIA, N8CAUREDVI, N8CAURESVI, N8CAURRVDR, N8CAURAOIN, N8CAURAVAR, N8CAURAVGM, N8CAURMIIN, N8CAURTRIN, N8CAUREF, N8CAURWBS, N8CAUR4AS, N8CAUR4AL, N8CAUR4MS, N8CAUR4ML, N8CAUR4BS, N8CAUR4BL, N8CAUR2AI, N8CAUR2AA, N8CAUR2MI, N8CAUR2ML, N8CAUR2BI, N8CAUR2BL, N8CAURRAA, N8CAURRAI, N8CAURRMA, N8CAURRMP, N8CAURRBA, N8CAURRBP, N8CAURSMS, N8CAURSMT, N8CAURSMI, N8CAURSMA, N8CAURSMP, N8CAURSML, N8CAUBEDVI, N8CAUBESVI, N8CAUBRVDR, N8CAUBAOIN, N8CAUBAVAR, N8CAUBAVGM, N8CAUBMIIN, N8CAUBTRIN, N8CAUBEF, N8CAUBWBS, N8CAUB4AS, N8CAUB4AL, N8CAUB4MS, N8CAUB4ML, N8CAUB4BS, N8CAUB4BL, N8CAUB2AI, N8CAUB2AA, N8CAUB2MI, N8CAUB2ML, N8CAUB2BI, N8CAUB2BL, N8CAUBRAA, N8CAUBRAI, N8CAUBRMA, N8CAUBRMP, N8CAUBRBA, N8CAUBRBP, N8CAUBSMS, N8CAUBSMT, N8CAUBSMI, N8CAUBSMA, N8CAUBSMP, N8CAUBSML, N8CAUEEDVI, N8CAUEESVI, N8CAUERVDR, N8CAUEAOIN, N8CAUEAVAR, N8CAUEAVGM, N8CAUEMIIN, N8CAUETRIN, N8CAUEEF, N8CAUEWBS, N8CAUE4AS, N8CAUE4AL, N8CAUE4MS, N8CAUE4ML, N8CAUE4BS, N8CAUE4BL, N8CAUE2AI, N8CAUE2AA, N8CAUE2MI, N8CAUE2ML, N8CAUE2BI, N8CAUE2BL, N8CAUERAA, N8CAUERAI, N8CAUERMA, N8CAUERMP, N8CAUERBA, N8CAUERBP, N8CAUESMS, N8CAUESMT, N8CAUESMI, N8CAUESMA, N8CAUESMP, N8CAUESML, N8CABVSTU, N8CABVEDVI, N8CABVESVI, N8CABVRVDR, N8CABVAOIN, N8CABVAVAR, N8CABVAVGM, N8CABVMIIN, N8CABVTRIN, N8CABVEF, N8CABV4AS, N8CABV4AL, N8CABV4MS, N8CABV4ML, N8CABV4BS, N8CABV4BL, N8CABV2AI, N8CABV2AA, N8CABV2MI, N8CABV2ML, N8CABV2BI, N8CABV2BL, N8CABVRAA, N8CABVRAI, N8CABVRMA, N8CABVRMP, N8CABVRBA, N8CABVRBP, N8CABVSMS, N8CABVSMT, N8CABVSMI, N8CABVSMA, N8CABVSMP, N8CABVSML, N8CASECCR1, N8CASECCR2, N8CASECCR3, N8CASECCR4, N8CASECCR5, N8CASECCR6, N8CASECCR7, N8CASECCR8, N8CASECCR9, N8CARESTXT, N8CARESUME, X00KRESDAT, N8CARESDAT, X00KRESTIM, N8CARESTIM, GSDKRESGP, X03MVMAKRZ, X03MVMARNG, N8CARESNAM, X03MVMAFAR, GSDKRESGP2, X04MVMAKRZ, X04MVMARNG, N8CARESNM2, X04MVMAFAR, N8CARESXPR, N8CARESXFU, N8CAL_VB, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG FROM N2CA05

TOP ERP 6.0 | N2CA05 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	DOKAR	Document Type	nvarchar	3	0	CHAR	(N' ')	No	*	DOKAR	Allow NULL?
3	DOKNR	Document number	nvarchar	25	0	CHAR	(N' ')	No	*	DOKNR	Allow NULL?
4	DOKVR	Document Version	nvarchar	2	0	CHAR	(N' ')	No		DOKVR	Allow NULL?
5	DOKTL	Document Part	nvarchar	3	0	CHAR	(N' ')	No		DOKTL_D	Allow NULL?
6	GSDKPATKPF	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
7	ISHMPATNAM	IS-H: Patient Name	nvarchar	30	0	CHAR	(N' ')	Yes		RI_NAME	Allow NULL?
8	ISHMPATNUM	IS-H: Patient Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	PATNR	Allow NULL?
9	ISHMPATGES	IS-H: Sex Indicator - User-Specific	char	1	0	CHAR	(N' ')	Yes	*	GSCHLE	Allow NULL?
10	ISHMPATFAL	IS-H: Case Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	FALNR	Allow NULL?
11	ISHMPATFAT	IS-H: Text for Case Type	nvarchar	14	0	CHAR	(N' ')	Yes		TEXT_FAA	Allow NULL?
12	ISHMPATGEB	IS-H: Birthdate	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_GBDAT	Allow NULL?
13	ISHMPATAPO	IS-H: Nursing Organizational Unit Requesting the Service	nvarchar	8	0	CHAR	(N' ')	Yes	*	ANPOE	Allow NULL?
14	N8CAEXAROO	Cardiology: Examination Room	nvarchar	8	0	CHAR	(N' ')	Yes	*	N2_CAEXRO	Allow NULL?
15	ISHMPATALT	Patient Age	nvarchar	3	0	NUMC	(N'000')	Yes		N2_ALTERP	Allow NULL?
16	N8CAPATALE	Unit of Age	char	1	0	CHAR	(N' ')	Yes		N2_ALTEINH	Allow NULL?
17	N8CAPATGEW	Body Weight in Kg	nvarchar	3	0	NUMC	(N'000')	Yes		N1KGEW	Allow NULL?
18	N8CAPATGRO	Height in Cm	nvarchar	3	0	NUMC	(N'000')	Yes		N1KGR	Allow NULL?
19	N8CAPATBMI	Cardiology: Body Mass Index (xx,y) kg/m2	decimal	3	1	DEC	((0))	Yes		N2_CA_BMI
20	N8CAPATBSA	Cardiology: Body Surface Area (x,yy) m2	decimal	3	2	DEC	((0))	Yes		N2_CA_BSA
21	N8CAANFVMA	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
22	N8CAANFDAT	IS-H: Date when Record Created	nvarchar	8	0	DATS	(N'00000000')	Yes		RI_ERDAT	Allow NULL?
23	N8CAANFTIM	IS-H: Time Record Created	nvarchar	6	0	TIMS	(N'000000')	Yes		RI_ERTIM	Allow NULL?
24	X00MKANAM	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
25	X00MFRGST	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
26	N8CASECIND	Cardiology: Selection of Indication	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CAINDC	Allow NULL?
27	N8CAPATEIN	Cardiology: Consent Exists?	char	1	0	CHAR	(N' ')	Yes		N2_CAXEIN	Allow NULL?
28	N8CATSTUD	Cardiology: Study Participation	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CATSTUD	Allow NULL?
29	N8CA_NYHA	Cardiology: Fixed Values NYHA Classification	char	1	0	CHAR	(N' ')	Yes		N2_CANYHA	Allow NULL?
30	N8CA_CCS	Cardiology: Fixed Value CCS Status	char	1	0	CHAR	(N' ')	Yes		N2_CACCS	Allow NULL?
31	N8CAXSCHRI	Cardiology: Pacemaker Exists ?	char	1	0	CHAR	(N' ')	Yes		N2_CAXSCHR	Allow NULL?
32	N8CAXICD	Cardiology: ICD Present	char	1	0	CHAR	(N' ')	Yes		N2_CAXICD	Allow NULL?
33	N8CAXKEBE	Cardiology: Checkbox no Cardiovascular Risks Known	char	1	0	CHAR	(N' ')	Yes		N2_CAKEBE	Allow NULL?
34	N8CAXARTHY	Cardiology: Checkbox Art. Hypertension	char	1	0	CHAR	(N' ')	Yes		N2_CAARTHY	Allow NULL?
35	N8CAXNICO	Cardiology: Checkbox Nicotine	char	1	0	CHAR	(N' ')	Yes		N2_CANICO	Allow NULL?
36	N8CAXDIABM	Cardiology: Checkbox Diabetes Mellitus	char	1	0	CHAR	(N' ')	Yes		N2_CADIABM	Allow NULL?
37	N8CAXHYLIP	Cardiology: Checkbox Hyperlipidemia	char	1	0	CHAR	(N' ')	Yes		N2_CAHYLIP	Allow NULL?
38	N8CAXFAMA	Cardiology: Checkbox Family Anamnesis	char	1	0	CHAR	(N' ')	Yes		N2_CAFAMA	Allow NULL?
39	N8CACAVSON	Cardiology: Other Cardiovascular Risk Factors	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CACAVS	Allow NULL?
40	N8CA_RDSCH	Cardiology: Echo General Acoustics	char	1	0	CHAR	(N' ')	Yes		N2_CARDSCH	Allow NULL?
41	N8CARBUBPS	Cardiology: Fixed Values Good/Satisfactory/Poor	char	1	0	CHAR	(N' ')	Yes		N2_CA_GZS	Allow NULL?
42	N8CARBUBAP	Cardiology: Fixed Values Good/Satisfactory/Poor	char	1	0	CHAR	(N' ')	Yes		N2_CA_GZS	Allow NULL?
43	N8CARBUBSC	Cardiology: Fixed Values Good/Satisfactory/Poor	char	1	0	CHAR	(N' ')	Yes		N2_CA_GZS	Allow NULL?
44	N8CAEKDOKV	Cardiology: Documentation on Video	char	1	0	CHAR	(N' ')	Yes		N2_CADOKV	Allow NULL?
45	N8CAEKDOKD	Cardiology: Documentation Digital on Data Carrier	char	1	0	CHAR	(N' ')	Yes		N2_CADOKD	Allow NULL?
46	N8CAEKDOKS	Cardiology: Documentation Digital on Server	char	1	0	CHAR	(N' ')	Yes		N2_CADOKS	Allow NULL?
47	N8CAXIDIAG	Cardiology: Checkbox Ischemia Diagnostics	char	1	0	CHAR	(N' ')	Yes		N2_CAXIDIAG	Allow NULL?
48	N8CAXVDIAG	Cardiology: Checkbox Valve Diagnostics	char	1	0	CHAR	(N' ')	Yes		N2_CAXVDIAG	Allow NULL?
49	N8CAEXADAT	Cardiology: Date of Examination	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_CAEXDT	Allow NULL?
50	N8CAEXATIM	Cardiology: Time of Examination	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CAEXTM	Allow NULL?
51	GSDKEXGP	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
52	ISHMVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
53	ISHMVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
54	N8CAEXANAM	Cardiology: Name of Examiner	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAEXNM	Allow NULL?
55	ISHMVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
56	GSDKEXGP2	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
57	X00MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
58	X00MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
59	N8CAEXANA2	Cardiology: Name of Examiner	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAEXNM	Allow NULL?
60	X00MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
61	GSDKASGP	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
62	X01MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
63	X01MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
64	N8CAASNAM1	Cardiology: Name of Assistant	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAASNM	Allow NULL?
65	X01MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
66	GSDKASGP2	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
67	X02MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
68	X02MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
69	N8CAASNAM2	Cardiology: Name of Assistant	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CAASNM	Allow NULL?
70	X02MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
71	N8CAEK_DEV	Cardiology: Echocardiography Device	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CA_EKD	Allow NULL?
72	N8CA_APOSI	Cardiology: Fixed Value Echo Resting Value Position	char	1	0	CHAR	(N' ')	Yes		N2_CAAPOSI	Allow NULL?
73	N8CAAWPULS	Cardiology: Resting Value Heart Rate / Min.	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAAWPULS	Allow NULL?
74	N8CAAW_SYS	Cardiology: Resting Value Systolic Blood Pressure (mmHg)	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAAWSY	Allow NULL?
75	N8CAAW_DIA	Cardiology: Resting Value Diastolic Blood Pressure (mmHg)	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAAWDI	Allow NULL?
76	N8CAAWMHF	Cardiology: Stress Echo Target Heart Rate	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAAWMHF	Allow NULL?
77	N8CA_BELTY	Cardiology: Fixed Value Echo Stress Type	char	1	0	CHAR	(N' ')	Yes		N2_CABELTY	Allow NULL?
78	N8CAEBS_V	Cardiology: Ergometry Stress Level From	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAEBS_V	Allow NULL?
79	N8CAEBS_B	Cardiology: Ergometry Stress Level To	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAEBS_B	Allow NULL?
80	N8CAEBBELD	Cardiology: Minutes Ergometry Stress	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAEBSD	Allow NULL?
81	N8CADOB_V	Cardiology: Dobutamine Dose From	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CADOB	Allow NULL?
82	N8CADOB_B	Cardiology: Dobutamine Dose To	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CADOB_B	Allow NULL?
83	N8CADOBELD	Cardiology: Dobutamine Stress Duration (min)	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CADOBELD	Allow NULL?
84	N8CABELAV	Cardiology: Combo Box Description Stress Method	nvarchar	80	0	CHAR	(N' ')	Yes		N2_CABELAV	Allow NULL?
85	N8CABELZME	Cardiology: Combo Box Stress Additional Medication	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CABELZME	Allow NULL?
86	N8CABELATR	Cardiology: Stress Atropine (mg)	decimal	3	2	DEC	((0))	Yes		N2_CABELATR
87	N8CABELBBL	Cardiology: Select Betablocker During/After Stress Echo	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CABELBBL	Allow NULL?
88	N8CABELESM	Cardiology: Stress Esmolol (mg)	decimal	4	1	DEC	((0))	Yes		N2_CABELESM
89	N8CAEWPULS	Cardiology: Heart Rate / Min. at Max. Stress	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAEWPULS	Allow NULL?
90	N8CAEW_SYS	Cardiology: Systolic Blood Pressure (mmHg) at Max. Stress	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAEWSY	Allow NULL?
91	N8CAEW_DIA	Cardiology: Diastol. Blood Pressure (mmHg) at Max. Stress	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAEWDI	Allow NULL?
92	N8CAEW_AGR	Cardiology: Combo Box Cancellation Reason with Max. Stress	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CAEWAGR	Allow NULL?
93	N8CAUEPULS	Cardiology: Heart Rate / Min. After Recovery	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAUEPULS	Allow NULL?
94	N8CAUE_SYS	Cardiology: Systolic Blood Pressure (mmHg) After Recovery	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAUESY	Allow NULL?
95	N8CAUE_DIA	Cardiology: Diastolic Blood Pressure (mmHg) on Recovery	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAUEDI	Allow NULL?
96	N8CAUREDVI	Cardiology: Index Conc. BSA to LV-EDV Resting (ml/m2)	decimal	4	1	DEC	((0))	Yes		N2_CAUREDVI
97	N8CAURESVI	Cardiology: Index Conc. BSA to LV-ESV Resting (ml/m2)	decimal	4	1	DEC	((0))	Yes		N2_CAURESVI
98	N8CAURRVDR	Cardiology: Pressure in Right Ventricle Resting (mmHg)	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAURRVDR	Allow NULL?
99	N8CAURAOIN	Cardiology: Aortic Insufficiency Degree Resting	char	1	0	CHAR	(N' ')	Yes		N2_CAURAOIN	Allow NULL?
100	N8CAURAVAR	Cardiology: Aortic Valve Area (cm2) Resting	decimal	3	2	DEC	((0))	Yes		N2_CAURVAAR
101	N8CAURAVGM	Cardiology: Aortic Valve Max. Gradient (mmHg) Resting	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAURAVGM	Allow NULL?
102	N8CAURMIIN	Cardiology: Mitral Insufficiency Degree Resting	char	1	0	CHAR	(N' ')	Yes		N2_CAURMIIN	Allow NULL?
103	N8CAURTRIN	Cardiology: Tricuspid Insufficiency Degree Resting	char	1	0	CHAR	(N' ')	Yes		N2_CAURTRIN	Allow NULL?
104	N8CAUREF	Cardiology: Ejection Fraction (%) Resting	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAUREF	Allow NULL?
105	N8CAURWBS	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
106	N8CAUR4AS	Cardiology: Wall Motion Abnorm. Resting 4CV Apical Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUR4AS	Allow NULL?
107	N8CAUR4AL	Cardiology: Wall Motion Abnorm. Resting 4CV Apical Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUR4AL	Allow NULL?
108	N8CAUR4MS	Cardiology: Wall Motion Abnorm. Resting 4CV Medial Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUR4MS	Allow NULL?
109	N8CAUR4ML	Cardiology: Wall Motion Abnorm. Resting 4CV Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUR4ML	Allow NULL?
110	N8CAUR4BS	Cardiology: Wall Motion Abnorm. Resting 4CV Basal Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUR4BS	Allow NULL?
111	N8CAUR4BL	Cardiology: Wall Motion Abnorm. Resting 4CV Basal Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUR4BL	Allow NULL?
112	N8CAUR2AI	Cardiology: Wall Motion Abn. Resting 2CV Apical Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUR2AI	Allow NULL?
113	N8CAUR2AA	Cardiology: Wall Motion Abn. Resting 2CV Apical Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUR2AA	Allow NULL?
114	N8CAUR2MI	Cardiology: Wall Motion Abn. Resting 2CV Medial Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUR2MI	Allow NULL?
115	N8CAUR2ML	Cardiology: Wall Motion Abn. Resting 2CV Medial Anterior (7)	char	1	0	CHAR	(N' ')	Yes		N2_CAUR2ML	Allow NULL?
116	N8CAUR2BI	Cardiology: Wall Motion Abn. Resting 2CV Basal Inferior (4)	char	1	0	CHAR	(N' ')	Yes		N2_CAUR2BI	Allow NULL?
117	N8CAUR2BL	Cardiology: Wall Motion Abn. Resting 2CV Basal Anterior (1)	char	1	0	CHAR	(N' ')	Yes		N2_CAUR2BL	Allow NULL?
118	N8CAURRAA	Cardiology: Wall Motion Abn. Rest. RAO Apical Anterior (13)	char	1	0	CHAR	(N' ')	Yes		N2_CAURRAA	Allow NULL?
119	N8CAURRAI	Cardiology: Wall Motion Abn. Resting RAO Apical Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAURRAI	Allow NULL?
120	N8CAURRMA	Cardiology: Wall Motion Abn. Rest. RAO Medial Ant.Septal(8)	char	1	0	CHAR	(N' ')	Yes		N2_CAURRMA	Allow NULL?
121	N8CAURRMP	Cardiology: Wall Motion Abn. Resting RAO Medial Post. (11)	char	1	0	CHAR	(N' ')	Yes		N2_CAURRMP	Allow NULL?
122	N8CAURRBA	Cardiology: Wall Motion Abn. Resting RAO Basal Ant.Sept. (2)	char	1	0	CHAR	(N' ')	Yes		N2_CAURRBA	Allow NULL?
123	N8CAURRBP	Cardiology: Wall Motion Abn. Resting RAO Basal Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CAURRBP	Allow NULL?
124	N8CAURSMS	Cardiology: WMA Resting SAX Medial (Infero) Septal (9)	char	1	0	CHAR	(N' ')	Yes		N2_CAURSMS	Allow NULL?
125	N8CAURSMT	Cardiology: WMA Resting SAX Medial Ant. Septal (8)	char	1	0	CHAR	(N' ')	Yes		N2_CAURSMT	Allow NULL?
126	N8CAURSMI	Cardiology: WMA Resting SAX Medial Inferior (10)	char	1	0	CHAR	(N' ')	Yes		N2_CAURSMI	Allow NULL?
127	N8CAURSMA	Cardiology: WMA Resting SAX Medial Anterior (7)	char	1	0	CHAR	(N' ')	Yes		N2_CAURSMA	Allow NULL?
128	N8CAURSMP	Cardiology: WMA Resting SAX Medial Posterior (11-Inf.Lat.)	char	1	0	CHAR	(N' ')	Yes		N2_CAURSMP	Allow NULL?
129	N8CAURSML	Cardiology: WMA Resting SAX Medial Lateral (12- Ant.Lat.)	char	1	0	CHAR	(N' ')	Yes		N2_CAURSML	Allow NULL?
130	N8CAUBEDVI	Cardiology: Index Conc. BSA to LV-EDV Under Stress (ml/m2)	decimal	4	1	DEC	((0))	Yes		N2_CAUBEDVI
131	N8CAUBESVI	Cardiology: Index Conc. BSA to LV-ESV Under Stress (ml/m2)	decimal	4	1	DEC	((0))	Yes		N2_CAUBESVI
132	N8CAUBRVDR	Cardiology: Pressure in Right Ventricle Under Stress (mmHg)	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAUBRVDR	Allow NULL?
133	N8CAUBAOIN	Cardiology: Aortic Insufficency Degree Under Stress	char	1	0	CHAR	(N' ')	Yes		N2_CAUBAOIN	Allow NULL?
134	N8CAUBAVAR	Cardiology: Aortic Valve Area (cm2) Under Stress	decimal	3	2	DEC	((0))	Yes		N2_CAUBVAAR
135	N8CAUBAVGM	Cardiology: Aortic Valve Max. Gradient (mmHg) Stress	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAUBAVGM	Allow NULL?
136	N8CAUBMIIN	Cardiology: Mitral Insufficiency Degree Under Stress	char	1	0	CHAR	(N' ')	Yes		N2_CAUBMIIN	Allow NULL?
137	N8CAUBTRIN	Cardiology: Tricuspid Insufficiency Degree Under Stress	char	1	0	CHAR	(N' ')	Yes		N2_CAUBTRIN	Allow NULL?
138	N8CAUBEF	Cardiology: Ejection Fraction (%) Under Stress	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAUBEF	Allow NULL?
139	N8CAUBWBS	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
140	N8CAUB4AS	Cardiology: Wall Motion Abnorm. Stress 4CV Apical Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUB4AS	Allow NULL?
141	N8CAUB4AL	Cardiology: Wall Motion Abnorm. Stress 4CV Apical Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUB4AL	Allow NULL?
142	N8CAUB4MS	Cardiology: Wall Motion Abnorm. Stress 4CV Medial Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUB4MS	Allow NULL?
143	N8CAUB4ML	Cardiology: Wall Motion Abnorm. Stress 4CV Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUB4ML	Allow NULL?
144	N8CAUB4BS	Cardiology: Wall Motion Abnorm. Stress 4CV Basal Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUB4BS	Allow NULL?
145	N8CAUB4BL	Cardiology: Wall Motion Abnorm. Stress 4CV Basal Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUB4BL	Allow NULL?
146	N8CAUB2AI	Cardiology: Wall Motion Abnorm. Stress 2CV Apical Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUB2AI	Allow NULL?
147	N8CAUB2AA	Cardiology: Wall Motion Abnorm. Stress 2CV Apical Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUB2AA	Allow NULL?
148	N8CAUB2MI	Cardiology: Wall Motion Abnorm. Stress 2CV Medial Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUB2MI	Allow NULL?
149	N8CAUB2ML	Cardiology: Wall Motion Abnorm. Stress 2CV Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUB2ML	Allow NULL?
150	N8CAUB2BI	Cardiology: Wall Motion Abnorm. Stress 2CV Basal Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUB2BI	Allow NULL?
151	N8CAUB2BL	Cardiology: Wall Motion Abnorm. Stress 2CV Basal Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUB2BL	Allow NULL?
152	N8CAUBRAA	Cardiology: Wall Motion Abnorm. Stress RAO Apical Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUBRAA	Allow NULL?
153	N8CAUBRAI	Cardiology: Wall Motion Abnorm. Stress RAO Apical Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUBRAI	Allow NULL?
154	N8CAUBRMA	Cardiology: Wall Motion Abnorm. Stress RAO Medial Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUBRMA	Allow NULL?
155	N8CAUBRMP	Cardiology: Wall Motion Abnorm. Stress RAO Medial Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUBRMP	Allow NULL?
156	N8CAUBRBA	Cardiology: Wall Motion Abnorm. Stress RAO Basal Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUBRBA	Allow NULL?
157	N8CAUBRBP	Cardiology: Wall Motion Abnorm. Stress RAO Basal Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUBRBP	Allow NULL?
158	N8CAUBSMS	Cardiology: Wall Motion Abnorm. Stress SAX Medial Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUBSMS	Allow NULL?
159	N8CAUBSMT	Cardio: Wall Motion Abnorm. Stress SAX Mmedial Ant. Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUBSMT	Allow NULL?
160	N8CAUBSMI	Cardiology: Wall Motion Abnorm. Stress SAX Medial Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUBSMI	Allow NULL?
161	N8CAUBSMA	Cardiology: Wall Motion Abnorm. Stress SAX Medial Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUBSMA	Allow NULL?
162	N8CAUBSMP	Cardiology: Wall Motion Abnorm. Stress SAX Medial Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUBSMP	Allow NULL?
163	N8CAUBSML	Cardiology: Wall Motion Abnorm. Stress SAX Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUBSML	Allow NULL?
164	N8CAUEEDVI	Cardiology: Index Concerning BSA to LV-EDV Recovery (ml/m2)	decimal	4	1	DEC	((0))	Yes		N2_CAUEEDVI
165	N8CAUEESVI	Cardiology: Index Concerning BSA to LV-ESV Recovery (ml/m2)	decimal	4	1	DEC	((0))	Yes		N2_CAUEESVI
166	N8CAUERVDR	Cardiology: Pressure in Right Ventricle After Recovery(mmHg)	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAUERVDR	Allow NULL?
167	N8CAUEAOIN	Cardiology: Aortic Insufficiency Degree After Recovery	char	1	0	CHAR	(N' ')	Yes		N2_CAUEAOIN	Allow NULL?
168	N8CAUEAVAR	Cardiology: Aortic Valve Area (cm2) After Recovery	decimal	3	2	DEC	((0))	Yes		N2_CAUEVAAR
169	N8CAUEAVGM	Cardiology: Aortic Valve Max. Gradient (mmHg) Recovery	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CAUEAVGM	Allow NULL?
170	N8CAUEMIIN	Cardiology: Mitral Insufficiency Degree After Recovery	char	1	0	CHAR	(N' ')	Yes		N2_CAUEMIIN	Allow NULL?
171	N8CAUETRIN	Cardiology: Tricuspid Insufficiency Degree After Recovery	char	1	0	CHAR	(N' ')	Yes		N2_CAUETRIN	Allow NULL?
172	N8CAUEEF	Cardiology: Ejection Fraction (%) After Recovery	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CAUEEF	Allow NULL?
173	N8CAUEWBS	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
174	N8CAUE4AS	Cardiology: Wall Motion Abnorm. Recovery 4CV Apical Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUE4AS	Allow NULL?
175	N8CAUE4AL	Cardiology: Wall Motion Abnorm. Recovery 4CV Apical Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUE4AL	Allow NULL?
176	N8CAUE4MS	Cardiology: Wall Motion Abnorm. Recovery 4CV Medial Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUE4MS	Allow NULL?
177	N8CAUE4ML	Cardiology: Wall Motion Abnorm. Recovery 4CV Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUE4ML	Allow NULL?
178	N8CAUE4BS	Cardiology: Wall Motion Abnorm. Recovery 4CV Basal Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUE4BS	Allow NULL?
179	N8CAUE4BL	Cardiology: Wall Motion Abnorm. Recovery 4CV Basal Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUE4BL	Allow NULL?
180	N8CAUE2AI	Cardiology: Wall Motion Abnorm. Recovery 2CV Apical Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUE2AI	Allow NULL?
181	N8CAUE2AA	Cardiology: Wall Motion Abnorm. Recov. 2CV Apical Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUE2AA	Allow NULL?
182	N8CAUE2MI	Cardiology: Wall Motion Abnorm. Recovery 2CV Medial Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUE2MI	Allow NULL?
183	N8CAUE2ML	Cardio: Wall Motion Abnorm. aft. Recovery 2CV Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUE2ML	Allow NULL?
184	N8CAUE2BI	Cardiology: Wall Motion Abnorm. Recovery 2CV Basal Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUE2BI	Allow NULL?
185	N8CAUE2BL	Cardiology: Wall Motion Abnorm. Recovery 2CV Basal Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUE2BL	Allow NULL?
186	N8CAUERAA	Cardiology: Wall Motion Abnorm. Recovery RAO Apical Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUERAA	Allow NULL?
187	N8CAUERAI	Cardiology: Wall Motion Abnorm. Recovery RAO Apical Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUERAI	Allow NULL?
188	N8CAUERMA	Cardiology: Wall Motion Abnorm. Recovery RAO Medial Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUERMA	Allow NULL?
189	N8CAUERMP	Cardiology: Wall Motion Abnorm. Recov. RAO Medial Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUERMP	Allow NULL?
190	N8CAUERBA	Cardiology: Wall Motion Abnorm. Recovery RAO Basal Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUERBA	Allow NULL?
191	N8CAUERBP	Cardiology: Wall Motion Abnorm. Recovery RAO Basal Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUERBP	Allow NULL?
192	N8CAUESMS	Cardiology: Wall Motion Abnorm. aft.Recov. SAX Medial Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUESMS	Allow NULL?
193	N8CAUESMT	Cardio: Wall Motion Abnorm. Recov. SAX Medial Ant. Septal	char	1	0	CHAR	(N' ')	Yes		N2_CAUESMT	Allow NULL?
194	N8CAUESMI	Cardiology: Wall Motion Abnorm. Recovery SAX Medial Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CAUESMI	Allow NULL?
195	N8CAUESMA	Cardiology: Wall Motion Abnorm. Recovery SAX Medial Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUESMA	Allow NULL?
196	N8CAUESMP	Cardiology: Wall Motion Abnorm. Recov. SAX Medial Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CAUESMP	Allow NULL?
197	N8CAUESML	Cardiology: Wall Motion Abnorm. Recov. SAX Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CAUESML	Allow NULL?
198	N8CABVSTU	Cardiology: Combo. Hemodynamic/WMA Biphas. Course Level	nvarchar	60	0	CHAR	(N' ')	Yes		N2_CABVSTU	Allow NULL?
199	N8CABVEDVI	Cardiology: Index Conc. BSA to LV-EDV Biph. Crse (ml/m2)	decimal	4	1	DEC	((0))	Yes		N2_CABVEDVI
200	N8CABVESVI	Cardiology: Index Conc. BSA to LV-ESV Biph. Crse (ml/m2)	decimal	4	1	DEC	((0))	Yes		N2_CABVESVI
201	N8CABVRVDR	Cardiology: Pressure in Right Ventricle Biph. Crse (mmHg)	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CABVRVDR	Allow NULL?
202	N8CABVAOIN	Cardiology: Aortic Insufficiency Degree Biphasic Progress	char	1	0	CHAR	(N' ')	Yes		N2_CABVAOIN	Allow NULL?
203	N8CABVAVAR	Cardiology: Aortic Valve Area (cm2) Biphasic Progress	decimal	3	2	DEC	((0))	Yes		N2_CABVVAAR
204	N8CABVAVGM	Cardiology: Aortic Valve Max. Gradient (mmHg) Biphasic Prog.	nvarchar	3	0	NUMC	(N'000')	Yes		N2_CABVAVGM	Allow NULL?
205	N8CABVMIIN	Cardiology: Mitral Insufficiency Degree Biph. Crse	char	1	0	CHAR	(N' ')	Yes		N2_CABVMIIN	Allow NULL?
206	N8CABVTRIN	Cardiology: Tricuspid Insufficiency Degree Biphasic Course	char	1	0	CHAR	(N' ')	Yes		N2_CABVTRIN	Allow NULL?
207	N8CABVEF	Cardiology: Ejection Fraction (%) Biph. Course	nvarchar	2	0	NUMC	(N'00')	Yes		N2_CABVEF	Allow NULL?
208	N8CABV4AS	Cardiology: Wall Motion Abn. Biph. Crse 4CV Apical Septal	char	1	0	CHAR	(N' ')	Yes		N2_CABV4AS	Allow NULL?
209	N8CABV4AL	Cardiology: Wall Motion Abn. Biph. Crse 4CV Apical Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CABV4AL	Allow NULL?
210	N8CABV4MS	Cardiology: Wall Motion Abnorm. Biph. Crse 4CV Medial Septal	char	1	0	CHAR	(N' ')	Yes		N2_CABV4MS	Allow NULL?
211	N8CABV4ML	Cardiology: Wall Motion Abn. Biph. Crse 4CV Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CABV4ML	Allow NULL?
212	N8CABV4BS	Cardiology: Wall Motion Abn. Biph. Crse 4CV Basal Septal	char	1	0	CHAR	(N' ')	Yes		N2_CABV4BS	Allow NULL?
213	N8CABV4BL	Cardiology: Wall Motion Abn. Biph. Crse 4CV Basal Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CABV4BL	Allow NULL?
214	N8CABV2AI	Cardiology: Wall Motion Abn. Biph. Crse 2CV Apical Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CABV2AI	Allow NULL?
215	N8CABV2AA	Cardiology: Wall Motion Abn. Biph Crse 2CV Apical Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CABV2AA	Allow NULL?
216	N8CABV2MI	Cardiology: Wall Motion Abn. Biph. Crse 2CV Medial Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CABV2MI	Allow NULL?
217	N8CABV2ML	Cardiology: Wall Motion Abn. Biph. Crse 2CV Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CABV2ML	Allow NULL?
218	N8CABV2BI	Cardiology: Wall Motion Abn. Biph. Crse 2CV Basal Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CABV2BI	Allow NULL?
219	N8CABV2BL	Cardiology: Wall Motion Abn. Biph. Crse 2CV Basal Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CABV2BL	Allow NULL?
220	N8CABVRAA	Cardiology: Wall Motion Abn. Biph. Crse RAO Apical Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CABVRAA	Allow NULL?
221	N8CABVRAI	Cardiology: Wall Motion Abn. Biph. Crse RAO Apical Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CABVRAI	Allow NULL?
222	N8CABVRMA	Cardiology: Wall Motion Abn. Biph. Crse RAO Medial Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CABVRMA	Allow NULL?
223	N8CABVRMP	Cardiology: Wall Motion Abn. Biph. Crse RAO Medial Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CABVRMP	Allow NULL?
224	N8CABVRBA	Cardiology: Wall Motion Abn. Biph. Crse RAO Basal Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CABVRBA	Allow NULL?
225	N8CABVRBP	Cardiology: Wall Motion Abn. Biph. Crse RAO Basal Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CABVRBP	Allow NULL?
226	N8CABVSMS	Cardiology: Wall Motion Abn. Biph. Crse SAX Medial Septal	char	1	0	CHAR	(N' ')	Yes		N2_CABVSMS	Allow NULL?
227	N8CABVSMT	Cardiology: Wall Motion Abn. Biph. Crse SAX Medial Ant. Sept	char	1	0	CHAR	(N' ')	Yes		N2_CABVSMT	Allow NULL?
228	N8CABVSMI	Cardiology: Wall Motion Abn. Biph. Crse SAX Medial Inferior	char	1	0	CHAR	(N' ')	Yes		N2_CABVSMI	Allow NULL?
229	N8CABVSMA	Cardiology: Wall Motion Abn. Biph. Crse SAX Medial Anterior	char	1	0	CHAR	(N' ')	Yes		N2_CABVSMA	Allow NULL?
230	N8CABVSMP	Cardiology: Wall Motion Abn. Biph. Crse SAX Medial Posterior	char	1	0	CHAR	(N' ')	Yes		N2_CABVSMP	Allow NULL?
231	N8CABVSML	Cardiology: Wall Motion Abn. Biph. Crse SAX Medial Lateral	char	1	0	CHAR	(N' ')	Yes		N2_CABVSML	Allow NULL?
232	N8CASECCR1	Cardiology: Criterion 1 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR1	Allow NULL?
233	N8CASECCR2	Cardiology: Criterion 2 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR2	Allow NULL?
234	N8CASECCR3	Cardiology: Criterion 3 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR3	Allow NULL?
235	N8CASECCR4	Cardiology: Criterion 4 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR4	Allow NULL?
236	N8CASECCR5	Cardiology: Criterion 5 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR5	Allow NULL?
237	N8CASECCR6	Cardiology: Criterion 6 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR6	Allow NULL?
238	N8CASECCR7	Cardiology: Criterion 7 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR7	Allow NULL?
239	N8CASECCR8	Cardiology: Criterion 8 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR8	Allow NULL?
240	N8CASECCR9	Cardiology: Criterion 9 Assessment Code	nvarchar	15	0	CHAR	(N' ')	Yes		N2_CAKBCR9	Allow NULL?
241	N8CARESTXT	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
242	N8CARESUME	PMD: Reference by GUUID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_REFUUID	Allow NULL?
243	X00KRESDAT	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
244	N8CARESDAT	Cardiology: Date of Findings	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_CARSDT	Allow NULL?
245	X00KRESTIM	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
246	N8CARESTIM	Cardiology: Time of Findings Creation	nvarchar	6	0	TIMS	(N'000000')	Yes		N2_CARSTM	Allow NULL?
247	GSDKRESGP	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
248	X03MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
249	X03MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
250	N8CARESNAM	Cardiology: Name of Findings Creator	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CARSNM	Allow NULL?
251	X03MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
252	GSDKRESGP2	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
253	X04MVMAKRZ	Employee Responsible	nvarchar	10	0	CHAR	(N' ')	Yes	*	N1MITARB	Allow NULL?
254	X04MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	CHAR	(N' ')	Yes		ISH_RANKTX	Allow NULL?
255	N8CARESNM2	Cardiology: Name of Supervisor	nvarchar	40	0	CHAR	(N' ')	Yes		N2_CASVNM	Allow NULL?
256	X04MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	CHAR	(N' ')	Yes		TEXT_KFA	Allow NULL?
257	N8CARESXPR	Cardiology: Checkbox Prophylaxis Recommended	char	1	0	CHAR	(N' ')	Yes		N2_CARESXPR	Allow NULL?
258	N8CARESXFU	Cardiology: Checkbox Progress Check-Up Recommended	char	1	0	CHAR	(N' ')	Yes		N2_CARESXFU	Allow NULL?
259	N8CAL_VB	Reference Key of a Referenced Object	nvarchar	20	0	CHAR	(N' ')	Yes		N2_REFKEY	Allow NULL?
260	N8CA_XDAT	Cardiology: Checkbox Data Was Imported	char	1	0	CHAR	(N' ')	Yes		N2_CAXDAT	Allow NULL?
261	N8CA_EINRI	Institution	nvarchar	4	0	CHAR	(N' ')	Yes	*	EINRI	Allow NULL?
262	N8CA_SDEST	Symbolic Destination	nvarchar	8	0	CHAR	(N' ')	Yes		N2_DSSDEST	Allow NULL?
263	N8CA_STUDA	Examination Date	nvarchar	8	0	DATS	(N'00000000')	Yes		N2_DSSTDATE	Allow NULL?
264	N8CA_PATNR	IS-H: Patient Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	PATNR	Allow NULL?
265	N8CA_UID	Character UID	nvarchar	32	0	CHAR	(N' ')	Yes		N2_CUID	Allow NULL?
266	N8CA_DFLAG	Data Flag Import OK	char	1	0	CHAR	(N' ')	Yes		N2_DSIMPOK	Allow NULL?

TOP ERP 6.0 | N2CA05 INDEXES

Name	Primary	Unique	Type	Columns
N2CA05~0	Yes	Yes	CLUSTERED	DOKTL, DOKVR, DOKNR, DOKAR, 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

266 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA05 TABLE

TOP ERP 6.0 | N2CA05 COLUMNS

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

266 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA05 TABLE

TOPERP 6.0 | N2CA05 COLUMNS

TOPERP 6.0 | N2CA05 INDEXES

TOP ERP 6.0 | N2CA05 COLUMNS

TOP ERP 6.0 | N2CA05 INDEXES