	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

392 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA02 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Clinical System
1	ERP EHP7	6.0	N2CA02	392	1	PMD: N8CA_HKB Cardiac Catheter Findings	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, X00KPATGEW, N8CAPATGEW, X00KPATGRO, N8CAPATGRO, N8CAPATBMI, N8CAPATBSA, N8CAANFVMA, N8CAANFDAT, N8CAANFTIM, X00MKANAM, X00MFRGST, N8CAHKIND, N8CAPATEIN, N8CATSTUD, N8CA_HKNR, N8CA_NYHA, N8CA_CCS, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CAEXADAT, N8CAEXATIM, N8CAHK_DEV, N8CA_ANKOR, N8CAHBVERT, N8CAKOROOK, N8CARC01GR, N8CARC01AR, N8CARC01KO, N8CARC01KA, N8CARC01LG, N8CARC01TY, N8CARC01BE, N8CARC02GR, N8CARC02AR, N8CARC02KO, N8CARC02KA, N8CARC02LG, N8CARC02TY, N8CARC02BE, N8CARC03GR, N8CARC03AR, N8CARC03KO, N8CARC03KA, N8CARC03LG, N8CARC03TY, N8CARC03BE, N8CARC4AGR, N8CARC4AAR, N8CARC4AKO, N8CARC4AKA, N8CARC4ALG, N8CARC4ATY, N8CARC4ABE, N8CARC4BGR, N8CARC4BAR, N8CARC4BKO, N8CARC4BKA, N8CARC4BLG, N8CARC4BTY, N8CARC4BBE, N8CALM05GR, N8CALM05AR, N8CALM05KO, N8CALM05KA, N8CALM05LG, N8CALM05TY, N8CALM05BE, N8CALA06GR, N8CALA06AR, N8CALA06KO, N8CALA06KA, N8CALA06LG, N8CALA06TY, N8CALA06BE, N8CALA07GR, N8CALA07AR, N8CALA07KO, N8CALA07KA, N8CALA07LG, N8CALA07TY, N8CALA07BE, N8CALA08GR, N8CALA08AR, N8CALA08KO, N8CALA08KA, N8CALA08LG, N8CALA08TY, N8CALA08BE, N8CADI09GR, N8CADI09AR, N8CADI09KO, N8CADI09KA, N8CADI09LG, N8CADI09TY, N8CADI09BE, N8CADI10GR, N8CADI10AR, N8CADI10KO, N8CADI10KA, N8CADI10LG, N8CADI10TY, N8CADI10BE, N8CALC11GR, N8CALC11AR, N8CALC11KO, N8CALC11KA, N8CALC11LG, N8CALC11TY, N8CALC11BE, N8CAMA12GR, N8CAMA12AR, N8CAMA12KO, N8CAMA12KA, N8CAMA12LG, N8CAMA12TY, N8CAMA12BE, N8CALC13GR, N8CALC13AR, N8CALC13KO, N8CALC13KA, N8CALC13LG, N8CALC13TY, N8CALC13BE, N8CARP14GR, N8CARP14AR, N8CARP14KO, N8CARP14KA, N8CARP14LG, N8CARP14TY, N8CARP14BE, N8CALC15GR, N8CALC15AR, N8CALC15KO, N8CALC15KA, N8CALC15LG, N8CALC15TY, N8CALC15BE, N8CARIMGR, N8CARIMAR, N8CARIMKO, N8CARIMKA, N8CARIMLG, N8CARIMTY, N8CARIMBE, N8CAHKRBIN, N8CAHKVETY, N8CAHKVEOK, N8CALV_MOB, N8CALV_EF, N8CALV_WTE, N8CARV_MOB, N8CALVVPAS, N8CALVVPAD, N8CALVVOAS, N8CALVVOAD, N8CALVAPAS, N8CALVAPAD, N8CALVAPAM, N8CALVAOAS, N8CALVAOAD, N8CALVAOAM, N8CA_ANVEN, N8CARAAB, N8CARAAL, N8CARAAP, N8CARAIN, N8CARAPB, N8CALASE, N8CALAPL, N8CAHKRBVI, N8CAHKHAOK, N8CAHKVISH, N8CAHKHB, N8CA_PULS, N8CAHKO2, N8CAHKZVSO, N8CA_HMV, N8CA_HMVO, N8CA_TPRR, N8CA_TPRP, N8CA_PARR, N8CA_PARP, N8CA_SVRR, N8CA_SVRP, N8CA_TPGR, N8CA_TPGP, N8CA_TPGT, N8CALV_EDV, N8CALV_ESV, N8CALV_SV, N8CALVSVI, N8CALV_DVI, N8CALV_SVI, N8CA_CI, X00ALV_EF, N8CASHASD, N8CASHVSD, N8CASHVOLR, N8CASHVORL, N8CASHHMVG, N8CASHHMVK, N8CASHHMVE, N8CAAV_OK, N8CADAVGMX, N8CADAVGMN, N8CADAVSTE, N8CADAVINS, N8CAAVAREA, N8CAAVKALK, N8CAMV_OK, N8CADMVGMX, N8CADMVGMN, N8CADMVSTE, N8CADMVINS, N8CAMVAREA, N8CAMVKALK, N8CATV_OK, N8CADTVGMX, N8CADTVGMN, N8CADTVSTE, N8CADTVINS, N8CAPV_OK, N8CADPVGMX, N8CADPVGMN, N8CADPVSTE, N8CADPVINS, N8CAHKAADR, N8CAHKAADB, N8CAHKADDR, N8CAHKADDB, N8CAHKPADR, N8CAHKPADB, N8CAHKPCDR, N8CAHKPCDB, N8CAHKLADR, N8CAHKLADB, N8CAHKRADR, N8CAHKRADB, N8CAHKLVDR, N8CAHKLVDB, N8CAHKRVDR, N8CAHKRVDB, N8CAHKLVOR, N8CAHKLVOB, N8CAHKRVOR, N8CAHKRVOB, N8CAHDAADR, N8CAHDAADB, N8CAHDADDR, N8CAHDADDB, N8CAHDPADR, N8CAHDPADB, N8CAHDPCDR, N8CAHDPCDB, N8CAHDLADR, N8CAHDLADB, N8CAHDRADR, N8CAHDRADB, N8CAHDLVDR, N8CAHDLVDB, N8CAHDRVDR, N8CAHDRVDB, N8CAHDLVOR, N8CAHDLVOB, N8CAHDRVOR, N8CAHDRVOB, N8CAHMAADR, N8CAHMAADB, N8CAHMADDR, N8CAHMADDB, N8CAHMPADR, N8CAHMPADB, N8CAHMPCDR, N8CAHMPCDB, N8CAHMLADR, N8CAHMLADB, N8CAHMRADR, N8CAHMRADB, N8CAHMLVDR, N8CAHMLVDB, N8CAHMRVDR, N8CAHMRVDB, N8CAHMLVOR, N8CAHMLVOB, N8CAHMRVOR, N8CAHMRVOB, N8CAHKOXPT, N8CAHKOXPR, N8CAHKOXPL, N8CAHKOXRK, N8CAHKOXRV, N8CAHKOXIP, N8CAHKOXID, N8CAHKOXSP, N8CAHKOXSD, N8CAHKOXAT, N8CAHKOXLK, N8CAHKOXLV, N8CA_HTVIT, N8CAHKKS, N8CAHKLP, N8CAHKIN, N8CAHKAG, N8CAHKZN, N8CAHKZE, N8CAHKIH, N8CAHKA1, N8CAHKA2, N8CARESTXT, N8CARESUME, N8CAHKBETH, GSDKKOMPKT, X00KRESDAT, N8CARESDAT, GSDKRESGP, ISHMVMAKRZ, ISHMVMARNG, N8CARESNAM, ISHMVMAFAR, GSDKRESGP2, X00MVMAKRZ, X00MVMARNG, N8CARESNM2, X00MVMAFAR, N8CAL_VB, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG, N8CAXKEBE, N8CAANKA, N8CAANIN, N8CAANCB, N8CAANE4, N8CAANDM, N8CAANNI, N8CAANKS, N8CAANBI, N8CAANKD, N8CAANSS, N8CAANIK, N8CAANIP, N8CAPDNP, N8CAPDHI, N8CAPDKS, N8CAPDPR, N8CAPDNK, N8CAPDHD, N8CAPDND, N8CAPDTE, N8CAPDNI, N8CAPDPA, N8CAPDZE, N8CAPDBM, N8CAPDGV, N8CAPDHS, N8CAPDLG, N8CAPDKB, N8CAPDOS, N8CAPDSI, N8CAPDIK, N8CAPDKV, N8CAPDRE, N8CAPDTA, N8CAPDSO, N8CAPDET, N8CALV_PES, X00A_HKNR, N8CAKOMPKT FROM N2CA02

TOP ERP 6.0 | N2CA02 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	N8CAEXAROO	Cardiology: Examination Room	nvarchar	8	0	Allow NULL?
15	ISHMPATALT	Patient Age	nvarchar	3	0	Allow NULL?
16	N8CAPATALE	Unit of Age	char	1	0	Allow NULL?
17	X00KPATGEW	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
18	N8CAPATGEW	Body Weight in Kg	nvarchar	3	0	Allow NULL?
19	X00KPATGRO	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
20	N8CAPATGRO	Height in Cm	nvarchar	3	0	Allow NULL?
21	N8CAPATBMI	Cardiology: Body Mass Index (xx,y) kg/m2	decimal	3	1
22	N8CAPATBSA	Cardiology: Body Surface Area (x,yy) m2	decimal	3	2
23	N8CAANFVMA	Employee Responsible	nvarchar	10	0	Allow NULL?
24	N8CAANFDAT	IS-H: Date when Record Created	nvarchar	8	0	Allow NULL?
25	N8CAANFTIM	IS-H: Time Record Created	nvarchar	6	0	Allow NULL?
26	X00MKANAM	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
27	X00MFRGST	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
28	N8CAHKIND	Cardiology: Selection of Indication	nvarchar	60	0	Allow NULL?
29	N8CAPATEIN	Cardiology: Consent Exists?	char	1	0	Allow NULL?
30	N8CATSTUD	Cardiology: Study Participation	nvarchar	15	0	Allow NULL?
31	N8CA_HKNR	Cardiology: Cardiac Catheter Number	nvarchar	10	0	Allow NULL?
32	N8CA_NYHA	Cardiology: Fixed Values NYHA Classification	char	1	0	Allow NULL?
33	N8CA_CCS	Cardiology: Fixed Value CCS Status	char	1	0	Allow NULL?
34	N8CAXARTHY	Cardiology: Checkbox Art. Hypertension	char	1	0	Allow NULL?
35	N8CAXNICO	Cardiology: Checkbox Nicotine	char	1	0	Allow NULL?
36	N8CAXDIABM	Cardiology: Checkbox Diabetes Mellitus	char	1	0	Allow NULL?
37	N8CAXHYLIP	Cardiology: Checkbox Hyperlipidemia	char	1	0	Allow NULL?
38	N8CAXFAMA	Cardiology: Checkbox Family Anamnesis	char	1	0	Allow NULL?
39	N8CACAVSON	Cardiology: Other Cardiovascular Risk Factors	nvarchar	60	0	Allow NULL?
40	N8CAEXADAT	Cardiology: Date of Examination	nvarchar	8	0	Allow NULL?
41	N8CAEXATIM	Cardiology: Time of Examination	nvarchar	6	0	Allow NULL?
42	N8CAHK_DEV	Cardiology: Cardiac Catheter Device	nvarchar	40	0	Allow NULL?
43	N8CA_ANKOR	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
44	N8CAHBVERT	Cardiology: Fixed Values Coronary Angiogr. Supply Type	char	1	0	Allow NULL?
45	N8CAKOROOK	Cardiology: Checkbox Coronary Angiography Normal	char	1	0	Allow NULL?
46	N8CARC01GR	Cardiology: RCA-1 Stenosis Degree (Right Coronary Artery)	nvarchar	3	0	Allow NULL?
47	N8CARC01AR	Cardiology: RCA-1 Stenosis Area (Right Coronary Artery)	nvarchar	2	0	Allow NULL?
48	N8CARC01KO	Cardiology: RCA-1 Stenosis Collateral. (Right Coron. Art.)	char	1	0	Allow NULL?
49	N8CARC01KA	Cardiology: RCA-1 Stenosis Ca++ (Right Coron. Art.)	char	1	0	Allow NULL?
50	N8CARC01LG	Cardiology: RCA-1 Stenosis Length (Right Coron. Art.)	char	1	0	Allow NULL?
51	N8CARC01TY	Cardiology: RCA-1 Stenosis Type (Right Coronary Artery)	nvarchar	2	0	Allow NULL?
52	N8CARC01BE	Cardiology: RCA-1 Stenosis Comment (Right Coronary Artery)	nvarchar	60	0	Allow NULL?
53	N8CARC02GR	Cardiology: RCA-2 Stenosis Degree (Right Coronary Artery)	nvarchar	3	0	Allow NULL?
54	N8CARC02AR	Cardiology: RCA-2 Stenosis Area (Right Coronary Artery)	nvarchar	2	0	Allow NULL?
55	N8CARC02KO	Cardiology: RCA-2 Stenosis Collateral. (Right Coron. Art.)	char	1	0	Allow NULL?
56	N8CARC02KA	Cardiology: RCA-2 Stenosis Ca++ (Right Coron. Art.)	char	1	0	Allow NULL?
57	N8CARC02LG	Cardiology: RCA - 2 Stenosis Length (Right Coron. Art.)	char	1	0	Allow NULL?
58	N8CARC02TY	Cardiology: RCA-2 Stenosis Type (Right Coronary Artery)	nvarchar	2	0	Allow NULL?
59	N8CARC02BE	Cardiology: RCA-2 Stenosis Comment (Right Coronary Artery)	nvarchar	60	0	Allow NULL?
60	N8CARC03GR	Cardiology: RCA-3 Stenosis Degree (Right Coronary Artery)	nvarchar	3	0	Allow NULL?
61	N8CARC03AR	Cardiology: RCA - 3 Stenosis Area (Right Coronary Artery)	nvarchar	2	0	Allow NULL?
62	N8CARC03KO	Cardiology: RCA-3 Stenosis Collateral. (Right Coron. Art.)	char	1	0	Allow NULL?
63	N8CARC03KA	Cardiology: RCA-3 Stenosis CA++ (Right Coron. Art.)	char	1	0	Allow NULL?
64	N8CARC03LG	Cardiology: RCA - 3 Stenosis Length (Right Coron. Art.)	char	1	0	Allow NULL?
65	N8CARC03TY	Cardiology: RCA-3 Stenosis Type (Right Coronary Artery)	nvarchar	2	0	Allow NULL?
66	N8CARC03BE	Cardiology: RCA-3 Stenosis Comment (Right Coronary Artery)	nvarchar	60	0	Allow NULL?
67	N8CARC4AGR	Cardiology: RCA-4a Stenosis Degree (Right Coronary Artery)	nvarchar	3	0	Allow NULL?
68	N8CARC4AAR	Cardiology: RCA - 4a Stenosis Area (Right Coron. Artery)	nvarchar	2	0	Allow NULL?
69	N8CARC4AKO	Cardiology: RCA-4a Stenosis Collateral. (Right Coron. Art.)	char	1	0	Allow NULL?
70	N8CARC4AKA	Cardiology: RCA-4a Stenosis Ca++ (Right Coron. Art.)	char	1	0	Allow NULL?
71	N8CARC4ALG	Cardiology: RCA - 4a Stenosis Length (Right Coron. Art.)	char	1	0	Allow NULL?
72	N8CARC4ATY	Cardiology: RCA-4a Stenosis Type (Right Coronary Artery)	nvarchar	2	0	Allow NULL?
73	N8CARC4ABE	Cardiology: RCA-4a Stenosis Comment (Right Coron. Artery)	nvarchar	60	0	Allow NULL?
74	N8CARC4BGR	Cardiology: RCA-4b Stenosis Degree (Right Coronary Artery)	nvarchar	3	0	Allow NULL?
75	N8CARC4BAR	Cardiology: RCA - 4b Stenosis Area (Right Coron. Artery)	nvarchar	2	0	Allow NULL?
76	N8CARC4BKO	Cardiology: RCA-4b Stenosis Collateral. (Right Coron. Art.)	char	1	0	Allow NULL?
77	N8CARC4BKA	Cardiology: RCA-4b Stenosis Ca++ (Right Coron. Art.)	char	1	0	Allow NULL?
78	N8CARC4BLG	Cardiology: RCA - 4b Stenosis Length (Right Coron. Art.)	char	1	0	Allow NULL?
79	N8CARC4BTY	Cardiology: RCA-4b Stenosis Type (Right Coronary Artery)	nvarchar	2	0	Allow NULL?
80	N8CARC4BBE	Cardiology: RCA-4b Stenosis Comment (Right Coron. Artery)	nvarchar	60	0	Allow NULL?
81	N8CALM05GR	Cardiology: LM - 5 Stenosis Degree (Left Main Stem)	nvarchar	3	0	Allow NULL?
82	N8CALM05AR	Cardiology: LM - 5 Stenosis Area (Left Main Stem)	nvarchar	2	0	Allow NULL?
83	N8CALM05KO	Cardiology: LM - 5 Stenosis Collateral. (Left Main Stem)	char	1	0	Allow NULL?
84	N8CALM05KA	Cardiology: LM - 5 Stenosis Ca++ (Left Main Stem)	char	1	0	Allow NULL?
85	N8CALM05LG	Cardiology: LM - 5 Stenosis Length (Left Main Stem)	char	1	0	Allow NULL?
86	N8CALM05TY	Cardiology: LM - 5 Stenosis Type (Left Main Stem)	nvarchar	2	0	Allow NULL?
87	N8CALM05BE	Cardiology: LM - 5 Stenosis Comment (Left Main Stem)	nvarchar	60	0	Allow NULL?
88	N8CALA06GR	Cardiology: LAD - 6 Stenosis Degree (Left Anterior Desc.)	nvarchar	3	0	Allow NULL?
89	N8CALA06AR	Cardiology: LAD - 6 Stenosis Area (Left Anterior Desc.)	nvarchar	2	0	Allow NULL?
90	N8CALA06KO	Cardiology: LAD - 6 Stenosis Collateral. (Left Ant. Desc)	char	1	0	Allow NULL?
91	N8CALA06KA	Cardiology: LAD - 6 Stenosis Ca++ (Left Anterior Desc.)	char	1	0	Allow NULL?
92	N8CALA06LG	Cardiology: LAD - 6 Stenosis Length (Left Anterior Desc.)	char	1	0	Allow NULL?
93	N8CALA06TY	Cardiology: LAD - 6 Stenosis Type (Left Anterior Desc)	nvarchar	2	0	Allow NULL?
94	N8CALA06BE	Cardiology: LAD - 6 Stenosis Comment (Left Anterior Desc.)	nvarchar	60	0	Allow NULL?
95	N8CALA07GR	Cardiology: LAD - 7 Stenosis Degree (Left Anterior Desc.)	nvarchar	3	0	Allow NULL?
96	N8CALA07AR	Cardiology: LAD - 7 Stenosis Area (Left Anterior Desc.)	nvarchar	2	0	Allow NULL?
97	N8CALA07KO	Cardiology: LAD - 7 Stenosis Collateral. (Left Ant. Desc)	char	1	0	Allow NULL?
98	N8CALA07KA	Cardiology: LAD - 7 Stenosis Ca++ (Left Anterior Desc.)	char	1	0	Allow NULL?
99	N8CALA07LG	Cardiology: LAD - 7 Stenosis Length (Left Anterior Desc.)	char	1	0	Allow NULL?
100	N8CALA07TY	Cardiology: LAD - 7 Stenosis Type (Left Anterior Desc)	nvarchar	2	0	Allow NULL?
101	N8CALA07BE	Cardiology: LAD - 7 Stenosis Comment (Left Anterior Desc.)	nvarchar	60	0	Allow NULL?
102	N8CALA08GR	Cardiology: LAD - 8 Degree of Stenosis (Left Anterior Desc.)	nvarchar	3	0	Allow NULL?
103	N8CALA08AR	Cardiology: LAD - 8 Stenosis Area (Left Anterior Desc.)	nvarchar	2	0	Allow NULL?
104	N8CALA08KO	Cardiology: LAD - 8 Stenosis Collateral. (Left Ant. Desc)	char	1	0	Allow NULL?
105	N8CALA08KA	Cardiology: LAD - 8 Stenosis Ca++ (Left Anterior Desc.)	char	1	0	Allow NULL?
106	N8CALA08LG	Cardiology: LAD - 8 Stenosis Length (Left Anterior Desc.)	char	1	0	Allow NULL?
107	N8CALA08TY	Cardiology: LAD - 8 Stenosis Type (Left Anterior Desc)	nvarchar	2	0	Allow NULL?
108	N8CALA08BE	Cardiology: LAD - 8 Stenosis Comment (Left Anterior Desc.)	nvarchar	60	0	Allow NULL?
109	N8CADI09GR	Cardiology: DIAG1 - 9 Stenosis Degree (Ramus Diagonalis 1)	nvarchar	3	0	Allow NULL?
110	N8CADI09AR	Cardiology: DIAG1 - 9 Stenosis Area (Ramus Diagonalis 1)	nvarchar	2	0	Allow NULL?
111	N8CADI09KO	Cardiology: DIAG1 - 9 Stenosis Collateral. (Ramus Diagon. 1)	char	1	0	Allow NULL?
112	N8CADI09KA	Cardiology: DIAG1 - 9 Stenosis Calc. (Ramus Diagonalis 1)	char	1	0	Allow NULL?
113	N8CADI09LG	Cardiology: DIAG1 - 9 Stenosis Length (Ramus Diagonalis 1)	char	1	0	Allow NULL?
114	N8CADI09TY	Cardiology: DIAG1 - 9 Stenosis Type (Ramus Diagonalis 1)	nvarchar	2	0	Allow NULL?
115	N8CADI09BE	Cardiology: DIAG1 - 9 Stenosis Comment (Ramus Diagon. 1)	nvarchar	60	0	Allow NULL?
116	N8CADI10GR	Cardiology: DIAG2 - 10 Stenosis Degree (Ramus Diagonalis 2)	nvarchar	3	0	Allow NULL?
117	N8CADI10AR	Cardiology: DIAG2 - 10 Stenosis Area (Ramus Diagonalis 2)	nvarchar	2	0	Allow NULL?
118	N8CADI10KO	Cardiology: DIAG2 -10 Stenosis Collateral. (Ramus Diagon. 2)	char	1	0	Allow NULL?
119	N8CADI10KA	Cardiology: DIAG2 -10 Stenosis Calc. (Ramus Diagonalis 2)	char	1	0	Allow NULL?
120	N8CADI10LG	Cardiology: DIAG2 -10 Stenosis Length (Ramus Diagonalis 2)	char	1	0	Allow NULL?
121	N8CADI10TY	Cardiology: DIAG2 -10 Stenosis Type (Ramus Diagonalis 2)	nvarchar	2	0	Allow NULL?
122	N8CADI10BE	Cardiology: DIAG2 - 10 Stenosis Comment (Ramus Diagon. 2)	nvarchar	60	0	Allow NULL?
123	N8CALC11GR	Cardiology: LCX - 11 Stenosis Degree (Left Circumflex)	nvarchar	3	0	Allow NULL?
124	N8CALC11AR	Cardiology: LCX - 11 Stenosis Area (Left Circumflex)	nvarchar	2	0	Allow NULL?
125	N8CALC11KO	Cardiology: LCX - 11 Stenosis Collateral. (Left Circumflex)	char	1	0	Allow NULL?
126	N8CALC11KA	Cardiology: LCX - 11 Stenosis Ca++ (Left Circumflex)	char	1	0	Allow NULL?
127	N8CALC11LG	Cardiology: LCX - 11 Stenosis Length (Left Circumflex)	char	1	0	Allow NULL?
128	N8CALC11TY	Cardiology: LCX - 11 Stenosis Type (Left Circumflex)	nvarchar	2	0	Allow NULL?
129	N8CALC11BE	Cardiology: LCX - 11 Stenosis Comment (Left Circumflex)	nvarchar	60	0	Allow NULL?
130	N8CAMA12GR	Cardiology: MARG - 12 Stenosis Degree (Ramus Marginalis)	nvarchar	3	0	Allow NULL?
131	N8CAMA12AR	Cardiology: MARG - 12 Stenosis Area (Ramus Marginalis)	nvarchar	2	0	Allow NULL?
132	N8CAMA12KO	Cardiology: MARG - 12 Stenosis Collateral. (Ramus Marginal.)	char	1	0	Allow NULL?
133	N8CAMA12KA	Cardiology: MARG - 12 Stenosis Ca++ (Ramus Marginalis)	char	1	0	Allow NULL?
134	N8CAMA12LG	Cardiology: MARG - 12 Stenosis Length (Ramus Marginalis)	char	1	0	Allow NULL?
135	N8CAMA12TY	Cardiology: MARG - 12 Stenosis Type (Ramus Marginalis)	nvarchar	2	0	Allow NULL?
136	N8CAMA12BE	Cardiology: MARG - 12 Stenosis Comment (Ramus Marginalis)	nvarchar	60	0	Allow NULL?
137	N8CALC13GR	CKardiology: LCX - 13 Stenosis Degree (Left Circumflex)	nvarchar	3	0	Allow NULL?
138	N8CALC13AR	Cardiology: LCX - 13 Stenosis Area (Left Circumflex)	nvarchar	2	0	Allow NULL?
139	N8CALC13KO	Cardiology: LCX - 13 Stenosis Collateral. (Left Circumflex)	char	1	0	Allow NULL?
140	N8CALC13KA	Cardiology: LCX - 13 Stenosis Ca++ (Left Circumflex)	char	1	0	Allow NULL?
141	N8CALC13LG	Cardiology: LCX - 13 Stenosis Length (Left Circumflex)	char	1	0	Allow NULL?
142	N8CALC13TY	Cardiology: LCX - 13 Stenosis Type (Left Circumflex)	nvarchar	2	0	Allow NULL?
143	N8CALC13BE	Cardiology: LCX - 13 Stenosis Comment (Left Circumflex)	nvarchar	60	0	Allow NULL?
144	N8CARP14GR	Cardiology: RPLS - 14 Stenosis Degree(Ramus Poster. Sinist.)	nvarchar	3	0	Allow NULL?
145	N8CARP14AR	Cardiology: RPLS -14 Stenosis Area (Ramus Poster. Sinis.)	nvarchar	2	0	Allow NULL?
146	N8CARP14KO	Cardiology: RPLS 14 Stenos. Collat. (Ramus Poster. Sinis.)	char	1	0	Allow NULL?
147	N8CARP14KA	Cardiology: RPLS - 14 Stenosis Ca++ (Ramus Poster. Sinis.)	char	1	0	Allow NULL?
148	N8CARP14LG	Cardiology: RPLS - 14 Stenosis Length (Ramus Poster. Sinis.)	char	1	0	Allow NULL?
149	N8CARP14TY	Cardiology: RPLS - 14 Stenosis Type (Ramus Poster. Sinis.)	nvarchar	2	0	Allow NULL?
150	N8CARP14BE	Cardiology: RPLS -14 Stenosis Comment (Ramus Poster. Sin.)	nvarchar	60	0	Allow NULL?
151	N8CALC15GR	Cardiology: LCX - 15 Stenosis Degree (Left Circumflex)	nvarchar	3	0	Allow NULL?
152	N8CALC15AR	Cardiology: LCX - 15 Stenosis Area (Left Circumflex)	nvarchar	2	0	Allow NULL?
153	N8CALC15KO	Cardiology: LCX - 15 Stenosis Collateral. (Left Circumflex)	char	1	0	Allow NULL?
154	N8CALC15KA	Cardiology: LCX - 15 Stenosis Ca++ (Left Circumflex)	char	1	0	Allow NULL?
155	N8CALC15LG	Cardiology: LCX - 15 Stenosis Length (Left Circumflex)	char	1	0	Allow NULL?
156	N8CALC15TY	Cardiology: LCX - 15 Stenosis Type (Left Circumflex)	nvarchar	2	0	Allow NULL?
157	N8CALC15BE	Cardiology: LCX - 15 Stenosis Comment (Left Circumflex)	nvarchar	60	0	Allow NULL?
158	N8CARIMGR	Cardiology: RIM Stenosis Degree (Ramus Intermedius)	nvarchar	3	0	Allow NULL?
159	N8CARIMAR	Cardiology: RIM Stenosis Area (Ramus Intermedius)	nvarchar	2	0	Allow NULL?
160	N8CARIMKO	Cardiology: RIM Stenosis Collateralis. (Ramus Intermedius)	char	1	0	Allow NULL?
161	N8CARIMKA	Cardiology: RIM Stenosis Ca++ (Ramus Intermedius)	char	1	0	Allow NULL?
162	N8CARIMLG	Cardiology: RIM Stenosis Length (Ramus Intermedius)	char	1	0	Allow NULL?
163	N8CARIMTY	Cardiology: RIM Stenosis Type (Ramus Intermedius)	nvarchar	2	0	Allow NULL?
164	N8CARIMBE	Cardiology: RIM Stenosis Comment (Ramus Intermedius)	nvarchar	60	0	Allow NULL?
165	N8CAHKRBIN	Cardiology: Fixed Values Type Intervention	char	1	0	Allow NULL?
166	N8CAHKVETY	Cardiology: Fixed Values Type Ventriculography	nvarchar	2	0	Allow NULL?
167	N8CAHKVEOK	Cardiology: Checkbox Ventriculography Non-Pathological	char	1	0	Allow NULL?
168	N8CALV_MOB	Cardiology: Left Ventricle Global Mobility	char	1	0	Allow NULL?
169	N8CALV_EF	Cardiology: LV Ejection Fraction (%)	nvarchar	2	0	Allow NULL?
170	N8CALV_WTE	Cardiology: End-Diastolic Wall Thickness (mm)	nvarchar	2	0	Allow NULL?
171	N8CARV_MOB	Cardiology: Right Ventricle Global Mobility	char	1	0	Allow NULL?
172	N8CALVVPAS	Cardiology: Systolic Blood Pressure (mmHg)	nvarchar	3	0	Allow NULL?
173	N8CALVVPAD	Cardiology: Pre-Angio LVEDP	nvarchar	2	0	Allow NULL?
174	N8CALVVOAS	Cardiology: Systolic Blood Pressure (mmHg)	nvarchar	3	0	Allow NULL?
175	N8CALVVOAD	Cardiology: Post Angio LVEDP	nvarchar	2	0	Allow NULL?
176	N8CALVAPAS	Cardiology: Systolic Blood Pressure (mmHg)	nvarchar	3	0	Allow NULL?
177	N8CALVAPAD	Cardiology: Diastolic Blood Pressure (mmHg)	nvarchar	3	0	Allow NULL?
178	N8CALVAPAM	Cardiology: Blood Pressure Mean Pressure (mmHg)	nvarchar	3	0	Allow NULL?
179	N8CALVAOAS	Cardiology: Systolic Blood Pressure (mmHg)	nvarchar	3	0	Allow NULL?
180	N8CALVAOAD	Cardiology: Diastolic Blood Pressure (mmHg)	nvarchar	3	0	Allow NULL?
181	N8CALVAOAM	Cardiology: Blood Pressure Mean Pressure (mmHg)	nvarchar	3	0	Allow NULL?
182	N8CA_ANVEN	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
183	N8CARAAB	Cardiology: Ventriculogr. RAO 1 - Anterobasal	char	1	0	Allow NULL?
184	N8CARAAL	Cardiology: Ventriculogr. RAO 2 - Anterolateral	char	1	0	Allow NULL?
185	N8CARAAP	Cardiology: Ventriculogr. RAO 3 - Apical	char	1	0	Allow NULL?
186	N8CARAIN	Cardiology: Ventriculogr. RAO 4 - Inferior	char	1	0	Allow NULL?
187	N8CARAPB	Cardiology: Ventriculogr. RAO 5 - Posterobasal	char	1	0	Allow NULL?
188	N8CALASE	Cardiology: Ventriculogr. LAO 6 - Septal	char	1	0	Allow NULL?
189	N8CALAPL	Cardiology: Ventriculogr. LAO 7 - Posterolateral	char	1	0	Allow NULL?
190	N8CAHKRBVI	Cardiology: Fixed Values Type Hemodynamics	nvarchar	2	0	Allow NULL?
191	N8CAHKHAOK	Cardiology: Checkbox Hemodynamics Non-Pathological	char	1	0	Allow NULL?
192	N8CAHKVISH	Cardiology: Fixed Values Shunt	nvarchar	2	0	Allow NULL?
193	N8CAHKHB	Cardiology: Hemoglobin Value (g/dl) (Directly Determined)	decimal	3	1
194	N8CA_PULS	Cardiology: Heart Rate / Min.	nvarchar	3	0	Allow NULL?
195	N8CAHKO2	Cardiology: Oxygen Conxumption : BSA * 125ml	decimal	5	2
196	N8CAHKZVSO	Cardiology: Central Venous Oxygen Saturation	nvarchar	3	0	Allow NULL?
197	N8CA_HMV	Cardiology: Cardiac Output (l/min)	decimal	4	2
198	N8CA_HMVO	Cardiology: Cardiac Output (l/min) over Oxygen	decimal	4	2
199	N8CA_TPRR	Cardiology: Total Peripheral Resistance (TPR) Resting	nvarchar	4	0	Allow NULL?
200	N8CA_TPRP	Cardiology: Total Peripheral Resistance (TPR) Post	nvarchar	4	0	Allow NULL?
201	N8CA_PARR	Cardiology: Pulmonary Arteriolar Resistance (PAR) Resting	nvarchar	4	0	Allow NULL?
202	N8CA_PARP	Cardiology: Pulmonary Arteriolar Resistance (PAR) Post	nvarchar	4	0	Allow NULL?
203	N8CA_SVRR	Cardiology: Systemic Vascular Resistance (SVR) Resting	nvarchar	4	0	Allow NULL?
204	N8CA_SVRP	Cardiology: Systemic Vascular Resistance (SVR) Post	nvarchar	4	0	Allow NULL?
205	N8CA_TPGR	Cardiology: Transpulmonary Gradient (TPG) Resting	nvarchar	3	0	Allow NULL?
206	N8CA_TPGP	Cardiology: Transpulmonary Gradient (TPG) Post	nvarchar	3	0	Allow NULL?
207	N8CA_TPGT	Cardiology: Transpulmonary Gradient (TPG) After Therapy	nvarchar	3	0	Allow NULL?
208	N8CALV_EDV	Cardiology: LV End-Diast. Volume (EDV)	nvarchar	3	0	Allow NULL?
209	N8CALV_ESV	Cardiology: LV End-Syst. Volume (ESV)	nvarchar	3	0	Allow NULL?
210	N8CALV_SV	Cardiology: LV Stroke Volume in ml	nvarchar	3	0	Allow NULL?
211	N8CALVSVI	Cardiology: LV Stroke Volume Index in ml/m2	decimal	4	1
212	N8CALV_DVI	Cardiology: End-Diastolic Volume Index (ml/m2)	decimal	4	1
213	N8CALV_SVI	Cardiology: LV End-Systolic Volume Index (ml/m2)	decimal	4	1
214	N8CA_CI	Cardiology: Cardiac Index [l / (min/m2)]	decimal	2	1
215	X00ALV_EF	Cardiology: LV Ejection Fraction (%)	nvarchar	2	0	Allow NULL?
216	N8CASHASD	Cardiology: Shunts Checkbox ASD	char	1	0	Allow NULL?
217	N8CASHVSD	Cardiology Shunts Checkbox VSD	char	1	0	Allow NULL?
218	N8CASHVOLR	Cardiology: Shunt Vitien Volume Left/Right	nvarchar	3	0	Allow NULL?
219	N8CASHVORL	Cardiology: Shunt Vitien Volume Right>Left	nvarchar	3	0	Allow NULL?
220	N8CASHHMVG	Cardiology: Shunts CO (Gr. Circ)	decimal	4	2
221	N8CASHHMVK	Cardiology: Shunts CO (Ls. Circ)	decimal	4	2
222	N8CASHHMVE	Cardiology: Shunts Eff. CO	decimal	4	2
223	N8CAAV_OK	Cardiology: Cardiac Valve - Normal	char	1	0	Allow NULL?
224	N8CADAVGMX	Cardiology: Maximum Gradient (mmHg)	nvarchar	3	0	Allow NULL?
225	N8CADAVGMN	Cardiology: Median Gradient (mmHg)	nvarchar	3	0	Allow NULL?
226	N8CADAVSTE	Cardiology: Cardiac Valve Degree of Stenosis	char	1	0	Allow NULL?
227	N8CADAVINS	Cardiology: Cardiac Valve Degree of Insufficiency	char	1	0	Allow NULL?
228	N8CAAVAREA	Cardiology: Cardiac Valve - Opening Area (cm2)	decimal	3	2
229	N8CAAVKALK	Cardiology: Aortic Valve Ca++	char	1	0	Allow NULL?
230	N8CAMV_OK	Cardiology: Cardiac Valve - Normal	char	1	0	Allow NULL?
231	N8CADMVGMX	Cardiology: Maximum Gradient (mmHg)	nvarchar	3	0	Allow NULL?
232	N8CADMVGMN	Cardiology: Median Gradient (mmHg)	nvarchar	3	0	Allow NULL?
233	N8CADMVSTE	Cardiology: Cardiac Valve Degree of Stenosis	char	1	0	Allow NULL?
234	N8CADMVINS	Cardiology: Cardiac Valve Degree of Insufficiency	char	1	0	Allow NULL?
235	N8CAMVAREA	Cardiology: Cardiac Valve - Opening Area (cm2)	decimal	3	2
236	N8CAMVKALK	Cardiology: Mitral Valve Calc	char	1	0	Allow NULL?
237	N8CATV_OK	Cardiology: Cardiac Valve - Normal	char	1	0	Allow NULL?
238	N8CADTVGMX	Cardiology: Maximum Gradient (mmHg)	nvarchar	3	0	Allow NULL?
239	N8CADTVGMN	Cardiology: Median Gradient (mmHg)	nvarchar	3	0	Allow NULL?
240	N8CADTVSTE	Cardiology: Cardiac Valve Degree of Stenosis	char	1	0	Allow NULL?
241	N8CADTVINS	Cardiology: Cardiac Valve Degree of Insufficiency	char	1	0	Allow NULL?
242	N8CAPV_OK	Cardiology: Cardiac Valve - Normal	char	1	0	Allow NULL?
243	N8CADPVGMX	Cardiology: Maximum Gradient (mmHg)	nvarchar	3	0	Allow NULL?
244	N8CADPVGMN	Cardiology: Median Gradient (mmHg)	nvarchar	3	0	Allow NULL?
245	N8CADPVSTE	Cardiology: Cardiac Valve Degree of Stenosis	char	1	0	Allow NULL?
246	N8CADPVINS	Cardiology: Cardiac Valve Degree of Insufficiency	char	1	0	Allow NULL?
247	N8CAHKAADR	Cardiology: Vitien Aorta Asc. Pressure Resting (mmHg)	decimal	3	0
248	N8CAHKAADB	Cardiology: Vitien Aorta Asc. Pressure Condition (mmHg)	decimal	3	0
249	N8CAHKADDR	Cardiology: Vitien Aorta Desc. Pressure Resting (mmHg)	decimal	3	0
250	N8CAHKADDB	Cardiology: Vitien Aorta Desc. Pressure Condition (mmHg)	decimal	3	0
251	N8CAHKPADR	Cardiology: Vitien Pulmonary Artery Pressure Resting	decimal	3	0
252	N8CAHKPADB	Cardiology: Vitien Pulmonary Artery Pressure Condition	decimal	3	0
253	N8CAHKPCDR	Cardiology: Pulmonary Valve Pressure Resting (mmHg)	decimal	3	0
254	N8CAHKPCDB	Cardiology: Vitien Pulmonary Valve Pressure Condition (mmHg)	decimal	3	0
255	N8CAHKLADR	Cardiology: Vitien Left Atrium. Pressure Resting (mmHg)	decimal	3	0
256	N8CAHKLADB	Cardiology: Vitien Left Atrium Pressure Condition (mmHg)	decimal	3	0
257	N8CAHKRADR	Cardiology: Vitien Right Atrium Pressure Resting	decimal	3	0
258	N8CAHKRADB	Cardiology: Vitien Right Atrium Pressure Condition (mmHg)	decimal	3	0
259	N8CAHKLVDR	Cardiology: Vitien Left Chamber Pressure Resting (mmHg)	decimal	3	0
260	N8CAHKLVDB	Cardiology: Vitien Left Chamber Pressure Condition (mmHg)	decimal	3	0
261	N8CAHKRVDR	Cardiology: Vitien Right Chamber Pressure Resting (mmHg)	decimal	3	0
262	N8CAHKRVDB	Cardiology: Vitien Right Chamber Pressure Condition (mmHg)	decimal	3	0
263	N8CAHKLVOR	Cardiology: Vitien LV Outflow Tract Pressure Resting (mmHg)	decimal	3	0
264	N8CAHKLVOB	Cardiology: Vitien LVOT Pressure Condition (mmHg)	decimal	3	0
265	N8CAHKRVOR	Cardiology: Vitien RV Outflow Tract Pressure Resting (mmHg)	decimal	3	0
266	N8CAHKRVOB	Cardiology: Vitien RV Outflow Tract Pressure Condit. (mmHg)	decimal	3	0
267	N8CAHDAADR	Cardiology: Vitien Aorta Asc. Pressure Resting (mmHg)	decimal	3	0
268	N8CAHDAADB	Cardiology: Vitien Aorta Asc. Pressure Condition (mmHg)	decimal	3	0
269	N8CAHDADDR	Cardiology: Vitien Aorta Desc. Pressure Resting (mmHg)	decimal	3	0
270	N8CAHDADDB	Cardiology: Vitien Aorta Desc. Pressure Condition (mmHg)	decimal	3	0
271	N8CAHDPADR	Cardiology: Vitien Pulmonary Artery Pressure Resting	decimal	3	0
272	N8CAHDPADB	Cardiology: Vitien Pulmonary Artery Pressure Condition	decimal	3	0
273	N8CAHDPCDR	Cardiology: Pulmonary Valve Pressure Resting (mmHg)	decimal	3	0
274	N8CAHDPCDB	Cardiology: Vitien Pulmonary Valve Pressure Condition (mmHg)	decimal	3	0
275	N8CAHDLADR	Cardiology: Vitien Left Atrium. Pressure Resting (mmHg)	decimal	3	0
276	N8CAHDLADB	Cardiology: Vitien Left Atrium Pressure Condition (mmHg)	decimal	3	0
277	N8CAHDRADR	Cardiology: Vitien Right Atrium Pressure Resting	decimal	3	0
278	N8CAHDRADB	Cardiology: Vitien Right Atrium Pressure Condition (mmHg)	decimal	3	0
279	N8CAHDLVDR	Cardiology: Vitien Left Chamber Pressure Resting (mmHg)	decimal	3	0
280	N8CAHDLVDB	Cardiology: Vitien Left Chamber Pressure Condition (mmHg)	decimal	3	0
281	N8CAHDRVDR	Cardiology: Vitien Right Chamber Pressure Resting (mmHg)	decimal	3	0
282	N8CAHDRVDB	Cardiology: Vitien Right Chamber Pressure Condition (mmHg)	decimal	3	0
283	N8CAHDLVOR	Cardiology: Vitien LV Outflow Tract Pressure Resting (mmHg)	decimal	3	0
284	N8CAHDLVOB	Cardiology: Vitien LVOT Pressure Condition (mmHg)	decimal	3	0
285	N8CAHDRVOR	Cardiology: Vitien RV Outflow Tract Pressure Resting (mmHg)	decimal	3	0
286	N8CAHDRVOB	Cardiology: Vitien RV Outflow Tract Pressure Condit. (mmHg)	decimal	3	0
287	N8CAHMAADR	Cardiology: Vitien Aorta Asc. Pressure Resting (mmHg)	decimal	3	0
288	N8CAHMAADB	Cardiology: Vitien Aorta Asc. Pressure Condition (mmHg)	decimal	3	0
289	N8CAHMADDR	Cardiology: Vitien Aorta Desc. Pressure Resting (mmHg)	decimal	3	0
290	N8CAHMADDB	Cardiology: Vitien Aorta Desc. Pressure Condition (mmHg)	decimal	3	0
291	N8CAHMPADR	Cardiology: Vitien Pulmonary Artery Pressure Resting	decimal	3	0
292	N8CAHMPADB	Cardiology: Vitien Pulmonary Artery Pressure Condition	decimal	3	0
293	N8CAHMPCDR	Cardiology: Pulmonary Valve Pressure Resting (mmHg)	decimal	3	0
294	N8CAHMPCDB	Cardiology: Vitien Pulmonary Valve Pressure Condition (mmHg)	decimal	3	0
295	N8CAHMLADR	Cardiology: Vitien Left Atrium. Pressure Resting (mmHg)	decimal	3	0
296	N8CAHMLADB	Cardiology: Vitien Left Atrium Pressure Condition (mmHg)	decimal	3	0
297	N8CAHMRADR	Cardiology: Vitien Right Atrium Pressure Resting	decimal	3	0
298	N8CAHMRADB	Cardiology: Vitien Right Atrium Pressure Condition (mmHg)	decimal	3	0
299	N8CAHMLVDR	Cardiology: Vitien Left Chamber Pressure Resting (mmHg)	decimal	3	0
300	N8CAHMLVDB	Cardiology: Vitien Left Chamber Pressure Condition (mmHg)	decimal	3	0
301	N8CAHMRVDR	Cardiology: Vitien Right Chamber Pressure Resting (mmHg)	decimal	3	0
302	N8CAHMRVDB	Cardiology: Vitien Right Chamber Pressure Condition (mmHg)	decimal	3	0
303	N8CAHMLVOR	Cardiology: Vitien LV Outflow Tract Pressure Resting (mmHg)	decimal	3	0
304	N8CAHMLVOB	Cardiology: Vitien LVOT Pressure Condition (mmHg)	decimal	3	0
305	N8CAHMRVOR	Cardiology: Vitien RV Outflow Tract Pressure Resting (mmHg)	decimal	3	0
306	N8CAHMRVOB	Cardiology: Vitien RV Outflow Tract Pressure Condit. (mmHg)	decimal	3	0
307	N8CAHKOXPT	Cardiology: Oxygen Saturation (%) Pulmonary Art. - Trunc	nvarchar	3	0	Allow NULL?
308	N8CAHKOXPR	Cardio: Oxygen Saturation (%) Pulmonary Art. Right Branch	nvarchar	3	0	Allow NULL?
309	N8CAHKOXPL	Cardio: Oxygen Saturation (%) Pulmonary Artery Left Branch	nvarchar	3	0	Allow NULL?
310	N8CAHKOXRK	Cardiology: Oxygen Saturation (%) Right Chamber	nvarchar	3	0	Allow NULL?
311	N8CAHKOXRV	Cardiology: Oxygen Saturation (%) Right Atrium	nvarchar	3	0	Allow NULL?
312	N8CAHKOXIP	Cardiology: Oxygen Saturation (%) Vena Cava Infer. Prox.	nvarchar	3	0	Allow NULL?
313	N8CAHKOXID	Cardiology: Oxygen Saturation (%) Vena Cava Inf. Distal	nvarchar	3	0	Allow NULL?
314	N8CAHKOXSP	Cardiology: Oxygen Saturation (%) Vena Cava Super. Prox.	nvarchar	3	0	Allow NULL?
315	N8CAHKOXSD	Cardiology: Oxygen Saturation (%) Vena Cava Super. Dist.	nvarchar	3	0	Allow NULL?
316	N8CAHKOXAT	Cardiology: Oxygen Saturation (%) Aorta - Truncus	nvarchar	3	0	Allow NULL?
317	N8CAHKOXLK	Cardiology: Oxygen Saturation (%) Left Chamber	nvarchar	3	0	Allow NULL?
318	N8CAHKOXLV	Cardiology: Oxygen Saturation (%) Left Atrium	nvarchar	3	0	Allow NULL?
319	N8CA_HTVIT	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
320	N8CAHKKS	Cardiology: Coronary Status	nvarchar	15	0	Allow NULL?
321	N8CAHKLP	Cardiology: LV Pump Function	nvarchar	15	0	Allow NULL?
322	N8CAHKIN	Cardiology: Intervention	nvarchar	15	0	Allow NULL?
323	N8CAHKAG	Cardiology: Acute Activity	nvarchar	15	0	Allow NULL?
324	N8CAHKZN	Cardiology: Condition After	nvarchar	15	0	Allow NULL?
325	N8CAHKZE	Cardiology: Condition After Other Card. Disease	nvarchar	15	0	Allow NULL?
326	N8CAHKIH	Cardiology: Intervention Hist.	nvarchar	15	0	Allow NULL?
327	N8CAHKA1	Cardiology: Other (1)	nvarchar	15	0	Allow NULL?
328	N8CAHKA2	Cardiology: Other (2)	nvarchar	15	0	Allow NULL?
329	N8CARESTXT	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
330	N8CARESUME	PMD: Reference by GUUID	nvarchar	32	0	Allow NULL?
331	N8CAHKBETH	Cardiology: Therapy Recommendation	char	1	0	Allow NULL?
332	GSDKKOMPKT	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
333	X00KRESDAT	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
334	N8CARESDAT	Cardiology: Date of Findings	nvarchar	8	0	Allow NULL?
335	GSDKRESGP	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
336	ISHMVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
337	ISHMVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
338	N8CARESNAM	Cardiology: Name of Findings Creator	nvarchar	40	0	Allow NULL?
339	ISHMVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
340	GSDKRESGP2	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
341	X00MVMAKRZ	Employee Responsible	nvarchar	10	0	Allow NULL?
342	X00MVMARNG	IS-H: Texts for ranks	nvarchar	15	0	Allow NULL?
343	N8CARESNM2	Cardiology: Name of Supervisor	nvarchar	40	0	Allow NULL?
344	X00MVMAFAR	IS-H: Name of Specialty	nvarchar	30	0	Allow NULL?
345	N8CAL_VB	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
346	N8CA_XDAT	Cardiology: Checkbox Data Was Imported	char	1	0	Allow NULL?
347	N8CA_EINRI	Institution	nvarchar	4	0	Allow NULL?
348	N8CA_SDEST	Symbolic Destination	nvarchar	8	0	Allow NULL?
349	N8CA_STUDA	Examination Date	nvarchar	8	0	Allow NULL?
350	N8CA_PATNR	IS-H: Patient Number	nvarchar	10	0	Allow NULL?
351	N8CA_UID	Character UID	nvarchar	32	0	Allow NULL?
352	N8CA_DFLAG	Data Flag Import OK	char	1	0	Allow NULL?
353	N8CAXKEBE	Cardiology: Checkbox no Cardiovascular Risks Known	char	1	0	Allow NULL?
354	N8CAANKA	Cardiology: Condition After Coronary Angiography	char	1	0	Allow NULL?
355	N8CAANIN	Cardiology: Condition After Intervention	char	1	0	Allow NULL?
356	N8CAANCB	Cardiology: Condition After Coronary Bypass Surgery	char	1	0	Allow NULL?
357	N8CAANE4	Cardiology: QA Ejection Fraction Under 40%	char	1	0	Allow NULL?
358	N8CAANDM	Cardiology: Diabetes Mellitus	char	1	0	Allow NULL?
359	N8CAANNI	Cardiology: Renal Insufficiency	char	1	0	Allow NULL?
360	N8CAANKS	Cardiology: Acute Coronary Syndrome	char	1	0	Allow NULL?
361	N8CAANBI	Cardiology: Stress Ischemia	char	1	0	Allow NULL?
362	N8CAANKD	Cardiology: Cardiac Dyspnoea	char	1	0	Allow NULL?
363	N8CAANSS	Cardiology: Anamnesis Data Other Symptoms	char	1	0	Allow NULL?
364	N8CAANIK	Cardiology: QA Indication Coronary Angiograghy	nvarchar	2	0	Allow NULL?
365	N8CAANIP	Cardiology: QA Indication PCI	char	1	0	Allow NULL?
366	N8CAPDNP	Cardiology: What Number Procedure of this Stay	nvarchar	2	0	Allow NULL?
367	N8CAPDHI	Cardiology: Manifest Cardiac Insufficiency Before Procedure	char	1	0	Allow NULL?
368	N8CAPDKS	Cardiology: Cardiogenic Shock at Start of Procedure	char	1	0	Allow NULL?
369	N8CAPDPR	Cardiology: Procedure Type	char	1	0	Allow NULL?
370	N8CAPDNK	Cardiology: What Number Diagnostic Coronary Angio of Stay	nvarchar	2	0	Allow NULL?
371	N8CAPDHD	Cardio: Principal Diagbnosis After Diagnostic Cardiac Cath.	nvarchar	2	0	Allow NULL?
372	N8CAPDND	Cardio: First Secondary Diagnosis After Diagn. Cardiac Cath.	nvarchar	2	0	Allow NULL?
373	N8CAPDTE	Cardiology: Therapy Recomms After Diagn. Cardiac Catheter	char	1	0	Allow NULL?
374	N8CAPDNI	Cardiology: What Number PCI of This Stay	nvarchar	2	0	Allow NULL?
375	N8CAPDPA	Cardiology: PCI on How Many Supply Areas	char	1	0	Allow NULL?
376	N8CAPDZE	Cardiology: Important Intervention Target Reached	char	1	0	Allow NULL?
377	N8CAPDBM	Cardiology: Special Characteristics PCI	char	1	0	Allow NULL?
378	N8CAPDGV	Cardiology: PCI on Complete Vascular Occlusion	char	1	0	Allow NULL?
379	N8CAPDHS	Cardiology: PCI on Unprotected Main Stem	char	1	0	Allow NULL?
380	N8CAPDLG	Cardiology: PCI on Last Remaining Vessel	char	1	0	Allow NULL?
381	N8CAPDKB	Cardiology: PCI of Coronary Bypass	char	1	0	Allow NULL?
382	N8CAPDOS	Cardiology: PCI of Ostium Stenosis LAD/RCX/RCA	char	1	0	Allow NULL?
383	N8CAPDSI	Cardiology: Stent(s) Implanted	char	1	0	Allow NULL?
384	N8CAPDIK	Cardiology: Intraprocedurally Occurring Complications	char	1	0	Allow NULL?
385	N8CAPDKV	Cardiology: Coronary Occlusion	char	1	0	Allow NULL?
386	N8CAPDRE	Cardiology: Reanimation	char	1	0	Allow NULL?
387	N8CAPDTA	Cardiology: TIA / Stroke	char	1	0	Allow NULL?
388	N8CAPDSO	Cardiology: Other Complications	char	1	0	Allow NULL?
389	N8CAPDET	Cardiology: Exitus in Cardiac Catheter Lab	char	1	0	Allow NULL?
390	N8CALV_PES	Cardiology: Post Extrasystolic Measurement	char	1	0	Allow NULL?
391	X00A_HKNR	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?
392	N8CAKOMPKT	Reference Key of a Referenced Object	nvarchar	20	0	Allow NULL?

TOP ERP 6.0 | N2CA02 INDEXES

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

392 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA02 TABLE

TOP ERP 6.0 | N2CA02 COLUMNS

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

392 COLUMNS | 1 INDEXES | ERP 6.0 | N2CA02 TABLE

TOPERP 6.0 | N2CA02 COLUMNS

TOPERP 6.0 | N2CA02 INDEXES

TOP ERP 6.0 | N2CA02 COLUMNS

TOP ERP 6.0 | N2CA02 INDEXES