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

Home | ERP 6.0  | N2CA02
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2CA023921PMD: N8CA_HKB Cardiac Catheter FindingsClinical 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
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DOKARDocument Typenvarchar30CHAR(N' ')No*DOKAR Allow NULL? 
3DOKNRDocument numbernvarchar250CHAR(N' ')No*DOKNR Allow NULL? 
4DOKVRDocument Versionnvarchar20CHAR(N' ')NoDOKVR Allow NULL? 
5DOKTLDocument Partnvarchar30CHAR(N' ')NoDOKTL_D Allow NULL? 
6GSDKPATKPFReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
7ISHMPATNAMIS-H: Patient Namenvarchar300CHAR(N' ')YesRI_NAME Allow NULL? 
8ISHMPATNUMIS-H: Patient Numbernvarchar100CHAR(N' ')Yes*PATNR Allow NULL? 
9ISHMPATGESIS-H: Sex Indicator - User-Specificchar10CHAR(N' ')Yes*GSCHLE Allow NULL? 
10ISHMPATFALIS-H: Case Numbernvarchar100CHAR(N' ')Yes*FALNR Allow NULL? 
11ISHMPATFATIS-H: Text for Case Typenvarchar140CHAR(N' ')YesTEXT_FAA Allow NULL? 
12ISHMPATGEBIS-H: Birthdatenvarchar80DATS(N'00000000')YesRI_GBDAT Allow NULL? 
13ISHMPATAPOIS-H: Nursing Organizational Unit Requesting the Servicenvarchar80CHAR(N' ')Yes*ANPOE Allow NULL? 
14N8CAEXAROOCardiology: Examination Roomnvarchar80CHAR(N' ')Yes*N2_CAEXRO Allow NULL? 
15ISHMPATALTPatient Agenvarchar30NUMC(N'000')YesN2_ALTERP Allow NULL? 
16N8CAPATALEUnit of Agechar10CHAR(N' ')YesN2_ALTEINH Allow NULL? 
17X00KPATGEWReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
18N8CAPATGEWBody Weight in Kgnvarchar30NUMC(N'000')YesN1KGEW Allow NULL? 
19X00KPATGROReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
20N8CAPATGROHeight in Cmnvarchar30NUMC(N'000')YesN1KGR Allow NULL? 
21N8CAPATBMICardiology: Body Mass Index (xx,y) kg/m2decimal31DEC((0))YesN2_CA_BMI
22N8CAPATBSACardiology: Body Surface Area (x,yy) m2decimal32DEC((0))YesN2_CA_BSA
23N8CAANFVMAEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
24N8CAANFDATIS-H: Date when Record Creatednvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
25N8CAANFTIMIS-H: Time Record Creatednvarchar60TIMS(N'000000')YesRI_ERTIM Allow NULL? 
26X00MKANAMReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
27X00MFRGSTReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
28N8CAHKINDCardiology: Selection of Indicationnvarchar600CHAR(N' ')YesN2_CAINDC Allow NULL? 
29N8CAPATEINCardiology: Consent Exists?char10CHAR(N' ')YesN2_CAXEIN Allow NULL? 
30N8CATSTUDCardiology: Study Participationnvarchar150CHAR(N' ')YesN2_CATSTUD Allow NULL? 
31N8CA_HKNRCardiology: Cardiac Catheter Numbernvarchar100CHAR(N' ')YesN2_CAHKNR Allow NULL? 
32N8CA_NYHACardiology: Fixed Values NYHA Classificationchar10CHAR(N' ')YesN2_CANYHA Allow NULL? 
33N8CA_CCSCardiology: Fixed Value CCS Statuschar10CHAR(N' ')YesN2_CACCS Allow NULL? 
34N8CAXARTHYCardiology: Checkbox Art. Hypertensionchar10CHAR(N' ')YesN2_CAARTHY Allow NULL? 
35N8CAXNICOCardiology: Checkbox Nicotinechar10CHAR(N' ')YesN2_CANICO Allow NULL? 
36N8CAXDIABMCardiology: Checkbox Diabetes Mellituschar10CHAR(N' ')YesN2_CADIABM Allow NULL? 
37N8CAXHYLIPCardiology: Checkbox Hyperlipidemiachar10CHAR(N' ')YesN2_CAHYLIP Allow NULL? 
38N8CAXFAMACardiology: Checkbox Family Anamnesischar10CHAR(N' ')YesN2_CAFAMA Allow NULL? 
39N8CACAVSONCardiology: Other Cardiovascular Risk Factorsnvarchar600CHAR(N' ')YesN2_CACAVS Allow NULL? 
40N8CAEXADATCardiology: Date of Examinationnvarchar80DATS(N'00000000')YesN2_CAEXDT Allow NULL? 
41N8CAEXATIMCardiology: Time of Examinationnvarchar60TIMS(N'000000')YesN2_CAEXTM Allow NULL? 
42N8CAHK_DEVCardiology: Cardiac Catheter Devicenvarchar400CHAR(N' ')YesN2_CA_HKD Allow NULL? 
43N8CA_ANKORReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
44N8CAHBVERTCardiology: Fixed Values Coronary Angiogr. Supply Typechar10CHAR(N' ')YesN2_CAVETY Allow NULL? 
45N8CAKOROOKCardiology: Checkbox Coronary Angiography Normalchar10CHAR(N' ')YesN2_CAKOOK Allow NULL? 
46N8CARC01GRCardiology: RCA-1 Stenosis Degree (Right Coronary Artery)nvarchar30CHAR(N' ')YesN2_CARC01GR Allow NULL? 
47N8CARC01ARCardiology: RCA-1 Stenosis Area (Right Coronary Artery)nvarchar20CHAR(N' ')YesN2_CARC01AR Allow NULL? 
48N8CARC01KOCardiology: RCA-1 Stenosis Collateral. (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC01KO Allow NULL? 
49N8CARC01KACardiology: RCA-1 Stenosis Ca++ (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC01KA Allow NULL? 
50N8CARC01LGCardiology: RCA-1 Stenosis Length (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC01LG Allow NULL? 
51N8CARC01TYCardiology: RCA-1 Stenosis Type (Right Coronary Artery)nvarchar20CHAR(N' ')YesN2_CARC01TY Allow NULL? 
52N8CARC01BECardiology: RCA-1 Stenosis Comment (Right Coronary Artery)nvarchar600CHAR(N' ')YesN2_CARC01BE Allow NULL? 
53N8CARC02GRCardiology: RCA-2 Stenosis Degree (Right Coronary Artery)nvarchar30CHAR(N' ')YesN2_CARC02GR Allow NULL? 
54N8CARC02ARCardiology: RCA-2 Stenosis Area (Right Coronary Artery)nvarchar20CHAR(N' ')YesN2_CARC02AR Allow NULL? 
55N8CARC02KOCardiology: RCA-2 Stenosis Collateral. (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC02KO Allow NULL? 
56N8CARC02KACardiology: RCA-2 Stenosis Ca++ (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC02KA Allow NULL? 
57N8CARC02LGCardiology: RCA - 2 Stenosis Length (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC02LG Allow NULL? 
58N8CARC02TYCardiology: RCA-2 Stenosis Type (Right Coronary Artery)nvarchar20CHAR(N' ')YesN2_CARC02TY Allow NULL? 
59N8CARC02BECardiology: RCA-2 Stenosis Comment (Right Coronary Artery)nvarchar600CHAR(N' ')YesN2_CARC02BE Allow NULL? 
60N8CARC03GRCardiology: RCA-3 Stenosis Degree (Right Coronary Artery)nvarchar30CHAR(N' ')YesN2_CARC03GR Allow NULL? 
61N8CARC03ARCardiology: RCA - 3 Stenosis Area (Right Coronary Artery)nvarchar20CHAR(N' ')YesN2_CARC03AR Allow NULL? 
62N8CARC03KOCardiology: RCA-3 Stenosis Collateral. (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC03KO Allow NULL? 
63N8CARC03KACardiology: RCA-3 Stenosis CA++ (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC03KA Allow NULL? 
64N8CARC03LGCardiology: RCA - 3 Stenosis Length (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC03LG Allow NULL? 
65N8CARC03TYCardiology: RCA-3 Stenosis Type (Right Coronary Artery)nvarchar20CHAR(N' ')YesN2_CARC03TY Allow NULL? 
66N8CARC03BECardiology: RCA-3 Stenosis Comment (Right Coronary Artery)nvarchar600CHAR(N' ')YesN2_CARC03BE Allow NULL? 
67N8CARC4AGRCardiology: RCA-4a Stenosis Degree (Right Coronary Artery)nvarchar30CHAR(N' ')YesN2_CARC4AGR Allow NULL? 
68N8CARC4AARCardiology: RCA - 4a Stenosis Area (Right Coron. Artery)nvarchar20CHAR(N' ')YesN2_CARC4AAR Allow NULL? 
69N8CARC4AKOCardiology: RCA-4a Stenosis Collateral. (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC4AKO Allow NULL? 
70N8CARC4AKACardiology: RCA-4a Stenosis Ca++ (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC4AKA Allow NULL? 
71N8CARC4ALGCardiology: RCA - 4a Stenosis Length (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC4ALG Allow NULL? 
72N8CARC4ATYCardiology: RCA-4a Stenosis Type (Right Coronary Artery)nvarchar20CHAR(N' ')YesN2_CARC4ATY Allow NULL? 
73N8CARC4ABECardiology: RCA-4a Stenosis Comment (Right Coron. Artery)nvarchar600CHAR(N' ')YesN2_CARC4ABE Allow NULL? 
74N8CARC4BGRCardiology: RCA-4b Stenosis Degree (Right Coronary Artery)nvarchar30CHAR(N' ')YesN2_CARC4BGR Allow NULL? 
75N8CARC4BARCardiology: RCA - 4b Stenosis Area (Right Coron. Artery)nvarchar20CHAR(N' ')YesN2_CARC4BAR Allow NULL? 
76N8CARC4BKOCardiology: RCA-4b Stenosis Collateral. (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC4BKO Allow NULL? 
77N8CARC4BKACardiology: RCA-4b Stenosis Ca++ (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC4BKA Allow NULL? 
78N8CARC4BLGCardiology: RCA - 4b Stenosis Length (Right Coron. Art.)char10CHAR(N' ')YesN2_CARC4BLG Allow NULL? 
79N8CARC4BTYCardiology: RCA-4b Stenosis Type (Right Coronary Artery)nvarchar20CHAR(N' ')YesN2_CARC4BTY Allow NULL? 
80N8CARC4BBECardiology: RCA-4b Stenosis Comment (Right Coron. Artery)nvarchar600CHAR(N' ')YesN2_CARC4BBE Allow NULL? 
81N8CALM05GRCardiology: LM - 5 Stenosis Degree (Left Main Stem)nvarchar30CHAR(N' ')YesN2_CALM05GR Allow NULL? 
82N8CALM05ARCardiology: LM - 5 Stenosis Area (Left Main Stem)nvarchar20CHAR(N' ')YesN2_CALM05AR Allow NULL? 
83N8CALM05KOCardiology: LM - 5 Stenosis Collateral. (Left Main Stem)char10CHAR(N' ')YesN2_CALM05KO Allow NULL? 
84N8CALM05KACardiology: LM - 5 Stenosis Ca++ (Left Main Stem)char10CHAR(N' ')YesN2_CALM05KA Allow NULL? 
85N8CALM05LGCardiology: LM - 5 Stenosis Length (Left Main Stem)char10CHAR(N' ')YesN2_CALM05LG Allow NULL? 
86N8CALM05TYCardiology: LM - 5 Stenosis Type (Left Main Stem)nvarchar20CHAR(N' ')YesN2_CALM05TY Allow NULL? 
87N8CALM05BECardiology: LM - 5 Stenosis Comment (Left Main Stem)nvarchar600CHAR(N' ')YesN2_CALM05BE Allow NULL? 
88N8CALA06GRCardiology: LAD - 6 Stenosis Degree (Left Anterior Desc.)nvarchar30CHAR(N' ')YesN2_CALA06GR Allow NULL? 
89N8CALA06ARCardiology: LAD - 6 Stenosis Area (Left Anterior Desc.)nvarchar20CHAR(N' ')YesN2_CALA06AR Allow NULL? 
90N8CALA06KOCardiology: LAD - 6 Stenosis Collateral. (Left Ant. Desc)char10CHAR(N' ')YesN2_CALA06KO Allow NULL? 
91N8CALA06KACardiology: LAD - 6 Stenosis Ca++ (Left Anterior Desc.)char10CHAR(N' ')YesN2_CALA06KA Allow NULL? 
92N8CALA06LGCardiology: LAD - 6 Stenosis Length (Left Anterior Desc.)char10CHAR(N' ')YesN2_CALA06LG Allow NULL? 
93N8CALA06TYCardiology: LAD - 6 Stenosis Type (Left Anterior Desc)nvarchar20CHAR(N' ')YesN2_CALA06TY Allow NULL? 
94N8CALA06BECardiology: LAD - 6 Stenosis Comment (Left Anterior Desc.)nvarchar600CHAR(N' ')YesN2_CALA06BE Allow NULL? 
95N8CALA07GRCardiology: LAD - 7 Stenosis Degree (Left Anterior Desc.)nvarchar30CHAR(N' ')YesN2_CALA07GR Allow NULL? 
96N8CALA07ARCardiology: LAD - 7 Stenosis Area (Left Anterior Desc.)nvarchar20CHAR(N' ')YesN2_CALA07AR Allow NULL? 
97N8CALA07KOCardiology: LAD - 7 Stenosis Collateral. (Left Ant. Desc)char10CHAR(N' ')YesN2_CALA07KO Allow NULL? 
98N8CALA07KACardiology: LAD - 7 Stenosis Ca++ (Left Anterior Desc.)char10CHAR(N' ')YesN2_CALA07KA Allow NULL? 
99N8CALA07LGCardiology: LAD - 7 Stenosis Length (Left Anterior Desc.)char10CHAR(N' ')YesN2_CALA07LG Allow NULL? 
100N8CALA07TYCardiology: LAD - 7 Stenosis Type (Left Anterior Desc)nvarchar20CHAR(N' ')YesN2_CALA07TY Allow NULL? 
101N8CALA07BECardiology: LAD - 7 Stenosis Comment (Left Anterior Desc.)nvarchar600CHAR(N' ')YesN2_CALA07BE Allow NULL? 
102N8CALA08GRCardiology: LAD - 8 Degree of Stenosis (Left Anterior Desc.)nvarchar30CHAR(N' ')YesN2_CALA08GR Allow NULL? 
103N8CALA08ARCardiology: LAD - 8 Stenosis Area (Left Anterior Desc.)nvarchar20CHAR(N' ')YesN2_CALA08AR Allow NULL? 
104N8CALA08KOCardiology: LAD - 8 Stenosis Collateral. (Left Ant. Desc)char10CHAR(N' ')YesN2_CALA08KO Allow NULL? 
105N8CALA08KACardiology: LAD - 8 Stenosis Ca++ (Left Anterior Desc.)char10CHAR(N' ')YesN2_CALA08KA Allow NULL? 
106N8CALA08LGCardiology: LAD - 8 Stenosis Length (Left Anterior Desc.)char10CHAR(N' ')YesN2_CALA08LG Allow NULL? 
107N8CALA08TYCardiology: LAD - 8 Stenosis Type (Left Anterior Desc)nvarchar20CHAR(N' ')YesN2_CALA08TY Allow NULL? 
108N8CALA08BECardiology: LAD - 8 Stenosis Comment (Left Anterior Desc.)nvarchar600CHAR(N' ')YesN2_CALA08BE Allow NULL? 
109N8CADI09GRCardiology: DIAG1 - 9 Stenosis Degree (Ramus Diagonalis 1)nvarchar30CHAR(N' ')YesN2_CADI09GR Allow NULL? 
110N8CADI09ARCardiology: DIAG1 - 9 Stenosis Area (Ramus Diagonalis 1)nvarchar20CHAR(N' ')YesN2_CADI09AR Allow NULL? 
111N8CADI09KOCardiology: DIAG1 - 9 Stenosis Collateral. (Ramus Diagon. 1)char10CHAR(N' ')YesN2_CADI09KO Allow NULL? 
112N8CADI09KACardiology: DIAG1 - 9 Stenosis Calc. (Ramus Diagonalis 1)char10CHAR(N' ')YesN2_CADI09KA Allow NULL? 
113N8CADI09LGCardiology: DIAG1 - 9 Stenosis Length (Ramus Diagonalis 1)char10CHAR(N' ')YesN2_CADI09LG Allow NULL? 
114N8CADI09TYCardiology: DIAG1 - 9 Stenosis Type (Ramus Diagonalis 1)nvarchar20CHAR(N' ')YesN2_CADI09TY Allow NULL? 
115N8CADI09BECardiology: DIAG1 - 9 Stenosis Comment (Ramus Diagon. 1)nvarchar600CHAR(N' ')YesN2_CADI09BE Allow NULL? 
116N8CADI10GRCardiology: DIAG2 - 10 Stenosis Degree (Ramus Diagonalis 2)nvarchar30CHAR(N' ')YesN2_CADI10GR Allow NULL? 
117N8CADI10ARCardiology: DIAG2 - 10 Stenosis Area (Ramus Diagonalis 2)nvarchar20CHAR(N' ')YesN2_CADI10AR Allow NULL? 
118N8CADI10KOCardiology: DIAG2 -10 Stenosis Collateral. (Ramus Diagon. 2)char10CHAR(N' ')YesN2_CADI10KO Allow NULL? 
119N8CADI10KACardiology: DIAG2 -10 Stenosis Calc. (Ramus Diagonalis 2)char10CHAR(N' ')YesN2_CADI10KA Allow NULL? 
120N8CADI10LGCardiology: DIAG2 -10 Stenosis Length (Ramus Diagonalis 2)char10CHAR(N' ')YesN2_CADI10LG Allow NULL? 
121N8CADI10TYCardiology: DIAG2 -10 Stenosis Type (Ramus Diagonalis 2)nvarchar20CHAR(N' ')YesN2_CADI10TY Allow NULL? 
122N8CADI10BECardiology: DIAG2 - 10 Stenosis Comment (Ramus Diagon. 2)nvarchar600CHAR(N' ')YesN2_CADI10BE Allow NULL? 
123N8CALC11GRCardiology: LCX - 11 Stenosis Degree (Left Circumflex)nvarchar30CHAR(N' ')YesN2_CALC11GR Allow NULL? 
124N8CALC11ARCardiology: LCX - 11 Stenosis Area (Left Circumflex)nvarchar20CHAR(N' ')YesN2_CALC11AR Allow NULL? 
125N8CALC11KOCardiology: LCX - 11 Stenosis Collateral. (Left Circumflex)char10CHAR(N' ')YesN2_CALC11KO Allow NULL? 
126N8CALC11KACardiology: LCX - 11 Stenosis Ca++ (Left Circumflex)char10CHAR(N' ')YesN2_CALC11KA Allow NULL? 
127N8CALC11LGCardiology: LCX - 11 Stenosis Length (Left Circumflex)char10CHAR(N' ')YesN2_CALC11LG Allow NULL? 
128N8CALC11TYCardiology: LCX - 11 Stenosis Type (Left Circumflex)nvarchar20CHAR(N' ')YesN2_CALC11TY Allow NULL? 
129N8CALC11BECardiology: LCX - 11 Stenosis Comment (Left Circumflex)nvarchar600CHAR(N' ')YesN2_CALC11BE Allow NULL? 
130N8CAMA12GRCardiology: MARG - 12 Stenosis Degree (Ramus Marginalis)nvarchar30CHAR(N' ')YesN2_CAMA12GR Allow NULL? 
131N8CAMA12ARCardiology: MARG - 12 Stenosis Area (Ramus Marginalis)nvarchar20CHAR(N' ')YesN2_CAMA12AR Allow NULL? 
132N8CAMA12KOCardiology: MARG - 12 Stenosis Collateral. (Ramus Marginal.)char10CHAR(N' ')YesN2_CAMA12KO Allow NULL? 
133N8CAMA12KACardiology: MARG - 12 Stenosis Ca++ (Ramus Marginalis)char10CHAR(N' ')YesN2_CAMA12KA Allow NULL? 
134N8CAMA12LGCardiology: MARG - 12 Stenosis Length (Ramus Marginalis)char10CHAR(N' ')YesN2_CAMA12LG Allow NULL? 
135N8CAMA12TYCardiology: MARG - 12 Stenosis Type (Ramus Marginalis)nvarchar20CHAR(N' ')YesN2_CAMA12TY Allow NULL? 
136N8CAMA12BECardiology: MARG - 12 Stenosis Comment (Ramus Marginalis)nvarchar600CHAR(N' ')YesN2_CAMA12BE Allow NULL? 
137N8CALC13GRCKardiology: LCX - 13 Stenosis Degree (Left Circumflex)nvarchar30CHAR(N' ')YesN2_CALC13GR Allow NULL? 
138N8CALC13ARCardiology: LCX - 13 Stenosis Area (Left Circumflex)nvarchar20CHAR(N' ')YesN2_CALC13AR Allow NULL? 
139N8CALC13KOCardiology: LCX - 13 Stenosis Collateral. (Left Circumflex)char10CHAR(N' ')YesN2_CALC13KO Allow NULL? 
140N8CALC13KACardiology: LCX - 13 Stenosis Ca++ (Left Circumflex)char10CHAR(N' ')YesN2_CALC13KA Allow NULL? 
141N8CALC13LGCardiology: LCX - 13 Stenosis Length (Left Circumflex)char10CHAR(N' ')YesN2_CALC13LG Allow NULL? 
142N8CALC13TYCardiology: LCX - 13 Stenosis Type (Left Circumflex)nvarchar20CHAR(N' ')YesN2_CALC13TY Allow NULL? 
143N8CALC13BECardiology: LCX - 13 Stenosis Comment (Left Circumflex)nvarchar600CHAR(N' ')YesN2_CALC13BE Allow NULL? 
144N8CARP14GRCardiology: RPLS - 14 Stenosis Degree(Ramus Poster. Sinist.)nvarchar30CHAR(N' ')YesN2_CARP14GR Allow NULL? 
145N8CARP14ARCardiology: RPLS -14 Stenosis Area (Ramus Poster. Sinis.)nvarchar20CHAR(N' ')YesN2_CARP14AR Allow NULL? 
146N8CARP14KOCardiology: RPLS 14 Stenos. Collat. (Ramus Poster. Sinis.)char10CHAR(N' ')YesN2_CARP14KO Allow NULL? 
147N8CARP14KACardiology: RPLS - 14 Stenosis Ca++ (Ramus Poster. Sinis.)char10CHAR(N' ')YesN2_CARP14KA Allow NULL? 
148N8CARP14LGCardiology: RPLS - 14 Stenosis Length (Ramus Poster. Sinis.)char10CHAR(N' ')YesN2_CARP14LG Allow NULL? 
149N8CARP14TYCardiology: RPLS - 14 Stenosis Type (Ramus Poster. Sinis.)nvarchar20CHAR(N' ')YesN2_CARP14TY Allow NULL? 
150N8CARP14BECardiology: RPLS -14 Stenosis Comment (Ramus Poster. Sin.)nvarchar600CHAR(N' ')YesN2_CARP14BE Allow NULL? 
151N8CALC15GRCardiology: LCX - 15 Stenosis Degree (Left Circumflex)nvarchar30CHAR(N' ')YesN2_CALC15GR Allow NULL? 
152N8CALC15ARCardiology: LCX - 15 Stenosis Area (Left Circumflex)nvarchar20CHAR(N' ')YesN2_CALC15AR Allow NULL? 
153N8CALC15KOCardiology: LCX - 15 Stenosis Collateral. (Left Circumflex)char10CHAR(N' ')YesN2_CALC15KO Allow NULL? 
154N8CALC15KACardiology: LCX - 15 Stenosis Ca++ (Left Circumflex)char10CHAR(N' ')YesN2_CALC15KA Allow NULL? 
155N8CALC15LGCardiology: LCX - 15 Stenosis Length (Left Circumflex)char10CHAR(N' ')YesN2_CALC15LG Allow NULL? 
156N8CALC15TYCardiology: LCX - 15 Stenosis Type (Left Circumflex)nvarchar20CHAR(N' ')YesN2_CALC15TY Allow NULL? 
157N8CALC15BECardiology: LCX - 15 Stenosis Comment (Left Circumflex)nvarchar600CHAR(N' ')YesN2_CALC15BE Allow NULL? 
158N8CARIMGRCardiology: RIM Stenosis Degree (Ramus Intermedius)nvarchar30CHAR(N' ')YesN2_CARIMGR Allow NULL? 
159N8CARIMARCardiology: RIM Stenosis Area (Ramus Intermedius)nvarchar20CHAR(N' ')YesN2_CARIMAR Allow NULL? 
160N8CARIMKOCardiology: RIM Stenosis Collateralis. (Ramus Intermedius)char10CHAR(N' ')YesN2_CARIMKO Allow NULL? 
161N8CARIMKACardiology: RIM Stenosis Ca++ (Ramus Intermedius)char10CHAR(N' ')YesN2_CARIMKA Allow NULL? 
162N8CARIMLGCardiology: RIM Stenosis Length (Ramus Intermedius)char10CHAR(N' ')YesN2_CARIMLG Allow NULL? 
163N8CARIMTYCardiology: RIM Stenosis Type (Ramus Intermedius)nvarchar20CHAR(N' ')YesN2_CARIMTY Allow NULL? 
164N8CARIMBECardiology: RIM Stenosis Comment (Ramus Intermedius)nvarchar600CHAR(N' ')YesN2_CARIMBE Allow NULL? 
165N8CAHKRBINCardiology: Fixed Values Type Interventionchar10CHAR(N' ')YesN2_CAHKRBIN Allow NULL? 
166N8CAHKVETYCardiology: Fixed Values Type Ventriculographynvarchar20CHAR(N' ')YesN2_CAHKVETY Allow NULL? 
167N8CAHKVEOKCardiology: Checkbox Ventriculography Non-Pathologicalchar10CHAR(N' ')YesN2_CAHKVEOK Allow NULL? 
168N8CALV_MOBCardiology: Left Ventricle Global Mobilitychar10CHAR(N' ')YesN2_CAGLMB Allow NULL? 
169N8CALV_EFCardiology: LV Ejection Fraction (%)nvarchar20NUMC(N'00')YesN2_CALVEF Allow NULL? 
170N8CALV_WTECardiology: End-Diastolic Wall Thickness (mm)nvarchar20NUMC(N'00')YesN2_CAWTED Allow NULL? 
171N8CARV_MOBCardiology: Right Ventricle Global Mobilitychar10CHAR(N' ')YesN2_CAGRMB Allow NULL? 
172N8CALVVPASCardiology: Systolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRSY Allow NULL? 
173N8CALVVPADCardiology: Pre-Angio LVEDPnvarchar20NUMC(N'00')YesN2_CARRLV Allow NULL? 
174N8CALVVOASCardiology: Systolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRSY Allow NULL? 
175N8CALVVOADCardiology: Post Angio LVEDPnvarchar20NUMC(N'00')YesN2_CAROLV Allow NULL? 
176N8CALVAPASCardiology: Systolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRSY Allow NULL? 
177N8CALVAPADCardiology: Diastolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRDI Allow NULL? 
178N8CALVAPAMCardiology: Blood Pressure Mean Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRMI Allow NULL? 
179N8CALVAOASCardiology: Systolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRSY Allow NULL? 
180N8CALVAOADCardiology: Diastolic Blood Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRDI Allow NULL? 
181N8CALVAOAMCardiology: Blood Pressure Mean Pressure (mmHg)nvarchar30NUMC(N'000')YesN2_CARRMI Allow NULL? 
182N8CA_ANVENReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
183N8CARAABCardiology: Ventriculogr. RAO 1 - Anterobasalchar10CHAR(N' ')YesN2_CARAAB Allow NULL? 
184N8CARAALCardiology: Ventriculogr. RAO 2 - Anterolateralchar10CHAR(N' ')YesN2_CARAAL Allow NULL? 
185N8CARAAPCardiology: Ventriculogr. RAO 3 - Apicalchar10CHAR(N' ')YesN2_CARAAP Allow NULL? 
186N8CARAINCardiology: Ventriculogr. RAO 4 - Inferiorchar10CHAR(N' ')YesN2_CARAIN Allow NULL? 
187N8CARAPBCardiology: Ventriculogr. RAO 5 - Posterobasalchar10CHAR(N' ')YesN2_CARAPB Allow NULL? 
188N8CALASECardiology: Ventriculogr. LAO 6 - Septalchar10CHAR(N' ')YesN2_CALASE Allow NULL? 
189N8CALAPLCardiology: Ventriculogr. LAO 7 - Posterolateralchar10CHAR(N' ')YesN2_CALAPL Allow NULL? 
190N8CAHKRBVICardiology: Fixed Values Type Hemodynamicsnvarchar20CHAR(N' ')YesN2_CAHKRBVI Allow NULL? 
191N8CAHKHAOKCardiology: Checkbox Hemodynamics Non-Pathologicalchar10CHAR(N' ')YesN2_CAHKHAOK Allow NULL? 
192N8CAHKVISHCardiology: Fixed Values Shuntnvarchar20CHAR(N' ')YesN2_CAHKVISH Allow NULL? 
193N8CAHKHBCardiology: Hemoglobin Value (g/dl) (Directly Determined)decimal31DEC((0))YesN2_CAHKHB
194N8CA_PULSCardiology: Heart Rate / Min.nvarchar30NUMC(N'000')YesN2_CAPULS Allow NULL? 
195N8CAHKO2Cardiology: Oxygen Conxumption : BSA * 125mldecimal52DEC((0))YesN2_CAHKO2
196N8CAHKZVSOCardiology: Central Venous Oxygen Saturationnvarchar30NUMC(N'000')YesN2_CAHKZVSO Allow NULL? 
197N8CA_HMVCardiology: Cardiac Output (l/min)decimal42DEC((0))YesN2_CAHMV
198N8CA_HMVOCardiology: Cardiac Output (l/min) over Oxygendecimal42DEC((0))YesN2_CAHMVO
199N8CA_TPRRCardiology: Total Peripheral Resistance (TPR) Restingnvarchar40NUMC(N'0000')YesN2_CATPR Allow NULL? 
200N8CA_TPRPCardiology: Total Peripheral Resistance (TPR) Postnvarchar40NUMC(N'0000')YesN2_CATPRP Allow NULL? 
201N8CA_PARRCardiology: Pulmonary Arteriolar Resistance (PAR) Restingnvarchar40NUMC(N'0000')YesN2_CAPAR Allow NULL? 
202N8CA_PARPCardiology: Pulmonary Arteriolar Resistance (PAR) Postnvarchar40NUMC(N'0000')YesN2_CAPARP Allow NULL? 
203N8CA_SVRRCardiology: Systemic Vascular Resistance (SVR) Restingnvarchar40NUMC(N'0000')YesN2_CASVR Allow NULL? 
204N8CA_SVRPCardiology: Systemic Vascular Resistance (SVR) Postnvarchar40NUMC(N'0000')YesN2_CASVRP Allow NULL? 
205N8CA_TPGRCardiology: Transpulmonary Gradient (TPG) Restingnvarchar30NUMC(N'000')YesN2_CATGR Allow NULL? 
206N8CA_TPGPCardiology: Transpulmonary Gradient (TPG) Postnvarchar30NUMC(N'000')YesN2_CATGP Allow NULL? 
207N8CA_TPGTCardiology: Transpulmonary Gradient (TPG) After Therapynvarchar30NUMC(N'000')YesN2_CATGT Allow NULL? 
208N8CALV_EDVCardiology: LV End-Diast. Volume (EDV)nvarchar30NUMC(N'000')YesN2_CALVDV Allow NULL? 
209N8CALV_ESVCardiology: LV End-Syst. Volume (ESV)nvarchar30NUMC(N'000')YesN2_CALVESV Allow NULL? 
210N8CALV_SVCardiology: LV Stroke Volume in mlnvarchar30NUMC(N'000')YesN2_CALVSV Allow NULL? 
211N8CALVSVICardiology: LV Stroke Volume Index in ml/m2decimal41DEC((0))YesN2_CALVSVI
212N8CALV_DVICardiology: End-Diastolic Volume Index (ml/m2)decimal41DEC((0))YesN2_CAEDVI
213N8CALV_SVICardiology: LV End-Systolic Volume Index (ml/m2)decimal41DEC((0))YesN2_CAESVI
214N8CA_CICardiology: Cardiac Index [l / (min/m2)]decimal21DEC((0))YesN2_CACI
215X00ALV_EFCardiology: LV Ejection Fraction (%)nvarchar20NUMC(N'00')YesN2_CALVEF Allow NULL? 
216N8CASHASDCardiology: Shunts Checkbox ASDchar10CHAR(N' ')YesN2_CASHASD Allow NULL? 
217N8CASHVSDCardiology Shunts Checkbox VSDchar10CHAR(N' ')YesN2_CASHVSD Allow NULL? 
218N8CASHVOLRCardiology: Shunt Vitien Volume Left/Rightnvarchar30NUMC(N'000')YesN2_CASHVOL Allow NULL? 
219N8CASHVORLCardiology: Shunt Vitien Volume Right>Leftnvarchar30NUMC(N'000')YesN2_CASHVOR Allow NULL? 
220N8CASHHMVGCardiology: Shunts CO (Gr. Circ)decimal42DEC((0))YesN2_CASHHMVG
221N8CASHHMVKCardiology: Shunts CO (Ls. Circ)decimal42DEC((0))YesN2_CASHHMVK
222N8CASHHMVECardiology: Shunts Eff. COdecimal42DEC((0))YesN2_CASHHMVE
223N8CAAV_OKCardiology: Cardiac Valve - Normalchar10CHAR(N' ')YesN2_CAVAOK Allow NULL? 
224N8CADAVGMXCardiology: Maximum Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGM Allow NULL? 
225N8CADAVGMNCardiology: Median Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGN Allow NULL? 
226N8CADAVSTECardiology: Cardiac Valve Degree of Stenosischar10CHAR(N' ')YesN2_CADPSG Allow NULL? 
227N8CADAVINSCardiology: Cardiac Valve Degree of Insufficiencychar10CHAR(N' ')YesN2_CADPIG Allow NULL? 
228N8CAAVAREACardiology: Cardiac Valve - Opening Area (cm2)decimal32DEC((0))YesN2_CAVAAR
229N8CAAVKALKCardiology: Aortic Valve Ca++char10CHAR(N' ')YesN2_CAAVKALK Allow NULL? 
230N8CAMV_OKCardiology: Cardiac Valve - Normalchar10CHAR(N' ')YesN2_CAVAOK Allow NULL? 
231N8CADMVGMXCardiology: Maximum Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGM Allow NULL? 
232N8CADMVGMNCardiology: Median Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGN Allow NULL? 
233N8CADMVSTECardiology: Cardiac Valve Degree of Stenosischar10CHAR(N' ')YesN2_CADPSG Allow NULL? 
234N8CADMVINSCardiology: Cardiac Valve Degree of Insufficiencychar10CHAR(N' ')YesN2_CADPIG Allow NULL? 
235N8CAMVAREACardiology: Cardiac Valve - Opening Area (cm2)decimal32DEC((0))YesN2_CAVAAR
236N8CAMVKALKCardiology: Mitral Valve Calcchar10CHAR(N' ')YesN2_CAMVKALK Allow NULL? 
237N8CATV_OKCardiology: Cardiac Valve - Normalchar10CHAR(N' ')YesN2_CAVAOK Allow NULL? 
238N8CADTVGMXCardiology: Maximum Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGM Allow NULL? 
239N8CADTVGMNCardiology: Median Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGN Allow NULL? 
240N8CADTVSTECardiology: Cardiac Valve Degree of Stenosischar10CHAR(N' ')YesN2_CADPSG Allow NULL? 
241N8CADTVINSCardiology: Cardiac Valve Degree of Insufficiencychar10CHAR(N' ')YesN2_CADPIG Allow NULL? 
242N8CAPV_OKCardiology: Cardiac Valve - Normalchar10CHAR(N' ')YesN2_CAVAOK Allow NULL? 
243N8CADPVGMXCardiology: Maximum Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGM Allow NULL? 
244N8CADPVGMNCardiology: Median Gradient (mmHg)nvarchar30NUMC(N'000')YesN2_CADPGN Allow NULL? 
245N8CADPVSTECardiology: Cardiac Valve Degree of Stenosischar10CHAR(N' ')YesN2_CADPSG Allow NULL? 
246N8CADPVINSCardiology: Cardiac Valve Degree of Insufficiencychar10CHAR(N' ')YesN2_CADPIG Allow NULL? 
247N8CAHKAADRCardiology: Vitien Aorta Asc. Pressure Resting (mmHg)decimal30DEC((0))YesN2_CAAADR
248N8CAHKAADBCardiology: Vitien Aorta Asc. Pressure Condition (mmHg)decimal30DEC((0))YesN2_CAAADB
249N8CAHKADDRCardiology: Vitien Aorta Desc. Pressure Resting (mmHg)decimal30DEC((0))YesN2_CAADDR
250N8CAHKADDBCardiology: Vitien Aorta Desc. Pressure Condition (mmHg)decimal30DEC((0))YesN2_CAADDB
251N8CAHKPADRCardiology: Vitien Pulmonary Artery Pressure Restingdecimal30DEC((0))YesN2_CAPADR
252N8CAHKPADBCardiology: Vitien Pulmonary Artery Pressure Conditiondecimal30DEC((0))YesN2_CAPADB
253N8CAHKPCDRCardiology: Pulmonary Valve Pressure Resting (mmHg)decimal30DEC((0))YesN2_CAPCDR
254N8CAHKPCDBCardiology: Vitien Pulmonary Valve Pressure Condition (mmHg)decimal30DEC((0))YesN2_CAPCDB
255N8CAHKLADRCardiology: Vitien Left Atrium. Pressure Resting (mmHg)decimal30DEC((0))YesN2_CALADR
256N8CAHKLADBCardiology: Vitien Left Atrium Pressure Condition (mmHg)decimal30DEC((0))YesN2_CALADB
257N8CAHKRADRCardiology: Vitien Right Atrium Pressure Restingdecimal30DEC((0))YesN2_CARADR
258N8CAHKRADBCardiology: Vitien Right Atrium Pressure Condition (mmHg)decimal30DEC((0))YesN2_CARADB
259N8CAHKLVDRCardiology: Vitien Left Chamber Pressure Resting (mmHg)decimal30DEC((0))YesN2_CALVDR
260N8CAHKLVDBCardiology: Vitien Left Chamber Pressure Condition (mmHg)decimal30DEC((0))YesN2_CALVDB
261N8CAHKRVDRCardiology: Vitien Right Chamber Pressure Resting (mmHg)decimal30DEC((0))YesN2_CARVDR
262N8CAHKRVDBCardiology: Vitien Right Chamber Pressure Condition (mmHg)decimal30DEC((0))YesN2_CARVDB
263N8CAHKLVORCardiology: Vitien LV Outflow Tract Pressure Resting (mmHg)decimal30DEC((0))YesN2_CALVOR
264N8CAHKLVOBCardiology: Vitien LVOT Pressure Condition (mmHg)decimal30DEC((0))YesN2_CALVOB
265N8CAHKRVORCardiology: Vitien RV Outflow Tract Pressure Resting (mmHg)decimal30DEC((0))YesN2_CARVOR
266N8CAHKRVOBCardiology: Vitien RV Outflow Tract Pressure Condit. (mmHg)decimal30DEC((0))YesN2_CARVOB
267N8CAHDAADRCardiology: Vitien Aorta Asc. Pressure Resting (mmHg)decimal30DEC((0))YesN2_CAAADR
268N8CAHDAADBCardiology: Vitien Aorta Asc. Pressure Condition (mmHg)decimal30DEC((0))YesN2_CAAADB
269N8CAHDADDRCardiology: Vitien Aorta Desc. Pressure Resting (mmHg)decimal30DEC((0))YesN2_CAADDR
270N8CAHDADDBCardiology: Vitien Aorta Desc. Pressure Condition (mmHg)decimal30DEC((0))YesN2_CAADDB
271N8CAHDPADRCardiology: Vitien Pulmonary Artery Pressure Restingdecimal30DEC((0))YesN2_CAPADR
272N8CAHDPADBCardiology: Vitien Pulmonary Artery Pressure Conditiondecimal30DEC((0))YesN2_CAPADB
273N8CAHDPCDRCardiology: Pulmonary Valve Pressure Resting (mmHg)decimal30DEC((0))YesN2_CAPCDR
274N8CAHDPCDBCardiology: Vitien Pulmonary Valve Pressure Condition (mmHg)decimal30DEC((0))YesN2_CAPCDB
275N8CAHDLADRCardiology: Vitien Left Atrium. Pressure Resting (mmHg)decimal30DEC((0))YesN2_CALADR
276N8CAHDLADBCardiology: Vitien Left Atrium Pressure Condition (mmHg)decimal30DEC((0))YesN2_CALADB
277N8CAHDRADRCardiology: Vitien Right Atrium Pressure Restingdecimal30DEC((0))YesN2_CARADR
278N8CAHDRADBCardiology: Vitien Right Atrium Pressure Condition (mmHg)decimal30DEC((0))YesN2_CARADB
279N8CAHDLVDRCardiology: Vitien Left Chamber Pressure Resting (mmHg)decimal30DEC((0))YesN2_CALVDR
280N8CAHDLVDBCardiology: Vitien Left Chamber Pressure Condition (mmHg)decimal30DEC((0))YesN2_CALVDB
281N8CAHDRVDRCardiology: Vitien Right Chamber Pressure Resting (mmHg)decimal30DEC((0))YesN2_CARVDR
282N8CAHDRVDBCardiology: Vitien Right Chamber Pressure Condition (mmHg)decimal30DEC((0))YesN2_CARVDB
283N8CAHDLVORCardiology: Vitien LV Outflow Tract Pressure Resting (mmHg)decimal30DEC((0))YesN2_CALVOR
284N8CAHDLVOBCardiology: Vitien LVOT Pressure Condition (mmHg)decimal30DEC((0))YesN2_CALVOB
285N8CAHDRVORCardiology: Vitien RV Outflow Tract Pressure Resting (mmHg)decimal30DEC((0))YesN2_CARVOR
286N8CAHDRVOBCardiology: Vitien RV Outflow Tract Pressure Condit. (mmHg)decimal30DEC((0))YesN2_CARVOB
287N8CAHMAADRCardiology: Vitien Aorta Asc. Pressure Resting (mmHg)decimal30DEC((0))YesN2_CAAADR
288N8CAHMAADBCardiology: Vitien Aorta Asc. Pressure Condition (mmHg)decimal30DEC((0))YesN2_CAAADB
289N8CAHMADDRCardiology: Vitien Aorta Desc. Pressure Resting (mmHg)decimal30DEC((0))YesN2_CAADDR
290N8CAHMADDBCardiology: Vitien Aorta Desc. Pressure Condition (mmHg)decimal30DEC((0))YesN2_CAADDB
291N8CAHMPADRCardiology: Vitien Pulmonary Artery Pressure Restingdecimal30DEC((0))YesN2_CAPADR
292N8CAHMPADBCardiology: Vitien Pulmonary Artery Pressure Conditiondecimal30DEC((0))YesN2_CAPADB
293N8CAHMPCDRCardiology: Pulmonary Valve Pressure Resting (mmHg)decimal30DEC((0))YesN2_CAPCDR
294N8CAHMPCDBCardiology: Vitien Pulmonary Valve Pressure Condition (mmHg)decimal30DEC((0))YesN2_CAPCDB
295N8CAHMLADRCardiology: Vitien Left Atrium. Pressure Resting (mmHg)decimal30DEC((0))YesN2_CALADR
296N8CAHMLADBCardiology: Vitien Left Atrium Pressure Condition (mmHg)decimal30DEC((0))YesN2_CALADB
297N8CAHMRADRCardiology: Vitien Right Atrium Pressure Restingdecimal30DEC((0))YesN2_CARADR
298N8CAHMRADBCardiology: Vitien Right Atrium Pressure Condition (mmHg)decimal30DEC((0))YesN2_CARADB
299N8CAHMLVDRCardiology: Vitien Left Chamber Pressure Resting (mmHg)decimal30DEC((0))YesN2_CALVDR
300N8CAHMLVDBCardiology: Vitien Left Chamber Pressure Condition (mmHg)decimal30DEC((0))YesN2_CALVDB
301N8CAHMRVDRCardiology: Vitien Right Chamber Pressure Resting (mmHg)decimal30DEC((0))YesN2_CARVDR
302N8CAHMRVDBCardiology: Vitien Right Chamber Pressure Condition (mmHg)decimal30DEC((0))YesN2_CARVDB
303N8CAHMLVORCardiology: Vitien LV Outflow Tract Pressure Resting (mmHg)decimal30DEC((0))YesN2_CALVOR
304N8CAHMLVOBCardiology: Vitien LVOT Pressure Condition (mmHg)decimal30DEC((0))YesN2_CALVOB
305N8CAHMRVORCardiology: Vitien RV Outflow Tract Pressure Resting (mmHg)decimal30DEC((0))YesN2_CARVOR
306N8CAHMRVOBCardiology: Vitien RV Outflow Tract Pressure Condit. (mmHg)decimal30DEC((0))YesN2_CARVOB
307N8CAHKOXPTCardiology: Oxygen Saturation (%) Pulmonary Art. - Truncnvarchar30NUMC(N'000')YesN2_CAHKOXTR Allow NULL? 
308N8CAHKOXPRCardio: Oxygen Saturation (%) Pulmonary Art. Right Branchnvarchar30NUMC(N'000')YesN2_CAHKOXPR Allow NULL? 
309N8CAHKOXPLCardio: Oxygen Saturation (%) Pulmonary Artery Left Branchnvarchar30NUMC(N'000')YesN2_CAHKOXPL Allow NULL? 
310N8CAHKOXRKCardiology: Oxygen Saturation (%) Right Chambernvarchar30NUMC(N'000')YesN2_CAHKOXRK Allow NULL? 
311N8CAHKOXRVCardiology: Oxygen Saturation (%) Right Atriumnvarchar30NUMC(N'000')YesN2_CAHKOXRV Allow NULL? 
312N8CAHKOXIPCardiology: Oxygen Saturation (%) Vena Cava Infer. Prox.nvarchar30NUMC(N'000')YesN2_CAHKOXIP Allow NULL? 
313N8CAHKOXIDCardiology: Oxygen Saturation (%) Vena Cava Inf. Distalnvarchar30NUMC(N'000')YesN2_CAHKOXID Allow NULL? 
314N8CAHKOXSPCardiology: Oxygen Saturation (%) Vena Cava Super. Prox.nvarchar30NUMC(N'000')YesN2_CAHKOXSP Allow NULL? 
315N8CAHKOXSDCardiology: Oxygen Saturation (%) Vena Cava Super. Dist.nvarchar30NUMC(N'000')YesN2_CAHKOXSD Allow NULL? 
316N8CAHKOXATCardiology: Oxygen Saturation (%) Aorta - Truncusnvarchar30NUMC(N'000')YesN2_CAHKOXAT Allow NULL? 
317N8CAHKOXLKCardiology: Oxygen Saturation (%) Left Chambernvarchar30NUMC(N'000')YesN2_CAHKOXLK Allow NULL? 
318N8CAHKOXLVCardiology: Oxygen Saturation (%) Left Atriumnvarchar30NUMC(N'000')YesN2_CAHKOXLV Allow NULL? 
319N8CA_HTVITReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
320N8CAHKKSCardiology: Coronary Statusnvarchar150CHAR(N' ')YesN2_CAHKKS Allow NULL? 
321N8CAHKLPCardiology: LV Pump Functionnvarchar150CHAR(N' ')YesN2_CAHKLP Allow NULL? 
322N8CAHKINCardiology: Interventionnvarchar150CHAR(N' ')YesN2_CAHKIN Allow NULL? 
323N8CAHKAGCardiology: Acute Activitynvarchar150CHAR(N' ')YesN2_CAHKAG Allow NULL? 
324N8CAHKZNCardiology: Condition Afternvarchar150CHAR(N' ')YesN2_CAHKZN Allow NULL? 
325N8CAHKZECardiology: Condition After Other Card. Diseasenvarchar150CHAR(N' ')YesN2_CAHKZE Allow NULL? 
326N8CAHKIHCardiology: Intervention Hist.nvarchar150CHAR(N' ')YesN2_CAHKIH Allow NULL? 
327N8CAHKA1Cardiology: Other (1)nvarchar150CHAR(N' ')YesN2_CAHKA1 Allow NULL? 
328N8CAHKA2Cardiology: Other (2)nvarchar150CHAR(N' ')YesN2_CAHKA2 Allow NULL? 
329N8CARESTXTPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
330N8CARESUMEPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
331N8CAHKBETHCardiology: Therapy Recommendationchar10CHAR(N' ')YesN2_CAHKBETH Allow NULL? 
332GSDKKOMPKTReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
333X00KRESDATReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
334N8CARESDATCardiology: Date of Findingsnvarchar80DATS(N'00000000')YesN2_CARSDT Allow NULL? 
335GSDKRESGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
336ISHMVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
337ISHMVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
338N8CARESNAMCardiology: Name of Findings Creatornvarchar400CHAR(N' ')YesN2_CARSNM Allow NULL? 
339ISHMVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
340GSDKRESGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
341X00MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
342X00MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
343N8CARESNM2Cardiology: Name of Supervisornvarchar400CHAR(N' ')YesN2_CASVNM Allow NULL? 
344X00MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
345N8CAL_VBReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
346N8CA_XDATCardiology: Checkbox Data Was Importedchar10CHAR(N' ')YesN2_CAXDAT Allow NULL? 
347N8CA_EINRIInstitutionnvarchar40CHAR(N' ')Yes*EINRI Allow NULL? 
348N8CA_SDESTSymbolic Destinationnvarchar80CHAR(N' ')YesN2_DSSDEST Allow NULL? 
349N8CA_STUDAExamination Datenvarchar80DATS(N'00000000')YesN2_DSSTDATE Allow NULL? 
350N8CA_PATNRIS-H: Patient Numbernvarchar100CHAR(N' ')Yes*PATNR Allow NULL? 
351N8CA_UIDCharacter UIDnvarchar320CHAR(N' ')YesN2_CUID Allow NULL? 
352N8CA_DFLAGData Flag Import OKchar10CHAR(N' ')YesN2_DSIMPOK Allow NULL? 
353N8CAXKEBECardiology: Checkbox no Cardiovascular Risks Knownchar10CHAR(N' ')YesN2_CAKEBE Allow NULL? 
354N8CAANKACardiology: Condition After Coronary Angiographychar10CHAR(N' ')YesN2_CAANKA Allow NULL? 
355N8CAANINCardiology: Condition After Interventionchar10CHAR(N' ')YesN2_CAANIN Allow NULL? 
356N8CAANCBCardiology: Condition After Coronary Bypass Surgerychar10CHAR(N' ')YesN2_CAANCB Allow NULL? 
357N8CAANE4Cardiology: QA Ejection Fraction Under 40%char10CHAR(N' ')YesN2_CAANE4 Allow NULL? 
358N8CAANDMCardiology: Diabetes Mellituschar10CHAR(N' ')YesN2_CAANDM Allow NULL? 
359N8CAANNICardiology: Renal Insufficiencychar10CHAR(N' ')YesN2_CAANNI Allow NULL? 
360N8CAANKSCardiology: Acute Coronary Syndromechar10CHAR(N' ')YesN2_CAANKS Allow NULL? 
361N8CAANBICardiology: Stress Ischemiachar10CHAR(N' ')YesN2_CAANBI Allow NULL? 
362N8CAANKDCardiology: Cardiac Dyspnoeachar10CHAR(N' ')YesN2_CAANKD Allow NULL? 
363N8CAANSSCardiology: Anamnesis Data Other Symptomschar10CHAR(N' ')YesN2_CAANSS Allow NULL? 
364N8CAANIKCardiology: QA Indication Coronary Angiograghynvarchar20CHAR(N' ')YesN2_CAANIK Allow NULL? 
365N8CAANIPCardiology: QA Indication PCIchar10CHAR(N' ')YesN2_CAANIP Allow NULL? 
366N8CAPDNPCardiology: What Number Procedure of this Staynvarchar20NUMC(N'00')YesN2_CAPDNP Allow NULL? 
367N8CAPDHICardiology: Manifest Cardiac Insufficiency Before Procedurechar10CHAR(N' ')YesN2_CAPDHI Allow NULL? 
368N8CAPDKSCardiology: Cardiogenic Shock at Start of Procedurechar10CHAR(N' ')YesN2_CAPDKS Allow NULL? 
369N8CAPDPRCardiology: Procedure Typechar10CHAR(N' ')YesN2_CAPDPR Allow NULL? 
370N8CAPDNKCardiology: What Number Diagnostic Coronary Angio of Staynvarchar20NUMC(N'00')YesN2_CAPDNK Allow NULL? 
371N8CAPDHDCardio: Principal Diagbnosis After Diagnostic Cardiac Cath.nvarchar20CHAR(N' ')YesN2_CAPDHD Allow NULL? 
372N8CAPDNDCardio: First Secondary Diagnosis After Diagn. Cardiac Cath.nvarchar20CHAR(N' ')YesN2_CAPDND Allow NULL? 
373N8CAPDTECardiology: Therapy Recomms After Diagn. Cardiac Catheterchar10CHAR(N' ')YesN2_CAPDTE Allow NULL? 
374N8CAPDNICardiology: What Number PCI of This Staynvarchar20NUMC(N'00')YesN2_CAPDNI Allow NULL? 
375N8CAPDPACardiology: PCI on How Many Supply Areaschar10CHAR(N' ')YesN2_CAPDPA Allow NULL? 
376N8CAPDZECardiology: Important Intervention Target Reachedchar10CHAR(N' ')YesN2_CAPDZE Allow NULL? 
377N8CAPDBMCardiology: Special Characteristics PCIchar10CHAR(N' ')YesN2_CAPDBM Allow NULL? 
378N8CAPDGVCardiology: PCI on Complete Vascular Occlusionchar10CHAR(N' ')YesN2_CAPDGV Allow NULL? 
379N8CAPDHSCardiology: PCI on Unprotected Main Stemchar10CHAR(N' ')YesN2_CAPDHS Allow NULL? 
380N8CAPDLGCardiology: PCI on Last Remaining Vesselchar10CHAR(N' ')YesN2_CAPDLG Allow NULL? 
381N8CAPDKBCardiology: PCI of Coronary Bypasschar10CHAR(N' ')YesN2_CAPDKB Allow NULL? 
382N8CAPDOSCardiology: PCI of Ostium Stenosis LAD/RCX/RCAchar10CHAR(N' ')YesN2_CAPDOS Allow NULL? 
383N8CAPDSICardiology: Stent(s) Implantedchar10CHAR(N' ')YesN2_CAPDSI Allow NULL? 
384N8CAPDIKCardiology: Intraprocedurally Occurring Complicationschar10CHAR(N' ')YesN2_CAPDIK Allow NULL? 
385N8CAPDKVCardiology: Coronary Occlusionchar10CHAR(N' ')YesN2_CAPDKV Allow NULL? 
386N8CAPDRECardiology: Reanimationchar10CHAR(N' ')YesN2_CAPDRE Allow NULL? 
387N8CAPDTACardiology: TIA / Strokechar10CHAR(N' ')YesN2_CAPDTA Allow NULL? 
388N8CAPDSOCardiology: Other Complicationschar10CHAR(N' ')YesN2_CAPDSO Allow NULL? 
389N8CAPDETCardiology: Exitus in Cardiac Catheter Labchar10CHAR(N' ')YesN2_CAPDET Allow NULL? 
390N8CALV_PESCardiology: Post Extrasystolic Measurementchar10CHAR(N' ')YesN2_CAXPES Allow NULL? 
391X00A_HKNRReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
392N8CAKOMPKTReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
NamePrimaryUniqueTypeColumns
N2CA02~0YesYesCLUSTEREDDOKTL, DOKVR, DOKNR, DOKAR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy