D1@D7D@D2009@D0@D1@D0@D4@D0@L@D0@D0@D0@D1D@D0@IGuid@D0@I83CF04104A18DAB4F9B82B9286FDAE25@D0@IType@D0@D8@D0@ICode@D0@A@D0@IDs@D0@Iclientonline-dossier-connector@D0@IInfo@D0@IGetConnector for getting the subjects from Profit.~-~*~-~*If filtering is needed, use the following fields:~-~*- SubjectId~-~*- TypeId + SubjectId~-~*- DateCreated + TypeId@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@A@D0@ICrUs@D0@I81620.1000291@D0@ICrDt@D0@H 45236.50125@D0@IChUs@D0@I81620.1000291@D0@IChDt@D0@H 45236.5022800926@D0@IClUs@D0@A@D0@IClDt@D0@A@D0@IMntL@D0@D0@D0@IUnCn@D0@L@D0@ISyId@D0@IKn@D0@ICnSn@D0@D2AF8@D0@IObId@D0@IB_Sbj00@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@D4F@D2009@D0@D1@D0@I1@D0@D1@D0@D3@D0@I@D0@IKn@D0@I70EB97804C7946D08F9C559C2E176C52@D0@I@D0@D3@D0@D0@D0@D43@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','70EB97804C7946D08F9C559C2E176C52','Vw_AfasKn70EB97804C7946D08F9C559C2E176C52',NULL,'Sbj','WordConnect_Dossieritems','/*~-~*~-~**/~-~*~-~*if exists (select * from sysobjects where id = ~-~*object_id(''dbo.Vw_AfasKn70EB97804C7946D08F9C559C2E176C52'') and sysstat & 0xf = 2)~-~*drop view dbo.Vw_AfasKn70EB97804C7946D08F9C559C2E176C52~-~*GO~-~*~-~*CREATE VIEW Vw_AfasKn70EB97804C7946D08F9C559C2E176C52 AS~-~*~-~*SELECT ~-~*~)AfasKnHasAttachment =~-~*~-~*~)''0'',~-~*~-~*~)AfasKnSubjectLinkId = ~-~*~)(~-~*~)~)Sbl.AfasKnSubjectLinkId~-~*~)),~-~*~-~*    AfasKnHasAttachmentSubject = ''0'', ~-~*~-~*  AfasKnUsedProfile = NULL ~-~*~-~*, Sbj.AfasKnSubjectId AfasQWKnU008,~-~*Sbj.AfasKnDescription AfasQWKnU003,~-~*Sbj.AfasKnDateTimeEntered AfasQWKnU001,~-~*Sbj.AfasKnSubjectNumber AfasQWKnU011,~-~*AfasKnCodeTableValueQW48.AfasKnDescription AfasQWKnU010,~-~*AfasKnFeatureQW55.AfasKnDescription AfasQWKnU002,~-~*AfasKnFeatureQW56.AfasKnDescription AfasQWKnU020,~-~*AfasKnFeatureQW57.AfasKnDescription AfasQWKnU021,~-~*AfasKnCodeTableValueQW65.AfasKnDescription AfasQWKnU022,~-~*AfasKnSubjectTypeQW36.AfasKnDescription AfasQWKnU023,~-~*AfasKnFeatureValueQW43.AfasKnDescription AfasQWKnU024,~-~*AfasKnFeatureValueQW44.AfasKnDescription AfasQWKnU025,~-~*AfasKnFeatureValueQW45.AfasKnDescription AfasQWKnU026,~-~*AfasKnBasicContactQW140.AfasKnBasicContactCode AfasQWKnU027,~-~*AfasKnBasicContactQW125.AfasKnBasicContactCode AfasQWKnU028,~-~*AfasKnBasicContactQW125.AfasKnName AfasQWKnU031,~-~*AfasKnCodeTableValueQW219.AfasKnDescription AfasQWKnU032,~-~*Sbj.AfasKnSubjectText AfasQWKnU009,~-~*Sbj.AfasKnDateTimeCtvMod AfasQWKnU033,~-~*AfasKnCodeTableValueQW49.AfasKnDescription AfasQWKnU043,~-~*Sbj.AfasKnDateTimeCtvModExternal AfasQWKnU045,~-~*AfasKnSourceDataQW39.AfasKnDescription AfasQWKnU046,~-~*AfasKnCodeTableValueQW48.AfasKnValueId AfasQWKnU048,~-~*AfasKnCodeTableValueQW49.AfasKnValueId AfasQWKnU049,~-~*Sbj.AfasKnSubjectTypeId AfasQWKnU047,~-~*Sbj.AfasKnFeatureValueIdFeature1 AfasQWKnU006,~-~*Sbj.AfasKnFeatureValueIdFeature2 AfasQWKnU005,~-~*Sbj.AfasKnFeatureValueIdFeature3 AfasQWKnU007,~-~*AfasKnBasicContactQW125.AfasKnBasicContactCode AfasQWKnU004,~-~*AfasKnCodeTableValueQW48.AfasKnColor KnCtvD001,~-~*AfasKnCodeTableValueQW65.AfasKnColor KnCtvD002,~-~*AfasKnCodeTableValueQW219.AfasKnColor KnCtvD003,~-~*AfasKnCodeTableValueQW49.AfasKnColor KnCtvD004 ~-~*~-~*FROM AfasKnSubject AS Sbj~-~*~-~*INNER JOIN AfasKnSubjectLink Sbl~-~*     ON Sbj.AfasKnSubjectId = Sbl.AfasKnSubjectId~-~*~-~*~*~-~*~-~*~*~-~*~-~*LEFT JOIN AfasKnSubjectType AfasKnSubjectTypeQW36 ON Sbj.AfasKnSubjectTypeId = AfasKnSubjectTypeQW36.AfasKnSubjectTypeId~-~*LEFT JOIN AfasKnCodeTableValue AfasKnCodeTableValueQW65 ON  ''Kn'' = AfasKnCodeTableValueQW65.AfasKnSystemId AND  ''SubjType'' = AfasKnCodeTableValueQW65.AfasKnCodeTableId AND AfasKnSubjectTypeQW36.AfasKnValueIntIdType = AfasKnCodeTableValueQW65.AfasKnValueIntId~-~*LEFT JOIN AfasKnSourceData AfasKnSourceDataQW39 ON Sbj.AfasKnSourceId = AfasKnSourceDataQW39.AfasKnSourceId~-~*LEFT JOIN AfasKnFeatureValue AfasKnFeatureValueQW43 ON Sbj.AfasKnFeatureId1 = AfasKnFeatureValueQW43.AfasKnFeatureId AND Sbj.AfasKnFeatureValueIdFeature1 = AfasKnFeatureValueQW43.AfasKnFeatureValueId~-~*LEFT JOIN AfasKnFeature AfasKnFeatureQW55 ON AfasKnFeatureValueQW43.AfasKnFeatureId = AfasKnFeatureQW55.AfasKnFeatureId~-~*LEFT JOIN AfasKnFeatureValue AfasKnFeatureValueQW44 ON Sbj.AfasKnFeatureId2 = AfasKnFeatureValueQW44.AfasKnFeatureId AND Sbj.AfasKnFeatureValueIdFeature2 = AfasKnFeatureValueQW44.AfasKnFeatureValueId~-~*LEFT JOIN AfasKnFeature AfasKnFeatureQW56 ON AfasKnFeatureValueQW44.AfasKnFeatureId = AfasKnFeatureQW56.AfasKnFeatureId~-~*LEFT JOIN AfasKnFeatureValue AfasKnFeatureValueQW45 ON Sbj.AfasKnFeatureId3 = AfasKnFeatureValueQW45.AfasKnFeatureId AND Sbj.AfasKnFeatureValueIdFeature3 = AfasKnFeatureValueQW45.AfasKnFeatureValueId~-~*LEFT JOIN AfasKnFeature AfasKnFeatureQW57 ON AfasKnFeatureValueQW45.AfasKnFeatureId = AfasKnFeatureQW57.AfasKnFeatureId~-~*LEFT JOIN AfasKnCodeTableValue AfasKnCodeTableValueQW48 ON Sbj.AfasKnSystemId = AfasKnCodeTableValueQW48.AfasKnSystemId AND Sbj.AfasKnCodeTableId = AfasKnCodeTableValueQW48.AfasKnCodeTableId AND Sbj.AfasKnValueIntId = AfasKnCodeTableValueQW48.AfasKnValueIntId~-~*LEFT JOIN AfasKnCodeTableValue AfasKnCodeTableValueQW49 ON  ''Kn'' = AfasKnCodeTableValueQW49.AfasKnSystemId AND  ''SbjWoFlSta'' = AfasKnCodeTableValueQW49.AfasKnCodeTableId AND Sbj.AfasKnWorkflowStatus = AfasKnCodeTableValueQW49.AfasKnValueIntId  ~-~*LEFT JOIN AfasKnBasicContact AfasKnBasicContactQW125 ON Sbl.AfasKnBasicContactId = AfasKnBasicContactQW125.AfasKnBasicContactId~-~*LEFT JOIN AfasKnCodeTableValue AfasKnCodeTableValueQW219 ON  ''Kn'' = AfasKnCodeTableValueQW219.AfasKnSystemId AND  ''KindOfBcn'' = AfasKnCodeTableValueQW219.AfasKnCodeTableId AND AfasKnBasicContactQW125.AfasKnValueIntIdKind = AfasKnCodeTableValueQW219.AfasKnValueIntId~-~*LEFT JOIN AfasKnContactData AfasKnContactDataQW127 ON Sbl.AfasKnContactDataId = AfasKnContactDataQW127.AfasKnContactDataId~-~*LEFT JOIN AfasKnBasicContact AfasKnBasicContactQW140 ON AfasKnContactDataQW127.AfasKnBasicContactId = AfasKnBasicContactQW140.AfasKnBasicContactId                          ~-~*WHERE ~-~*1 = 1~-~*~-~*GO~-~*','1','1','D1~BD0',NULL,'0','D2~BL1~BISbj~BI/*~A-~A*---------------------------------------------------------------------~A-~A*-- Creator: rwi~A-~A*-- Date: 10-11-2008~A-~A*-- ObjectName: Vw_AfasKnS_Sbj06~A-~A*-- Purpose: Like S_Sbj00 but without project construction~A-~A*---------------------------------------------------------------------~A-~A**/~A-~A*~A-~A*if exists (select * from sysobjects where id = ~A-~A*object_id(''dbo.Vw_AfasKnS_Sbj06'') and sysstat & 0xf = 2)~A-~A*drop view dbo.Vw_AfasKnS_Sbj06~A-~A*GO~A-~A*~A-~A*CREATE VIEW Vw_AfasKnS_Sbj06 AS~A-~A*~A-~A*SELECT ~A-~A*~A)AfasKnHasAttachment =~A-~A*~A)/*#IF USEFIELD(AfasKnHasAttachment) AND ALIAS(SbjR) #THEN~A-~A*~A)CASE ~A-~A*~A)~A)WHEN EXISTS(SELECT '''' FROM AfasKnReactionAttachment Rut WHERE Rut.AfasKnReactionId = SbjR.AfasKnIdentity) THEN ''1''~A-~A*~A)~A)ELSE ''0''~A-~A*~A)END~A-~A*~A)#ENDIF*/~A-~A*~A)/*#IF USEFIELD(AfasKnHasAttachment) AND NOT ALIAS(SbjR) #THEN~A-~A*~A)CASE ~A-~A*~A)~A)WHEN EXISTS(SELECT '''' FROM AfasKnSubjectAttachment Sut WHERE Sut.AfasKnSubjectId = Sbj.AfasKnSubjectId) THEN ''1''~A-~A*~A)~A)ELSE ''0''~A-~A*~A)END~A-~A*~A)#ENDIF*/~A-~A*~A)/*#IF NOT USEFIELD(AfasKnHasAttachment) #THEN~A-~A*~A)''0''~A-~A*~A)#ENDIF*/,~A-~A*~A-~A*~A)AfasKnSubjectLinkId = ~A-~A*~A)/* #IF ALIAS(Sbl) #THEN~A-~A*~A)(~A-~A*~A)~A)Sbl.AfasKnSubjectLinkId~A-~A*~A))~A-~A*~A)#ELSE */~A-~A*~A)~A)1 /*~A-~A*~A)#ENDIF */,~A-~A*~A-~A*    /*#IF USEFIELD(AfasKnHasAttachmentSubject) AND ALIAS(Rss) #THEN~A-~A*~A)AfasKnHasAttachmentSubject = ~A-~A*~A)~A)CASE ~A-~A*~A)~A)~A)WHEN EXISTS(SELECT '''' FROM AfasKnSubjectAttachment Sut WHERE Sut.AfasKnSubjectId = Rss.AfasKnSubjectId) THEN ''1''~A-~A*~A)~A)~A)ELSE ''0''~A-~A*~A)~A)END~A-~A*~A)#ELSE */~A-~A*~A)AfasKnHasAttachmentSubject = ''0''~A-~A*~A)/*#ENDIF*/, ~A-~A*~A-~A*  /*#IF USEFIELD(AfasKnUsedProfile) #THEN~A-~A*~A)AfasKnUsedProfile = isnull(KnPfs.AfasKnName_Translate,Sbj.AfasKnCreateProfile)~A-~A*~A)#ELSE */~A-~A*~A)AfasKnUsedProfile = NULL~A-~A*~A)/*#ENDIF*/ ~A-~A*~A-~A*/*QWSelect*/~A-~A*~A-~A*FROM AfasKnSubject AS Sbj~A-~A*~A-~A*/* #IF ALIAS(Rss) #THEN~A-~A*     INNER JOIN AfasKnRemovalSetSubject Rss~A-~A*     ON Sbj.AfasKnSubjectId = Rss.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Sbl) OR ALIAS(ToCRMType) OR ALIAS(Coy) OR ALIAS(Cty) OR ALIAS(Acd) OR ALIAS(Cpl) OR ALIAS(Dvb) #THEN~A-~A*     INNER JOIN AfasKnSubjectLink Sbl~A-~A*     ON Sbj.AfasKnSubjectId = Sbl.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Dvb) #THEN~A-~A*     LEFT JOIN  AfasHrDvb Dvb ON dvb.AfasHrEmployeeId = sbl.AfasKnEmployeeId~A-~A*     AND dvb.AfasHrDvbSeqNo = sbl.AfasKnEmploymentSeqNo~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Coy) OR ALIAS(Cty) #THEN~A-~A*LEFT JOIN AfasKnBasicContact Bcn~A-~A*ON Bcn.AfasKnBasicContactId = Sbl.AfasKnBasicContactId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Atv) OR ALIAS(Wft) #THEN~A-~A*INNER JOIN AfasKnActivity Atv~A-~A*ON Sbj.AfasKnSubjectId = Atv.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Wft) #THEN~A-~A*INNER JOIN AfasKnWorkflowTask Wft~A-~A*ON Wft.AfasKnTaskId = Atv.AfasKnTaskId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(TRS) #THEN~A-~A*LEFT JOIN AfasKnTeamMemberRespSubject TRS~A-~A*ON TRS.AfasKnSubjectId = Sbj.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(S01) #THEN~A-~A*LEFT JOIN AfasKnSubjectType01 S01~A-~A*ON S01.AfasKnSubjectId = Sbj.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(S02) #THEN~A-~A*LEFT JOIN AfasKnSubjectType02 S02~A-~A*ON S02.AfasKnSubjectId = Sbj.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(S03) #THEN~A-~A*LEFT JOIN AfasKnSubjectType03 S03~A-~A*ON S03.AfasKnSubjectId = Sbj.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(S04) #THEN~A-~A*LEFT JOIN AfasKnSubjectType04 S04~A-~A*ON S04.AfasKnSubjectId = Sbj.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(S05) #THEN~A-~A*LEFT JOIN AfasKnSubjectType05 S05~A-~A*ON S05.AfasKnSubjectId = Sbj.AfasKnSubjectId~A-~A*#ENDIF */~A*~A-~A*/* #IF ALIAS(SbjR) OR ALIAS(SbjRL) #THEN~A-~A*LEFT JOIN AfasKnReaction SbjR~A-~A*ON~A)SbjR.AfasKnSubjectId = Sbj.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(SbjRL) #THEN~A-~A*LEFT JOIN AfasKnReactionLabel SbjRL~A-~A*ON~A)SbjRL.AfasKnReactionId = SbjR.AfasKnIdentity~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(SbjH) ~A-~A*OR ALIAS(A01) OR ALIAS(A02) OR ALIAS(A03) OR ALIAS(A04) OR ALIAS(A05) #THEN~A-~A*~A-~A*LEFT JOIN AfasKnSubject SbjH~A-~A*ON SbjH.AfasKnSubjectId = Sbj.AfasKnSubjectIdHigher~A-~A*#ENDIF */~A-~A*~A-~A*~A-~A*/* #IF ALIAS(A01) #THEN~A-~A*LEFT JOIN AfasKnSubjectType01 A01~A-~A*ON A01.AfasKnSubjectId = SbjH.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(A02) #THEN~A-~A*LEFT JOIN AfasKnSubjectType02 A02~A-~A*ON A02.AfasKnSubjectId = SbjH.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(A03) #THEN~A-~A*LEFT JOIN AfasKnSubjectType03 A03~A-~A*ON A03.AfasKnSubjectId = SbjH.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(A04) #THEN~A-~A*LEFT JOIN AfasKnSubjectType04 A04~A-~A*ON A04.AfasKnSubjectId = SbjH.AfasKnSubjectId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(A05) #THEN~A-~A*LEFT JOIN AfasKnSubjectType05 A05~A-~A*ON A05.AfasKnSubjectId = SbjH.AfasKnSubjectId~A-~A*#ENDIF */~A*~A-~A*/* #IF ALIAS(Cty) #THEN~A-~A*LEFT JOIN AfasTxClientTaxYear Cty~A-~A*ON Cty.AfasTxClientId = Bcn.AfasKnTypeClientIBId~A-~A*AND Cty.AfasTxFiscalYear = (SELECT MAX(Cmy.AfasTxFiscalYear) FROM AfasTxClientTaxYear Cmy WHERE Cmy.AfasTxClientId = Cty.AfasTxClientId)~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Coy) #THEN~A-~A*LEFT JOIN AfasTxCompanyTaxYear Coy~A-~A*ON Coy.AfasTxClientId = Bcn.AfasKnTypeClientVpbId~A-~A*AND Coy.AfasTxFiscalYear = (SELECT MAX(Cmy.AfasTxFiscalYear) FROM AfasTxCompanyTaxYear Cmy WHERE Cmy.AfasTxClientId = Coy.AfasTxClientId)~A-~A*AND Coy.AfasTxPeriodId = (SELECT TOP 1 Cmp.AfasTxPeriodId FROM AfasTxCompanyTaxYear Cmp WHERE Cmp.AfasTxClientId = Coy.AfasTxClientId AND Cmp.AfasTxFiscalYear = (SELECT MAX(Cmz.AfasTxFiscalYear) FROM AfasTxCompanyTaxYear Cmz WHERE Cmz.AfasTxClientId = Cmp.AfasTxClientId) ORDER BY AfasTxPeriodEnd DESC)~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Acd) #THEN~A-~A*LEFT JOIN AfasHrEmpActualDvb Acd~A-~A*ON~A)Acd.AfasHrEmployeeId = Sbl.AfasKnEmployeeId~A-~A*AND~A)Acd.AfasHrEmploymentSeqNo = Sbl.AfasKnEmploymentSeqNo~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Atv2) #THEN~A-~A*LEFT JOIN AfasKnActivity Atv2~A-~A*ON Atv2.AfasKnSubjectId = Sbj.AfasKnSubjectId~A-~A*AND Atv2.AfasKnTaskId IN (SELECT TWft.AfasKnTaskId FROM AfasKnWorkflowTask TWft WHERE TWft.AfasKnTaskTypeId = 1)~A-~A*AND Atv2.AfasKnIsHandled = ''0''~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Ccm) #THEN~A-~A*LEFT JOIN AfasKnCommConSubject Ccs~A-~A*ON Ccs.AfasKnSubjectId = Sbj.AfasKnSubjectId~A-~A*LEFT JOIN AfasKnCommConMessage Ccm~A-~A*ON Ccm.AfasKnMessageId = Ccs.AfasKnMessageId~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(Cpl) #THEN~A-~A*LEFT JOIN AfasHrCalculationPlan Cpl~A-~A*ON~A)Cpl.AfasHrEmployerId = Sbl.AfasKnEmployerId~A-~A*AND~A)RIGHT(''0000000000''+LTRIM(STR(Cpl.AfasHrPlanId)),10) = LEFT(Sbl.AfasKnReference,10)~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(LastRea) #THEN~A-~A*OUTER APPLY~A-~A*(select top 1 Rea1.AfasKnIdentity from AfasKnReaction Rea1~A-~A*   where Rea1.AfasKnSubjectId= Sbj.AfasKnSubjectId~A-~A*   order by Rea1.AfasKnIdentity desc) as LastReaIdent~A-~A*~A-~A*LEFT JOIN AfasKnReaction LastRea~A-~A*ON~A)LastRea.AfasKnIdentity = LastReaIdent.AfasKnIdentity~A-~A*~A-~A*#ENDIF */~A-~A*~A-~A*/* #IF ALIAS(LastReaEx) #THEN~A-~A*OUTER APPLY~A-~A*(select top 1 Rea2.AfasKnIdentity from AfasKnReaction Rea2 ~A-~A*   where Rea2.AfasKnSubjectId= Sbj.AfasKnSubjectId and ~A-~A*         Rea2.AfasKnReactionsVisible=''2'' ~A-~A*   order by Rea2.AfasKnIdentity desc) as LastReaExIdent~A-~A*~A-~A*LEFT JOIN AfasKnReaction LastReaEx~A-~A*ON~A)LastReaEx.AfasKnIdentity = LastReaExIdent.AfasKnIdentity   ~A-~A*~A-~A*#ENDIF */~A-~A*~A-~A*/*#IF USEFIELD(AfasKnUsedProfile) #THEN~A-~A*LEFT JOIN AfasKnSubjectProfile KnSbp~A-~A*  ON KnSbp.AfasKnProfileGuid=Sbj.AfasKnCreateProfile~A-~A*LEFT JOIN AfasKnProfiles KnPfs~A-~A*  ON KnPfs.AfasKnProfileId=KnSbp.AfasKnProfileId~A-~A*#ENDIF*/ ~A-~A*~A-~A*/*QWFrom*/~A-~A*WHERE ~A-~A*/* #IF ALIAS(ToCRMType) #THEN~A-~A*~A)CASE ~A-~A*~A)WHEN Sbl.AfasKnToBasicContact =''1'' OR~A-~A* ~A)~A)Sbl.AfasKnToSalesRelation = ''1'' OR~A-~A* ~A)~A)Sbl.AfasKnToPurchaseRelation = ''1'' OR~A-~A* ~A)~A)Sbl.AfasKnToTxClient = ''1'' OR~A-~A* ~A)~A)Sbl.AfasKnToTxCompany = ''1'' OR~A-~A* ~A)~A)Sbl.AfasKnToEmployer = ''1'' ~A-~A*~A)THEN ~A-~A*~A)~A)''1'' -- Dossier item is ingestuurd op een CRM type waarbij medewerker/sollicitant niet als CRM type wordt gezien. Als ingestuurd op medewerker EN (bv) verkooprelatie moet ook ''1'' teruggegeven worden~A-~A*~A)ELSE ''0''~A-~A*~A)END = ''1''~A-~A*#ELSE */~A-~A*~A)~A)1 = 1/*~A-~A*#ENDIF */~A-~A*~A-~A*GO~A-~A*','S_Sbj06',NULL,NULL,'Kn',NULL,'0',NULL,NULL,104008,'0','0','B_Sbj111',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','70EB97804C7946D08F9C559C2E176C52','D001',34,'KnCtvD001','Kn','Ctv','Co','Kleur',2,'0','Sbj.KnCtv1','Kleur','0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,34,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','70EB97804C7946D08F9C559C2E176C52','D002',35,'KnCtvD002','Kn','Ctv','Co','Kleur',2,'0','Sbj.KnSbt.KnCtv2','Kleur','0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,35,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','70EB97804C7946D08F9C559C2E176C52','D003',36,'KnCtvD003','Kn','Ctv','Co','Kleur',2,'0','Sbl.KnBcn.KnCtv','Kleur','0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,36,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','70EB97804C7946D08F9C559C2E176C52','D004',37,'KnCtvD004','Kn','Ctv','Co','Kleur',2,'0','Sbj.KnCtv2','Kleur','0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,37,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','70EB97804C7946D08F9C559C2E176C52','PrIdNm',33,'AfasKnUsedProfile','Kn','Pfs','Nm',NULL,0,'0','Sbj',NULL,'1',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,33,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','70EB97804C7946D08F9C559C2E176C52','SbAt',30,'AfasKnHasAttachment','Kn','Vdf','Yn',NULL,0,'0','Sbj',NULL,'1',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,30,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','70EB97804C7946D08F9C559C2E176C52','SbAtSbj',32,'AfasKnHasAttachmentSubject','Kn','Vdf','Yn',NULL,0,'0','Sbj',NULL,'1',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,32,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','70EB97804C7946D08F9C559C2E176C52','SlId',31,'AfasKnSubjectLinkId','Kn','Sbl','SlId',NULL,2,'1',NULL,NULL,'1',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,31,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','70EB97804C7946D08F9C559C2E176C52','U001',3,'AfasQWKnU001','Kn','Sbj','Da',NULL,1,'1','Sbj',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','70EB97804C7946D08F9C559C2E176C52','U002',6,'AfasQWKnU002','Kn','Fty','Ds','Kenmerk 1',1,'0','Sbj.KnFea1.KnFty',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','70EB97804C7946D08F9C559C2E176C52','U003',2,'AfasQWKnU003','Kn','Sbj','Ds',NULL,1,'1','Sbj',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','70EB97804C7946D08F9C559C2E176C52','U004',29,'AfasQWKnU004','Kn','Bcn','BcCo','clientId',1,'0','Sbl.KnBcn',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,29,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','70EB97804C7946D08F9C559C2E176C52','U005',27,'AfasQWKnU005','Kn','Sbj','FvF2',NULL,1,'1','Sbj',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,27,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','70EB97804C7946D08F9C559C2E176C52','U006',26,'AfasQWKnU006','Kn','Sbj','FvF1',NULL,1,'1','Sbj',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,26,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','70EB97804C7946D08F9C559C2E176C52','U007',28,'AfasQWKnU007','Kn','Sbj','FvF3',NULL,1,'1','Sbj',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,28,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','70EB97804C7946D08F9C559C2E176C52','U008',1,'AfasQWKnU008','Kn','Sbj','SbId','DossierId',1,'1','Sbj','DossierId','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','70EB97804C7946D08F9C559C2E176C52','U009',18,'AfasQWKnU009','Kn','Sbj','SbTx',NULL,1,'1','Sbj',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,18,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','70EB97804C7946D08F9C559C2E176C52','U010',5,'AfasQWKnU010','Kn','Ctv','Ds','Codetabelwaarde',1,'0','Sbj.KnCtv1','Codetabelwaarde','0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,5,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','70EB97804C7946D08F9C559C2E176C52','U011',4,'AfasQWKnU011','Kn','Sbj','SbNo','Nummer',1,'1','Sbj',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','70EB97804C7946D08F9C559C2E176C52','U020',7,'AfasQWKnU020','Kn','Fty','Ds','Kenmerk 2',1,'0','Sbj.KnFea.KnFty',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','70EB97804C7946D08F9C559C2E176C52','U021',8,'AfasQWKnU021','Kn','Fty','Ds','Kenmerk 3',1,'0','Sbj.KnFea2.KnFty',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','70EB97804C7946D08F9C559C2E176C52','U022',9,'AfasQWKnU022','Kn','Ctv','Ds','Technisch type',1,'0','Sbj.KnSbt.KnCtv2','Technisch type','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','70EB97804C7946D08F9C559C2E176C52','U023',10,'AfasQWKnU023','Kn','Sbt','Ds',NULL,1,'0','Sbj.KnSbt',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,10,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','70EB97804C7946D08F9C559C2E176C52','U024',11,'AfasQWKnU024','Kn','Fea','Ds',NULL,1,'0','Sbj.KnFea1',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,11,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','70EB97804C7946D08F9C559C2E176C52','U025',12,'AfasQWKnU025','Kn','Fea','Ds','Kenmerk 2 Waarde kenmerk',1,'0','Sbj.KnFea',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,12,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','70EB97804C7946D08F9C559C2E176C52','U026',13,'AfasQWKnU026','Kn','Fea','Ds','Kenmerk 3 Waarde kenmerk',1,'0','Sbj.KnFea2',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,13,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','70EB97804C7946D08F9C559C2E176C52','U027',14,'AfasQWKnU027','Kn','Bcn','BcCo','Persoon Nr.',1,'0','Sbl.KnCdt.KnBcn',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,14,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','70EB97804C7946D08F9C559C2E176C52','U028',15,'AfasQWKnU028','Kn','Bcn','BcCo','clientId',1,'0','Sbl.KnBcn',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,15,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','70EB97804C7946D08F9C559C2E176C52','U031',16,'AfasQWKnU031','Kn','Bcn','Nm',NULL,1,'0','Sbl.KnBcn',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,16,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','70EB97804C7946D08F9C559C2E176C52','U032',17,'AfasQWKnU032','Kn','Ctv','Ds','Organisatie/persoon',1,'0','Sbl.KnBcn.KnCtv','Organisatie/persoon','0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,17,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','70EB97804C7946D08F9C559C2E176C52','U033',19,'AfasQWKnU033','Kn','Sbj','DaCt',NULL,1,'1','Sbj',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,19,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','70EB97804C7946D08F9C559C2E176C52','U043',20,'AfasQWKnU043','Kn','Ctv','Ds','Workflow status',1,'0','Sbj.KnCtv2','Workflow status','0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,20,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','70EB97804C7946D08F9C559C2E176C52','U045',21,'AfasQWKnU045','Kn','Sbj','DaEx',NULL,1,'1','Sbj',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,21,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','70EB97804C7946D08F9C559C2E176C52','U046',22,'AfasQWKnU046','Kn','Srd','Ds',NULL,1,'0','Sbj.KnSrd',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,22,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','70EB97804C7946D08F9C559C2E176C52','U047',25,'AfasQWKnU047','Kn','Sbj','StId',NULL,1,'1','Sbj',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,25,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','70EB97804C7946D08F9C559C2E176C52','U048',23,'AfasQWKnU048','Kn','Ctv','VaId','Status',1,'0','Sbj.KnCtv1','Status','0',NULL,NULL,NULL,0,'Kn','Sbj','VaIi','0',0,23,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','70EB97804C7946D08F9C559C2E176C52','U049',24,'AfasQWKnU049','Kn','Ctv','VaId','Workflow status',1,'0','Sbj.KnCtv2','Workflow status','0',NULL,NULL,NULL,0,'Kn','Sbj','WoSt','0',0,24,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','70EB97804C7946D08F9C559C2E176C52','A01',25,'Kn','S01',NULL,NULL,0,NULL,'Aanleiding vrij dossieritem: Genereren brief - k..','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','A02',24,'Kn','S02',NULL,NULL,0,NULL,'Aanleiding vrij dossieritem: Inkomende correspon..','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','A03',26,'Kn','S03',NULL,NULL,0,NULL,'Aanleiding vrij dossieritem: Spreekuur bedrijfsa..','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','A04',27,'Kn','S04',NULL,NULL,0,NULL,'Aanleiding vrij dossieritem: Exitgesprek','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','A05',28,'Kn','S05',NULL,NULL,0,103012,'Aanleiding vrij dossieritem: Fiscaal signaal','1','0','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Acd',15,'Hr','Acd',NULL,NULL,0,NULL,'$81739=Actuele tabel medewerker/dienstverband','1','0','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Atv',4,'Kn','Atv',NULL,NULL,0,NULL,'$191350=Activiteit (oud)','0','0','0','1',2,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Atv2',5,'Kn','Atv',NULL,NULL,0,NULL,'$7140=Activiteit','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Ccm',16,'Kn','Ccm',NULL,NULL,0,111042,'$182723=Communicatieconnector bericht','1','0','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Coy',12,'Tx','Coy',NULL,NULL,0,19000,'$81918=Clint Vpb meeste recente jaargegevens','1','0','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Cpl',14,'Hr','Cpl',NULL,NULL,0,111056,'$261830=Salarisverwerkingsplan voorlopige loonstro','1','0','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Cty',11,'Tx','Cty',NULL,NULL,0,19000,'$81919=Clint IB meeste recente jaargegevens','1','0','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Dvb',19,'Hr','Dvb',NULL,NULL,0,NULL,'$6588=Dienstverband','1','0','0','1',2,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','LastRea',7,'Kn','Rea',NULL,NULL,0,NULL,'$265528=Laatste reactie','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','LastReaEx',8,'Kn','Rea',NULL,NULL,0,NULL,'$265529=Laatste externe reactie','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Rss',17,'Kn','Rss',NULL,NULL,0,NULL,'$256628=Koppeltabel Verwijderset/Dossieritem','0','1','0','0',2,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','S01',21,'Kn','S01',NULL,NULL,0,NULL,'Vrij dossieritem: Genereren brief - klant','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','S02',20,'Kn','S02',NULL,NULL,0,NULL,'Vrij dossieritem: Inkomende correspondentie klant','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','S03',22,'Kn','S03',NULL,NULL,0,NULL,'Vrij dossieritem: Spreekuur bedrijfsarts','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','S04',23,'Kn','S04',NULL,NULL,0,NULL,'Vrij dossieritem: Exitgesprek','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','S05',29,'Kn','S05',NULL,NULL,0,NULL,'Vrij dossieritem: Fiscaal signaal','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Sbj',1,'Kn','Sbj',NULL,NULL,0,NULL,'$17425=Dossieritem','1','1','0','1',2,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','SbjH',10,'Kn','Sbj',NULL,NULL,0,NULL,'$17679=Aanleiding','0','1','0','1',2,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','SbjR',9,'Kn','Rea',NULL,NULL,0,NULL,'$5202=Reacties','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','SbjRL',18,'Kn','Rla',NULL,NULL,0,NULL,'$259451=Labels bij dossieritem reacties','1','1','0','1',2,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Sbl',3,'Kn','Sbl',NULL,NULL,0,NULL,'$76044=Dossieritem koppeling','0','1','0','1',2,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','ToCRMType',13,'Kn','Sbl',NULL,NULL,0,NULL,'$104125=Dossieritems die zijn ingestuurd op CRM ty','0','1','0','0',2,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','TRS',2,'Kn','TRS',NULL,NULL,0,NULL,'$234822=Projectdossier verantwoordelijke','1','1','0','1',1,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','70EB97804C7946D08F9C559C2E176C52','Wft',6,'Kn','Wft',NULL,NULL,0,NULL,'$191351=Workflowtaak (oud)','0','0','0','1',2,NULL)@D0@L@D0@A@D0@IKn@D0@I70EB97804C7946D08F9C559C2E176C52@D0@Iclientonline-dossier-connector@D0@D1D@D0@IU008@D0@ISubjectId@D0@IU003@D0@ISubject@D0@IU001@D0@IDateCreated@D0@IU011@D0@INumber@D0@IU010@D0@IStatus@D0@IU002@D0@IKenmerk_1_Omschrijving@D0@IU020@D0@IKenmerk_2_Omschrijving_@D0@IU021@D0@IKenmerk_3_Omschrijving@D0@IU022@D0@ITechnisch_type@D0@IU023@D0@IOmschrijving_4@D0@IU024@D0@IKenmerk_1_Waarde@D0@IU025@D0@IKenmerk_2_Waarde@D0@IU026@D0@IKenmerk_3_Waarde@D0@IU027@D0@INummer@D0@IU028@D0@INummer_2@D0@IU031@D0@INaam@D0@IU032@D0@IOrganisatie_persoon@D0@IU009@D0@IComment@D0@IU033@D0@ILaatst_gewijzigde_veld_vrije_tabel@D0@IU043@D0@IWFstatus@D0@IU045@D0@ILaatste_wijziging_externe_status@D0@IU046@D0@IOmschrijving_8@D0@IU048@D0@IStatus_2@D0@IU049@D0@IWorkflow_status@D0@IU047@D0@IType_dossieritem@D0@IU006@D0@IWaarde_kenmerk_1@D0@IU005@D0@IWaarde_kenmerk_2@D0@IU007@D0@IWaarde_kenmerk_3@D0@IU004@D0@INummer_3