D1@D53@D2009@D0@D1@D0@D4@D0@L@D0@D0@D0@D1D@D0@IGuid@D0@IE8910B8242C9D43E2C649F939534CAB0@D0@IType@D0@D8@D0@ICode@D0@A@D0@IDs@D0@ISecureLogin - Dossierkenmerken@D0@IInfo@D0@ISecureLogin - Dossierkenmerken@D0@IPrId@D0@ICrm@D0@ICtId@D0@A@D0@IAuId@D0@A@D0@IComp@D0@IDOSSI@D0@ITemp@D0@L@D0@IBl@D0@L@D0@IOwn@D0@I86519.admin@D0@ICrUs@D0@A@D0@ICrDt@D0@A@D0@IChUs@D0@I86519.admin@D0@IChDt@D0@H 44371.4103240741@D0@IClUs@D0@A@D0@IClDt@D0@A@D0@IMntL@D0@D0@D0@IUnCn@D0@L@D0@ISyId@D0@IKn@D0@ICnSn@D0@D19648@D0@IObId@D0@IB_Fco00@D0@IVisi@D0@L1@D0@IMd@D0@A@D0@INCnd@D0@A@D0@IUsAu@D0@L@D0@IBu@D0@DC8@D0@ISp@D0@D3@D1@D18@D2009@D0@D1@D0@I1@D0@D1@D0@D3@D0@I@D0@IKn@D0@I3C2BD93A454A0B311DDF428EE69E773F@D0@I@D0@D3@D0@D0@D0@DC@D0@Iinsert AfasMdView (AfasMdSystemId, AfasMdViewId, AfasMdName, AfasMdFilename, AfasMdTableId, AfasMdDescription, AfasMdCreateStatement, AfasMdCustom, AfasMdQuerytool, AfasMdFilterData, AfasMdGuid, AfasMdListUse, AfasMdExtensionData, AfasMdSourceViewId, AfasMdBDefSystemId, AfasMdBDefCode, AfasMdMainTableSystemId, AfasMdAdditionalSystemId, AfasMdGrouping, AfasMdLinkToSystemId, AfasMdLinkToViewId, AfasMdConditionSeqNo, AfasMdHideFromUser, AfasMdDistinct, AfasMdBaseViewId, AfasMdSourceVersion, AfasMdViewType, AfasMdQueryCompatible, AfasMdViewParsed, AfasMdUseBlockedLines, AfasMdGroupLines, AfasMdRowHeight) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','Vw_AfasKn3C2BD93A454A0B311DDF428EE69E773F',NULL,'Fco','Kenmerkcombinaties','/*~-~*~-~**/~-~*~-~*if exists (select * from sysobjects where id = ~-~*object_id(''dbo.Vw_AfasKn3C2BD93A454A0B311DDF428EE69E773F'') and sysstat & 0xf = 2)~-~*drop view dbo.Vw_AfasKn3C2BD93A454A0B311DDF428EE69E773F~-~*GO~-~*~-~*CREATE VIEW Vw_AfasKn3C2BD93A454A0B311DDF428EE69E773F AS~-~*~-~*SELECT ~-~*~-~*Fco.AfasKnSubjectTypeId AfasQWKnU009,~-~*Fco.AfasKnDescription AfasQWKnU001,~-~*AfasQWKnU010=(CASE WHEN Fco.AfasKnBlocked = ''1'' THEN 1 ELSE 0 END),~-~*Fco.AfasKnFeatureValueIdFeature1 AfasQWKnU005,~-~*AfasKnFeatureValueQW3.AfasKnDescription AfasQWKnU011,~-~*Fco.AfasKnFeatureValueIdFeature2 AfasQWKnU006,~-~*AfasKnFeatureValueQW4.AfasKnDescription AfasQWKnU002,~-~*Fco.AfasKnFeatureValueIdFeature3 AfasQWKnU007,~-~*AfasKnFeatureValueQW5.AfasKnDescription AfasQWKnU008,~-~*Fco.AfasKnFeatureCombinationId AfasQWKnKnFcoFcId ~-~*~-~*FROM AfasKnFeatureCombination AS Fco~-~*~-~*LEFT JOIN AfasKnFeatureValue AfasKnFeatureValueQW3 ON Fco.AfasKnFeatureId1 = AfasKnFeatureValueQW3.AfasKnFeatureId AND Fco.AfasKnFeatureValueIdFeature1 = AfasKnFeatureValueQW3.AfasKnFeatureValueId~-~*LEFT JOIN AfasKnFeatureValue AfasKnFeatureValueQW4 ON Fco.AfasKnFeatureId2 = AfasKnFeatureValueQW4.AfasKnFeatureId AND Fco.AfasKnFeatureValueIdFeature2 = AfasKnFeatureValueQW4.AfasKnFeatureValueId~-~*LEFT JOIN AfasKnFeatureValue AfasKnFeatureValueQW5 ON Fco.AfasKnFeatureId3 = AfasKnFeatureValueQW5.AfasKnFeatureId AND Fco.AfasKnFeatureValueIdFeature3 = AfasKnFeatureValueQW5.AfasKnFeatureValueId ~-~*/*QWWhereNew*/~-~*GO~-~*','1','1','C1~BD1~BC3~BI~BD2~BD1~BC1~BD1~BC2~BIU010~BI=0~BCF~BA~BD2~BD0~BL~BL',NULL,'0','C2~BL1~BIFco~BI/*~A-~A*---------------------------------------------------------------------~A-~A*-- Creator: cwi~A-~A*-- Date: 01-mrt-2004~A-~A*-- ObjectName: Vw_AfasKnS_Fco00~A-~A*-- Purpose: ~A-~A*---------------------------------------------------------------------~A-~A**/~A-~A*~A-~A*if exists (select * from sysobjects where id = ~A-~A*object_id(''dbo.Vw_AfasKnS_Fco00'') and sysstat & 0xf = 2)~A-~A*drop view dbo.Vw_AfasKnS_Fco00~A-~A*GO~A-~A*~A-~A*CREATE VIEW Vw_AfasKnS_Fco00 AS~A-~A*~A-~A*SELECT ~A-~A*~A-~A*/*QWSelectNew*/~A-~A*~A-~A*FROM AfasKnFeatureCombination AS Fco~A-~A*~A-~A*/*QWFrom*/~A-~A*/*QWWhereNew*/~A-~A*GO~A-~A*~A-~A*','S_Fco00',NULL,NULL,'Kn',NULL,'0',NULL,NULL,104008,'0','0','B_Fco00',NULL,3,'0','0',1,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','KnFcoFcId',10,'AfasQWKnKnFcoFcId','Kn','Fco','FcId',NULL,2,'1','Fco',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,10,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','U001',2,'AfasQWKnU001','Kn','Fco','Ds','Omschrijving',1,'1','Fco',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,2,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','U002',7,'AfasQWKnU002','Kn','Fea','Ds','Waarde kenmerk 2 omschrijving',1,'0','Fco.KnFea1',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,7,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','U005',4,'AfasQWKnU005','Kn','Fco','FvF1',NULL,1,'1','Fco',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,4,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','U006',6,'AfasQWKnU006','Kn','Fco','FvF2',NULL,1,'1','Fco',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,6,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','U007',8,'AfasQWKnU007','Kn','Fco','FvF3',NULL,1,'1','Fco',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,8,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','U008',9,'AfasQWKnU008','Kn','Fea','Ds','Waarde kenmerk 3 omschrijving',1,'0','Fco.KnFea2',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,9,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','U009',1,'AfasQWKnU009','Kn','Fco','StId','Type dossieritem',1,'1','Fco',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,1,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','U010',3,'AfasQWKnU010','Kn','Fco','Bl','Geblokkeerd (1/0)',0,'1','Fco','Geblokkeerd (1/0)','0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,3,NULL,NULL,'0','Kn','Bln01',NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','U011',5,'AfasQWKnU011','Kn','Fea','Ds','Waarde kenmerk 1 omschrijving',1,'0','Fco.KnFea',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,5,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','3C2BD93A454A0B311DDF428EE69E773F','Fco',1,'Kn','Fco',NULL,NULL,0,NULL,'$18787=Kenmerkcombinatie','0','1','0','1',2,NULL)@D0@L@D0@A@D0@IKn@D0@I3C2BD93A454A0B311DDF428EE69E773F@D0@ISecureLogin_Dossierkenmerken@D0@D8@D0@IU009@D0@IDossierType@D0@IU001@D0@IOmschrijving@D0@IU005@D0@IFvF1@D0@IU011@D0@IOmschrijving_2@D0@IU006@D0@IFvF2@D0@IU002@D0@IOmschrijving_3@D0@IU007@D0@IFvF3@D0@IU008@D0@IOmschrijving_4