D1@D69@D2009@D0@D1@D0@D4@D0@L@D0@D0@D0@D1D@D0@IGuid@D0@IE71E623A4D3BDB10BC5FB960FFF08825@D0@IType@D0@D8@D0@ICode@D0@A@D0@IDs@D0@ISecureLogin_Contacten@D0@IInfo@D0@IGegevensverzameling met alle contacten bestemd voor analyses, rapporten en Getconnector.@D0@IPrId@D0@ICrm@D0@ICtId@D0@A@D0@IAuId@D0@A@D0@IComp@D0@IRELAT@D0@ITemp@D0@L@D0@IBl@D0@L@D0@IOwn@D0@I32772.CLN@D0@ICrUs@D0@A@D0@ICrDt@D0@A@D0@IChUs@D0@I86519.admin@D0@IChDt@D0@H 44722.3638078704@D0@IClUs@D0@I86519.admin@D0@IClDt@D0@H 44314.6263888889@D0@IMntL@D0@D0@D0@IUnCn@D0@L@D0@ISyId@D0@IKn@D0@ICnSn@D0@D2AF8@D0@IObId@D0@IB_Cdt02@D0@IVisi@D0@L1@D0@IMd@D0@A@D0@INCnd@D0@A@D0@IUsAu@D0@L@D0@IBu@D0@A@D0@ISp@D0@A@D1@D48@D2009@D0@D1@D0@I1@D0@D1@D0@D3@D0@I@D0@IKn@D0@I36764D26475EBD721ABBDAA6A6204149@D0@I@D0@D3@D0@D0@D0@D3C@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','36764D26475EBD721ABBDAA6A6204149','Vw_AfasKn36764D26475EBD721ABBDAA6A6204149',NULL,'Cdt','SecureLogin_contacten_nieuw_ib','/*~-~*~-~**/~-~*~-~*DROP VIEW IF EXISTS dbo.Vw_AfasKn36764D26475EBD721ABBDAA6A6204149;~-~*GO~-~*~-~*CREATE VIEW Vw_AfasKn36764D26475EBD721ABBDAA6A6204149 AS~-~*~-~*SELECT ~-~*~-~*NULL AS AfasKnRoleAdm~-~*~-~*, NULL AS AfasKnRoleEmp~-~*~-~*, NULL AS AfasKnAutRole01ExDs~-~*~-~*, NULL AS AfasKnAutRole02ExDs~-~*~-~*, NULL AS AfasKnAutRole03ExDs~-~*~-~*, NULL AS AfasKnAutRole04ExDs~-~*~-~*, NULL AS AfasKnAutRole05ExDs~-~*~-~*, NULL AS AfasKnAutRole06ExDs~-~*~-~*, NULL AS AfasKnAutRole07ExDs~-~*~-~*, NULL AS AfasKnAutRole08ExDs~-~*~-~*, NULL AS AfasKnAutRole09ExDs~-~*~-~*, NULL AS AfasKnAutRole10ExDs~-~*~-~*, Cdt.AfasKnContactDataId AS AfasKnUniqueId~-~*~-~*, Cdt.AfasKnContactDataId AfasQWKnU008,~-~*AfasKnBasicContactQW28.AfasKnName AfasQWKnU009,~-~*AfasKnBasicAddressQW52.AfasKnAddressExampleLine AfasQWKnU016,~-~*AfasTxCompanyQW77.AfasTxFiscalNumber AfasQWTxU001,~-~*AfasKnBasicContactQW28.AfasKnChOfCommNr AfasQWKnU002,~-~*AfasKnCodeTableValueQW30.AfasKnDescription AfasQWKnU010,~-~*AfasKnBasicContactQW28.AfasKnBasicContactCode AfasQWKnU011,~-~*AfasKnBasicContactQW29.AfasKnBasicContactCode AfasQWKnU012,~-~*AfasKnCodeTableValueQW32.AfasKnDescription AfasQWKnU013,~-~*Cdt.AfasKnMobileNr AfasQWKnU014,~-~*Cdt.AfasKnMobileNr2 AfasQWKnU021,~-~*Cdt.AfasKnEmail AfasQWKnU015,~-~*Cdt.AfasKnEmail2 AfasQWKnU022,~-~*AfasKnBasicContactQW29.AfasKnCallingName AfasQWKnU004,~-~*AfasKnBasicContactQW29.AfasKnInsertion AfasQWKnU005,~-~*AfasKnBasicContactQW29.AfasKnLastName AfasQWKnU006,~-~*AfasTxClientQW75.AfasTxSeqno AfasQWTxU007,~-~*AfasKnBasicContactQW28.AfasKnIsClientIB AfasQWKnU017,~-~*AfasKnPurRelationQW70.AfasKnVatAccountId AfasQWKnU003,~-~*AfasKnCodeTableValueQW30.AfasKnColor KnCtvD001,~-~*AfasKnCodeTableValueQW32.AfasKnColor KnCtvD002 ~-~*~-~*FROM AfasKnContactData AS Cdt~-~*LEFT OUTER JOIN AfasKnBasicContact AS Bcn ON Bcn.AfasKnBasicContactId = Cdt.AfasKnBasicContactIdLink~-~*~-~*LEFT JOIN AfasKnBasicContact AfasKnBasicContactQW28 ON Cdt.AfasKnBasicContactId = AfasKnBasicContactQW28.AfasKnBasicContactId~-~*LEFT JOIN AfasKnBasicAddress AfasKnBasicAddressQW52 ON AfasKnBasicContactQW28.AfasKnBasicAddressIdAdr = AfasKnBasicAddressQW52.AfasKnBasicAddressId~-~*LEFT JOIN AfasKnPurRelation AfasKnPurRelationQW70 ON AfasKnBasicContactQW28.AfasKnTypePurRelationId = AfasKnPurRelationQW70.AfasKnCreditorId~-~*LEFT JOIN AfasTxClient AfasTxClientQW75 ON AfasKnBasicContactQW28.AfasKnTypeClientIBId = AfasTxClientQW75.AfasTxClientId~-~*LEFT JOIN AfasTxCompany AfasTxCompanyQW77 ON AfasKnBasicContactQW28.AfasKnTypeClientVpbId = AfasTxCompanyQW77.AfasTxClientId~-~*LEFT JOIN AfasKnBasicContact AfasKnBasicContactQW29 ON Cdt.AfasKnBasicContactIdLink = AfasKnBasicContactQW29.AfasKnBasicContactId~-~*LEFT JOIN AfasKnCodeTableValue AfasKnCodeTableValueQW30 ON  ''Kn'' = AfasKnCodeTableValueQW30.AfasKnSystemId AND  ''CdtType'' = AfasKnCodeTableValueQW30.AfasKnCodeTableId AND Cdt.AfasKnValueIntIdKind = AfasKnCodeTableValueQW30.AfasKnValueIntId~-~*LEFT JOIN AfasKnCodeTableValue AfasKnCodeTableValueQW32 ON  ''Kn'' = AfasKnCodeTableValueQW32.AfasKnSystemId AND  ''ContFunc'' = AfasKnCodeTableValueQW32.AfasKnCodeTableId AND Cdt.AfasKnValueIntIdFun = AfasKnCodeTableValueQW32.AfasKnValueIntId                         ~-~*~-~*WHERE ISNULL(Bcn.AfasKnIsProFormaEmp, ''0'') = ''0''~-~*~-~*/*QWWhereAdd*/~-~*~-~*GO','1','1','D1~BD0',NULL,'0','D2~BL1~BICdt~BI/*~A-~A*---------------------------------------------------------------------~A-~A*-- Creator: ezw~A-~A*-- Date: 27-mrt-2007~A-~A*-- ObjectName: Vw_AfasKnS_Cdt00~A-~A*-- Purpose: ~A-~A*---------------------------------------------------------------------~A-~A**/~A-~A*~A-~A*DROP VIEW IF EXISTS dbo.Vw_AfasKnS_Cdt00;~A-~A*GO~A-~A*~A-~A*CREATE VIEW Vw_AfasKnS_Cdt00 AS~A-~A*~A-~A*SELECT ~A-~A*~A-~A*/* #IF USEFIELD(AfasKnRoleAdm) #THEN~A-~A*  dbo.Fn_AfasKnIsAutRoleTypeAssigned(Cdt.AfasKnContactDataId, ''2'', ''1'')~A-~A*#ELSE */~A-~A*  NULL/* #ENDIF */ AS AfasKnRoleAdm~A-~A*~A-~A*/* #IF USEFIELD(AfasKnRoleEmp) #THEN~A-~A*, dbo.Fn_AfasKnIsAutRoleTypeAssigned(Cdt.AfasKnContactDataId, ''2'', ''2'')~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnRoleEmp~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole01ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 1)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole01ExDs~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole02ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 2)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole02ExDs~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole03ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 3)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole03ExDs~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole04ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 4)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole04ExDs~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole05ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 5)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole05ExDs~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole06ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 6)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole06ExDs~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole07ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 7)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole07ExDs~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole08ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 8)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole08ExDs~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole09ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 9)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole09ExDs~A-~A*~A-~A*/* #IF USEFIELD(AfasKnAutRole10ExDs) #THEN~A-~A*, dbo.Fn_AfasKnGetCustomOutSiteAutRoleDescription(Cdt.AfasKnContactDataId, 10)~A-~A*#ELSE */~A-~A*, NULL/* #ENDIF */ AS AfasKnAutRole10ExDs~A-~A*~A-~A*/* #IF ALIAS(C01)~A-~A*       OR ALIAS(C02)~A-~A*       OR ALIAS(C03) ~A-~A*       OR ALIAS(C04) ~A-~A*       OR ALIAS(C05) ~A-~A*       OR ALIAS(C06) ~A-~A*       OR ALIAS(C07) ~A-~A*       OR ALIAS(C08) ~A-~A*       OR ALIAS(C09) ~A-~A*       OR ALIAS(C10) ~A-~A*       OR ALIAS(C11) ~A-~A*       OR ALIAS(C12) ~A-~A*       OR ALIAS(C13) ~A-~A*       OR ALIAS(C14) ~A-~A*       OR ALIAS(C15) ~A-~A*       OR ALIAS(C16) ~A-~A*       OR ALIAS(C17) ~A-~A*       OR ALIAS(C18) ~A-~A*       OR ALIAS(C19) ~A-~A*       OR ALIAS(C20) #THEN~A-~A*, ROW_NUMBER() OVER (ORDER BY Cdt.AfasKnContactDataId ASC)~A-~A*#ELSE */~A-~A*, Cdt.AfasKnContactDataId/* #ENDIF */ AS AfasKnUniqueId~A-~A*~A-~A*/*QWSelect*/~A-~A*~A-~A*FROM AfasKnContactData AS Cdt~A-~A*LEFT OUTER JOIN AfasKnBasicContact AS Bcn ON Bcn.AfasKnBasicContactId = Cdt.AfasKnBasicContactIdLink~A-~A*~A-~A*/*~A-~A*#IF ALIAS(Csm) #THEN~A-~A*LEFT JOIN AfasKnCourseSessionMember Csm ON Csm.AfasKnMemberCdtId = Cdt.AfasKnContactDataId~A-~A*#ENDIF~A-~A*~A-~A*#IF ALIAS(Pap) OR ALIAS(BcnOwn) #THEN~A-~A*LEFT JOIN AfasKnPersonAppointment Pap ON Pap.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF~A-~A*~A-~A*#IF ALIAS(BcnOwn) #THEN~A-~A*LEFT JOIN~A-~A*(~A-~A*  SELECT Pap2.AfasKnAppointmentId, AfasKnPersonAppointmentId = MIN(Pap2.AfasKnPersonAppointmentId), AfasKnBasicContactId = MIN(Usr.AfasKnBasicContactId)~A-~A*  FROM AfasKnPersonAppointment Pap2~A-~A*  INNER JOIN AfasKnUser Usr ON Usr.AfasKnUserId = Pap2.AfasKnUser~A-~A*  WHERE Pap2.AfasKnIsOwner = ''1''~A-~A*  GROUP BY Pap2.AfasKnAppointmentId~A-~A*) Sub ON Sub.AfasKnAppointmentId = Pap.AfasKnAppointmentId~A-~A*LEFT JOIN AfasKnBasicContact BcnOwn ON BcnOwn.AfasKnBasicContactId = Sub.AfasKnBasicContactId~A-~A*#ENDIF~A-~A*~A-~A*#IF ALIAS(WOI) #THEN~A-~A*LEFT JOIN AfasKnWebOptIn WOI ON WOI.AfasKnBasicContactId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF~A-~A*~A-~A*#IF ALIAS(C01) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC01 C01 ON C01.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C02) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC02 C02 ON C02.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C03) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC03 C03 ON C03.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C04) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC04 C04 ON C04.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C05) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC05 C05 ON C05.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C06) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC06 C06 ON C06.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C07) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC07 C07 ON C07.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C08) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC08 C08 ON C08.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C09) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC09 C09 ON C09.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C10) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC10 C10 ON C10.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C11) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC11 C11 ON C11.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C12) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC12 C12 ON C12.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C13) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC13 C13 ON C13.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C14) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC14 C14 ON C14.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C15) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC15 C15 ON C15.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C16) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC16 C16 ON C16.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C17) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC17 C17 ON C17.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C18) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC18 C18 ON C18.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C19) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC19 C19 ON C19.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C20) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC20 C20 ON C20.AfasKnContactDataId = Cdt.AfasKnContactDataId~A-~A*#ENDIF~A-~A**/~A-~A*~A-~A*/*QWFrom*/~A-~A*~A-~A*-- Geen pro-forma medewerkers tonen.~A-~A*WHERE ISNULL(Bcn.AfasKnIsProFormaEmp, ''0'') = ''0''~A-~A*~A-~A*/*QWWhereAdd*/~A-~A*~A-~A*GO','S_Cdt00',NULL,NULL,'Kn',NULL,'0',NULL,NULL,11000,'0','0','B_Cdt02',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','36764D26475EBD721ABBDAA6A6204149','AutRole01ExDs',26,'AfasKnAutRole01ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',NULL,'1',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','36764D26475EBD721ABBDAA6A6204149','AutRole02ExDs',27,'AfasKnAutRole02ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',NULL,'1',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','36764D26475EBD721ABBDAA6A6204149','AutRole03ExDs',28,'AfasKnAutRole03ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',NULL,'1',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','36764D26475EBD721ABBDAA6A6204149','AutRole04ExDs',23,'AfasKnAutRole04ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',NULL,'1',NULL,NULL,NULL,0,NULL,NULL,NULL,'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','36764D26475EBD721ABBDAA6A6204149','AutRole05ExDs',24,'AfasKnAutRole05ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',NULL,'1',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,24,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','36764D26475EBD721ABBDAA6A6204149','AutRole06ExDs',25,'AfasKnAutRole06ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',NULL,'1',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','36764D26475EBD721ABBDAA6A6204149','AutRole07ExDs',29,'AfasKnAutRole07ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',NULL,'1',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','36764D26475EBD721ABBDAA6A6204149','AutRole08ExDs',30,'AfasKnAutRole08ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',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','36764D26475EBD721ABBDAA6A6204149','AutRole09ExDs',31,'AfasKnAutRole09ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',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','36764D26475EBD721ABBDAA6A6204149','AutRole10ExDs',32,'AfasKnAutRole10ExDs','Kn','ARo','ExDs',NULL,0,'0','ARo',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','36764D26475EBD721ABBDAA6A6204149','D001',33,'KnCtvD001','Kn','Ctv','Co',NULL,2,'0','Cdt.KnCtv',NULL,'0',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','36764D26475EBD721ABBDAA6A6204149','D002',34,'KnCtvD002','Kn','Ctv','Co','Kleur',2,'0','Cdt.KnCtv3','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','36764D26475EBD721ABBDAA6A6204149','KnUnId',20,'AfasKnUniqueId','Kn','Cdt','CdId','$114653=~AContact Id~AId',0,'1','Cdt','$7260=Contact Id','1',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','36764D26475EBD721ABBDAA6A6204149','RlAdm',21,'AfasKnRoleAdm','Kn','VDF','YN',NULL,0,'0','Cdt',NULL,'1',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','36764D26475EBD721ABBDAA6A6204149','RlEmp',22,'AfasKnRoleEmp','Kn','VDF','YN',NULL,0,'0','Cdt',NULL,'1',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','36764D26475EBD721ABBDAA6A6204149','U001',4,'AfasQWTxU001','Tx','Com','FiNo',NULL,1,'0','Cdt.KnBcn.TxCom',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','36764D26475EBD721ABBDAA6A6204149','U002',5,'AfasQWKnU002','Kn','Bcn','CcNr',NULL,1,'0','Cdt.KnBcn',NULL,'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','36764D26475EBD721ABBDAA6A6204149','U003',19,'AfasQWKnU003','Kn','PRe','VaId',NULL,1,'0','Cdt.KnBcn.KnPRe',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','36764D26475EBD721ABBDAA6A6204149','U004',14,'AfasQWKnU004','Kn','Bcn','CaNm',NULL,1,'0','Cdt.KnBcn1',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','36764D26475EBD721ABBDAA6A6204149','U005',15,'AfasQWKnU005','Kn','Bcn','Is',NULL,1,'0','Cdt.KnBcn1',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','36764D26475EBD721ABBDAA6A6204149','U006',16,'AfasQWKnU006','Kn','Bcn','LaNm',NULL,1,'0','Cdt.KnBcn1',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','36764D26475EBD721ABBDAA6A6204149','U007',17,'AfasQWTxU007','Tx','Cli','SeNo',NULL,1,'0','Cdt.KnBcn.TxCli',NULL,'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','36764D26475EBD721ABBDAA6A6204149','U008',1,'AfasQWKnU008','Kn','Cdt','CdId',NULL,1,'1','Cdt',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','36764D26475EBD721ABBDAA6A6204149','U009',2,'AfasQWKnU009','Kn','Bcn','Nm',NULL,1,'1','Cdt.KnBcn',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','36764D26475EBD721ABBDAA6A6204149','U010',6,'AfasQWKnU010','Kn','Ctv','Ds','Soort contact',1,'0','Cdt.KnCtv','Soort contact','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','36764D26475EBD721ABBDAA6A6204149','U011',7,'AfasQWKnU011','Kn','Bcn','BcCo',NULL,1,'0','Cdt.KnBcn','Organisatie','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','36764D26475EBD721ABBDAA6A6204149','U012',8,'AfasQWKnU012','Kn','Bcn','BcCo','Contact Nr.',1,'0','Cdt.KnBcn1','Persoon','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','36764D26475EBD721ABBDAA6A6204149','U013',9,'AfasQWKnU013','Kn','Ctv','Ds','Functie',1,'0','Cdt.KnCtv3','Functie','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','36764D26475EBD721ABBDAA6A6204149','U014',10,'AfasQWKnU014','Kn','Cdt','MbNr',NULL,1,'1','Cdt',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','36764D26475EBD721ABBDAA6A6204149','U015',12,'AfasQWKnU015','Kn','Cdt','EmAd',NULL,1,'1','Cdt',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','36764D26475EBD721ABBDAA6A6204149','U016',3,'AfasQWKnU016','Kn','Bad','AdEL','AdresOrganisatie',1,'0','Cdt.KnBcn.KnBad',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','36764D26475EBD721ABBDAA6A6204149','U017',18,'AfasQWKnU017','Kn','Bcn','ICiB',NULL,1,'0','Cdt.KnBcn',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','36764D26475EBD721ABBDAA6A6204149','U021',11,'AfasQWKnU021','Kn','Cdt','MbN2','Contact Mob. priv',1,'1','Cdt',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','36764D26475EBD721ABBDAA6A6204149','U022',13,'AfasQWKnU022','Kn','Cdt','EmA2','Contact Mail priv',1,'1','Cdt',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,13,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','36764D26475EBD721ABBDAA6A6204149','BcnOwn',4,'Kn','Bcn',NULL,NULL,0,11001,'$88623=Eigenaar afspraak','1','0','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','36764D26475EBD721ABBDAA6A6204149','C01',5,'Kn','C01',NULL,NULL,0,NULL,'$85341=Vrij contactbestand 01','0','0','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','36764D26475EBD721ABBDAA6A6204149','C02',6,'Kn','C02',NULL,NULL,0,NULL,'$85342=Vrij contactbestand 02','0','0','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','36764D26475EBD721ABBDAA6A6204149','C03',7,'Kn','C03',NULL,NULL,0,NULL,'$85343=Vrij contactbestand 03','0','0','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','36764D26475EBD721ABBDAA6A6204149','C04',8,'Kn','C04',NULL,NULL,0,NULL,'$85344=Vrij contactbestand 04','0','0','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','36764D26475EBD721ABBDAA6A6204149','C05',9,'Kn','C05',NULL,NULL,0,NULL,'$85345=Vrij contactbestand 05','0','0','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','36764D26475EBD721ABBDAA6A6204149','C06',10,'Kn','C06',NULL,NULL,0,NULL,'$85346=Vrij contactbestand 06','0','0','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','36764D26475EBD721ABBDAA6A6204149','C07',11,'Kn','C07',NULL,NULL,0,NULL,'$85347=Vrij contactbestand 07','0','0','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','36764D26475EBD721ABBDAA6A6204149','C08',12,'Kn','C08',NULL,NULL,0,NULL,'$85348=Vrij contactbestand 08','0','0','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','36764D26475EBD721ABBDAA6A6204149','C09',13,'Kn','C09',NULL,NULL,0,NULL,'$85349=Vrij contactbestand 09','0','0','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','36764D26475EBD721ABBDAA6A6204149','C10',14,'Kn','C10',NULL,NULL,0,NULL,'$85350=Vrij contactbestand 10','0','0','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','36764D26475EBD721ABBDAA6A6204149','C11',15,'Kn','C11',NULL,NULL,0,NULL,'$85351=Vrij contactbestand 11','0','0','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','36764D26475EBD721ABBDAA6A6204149','C12',16,'Kn','C12',NULL,NULL,0,NULL,'$85352=Vrij contactbestand 12','0','0','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','36764D26475EBD721ABBDAA6A6204149','C13',17,'Kn','C13',NULL,NULL,0,NULL,'$85353=Vrij contactbestand 13','0','0','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','36764D26475EBD721ABBDAA6A6204149','C14',18,'Kn','C14',NULL,NULL,0,NULL,'$85354=Vrij contactbestand 14','0','0','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','36764D26475EBD721ABBDAA6A6204149','C15',19,'Kn','C15',NULL,NULL,0,NULL,'$85355=Vrij contactbestand 15','0','0','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','36764D26475EBD721ABBDAA6A6204149','C16',20,'Kn','C16',NULL,NULL,0,NULL,'$85356=Vrij contactbestand 16','0','0','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','36764D26475EBD721ABBDAA6A6204149','C17',21,'Kn','C17',NULL,NULL,0,NULL,'$85357=Vrij contactbestand 17','0','0','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','36764D26475EBD721ABBDAA6A6204149','C18',22,'Kn','C18',NULL,NULL,0,NULL,'$85358=Vrij contactbestand 18','0','0','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','36764D26475EBD721ABBDAA6A6204149','C19',23,'Kn','C19',NULL,NULL,0,NULL,'$85359=Vrij contactbestand 19','0','0','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','36764D26475EBD721ABBDAA6A6204149','C20',24,'Kn','C20',NULL,NULL,0,NULL,'$85360=Vrij contactbestand 20','0','0','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','36764D26475EBD721ABBDAA6A6204149','Cdt',1,'Kn','Cdt',NULL,NULL,0,NULL,'$856=Contact','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','36764D26475EBD721ABBDAA6A6204149','Csm',2,'Kn','Csm',NULL,NULL,0,11018,'$36726=Presentie','1','0','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','36764D26475EBD721ABBDAA6A6204149','Pap',3,'Kn','Pap',NULL,NULL,0,11001,'$77326=Genodigden afspraken','1','0','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','36764D26475EBD721ABBDAA6A6204149','WOI',25,'Kn','WOI',NULL,NULL,0,111037,'$144466=Opt-in','1','0','0','1',2,NULL)@D0@L@D0@A@D0@IKn@D0@I36764D26475EBD721ABBDAA6A6204149@D0@ISecureLogin_Contacten@D0@D13@D0@IU008@D0@IContact@D0@IU009@D0@INaam@D0@IU016@D0@IAdresvoorbeeld_op_1_regel@D0@IU001@D0@INaam_2@D0@IU002@D0@INummer@D0@IU010@D0@ISoort_contact@D0@IU011@D0@IOrganisatie@D0@IU012@D0@IPersoon@D0@IU013@D0@IFunctie@D0@IU014@D0@IMobiel_werk@D0@IU021@D0@IMobiel_prive@D0@IU015@D0@IE-mail_werk@D0@IU022@D0@IE-mail_prive@D0@IU004@D0@IAfdeling@D0@IU005@D0@IAdresvoorbeeld_op_1_regel_2@D0@IU006@D0@IGeblokkeerd@D0@IU007@D0@IOmschrijving@D0@IU017@D0@IClient_IB@D0@IU003@D0@IBtw-identificatienummer