SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2CA093281PMD: N8CA_MRT 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, N8CAMRTIND, N8CAPATEIN, N8CATSTUD, N8CA_NYHA, N8CA_CCS, N8CAXKEBE, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CAMETIM, N8CAKINSM, N8CAKMAL, N8CAMRTSE1, N8CAMRTSE2, N8CAMRTANG, N8CAMRTFLQ, N8CAMRTDEN, N8CAMRTGRC, N8CAMRTPER, N8CAMRTNDF, N8CAMRTKM, N8CAMRTMKM, N8CAMRTSON, N8CABQUALI, N8CAEXADAT, GSDKEXGP, ISHMVMAKRZ, ISHMVMARNG, N8CAEXANAM, ISHMVMAFAR, GSDKEXGP2, X00MVMAKRZ, X00MVMARNG, N8CAEXANA2, X00MVMAFAR, GSDKEXGP3, X01MVMAKRZ, X01MVMARNG, N8CAEXANA3, X01MVMAFAR, GSDKEXGP4, X02MVMAKRZ, X02MVMARNG, N8CAEXANA4, X02MVMAFAR, N8CAMR_DEV, N8CAMRT2FS, N8CAMRT2LS, N8CAMRT2FD, N8CAMRT2LD, N8CAMRT2FE, N8CAMRT2LE, N8CAMRT2FL, N8CAMRT2LL, N8CAMRT4FS, N8CAMRT4LS, N8CAMRT4FD, N8CAMRT4LD, N8CAMRT4FE, N8CAMRT4LE, N8CAMRT4FL, N8CAMRT4LL, N8CARR_SYS, N8CA_PULS, N8CALV2EF, N8CALV2EDV, N8CALV2ESV, N8CALV2EDI, N8CALV2EDE, N8CALV2SV, N8CALV2LVM, N8CALV2LVI, N8CALV4EF, N8CALV4EDV, N8CALV4ESV, N8CALV4EDI, N8CALV4EDE, N8CALV4SV, N8CALV4LVM, N8CALV4LVI, N8CALV3EF, N8CALV3EDV, N8CALV3ESV, N8CALV3EDI, N8CALV3SV, N8CALV3LVM, N8CALV3LVI, N8CALVBEF, N8CALVBEDV, N8CALVBESV, N8CALVBEDI, N8CALVBEDE, N8CALVBSV, N8CALVBLVM, N8CALVBLVI, N8CALAV, N8CALAVIH, N8CALAVIB, N8CAWSPANN, N8CAL_WBS, N8CAMR4AP, N8CAUR4AS, N8CAUR4AL, N8CAUR4MS, N8CAUR4ML, N8CAUR4BS, N8CAUR4BL, N8CAMR2AP, N8CAUR2AI, N8CAUR2AA, N8CAUR2MI, N8CAUR2ML, N8CAUR2BI, N8CAUR2BL, N8CAURSMS, N8CAURSMT, N8CAURSMI, N8CAURSMA, N8CAURSMP, N8CAURSML, N8CAMR2S1S, N8CAMR2S1M, N8CAMR2S1R, N8CAMR2S2S, N8CAMR2S2M, N8CAMR2S2R, N8CAMR2S3S, N8CAMR2S3M, N8CAMR2S3R, N8CAMRT2MW, N8CAMR2S4S, N8CAMR2S4M, N8CAMR2S4R, N8CAKMS1SN, N8CAKMS1SK, N8CAKMS1SE, N8CAKMS1MN, N8CAKMS1MK, N8CAKMS1ME, N8CAKMS1RA, N8CAKMS2SN, N8CAKMS2SK, N8CAKMS2SE, N8CAKMS2MN, N8CAKMS2MK, N8CAKMS2ME, N8CAKMS2RA, N8CAKMS3SN, N8CAKMS3SK, N8CAKMS3SE, N8CAKMS3MN, N8CAKMS3MK, N8CAKMS3ME, N8CAKMS3RA, N8CAKMS4SN, N8CAKMS4SK, N8CAKMS4SE, N8CAKMS4MN, N8CAKMS4MK, N8CAKMS4ME, N8CAKMS4RA, N8CAMRKMME, N8CAKMSFSN, N8CAKMSFSK, N8CAKMSFSE, N8CAKMSFMN, N8CAKMSFMK, N8CAKMSFME, N8CAKMSFRA, N8CADEDIFF, N8CADELOK, N8CADETM, N8CAAV_OK, N8CAKLMOR, N8CAAVAREA, N8CAAVAIDX, N8CADAVVMX, N8CADAVVME, N8CADAVSTE, N8CADAVINS, N8CAARV, N8CAARF, N8CAAOLVOT, N8CAMV_OK, X00AKLMOR, N8CAMVAREA, N8CAMVAIDX, N8CADMVVMX, N8CADMVVMN, N8CADMVSTE, N8CADMVINS, N8CAMRV, N8CAMRF, N8CATV_OK, X01AKLMOR, N8CADTVVMX, N8CADTVVME, N8CADTVSTE, N8CADTVINS, N8CAPV_OK, X02AKLMOR, N8CADPVVMX, N8CADPVVME, N8CADPVSTE, N8CADPVINS, N8CADSH_OK, N8CASVAO, N8CASVAP, N8CASRQ, N8CAMRTCR1, N8CAMRTCR2, N8CAMRTCR3, N8CAMRTCR4, N8CAMRTCR5, N8CAMRTCR6, N8CAMRTCR7, N8CAMRTCR8, N8CAMRTCR9, N8CARESTXT, N8CARESUME, N8CARESDAT, X03MVMAKRZ, X03MVMARNG, N8CARESNAM, X03MVMAFAR, X04MVMAKRZ, X04MVMARNG, N8CARESNM2, X04MVMAFAR, N8CAMRTLVB, N8CAMRBTY, N8CAAWPULS, N8CAAW_SYS, N8CAAW_DIA, N8CAAWMHF, N8CADOB_V, N8CADOB_B, N8CADOBELD, N8CAMBELAV, N8CAMBELZM, N8CABELATR, N8CABELBBL, N8CABELESM, N8CAEWPULS, N8CAEW_SYS, N8CAEW_DIA, N8CAEWMAGR, N8CAMRLAX, N8CAUBWBS, N8CAMUB4AP, N8CAMUB4AS, N8CAMUB4AL, N8CAMUB4MS, N8CAMUB4ML, N8CAMUB4BS, N8CAMUB4BL, N8CAMUB2AP, N8CAMUB2AI, N8CAMUB2AA, N8CAMUB2MI, N8CAMUB2ML, N8CAMUB2BI, N8CAMUB2BL, N8CAMUB3AP, N8CAMUBRAA, N8CAMUB3AI, N8CAMUB3MA, N8CAMUB3MP, N8CAMUB3BA, N8CAMUB3BP, N8CAUBSBBS, N8CAUBSBBT, N8CAUBSBBI, N8CAUBSBBA, N8CAUBSBBP, N8CAUBSBBL, N8CAUBSMMS, N8CAUBSMMT, N8CAUBSMMI, N8CAUBSMMA, N8CAUBSMMP, N8CAUBSMML, N8CAUBSAAI, N8CAUBSAAS, N8CAUBSAAL, N8CAUBSAAA, N8CAUBSAAP, N8CABWAW, N8CABWEW, N8CABWBV, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG, GSDKRESGP, GSDKRESGP2, N8CAEXATIM FROM N2CA09
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DOKARDocument Typenvarchar30 Allow NULL? 
3DOKNRDocument numbernvarchar250 Allow NULL? 
4DOKVRDocument Versionnvarchar20 Allow NULL? 
5DOKTLDocument Partnvarchar30 Allow NULL? 
6GSDKPATKPFReference Key of a Referenced Objectnvarchar200 Allow NULL? 
7ISHMPATNAMIS-H: Patient Namenvarchar300 Allow NULL? 
8ISHMPATNUMIS-H: Patient Numbernvarchar100 Allow NULL? 
9ISHMPATGESIS-H: Sex Indicator - User-Specificchar10 Allow NULL? 
10ISHMPATFALIS-H: Case Numbernvarchar100 Allow NULL? 
11ISHMPATFATIS-H: Text for Case Typenvarchar140 Allow NULL? 
12ISHMPATGEBIS-H: Birthdatenvarchar80 Allow NULL? 
13ISHMPATAPOIS-H: Nursing Organizational Unit Requesting the Servicenvarchar80 Allow NULL? 
14N8CAEXAROOCardiology: Examination Roomnvarchar80 Allow NULL? 
15ISHMPATALTPatient Agenvarchar30 Allow NULL? 
16N8CAPATALEUnit of Agechar10 Allow NULL? 
17N8CAPATGEWBody Weight in Kgnvarchar30 Allow NULL? 
18N8CAPATGROHeight in Cmnvarchar30 Allow NULL? 
19N8CAPATBMICardiology: Body Mass Index (xx,y) kg/m2decimal31
20N8CAPATBSACardiology: Body Surface Area (x,yy) m2decimal32
21N8CAANFVMAEmployee Responsiblenvarchar100 Allow NULL? 
22N8CAANFDATIS-H: Date when Record Creatednvarchar80 Allow NULL? 
23N8CAANFTIMIS-H: Time Record Creatednvarchar60 Allow NULL? 
24X00MKANAMReference Key of a Referenced Objectnvarchar200 Allow NULL? 
25X00MFRGSTReference Key of a Referenced Objectnvarchar200 Allow NULL? 
26N8CAMRTINDCardiology: Selection of Indicationnvarchar600 Allow NULL? 
27N8CAPATEINCardiology: Consent Exists?char10 Allow NULL? 
28N8CATSTUDCardiology: Study Participationnvarchar150 Allow NULL? 
29N8CA_NYHACardiology: Fixed Values NYHA Classificationchar10 Allow NULL? 
30N8CA_CCSCardiology: Fixed Value CCS Statuschar10 Allow NULL? 
31N8CAXKEBECardiology: Checkbox no Cardiovascular Risks Knownchar10 Allow NULL? 
32N8CAXARTHYCardiology: Checkbox Art. Hypertensionchar10 Allow NULL? 
33N8CAXNICOCardiology: Checkbox Nicotinechar10 Allow NULL? 
34N8CAXDIABMCardiology: Checkbox Diabetes Mellituschar10 Allow NULL? 
35N8CAXHYLIPCardiology: Checkbox Hyperlipidemiachar10 Allow NULL? 
36N8CAXFAMACardiology: Checkbox Family Anamnesischar10 Allow NULL? 
37N8CACAVSONCardiology: Other Cardiovascular Risk Factorsnvarchar600 Allow NULL? 
38N8CAMETIMCardiology: Metal Implantschar10 Allow NULL? 
39N8CAKINSMCardiology: Pacemakerchar10 Allow NULL? 
40N8CAKMALCardiology: Contrast Medium Allergychar10 Allow NULL? 
41N8CAMRTSE1Cardiology: Checkbox Spinecho with T1 Weightingchar10 Allow NULL? 
42N8CAMRTSE2Cardiology: Checkbox Spinecho with T2 Weightingchar10 Allow NULL? 
43N8CAMRTANGCardiology: Checkbox Angiography 3Dchar10 Allow NULL? 
44N8CAMRTFLQCardiology: Checkbox Quantif. of Flow Velocitieschar10 Allow NULL? 
45N8CAMRTDENCardiology: Checkbox Delayed Enhancement (Contrast Medium)char10 Allow NULL? 
46N8CAMRTGRCCardiology: Checkbox Acquisition of Gradient Echo Cine Sequ.char10 Allow NULL? 
47N8CAMRTPERCardiology: Checkbox Stress (Contrast Medium)char10 Allow NULL? 
48N8CAMRTNDFCardiology: Checkbox Not Executablechar10 Allow NULL? 
49N8CAMRTKMCardiology: Selection Contrast Mediumnvarchar400 Allow NULL? 
50N8CAMRTMKMCardiology: Quantity Contrast Medium (ml)nvarchar30 Allow NULL? 
51N8CAMRTSONCardiology: Other Examination Technique MRInvarchar200 Allow NULL? 
52N8CABQUALICardiologye: Fixed Value Image Qualitychar10 Allow NULL? 
53N8CAEXADATCardiology: Date of Examinationnvarchar80 Allow NULL? 
54GSDKEXGPReference Key of a Referenced Objectnvarchar200 Allow NULL? 
55ISHMVMAKRZEmployee Responsiblenvarchar100 Allow NULL? 
56ISHMVMARNGIS-H: Texts for ranksnvarchar150 Allow NULL? 
57N8CAEXANAMCardiology: Name of Examinernvarchar400 Allow NULL? 
58ISHMVMAFARIS-H: Name of Specialtynvarchar300 Allow NULL? 
59GSDKEXGP2Reference Key of a Referenced Objectnvarchar200 Allow NULL? 
60X00MVMAKRZEmployee Responsiblenvarchar100 Allow NULL? 
61X00MVMARNGIS-H: Texts for ranksnvarchar150 Allow NULL? 
62N8CAEXANA2Cardiology: Name of Examinernvarchar400 Allow NULL? 
63X00MVMAFARIS-H: Name of Specialtynvarchar300 Allow NULL? 
64GSDKEXGP3Reference Key of a Referenced Objectnvarchar200 Allow NULL? 
65X01MVMAKRZEmployee Responsiblenvarchar100 Allow NULL? 
66X01MVMARNGIS-H: Texts for ranksnvarchar150 Allow NULL? 
67N8CAEXANA3Cardiology: Name of Examinernvarchar400 Allow NULL? 
68X01MVMAFARIS-H: Name of Specialtynvarchar300 Allow NULL? 
69GSDKEXGP4Reference Key of a Referenced Objectnvarchar200 Allow NULL? 
70X02MVMAKRZEmployee Responsiblenvarchar100 Allow NULL? 
71X02MVMARNGIS-H: Texts for ranksnvarchar150 Allow NULL? 
72N8CAEXANA4Cardiology: Name of Examinernvarchar400 Allow NULL? 
73X02MVMAFARIS-H: Name of Specialtynvarchar300 Allow NULL? 
74N8CAMR_DEVCardiology: Devicenvarchar400 Allow NULL? 
75N8CAMRT2FSCardiology: 2CV ESCA Area of Left Ventricle Syst. (mm2)nvarchar50 Allow NULL? 
76N8CAMRT2LSCardiology: 2CV ESD Length of Left Ventr. Syst. (mm)nvarchar30 Allow NULL? 
77N8CAMRT2FDCardiology: 2CV EDCA Area of Left Ventricle Diast. (mm2)nvarchar50 Allow NULL? 
78N8CAMRT2LDCardiology: 2CV EDD Length of Left Ventricle Diast. (mm)nvarchar30 Allow NULL? 
79N8CAMRT2FECardiology: 2CV EDEA Area of Left Ventricle Epicard. (mm2)nvarchar50 Allow NULL? 
80N8CAMRT2LECardiology: 2CV EDED Length of Left Ventricle Epicard. (mm)nvarchar30 Allow NULL? 
81N8CAMRT2FLCardiology: 2CV LAA Area of Left Atrium (mm2)nvarchar50 Allow NULL? 
82N8CAMRT2LLCardiology: 2CV LAD Length of Left Atrium (mm)nvarchar30 Allow NULL? 
83N8CAMRT4FSCardiology: 4CV ESCA Area of Left Ventricle Syst. (mm2)nvarchar50 Allow NULL? 
84N8CAMRT4LSCardiology: 4CV ESD Length of Left Ventricle Syst. (mm)nvarchar30 Allow NULL? 
85N8CAMRT4FDCardiology: 4CV EDCA Area of Left Ventricle Diast. (mm2)nvarchar50 Allow NULL? 
86N8CAMRT4LDCardiology: 4CV EDD Length of Left Ventricle Diast. (mm)nvarchar30 Allow NULL? 
87N8CAMRT4FECardiology: 4CV EDEA Area of Left Ventricle Epicard. (mm2)nvarchar50 Allow NULL? 
88N8CAMRT4LECardiology: 4CV EDED Length of Left Ventricle Epicard. (mm)nvarchar30 Allow NULL? 
89N8CAMRT4FLCardiology: 4CV LAA Area of Left Arium (mm2)nvarchar50 Allow NULL? 
90N8CAMRT4LLCardiology: 4CV LAD Length of Left Atrium (mm)nvarchar30 Allow NULL? 
91N8CARR_SYSCardiology: Systolic Blood Pressure (mmHg)nvarchar30 Allow NULL? 
92N8CA_PULSCardiology: Heart Rate / Min.nvarchar30 Allow NULL? 
93N8CALV2EFCardiology: LV 2CV Ejection Fraction (%)nvarchar20 Allow NULL? 
94N8CALV2EDVCardiology: LV 2CV End-Diast. Volume (ml)nvarchar30 Allow NULL? 
95N8CALV2ESVCardiology: LV 2CV End-Syst. Volume (ml)nvarchar30 Allow NULL? 
96N8CALV2EDICardiology: LV 2CV End-Diast. Volume Index (ml/cm)decimal21
97N8CALV2EDECardiology: LV 2CV End-Diast. Volume Epi. (ml)nvarchar30 Allow NULL? 
98N8CALV2SVCardiology: LV 2CV Stroke Volume (ml)nvarchar30 Allow NULL? 
99N8CALV2LVMCardiology: LV 2CV Muscular Mass (g)nvarchar30 Allow NULL? 
100N8CALV2LVICardiology: LV 2CV Muscular Mass Index (g/cm)decimal21
101N8CALV4EFCardiology: LV 4CV Ejection Fraction (%)nvarchar20 Allow NULL? 
102N8CALV4EDVCardiology: LV 4CV End-Diast. Volume (ml)nvarchar30 Allow NULL? 
103N8CALV4ESVCardiology: LV 4CV End-Syst. Volume (ml)nvarchar30 Allow NULL? 
104N8CALV4EDICardiology: LV 4CV End-Diast. Volume Index (ml/cm)decimal21
105N8CALV4EDECardiology: LV 4CV End-Diast. Volume Epi. (ml)nvarchar30 Allow NULL? 
106N8CALV4SVCardiology: LV 4CV Stroke Volume (ml)nvarchar30 Allow NULL? 
107N8CALV4LVMCardiology: LV 4CV Muscular Mass (g)nvarchar30 Allow NULL? 
108N8CALV4LVICardiology: LV 4CV Muscular Mass Index (g/cm)decimal21
109N8CALV3EFCardiology: LV 3D Ejection Fraction (%)nvarchar20 Allow NULL? 
110N8CALV3EDVCardiology: LV 3D End-Diast. Volume (ml)nvarchar30 Allow NULL? 
111N8CALV3ESVCardiology: LV 3D End-Syst. Volume (ml)nvarchar30 Allow NULL? 
112N8CALV3EDICardiology: LV 3D End-Diast. Volume Index (ml/cm)decimal21
113N8CALV3SVCardiology: LV 3D Stroke Volume (ml)nvarchar30 Allow NULL? 
114N8CALV3LVMCardiology: LV 3D Muscular Mass (g)nvarchar30 Allow NULL? 
115N8CALV3LVICardiology: LV 3D Muscular Mass Index (g/cm)decimal21
116N8CALVBEFCardiology: LV Biplan Ejection Fraction (%)nvarchar20 Allow NULL? 
117N8CALVBEDVCardiology: LV Biplanar End-Diast. Volume (ml)nvarchar30 Allow NULL? 
118N8CALVBESVCardiology: LV Biplanar End-Systolic Volume (ml)nvarchar30 Allow NULL? 
119N8CALVBEDICardiology: LV Biplanar End-Diast. Volume Index (ml/cm)decimal21
120N8CALVBEDECardiology: LV Biplanar End-Diast. Volume Epi. (ml)nvarchar30 Allow NULL? 
121N8CALVBSVCardiology: LV Biplanar Stroke Volume (ml)nvarchar30 Allow NULL? 
122N8CALVBLVMCardiology: LV Biplanar Muscular Mass (g)nvarchar30 Allow NULL? 
123N8CALVBLVICardiology: LV Biplanar Muscular Mass Index (g/cm)decimal21
124N8CALAVCardiology: Left Atrium Volume (ml)nvarchar30 Allow NULL? 
125N8CALAVIHCardiology: Left Atrium Volume/Body Height (ml/cm)decimal32
126N8CALAVIBCardiology: Left Atrium Volume/BSA (ml/m2)decimal41
127N8CAWSPANNCardiology: Function Wall Tension (N/m2 X 1000 )nvarchar30 Allow NULL? 
128N8CAL_WBSReference Key of a Referenced Objectnvarchar200 Allow NULL? 
129N8CAMR4APCardiology: Wall Motion Abnorm. MRI 4CV Apex - 17char10 Allow NULL? 
130N8CAUR4ASCardiology: Wall Motion Abnorm. Resting 4CV Apical Septalchar10 Allow NULL? 
131N8CAUR4ALCardiology: Wall Motion Abnorm. Resting 4CV Apical Lateralchar10 Allow NULL? 
132N8CAUR4MSCardiology: Wall Motion Abnorm. Resting 4CV Medial Septalchar10 Allow NULL? 
133N8CAUR4MLCardiology: Wall Motion Abnorm. Resting 4CV Medial Lateralchar10 Allow NULL? 
134N8CAUR4BSCardiology: Wall Motion Abnorm. Resting 4CV Basal Septalchar10 Allow NULL? 
135N8CAUR4BLCardiology: Wall Motion Abnorm. Resting 4CV Basal Lateralchar10 Allow NULL? 
136N8CAMR2APCardiology: Wall Motion Abnorm. MRI 2CV Apex - 17char10 Allow NULL? 
137N8CAUR2AICardiology: Wall Motion Abn. Resting 2CV Apical Inferiorchar10 Allow NULL? 
138N8CAUR2AACardiology: Wall Motion Abn. Resting 2CV Apical Anteriorchar10 Allow NULL? 
139N8CAUR2MICardiology: Wall Motion Abn. Resting 2CV Medial Inferiorchar10 Allow NULL? 
140N8CAUR2MLCardiology: Wall Motion Abn. Resting 2CV Medial Anterior (7)char10 Allow NULL? 
141N8CAUR2BICardiology: Wall Motion Abn. Resting 2CV Basal Inferior (4)char10 Allow NULL? 
142N8CAUR2BLCardiology: Wall Motion Abn. Resting 2CV Basal Anterior (1)char10 Allow NULL? 
143N8CAURSMSCardiology: WMA Resting SAX Medial (Infero) Septal (9)char10 Allow NULL? 
144N8CAURSMTCardiology: WMA Resting SAX Medial Ant. Septal (8)char10 Allow NULL? 
145N8CAURSMICardiology: WMA Resting SAX Medial Inferior (10)char10 Allow NULL? 
146N8CAURSMACardiology: WMA Resting SAX Medial Anterior (7)char10 Allow NULL? 
147N8CAURSMPCardiology: WMA Resting SAX Medial Posterior (11-Inf.Lat.)char10 Allow NULL? 
148N8CAURSMLCardiology: WMA Resting SAX Medial Lateral (12- Ant.Lat.)char10 Allow NULL? 
149N8CAMR2S1SCardiology: MRI Tissue T2 Skeletal Muscle Section 1nvarchar30 Allow NULL? 
150N8CAMR2S1MCardiology: MRI Tissue T2 Myocardium Section 1nvarchar30 Allow NULL? 
151N8CAMR2S1RCardiology: MRI Tissue T2 Ratio S/M Section 1decimal31
152N8CAMR2S2SCardiology: MRI Tissue T2 Skeletal Muscle Section 2nvarchar30 Allow NULL? 
153N8CAMR2S2MCardiology: MRI Tissue T2 Myocardium Section 2nvarchar30 Allow NULL? 
154N8CAMR2S2RCardiology: MRI Tissue T2 Ratio S/M Section 2decimal31
155N8CAMR2S3SCardiology: MRI Tissue T2 Skeletal Muscle Section 3nvarchar30 Allow NULL? 
156N8CAMR2S3MCardiology: MRI Tissue T2 Myocardium Section 3nvarchar30 Allow NULL? 
157N8CAMR2S3RCardiology: MRI Tissue T2 Ratio S/M Section 3decimal31
158N8CAMRT2MWCardiology: MRI Tissue T2 Relative Myocardial Water Contentdecimal31
159N8CAMR2S4SCardiology: MRI Tissue T2 Skeletal Muscle Focal Sectionnvarchar30 Allow NULL? 
160N8CAMR2S4MCardiology: MRI Tissue T2 Myocard Focal Sectionnvarchar30 Allow NULL? 
161N8CAMR2S4RCardiology: MRI Tissue T2 Ratio S/M Focal Sectiondecimal31
162N8CAKMS1SNCardiology: Skeletal Muscle Native Section 1nvarchar40 Allow NULL? 
163N8CAKMS1SKCardiology: Skeletal Muscle w/ Contrast Medium Section 1nvarchar40 Allow NULL? 
164N8CAKMS1SECardio: Contr. Medium Skeletal Muscle Enhancement Section 1nvarchar30 Allow NULL? 
165N8CAKMS1MNCardiology: Myocard Native Section 1nvarchar40 Allow NULL? 
166N8CAKMS1MKCardiology: Myocardium with Contrast Medium Section 1nvarchar40 Allow NULL? 
167N8CAKMS1MECardiology: Contrast Medium Myocardium Enhancement Section 1nvarchar30 Allow NULL? 
168N8CAKMS1RACardiology: MRI Contrast Medium Ratio S/M Section 1decimal31
169N8CAKMS2SNCardiology: Contrast Medium Skelet. Muscle Native Section 2nvarchar40 Allow NULL? 
170N8CAKMS2SKCardiology: Skeletal Muscle w/ Contrast Medium Section 2nvarchar40 Allow NULL? 
171N8CAKMS2SECardiology: Contrast Med Skeletal Muscle Enhancem. Section 2nvarchar30 Allow NULL? 
172N8CAKMS2MNCardiology: Myocardium Native Section 2nvarchar40 Allow NULL? 
173N8CAKMS2MKCardiology: Myocardium w/ Contrast Medium Section 2nvarchar40 Allow NULL? 
174N8CAKMS2MECardiology: Contrast Medium Myocardium Enhancem. Section 2nvarchar30 Allow NULL? 
175N8CAKMS2RACardiology: MRI Contrast Medium Ratio S/M Section 2decimal31
176N8CAKMS3SNCardiology: Contrast Medium Skeletal Muscle Native Section 3nvarchar40 Allow NULL? 
177N8CAKMS3SKCardiology: Skeletal Muscle w/ Contrast Medium Section 3nvarchar40 Allow NULL? 
178N8CAKMS3SECardiology: Contrast Med. Skeletal Musc. Enhancem. Section 3nvarchar30 Allow NULL? 
179N8CAKMS3MNCardiology: Myocardium Native Section 3nvarchar40 Allow NULL? 
180N8CAKMS3MKCardiology: Myocardium w/ Contrast Medium Section 3nvarchar40 Allow NULL? 
181N8CAKMS3MECardiology: Contrast Medium Myocardial Enhancem. Section 3nvarchar30 Allow NULL? 
182N8CAKMS3RACardiology: MRI Contrast Medium Ratio S/M Section 3decimal31
183N8CAKMS4SNCardiology: Contrast Medium Skelet. Muscle Native Section 4nvarchar40 Allow NULL? 
184N8CAKMS4SKCardiology: Skeletal Muscle w/ Contrast Medium Section 4nvarchar40 Allow NULL? 
185N8CAKMS4SECardio: Contrast Med. Skeletal Muscle Enhancem. Section 4nvarchar30 Allow NULL? 
186N8CAKMS4MNCardiology: Myocard. Native Section 4nvarchar40 Allow NULL? 
187N8CAKMS4MKCardiology: Myocard w/ Contrast Medium Section 4nvarchar40 Allow NULL? 
188N8CAKMS4MECardiology: Contrast Med. Myocard. Enhancem. Section 4nvarchar30 Allow NULL? 
189N8CAKMS4RACardiology: MRI Contrast Medium Ratio S/M Section 4decimal31
190N8CAMRKMMECardiology: MRI Contrast Medium, Rel. Myocard. Enhancementdecimal31
191N8CAKMSFSNCardiology: Contrast Medium Skeletal Muscle Native Focusnvarchar40 Allow NULL? 
192N8CAKMSFSKCardiology: Skeletal Muscle w/ Contrast Medium, Focusnvarchar40 Allow NULL? 
193N8CAKMSFSECardiology: Contrast Medium Skeletal Muscle Enhancem. Focusnvarchar30 Allow NULL? 
194N8CAKMSFMNCardiology: Myocardium Native Focal Sectionnvarchar40 Allow NULL? 
195N8CAKMSFMKCardiology: Myocardium w/ Contrast Medium Focal Sectionnvarchar40 Allow NULL? 
196N8CAKMSFMECardiology: Contrast Medium Myocard. Enhancem. Focal Sectionnvarchar30 Allow NULL? 
197N8CAKMSFRACardiology: MRI Contrast Medium Ratio S/M Focal Sectiondecimal31
198N8CADEDIFFCardiology: DE Differentiationchar10 Allow NULL? 
199N8CADELOKCardiology: Localization Delayed Enhancementchar10 Allow NULL? 
200N8CADETMCardiology: Transmurality Delayed Enhancementchar10 Allow NULL? 
201N8CAAV_OKCardiology: Cardiac Valve - Normalchar10 Allow NULL? 
202N8CAKLMORCardiology: Select Cardiac Valve Morphologynvarchar800 Allow NULL? 
203N8CAAVAREACardiology: Cardiac Valve - Opening Area (cm2)decimal32
204N8CAAVAIDXCardiology: Aoritc Valve - Opening Indexdecimal32
205N8CADAVVMXCardiology: Max. Flow Velocity (m/s)decimal32
206N8CADAVVMECardiology: Aortic Valve Mean Flow Velocity (m/s)decimal32
207N8CADAVSTECardiology: Cardiac Valve Degree of Stenosischar10 Allow NULL? 
208N8CADAVINSCardiology: Cardiac Valve Degree of Insufficiencychar10 Allow NULL? 
209N8CAARVCardiology: Aortic Valve Regurgitation Volume (ml)nvarchar30 Allow NULL? 
210N8CAARFCardiology: Aortic Valve Regurgitation Fraction (%)nvarchar20 Allow NULL? 
211N8CAAOLVOTCardiology: Aortic Valve LVOT (cm2)decimal32
212N8CAMV_OKCardiology: Cardiac Valve - Normalchar10 Allow NULL? 
213X00AKLMORCardiology: Select Cardiac Valve Morphologynvarchar800 Allow NULL? 
214N8CAMVAREACardiology: Cardiac Valve - Opening Area (cm2)decimal32
215N8CAMVAIDXCardiology: Aoritc Valve - Opening Indexdecimal32
216N8CADMVVMXCardiology: Max. Flow Velocity (m/s)decimal32
217N8CADMVVMNCardiology: Mean Flow Velocity (m/s)decimal32
218N8CADMVSTECardiology: Cardiac Valve Degree of Stenosischar10 Allow NULL? 
219N8CADMVINSCardiology: Cardiac Valve Degree of Insufficiencychar10 Allow NULL? 
220N8CAMRVCardiology: Mitral Valve Regurgitation Volume (ml)nvarchar30 Allow NULL? 
221N8CAMRFCardiology: Mitral Valve Regurgitation Percent.(%)nvarchar20 Allow NULL? 
222N8CATV_OKCardiology: Cardiac Valve - Normalchar10 Allow NULL? 
223X01AKLMORCardiology: Select Cardiac Valve Morphologynvarchar800 Allow NULL? 
224N8CADTVVMXCardiology: Max. Flow Velocity (m/s)decimal32
225N8CADTVVMECardiology: Tricuspid Valve Mean Flow Velocity (m/s)decimal32
226N8CADTVSTECardiology: Cardiac Valve Degree of Stenosischar10 Allow NULL? 
227N8CADTVINSCardiology: Cardiac Valve Degree of Insufficiencychar10 Allow NULL? 
228N8CAPV_OKCardiology: Cardiac Valve - Normalchar10 Allow NULL? 
229X02AKLMORCardiology: Select Cardiac Valve Morphologynvarchar800 Allow NULL? 
230N8CADPVVMXCardiology: Max. Flow Velocity (m/s)decimal32
231N8CADPVVMECardiology: Pulmonary Valve Mean Flow Velocity (m/s)decimal32
232N8CADPVSTECardiology: Cardiac Valve Degree of Stenosischar10 Allow NULL? 
233N8CADPVINSCardiology: Cardiac Valve Degree of Insufficiencychar10 Allow NULL? 
234N8CADSH_OKCardiology: Shunts - Normalchar10 Allow NULL? 
235N8CASVAOCardiology: Shunt Volume Aorta (ml)nvarchar30 Allow NULL? 
236N8CASVAPCardiology: Shunt Volume Arteria Pulmonaris (ml)nvarchar30 Allow NULL? 
237N8CASRQCardiology: Shunts Pulmonary to Systemic Flow Ratiodecimal21
238N8CAMRTCR1Cardiology: Criterion 1 Assessment Codenvarchar150 Allow NULL? 
239N8CAMRTCR2Cardiology: Criterion 2 Assessment Codenvarchar150 Allow NULL? 
240N8CAMRTCR3Cardiology: Criterion 3 Assessment Codenvarchar150 Allow NULL? 
241N8CAMRTCR4Cardiology: Criterion 4 Assessment Codenvarchar150 Allow NULL? 
242N8CAMRTCR5Cardiology: Criterion 5 Assessment Codenvarchar150 Allow NULL? 
243N8CAMRTCR6Cardiology: Criterion 6 Assessment Codenvarchar150 Allow NULL? 
244N8CAMRTCR7Cardiology: Criterion 7 Assessment Codenvarchar150 Allow NULL? 
245N8CAMRTCR8Cardiology: Criterion 8 Assessment Codenvarchar150 Allow NULL? 
246N8CAMRTCR9Cardiology: Criterion 9 Assessment Codenvarchar150 Allow NULL? 
247N8CARESTXTPMD: Reference by GUUIDnvarchar320 Allow NULL? 
248N8CARESUMEPMD: Reference by GUUIDnvarchar320 Allow NULL? 
249N8CARESDATCardiology: Date of Findingsnvarchar80 Allow NULL? 
250X03MVMAKRZEmployee Responsiblenvarchar100 Allow NULL? 
251X03MVMARNGIS-H: Texts for ranksnvarchar150 Allow NULL? 
252N8CARESNAMCardiology: Name of Findings Creatornvarchar400 Allow NULL? 
253X03MVMAFARIS-H: Name of Specialtynvarchar300 Allow NULL? 
254X04MVMAKRZEmployee Responsiblenvarchar100 Allow NULL? 
255X04MVMARNGIS-H: Texts for ranksnvarchar150 Allow NULL? 
256N8CARESNM2Cardiology: Name of Supervisornvarchar400 Allow NULL? 
257X04MVMAFARIS-H: Name of Specialtynvarchar300 Allow NULL? 
258N8CAMRTLVBReference Key of a Referenced Objectnvarchar200 Allow NULL? 
259N8CAMRBTYCardiology: Fixed Values MRI Stress Typechar10 Allow NULL? 
260N8CAAWPULSCardiology: Resting Value Heart Rate / Min.nvarchar30 Allow NULL? 
261N8CAAW_SYSCardiology: Resting Value Systolic Blood Pressure (mmHg)nvarchar30 Allow NULL? 
262N8CAAW_DIACardiology: Resting Value Diastolic Blood Pressure (mmHg)nvarchar30 Allow NULL? 
263N8CAAWMHFCardiology: Stress Echo Target Heart Ratenvarchar30 Allow NULL? 
264N8CADOB_VCardiology: Dobutamine Dose Fromnvarchar20 Allow NULL? 
265N8CADOB_BCardiology: Dobutamine Dose Tonvarchar20 Allow NULL? 
266N8CADOBELDCardiology: Dobutamine Stress Duration (min)nvarchar20 Allow NULL? 
267N8CAMBELAVCardiology: Combo Box Description Stress Methodnvarchar800 Allow NULL? 
268N8CAMBELZMCardiology: Combo Box Stress Additional Medicationnvarchar600 Allow NULL? 
269N8CABELATRCardiology: Stress Atropine (mg)decimal32
270N8CABELBBLCardiology: Select Betablocker During/After Stress Echonvarchar400 Allow NULL? 
271N8CABELESMCardiology: Stress Esmolol (mg)decimal41
272N8CAEWPULSCardiology: Heart Rate / Min. at Max. Stressnvarchar30 Allow NULL? 
273N8CAEW_SYSCardiology: Systolic Blood Pressure (mmHg) at Max. Stressnvarchar30 Allow NULL? 
274N8CAEW_DIACardiology: Diastol. Blood Pressure (mmHg) at Max. Stressnvarchar30 Allow NULL? 
275N8CAEWMAGRCardiology: Combo Box Cancellation Reason with Max. Stressnvarchar600 Allow NULL? 
276N8CAMRLAXCardiology: MRI Fixed Value Long Axischar10 Allow NULL? 
277N8CAUBWBSReference Key of a Referenced Objectnvarchar200 Allow NULL? 
278N8CAMUB4APCardiology: Wall Motion Abnorm. Stress 4CV Apexchar10 Allow NULL? 
279N8CAMUB4ASCardiology: Wall Motion Abnorm. Stress 4CV Apical Septalchar10 Allow NULL? 
280N8CAMUB4ALCardiology: Wall Motion Abnorm. Stress 4CV Apical Lateralchar10 Allow NULL? 
281N8CAMUB4MSCardiology: Wall Motion Abnorm. Stress 4CV Medial Septalchar10 Allow NULL? 
282N8CAMUB4MLCardiology: Wall Motion Abnorm. Stress 4CV Medial Lateralchar10 Allow NULL? 
283N8CAMUB4BSCardiology: Wall Motion Abnorm. Stress 4CV Basal Septalchar10 Allow NULL? 
284N8CAMUB4BLCardiology: Wall Motion Abnorm. Stress 4CV Basal Lateralchar10 Allow NULL? 
285N8CAMUB2APCardiology: Wall Motion Abnorm. Stress 4CV Apexchar10 Allow NULL? 
286N8CAMUB2AICardiology: Wall Motion Abnorm. Stress 2CV Apical Inferiorchar10 Allow NULL? 
287N8CAMUB2AACardiology: Wall Motion Abnorm. Stress 2CV Apical Anteriorchar10 Allow NULL? 
288N8CAMUB2MICardiology: Wall Motion Abnorm. Stress 2CV Medial Inferiorchar10 Allow NULL? 
289N8CAMUB2MLCardiology: Wall Motion Abnorm. Stress 2CV Medial Lateralchar10 Allow NULL? 
290N8CAMUB2BICardiology: Wall Motion Abnorm. Stress 2CV Basal Inferiorchar10 Allow NULL? 
291N8CAMUB2BLCardiology: Wall Motion Abnorm. Stress 2CV Basal Lateralchar10 Allow NULL? 
292N8CAMUB3APCardiology: Wall Motion Abnorm. Stress 3CV Apexchar10 Allow NULL? 
293N8CAMUBRAACardiology: Wall Motion Abnorm. Stress 3CV Apical Anteriorchar10 Allow NULL? 
294N8CAMUB3AICardiology: Wall Motion Abnorm. Stress 3CV Apical Inferiorchar10 Allow NULL? 
295N8CAMUB3MACardiology: Wall Motion Abnorm. Stress 3CV Medial Anteriorchar10 Allow NULL? 
296N8CAMUB3MPCardiology: Wall Motion Abnorm. Stress 3CV Medial Posteriorchar10 Allow NULL? 
297N8CAMUB3BACardiology: Wall Motion Abnorm. Stress 3CV Basal Anteriorchar10 Allow NULL? 
298N8CAMUB3BPCardiology: Wall Motion Abnorm. Stress 3CV Basal Posteriorchar10 Allow NULL? 
299N8CAUBSBBSCardiology: Wall Motion Abnorm. Stress SAX Basal Septalchar10 Allow NULL? 
300N8CAUBSBBTCardiology: Wall Motion Abnorm. Stress SAX Basal Ant. Septalchar10 Allow NULL? 
301N8CAUBSBBICardiology: Wall Motion Abnorm. Stress SAX Basal Inferiorchar10 Allow NULL? 
302N8CAUBSBBACardiology: Wall Motion Abnorm. Stress SAX Basal Anteriorchar10 Allow NULL? 
303N8CAUBSBBPCardiology: Wall Motion Abnorm. Stress SAX Basal Posteriorchar10 Allow NULL? 
304N8CAUBSBBLCardiology: Wall Motion Abnorm. Stress SAX Basal Lateralchar10 Allow NULL? 
305N8CAUBSMMSCardiology: Wall Motion Abnorm. Stress SAX Medial Septalchar10 Allow NULL? 
306N8CAUBSMMTCardio: Wall Motion Abnorm. Stress SAX Mmedial Ant. Septalchar10 Allow NULL? 
307N8CAUBSMMICardiology: Wall Motion Abnorm. Stress SAX Medial Inferiorchar10 Allow NULL? 
308N8CAUBSMMACardiology: Wall Motion Abnorm. Stress SAX Medial Anteriorchar10 Allow NULL? 
309N8CAUBSMMPCardiology: Wall Motion Abnorm. Stress SAX Medial Posteriorchar10 Allow NULL? 
310N8CAUBSMMLCardiology: Wall Motion Abnorm. Stress SAX Medial Lateralchar10 Allow NULL? 
311N8CAUBSAAICardiology: Wall Motion Abnorm. Stress SAX Apical Inferiorchar10 Allow NULL? 
312N8CAUBSAASCardiology: Wall Motion Abnorm. Stress SAX Apical Septalchar10 Allow NULL? 
313N8CAUBSAALCardiology: Wall Motion Abnorm. Stress SAX Apical Lateralchar10 Allow NULL? 
314N8CAUBSAAACardiology: Wall Motion Abnorm. Stress SAX Apical Anteriorchar10 Allow NULL? 
315N8CAUBSAAPCardiology: Wall Motion Abnorm. Stress SAX Apical Apexchar10 Allow NULL? 
316N8CABWAWCardiology: Evaluation Wall Motion Initial Situationchar10 Allow NULL? 
317N8CABWEWCardiology: Evaluation Wall Motion Final Situationchar10 Allow NULL? 
318N8CABWBVCardiology: Wall Motion Biphasic Progressnvarchar200 Allow NULL? 
319N8CA_XDATCardiology: Checkbox Data Was Importedchar10 Allow NULL? 
320N8CA_EINRIInstitutionnvarchar40 Allow NULL? 
321N8CA_SDESTSymbolic Destinationnvarchar80 Allow NULL? 
322N8CA_STUDAExamination Datenvarchar80 Allow NULL? 
323N8CA_PATNRIS-H: Patient Numbernvarchar100 Allow NULL? 
324N8CA_UIDCharacter UIDnvarchar320 Allow NULL? 
325N8CA_DFLAGData Flag Import OKchar10 Allow NULL? 
326GSDKRESGPReference Key of a Referenced Objectnvarchar200 Allow NULL? 
327GSDKRESGP2Reference Key of a Referenced Objectnvarchar200 Allow NULL? 
328N8CAEXATIMCardiology: Time of Examinationnvarchar60 Allow NULL? 
NamePrimaryUniqueTypeColumns
N2CA09~0YesYesCLUSTEREDDOKTL, DOKVR, DOKNR, DOKAR, MANDT