	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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	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

389 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA12 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N2CA12	389	1	PMD: N8CA_DTO 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, ISHMPATALT, N8CAPATALE, N8CAPATGEW, N8CAPATGRO, N8CAPATBMI, N8CAPATBSA, N8CAANFVMA, N8CAANFDAT, N8CAANFTIM, N8CAEXAROO, X00MKANAM, X00MFRGST, N8CADTOIND, N8CATSTUD, N8CAXKEBE, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CA_DOKP, N8CA_DOKV, N8CA_DOKD, N8CA_DOKS, N8CA_AQ, N8CAKM_GD, N8CAKM_DCE, N8CAEXADAT, N8CAEXATIM, N8CADC_DEV, GSDKEXGP, ISHMVMAKRZ, ISHMVMARNG, N8CAEXANAM, ISHMVMAFAR, GSDKEXGP2, X00MVMAKRZ, X00MVMARNG, N8CAEXANA2, X00MVMAFAR, GSDKASGP, X01MVMAKRZ, X01MVMARNG, N8CAASNAM1, X01MVMAFAR, GSDKASGP2, X02MVMAKRZ, X02MVMARNG, N8CAASNAM2, X02MVMAFAR, N8CAAGUS, N8CAAGUB, N8CAAGSRGW, N8CAAGSRWE, N8CAAGSRSI, N8CAAGSRVM, N8CAAGSRDA, N8CAAGSRDQ, N8CAAGIRGW, N8CAAGIRWE, N8CAAGIRSI, N8CAAGIRVM, N8CAAGIRDA, N8CAAGIRDQ, N8CAAGPRGW, N8CAAGPRWE, N8CAAGPRSI, N8CAAGPRVM, N8CAAGPRDA, N8CAAGPRDQ, N8CAAGAE, N8CAAGNS, N8CAAGCAGW, N8CAAGCASI, N8CAAGCAVM, N8CAAGCARI, N8CAAGCAPV, N8CAAGCDGW, N8CAAGCDSI, N8CAAGCDVM, N8CAAGCDRI, N8CAAGCDPV, N8CAAGSAGW, N8CAAGSASI, N8CAAGSAVM, N8CAAGSARI, N8CAAGSAPV, N8CAAGSDGW, N8CAAGSDSI, N8CAAGSDVM, N8CAAGSDRI, N8CAAGSDPV, N8CAAGIAGW, N8CAAGIASI, N8CAAGIAVM, N8CAAGIARI, N8CAAGIAPV, N8CAAGIDGW, N8CAAGIDSI, N8CAAGIDVM, N8CAAGIDRI, N8CAAGIDPV, N8CAAGAMA, N8CAAGAMQ, N8CAAGALA, N8CAAGLDA, N8CAAGLDQ, N8CAAGLLA, N8CAAGTMO, N8CAAGTMD, N8CAAGTFO, N8CAAGTLA, N8CAAGUA, N8CAAGAM, N8CAAGWT, N8CAAGKT, N8CALMUS, N8CALMUB, N8CALMNS, N8CALMPHDM, N8CALMPHLU, N8CALMPHVM, N8CALMPRDM, N8CALMPRLU, N8CALMPRVM, N8CALMPLDM, N8CALMPLLU, N8CALMPLVM, N8CALMHPVM, N8CALMHPRI, N8CALMHCVM, N8CALMHCRI, N8CALMHMDM, N8CALMHMLU, N8CALMHMSI, N8CALMHSDM, N8CALMHSLU, N8CALMHSSI, N8CALMHDDM, N8CALMHDLU, N8CALMHDSI, N8CALMCILU, N8CALMAS, N8CALMLG, N8CALMPS, N8CALMOK, N8CALAUS, N8CALAUB, N8CALMKKAM, N8CALMKKRM, N8CALMKKDM, N8CALMKKVM, N8CALMKKFM, N8CALMKKAR, N8CALMKKRR, N8CALMKKDR, N8CALMKKVR, N8CALMKKFR, N8CALMKKAB, N8CALMKKRB, N8CALMKKDB, N8CALMKKVB, N8CALMKKFB, N8CALMVLDM, N8CALMVLVM, N8CALMALGW, N8CALMALSI, N8CALMALVM, N8CALMALRI, N8CALMALPV, N8CALMCOLU, N8CALMMSLU, N8CALMMSFR, N8CALMMSVM, N8CALMMG, N8CALMMF, N8CANAUS, N8CANAUB, N8CANAFSVS, N8CANARARV, N8CANARARR, N8CANARARW, N8CANARARI, N8CANARARS, N8CANARARG, N8CANARALV, N8CANARALR, N8CANARALW, N8CANARALI, N8CANARALS, N8CANARALG, N8CANARMRV, N8CANARMRR, N8CANARMRW, N8CANARMRS, N8CANARMRG, N8CANARMLV, N8CANARMLR, N8CANARMLW, N8CANARMLS, N8CANARMLG, N8CANARHRV, N8CANARHRR, N8CANARHRI, N8CANARHRS, N8CANARHRG, N8CANARHLV, N8CANARHLR, N8CANARHLI, N8CANARHLS, N8CANARHLG, N8CANAOPRV, N8CANAOPRD, N8CANAOPRI, N8CANAOPRS, N8CANAOPRG, N8CANAOPLV, N8CANAOPLD, N8CANAOPLI, N8CANAOPLS, N8CANAOPLG, N8CANASMRV, N8CANASMRD, N8CANASMRI, N8CANASMRS, N8CANASMRG, N8CANASMLV, N8CANASMLD, N8CANASMLI, N8CANASMLS, N8CANASMLG, N8CANAUPRV, N8CANAUPRD, N8CANAUPRI, N8CANAUPRS, N8CANAUPRG, N8CANAUPLV, N8CANAUPLD, N8CANAUPLI, N8CANAUPLS, N8CANAUPLG, N8CANAPORI, N8CANAPOLI, N8CANAPMRI, N8CANAPMLI, N8CANAPURI, N8CANAPULI, N8CANANDRL, N8CANANDRQ, N8CANANDRT, N8CANANDRV, N8CANANDLL, N8CANANDLQ, N8CANANDLT, N8CANANDLV, N8CANANVR, N8CANANVL, N8CANAPBR, N8CANAPBL, N8CAFTUS, N8CAFTUB, N8CAFTRAVM, N8CAFTRAPV, N8CAFTRAGW, N8CAFTRASI, N8CAFTRMVM, N8CAFTRMPV, N8CAFTRMGW, N8CAFTRMSI, N8CAFTRHVM, N8CAFTRHPV, N8CAFTRHSI, N8CAFTOPVS, N8CAFTOPVD, N8CAFTOPRI, N8CAFTOPSI, N8CAFTSMVS, N8CAFTSMVD, N8CAFTSMRI, N8CAFTSMSI, N8CAFTUPVS, N8CAFTUPVD, N8CAFTUPRI, N8CAFTUPSI, N8CAFTNDL, N8CAFTNDQ, N8CAFTNDT, N8CAFTNDV, N8CAFTRIPO, N8CAFTRIPM, N8CAFTRIPU, N8CAFTNV, N8CAFTPB, N8CAFTPO, N8CAFTMO, N8CAFTPR, N8CAKTSRRW, N8CAKTSRRL, N8CAKTSRRS, N8CAKTSRRE, N8CAKTSRRR, N8CAKTSRRP, N8CAKTSRRG, N8CAKTSRLW, N8CAKTSRLL, N8CAKTSRLS, N8CAKTSRLE, N8CAKTSRLR, N8CAKTSRLP, N8CAKTSRLG, N8CALRUS, N8CALRASLA, N8CALRASBR, N8CALRASTI, N8CALRASLU, N8CALRASAH, N8CALRAFAR, N8CALRAFVE, N8CALRAFQU, N8CALRAFVM, N8CALRAFSV, N8CALRHALA, N8CALRHABR, N8CALRHATI, N8CALRHAMO, N8CALLUS, N8CALLASLA, N8CALLASBR, N8CALLASTI, N8CALLASLU, N8CALLASAH, N8CALLAFAR, N8CALLAFVE, N8CALLAFQU, N8CALLAFVM, N8CALLAFSV, N8CALLHALA, N8CALLHABR, N8CALLHATI, N8CALLHAMO, N8CADTOCR1, N8CADTOCR2, N8CADTOCR3, N8CADTOCR4, N8CADTOCR5, N8CADTOCR6, N8CADTOCR7, N8CADTOCR8, N8CADTOCR9, GSDKFIND, GSDKRESUME, GSDKHKVOEM, N8CAHKBETH, X00KRESDAT, N8CARESDAT, X00KRESTIM, N8CARESTIM, X00KRESGP, X03MVMAKRZ, X03MVMARNG, N8CARESNAM, X03MVMAFAR, X00KRESGP2, X04MVMAKRZ, X04MVMARNG, N8CARESNM2, X04MVMAFAR, GSDKDCELVB, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG FROM N2CA12

TOP ERP 6.0 | N2CA12 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DOKAR	Document Type	nvarchar	3	0	Allow NULL?
3	DOKNR	Document number	nvarchar	25	0	Allow NULL?
4	DOKVR	Document Version	nvarchar	2	0	Allow NULL?
5	DOKTL	Document Part	nvarchar	3	0	Allow NULL?
6	GSDKPATKPF	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
7	ISHMPATNAM	IS-H: Patient Name	nvarchar	30	0	Allow NULL?
8	ISHMPATNUM	IS-H: Patient Number	nvarchar	10	0	Allow NULL?
9	ISHMPATGES	IS-H: Sex Indicator - User-Specific	char	1	0	Allow NULL?
10	ISHMPATFAL	IS-H: Case Number	nvarchar	10	0	Allow NULL?
11	ISHMPATFAT	IS-H: Text for Case Type	nvarchar	14	0	Allow NULL?
12	ISHMPATGEB	IS-H: Birthdate	nvarchar	8	0	Allow NULL?
13	ISHMPATAPO	IS-H: Nursing Organizational Unit Requesting the Service	nvarchar	8	0	Allow NULL?
14	ISHMPATALT	Patient Age	nvarchar	3	0	Allow NULL?
15	N8CAPATALE	Unit of Age	char	1	0	Allow NULL?
16	N8CAPATGEW	Body Weight in Kg	nvarchar	3	0	Allow NULL?
17	N8CAPATGRO	Height in Cm	nvarchar	3	0	Allow NULL?
18	N8CAPATBMI	Cardiology: Body Mass Index (xx,y) kg/m2	decimal	3	1
19	N8CAPATBSA	Cardiology: Body Surface Area (x,yy) m2	decimal	3	2
20	N8CAANFVMA	Employee Responsible	nvarchar	10	0	Allow NULL?
21	N8CAANFDAT	IS-H: Date when Record Created	nvarchar	8	0	Allow NULL?
22	N8CAANFTIM	IS-H: Time Record Created	nvarchar	6	0	Allow NULL?
23	N8CAEXAROO	Cardiology: Examination Room	nvarchar	8	0	Allow NULL?
24	X00MKANAM	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
25	X00MFRGST	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
26	N8CADTOIND	Cardiology: Selection of Indication	nvarchar	60	0	Allow NULL?
27	N8CATSTUD	Cardiology: Study Participation	nvarchar	15	0	Allow NULL?
28	N8CAXKEBE	Cardiology: Checkbox no Cardiovascular Risks Known	char	1	0	Allow NULL?
29	N8CAXARTHY	Cardiology: Checkbox Art. Hypertension	char	1	0	Allow NULL?
30	N8CAXNICO	Cardiology: Checkbox Nicotine	char	1	0	Allow NULL?
31	N8CAXDIABM	Cardiology: Checkbox Diabetes Mellitus	char	1	0	Allow NULL?
32	N8CAXHYLIP	Cardiology: Checkbox Hyperlipidemia	char	1	0	Allow NULL?
33	N8CAXFAMA	Cardiology: Checkbox Family Anamnesis	char	1	0	Allow NULL?
34	N8CACAVSON	Cardiology: Other Cardiovascular Risk Factors	nvarchar	60	0	Allow NULL?
35	N8CA_DOKP	Cardiology: Documentation Print	char	1	0	Allow NULL?
36	N8CA_DOKV	Cardiology: Documentation on Video	char	1	0	Allow NULL?
37	N8CA_DOKD	Cardiology: Documentation Digital on Data Carrier	char	1	0	Allow NULL?
38	N8CA_DOKS	Cardiology: Documentation Digital on Server	char	1	0	Allow NULL?
39	N8CA_AQ	Cardiology: Assessability	char	1	0	Allow NULL?
40	N8CAKM_GD	Cardiology: Contrast Medium Ultrasound	char	1	0	Allow NULL?
41	N8CAKM_DCE	Cardiology: Contrast Medium	nvarchar	50	0	Allow NULL?
42	N8CAEXADAT	Cardiology: Date of Examination	nvarchar	8	0	Allow NULL?
43	N8CAEXATIM	Cardiology: Time of Examination	nvarchar	6	0	Allow NULL?
44	N8CADC_DEV	Cardiology: Examination Device	nvarchar	25	0	Allow NULL?
45	GSDKEXGP	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
46	ISHMVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
47	ISHMVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
48	N8CAEXANAM	Cardiology: Name of Examiner	nvarchar	40	0	Allow NULL?
49	ISHMVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
50	GSDKEXGP2	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
51	X00MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
52	X00MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
53	N8CAEXANA2	Cardiology: Name of Examiner	nvarchar	40	0	Allow NULL?
54	X00MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
55	GSDKASGP	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
56	X01MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
57	X01MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
58	N8CAASNAM1	Cardiology: Name of Assistant	nvarchar	40	0	Allow NULL?
59	X01MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
60	GSDKASGP2	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
61	X02MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
62	X02MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
63	N8CAASNAM2	Cardiology: Name of Assistant	nvarchar	40	0	Allow NULL?
64	X02MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
65	N8CAAGUS	Cardiology: Examination Status Abdominal Vessels	char	1	0	Allow NULL?
66	N8CAAGUB	Cardiology: Assessability Abdominal Vessels	char	1	0	Allow NULL?
67	N8CAAGSRGW	Cardiology: Vessel Wall Aorta Suprarenal	char	1	0	Allow NULL?
68	N8CAAGSRWE	Cardiology: Width Aorta Suprarenal	char	1	0	Allow NULL?
69	N8CAAGSRSI	Cardiology: Signal Aorta Suprarenal	char	1	0	Allow NULL?
70	N8CAAGSRVM	Cardiology: Maximum Flow Velocity Aorta Suprarenal	nvarchar	3	0	Allow NULL?
71	N8CAAGSRDA	Cardiology: Diameter Anterior-Posterior Aorta Suprarenal	nvarchar	3	0	Allow NULL?
72	N8CAAGSRDQ	Cardiology: Transverse Diameter Aorta Suprarenal	nvarchar	3	0	Allow NULL?
73	N8CAAGIRGW	Cardiology: Vessel Wall Aorta Infrarenal	char	1	0	Allow NULL?
74	N8CAAGIRWE	Cardiology: Width Aorta Infrarenal	char	1	0	Allow NULL?
75	N8CAAGIRSI	Cardiology: Signal Aorta Infrarenal	char	1	0	Allow NULL?
76	N8CAAGIRVM	Cardiology: Maximum Flow Velocity Aorta Infrarenal	nvarchar	3	0	Allow NULL?
77	N8CAAGIRDA	Cardiology: Diameter Anterior-Posterior Aorta Infrarenal	nvarchar	3	0	Allow NULL?
78	N8CAAGIRDQ	Cardiology: Transverse Diameter Aorta Infrarenal	nvarchar	3	0	Allow NULL?
79	N8CAAGPRGW	Cardiology: Vessel Wall Aorta Prebifurcation	char	1	0	Allow NULL?
80	N8CAAGPRWE	Cardiology: Width Aorta Prebifurcation	char	1	0	Allow NULL?
81	N8CAAGPRSI	Cardiology: Signal Aorta Prebifurcation	char	1	0	Allow NULL?
82	N8CAAGPRVM	Cardiology: Maximum Flow Velocity Aorta Prebifurcation	nvarchar	3	0	Allow NULL?
83	N8CAAGPRDA	Cardiology: Diameter Ant.-Post. Aorta Prebifurcation	nvarchar	3	0	Allow NULL?
84	N8CAAGPRDQ	Cardiology: Transverse Diameter Aorta Prebifurcation	nvarchar	3	0	Allow NULL?
85	N8CAAGAE	Cardiology: Pronounced Elongation	char	1	0	Allow NULL?
86	N8CAAGNS	Cardiology: Fasting Status Abdominal Vessels	char	1	0	Allow NULL?
87	N8CAAGCAGW	Cardiology: Vessel Wall Truncus Coeliacus Origin	char	1	0	Allow NULL?
88	N8CAAGCASI	Cardiology: Signal Truncus Coeliacus Origin	char	1	0	Allow NULL?
89	N8CAAGCAVM	Cardiology: Maximum Flow Velocity Tr. Coeliacus Origin	nvarchar	3	0	Allow NULL?
90	N8CAAGCARI	Cardiology: Resistance Index Truncus Coeliacus Origin	decimal	4	2
91	N8CAAGCAPV	Cardiology: Peak Velocity Ratio Truncus Coeliacus Origin	decimal	4	2
92	N8CAAGCDGW	Cardiology: Vessel Wall Truncus Coeliacus Distal	char	1	0	Allow NULL?
93	N8CAAGCDSI	Cardiology: Signal Truncus Coeliacus Distal	char	1	0	Allow NULL?
94	N8CAAGCDVM	Cardiology: Maximum Flow Velocity Tr. Coeliacus Distal	nvarchar	3	0	Allow NULL?
95	N8CAAGCDRI	Cardiology: Resistance Index Truncus Coeliacus Distal	decimal	4	2
96	N8CAAGCDPV	Cardiology: Peak Velocity Ratio Truncus Coeliacus Distal	decimal	4	2
97	N8CAAGSAGW	Cardiology: Vessel Wall A. Mesenterica Sup. Origin	char	1	0	Allow NULL?
98	N8CAAGSASI	Cardiology: Signal A. Mesenterica Sup. Origin	char	1	0	Allow NULL?
99	N8CAAGSAVM	Cardiology: Maximum Flow Velocity A. Mesent. Sup. Origin	nvarchar	3	0	Allow NULL?
100	N8CAAGSARI	Cardiology: Resistance Index A. Mesenterica Sup. Origin	decimal	4	2
101	N8CAAGSAPV	Cardiology: Peak Velocity Ratio A. Mesenterica Sup. Origin	decimal	4	2
102	N8CAAGSDGW	Cardiology: Vessel Wall A. Mesenterica Sup. Distal	char	1	0	Allow NULL?
103	N8CAAGSDSI	Cardiology: Signal A. Mesenterica Sup. Distal	char	1	0	Allow NULL?
104	N8CAAGSDVM	Cardiology: Maximum Flow Velocity A. Mesent. Sup. Distal	nvarchar	3	0	Allow NULL?
105	N8CAAGSDRI	Cardiology: Resistance Index A. Mesenterica Sup. Distal	decimal	4	2
106	N8CAAGSDPV	Cardiology: Peak Velocity Ratio A. Mesenterica Sup. Distal	decimal	4	2
107	N8CAAGIAGW	Cardiology: Vessel Wall A. Mesenterica Inf. Origin	char	1	0	Allow NULL?
108	N8CAAGIASI	Cardiology: Signal A. Mesenterica Inf. Origin	char	1	0	Allow NULL?
109	N8CAAGIAVM	Cardiology: Maximum Flow Velocity A. Mesent. Inf. Origin	nvarchar	3	0	Allow NULL?
110	N8CAAGIARI	Cardiology: Resistance Index A. Mesenterica Inf. Origin	decimal	4	2
111	N8CAAGIAPV	Cardiology: Peak Velocity Ratio A. Mesenterica Inf. Origin	decimal	4	2
112	N8CAAGIDGW	Cardiology: Vessel Wall A. Mesenterica Inf. Distal	char	1	0	Allow NULL?
113	N8CAAGIDSI	Cardiology: Signal A. Mesenterica Inf. Distal	char	1	0	Allow NULL?
114	N8CAAGIDVM	Cardiology: Maximum Flow Velocity A. Mesent. Inf. Distal	nvarchar	3	0	Allow NULL?
115	N8CAAGIDRI	Cardiology: Resistance Index A. Mesenterica Inf. Distal	decimal	4	2
116	N8CAAGIDPV	Cardiology: Peak Velocity Ratio A. Mesenterica Inf. Distal	decimal	4	2
117	N8CAAGAMA	Cardiology: Max. Diameter Ant.-Post. Aortic Aneurysm	decimal	3	1
118	N8CAAGAMQ	Cardiology: Max. Transverse Diameter Aorta Aneurysm (cm)	decimal	3	1
119	N8CAAGALA	Cardiology: Length Aortic Aneurysm (cm)	decimal	3	1
120	N8CAAGLDA	Cardiology: Diameter Anterior-Posterior Free Lumen (cm)	decimal	3	1
121	N8CAAGLDQ	Cardiology: Transverse Diameter Free Lumen (cm)	decimal	3	1
122	N8CAAGLLA	Cardiology: Length Free Lumen (cm)	decimal	3	1
123	N8CAAGTMO	Cardiology: Morphology of Thrombus in Aortic Aneurysm	char	1	0	Allow NULL?
124	N8CAAGTMD	Cardiology: Maximum Thickness Thrombus (cm)	decimal	3	1
125	N8CAAGTFO	Cardiology: Thrombus Form	char	1	0	Allow NULL?
126	N8CAAGTLA	Cardiology: Thrombus Length (cm)	decimal	3	1
127	N8CAAGUA	Cardiology: Color Doppler V. Cava Inferior Normal	char	1	0	Allow NULL?
128	N8CAAGAM	Cardiology: Color Doppler V. Cava Inf. Respiratory Modulated	char	1	0	Allow NULL?
129	N8CAAGWT	Cardiology: Wall Adherent Thrombi V. Cava Inf.	char	1	0	Allow NULL?
130	N8CAAGKT	Cardiology: V. Cava Inf. Completely Thrombosed	char	1	0	Allow NULL?
131	N8CALMUS	Cardiology: Examination Status Liver and Spleen Vessels	char	1	0	Allow NULL?
132	N8CALMUB	Cardiology: Assessability Liver and Spleen Vessels	char	1	0	Allow NULL?
133	N8CALMNS	Cardiology: Fasting Status Liver and Spleen Vessels	char	1	0	Allow NULL?
134	N8CALMPHDM	Cardiology: Diameter V. Portae Main Stem	nvarchar	2	0	Allow NULL?
135	N8CALMPHLU	Cardiology: Lumen V. Portae Main Stem	char	1	0	Allow NULL?
136	N8CALMPHVM	Cardiology: Maximum Flow Velocity V. Portae Main Stem	nvarchar	3	0	Allow NULL?
137	N8CALMPRDM	Cardiology: Diameter V. Portae Right Main Branch	nvarchar	2	0	Allow NULL?
138	N8CALMPRLU	Cardiology: Lumenr V. Portae Right Main Branch	char	1	0	Allow NULL?
139	N8CALMPRVM	Cardioy: Maximum Flow Velocity V. Portae Right Main Branch	nvarchar	3	0	Allow NULL?
140	N8CALMPLDM	Cardiology: Diameter V. Portae Left Main Branch	nvarchar	2	0	Allow NULL?
141	N8CALMPLLU	Cardiology: Lumen V. Portae Left Main Branch	char	1	0	Allow NULL?
142	N8CALMPLVM	Cardiology: Maximum Flow Velocity V. Portae Left Main Branch	nvarchar	3	0	Allow NULL?
143	N8CALMHPVM	Cardiology: Maximale Flow Velocity Art. Hepatica Propria	nvarchar	3	0	Allow NULL?
144	N8CALMHPRI	Cardiology: Resistance Index Art. Hepatica Propria	decimal	4	2
145	N8CALMHCVM	Cardiology: Mmaximum Flow Velocity A. Hepatica Communis	nvarchar	3	0	Allow NULL?
146	N8CALMHCRI	Cardiology: Resistance Index Art. Hepatica Communis	decimal	4	2
147	N8CALMHMDM	Cardiology: Diameter V. Hepatica Media	nvarchar	2	0	Allow NULL?
148	N8CALMHMLU	Cardiology: Lumen V. Hepatica Media	char	1	0	Allow NULL?
149	N8CALMHMSI	Cardiology: Signal V. Hepatica Media	char	1	0	Allow NULL?
150	N8CALMHSDM	Cardiology: Diameter V. Hepatica Sinistra	nvarchar	2	0	Allow NULL?
151	N8CALMHSLU	Cardiology: Lumen V. Hepatica Sinistra	char	1	0	Allow NULL?
152	N8CALMHSSI	Cardiology: Signal V. Hepatica Sinistra	char	1	0	Allow NULL?
153	N8CALMHDDM	Cardiology: Diameter V. Hepatica Dextra	nvarchar	2	0	Allow NULL?
154	N8CALMHDLU	Cardiology: Lumen V. Hepatica Dextra	char	1	0	Allow NULL?
155	N8CALMHDSI	Cardiology: Signal V. Hepatica Dextra	char	1	0	Allow NULL?
156	N8CALMCILU	Cardiology: Lumen V. Hepatica Dextra	char	1	0	Allow NULL?
157	N8CALMAS	Cardiology: Ascites	char	1	0	Allow NULL?
158	N8CALMLG	Cardiology: Lobe Size Liver	char	1	0	Allow NULL?
159	N8CALMPS	Cardiology: Parenchym Structure Liver	char	1	0	Allow NULL?
160	N8CALMOK	Cardiology: Surface Contour Liver	char	1	0	Allow NULL?
161	N8CALAUS	Cardiology: Examination Status Vessels Spleno-Port. Axis	char	1	0	Allow NULL?
162	N8CALAUB	Cardiology: Assessability Vessels Spleno-Port. Axis	char	1	0	Allow NULL?
163	N8CALMKKAM	Cardiology: Degree Collateral Circulation Gastric Wall	char	1	0	Allow NULL?
164	N8CALMKKRM	Cardiology: Reference Vessel Collateral Circul. Gastric Wall	nvarchar	25	0	Allow NULL?
165	N8CALMKKDM	Cardiology: Diameter Reference Vessel Gastric Wall	nvarchar	2	0	Allow NULL?
166	N8CALMKKVM	Cardiology: Maximum Velocity Reference Vessel Gastric Wall	nvarchar	3	0	Allow NULL?
167	N8CALMKKFM	Cardiology: Flow Vol. Reference Vessel Gastric Wall (ml/min)	nvarchar	4	0	Allow NULL?
168	N8CALMKKAR	Cardiology: Degree Collateral Circulation Retroperitoneum	char	1	0	Allow NULL?
169	N8CALMKKRR	Cardiology: Reference Vessel Collateral Circul. Retroperit.	nvarchar	25	0	Allow NULL?
170	N8CALMKKDR	Cardiology: Diameter Reference Vessel Retroperitoneum	nvarchar	2	0	Allow NULL?
171	N8CALMKKVR	Cardio: Maximum Flow Velocity Reference Vessel Retroperit.	nvarchar	3	0	Allow NULL?
172	N8CALMKKFR	Cardiology: Flow Volume Reference Vessel Retroperitoneum	nvarchar	4	0	Allow NULL?
173	N8CALMKKAB	Cardiology: Degree Collateral Circulation Abdominal Wall	char	1	0	Allow NULL?
174	N8CALMKKRB	Cardiology: Reference Vessel Collateral Circul. Abdom. Wall	nvarchar	25	0	Allow NULL?
175	N8CALMKKDB	Cardiology: Diameter Reference Vessel Gastric Wall	nvarchar	2	0	Allow NULL?
176	N8CALMKKVB	Cardiology: Maximum Velocity Reference Vessel Gastric Wall	nvarchar	3	0	Allow NULL?
177	N8CALMKKFB	Cardiology: Flow Vol. Reference Vesssel Gastric Wall(ml/min)	nvarchar	4	0	Allow NULL?
178	N8CALMVLDM	Cardiology: Diameter V. Lienalis	nvarchar	2	0	Allow NULL?
179	N8CALMVLVM	Cardiology: Maximum Flow Velocity V. Lienalis	nvarchar	3	0	Allow NULL?
180	N8CALMALGW	Cardiology: Vessel Wall A. Lienalis	char	1	0	Allow NULL?
181	N8CALMALSI	Cardiology: Signal A. Lienalis	char	1	0	Allow NULL?
182	N8CALMALVM	Cardiology: Maximum Flow Velocity A. Lienalis	nvarchar	3	0	Allow NULL?
183	N8CALMALRI	Cardiology: Resistance Index A. Lienalis	decimal	4	2
184	N8CALMALPV	Cardiology: Peak Velocity Ratio A. Lienalis	decimal	4	2
185	N8CALMCOLU	Cardiology: Lumen Confluence	char	1	0	Allow NULL?
186	N8CALMMSLU	Cardiology: Lumen V. Mesenterica Superior	char	1	0	Allow NULL?
187	N8CALMMSFR	Cardiology: Flow Direction V. Mesenteric Superior	char	1	0	Allow NULL?
188	N8CALMMSVM	Cardiology: Maximum Flow Velocity V. Mesenterica Superior	nvarchar	3	0	Allow NULL?
189	N8CALMMG	Cardiology: Spleen Size	char	1	0	Allow NULL?
190	N8CALMMF	Cardiology: Spleen Form	char	1	0	Allow NULL?
191	N8CANAUS	Cardiology: Examination Status Renal Arteries	char	1	0	Allow NULL?
192	N8CANAUB	Cardiology: Assessability Renal Arteries	char	1	0	Allow NULL?
193	N8CANAFSVS	Cardiology: Maximum Flow Velocity Systolic Aorta Suprarenal.	nvarchar	3	0	Allow NULL?
194	N8CANARARV	Cardiology: Maximum Flow Velocity A. Renalis Origin Right	nvarchar	3	0	Allow NULL?
195	N8CANARARR	Cardiology: Renoaortic Ratio A. Renalis Origin Right	decimal	4	2
196	N8CANARARW	Cardiology: Vessel Wall A. Renalis Origin Right	char	1	0	Allow NULL?
197	N8CANARARI	Cardiology: Resistance Index Art. Renalis Origin Right	decimal	4	2
198	N8CANARARS	Cardiology: Signal A. Renalis Origin Right	char	1	0	Allow NULL?
199	N8CANARARG	Cardiology: Deg. of Sten. Origin Art. Renalis Right	nvarchar	3	0	Allow NULL?
200	N8CANARALV	Cardiology: Maximum Flow Velocity A. Renalis Origin Left	nvarchar	3	0	Allow NULL?
201	N8CANARALR	Cardiology: Renoaortic Ratio A. Renalis Origin Left	decimal	4	2
202	N8CANARALW	Cardiology: Vessel Wall A. Renalis Origin Left	char	1	0	Allow NULL?
203	N8CANARALI	Cardiology: Resistance Index Art. Renalis Origin Left	decimal	4	2
204	N8CANARALS	Cardiology: Signal A. Renalis Origin Left	char	1	0	Allow NULL?
205	N8CANARALG	Cardiology: Deg. of Sten. Origin Art. Renalis Left	nvarchar	3	0	Allow NULL?
206	N8CANARMRV	Cardiology: Maximum Flow Velocity A. Renalis Medial Right	nvarchar	3	0	Allow NULL?
207	N8CANARMRR	Cardiology: Peak Velocity Ratio A. Renalis Medial Right	decimal	4	2
208	N8CANARMRW	Cardiology: Vessel Wall A. Renalis Medial Right	char	1	0	Allow NULL?
209	N8CANARMRS	Cardiology: Signal A. Renalis Medial Right	char	1	0	Allow NULL?
210	N8CANARMRG	Cardiology: Deg. of Sten. Medial Art. Renalis Right	nvarchar	3	0	Allow NULL?
211	N8CANARMLV	Cardiology: Maximum Flow Velocity A. Renalis Medial Left	nvarchar	3	0	Allow NULL?
212	N8CANARMLR	Cardiology: Peak Velocity Ratio A. Renalis Medial Left	decimal	4	2
213	N8CANARMLW	Cardiology: Vessel Wall A. Renalis Medial Left	char	1	0	Allow NULL?
214	N8CANARMLS	Cardiology: Signal A. Renalis Medial Left	char	1	0	Allow NULL?
215	N8CANARMLG	Cardiology: Deg. of Sten. Art. Renalis Medial Left	nvarchar	3	0	Allow NULL?
216	N8CANARHRV	Cardiology: Maximum Flow Velocity A. Renalis Hilus Right	nvarchar	3	0	Allow NULL?
217	N8CANARHRR	Cardiology: Peak Velocity Ratio A. Renalis Hilus Right	decimal	4	2
218	N8CANARHRI	Cardiology: Resistance Index Art. Renalis Hilus Right	decimal	4	2
219	N8CANARHRS	Cardiology: Signal A. Renalis Hilus Right	char	1	0	Allow NULL?
220	N8CANARHRG	Cardiology: Deg. of Sten. Art. Renalis Hilus Right	nvarchar	3	0	Allow NULL?
221	N8CANARHLV	Cardiology: Maximum Flow Velocity A. Renalis Hilus Left	nvarchar	3	0	Allow NULL?
222	N8CANARHLR	Cardiology: Peak Velocity Ratio A. Renalis Hilus Left	decimal	4	2
223	N8CANARHLI	Cardiology: Resistance Index Art. Renalis Hilus Left	decimal	4	2
224	N8CANARHLS	Cardiology: Signal A. Renalis Hilus Left	char	1	0	Allow NULL?
225	N8CANARHLG	Cardiology: Deg. of Sten. Art. Renalis Hilus Left	nvarchar	3	0	Allow NULL?
226	N8CANAOPRV	Cardiology: MaxV Systolic Segment Arteries Upper Pole Right	nvarchar	3	0	Allow NULL?
227	N8CANAOPRD	Cardiology: MaxV Diastolic Segmental Arteries Up. Pole Right	nvarchar	3	0	Allow NULL?
228	N8CANAOPRI	Cardiology: Resistance Index Segmental Arts Up. Pole Right	decimal	4	2
229	N8CANAOPRS	Cardiology: Signal Segment Arteries Upper Pole Right	char	1	0	Allow NULL?
230	N8CANAOPRG	Cardiology: Deg. of Sten. Segment Arteries Upper Pole Right	nvarchar	3	0	Allow NULL?
231	N8CANAOPLV	Cardiology: MaxV Systolic Segment Arteries Upper Pole Left	nvarchar	3	0	Allow NULL?
232	N8CANAOPLD	Cardiology: MaxV Diastolic Segment Arteries Upper Pole Left	nvarchar	3	0	Allow NULL?
233	N8CANAOPLI	Cardiology: Resistance Index Segment Art. Upper Pole Left	decimal	4	2
234	N8CANAOPLS	Cardiology: Signal Segment Arteries Upper Pole Left	char	1	0	Allow NULL?
235	N8CANAOPLG	Cardiology: Deg. of Sten. Segment Arteries Upper Pole Left	nvarchar	3	0	Allow NULL?
236	N8CANASMRV	Cardiology: MaxV Systolic Segment Arteries Medial Right	nvarchar	3	0	Allow NULL?
237	N8CANASMRD	Cardiology: MaxV Diastolic Segment Arteries Medial Right	nvarchar	3	0	Allow NULL?
238	N8CANASMRI	Cardiology: Resistance Index Segment Artery Medial Right	decimal	4	2
239	N8CANASMRS	Cardiology: Signal Segment Arteries Medial Right	char	1	0	Allow NULL?
240	N8CANASMRG	Cardiology: Deg. of Sten. Segment Arteries Medial Right	nvarchar	3	0	Allow NULL?
241	N8CANASMLV	Cardiology: MaxV Systolic Segment Arteries Medial Left	nvarchar	3	0	Allow NULL?
242	N8CANASMLD	Cardiology: MaxV Diastolic Segment Arteries Medial Left	nvarchar	3	0	Allow NULL?
243	N8CANASMLI	Cardiology: Resistance Index Segment Arteries Medial Left	decimal	4	2
244	N8CANASMLS	Cardiology: Signal Segment Arteries Medial Left	char	1	0	Allow NULL?
245	N8CANASMLG	Cardiology: Deg. of Sten. Segment Arteries Medial Left	nvarchar	3	0	Allow NULL?
246	N8CANAUPRV	Cardiology: MaxV Systolic Segment Arteries Lower Pole Right	nvarchar	3	0	Allow NULL?
247	N8CANAUPRD	Cardiology: MaxV Diastolic Segment Arteries Lower Pole Right	nvarchar	3	0	Allow NULL?
248	N8CANAUPRI	Cardiology: Resistance Index Segment Art. Lower Pole Right	decimal	4	2
249	N8CANAUPRS	Cardiology: Signal Segment Arteries Lower Pole Right	char	1	0	Allow NULL?
250	N8CANAUPRG	Cardiology: Deg. of Sten. Segment Arteries Lower Pole Right	nvarchar	3	0	Allow NULL?
251	N8CANAUPLV	Cardiology: MaxV Systolic Segment Arteries Lower Pole Left	nvarchar	3	0	Allow NULL?
252	N8CANAUPLD	Cardiology: MaxV Diastolic Segment Arteries Lower Pole Left	nvarchar	3	0	Allow NULL?
253	N8CANAUPLI	Cardiology: Resistance Index Segment Art. Lower Pole Left	decimal	4	2
254	N8CANAUPLS	Cardiology: Signal Segment Arteries Lower Pole Left	char	1	0	Allow NULL?
255	N8CANAUPLG	Cardiology: Deg. of Sten. Segment Arteries Lower Pole Left	nvarchar	3	0	Allow NULL?
256	N8CANAPORI	Cardiology: Resistance Index Periph. Artery Upper Pole Right	decimal	4	2
257	N8CANAPOLI	Cardiology: Resistance Index Periph. Artery Upper Pole Left	decimal	4	2
258	N8CANAPMRI	Cardiology: Resistance Index Periph. Artery Medial Right	decimal	4	2
259	N8CANAPMLI	Cardiology: Resistance Index Periph. Artery Medial Left	decimal	4	2
260	N8CANAPURI	Cardiology: Resistance Index Periph. Artery Lower Pole Right	decimal	4	2
261	N8CANAPULI	Cardiology: Resistance Index Periph. Artery Lower Pole Left	decimal	4	2
262	N8CANANDRL	Cardiology: Kidney Longitudinal Diameter Right	decimal	3	1
263	N8CANANDRQ	Cardiology: Kidney Transverse Diameter Right	decimal	3	1
264	N8CANANDRT	Cardiology: Kidney Diameter Depth Right Kidney	decimal	3	1
265	N8CANANDRV	Cardiology: Kidney Volume Right Kidney (ml)	nvarchar	4	0	Allow NULL?
266	N8CANANDLL	Cardiology: Longitudinal Kidney Diameter Left	decimal	3	1
267	N8CANANDLQ	Cardiology: Transverse Kidney Diameter Left	decimal	3	1
268	N8CANANDLT	Cardiology: Kidney Diameter Depth Left Kidney	decimal	3	1
269	N8CANANDLV	Cardiology: Kidney Volume Left Kidney (ml)	nvarchar	4	0	Allow NULL?
270	N8CANANVR	Cardiology: Condition Renal Vein Right	char	1	0	Allow NULL?
271	N8CANANVL	Cardiology: Condition Renal Vein Left	char	1	0	Allow NULL?
272	N8CANAPBR	Cardiology: Parenchym Width Right (mm)	nvarchar	2	0	Allow NULL?
273	N8CANAPBL	Cardiology: Parenchym Width Left (mm)	nvarchar	2	0	Allow NULL?
274	N8CAFTUS	Cardiology: Examination Status Transplant Kidney	char	1	0	Allow NULL?
275	N8CAFTUB	Cardiology: Assessability Transplant Kidney	char	1	0	Allow NULL?
276	N8CAFTRAVM	Cardiology: MaxV A. Renalis Origin Transplant Kidney	nvarchar	3	0	Allow NULL?
277	N8CAFTRAPV	Cardiology: RAO A. Renalis Origin Transplant Kidney	decimal	4	2
278	N8CAFTRAGW	Cardiology: Vessel Wall A. Renalis Origin Transplant Kidney	char	1	0	Allow NULL?
279	N8CAFTRASI	Cardiology: Signal A. Renalis Origin Transplant Kidney	char	1	0	Allow NULL?
280	N8CAFTRMVM	Cardiology: Vmax A. Renalis Medial Transplant Kidney	nvarchar	3	0	Allow NULL?
281	N8CAFTRMPV	Cardiology: PVR A. Renalis Medial Transplant Kidney	decimal	4	2
282	N8CAFTRMGW	Cardio: Vessel Wall A. Renalis Medial Transplant Kidney	char	1	0	Allow NULL?
283	N8CAFTRMSI	Cardiology: Signal A. Renalis Medial Transplant Kidney	char	1	0	Allow NULL?
284	N8CAFTRHVM	Cardiology: Vmax A. Renalis Hilus Transplant Kidney	nvarchar	3	0	Allow NULL?
285	N8CAFTRHPV	Cardiology: PVR A. Renalis Hilus Transplant Kidney	decimal	4	2
286	N8CAFTRHSI	Cardiology: Signal A. Renalis Hilus Transplant Kidney	char	1	0	Allow NULL?
287	N8CAFTOPVS	Cardio: MaxV Syst. Segment Art. Upper Pole Transplant Kidney	nvarchar	3	0	Allow NULL?
288	N8CAFTOPVD	Cardio: MaxV Diast. Segment Art. Upper Pole Transpl. Kidney	nvarchar	3	0	Allow NULL?
289	N8CAFTOPRI	Cardioy: Res. Idx Segment Art. Upper Pole Transplant Kidney	decimal	4	2
290	N8CAFTOPSI	Cardiology: Signal Segment Art. Upper Pole Transplant Kidney	char	1	0	Allow NULL?
291	N8CAFTSMVS	Cardiology: MaxV Syst. Segment Art. Medial Transplant Kidney	nvarchar	3	0	Allow NULL?
292	N8CAFTSMVD	Cardiology: MaxV Diast. Segment Art. Medial Transpl. Kidney	nvarchar	3	0	Allow NULL?
293	N8CAFTSMRI	Cardiology: RI Segment Arteries Medial Transplant Kidney	decimal	4	2
294	N8CAFTSMSI	Cardiology: Signal Segment Arteries Medial Transplant Kidney	char	1	0	Allow NULL?
295	N8CAFTUPVS	Cardiology: MaxV Syst. Segment Art. Lower Pole Transplant	nvarchar	3	0	Allow NULL?
296	N8CAFTUPVD	Cardiology: MaxV Diast. Segment Art. Lower Pole Transplant	nvarchar	3	0	Allow NULL?
297	N8CAFTUPRI	Cardiology: RI Segment Art. Lower Pole Transplant Kidney	decimal	4	2
298	N8CAFTUPSI	Cardiology: Signal Segment Arts Lower Pole Transplant Kidney	char	1	0	Allow NULL?
299	N8CAFTNDL	Cardiology: Kidney Longitudinal Diameter Transplant Kidney	decimal	3	1
300	N8CAFTNDQ	Cardiology: Kidney Transverse Diameter Transplant Kidney	decimal	3	1
301	N8CAFTNDT	Cardiology: Kidney Diameter Depth Transplant Kidney	decimal	3	1
302	N8CAFTNDV	Cardiology: Kidney Volume Transplant Kidney (ml)	nvarchar	4	0	Allow NULL?
303	N8CAFTRIPO	Cardiology: RI Periph. Art. Upper Pole Transplant Kidney	decimal	4	2
304	N8CAFTRIPM	Cardiology: RI Periph. Arteries Medial Transplant Kidney	decimal	4	2
305	N8CAFTRIPU	Cardiology: RI Periph. Art. Lower Pole Transplant Kidney	decimal	4	2
306	N8CAFTNV	Cardiology: Condition Renal Vein Transplant Kidney	char	1	0	Allow NULL?
307	N8CAFTPB	Cardiology: Parenchym Width Transplant Kidney	nvarchar	2	0	Allow NULL?
308	N8CAFTPO	Cadiology: Fixed Values Position Transplant Kidney	char	1	0	Allow NULL?
309	N8CAFTMO	Cardiology: Morphology Transplant Kidney in Sonography	char	1	0	Allow NULL?
310	N8CAFTPR	Cardiology: Pararenal Space Transplant Kidney	char	1	0	Allow NULL?
311	N8CAKTSRRW	Cardiology: Vessel Wall Stent Art. Renalis Right	char	1	0	Allow NULL?
312	N8CAKTSRRL	Cardiology: Lumen Stent Art. Renalis Right	char	1	0	Allow NULL?
313	N8CAKTSRRS	Cardiology: Flow Velocity Syst. Stent Art. Renalis Right	nvarchar	3	0	Allow NULL?
314	N8CAKTSRRE	Cardiology: Flow Velocity EndD. Stent Art. Renalis Right	nvarchar	3	0	Allow NULL?
315	N8CAKTSRRR	Cardiology: Resistance Index Stent Art. Renalis Right	decimal	4	2
316	N8CAKTSRRP	Cardiology: Peak Vel. Ratio Stent A. Renalis Right	decimal	4	2
317	N8CAKTSRRG	Cardiology: Deg. of Stenosis Stent Art. Renalis Right	nvarchar	3	0	Allow NULL?
318	N8CAKTSRLW	Cardiology: Vessel Wall Stent Art. Renalis Left	char	1	0	Allow NULL?
319	N8CAKTSRLL	Cardiology: Lumen Stent A. Renalis Left	char	1	0	Allow NULL?
320	N8CAKTSRLS	Cardiology: Flow Velocity Syst. Stent Art. Renalis Left	nvarchar	3	0	Allow NULL?
321	N8CAKTSRLE	Cardiology: Flow Velocity EndD. Stent A. Renalis Left	nvarchar	3	0	Allow NULL?
322	N8CAKTSRLR	Cardiology: Resistance Index Stent Art. Renalis Left	decimal	4	2
323	N8CAKTSRLP	Cardiology: Peak Vel. Ratio Stent A. Renalis Left	decimal	4	2
324	N8CAKTSRLG	Cardiology: Deg. of Stenosis Stent A. Renalis Left	nvarchar	3	0	Allow NULL?
325	N8CALRUS	Cardiology: Examination Status Groin After Puncture Right	char	1	0	Allow NULL?
326	N8CALRASLA	Cardiology: Length Spurious Aneurysm Right (cm)	decimal	3	1
327	N8CALRASBR	Cardiology: Width Spurious Aneurysm Right (cm)	decimal	3	1
328	N8CALRASTI	Cardiology: Depth Spurious Aneurysm Right (cm)	decimal	3	1
329	N8CALRASLU	Cardiology: Lumen Spurious Aneurysm Right	char	1	0	Allow NULL?
330	N8CALRASAH	Cardiology: Neck Spurious Aneurysm Right (cm)	decimal	3	1
331	N8CALRAFAR	Cardiology: AV Fistula Supplying Artery Right	char	1	0	Allow NULL?
332	N8CALRAFVE	Cardiology: AV Fistula Draining Vein Right	char	1	0	Allow NULL?
333	N8CALRAFQU	Cardiology: AV Fistula Transverse Right (mm)	decimal	3	1
334	N8CALRAFVM	Cardiology: Mean Flow Velocity AV Fistula Right (cm/sec)	nvarchar	3	0	Allow NULL?
335	N8CALRAFSV	Cardiology: Shunt Volume AV Fistula Right (ml/min)	nvarchar	4	0	Allow NULL?
336	N8CALRHALA	Cardiology: Length Hematoma Groin Right (cm)	decimal	3	1
337	N8CALRHABR	Cardiology: Width Hematoma Groin Right (cm)	decimal	3	1
338	N8CALRHATI	Cardiology: Depth Hematoma Groin Right (cm)	decimal	3	1
339	N8CALRHAMO	Cardiology: Morphology Hematoma Groin Right	char	1	0	Allow NULL?
340	N8CALLUS	Cardiology: Examination Status Groin After Puncture Left	char	1	0	Allow NULL?
341	N8CALLASLA	Cardiology: Length Spurious Aneurysm Left (cm)	decimal	3	1
342	N8CALLASBR	Cardiology: Width Spurious Aneurysm Left (cm)	decimal	3	1
343	N8CALLASTI	Cardiology: Depth Spurious Aneurysm Left (cm)	decimal	3	1
344	N8CALLASLU	Cardiology: Lumen Spurious Aneurysm Left	char	1	0	Allow NULL?
345	N8CALLASAH	Cardiology: Neck Spurious Aneurysm Left (cm)	decimal	3	1
346	N8CALLAFAR	Cardiology: AV Fistula Supplying Artery Left	char	1	0	Allow NULL?
347	N8CALLAFVE	Cardiology: AV Fistula Draining Vein Left	char	1	0	Allow NULL?
348	N8CALLAFQU	Cardiology: Transverse AV Fistula Left (mm)	decimal	3	1
349	N8CALLAFVM	Cardiology: Mean Flow Velocity AV Fistula Left (cm/sec)	nvarchar	3	0	Allow NULL?
350	N8CALLAFSV	Cardiology: Shunt Volume AV Fistula Left (ml/min)	nvarchar	4	0	Allow NULL?
351	N8CALLHALA	Cardiology: Length Hematoma Groin Left (cm)	decimal	3	1
352	N8CALLHABR	Cardiology: Width Hematoma Groin Left (cm)	decimal	3	1
353	N8CALLHATI	Cardiology: Deep Hematoma Groin Left (cm)	decimal	3	1
354	N8CALLHAMO	Cardiology: Morphology Hematoma Groin Left	char	1	0	Allow NULL?
355	N8CADTOCR1	Cardiology: Criterion 1 Assessment Code	nvarchar	15	0	Allow NULL?
356	N8CADTOCR2	Cardiology: Criterion 2 Assessment Code	nvarchar	15	0	Allow NULL?
357	N8CADTOCR3	Cardiology: Criterion 3 Assessment Code	nvarchar	15	0	Allow NULL?
358	N8CADTOCR4	Cardiology: Criterion 4 Assessment Code	nvarchar	15	0	Allow NULL?
359	N8CADTOCR5	Cardiology: Criterion 5 Assessment Code	nvarchar	15	0	Allow NULL?
360	N8CADTOCR6	Cardiology: Criterion 6 Assessment Code	nvarchar	15	0	Allow NULL?
361	N8CADTOCR7	Cardiology: Criterion 7 Assessment Code	nvarchar	15	0	Allow NULL?
362	N8CADTOCR8	Cardiology: Criterion 8 Assessment Code	nvarchar	15	0	Allow NULL?
363	N8CADTOCR9	Cardiology: Criterion 9 Assessment Code	nvarchar	15	0	Allow NULL?
364	GSDKFIND	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
365	GSDKRESUME	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
366	GSDKHKVOEM	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
367	N8CAHKBETH	Cardiology: Therapy Recommendation	char	1	0	Allow NULL?
368	X00KRESDAT	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
369	N8CARESDAT	Cardiology: Date of Findings	nvarchar	8	0	Allow NULL?
370	X00KRESTIM	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
371	N8CARESTIM	Cardiology: Time of Findings Creation	nvarchar	6	0	Allow NULL?
372	X00KRESGP	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
373	X03MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
374	X03MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
375	N8CARESNAM	Cardiology: Name of Findings Creator	nvarchar	40	0	Allow NULL?
376	X03MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
377	X00KRESGP2	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
378	X04MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
379	X04MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
380	N8CARESNM2	Cardiology: Name of Supervisor	nvarchar	40	0	Allow NULL?
381	X04MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
382	GSDKDCELVB	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
383	N8CA_XDAT	Cardiology: Checkbox Data Was Imported	char	1	0	Allow NULL?
384	N8CA_EINRI	Institution	nvarchar	4	0	Allow NULL?
385	N8CA_SDEST	Symbolic Destination	nvarchar	8	0	Allow NULL?
386	N8CA_STUDA	Examination Date	nvarchar	8	0	Allow NULL?
387	N8CA_PATNR	IS-H: Patient Number	nvarchar	10	0	Allow NULL?
388	N8CA_UID	Character UID	nvarchar	32	0	Allow NULL?
389	N8CA_DFLAG	Data Flag Import OK	char	1	0	Allow NULL?

TOP ERP 6.0 | N2CA12 INDEXES

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

389 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA12 TABLE

TOP ERP 6.0 | N2CA12 COLUMNS

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

389 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA12 TABLE

TOPERP 6.0 | N2CA12 COLUMNS

TOPERP 6.0 | N2CA12 INDEXES

TOP ERP 6.0 | N2CA12 COLUMNS

TOP ERP 6.0 | N2CA12 INDEXES