get invoices.sql

exec sp_executesql N'SELECT 
    [UnionAll2].[SIHeadId] AS [C1], 
    [UnionAll2].[SIHeadId1] AS [C2], 
    [UnionAll2].[InvoiceTypeId] AS [C3], 
    [UnionAll2].[InvoiceNumber] AS [C4], 
    [UnionAll2].[CreationDate] AS [C5], 
    [UnionAll2].[DeliveryDate] AS [C6], 
    [UnionAll2].[ReceivedDate] AS [C7], 
    [UnionAll2].[CaptureDate] AS [C8], 
    [UnionAll2].[BuyerGLDate] AS [C9], 
    [UnionAll2].[SupplierGLDate] AS [C10], 
    [UnionAll2].[TaxPoint] AS [C11], 
    [UnionAll2].[DueDate] AS [C12], 
    [UnionAll2].[AgreedDiscountPaymentDate] AS [C13], 
    [UnionAll2].[CurrencyCode] AS [C14], 
    [UnionAll2].[TotalBeforeTax] AS [C15], 
    [UnionAll2].[TotalTax] AS [C16], 
    [UnionAll2].[TotalIncludingTax] AS [C17], 
    [UnionAll2].[Comment] AS [C18], 
    [UnionAll2].[FromCompanyId] AS [C19], 
    [UnionAll2].[ToCompanyId] AS [C20], 
    [UnionAll2].[FactorCompanyId] AS [C21], 
    [UnionAll2].[PayeeAuxId] AS [C22], 
    [UnionAll2].[BuyerInvoiceStateMask] AS [C23], 
    [UnionAll2].[SupplierInvoiceStateMask] AS [C24], 
    [UnionAll2].[FactorInvoiceStateMask] AS [C25], 
    [UnionAll2].[OtherPartyInvoiceStateMask] AS [C26], 
    [UnionAll2].[RawSalesInvoiceId] AS [C27], 
    [UnionAll2].[DiscountSchemeId] AS [C28], 
    [UnionAll2].[TransactionNumberSeriesId] AS [C29], 
    [UnionAll2].[OwningUserId] AS [C30], 
    [UnionAll2].[IsFlipped] AS [C31], 
    [UnionAll2].[LastUpdated] AS [C32], 
    [UnionAll2].[Version] AS [C33], 
    [UnionAll2].[SerializationStatus] AS [C34], 
    [UnionAll2].[SerializationError] AS [C35], 
    [UnionAll2].[C1] AS [C36], 
    [UnionAll2].[SIHeadId2] AS [C37], 
    [UnionAll2].[SIHeadId3] AS [C38], 
    [UnionAll2].[ExternalReferenceSystemId] AS [C39], 
    [UnionAll2].[Reference] AS [C40], 
    [UnionAll2].[LastUpdated1] AS [C41], 
    [UnionAll2].[Version1] AS [C42], 
    [UnionAll2].[SIHeadId4] AS [C43], 
    [UnionAll2].[ExternalReferenceSystemId1] AS [C44], 
    [UnionAll2].[ExternalReferenceSystemId2] AS [C45], 
    [UnionAll2].[DisplayName] AS [C46], 
    [UnionAll2].[IsStandard] AS [C47], 
    [UnionAll2].[AppliesToEntityTypeMask] AS [C48], 
    [UnionAll2].[OrganisationId] AS [C49], 
    [UnionAll2].[LastUpdated2] AS [C50], 
    [UnionAll2].[Version2] AS [C51], 
    [UnionAll2].[C2] AS [C52], 
    [UnionAll2].[C3] AS [C53], 
    [UnionAll2].[C4] AS [C54], 
    [UnionAll2].[C5] AS [C55], 
    [UnionAll2].[C6] AS [C56], 
    [UnionAll2].[C7] AS [C57], 
    [UnionAll2].[C8] AS [C58], 
    [UnionAll2].[C9] AS [C59], 
    [UnionAll2].[C10] AS [C60], 
    [UnionAll2].[C11] AS [C61]
    FROM  (SELECT 
        CASE WHEN ([Join1].[SIHeadId] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C1], 
        [Extent1].[SIHeadId] AS [SIHeadId], 
        [Extent1].[SIHeadId] AS [SIHeadId1], 
        [Extent1].[InvoiceTypeId] AS [InvoiceTypeId], 
        [Extent1].[InvoiceNumber] AS [InvoiceNumber], 
        [Extent1].[CreationDate] AS [CreationDate], 
        [Extent1].[DeliveryDate] AS [DeliveryDate], 
        [Extent1].[ReceivedDate] AS [ReceivedDate], 
        [Extent1].[CaptureDate] AS [CaptureDate], 
        [Extent1].[BuyerGLDate] AS [BuyerGLDate], 
        [Extent1].[SupplierGLDate] AS [SupplierGLDate], 
        [Extent1].[TaxPoint] AS [TaxPoint], 
        [Extent1].[DueDate] AS [DueDate], 
        [Extent1].[AgreedDiscountPaymentDate] AS [AgreedDiscountPaymentDate], 
        [Extent1].[CurrencyCode] AS [CurrencyCode], 
        [Extent1].[TotalBeforeTax] AS [TotalBeforeTax], 
        [Extent1].[TotalTax] AS [TotalTax], 
        [Extent1].[TotalIncludingTax] AS [TotalIncludingTax], 
        [Extent1].[Comment] AS [Comment], 
        [Extent1].[FromCompanyId] AS [FromCompanyId], 
        [Extent1].[ToCompanyId] AS [ToCompanyId], 
        [Extent1].[FactorCompanyId] AS [FactorCompanyId], 
        [Extent1].[PayeeAuxId] AS [PayeeAuxId], 
        [Extent1].[BuyerInvoiceStateMask] AS [BuyerInvoiceStateMask], 
        [Extent1].[SupplierInvoiceStateMask] AS [SupplierInvoiceStateMask], 
        [Extent1].[FactorInvoiceStateMask] AS [FactorInvoiceStateMask], 
        [Extent1].[OtherPartyInvoiceStateMask] AS [OtherPartyInvoiceStateMask], 
        [Extent1].[RawSalesInvoiceId] AS [RawSalesInvoiceId], 
        [Extent1].[DiscountSchemeId] AS [DiscountSchemeId], 
        [Extent1].[TransactionNumberSeriesId] AS [TransactionNumberSeriesId], 
        [Extent1].[OwningUserId] AS [OwningUserId], 
        [Extent1].[IsFlipped] AS [IsFlipped], 
        [Extent1].[LastUpdated] AS [LastUpdated], 
        [Extent1].[Version] AS [Version], 
        [Extent1].[SerializationStatus] AS [SerializationStatus], 
        [Extent1].[SerializationError] AS [SerializationError], 
        [Join1].[SIHeadId] AS [SIHeadId2], 
        [Join1].[SIHeadId] AS [SIHeadId3], 
        [Join1].[ExternalReferenceSystemId1] AS [ExternalReferenceSystemId], 
        [Join1].[Reference] AS [Reference], 
        [Join1].[LastUpdated1] AS [LastUpdated1], 
        [Join1].[Version1] AS [Version1], 
        [Join1].[SIHeadId] AS [SIHeadId4], 
        [Join1].[ExternalReferenceSystemId1] AS [ExternalReferenceSystemId1], 
        [Join1].[ExternalReferenceSystemId2] AS [ExternalReferenceSystemId2], 
        [Join1].[DisplayName] AS [DisplayName], 
        [Join1].[IsStandard] AS [IsStandard], 
        [Join1].[AppliesToEntityTypeMask] AS [AppliesToEntityTypeMask], 
        [Join1].[OrganisationId] AS [OrganisationId], 
        [Join1].[LastUpdated2] AS [LastUpdated2], 
        [Join1].[Version2] AS [Version2], 
        CAST(NULL AS int) AS [C2], 
        CAST(NULL AS int) AS [C3], 
        CAST(NULL AS varchar(1)) AS [C4], 
        CAST(NULL AS int) AS [C5], 
        CAST(NULL AS int) AS [C6], 
        CAST(NULL AS uniqueidentifier) AS [C7], 
        CAST(NULL AS int) AS [C8], 
        CAST(NULL AS datetime2) AS [C9], 
        CAST(NULL AS int) AS [C10], 
        CAST(NULL AS varchar(1)) AS [C11]
        FROM  [dbo].[SIHead] AS [Extent1]
        LEFT OUTER JOIN  (SELECT [Extent2].[SIHeadId] AS [SIHeadId], [Extent2].[ExternalReferenceSystemId] AS [ExternalReferenceSystemId1], [Extent2].[Reference] AS [Reference], [Extent2].[LastUpdated] AS [LastUpdated1], [Extent2].[Version] AS [Version1], [Extent3].[ExternalReferenceSystemId] AS [ExternalReferenceSystemId2], [Extent3].[DisplayName] AS [DisplayName], [Extent3].[IsStandard] AS [IsStandard], [Extent3].[AppliesToEntityTypeMask] AS [AppliesToEntityTypeMask], [Extent3].[OrganisationId] AS [OrganisationId], [Extent3].[LastUpdated] AS [LastUpdated2], [Extent3].[Version] AS [Version2]
            FROM  [dbo].[SIHeadExternalReference] AS [Extent2]
            INNER JOIN [dbo].[ExternalReferenceSystem] AS [Extent3] ON [Extent2].[ExternalReferenceSystemId] = [Extent3].[ExternalReferenceSystemId] ) AS [Join1] ON [Extent1].[SIHeadId] = [Join1].[SIHeadId]
        WHERE (( EXISTS (SELECT 
            1 AS [C1]
            FROM ( SELECT 
                [Extent5].[RoleId] AS [RoleId]
                FROM  [dbo].[Company] AS [Extent4]
                INNER JOIN [dbo].[RoleCompany] AS [Extent5] ON [Extent4].[CompanyId] = [Extent5].[CompanyId]
                WHERE (( EXISTS (SELECT 
                    1 AS [C1]
                    FROM  [dbo].[User] AS [Extent6]
                    INNER JOIN [dbo].[aspnet_Users] AS [Extent7] ON [Extent6].[UserId] = [Extent7].[UserId]
                    WHERE ([Extent6].[OrganisationId] IS NOT NULL) AND (( EXISTS (SELECT 
                        1 AS [C1]
                        FROM  [dbo].[User] AS [Extent8]
                        INNER JOIN [dbo].[aspnet_Users] AS [Extent9] ON [Extent8].[UserId] = [Extent9].[UserId]
                        WHERE ([Extent6].[OrganisationId] = [Extent8].[OrganisationId]) AND (([Extent9].[UserName] = @DynamicFilterParam_000001) OR (1 = 0))
                    )) ) AND ([Extent4].[OrganisationId] = [Extent6].[OrganisationId]) AND (([Extent7].[UserName] = @DynamicFilterParam_000003) OR (1 = 0))
                )) ) AND ([Extent1].[FactorCompanyId] = [Extent4].[CompanyId])
            )  AS [Project3]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[aspnet_UsersInRoles] AS [Extent10]
                INNER JOIN [dbo].[aspnet_Users] AS [Extent11] ON [Extent10].[UserId] = [Extent11].[UserId]
                WHERE ([Project3].[RoleId] = [Extent10].[RoleId]) AND ([Extent11].[UserName] = @DynamicFilterParam_000005)
            )) AND ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[RolePrivilege] AS [Extent12]
                INNER JOIN [dbo].[Privilege] AS [Extent13] ON [Extent13].[PrivilegeId] = [Extent12].[PrivilegeId]
                WHERE ([Project3].[RoleId] = [Extent12].[RoleId]) AND ([Extent13].[SystemName] = N''Factor View Invoice'')
            ))
        )) OR ( EXISTS (SELECT 
            1 AS [C1]
            FROM ( SELECT 
                [Extent20].[RoleId] AS [RoleId]
                FROM   (SELECT TOP (1) 
                    [Extent14].[CompanyId] AS [CompanyId], 
                    [Extent14].[OrganisationId] AS [OrganisationId], 
                    [Extent15].[CompanyAuxId] AS [CompanyAuxId], 
                    [Extent15].[CompanyId] AS [CompanyId1]
                    FROM  [dbo].[Company] AS [Extent14]
                    INNER JOIN [dbo].[CompanyAux] AS [Extent15] ON [Extent15].[CompanyId] = [Extent14].[CompanyId]
                    WHERE ([Extent1].[ToCompanyId] = [Extent15].[CompanyAuxId]) AND (( EXISTS (SELECT 
                        1 AS [C1]
                        FROM  [dbo].[User] AS [Extent16]
                        INNER JOIN [dbo].[aspnet_Users] AS [Extent17] ON [Extent16].[UserId] = [Extent17].[UserId]
                        WHERE ([Extent16].[OrganisationId] IS NOT NULL) AND (( EXISTS (SELECT 
                            1 AS [C1]
                            FROM  [dbo].[User] AS [Extent18]
                            INNER JOIN [dbo].[aspnet_Users] AS [Extent19] ON [Extent18].[UserId] = [Extent19].[UserId]
                            WHERE ([Extent16].[OrganisationId] = [Extent18].[OrganisationId]) AND (([Extent19].[UserName] = @DynamicFilterParam_000001) OR (1 = 0))
                        )) ) AND ([Extent14].[OrganisationId] = [Extent16].[OrganisationId]) AND (([Extent17].[UserName] = @DynamicFilterParam_000003) OR (1 = 0))
                    )) ) ) AS [Element1]
                INNER JOIN [dbo].[RoleCompany] AS [Extent20] ON [Element1].[CompanyId] = [Extent20].[CompanyId]
            )  AS [Project10]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[aspnet_UsersInRoles] AS [Extent21]
                INNER JOIN [dbo].[aspnet_Users] AS [Extent22] ON [Extent21].[UserId] = [Extent22].[UserId]
                WHERE ([Project10].[RoleId] = [Extent21].[RoleId]) AND ([Extent22].[UserName] = @DynamicFilterParam_000005)
            )) AND ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[RolePrivilege] AS [Extent23]
                INNER JOIN [dbo].[Privilege] AS [Extent24] ON [Extent24].[PrivilegeId] = [Extent23].[PrivilegeId]
                WHERE ([Project10].[RoleId] = [Extent23].[RoleId]) AND ([Extent24].[SystemName] = N''View Invoice'')
            ))
        )) OR ( EXISTS (SELECT 
            1 AS [C1]
            FROM ( SELECT 
                [Extent31].[RoleId] AS [RoleId]
                FROM   (SELECT TOP (1) 
                    [Extent25].[CompanyId] AS [CompanyId], 
                    [Extent25].[OrganisationId] AS [OrganisationId], 
                    [Extent26].[CompanyAuxId] AS [CompanyAuxId], 
                    [Extent26].[CompanyId] AS [CompanyId1]
                    FROM  [dbo].[Company] AS [Extent25]
                    INNER JOIN [dbo].[CompanyAux] AS [Extent26] ON [Extent26].[CompanyId] = [Extent25].[CompanyId]
                    WHERE ([Extent1].[FromCompanyId] = [Extent26].[CompanyAuxId]) AND (( EXISTS (SELECT 
                        1 AS [C1]
                        FROM  [dbo].[User] AS [Extent27]
                        INNER JOIN [dbo].[aspnet_Users] AS [Extent28] ON [Extent27].[UserId] = [Extent28].[UserId]
                        WHERE ([Extent27].[OrganisationId] IS NOT NULL) AND (( EXISTS (SELECT 
                            1 AS [C1]
                            FROM  [dbo].[User] AS [Extent29]
                            INNER JOIN [dbo].[aspnet_Users] AS [Extent30] ON [Extent29].[UserId] = [Extent30].[UserId]
                            WHERE ([Extent27].[OrganisationId] = [Extent29].[OrganisationId]) AND (([Extent30].[UserName] = @DynamicFilterParam_000001) OR (1 = 0))
                        )) ) AND ([Extent25].[OrganisationId] = [Extent27].[OrganisationId]) AND (([Extent28].[UserName] = @DynamicFilterParam_000003) OR (1 = 0))
                    )) ) ) AS [Element2]
                INNER JOIN [dbo].[RoleCompany] AS [Extent31] ON [Element2].[CompanyId] = [Extent31].[CompanyId]
            )  AS [Project17]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[aspnet_UsersInRoles] AS [Extent32]
                INNER JOIN [dbo].[aspnet_Users] AS [Extent33] ON [Extent32].[UserId] = [Extent33].[UserId]
                WHERE ([Project17].[RoleId] = [Extent32].[RoleId]) AND ([Extent33].[UserName] = @DynamicFilterParam_000005)
            )) AND ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[RolePrivilege] AS [Extent34]
                INNER JOIN [dbo].[Privilege] AS [Extent35] ON [Extent35].[PrivilegeId] = [Extent34].[PrivilegeId]
                WHERE ([Project17].[RoleId] = [Extent34].[RoleId]) AND ([Extent35].[SystemName] = N''View Sales Invoice'')
            ))
        )) OR ( EXISTS (SELECT 
            1 AS [C1]
            FROM   [dbo].[SIHeadContact] AS [Extent36]
            INNER JOIN [dbo].[Contact] AS [Extent37] ON [Extent36].[ContactId] = [Extent37].[ContactId]
            LEFT OUTER JOIN  (SELECT [Extent38].[UserName] AS [UserName], [Extent39].[UserId] AS [UserId1]
                FROM  [dbo].[aspnet_Users] AS [Extent38]
                LEFT OUTER JOIN [dbo].[User] AS [Extent39] ON [Extent38].[UserId] = [Extent39].[UserId] ) AS [Join21] ON [Join21].[UserId1] = [Extent37].[UserId]
            WHERE ([Extent1].[SIHeadId] = [Extent36].[SIHeadId]) AND (([Join21].[UserName] = @DynamicFilterParam_000005) OR (([Join21].[UserName] IS NULL) AND (@DynamicFilterParam_000005 IS NULL)))
        )) ) AND ( EXISTS (SELECT 
            1 AS [C1]
            FROM  [dbo].[SIHeadExternalReference] AS [Extent40]
            INNER JOIN [dbo].[ExternalReferenceSystem] AS [Extent41] ON [Extent40].[ExternalReferenceSystemId] = [Extent41].[ExternalReferenceSystemId]
            WHERE ([Extent1].[SIHeadId] = [Extent40].[SIHeadId]) AND ([Extent41].[DisplayName] + N''|'' + [Extent40].[Reference] IN (N''FCS|5100020371FR012017'', N''FCS|5100020940FR012017'', 
N''FCS|5100027630FR012017'', N''FCS|5100019451FR012017'', N''FCS|5100020115FR012017'', N''FCS|5100020118FR012017'', N''FCS|5100021016FR012017'', N''FCS|5100024827FR012017'', 
N''FCS|5100026457FR012017'', N''FCS|5100020120FR012017'', N''FCS|5100022743FR012017'', N''FCS|5100022744FR012017'', N''FCS|5100022702FR012017'', N''FCS|5100022703FR012017'', 
N''FCS|5100022704FR012017'', N''FCS|5100022735FR012017'', N''FCS|5100022736FR012017'', N''FCS|5100024026FR012017'', N''FCS|5100024395FR012017'', N''FCS|5100024615FR012017'', 
N''FCS|5100024899FR012017'', N''FCS|5100024971FR012017'', N''FCS|5100025219FR012017'', N''FCS|5100026161FR012017'', N''FCS|5100028517FR012017'', N''FCS|5100028882FR012017'', 
N''FCS|5100024399FR012017'', N''FCS|5100024293FR012017'', N''FCS|5100024408FR012017'', N''FCS|5100024501FR012017'', N''FCS|5100024622FR012017'', N''FCS|5100025317FR012017'', 
N''FCS|5100028461FR012017'', N''FCS|5100024256FR012017'', N''FCS|5100024294FR012017'', N''FCS|5100025547FR012017'', N''FCS|5100028462FR012017'', N''FCS|5100028454FR012017'', 
N''FCS|5100028455FR012017'', N''FCS|5100028456FR012017'', N''FCS|5100028465FR012017'', N''FCS|5100028452FR012017'', N''FCS|5100029430FR012017'', N''FCS|5100028463FR012017'', 
N''FCS|5100028464FR012017'', N''FCS|5100028473FR012017'', N''FCS|5100029343FR012017'', N''FCS|5100029594FR012017'', N''FCS|5100028449FR012017'', N''FCS|5100028450FR012017'', 
N''FCS|5100028457FR012017'', N''FCS|5100028468FR012017'', N''FCS|5100028520FR012017'', N''FCS|5100028528FR012017'', N''FCS|5100028530FR012017'', N''FCS|5100028531FR012017'', 
N''FCS|5100028645FR012017'', N''FCS|5100029458FR012017'', N''FCS|5100029376FR012017'', N''FCS|5100031929FR012017'', N''FCS|5100030518FR012017'', N''FCS|5100030519FR012017'', 
N''FCS|5100030520FR012017'', N''FCS|5100030521FR012017'', N''FCS|5100030522FR012017'', N''FCS|5100030582FR012017'', N''FCS|5100030602FR012017'', N''FCS|5100031953FR012017'', N''FCS|5100031955FR012017'', N''FCS|5100030517FR012017'', N''FCS|5100030523FR012017'', N''FCS|5100030524FR012017'', N''FCS|5100030525FR012017'', N''FCS|5100030607FR012017'', N''FCS|2800008446FR012017'', N''FCS|2800008447FR012017'', N''FCS|2800008448FR012017'', N''FCS|2800008449FR012017'', N''FCS|2800008450FR012017'', N''FCS|2800008451FR012017'', N''FCS|2800008452FR012017'', N''FCS|2800008453FR012017'', N''FCS|2800008454FR012017'', N''FCS|2800008455FR012017'', N''FCS|2800008456FR012017'', N''FCS|2800008457FR012017'', N''FCS|2800008458FR012017'', N''FCS|2800008459FR012017'', N''FCS|2800008460FR012017'', N''FCS|2800008461FR012017'', N''FCS|2800008568FR012017'', N''FCS|2800008569FR012017'', N''FCS|2800008570FR012017'', N''FCS|2800008571FR012017'', N''FCS|2800008572FR012017'', N''FCS|2800008578FR012017'', N''FCS|2800008584FR012017'', N''FCS|2800008586FR012017'', N''FCS|2800008588FR012017'', N''FCS|2800008593FR012017'', N''FCS|2800009022FR012017'', N''FCS|2800009114FR012017'', N''FCS|2800009115FR012017'', N''FCS|2800009116FR012017'', N''FCS|2800009117FR012017'', N''FCS|2800009118FR012017'', N''FCS|5100030145FR012017'', N''FCS|5100018813FR012017'', N''FCS|5100021839FR012017'', N''FCS|5100022034FR012017'', N''FCS|5100022035FR012017'', N''FCS|5100022461FR012017'', N''FCS|5100024303FR012017'', N''FCS|5100024838FR012017'', N''FCS|5100025482FR012017'', N''FCS|5100027951FR012017'', N''FCS|5100028602FR012017'', N''FCS|5100029422FR012017'', N''FCS|5100029478FR012017'', N''FCS|5100029479FR012017'', N''FCS|5100029480FR012017'', N''FCS|5100029481FR012017'', N''FCS|5100029482FR012017'', N''FCS|5100029483FR012017'', N''FCS|5100029484FR012017'', N''FCS|5100029488FR012017'', N''FCS|5100031927FR012017'', N''FCS|1000003249FR012017'')) AND ([Extent41].[DisplayName] + N''|'' + [Extent40].[Reference] IS NOT NULL)
        ))
    UNION ALL
        SELECT 
        2 AS [C1], 
        [Extent42].[SIHeadId] AS [SIHeadId], 
        [Extent42].[SIHeadId] AS [SIHeadId1], 
        [Extent42].[InvoiceTypeId] AS [InvoiceTypeId], 
        [Extent42].[InvoiceNumber] AS [InvoiceNumber], 
        [Extent42].[CreationDate] AS [CreationDate], 
        [Extent42].[DeliveryDate] AS [DeliveryDate], 
        [Extent42].[ReceivedDate] AS [ReceivedDate], 
        [Extent42].[CaptureDate] AS [CaptureDate], 
        [Extent42].[BuyerGLDate] AS [BuyerGLDate], 
        [Extent42].[SupplierGLDate] AS [SupplierGLDate], 
        [Extent42].[TaxPoint] AS [TaxPoint], 
        [Extent42].[DueDate] AS [DueDate], 
        [Extent42].[AgreedDiscountPaymentDate] AS [AgreedDiscountPaymentDate], 
        [Extent42].[CurrencyCode] AS [CurrencyCode], 
        [Extent42].[TotalBeforeTax] AS [TotalBeforeTax], 
        [Extent42].[TotalTax] AS [TotalTax], 
        [Extent42].[TotalIncludingTax] AS [TotalIncludingTax], 
        [Extent42].[Comment] AS [Comment], 
        [Extent42].[FromCompanyId] AS [FromCompanyId], 
        [Extent42].[ToCompanyId] AS [ToCompanyId], 
        [Extent42].[FactorCompanyId] AS [FactorCompanyId], 
        [Extent42].[PayeeAuxId] AS [PayeeAuxId], 
        [Extent42].[BuyerInvoiceStateMask] AS [BuyerInvoiceStateMask], 
        [Extent42].[SupplierInvoiceStateMask] AS [SupplierInvoiceStateMask], 
        [Extent42].[FactorInvoiceStateMask] AS [FactorInvoiceStateMask], 
        [Extent42].[OtherPartyInvoiceStateMask] AS [OtherPartyInvoiceStateMask], 
        [Extent42].[RawSalesInvoiceId] AS [RawSalesInvoiceId], 
        [Extent42].[DiscountSchemeId] AS [DiscountSchemeId], 
        [Extent42].[TransactionNumberSeriesId] AS [TransactionNumberSeriesId], 
        [Extent42].[OwningUserId] AS [OwningUserId], 
        [Extent42].[IsFlipped] AS [IsFlipped], 
        [Extent42].[LastUpdated] AS [LastUpdated], 
        [Extent42].[Version] AS [Version], 
        [Extent42].[SerializationStatus] AS [SerializationStatus], 
        [Extent42].[SerializationError] AS [SerializationError], 
        CAST(NULL AS int) AS [C2], 
        CAST(NULL AS int) AS [C3], 
        CAST(NULL AS int) AS [C4], 
        CAST(NULL AS varchar(1)) AS [C5], 
        CAST(NULL AS datetime2) AS [C6], 
        CAST(NULL AS varbinary(1)) AS [C7], 
        CAST(NULL AS int) AS [C8], 
        CAST(NULL AS int) AS [C9], 
        CAST(NULL AS int) AS [C10], 
        CAST(NULL AS varchar(1)) AS [C11], 
        CAST(NULL AS bit) AS [C12], 
        CAST(NULL AS int) AS [C13], 
        CAST(NULL AS int) AS [C14], 
        CAST(NULL AS datetime2) AS [C15], 
        CAST(NULL AS varbinary(1)) AS [C16], 
        [Extent43].[SIHeadExternalStateId] AS [SIHeadExternalStateId], 
        [Extent43].[SIHeadId] AS [SIHeadId2], 
        [Extent43].[ExternalState] AS [ExternalState], 
        [Extent43].[CompanyAuxId] AS [CompanyAuxId], 
        CAST(NULL AS int) AS [C17], 
        CAST(NULL AS uniqueidentifier) AS [C18], 
        CAST(NULL AS int) AS [C19], 
        CAST(NULL AS datetime2) AS [C20], 
        CAST(NULL AS int) AS [C21], 
        CAST(NULL AS varchar(1)) AS [C22]
        FROM  [dbo].[SIHead] AS [Extent42]
        INNER JOIN [dbo].[SIHeadExternalState] AS [Extent43] ON [Extent42].[SIHeadId] = [Extent43].[SIHeadId]
        WHERE (( EXISTS (SELECT 
            1 AS [C1]
            FROM ( SELECT 
                [Extent45].[RoleId] AS [RoleId]
                FROM  [dbo].[Company] AS [Extent44]
                INNER JOIN [dbo].[RoleCompany] AS [Extent45] ON [Extent44].[CompanyId] = [Extent45].[CompanyId]
                WHERE (( EXISTS (SELECT 
                    1 AS [C1]
                    FROM  [dbo].[User] AS [Extent46]
                    INNER JOIN [dbo].[aspnet_Users] AS [Extent47] ON [Extent46].[UserId] = [Extent47].[UserId]
                    WHERE ([Extent46].[OrganisationId] IS NOT NULL) AND (( EXISTS (SELECT 
                        1 AS [C1]
                        FROM  [dbo].[User] AS [Extent48]
                        INNER JOIN [dbo].[aspnet_Users] AS [Extent49] ON [Extent48].[UserId] = [Extent49].[UserId]
                        WHERE ([Extent46].[OrganisationId] = [Extent48].[OrganisationId]) AND (([Extent49].[UserName] = @DynamicFilterParam_000001) OR (1 = 0))
                    )) ) AND ([Extent44].[OrganisationId] = [Extent46].[OrganisationId]) AND (([Extent47].[UserName] = @DynamicFilterParam_000003) OR (1 = 0))
                )) ) AND ([Extent42].[FactorCompanyId] = [Extent44].[CompanyId])
            )  AS [Project26]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[aspnet_UsersInRoles] AS [Extent50]
                INNER JOIN [dbo].[aspnet_Users] AS [Extent51] ON [Extent50].[UserId] = [Extent51].[UserId]
                WHERE ([Project26].[RoleId] = [Extent50].[RoleId]) AND ([Extent51].[UserName] = @DynamicFilterParam_000005)
            )) AND ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[RolePrivilege] AS [Extent52]
                INNER JOIN [dbo].[Privilege] AS [Extent53] ON [Extent53].[PrivilegeId] = [Extent52].[PrivilegeId]
                WHERE ([Project26].[RoleId] = [Extent52].[RoleId]) AND ([Extent53].[SystemName] = N''Factor View Invoice'')
            ))
        )) OR ( EXISTS (SELECT 
            1 AS [C1]
            FROM ( SELECT 
                [Extent60].[RoleId] AS [RoleId]
                FROM   (SELECT TOP (1) 
                    [Extent54].[CompanyId] AS [CompanyId], 
                    [Extent54].[OrganisationId] AS [OrganisationId], 
                    [Extent55].[CompanyAuxId] AS [CompanyAuxId], 
                    [Extent55].[CompanyId] AS [CompanyId1]
                    FROM  [dbo].[Company] AS [Extent54]
                    INNER JOIN [dbo].[CompanyAux] AS [Extent55] ON [Extent55].[CompanyId] = [Extent54].[CompanyId]
                    WHERE ([Extent42].[ToCompanyId] = [Extent55].[CompanyAuxId]) AND (( EXISTS (SELECT 
                        1 AS [C1]
                        FROM  [dbo].[User] AS [Extent56]
                        INNER JOIN [dbo].[aspnet_Users] AS [Extent57] ON [Extent56].[UserId] = [Extent57].[UserId]
                        WHERE ([Extent56].[OrganisationId] IS NOT NULL) AND (( EXISTS (SELECT 
                            1 AS [C1]
                            FROM  [dbo].[User] AS [Extent58]
                            INNER JOIN [dbo].[aspnet_Users] AS [Extent59] ON [Extent58].[UserId] = [Extent59].[UserId]
                            WHERE ([Extent56].[OrganisationId] = [Extent58].[OrganisationId]) AND (([Extent59].[UserName] = @DynamicFilterParam_000001) OR (1 = 0))
                        )) ) AND ([Extent54].[OrganisationId] = [Extent56].[OrganisationId]) AND (([Extent57].[UserName] = @DynamicFilterParam_000003) OR (1 = 0))
                    )) ) ) AS [Element3]
                INNER JOIN [dbo].[RoleCompany] AS [Extent60] ON [Element3].[CompanyId] = [Extent60].[CompanyId]
            )  AS [Project33]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[aspnet_UsersInRoles] AS [Extent61]
                INNER JOIN [dbo].[aspnet_Users] AS [Extent62] ON [Extent61].[UserId] = [Extent62].[UserId]
                WHERE ([Project33].[RoleId] = [Extent61].[RoleId]) AND ([Extent62].[UserName] = @DynamicFilterParam_000005)
            )) AND ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[RolePrivilege] AS [Extent63]
                INNER JOIN [dbo].[Privilege] AS [Extent64] ON [Extent64].[PrivilegeId] = [Extent63].[PrivilegeId]
                WHERE ([Project33].[RoleId] = [Extent63].[RoleId]) AND ([Extent64].[SystemName] = N''View Invoice'')
            ))
        )) OR ( EXISTS (SELECT 
            1 AS [C1]
            FROM ( SELECT 
                [Extent71].[RoleId] AS [RoleId]
                FROM   (SELECT TOP (1) 
                    [Extent65].[CompanyId] AS [CompanyId], 
                    [Extent65].[OrganisationId] AS [OrganisationId], 
                    [Extent66].[CompanyAuxId] AS [CompanyAuxId], 
                    [Extent66].[CompanyId] AS [CompanyId1]
                    FROM  [dbo].[Company] AS [Extent65]
                    INNER JOIN [dbo].[CompanyAux] AS [Extent66] ON [Extent66].[CompanyId] = [Extent65].[CompanyId]
                    WHERE ([Extent42].[FromCompanyId] = [Extent66].[CompanyAuxId]) AND (( EXISTS (SELECT 
                        1 AS [C1]
                        FROM  [dbo].[User] AS [Extent67]
                        INNER JOIN [dbo].[aspnet_Users] AS [Extent68] ON [Extent67].[UserId] = [Extent68].[UserId]
                        WHERE ([Extent67].[OrganisationId] IS NOT NULL) AND (( EXISTS (SELECT 
                            1 AS [C1]
                            FROM  [dbo].[User] AS [Extent69]
                            INNER JOIN [dbo].[aspnet_Users] AS [Extent70] ON [Extent69].[UserId] = [Extent70].[UserId]
                            WHERE ([Extent67].[OrganisationId] = [Extent69].[OrganisationId]) AND (([Extent70].[UserName] = @DynamicFilterParam_000001) OR (1 = 0))
                        )) ) AND ([Extent65].[OrganisationId] = [Extent67].[OrganisationId]) AND (([Extent68].[UserName] = @DynamicFilterParam_000003) OR (1 = 0))
                    )) ) ) AS [Element4]
                INNER JOIN [dbo].[RoleCompany] AS [Extent71] ON [Element4].[CompanyId] = [Extent71].[CompanyId]
            )  AS [Project40]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[aspnet_UsersInRoles] AS [Extent72]
                INNER JOIN [dbo].[aspnet_Users] AS [Extent73] ON [Extent72].[UserId] = [Extent73].[UserId]
                WHERE ([Project40].[RoleId] = [Extent72].[RoleId]) AND ([Extent73].[UserName] = @DynamicFilterParam_000005)
            )) AND ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[RolePrivilege] AS [Extent74]
                INNER JOIN [dbo].[Privilege] AS [Extent75] ON [Extent75].[PrivilegeId] = [Extent74].[PrivilegeId]
                WHERE ([Project40].[RoleId] = [Extent74].[RoleId]) AND ([Extent75].[SystemName] = N''View Sales Invoice'')
            ))
        )) OR ( EXISTS (SELECT 
            1 AS [C1]
            FROM   [dbo].[SIHeadContact] AS [Extent76]
            INNER JOIN [dbo].[Contact] AS [Extent77] ON [Extent76].[ContactId] = [Extent77].[ContactId]
            LEFT OUTER JOIN  (SELECT [Extent78].[UserName] AS [UserName], [Extent79].[UserId] AS [UserId2]
                FROM  [dbo].[aspnet_Users] AS [Extent78]
                LEFT OUTER JOIN [dbo].[User] AS [Extent79] ON [Extent78].[UserId] = [Extent79].[UserId] ) AS [Join43] ON [Join43].[UserId2] = [Extent77].[UserId]
            WHERE ([Extent42].[SIHeadId] = [Extent76].[SIHeadId]) AND (([Join43].[UserName] = @DynamicFilterParam_000005) OR (([Join43].[UserName] IS NULL) AND (@DynamicFilterParam_000005 IS NULL)))
        )) ) AND ( EXISTS (SELECT 
            1 AS [C1]
            FROM  [dbo].[SIHeadExternalReference] AS [Extent80]
            INNER JOIN [dbo].[ExternalReferenceSystem] AS [Extent81] ON [Extent80].[ExternalReferenceSystemId] = [Extent81].[ExternalReferenceSystemId]
            WHERE ([Extent42].[SIHeadId] = [Extent80].[SIHeadId]) AND ([Extent81].[DisplayName] + N''|'' + [Extent80].[Reference] IN (N''FCS|5100020371FR012017'', N''FCS|5100020940FR012017'', 
N''FCS|5100027630FR012017'', N''FCS|5100019451FR012017'', N''FCS|5100020115FR012017'', N''FCS|5100020118FR012017'', N''FCS|5100021016FR012017'', N''FCS|5100024827FR012017'', 
N''FCS|5100026457FR012017'', N''FCS|5100020120FR012017'', N''FCS|5100022743FR012017'', N''FCS|5100022744FR012017'', N''FCS|5100022702FR012017'', N''FCS|5100022703FR012017'', 
N''FCS|5100022704FR012017'', N''FCS|5100022735FR012017'', N''FCS|5100022736FR012017'', N''FCS|5100024026FR012017'', N''FCS|5100024395FR012017'', N''FCS|5100024615FR012017'', 
N''FCS|5100024899FR012017'', N''FCS|5100024971FR012017'', N''FCS|5100025219FR012017'', N''FCS|5100026161FR012017'', N''FCS|5100028517FR012017'', N''FCS|5100028882FR012017'', 
N''FCS|5100024399FR012017'', N''FCS|5100024293FR012017'', N''FCS|5100024408FR012017'', N''FCS|5100024501FR012017'', N''FCS|5100024622FR012017'', N''FCS|5100025317FR012017'', 
N''FCS|5100028461FR012017'', N''FCS|5100024256FR012017'', N''FCS|5100024294FR012017'', N''FCS|5100025547FR012017'', N''FCS|5100028462FR012017'', N''FCS|5100028454FR012017'', 
N''FCS|5100028455FR012017'', N''FCS|5100028456FR012017'', N''FCS|5100028465FR012017'', N''FCS|5100028452FR012017'', N''FCS|5100029430FR012017'', N''FCS|5100028463FR012017'', 
N''FCS|5100028464FR012017'', N''FCS|5100028473FR012017'', N''FCS|5100029343FR012017'', N''FCS|5100029594FR012017'', N''FCS|5100028449FR012017'', N''FCS|5100028450FR012017'', 
N''FCS|5100028457FR012017'', N''FCS|5100028468FR012017'', N''FCS|5100028520FR012017'', N''FCS|5100028528FR012017'', N''FCS|5100028530FR012017'', N''FCS|5100028531FR012017'', 
N''FCS|5100028645FR012017'', N''FCS|5100029458FR012017'', N''FCS|5100029376FR012017'', N''FCS|5100031929FR012017'', N''FCS|5100030518FR012017'', N''FCS|5100030519FR012017'', 
N''FCS|5100030520FR012017'', N''FCS|5100030521FR012017'', N''FCS|5100030522FR012017'', N''FCS|5100030582FR012017'', N''FCS|5100030602FR012017'', N''FCS|5100031953FR012017'', N''FCS|5100031955FR012017'', N''FCS|5100030517FR012017'', N''FCS|5100030523FR012017'', N''FCS|5100030524FR012017'', N''FCS|5100030525FR012017'', N''FCS|5100030607FR012017'', N''FCS|2800008446FR012017'', N''FCS|2800008447FR012017'', N''FCS|2800008448FR012017'', N''FCS|2800008449FR012017'', N''FCS|2800008450FR012017'', N''FCS|2800008451FR012017'', N''FCS|2800008452FR012017'', N''FCS|2800008453FR012017'', N''FCS|2800008454FR012017'', N''FCS|2800008455FR012017'', N''FCS|2800008456FR012017'', N''FCS|2800008457FR012017'', N''FCS|2800008458FR012017'', N''FCS|2800008459FR012017'', N''FCS|2800008460FR012017'', N''FCS|2800008461FR012017'', N''FCS|2800008568FR012017'', N''FCS|2800008569FR012017'', N''FCS|2800008570FR012017'', N''FCS|2800008571FR012017'', N''FCS|2800008572FR012017'', N''FCS|2800008578FR012017'', N''FCS|2800008584FR012017'', N''FCS|2800008586FR012017'', N''FCS|2800008588FR012017'', N''FCS|2800008593FR012017'', N''FCS|2800009022FR012017'', N''FCS|2800009114FR012017'', N''FCS|2800009115FR012017'', N''FCS|2800009116FR012017'', N''FCS|2800009117FR012017'', N''FCS|2800009118FR012017'', N''FCS|5100030145FR012017'', N''FCS|5100018813FR012017'', N''FCS|5100021839FR012017'', N''FCS|5100022034FR012017'', N''FCS|5100022035FR012017'', N''FCS|5100022461FR012017'', N''FCS|5100024303FR012017'', N''FCS|5100024838FR012017'', N''FCS|5100025482FR012017'', N''FCS|5100027951FR012017'', N''FCS|5100028602FR012017'', N''FCS|5100029422FR012017'', N''FCS|5100029478FR012017'', N''FCS|5100029479FR012017'', N''FCS|5100029480FR012017'', N''FCS|5100029481FR012017'', N''FCS|5100029482FR012017'', N''FCS|5100029483FR012017'', N''FCS|5100029484FR012017'', N''FCS|5100029488FR012017'', N''FCS|5100031927FR012017'', N''FCS|1000003249FR012017'')) AND ([Extent81].[DisplayName] + N''|'' + [Extent80].[Reference] IS NOT NULL)
        ))
    UNION ALL
        SELECT 
        3 AS [C1], 
        [Extent82].[SIHeadId] AS [SIHeadId], 
        [Extent82].[SIHeadId] AS [SIHeadId1], 
        [Extent82].[InvoiceTypeId] AS [InvoiceTypeId], 
        [Extent82].[InvoiceNumber] AS [InvoiceNumber], 
        [Extent82].[CreationDate] AS [CreationDate], 
        [Extent82].[DeliveryDate] AS [DeliveryDate], 
        [Extent82].[ReceivedDate] AS [ReceivedDate], 
        [Extent82].[CaptureDate] AS [CaptureDate], 
        [Extent82].[BuyerGLDate] AS [BuyerGLDate], 
        [Extent82].[SupplierGLDate] AS [SupplierGLDate], 
        [Extent82].[TaxPoint] AS [TaxPoint], 
        [Extent82].[DueDate] AS [DueDate], 
        [Extent82].[AgreedDiscountPaymentDate] AS [AgreedDiscountPaymentDate], 
        [Extent82].[CurrencyCode] AS [CurrencyCode], 
        [Extent82].[TotalBeforeTax] AS [TotalBeforeTax], 
        [Extent82].[TotalTax] AS [TotalTax], 
        [Extent82].[TotalIncludingTax] AS [TotalIncludingTax], 
        [Extent82].[Comment] AS [Comment], 
        [Extent82].[FromCompanyId] AS [FromCompanyId], 
        [Extent82].[ToCompanyId] AS [ToCompanyId], 
        [Extent82].[FactorCompanyId] AS [FactorCompanyId], 
        [Extent82].[PayeeAuxId] AS [PayeeAuxId], 
        [Extent82].[BuyerInvoiceStateMask] AS [BuyerInvoiceStateMask], 
        [Extent82].[SupplierInvoiceStateMask] AS [SupplierInvoiceStateMask], 
        [Extent82].[FactorInvoiceStateMask] AS [FactorInvoiceStateMask], 
        [Extent82].[OtherPartyInvoiceStateMask] AS [OtherPartyInvoiceStateMask], 
        [Extent82].[RawSalesInvoiceId] AS [RawSalesInvoiceId], 
        [Extent82].[DiscountSchemeId] AS [DiscountSchemeId], 
        [Extent82].[TransactionNumberSeriesId] AS [TransactionNumberSeriesId], 
        [Extent82].[OwningUserId] AS [OwningUserId], 
        [Extent82].[IsFlipped] AS [IsFlipped], 
        [Extent82].[LastUpdated] AS [LastUpdated], 
        [Extent82].[Version] AS [Version], 
        [Extent82].[SerializationStatus] AS [SerializationStatus], 
        [Extent82].[SerializationError] AS [SerializationError], 
        CAST(NULL AS int) AS [C2], 
        CAST(NULL AS int) AS [C3], 
        CAST(NULL AS int) AS [C4], 
        CAST(NULL AS varchar(1)) AS [C5], 
        CAST(NULL AS datetime2) AS [C6], 
        CAST(NULL AS varbinary(1)) AS [C7], 
        CAST(NULL AS int) AS [C8], 
        CAST(NULL AS int) AS [C9], 
        CAST(NULL AS int) AS [C10], 
        CAST(NULL AS varchar(1)) AS [C11], 
        CAST(NULL AS bit) AS [C12], 
        CAST(NULL AS int) AS [C13], 
        CAST(NULL AS int) AS [C14], 
        CAST(NULL AS datetime2) AS [C15], 
        CAST(NULL AS varbinary(1)) AS [C16], 
        CAST(NULL AS int) AS [C17], 
        CAST(NULL AS int) AS [C18], 
        CAST(NULL AS varchar(1)) AS [C19], 
        CAST(NULL AS int) AS [C20], 
        [Join46].[UserActionLogId1] AS [UserActionLogId], 
        [Join46].[UserId] AS [UserId], 
        [Join46].[ActionTypeId] AS [ActionTypeId], 
        [Join46].[DateTime] AS [DateTime], 
        [Join46].[NotificationEventId] AS [NotificationEventId], 
        [Join46].[Comment] AS [Comment1]
        FROM  [dbo].[SIHead] AS [Extent82]
        INNER JOIN  (SELECT [Extent83].[SIHeadId] AS [SIHeadId], [Extent84].[UserActionLogId] AS [UserActionLogId1], [Extent84].[UserId] AS [UserId], [Extent84].[ActionTypeId] AS [ActionTypeId], [Extent84].[DateTime] AS [DateTime], [Extent84].[NotificationEventId] AS [NotificationEventId], [Extent84].[Comment] AS [Comment]
            FROM  [dbo].[SIHeadActionLog] AS [Extent83]
            INNER JOIN [dbo].[UserActionLog] AS [Extent84] ON [Extent84].[UserActionLogId] = [Extent83].[UserActionLogId] ) AS [Join46] ON [Extent82].[SIHeadId] = [Join46].[SIHeadId]
        WHERE (( EXISTS (SELECT 
            1 AS [C1]
            FROM ( SELECT 
                [Extent86].[RoleId] AS [RoleId]
                FROM  [dbo].[Company] AS [Extent85]
                INNER JOIN [dbo].[RoleCompany] AS [Extent86] ON [Extent85].[CompanyId] = [Extent86].[CompanyId]
                WHERE (( EXISTS (SELECT 
                    1 AS [C1]
                    FROM  [dbo].[User] AS [Extent87]
                    INNER JOIN [dbo].[aspnet_Users] AS [Extent88] ON [Extent87].[UserId] = [Extent88].[UserId]
                    WHERE ([Extent87].[OrganisationId] IS NOT NULL) AND (( EXISTS (SELECT 
                        1 AS [C1]
                        FROM  [dbo].[User] AS [Extent89]
                        INNER JOIN [dbo].[aspnet_Users] AS [Extent90] ON [Extent89].[UserId] = [Extent90].[UserId]
                        WHERE ([Extent87].[OrganisationId] = [Extent89].[OrganisationId]) AND (([Extent90].[UserName] = @DynamicFilterParam_000001) OR (1 = 0))
                    )) ) AND ([Extent85].[OrganisationId] = [Extent87].[OrganisationId]) AND (([Extent88].[UserName] = @DynamicFilterParam_000003) OR (1 = 0))
                )) ) AND ([Extent82].[FactorCompanyId] = [Extent85].[CompanyId])
            )  AS [Project49]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[aspnet_UsersInRoles] AS [Extent91]
                INNER JOIN [dbo].[aspnet_Users] AS [Extent92] ON [Extent91].[UserId] = [Extent92].[UserId]
                WHERE ([Project49].[RoleId] = [Extent91].[RoleId]) AND ([Extent92].[UserName] = @DynamicFilterParam_000005)
            )) AND ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[RolePrivilege] AS [Extent93]
                INNER JOIN [dbo].[Privilege] AS [Extent94] ON [Extent94].[PrivilegeId] = [Extent93].[PrivilegeId]
                WHERE ([Project49].[RoleId] = [Extent93].[RoleId]) AND ([Extent94].[SystemName] = N''Factor View Invoice'')
            ))
        )) OR ( EXISTS (SELECT 
            1 AS [C1]
            FROM ( SELECT 
                [Extent101].[RoleId] AS [RoleId]
                FROM   (SELECT TOP (1) 
                    [Extent95].[CompanyId] AS [CompanyId], 
                    [Extent95].[OrganisationId] AS [OrganisationId], 
                    [Extent96].[CompanyAuxId] AS [CompanyAuxId], 
                    [Extent96].[CompanyId] AS [CompanyId1]
                    FROM  [dbo].[Company] AS [Extent95]
                    INNER JOIN [dbo].[CompanyAux] AS [Extent96] ON [Extent96].[CompanyId] = [Extent95].[CompanyId]
                    WHERE ([Extent82].[ToCompanyId] = [Extent96].[CompanyAuxId]) AND (( EXISTS (SELECT 
                        1 AS [C1]
                        FROM  [dbo].[User] AS [Extent97]
                        INNER JOIN [dbo].[aspnet_Users] AS [Extent98] ON [Extent97].[UserId] = [Extent98].[UserId]
                        WHERE ([Extent97].[OrganisationId] IS NOT NULL) AND (( EXISTS (SELECT 
                            1 AS [C1]
                            FROM  [dbo].[User] AS [Extent99]
                            INNER JOIN [dbo].[aspnet_Users] AS [Extent100] ON [Extent99].[UserId] = [Extent100].[UserId]
                            WHERE ([Extent97].[OrganisationId] = [Extent99].[OrganisationId]) AND (([Extent100].[UserName] = @DynamicFilterParam_000001) OR (1 = 0))
                        )) ) AND ([Extent95].[OrganisationId] = [Extent97].[OrganisationId]) AND (([Extent98].[UserName] = @DynamicFilterParam_000003) OR (1 = 0))
                    )) ) ) AS [Element5]
                INNER JOIN [dbo].[RoleCompany] AS [Extent101] ON [Element5].[CompanyId] = [Extent101].[CompanyId]
            )  AS [Project56]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[aspnet_UsersInRoles] AS [Extent102]
                INNER JOIN [dbo].[aspnet_Users] AS [Extent103] ON [Extent102].[UserId] = [Extent103].[UserId]
                WHERE ([Project56].[RoleId] = [Extent102].[RoleId]) AND ([Extent103].[UserName] = @DynamicFilterParam_000005)
            )) AND ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[RolePrivilege] AS [Extent104]
                INNER JOIN [dbo].[Privilege] AS [Extent105] ON [Extent105].[PrivilegeId] = [Extent104].[PrivilegeId]
                WHERE ([Project56].[RoleId] = [Extent104].[RoleId]) AND ([Extent105].[SystemName] = N''View Invoice'')
            ))
        )) OR ( EXISTS (SELECT 
            1 AS [C1]
            FROM ( SELECT 
                [Extent112].[RoleId] AS [RoleId]
                FROM   (SELECT TOP (1) 
                    [Extent106].[CompanyId] AS [CompanyId], 
                    [Extent106].[OrganisationId] AS [OrganisationId], 
                    [Extent107].[CompanyAuxId] AS [CompanyAuxId], 
                    [Extent107].[CompanyId] AS [CompanyId1]
                    FROM  [dbo].[Company] AS [Extent106]
                    INNER JOIN [dbo].[CompanyAux] AS [Extent107] ON [Extent107].[CompanyId] = [Extent106].[CompanyId]
                    WHERE ([Extent82].[FromCompanyId] = [Extent107].[CompanyAuxId]) AND (( EXISTS (SELECT 
                        1 AS [C1]
                        FROM  [dbo].[User] AS [Extent108]
                        INNER JOIN [dbo].[aspnet_Users] AS [Extent109] ON [Extent108].[UserId] = [Extent109].[UserId]
                        WHERE ([Extent108].[OrganisationId] IS NOT NULL) AND (( EXISTS (SELECT 
                            1 AS [C1]
                            FROM  [dbo].[User] AS [Extent110]
                            INNER JOIN [dbo].[aspnet_Users] AS [Extent111] ON [Extent110].[UserId] = [Extent111].[UserId]
                            WHERE ([Extent108].[OrganisationId] = [Extent110].[OrganisationId]) AND (([Extent111].[UserName] = @DynamicFilterParam_000001) OR (1 = 0))
                        )) ) AND ([Extent106].[OrganisationId] = [Extent108].[OrganisationId]) AND (([Extent109].[UserName] = @DynamicFilterParam_000003) OR (1 = 0))
                    )) ) ) AS [Element6]
                INNER JOIN [dbo].[RoleCompany] AS [Extent112] ON [Element6].[CompanyId] = [Extent112].[CompanyId]
            )  AS [Project63]
            WHERE ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[aspnet_UsersInRoles] AS [Extent113]
                INNER JOIN [dbo].[aspnet_Users] AS [Extent114] ON [Extent113].[UserId] = [Extent114].[UserId]
                WHERE ([Project63].[RoleId] = [Extent113].[RoleId]) AND ([Extent114].[UserName] = @DynamicFilterParam_000005)
            )) AND ( EXISTS (SELECT 
                1 AS [C1]
                FROM  [dbo].[RolePrivilege] AS [Extent115]
                INNER JOIN [dbo].[Privilege] AS [Extent116] ON [Extent116].[PrivilegeId] = [Extent115].[PrivilegeId]
                WHERE ([Project63].[RoleId] = [Extent115].[RoleId]) AND ([Extent116].[SystemName] = N''View Sales Invoice'')
            ))
        )) OR ( EXISTS (SELECT 
            1 AS [C1]
            FROM   [dbo].[SIHeadContact] AS [Extent117]
            INNER JOIN [dbo].[Contact] AS [Extent118] ON [Extent117].[ContactId] = [Extent118].[ContactId]
            LEFT OUTER JOIN  (SELECT [Extent119].[UserName] AS [UserName], [Extent120].[UserId] AS [UserId3]
                FROM  [dbo].[aspnet_Users] AS [Extent119]
                LEFT OUTER JOIN [dbo].[User] AS [Extent120] ON [Extent119].[UserId] = [Extent120].[UserId] ) AS [Join66] ON [Join66].[UserId3] = [Extent118].[UserId]
            WHERE ([Extent82].[SIHeadId] = [Extent117].[SIHeadId]) AND (([Join66].[UserName] = @DynamicFilterParam_000005) OR (([Join66].[UserName] IS NULL) AND (@DynamicFilterParam_000005 IS NULL)))
        )) ) AND ( EXISTS (SELECT 
            1 AS [C1]
            FROM  [dbo].[SIHeadExternalReference] AS [Extent121]
            INNER JOIN [dbo].[ExternalReferenceSystem] AS [Extent122] ON [Extent121].[ExternalReferenceSystemId] = [Extent122].[ExternalReferenceSystemId]
            WHERE ([Extent82].[SIHeadId] = [Extent121].[SIHeadId]) AND ([Extent122].[DisplayName] + N''|'' + [Extent121].[Reference] IN (N''FCS|5100020371FR012017'', N''FCS|5100020940FR012017'', 
N''FCS|5100027630FR012017'', N''FCS|5100019451FR012017'', N''FCS|5100020115FR012017'', N''FCS|5100020118FR012017'', N''FCS|5100021016FR012017'', N''FCS|5100024827FR012017'', 
N''FCS|5100026457FR012017'', N''FCS|5100020120FR012017'', N''FCS|5100022743FR012017'', N''FCS|5100022744FR012017'', N''FCS|5100022702FR012017'', N''FCS|5100022703FR012017'', 
N''FCS|5100022704FR012017'', N''FCS|5100022735FR012017'', N''FCS|5100022736FR012017'', N''FCS|5100024026FR012017'', N''FCS|5100024395FR012017'', N''FCS|5100024615FR012017'', 
N''FCS|5100024899FR012017'', N''FCS|5100024971FR012017'', N''FCS|5100025219FR012017'', N''FCS|5100026161FR012017'', N''FCS|5100028517FR012017'', N''FCS|5100028882FR012017'', 
N''FCS|5100024399FR012017'', N''FCS|5100024293FR012017'', N''FCS|5100024408FR012017'', N''FCS|5100024501FR012017'', N''FCS|5100024622FR012017'', N''FCS|5100025317FR012017'', 
N''FCS|5100028461FR012017'', N''FCS|5100024256FR012017'', N''FCS|5100024294FR012017'', N''FCS|5100025547FR012017'', N''FCS|5100028462FR012017'', N''FCS|5100028454FR012017'', 
N''FCS|5100028455FR012017'', N''FCS|5100028456FR012017'', N''FCS|5100028465FR012017'', N''FCS|5100028452FR012017'', N''FCS|5100029430FR012017'', N''FCS|5100028463FR012017'', 
N''FCS|5100028464FR012017'', N''FCS|5100028473FR012017'', N''FCS|5100029343FR012017'', N''FCS|5100029594FR012017'', N''FCS|5100028449FR012017'', N''FCS|5100028450FR012017'', 
N''FCS|5100028457FR012017'', N''FCS|5100028468FR012017'', N''FCS|5100028520FR012017'', N''FCS|5100028528FR012017'', N''FCS|5100028530FR012017'', N''FCS|5100028531FR012017'', 
N''FCS|5100028645FR012017'', N''FCS|5100029458FR012017'', N''FCS|5100029376FR012017'', N''FCS|5100031929FR012017'', N''FCS|5100030518FR012017'', N''FCS|5100030519FR012017'', 
N''FCS|5100030520FR012017'', N''FCS|5100030521FR012017'', N''FCS|5100030522FR012017'', N''FCS|5100030582FR012017'', N''FCS|5100030602FR012017'', N''FCS|5100031953FR012017'', N''FCS|5100031955FR012017'', N''FCS|5100030517FR012017'', N''FCS|5100030523FR012017'', N''FCS|5100030524FR012017'', N''FCS|5100030525FR012017'', N''FCS|5100030607FR012017'', N''FCS|2800008446FR012017'', N''FCS|2800008447FR012017'', N''FCS|2800008448FR012017'', N''FCS|2800008449FR012017'', N''FCS|2800008450FR012017'', N''FCS|2800008451FR012017'', N''FCS|2800008452FR012017'', N''FCS|2800008453FR012017'', N''FCS|2800008454FR012017'', N''FCS|2800008455FR012017'', N''FCS|2800008456FR012017'', N''FCS|2800008457FR012017'', N''FCS|2800008458FR012017'', N''FCS|2800008459FR012017'', N''FCS|2800008460FR012017'', N''FCS|2800008461FR012017'', N''FCS|2800008568FR012017'', N''FCS|2800008569FR012017'', 
N''FCS|2800008570FR012017'', N''FCS|2800008571FR012017'', N''FCS|2800008572FR012017'', N''FCS|2800008578FR012017'', N''FCS|2800008584FR012017'', N''FCS|2800008586FR012017'', N''FCS|2800008588FR012017'', N''FCS|2800008593FR012017'', N''FCS|2800009022FR012017'', N''FCS|2800009114FR012017'', N''FCS|2800009115FR012017'', N''FCS|2800009116FR012017'', N''FCS|2800009117FR012017'', N''FCS|2800009118FR012017'', N''FCS|5100030145FR012017'', N''FCS|5100018813FR012017'', N''FCS|5100021839FR012017'', N''FCS|5100022034FR012017'', N''FCS|5100022035FR012017'', N''FCS|5100022461FR012017'', N''FCS|5100024303FR012017'', N''FCS|5100024838FR012017'', N''FCS|5100025482FR012017'', N''FCS|5100027951FR012017'', N''FCS|5100028602FR012017'', N''FCS|5100029422FR012017'', N''FCS|5100029478FR012017'', N''FCS|5100029479FR012017'', N''FCS|5100029480FR012017'', N''FCS|5100029481FR012017'', N''FCS|5100029482FR012017'', N''FCS|5100029483FR012017'', N''FCS|5100029484FR012017'', N''FCS|5100029488FR012017'', N''FCS|5100031927FR012017'', N''FCS|1000003249FR012017'')) AND ([Extent122].[DisplayName] + N''|'' + [Extent121].[Reference] IS NOT NULL)
        ))) AS [UnionAll2]
    ORDER BY [UnionAll2].[SIHeadId1] ASC, [UnionAll2].[C1] ASC',N'@DynamicFilterParam_000001 nvarchar(4000),@DynamicFilterParam_000002 bit,@DynamicFilterParam_000003 nvarchar(4000),@DynamicFilterParam_000004 bit,@DynamicFilterParam_000005 nvarchar(4000),@DynamicFilterParam_000006 bit',@DynamicFilterParam_000001=N'Faurecia.Admin@test.null',@DynamicFilterParam_000002=NULL,@DynamicFilterParam_000003=N'Faurecia.Admin@test.null',@DynamicFilterParam_000004=NULL,@DynamicFilterParam_000005=N'Faurecia.Admin@test.null',@DynamicFilterParam_000006=NULL