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
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2CA151681PMD: N8CA_SPI i.s.h.med Cardiology:Clinical System
SQL:  selectupdate insert create

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

SELECT MANDT, DOKAR, DOKNR, DOKVR, DOKTL, GSDKPATKPF, ISHMPATNAM, ISHMPATNUM, ISHMPATGES, ISHMPATFAL, ISHMPATFAT, ISHMPATGEB, ISHMPATAPO, ISHMPATALT, N8CAPATALE, N8CAPATGEW, N8CAPATGRO, N8CAPATBMI, N8CAPATBSA, N8CAANFVMA, N8CAANFDAT, N8CAANFTIM, N8CAEXAROO, X00MKANAM, X00MFRGST, N8CASPIIND, N8CATSTUD, N8CA_ICDTY, N8CA_ICDMO, N8CA_PMTY, N8CA_PMMO, N8CA_NYHA, N8CA_CCS, N8CAXKEBE, N8CAXARTHY, N8CAXNICO, N8CAXDIABM, N8CAXHYLIP, N8CAXFAMA, N8CACAVSON, N8CASPXSP, N8CASPXBP, N8CASPXES, N8CAXKEMBE, N8CAXDIGIT, N8CAXBETA, N8CAXCAPLU, N8CAXANTIA, N8CAXPSYCH, N8CAMEDSON, N8CAXANTI2, N8CAEXADAT, N8CAEXATIM, N8CASP_DEV, GSDKEXGP, ISHMVMAKRZ, ISHMVMARNG, N8CAEXANAM, ISHMVMAFAR, GSDKASGP, X00MVMAKRZ, X00MVMARNG, N8CAASNAM1, X00MVMAFAR, GSDKEXGP2, X01MVMAKRZ, X01MVMARNG, N8CAEXANA2, X01MVMAFAR, GSDKASGP2, X02MVMAKRZ, X02MVMARNG, N8CAASNAM2, X02MVMAFAR, N8CASPAWVC, N8CASPAWVS, N8CASPAWVP, N8CASPAWER, N8CASPAWIR, N8CASPAWTV, N8CASPAWFV, N8CASPAWFS, N8CASPAWFP, N8CASPAWEV, N8CASPAWES, N8CASPAWEP, N8CASPAWTP, N8CASPAWAS, N8CASPAWSP, N8CASPAWF2, N8CASPAWF7, N8CASPAWPF, N8CASPAWIT, N8CASPAWRV, N8CASPAWTL, N8CASPAWRP, N8CASPAWRA, N8CASPAWRS, N8CASPAWLF, X00KSPAWBE, N8CASPLSSB, N8CASPLSSP, N8CASPLSMB, N8CASPLSMP, N8CASPMIMI, N8CASPMIMW, GSDKSPMIKO, N8CASPEWVC, N8CASPEWVS, N8CASPEWVP, N8CASPEWER, N8CASPEWIR, N8CASPEWTV, N8CASPEWFV, N8CASPEWFS, N8CASPEWFP, N8CASPEWEV, N8CASPEWES, N8CASPEWEP, N8CASPEWTP, N8CASPEWAS, N8CASPEWSP, N8CASPEWF2, N8CASPEWF7, N8CASPEWPF, N8CASPEWIT, N8CASPEWRV, N8CASPEWTL, N8CASPEWRP, N8CASPEWRA, N8CASPEWRS, N8CASPEWLF, X00KSPEWBE, N8CARESDAT, N8CARESTIM, GSDKRESGP, X03MVMAKRZ, X03MVMARNG, N8CARESNAM, X03MVMAFAR, GSDKRESGP2, X04MVMAKRZ, X04MVMARNG, N8CARESNM2, X04MVMAFAR, GSDKFIND, GSDKRESUME, GSDKHKVOEM, N8CARESXKT, N8CARESXUE, N8CASPICR1, N8CASPICR2, N8CASPICR3, N8CASPICR4, N8CASPICR5, N8CASPICR6, N8CASPICR7, N8CASPICR8, N8CASPICR9, GSDKSPILVB, N8CA_RST, N8CA_XDAT, N8CA_EINRI, N8CA_SDEST, N8CA_STUDA, N8CA_PATNR, N8CA_UID, N8CA_DFLAG FROM N2CA15
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? 
14ISHMPATALTPatient Agenvarchar30NUMC(N'000')YesN2_ALTERP Allow NULL? 
15N8CAPATALEUnit of Agechar10CHAR(N' ')YesN2_ALTEINH Allow NULL? 
16N8CAPATGEWBody Weight in Kgnvarchar30NUMC(N'000')YesN1KGEW Allow NULL? 
17N8CAPATGROHeight in Cmnvarchar30NUMC(N'000')YesN1KGR Allow NULL? 
18N8CAPATBMICardiology: Body Mass Index (xx,y) kg/m2decimal31DEC((0))YesN2_CA_BMI
19N8CAPATBSACardiology: Body Surface Area (x,yy) m2decimal32DEC((0))YesN2_CA_BSA
20N8CAANFVMAEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
21N8CAANFDATIS-H: Date when Record Creatednvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
22N8CAANFTIMIS-H: Time Record Creatednvarchar60TIMS(N'000000')YesRI_ERTIM Allow NULL? 
23N8CAEXAROOCardiology: Examination Roomnvarchar80CHAR(N' ')Yes*N2_CAEXRO Allow NULL? 
24X00MKANAMReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
25X00MFRGSTReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
26N8CASPIINDCardiology: Selection of Indicationnvarchar600CHAR(N' ')YesN2_CAINDC Allow NULL? 
27N8CATSTUDCardiology: Study Participationnvarchar150CHAR(N' ')YesN2_CATSTUD Allow NULL? 
28N8CA_ICDTYCardiology: ICD Typenvarchar300CHAR(N' ')YesN2_CAICDTY Allow NULL? 
29N8CA_ICDMOCardiology: ICD Modechar10CHAR(N' ')YesN2_CAICDMO Allow NULL? 
30N8CA_PMTYCardiology: Pacemaker Typenvarchar300CHAR(N' ')YesN2_CAPMTY Allow NULL? 
31N8CA_PMMOCardiology: Pacemaker Modenvarchar30CHAR(N' ')YesN2_CAPMMO Allow NULL? 
32N8CA_NYHACardiology: Fixed Values NYHA Classificationchar10CHAR(N' ')YesN2_CANYHA Allow NULL? 
33N8CA_CCSCardiology: Fixed Value CCS Statuschar10CHAR(N' ')YesN2_CACCS Allow NULL? 
34N8CAXKEBECardiology: Checkbox no Cardiovascular Risks Knownchar10CHAR(N' ')YesN2_CAKEBE Allow NULL? 
35N8CAXARTHYCardiology: Checkbox Art. Hypertensionchar10CHAR(N' ')YesN2_CAARTHY Allow NULL? 
36N8CAXNICOCardiology: Checkbox Nicotinechar10CHAR(N' ')YesN2_CANICO Allow NULL? 
37N8CAXDIABMCardiology: Checkbox Diabetes Mellituschar10CHAR(N' ')YesN2_CADIABM Allow NULL? 
38N8CAXHYLIPCardiology: Checkbox Hyperlipidemiachar10CHAR(N' ')YesN2_CAHYLIP Allow NULL? 
39N8CAXFAMACardiology: Checkbox Family Anamnesischar10CHAR(N' ')YesN2_CAFAMA Allow NULL? 
40N8CACAVSONCardiology: Other Cardiovascular Risk Factorsnvarchar600CHAR(N' ')YesN2_CACAVS Allow NULL? 
41N8CASPXSPCardiology: Spirometry Performedchar10CHAR(N' ')YesN2_CASPXSP Allow NULL? 
42N8CASPXBPCardiology: Body Plethysmography Completedchar10CHAR(N' ')YesN2_CASPXBP Allow NULL? 
43N8CASPXESCardiology: Spiroergometry Completedchar10CHAR(N' ')YesN2_CASPXES Allow NULL? 
44N8CAXKEMBECardiology: Checkbox No Relevant Medication Knownchar10CHAR(N' ')YesN2_CAKEMBE Allow NULL? 
45N8CAXDIGITCardiology: Checkbox Digitalischar10CHAR(N' ')YesN2_CADIGIT Allow NULL? 
46N8CAXBETACardiology: Checkbox Betablockerchar10CHAR(N' ')YesN2_CAXBETA Allow NULL? 
47N8CAXCAPLUCardiology: Checkbox Ca++ Antagonistschar10CHAR(N' ')YesN2_CAXCA Allow NULL? 
48N8CAXANTIACardiology: Checkbox Antiarrhythmics Cl. Ichar10CHAR(N' ')YesN2_CAXANTI Allow NULL? 
49N8CAXPSYCHCardiology: Checkbox Psychotropicschar10CHAR(N' ')YesN2_CAXPSY Allow NULL? 
50N8CAMEDSONCardiology: Other Relevant Medicationnvarchar400CHAR(N' ')YesN2_CAMEDS Allow NULL? 
51N8CAXANTI2Cardiology: Checkbox Antiarrhythmics Cl. IIIchar10CHAR(N' ')YesN2_CAXANTI2 Allow NULL? 
52N8CAEXADATCardiology: Date of Examinationnvarchar80DATS(N'00000000')YesN2_CAEXDT Allow NULL? 
53N8CAEXATIMCardiology: Time of Examinationnvarchar60TIMS(N'000000')YesN2_CAEXTM Allow NULL? 
54N8CASP_DEVCardiology: Spirometry Devicenvarchar250CHAR(N' ')YesN2_CA_SPD Allow NULL? 
55GSDKEXGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
56ISHMVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
57ISHMVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
58N8CAEXANAMCardiology: Name of Examinernvarchar400CHAR(N' ')YesN2_CAEXNM Allow NULL? 
59ISHMVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
60GSDKASGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
61X00MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
62X00MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
63N8CAASNAM1Cardiology: Name of Assistantnvarchar400CHAR(N' ')YesN2_CAASNM Allow NULL? 
64X00MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
65GSDKEXGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
66X01MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
67X01MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
68N8CAEXANA2Cardiology: Name of Examinernvarchar400CHAR(N' ')YesN2_CAEXNM Allow NULL? 
69X01MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
70GSDKASGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
71X02MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
72X02MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
73N8CAASNAM2Cardiology: Name of Assistantnvarchar400CHAR(N' ')YesN2_CAASNM Allow NULL? 
74X02MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
75N8CASPAWVCCardiology: Vital Capacity (Liters) Predecimal42DEC((0))YesN2_CASPAWVC
76N8CASPAWVSCardiology: Age and Weight-Dependent Target VC (l) Predecimal42DEC((0))YesN2_CASPAWVS
77N8CASPAWVPCardiology: Reached VC in Relation to Target Predecimal52DEC((0))YesN2_CASPAWVP
78N8CASPAWERCardiology: Expiratory Reserve Volume (Liters) Predecimal42DEC((0))YesN2_CASPAWER
79N8CASPAWIRCardiology: Inspiratory Reserve Volume (Liters) Predecimal42DEC((0))YesN2_CASPAWIR
80N8CASPAWTVCardiology: Tidal Volume (Liters) Predecimal32DEC((0))YesN2_CASPAWTV
81N8CASPAWFVCardiology: Forced Vital Capacity (Liters) Predecimal42DEC((0))YesN2_CASPAWFV
82N8CASPAWFSCardiology: Age and Weight-Dependent Target FVC Predecimal42DEC((0))YesN2_CASPAWFS
83N8CASPAWFPCardiology: Reached FVC in Relation to Target Predecimal52DEC((0))YesN2_CASPAWFP
84N8CASPAWEVCardiology: 1-Second Capacity (Liters) Predecimal42DEC((0))YesN2_CASPAWEV
85N8CASPAWESCardiology: Age and Weight-Dependent Target FEV Predecimal42DEC((0))YesN2_CASPAWES
86N8CASPAWEPCardiology: Reached FEV in Relation to Target Predecimal52DEC((0))YesN2_CASPAWEP
87N8CASPAWTPCardiology: FEV/FVC Ratio Predecimal52DEC((0))YesN2_CASPAWTP
88N8CASPAWASCardiology: Age and Weight-Dependent Target FEV % Predecimal52DEC((0))YesN2_CASPAWAS
89N8CASPAWSPCardiology: Reached FEV/FVC Ratio in % to Target Predecimal52DEC((0))YesN2_CASPAWSP
90N8CASPAWF2Cardiology: Forced Expiratory Flow 25-75 % Predecimal42DEC((0))YesN2_CASPAWF2
91N8CASPAWF7Cardiology: Forced Expiratory Flow 75-85 % Predecimal42DEC((0))YesN2_CASPAWF7
92N8CASPAWPFCardiology: Peak Expiratory Flow (l/s) Predecimal42DEC((0))YesN2_CASPAWPF
93N8CASPAWITCardiology: Intrathoracic Gas Volume (Liters) Predecimal42DEC((0))YesN2_CASPAWIT
94N8CASPAWRVCardiology: Residual Volume (Liters) Predecimal42DEC((0))YesN2_CASPAWRV
95N8CASPAWTLCardiology: Total Lung Capacity (Liters) Predecimal42DEC((0))YesN2_CASPAWTL
96N8CASPAWRPCardiology: Relative Residual Volume in % of TLC Predecimal52DEC((0))YesN2_CASPAWRP
97N8CASPAWRACardiology: Airway Resistance (kPa*s/l) Predecimal32DEC((0))YesN2_CASPAWRA
98N8CASPAWRSCardiology: Assessment of Resistance Loops Prenvarchar250CHAR(N' ')YesN2_CASPAWRS Allow NULL? 
99N8CASPAWLFCardiology: Lung Function Prechar10CHAR(N' ')YesN2_CASPAWLF Allow NULL? 
100X00KSPAWBEPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
101N8CASPLSSBCardiology: Checkbox for Bronchodilatation Medicationchar10CHAR(N' ')YesN2_CASPLSSB Allow NULL? 
102N8CASPLSSPCardiology: Checkbox for Provocation Medicationchar10CHAR(N' ')YesN2_CASPLSSP Allow NULL? 
103N8CASPLSMBCardiology: Medication for Bronchodilatationnvarchar400CHAR(N' ')YesN2_CASPLSMB Allow NULL? 
104N8CASPLSMPCardiology: Provocation Medicationnvarchar400CHAR(N' ')YesN2_CASPLSMP Allow NULL? 
105N8CASPMIMICardiology: Patient Cooperationnvarchar250CHAR(N' ')YesN2_CASPMIMI Allow NULL? 
106N8CASPMIMWCardiology: Assessment of Measured Valuesnvarchar250CHAR(N' ')YesN2_CASPMIMW Allow NULL? 
107GSDKSPMIKOPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
108N8CASPEWVCCardiology: Vital Capacity (Liters) Postdecimal42DEC((0))YesN2_CASPEWVC
109N8CASPEWVSCardiology: Age and Weight-Dependent Target VC Postdecimal42DEC((0))YesN2_CASPEWVS
110N8CASPEWVPCardiology: Reached VC in Relation to Target Postdecimal52DEC((0))YesN2_CASPEWVP
111N8CASPEWERCardiology: Expiratory Reserve Volume (Liters) Postdecimal42DEC((0))YesN2_CASPEWER
112N8CASPEWIRCardiology: Inspiratory Reserve Volume (Liters) Postdecimal42DEC((0))YesN2_CASPEWIR
113N8CASPEWTVCardiology: Tidal Volume (Liters) Postdecimal32DEC((0))YesN2_CASPEWTV
114N8CASPEWFVCardiology: Forced Vital Capacity (Liters) Postdecimal42DEC((0))YesN2_CASPEWFV
115N8CASPEWFSCardiology: Age and Weight-Dependent Target FVC Postdecimal42DEC((0))YesN2_CASPEWFS
116N8CASPEWFPCardiology: Reached FVC in Relation to Target Postdecimal52DEC((0))YesN2_CASPEWFP
117N8CASPEWEVCardiology: 1-Second Capacity (Liters) Postdecimal42DEC((0))YesN2_CASPEWEV
118N8CASPEWESCardiology: Age and Weight-Dependent Target FEV Postdecimal42DEC((0))YesN2_CASPEWES
119N8CASPEWEPCardiology: Reached FEV in Relation to Target Postdecimal52DEC((0))YesN2_CASPEWEP
120N8CASPEWTPCardiology: FEV/FVC Ratio Postdecimal52DEC((0))YesN2_CASPEWTP
121N8CASPEWASCardiology: Age and Weight-Dependent Target FEV % Postdecimal52DEC((0))YesN2_CASPEWAS
122N8CASPEWSPCardiology: Reached FEV/FVC Ratio in % to Target Postdecimal52DEC((0))YesN2_CASPEWSP
123N8CASPEWF2Cardiology: Forced Expiratory Flow 25-75 % Postdecimal42DEC((0))YesN2_CASPEWF2
124N8CASPEWF7Cardiology: Forced Expiratory Flow 75-85 % Postdecimal42DEC((0))YesN2_CASPEWF7
125N8CASPEWPFCardiology: Preak Expiratory Flow (l/s) Postdecimal42DEC((0))YesN2_CASPEWPF
126N8CASPEWITCardiology: Intrathoracic Gas Volume (Liters) Postdecimal42DEC((0))YesN2_CASPEWIT
127N8CASPEWRVCardiology: Residual Volume (Liters) Postdecimal42DEC((0))YesN2_CASPEWRV
128N8CASPEWTLCardiology: Total Lung Capacity (Liters) Postdecimal42DEC((0))YesN2_CASPEWTL
129N8CASPEWRPCardiology: Relative Residual Volume in % of TLC Postdecimal52DEC((0))YesN2_CASPEWRP
130N8CASPEWRACardiology: Airway Resistance (kPa*s/l) Postdecimal32DEC((0))YesN2_CASPEWRA
131N8CASPEWRSCardiology: Assessment of Resistance Loops Postnvarchar250CHAR(N' ')YesN2_CASPEWRS Allow NULL? 
132N8CASPEWLFCardiology: Lung Function Postchar10CHAR(N' ')YesN2_CASPEWLF Allow NULL? 
133X00KSPEWBEPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
134N8CARESDATCardiology: Date of Findingsnvarchar80DATS(N'00000000')YesN2_CARSDT Allow NULL? 
135N8CARESTIMCardiology: Time of Findings Creationnvarchar60TIMS(N'000000')YesN2_CARSTM Allow NULL? 
136GSDKRESGPReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
137X03MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
138X03MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
139N8CARESNAMCardiology: Name of Findings Creatornvarchar400CHAR(N' ')YesN2_CARSNM Allow NULL? 
140X03MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
141GSDKRESGP2Reference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
142X04MVMAKRZEmployee Responsiblenvarchar100CHAR(N' ')Yes*N1MITARB Allow NULL? 
143X04MVMARNGIS-H: Texts for ranksnvarchar150CHAR(N' ')YesISH_RANKTX Allow NULL? 
144N8CARESNM2Cardiology: Name of Supervisornvarchar400CHAR(N' ')YesN2_CASVNM Allow NULL? 
145X04MVMAFARIS-H: Name of Specialtynvarchar300CHAR(N' ')YesTEXT_KFA Allow NULL? 
146GSDKFINDPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
147GSDKRESUMEPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
148GSDKHKVOEMPMD: Reference by GUUIDnvarchar320CHAR(N' ')YesN2_REFUUID Allow NULL? 
149N8CARESXKTCardiology: Check-Up Checkboxchar10CHAR(N' ')YesN2_CARESXKT Allow NULL? 
150N8CARESXUECardiology: Checkbox Unchanged ECGchar10CHAR(N' ')YesN2_CARESXUE Allow NULL? 
151N8CASPICR1Cardiology: Criterion 1 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR1 Allow NULL? 
152N8CASPICR2Cardiology: Criterion 2 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR2 Allow NULL? 
153N8CASPICR3Cardiology: Criterion 3 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR3 Allow NULL? 
154N8CASPICR4Cardiology: Criterion 4 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR4 Allow NULL? 
155N8CASPICR5Cardiology: Criterion 5 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR5 Allow NULL? 
156N8CASPICR6Cardiology: Criterion 6 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR6 Allow NULL? 
157N8CASPICR7Cardiology: Criterion 7 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR7 Allow NULL? 
158N8CASPICR8Cardiology: Criterion 8 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR8 Allow NULL? 
159N8CASPICR9Cardiology: Criterion 9 Assessment Codenvarchar150CHAR(N' ')YesN2_CAKBCR9 Allow NULL? 
160GSDKSPILVBReference Key of a Referenced Objectnvarchar200CHAR(N' ')YesN2_REFKEY Allow NULL? 
161N8CA_RSTCardiology: Name of RST File for ECG Datanvarchar600CHAR(N' ')YesN2_CARST Allow NULL? 
162N8CA_XDATCardiology: Checkbox Data Was Importedchar10CHAR(N' ')YesN2_CAXDAT Allow NULL? 
163N8CA_EINRIInstitutionnvarchar40CHAR(N' ')Yes*EINRI Allow NULL? 
164N8CA_SDESTSymbolic Destinationnvarchar80CHAR(N' ')YesN2_DSSDEST Allow NULL? 
165N8CA_STUDAExamination Datenvarchar80DATS(N'00000000')YesN2_DSSTDATE Allow NULL? 
166N8CA_PATNRIS-H: Patient Numbernvarchar100CHAR(N' ')Yes*PATNR Allow NULL? 
167N8CA_UIDCharacter UIDnvarchar320CHAR(N' ')YesN2_CUID Allow NULL? 
168N8CA_DFLAGData Flag Import OKchar10CHAR(N' ')YesN2_DSIMPOK Allow NULL? 
NamePrimaryUniqueTypeColumns
N2CA15~0YesYesCLUSTEREDDOKTL, DOKVR, DOKNR, DOKAR, MANDT