D1@D57@D2009@D0@D1@D0@D4@D0@L@D0@D0@D0@D1D@D0@IGuid@D0@IFD46EE804FC82BC84F9874BC77128E10@D0@IType@D0@D8@D0@ICode@D0@A@D0@IDs@D0@ISecureLogin_IB_VPB_VRK@D0@IInfo@D0@IGegevensverzameling over organisaties en personen zonder filterautorisatie voor gebruik in rapporten/analyses@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@I86519.admin@D0@ICrDt@D0@H 44105.4965972222@D0@IChUs@D0@A@D0@IChDt@D0@A@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_Bcn02@D0@IVisi@D0@L1@D0@IMd@D0@A@D0@INCnd@D0@A@D0@IUsAu@D0@L@D0@IBu@D0@D2BC@D0@ISp@D0@D5@D1@D40@D2009@D0@D1@D0@I1@D0@D1@D0@D3@D0@I@D0@IKn@D0@I94DA5AB54864EA68C006F296777ABB85@D0@I@D0@D3@D0@D0@D0@D34@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','94DA5AB54864EA68C006F296777ABB85','Vw_AfasKn94DA5AB54864EA68C006F296777ABB85',NULL,'Bcn','Organisaties/Personen (excl. Autorisatie)','~-~*if exists (select * from sysobjects where id = object_id(''dbo.Vw_AfasKn94DA5AB54864EA68C006F296777ABB85'') and sysstat & 0xf = 2)~-~*  drop view dbo.Vw_AfasKn94DA5AB54864EA68C006F296777ABB85~-~*GO~-~*~-~*CREATE VIEW Vw_AfasKn94DA5AB54864EA68C006F296777ABB85 AS~-~*~-~*SELECT ~-~*  AfasKnSearchableName = REPLACE(CASE Bcn.AfasKnValueIntIdKind WHEN ''PER'' THEN Bcn.AfasKnNamePer6 ELSE Bcn.AfasKnName END, ''.'', '''')~-~*  ,AfasKnUniqueIndex = Bcn.AfasKnBasicContactId~-~*~-~*, NULL as AfasFbTotalSalesCurrentYear~-~*~-~*, NULL as AfasFbTotalSalesPreviousYear~-~*  , Bcn.AfasKnBlocked as AfasKnBlocked~-~*~-~*, NULL as AfasKnBarcode~-~*~-~*, NULL as AfasKnBasicContactPartId~-~*~-~*, Bcn.AfasKnBasicContactCode AfasQWKnU001,~-~*Bcn.AfasKnTypeSalRelationId AfasQWKnU008,~-~*Bcn.AfasKnTypeClientIBId AfasQWKnU003,~-~*Bcn.AfasKnTypeClientVpbId AfasQWKnU005,~-~*Bcn.AfasKnTypeClientOBId AfasQWKnU007,~-~*Bcn.AfasKnSearchName AfasQWKnU002,~-~*Bcn.AfasKnName AfasQWKnU004,~-~*AfasKnCodeTableValueQW43.AfasKnDescription AfasQWKnU006,~-~*Bcn.AfasKnModifiedDate AfasQWKnU009,~-~*Bcn.AfasKnCreateDate AfasQWKnU010,~-~*Bcn.AfasKnBasicContactId AfasQWKnKnBcnBcId,~-~*Bcn.AfasKnBasicContactCode AfasQWKnKnBcnBcCo,~-~*Bcn.AfasKnValueIntIdKind AfasQWKnKnBcnViKi,~-~*AfasKnCodeTableValueQW43.AfasKnColor KnCtvD001 ~-~*~-~*FROM AfasKnBasicContact AS Bcn~-~*~-~*LEFT JOIN AfasKnCodeTableValue AfasKnCodeTableValueQW43 ON  ''Kn'' = AfasKnCodeTableValueQW43.AfasKnSystemId AND  ''KindOfBcn'' = AfasKnCodeTableValueQW43.AfasKnCodeTableId AND Bcn.AfasKnValueIntIdKind = AfasKnCodeTableValueQW43.AfasKnValueIntId                            ~-~*~-~*WHERE Bcn.AfasKnIsProFormaEmp = ''0''~-~*~-~*/*QWWhereAdd*/~-~*GO','1','1','D1~BD0',NULL,'0','D2~BL1~BIBcn~BI~A-~A*---------------------------------------------------------------------~A-~A*-- Creator: ezw~A-~A*-- Date: 30-mei-2006~A-~A*-- ObjectName: Vw_AfasKnS_Bcn00~A-~A*-- Purpose: ~A-~A*---------------------------------------------------------------------~A-~A*~A-~A*if exists (select * from sysobjects where id = object_id(''dbo.Vw_AfasKnS_Bcn00'') and sysstat & 0xf = 2)~A-~A*  drop view dbo.Vw_AfasKnS_Bcn00~A-~A*GO~A-~A*~A-~A*CREATE VIEW Vw_AfasKnS_Bcn00 AS~A-~A*~A-~A*SELECT ~A-~A*  AfasKnSearchableName = /* #IF USEFIELD(AfasKnSearchableName)  #THEN ~A-~A*  REPLACE(CASE Bcn.AfasKnValueIntIdKind WHEN ''PER'' THEN Bcn.AfasKnNamePer6 ELSE Bcn.AfasKnName END, ''.'', '''')     #ELSE */ NULL /* #ENDIF */~A-~A*  ,AfasKnUniqueIndex = /* #IF ALIAS(Col) ~A-~A*                          OR ALIAS(Sub) ~A-~A*                          OR ALIAS(Sul) ~A-~A*                          OR ALIAS(CnlS)~A-~A*                          OR ALIAS(CnlT)~A-~A*                          OR ALIAS(Ban)~A-~A*                          OR 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) ~A-~A*                          OR ALIAS(Cws)~A-~A*                        #THEN Row_Number() Over (Order By Bcn.AfasKnBasicContactId Asc) #ELSE */ Bcn.AfasKnBasicContactId /* #ENDIF */~A-~A*~A-~A*/*#IF CONDITION(20001) AND USEFIELD(AfasFbTotalSalesCurrentYear) #THEN~A-~A*~A), (select top 1 Src.AfasFbAmtTotalPeriod~A-~A*    from AfasFbSalesRelationCum Src~A-~A*    inner join AfasKnPeriodTableRow Ptr~A-~A*      on Src.AfasFbPeriodTableId=Ptr.AfasKnPeriodTableId~A-~A*     and Src.AfasFbYear         =Ptr.AfasKnYear ~A-~A*     and convert(char(8),getdate(),112) between Ptr.AfasKnDateBegin and Ptr.AfasKnDateEnd~A-~A*    inner join AfasKnSalRelation SRe~A-~A*      on SRe.AfasKnDebtorId = Bcn.AfasKnTypeSalRelationId~A-~A*     and Bcn.AfasKnIsDebtor = ''1''~A-~A*   where Src.AfasFbDebtorId=SRe.AfasKnDebtorId~A-~A*   order by Src.AfasFbPeriodSeqNo desc)~A-~A*#ELSE */~A-~A*~A), NULL~A-~A*/*#ENDIF*/ as AfasFbTotalSalesCurrentYear~A-~A*~A-~A*/*#IF CONDITION(20001) AND USEFIELD(AfasFbTotalSalesPreviousYear) #THEN~A-~A*  , (select top 1 Src.AfasFbAmtTotalPeriod~A-~A*    from AfasFbSalesRelationCum Src~A-~A*    inner join AfasKnPeriodTableRow Ptr~A-~A*      on Src.AfasFbPeriodTableId=Ptr.AfasKnPeriodTableId~A-~A*     and Src.AfasFbYear         =Ptr.AfasKnYear ~A-~A*     and dateadd(year,-1,convert(char(8),getdate(),112)) between Ptr.AfasKnDateBegin and Ptr.AfasKnDateEnd~A-~A*    inner join AfasKnSalRelation SRe~A-~A*      on SRe.AfasKnDebtorId = Bcn.AfasKnTypeSalRelationId~A-~A*     and Bcn.AfasKnIsDebtor = ''1''~A-~A*   where Src.AfasFbDebtorId=SRe.AfasKnDebtorId~A-~A*   order by Src.AfasFbPeriodSeqNo desc)~A-~A*#ELSE */~A-~A*~A), NULL~A-~A*/*#ENDIF*/ as AfasFbTotalSalesPreviousYear~A-~A*  , Bcn.AfasKnBlocked as AfasKnBlocked~A-~A*~A-~A*/*#IF USEFIELD(AfasKnBarcode) #THEN~A-~A*  , dbo.Fn_AfasKnBcnBarcode(str(Bcn.AfasKnBasicContactId),Bcn.AfasKnBasicContactId)~A-~A*#ELSE */~A-~A*~A), NULL~A-~A*/*#ENDIF*/ as AfasKnBarcode~A-~A*~A-~A*/*#IF USEFIELD(AfasKnBasicContactPartId) #THEN~A-~A*~A), Bcn1.AfasKnBasicContactId~A-~A*#ELSE */~A-~A*~A), NULL~A-~A*/*#ENDIF*/ as AfasKnBasicContactPartId~A-~A*~A-~A*/*QWSelect*/~A-~A*~A-~A*FROM AfasKnBasicContact AS Bcn~A-~A*~A-~A*/*~A-~A*#IF ALIAS(Sub) OR ALIAS(Sul) OR ALIAS(Col) #THEN~A-~A*LEFT OUTER JOIN AfasFbSubscription Sub~A-~A*ON~A)Sub.AfasFbBasicContactId = Bcn.AfasKnBasicContactId~A-~A*~A-~A*  #IF ALIAS(Sul) #THEN~A-~A*  LEFT OUTER JOIN AfasFbSubscriptionLines Sul~A-~A*  ON~A)Sul.AfasFbSubscriptionNbr = Sub.AfasFbSubscriptionNbr~A-~A*  #ENDIF~A-~A*~A-~A*  #IF ALIAS(Col) #THEN~A-~A*  LEFT OUTER JOIN AfasFbCompositionLines Col~A-~A*  ON~A)Col.AfasFbSubscriptionNbr = Sub.AfasFbSubscriptionNbr~A-~A*  #ENDIF~A-~A*~A-~A*#ENDIF~A-~A*~A-~A*#IF ALIAS(CnlS) #THEN~A-~A*  LEFT OUTER JOIN AfasKnConnectionLine CnlS~A-~A*  ON    CnlS.AfasKnContactDataId1 = Bcn.AfasKnContactDataId~A-~A*#ENDIF~A-~A*#IF ALIAS(CnlT) #THEN~A-~A*  LEFT OUTER JOIN AfasKnConnectionLine CnlT~A-~A*  ON    CnlT.AfasKnContactDataId1 = Bcn.AfasKnContactDataId~A-~A*#ENDIF~A-~A*~A-~A*#IF ALIAS(Idf) #THEN~A-~A*  LEFT JOIN AfasKnIdentification Idf~A-~A*  ON Idf.AfasKnBasicContactId = Bcn.AfasKnBasicContactId~A-~A*  AND Idf.AfasKnDefaultNr = ''1''~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(Ban) #THEN~A-~A*  LEFT JOIN AfasKnBankAccountNr Ban~A-~A*  ON Ban.AfasKnBasicContactId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(WOI) #THEN~A-~A*  LEFT JOIN AfasKnWebOptIn WOI~A-~A*  ON WOI.AfasKnBasicContactId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF~A-~A*~A-~A*#IF ALIAS(Cws) #THEN~A-~A*  LEFT JOIN AfasKnCaseWareSubject Cws~A-~A*  ON Cws.AfasKnBasicContactId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A*#IF ALIAS(C01) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC01 C01~A-~A*  ON C01.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C02) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC02 C02~A-~A*  ON C02.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C03) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC03 C03~A-~A*  ON C03.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C04) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC04 C04~A-~A*  ON C04.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C05) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC05 C05~A-~A*  ON C05.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C06) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC06 C06~A-~A*  ON C06.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C07) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC07 C07~A-~A*  ON C07.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C08) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC08 C08~A-~A*  ON C08.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C09) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC09 C09~A-~A*  ON C09.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C10) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC10 C10~A-~A*  ON C10.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C11) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC11 C11~A-~A*  ON C11.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C12) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC12 C12~A-~A*  ON C12.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C13) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC13 C13~A-~A*  ON C13.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C14) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC14 C14~A-~A*  ON C14.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C15) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC15 C15~A-~A*  ON C15.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C16) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC16 C16~A-~A*  ON C16.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C17) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC17 C17~A-~A*  ON C17.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C18) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC18 C18~A-~A*  ON C18.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C19) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC19 C19~A-~A*  ON C19.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF ~A-~A*~A-~A* #IF ALIAS(C20) #THEN~A-~A*LEFT JOIN AfasKnCustomLinkC20 C20~A-~A*  ON C20.AfasKnContactDataId = Bcn.AfasKnBasicContactId~A-~A*#ENDIF~A-~A*~A-~A* #IF USEFIELD(AfasKnBasicContactPartId) #THEN~A-~A*LEFT JOIN AfasKnBasicContact Bcn1~A-~A*  ON Bcn1.AfasKnBasicContactId = Bcn.AfasKnBasicContactIdPart~A-~A*#ENDIF */~A-~A*~A-~A*/*QWFrom*/~A-~A*~A-~A*WHERE Bcn.AfasKnIsProFormaEmp = ''0''~A-~A*~A-~A*/*QWWhereAdd*/~A-~A*GO','S_Bcn00',NULL,NULL,'Kn',NULL,'0',NULL,NULL,11000,'0','0','B_Bcn02',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','94DA5AB54864EA68C006F296777ABB85','BaCo',19,'AfasKnBarcode','Fb','Sal','Baco',NULL,0,'0','Bcn',NULL,'1',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','94DA5AB54864EA68C006F296777ABB85','Bl',13,'AfasKnBlocked','Kn','Bcn','Bl',NULL,0,'0','Bcn',NULL,'1',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','94DA5AB54864EA68C006F296777ABB85','D001',21,'KnCtvD001','Kn','Ctv','Co',NULL,2,'0','Bcn.KnCtv',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','94DA5AB54864EA68C006F296777ABB85','FbSrcTpCu',11,'AfasFbTotalSalesCurrentYear','Fb','Src','AmPe',NULL,0,'0','Bcn',NULL,'1',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,11,NULL,20001,'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','94DA5AB54864EA68C006F296777ABB85','FbSrcTpPy',12,'AfasFbTotalSalesPreviousYear','Fb','Src','AmPe',NULL,0,'0','Bcn',NULL,'1',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,12,NULL,20001,'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','94DA5AB54864EA68C006F296777ABB85','KnBcn1BcId',20,'AfasKnBasicContactPartId','Kn','VDF','Id',NULL,0,'0','Bcn1',NULL,'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','94DA5AB54864EA68C006F296777ABB85','KnBcnBcCo',15,'AfasQWKnKnBcnBcCo','Kn','Bcn','BcCo',NULL,2,'1','Bcn',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,15,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','94DA5AB54864EA68C006F296777ABB85','KnBcnBcId',14,'AfasQWKnKnBcnBcId','Kn','Bcn','BcId',NULL,2,'1','Bcn',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,14,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','94DA5AB54864EA68C006F296777ABB85','KnBcnId',18,'AfasKnUniqueIndex','Kn','VDF','Id',NULL,2,'0','Bcn',NULL,'1',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','94DA5AB54864EA68C006F296777ABB85','KnBcnViKi',16,'AfasQWKnKnBcnViKi','Kn','Bcn','ViKi',NULL,2,'1','Bcn',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,16,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','94DA5AB54864EA68C006F296777ABB85','SbNm',17,'AfasKnSearchableName','Kn','VDF','T255',NULL,2,'0','Bcn',NULL,'1',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','94DA5AB54864EA68C006F296777ABB85','U001',1,'AfasQWKnU001','Kn','Bcn','BcCo',NULL,1,'1','Bcn',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','94DA5AB54864EA68C006F296777ABB85','U002',6,'AfasQWKnU002','Kn','Bcn','SeNm',NULL,1,'1','Bcn',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','94DA5AB54864EA68C006F296777ABB85','U003',3,'AfasQWKnU003','Kn','Bcn','TCiB',NULL,1,'1','Bcn',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','94DA5AB54864EA68C006F296777ABB85','U004',7,'AfasQWKnU004','Kn','Bcn','Nm',NULL,1,'1','Bcn',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','94DA5AB54864EA68C006F296777ABB85','U005',4,'AfasQWKnU005','Kn','Bcn','TVpb',NULL,1,'1','Bcn',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','94DA5AB54864EA68C006F296777ABB85','U006',8,'AfasQWKnU006','Kn','Ctv','Ds','Organisatie/persoon',1,'0','Bcn.KnCtv','Organisatie/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','94DA5AB54864EA68C006F296777ABB85','U007',5,'AfasQWKnU007','Kn','Bcn','TCob',NULL,1,'1','Bcn',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','94DA5AB54864EA68C006F296777ABB85','U008',2,'AfasQWKnU008','Kn','Bcn','TSRe',NULL,1,'1','Bcn',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','94DA5AB54864EA68C006F296777ABB85','U009',9,'AfasQWKnU009','Kn','Bcn','MdDa',NULL,1,'1','Bcn',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,9,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL)@D0@Iinsert AfasMdViewField (AfasMdSystemId, AfasMdViewId, AfasMdViewFieldId, AfasMdFieldSeqno, AfasMdName, AfasMdSystemIdFld, AfasMdTableIdFld, AfasMdFieldId, AfasMdColumnHeader, AfasMdDisplay, AfasMdMainTable, AfasMdForeignKeyPath, AfasMdLabel, AfasMdExtension, AfasMdAVSystemId, AfasMdAVViewId, AfasMdAVFieldId, AfasMdFilterLevel, AfasMdSearchSystemId, AfasMdSearchTableId, AfasMdSearchFieldId, AfasMdCustomProp, AfasMdAggFunc, AfasMdGroupIndex, AfasMdFKeyPathFieldId, AfasMdConditionSeqNo, AfasMdFixedField, AfasMdSQLFunctionSystemId, AfasMdSQLFunctionId, AfasMdBold, AfasMdColor, AfasMdOrderBy, AfasMdOrderType) values ('Kn','94DA5AB54864EA68C006F296777ABB85','U010',10,'AfasQWKnU010','Kn','Bcn','CrDa',NULL,1,'1','Bcn',NULL,'0',NULL,NULL,NULL,0,NULL,NULL,NULL,'0',0,10,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','94DA5AB54864EA68C006F296777ABB85','Ban',28,'Kn','Ban',NULL,NULL,0,NULL,'$5919=Bankrekening','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','94DA5AB54864EA68C006F296777ABB85','Bcn',1,'Kn','Bcn',NULL,NULL,0,NULL,'$77799=Organisatie/persoon','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','94DA5AB54864EA68C006F296777ABB85','C01',8,'Kn','C01',NULL,NULL,0,11000,'$85341=Vrij contactbestand 01','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C02',9,'Kn','C02',NULL,NULL,0,11006,'$85342=Vrij contactbestand 02','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C03',10,'Kn','C03',NULL,NULL,0,11006,'$85343=Vrij contactbestand 03','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C04',11,'Kn','C04',NULL,NULL,0,11006,'$85344=Vrij contactbestand 04','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C05',12,'Kn','C05',NULL,NULL,0,11006,'$85345=Vrij contactbestand 05','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C06',13,'Kn','C06',NULL,NULL,0,11000,'$85346=Vrij contactbestand 06','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C07',14,'Kn','C07',NULL,NULL,0,11006,'$85347=Vrij contactbestand 07','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C08',15,'Kn','C08',NULL,NULL,0,11006,'$85348=Vrij contactbestand 08','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C09',16,'Kn','C09',NULL,NULL,0,11006,'$85349=Vrij contactbestand 09','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C10',17,'Kn','C10',NULL,NULL,0,11006,'$85350=Vrij contactbestand 10','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C11',18,'Kn','C11',NULL,NULL,0,11006,'$85351=Vrij contactbestand 11','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C12',19,'Kn','C12',NULL,NULL,0,11006,'$85352=Vrij contactbestand 12','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C13',20,'Kn','C13',NULL,NULL,0,11006,'$85353=Vrij contactbestand 13','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C14',21,'Kn','C14',NULL,NULL,0,11006,'$85354=Vrij contactbestand 14','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C15',22,'Kn','C15',NULL,NULL,0,11006,'$85355=Vrij contactbestand 15','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C16',23,'Kn','C16',NULL,NULL,0,11006,'$85356=Vrij contactbestand 16','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C17',24,'Kn','C17',NULL,NULL,0,11006,'$85357=Vrij contactbestand 17','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C18',25,'Kn','C18',NULL,NULL,0,11006,'$85358=Vrij contactbestand 18','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C19',26,'Kn','C19',NULL,NULL,0,11006,'$85359=Vrij contactbestand 19','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','C20',27,'Kn','C20',NULL,NULL,0,11006,'$85360=Vrij contactbestand 20','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','CnlS',6,'Kn','Cnl',NULL,NULL,0,NULL,'$92841=Verbanden vanaf bron','1','1','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','CnlT',7,'Kn','Cnl',NULL,NULL,0,NULL,'$92842=Verbanden vanaf doel','1','1','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','Col',2,'Fb','Col',NULL,NULL,0,20014,'$24439=Samenstellingsregels abonnement','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','Cws',30,'Kn','Cws',NULL,NULL,0,102037,'$165567=Caseware dossier','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','Idf',3,'Kn','Idf',NULL,NULL,0,NULL,'$829=Identificatie','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','94DA5AB54864EA68C006F296777ABB85','Sub',4,'Fb','Sub',NULL,NULL,0,20002,'$2255=Abonnementen','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','Sul',5,'Fb','Sul',NULL,NULL,0,20002,'$23274=Abonnementsregels','1','0','0','1',3,NULL)@D0@Iinsert AfasMdViewAlias (AfasMdSystemId, AfasMdViewId, AfasMdAlias, AfasMdSeqNo, AfasMdTargetSystemIdTable, AfasMdTargetTableId, AfasMdTargetSystemIdView, AfasMdTargetViewId, AfasMdTargetType, AfasMdCondition, AfasMdDescription, AfasMdLeftJoinOnly, AfasMdDefault, AfasMdAlwaysOn, AfasMdVisible, AfasMdJoinType, AfasMdTargetViewTableAlias) values ('Kn','94DA5AB54864EA68C006F296777ABB85','WOI',29,'Kn','WOI',NULL,NULL,0,111037,'$144466=Opt-in','1','0','0','1',2,NULL)@D0@L@D0@A@D0@IKn@D0@I94DA5AB54864EA68C006F296777ABB85@D0@ISecureLogin_IB_VPB_VRK@D0@DA@D0@IU001@D0@INummer@D0@IU008@D0@IVerkooprelatie@D0@IU003@D0@IClient_IB@D0@IU005@D0@IClient_Vpb@D0@IU007@D0@IClient_OB@D0@IU002@D0@INummer_2@D0@IU004@D0@IOmschrijving@D0@IU006@D0@INaam@D0@IU009@D0@IGewijzigd_op@D0@IU010@D0@IAangemaakt_op