D1@D4B@D2009@D0@D1@D0@D4@D0@L@D0@D0@D0@D1D@D0@IGuid@D0@I760D19C84A56AA8161E88386BEC07409@D0@IType@D0@D8@D0@ICode@D0@A@D0@IDs@D0@Iclientonline-dossier-connector-kenmerkwaarden@D0@IInfo@D0@IGetConnector for getting the features and their values from Profit.~-~*~-~*If filtering is needed, use the following fields:~-~*- FeatureId~-~*- FeatureValueId@D0@IPrId@D0@ICrm@D0@ICtId@D0@A@D0@IAuId@D0@A@D0@IComp@D0@IDOSSI@D0@ITemp@D0@L1@D0@IBl@D0@L@D0@IOwn@D0@A@D0@ICrUs@D0@I81620.1000291@D0@ICrDt@D0@H 45236.50125@D0@IChUs@D0@I81620.1000291@D0@IChDt@D0@H 45236.5027893518@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_Fea00@D0@IVisi@D0@L1@D0@IMd@D0@A@D0@INCnd@D0@A@D0@IUsAu@D0@L@D0@IBu@D0@D258@D0@ISp@D0@D1@D1@D12@D2009@D0@D1@D0@I1@D0@D1@D0@D3@D0@I@D0@IKn@D0@I98D3753F4F509664BE4373B8371AFBF7@D0@I@D0@D3@D0@D0@D0@D6@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','98D3753F4F509664BE4373B8371AFBF7','Vw_AfasKn98D3753F4F509664BE4373B8371AFBF7',NULL,'Fea','Waarde kenmerk','/*~-~*~-~**/~-~*~-~*if exists (select * from sysobjects where id = ~-~*object_id(''dbo.Vw_AfasKn98D3753F4F509664BE4373B8371AFBF7'') and sysstat & 0xf = 2)~-~*drop view dbo.Vw_AfasKn98D3753F4F509664BE4373B8371AFBF7~-~*GO~-~*~-~*CREATE VIEW Vw_AfasKn98D3753F4F509664BE4373B8371AFBF7 AS~-~*~-~*SELECT ~-~*~-~*Fea.AfasKnFeatureId AfasQWKnU004,~-~*Fea.AfasKnFeatureValueId AfasQWKnU005,~-~*Fea.AfasKnDescription AfasQWKnU006,~-~*Fea.AfasKnBlocked AfasQWKnU007 ~-~*~-~*FROM AfasKnFeatureValue AS Fea~-~*~-~*/*QWFrom*/~-~*/*QWWhereNew*/~-~*GO~-~*','1','1','D1~BD0',NULL,'0','D2~BL1~BIFea~BI/*~A-~A*---------------------------------------------------------------------~A-~A*-- Creator: cwi~A-~A*-- Date: 01-mrt-2004~A-~A*-- ObjectName: Vw_AfasKnS_Fea00~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_Fea00'') and sysstat & 0xf = 2)~A-~A*drop view dbo.Vw_AfasKnS_Fea00~A-~A*GO~A-~A*~A-~A*CREATE VIEW Vw_AfasKnS_Fea00 AS~A-~A*~A-~A*SELECT ~A-~A*~A-~A*/*QWSelectNew*/~A-~A*~A-~A*FROM AfasKnFeatureValue AS Fea~A-~A*~A-~A*/*QWFrom*/~A-~A*/*QWWhereNew*/~A-~A*GO~A-~A*~A-~A*','S_Fea00',NULL,NULL,'Kn',NULL,'0',NULL,NULL,104008,'0','0','B_Fea00',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','98D3753F4F509664BE4373B8371AFBF7','U004',1,'AfasQWKnU004','Kn','Fea','FpId',NULL,1,'1','Fea',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','98D3753F4F509664BE4373B8371AFBF7','U005',2,'AfasQWKnU005','Kn','Fea','FeId',NULL,1,'1','Fea',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','98D3753F4F509664BE4373B8371AFBF7','U006',3,'AfasQWKnU006','Kn','Fea','Ds',NULL,1,'1','Fea',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,3,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','98D3753F4F509664BE4373B8371AFBF7','U007',4,'AfasQWKnU007','Kn','Fea','Bl',NULL,1,'1','Fea',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,4,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','98D3753F4F509664BE4373B8371AFBF7','Fea',1,'Kn','Fea',NULL,NULL,0,NULL,'$7273=Kenmerkwaarde','0','1','0','1',2,NULL)@D0@L@D0@A@D0@IKn@D0@I98D3753F4F509664BE4373B8371AFBF7@D0@Iclientonline-dossier-connector-kenmerkwaarden@D0@D4@D0@IU004@D0@IFeatureId@D0@IU005@D0@IFeatureValueId@D0@IU006@D0@IDescription@D0@IU007@D0@IBlocked