SELECT TOP (50) ISNULL("Customer"."timestamp",@0) AS "timestamp",ISNULL("Customer"."No_",@1) AS "No_",ISNULL("Customer"."Name",@2) AS "Name",ISNULL("Customer"."Search Name",@1) AS "Search Name",ISNULL("Customer"."Name 2",@2) AS "Name 2",ISNULL("Customer"."Address",@2) AS "Address",ISNULL("Customer"."Address 2",@2) AS "Address 2",ISNULL("Customer"."City",@2) AS "City",ISNULL("Customer"."Contact",@2) AS "Contact",ISNULL("Customer"."Phone No_",@2) AS "Phone No_",ISNULL("Customer"."Telex No_",@2) AS "Telex No_",ISNULL("Customer"."Document Sending Profile",@1) AS "Document Sending Profile",ISNULL("Customer"."Our Account No_",@2) AS "Our Account No_",ISNULL("Customer"."Territory Code",@1) AS "Territory Code",ISNULL("Customer"."Global Dimension 1 Code",@1) AS "Global Dimension 1 Code",ISNULL("Customer"."Global Dimension 2 Code",@1) AS "Global Dimension 2 Code",ISNULL("Customer"."Chain Name",@1) AS "Chain Name",ISNULL("Customer"."Budgeted Amount",@3) AS "Budgeted Amount",ISNULL("Customer"."Credit Limit (LCY)",@3) AS "Credit Limit (LCY)",ISNULL("Customer"."Customer Posting Group",@1) AS "Customer Posting Group",ISNULL("Customer"."Currency Code",@1) AS "Currency Code",ISNULL("Customer"."Customer Price Group",@1) AS "Customer Price Group",ISNULL("Customer"."Language Code",@1) AS "Language Code",ISNULL("Customer"."Statistics Group",@4) AS "Statistics Group",ISNULL("Customer"."Payment Terms Code",@1) AS "Payment Terms Code",ISNULL("Customer"."Fin_ Charge Terms Code",@1) AS "Fin_ Charge Terms Code",ISNULL("Customer"."Salesperson Code",@1) AS "Salesperson Code",ISNULL("Customer"."Shipment Method Code",@1) AS "Shipment Method Code",ISNULL("Customer"."Shipping Agent Code",@1) AS "Shipping Agent Code",ISNULL("Customer"."Place of Export",@1) AS "Place of Export",ISNULL("Customer"."Invoice Disc_ Code",@1) AS "Invoice Disc_ Code",ISNULL("Customer"."Customer Disc_ Group",@1) AS "Customer Disc_ Group",ISNULL("Customer"."Country_Region Code",@1) AS "Country_Region Code",ISNULL("Customer"."Collection Method",@1) AS "Collection Method",ISNULL("Customer"."Amount",@3) AS "Amount",ISNULL("Customer"."Blocked",@5) AS "Blocked",ISNULL("Customer"."Invoice Copies",@4) AS "Invoice Copies",ISNULL("Customer"."Last Statement No_",@4) AS "Last Statement No_",ISNULL("Customer"."Print Statements",@6) AS "Print Statements",ISNULL("Customer"."Bill-to Customer No_",@1) AS "Bill-to Customer No_",ISNULL("Customer"."Priority",@4) AS "Priority",ISNULL("Customer"."Payment Method Code",@1) AS "Payment Method Code",ISNULL("Customer"."Last Date Modified",@7) AS "Last Date Modified",ISNULL("Customer"."Application Method",@5) AS "Application Method",ISNULL("Customer"."Prices Including VAT",@6) AS "Prices Including VAT",ISNULL("Customer"."Location Code",@1) AS "Location Code",ISNULL("Customer"."Fax No_",@2) AS "Fax No_",ISNULL("Customer"."Telex Answer Back",@2) AS "Telex Answer Back",ISNULL("Customer"."VAT Registration No_",@2) AS "VAT Registration No_",ISNULL("Customer"."Combine Shipments",@6) AS "Combine Shipments",ISNULL("Customer"."Gen_ Bus_ Posting Group",@1) AS "Gen_ Bus_ Posting Group",DATALENGTH("Customer"."Picture") AS "Picture",ISNULL("Customer"."GLN",@1) AS "GLN",ISNULL("Customer"."Post Code",@1) AS "Post Code",ISNULL("Customer"."County",@2) AS "County",ISNULL("Customer"."E-Mail",@2) AS "E-Mail",ISNULL("Customer"."Home Page",@2) AS "Home Page",ISNULL("Customer"."Reminder Terms Code",@1) AS "Reminder Terms Code",ISNULL("Customer"."No_ Series",@1) AS "No_ Series",ISNULL("Customer"."Tax Area Code",@1) AS "Tax Area Code",ISNULL("Customer"."Tax Liable",@6) AS "Tax Liable",ISNULL("Customer"."VAT Bus_ Posting Group",@1) AS "VAT Bus_ Posting Group",ISNULL("Customer"."Reserve",@5) AS "Reserve",ISNULL("Customer"."Block Payment Tolerance",@6) AS "Block Payment Tolerance",ISNULL("Customer"."IC Partner Code",@1) AS "IC Partner Code",ISNULL("Customer"."Prepayment _",@3) AS "Prepayment _",ISNULL("Customer"."Partner Type",@5) AS "Partner Type",ISNULL("Customer"."Image",@8) AS "Image",ISNULL("Customer"."Preferred Bank Account Code",@1) AS "Preferred Bank Account Code",ISNULL("Customer"."Cash Flow Payment Terms Code",@1) AS "Cash Flow Payment Terms Code",ISNULL("Customer"."Primary Contact No_",@1) AS "Primary Contact No_",ISNULL("Customer"."Responsibility Center",@1) AS "Responsibility Center",ISNULL("Customer"."Shipping Advice",@5) AS "Shipping Advice",ISNULL("Customer"."Shipping Time",@9) AS "Shipping Time",ISNULL("Customer"."Shipping Agent Service Code",@1) AS "Shipping Agent Service Code",ISNULL("Customer"."Service Zone Code",@1) AS "Service Zone Code",ISNULL("Customer"."Allow Line Disc_",@6) AS "Allow Line Disc_",ISNULL("Customer"."Base Calendar Code",@1) AS "Base Calendar Code",ISNULL("Customer"."Copy Sell-to Addr_ to Qte From",@5) AS "Copy Sell-to Addr_ to Qte From",ISNULL("Customer"."Enterprise No_",@2) AS "Enterprise No_",ISNULL("Customer"."Quality",@2) AS "Quality",ISNULL("Customer"."Material Usage _",@3) AS "Material Usage _",ISNULL("Customer"."Price Increase _",@3) AS "Price Increase _",ISNULL("Customer"."Min_ Margin _",@3) AS "Min_ Margin _",ISNULL("Customer"."Prop_ Maint_ Coordinator",@1) AS "Prop_ Maint_ Coordinator",ISNULL("Customer"."District Manager",@1) AS "District Manager",ISNULL("Customer"."Pay Scale Area",@1) AS "Pay Scale Area",ISNULL("Customer"."Calendar Code",@1) AS "Calendar Code",ISNULL("Customer"."Region Code",@1) AS "Region Code",ISNULL("Customer"."Alt_ Address X",@2) AS "Alt_ Address X",ISNULL("Customer"."Alt_ Address Y",@2) AS "Alt_ Address Y",ISNULL("Customer"."Modified by",@1) AS "Modified by",ISNULL("Customer"."Modified on",@7) AS "Modified on",ISNULL("Customer"."Customer Status",@5) AS "Customer Status",ISNULL("Customer"."VAT Obliged",@6) AS "VAT Obliged",ISNULL("Customer"."Intercompany",@2) AS "Intercompany",ISNULL("Customer"."Collective Invoice No_",@1) AS "Collective Invoice No_",ISNULL("Customer"."Customer Group",@1) AS "Customer Group",ISNULL("Customer"."Customer Size",@1) AS "Customer Size",ISNULL("Customer"."Gov_ Company ID",@4) AS "Gov_ Company ID",ISNULL("Customer"."Different reminder recipient",@6) AS "Different reminder recipient",ISNULL("Customer"."Domiciliation No_",@2) AS "Domiciliation No_",ISNULL("SUB$Comment"."Comment$Comment Line$EXISTS",@0) AS "Comment",ISNULL("SUB$Balance"."Balance$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Balance",ISNULL("SUB$Balance (LCY)"."Balance (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Balance (LCY)",ISNULL("SUB$Net Change"."Net Change$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Net Change",ISNULL("SUB$Net Change (LCY)"."Net Change (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Net Change (LCY)",ISNULL("SUB$Sales (LCY)"."Sales (LCY)$Cust_ Ledger Entry$SUM$Sales (LCY)",@3) AS "Sales (LCY)",ISNULL("SUB$Profit (LCY)"."Profit (LCY)$Cust_ Ledger Entry$SUM$Profit (LCY)",@3) AS "Profit (LCY)",ISNULL("SUB$Inv_ Discounts (LCY)"."Inv_ Discounts (LCY)$Cust_ Ledger Entry$SUM$Inv_ Discount (LCY)",@3) AS "Inv_ Discounts (LCY)",-ISNULL("SUB$Pmt_ Discounts (LCY)"."Pmt_ Discounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Pmt_ Discounts (LCY)",ISNULL("SUB$Balance Due"."Balance Due$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Balance Due",ISNULL("SUB$Balance Due (LCY)"."Balance Due (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Balance Due (LCY)",-ISNULL("SUB$Payments"."Payments$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Payments",ISNULL("SUB$Invoice Amounts"."Invoice Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Invoice Amounts",-ISNULL("SUB$Cr_ Memo Amounts"."Cr_ Memo Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Cr_ Memo Amounts",ISNULL("SUB$Finance Charge Memo Amounts"."Finance Charge Memo Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Finance Charge Memo Amounts",-ISNULL("SUB$Payments (LCY)"."Payments (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Payments (LCY)",ISNULL("SUB$Inv_ Amounts (LCY)"."Inv_ Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Inv_ Amounts (LCY)",-ISNULL("SUB$Cr_ Memo Amounts (LCY)"."Cr_ Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Cr_ Memo Amounts (LCY)",ISNULL("SUB$Fin_ Charge Memo Amounts (LCY)"."Fin_ Charge Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Fin_ Charge Memo Amounts (LCY)",ISNULL("SUB$Debit Amount"."Debit Amount$Detailed Cust_ Ledg_ Entry$SUM$Debit Amount",@3) AS "Debit Amount",ISNULL("SUB$Credit Amount"."Credit Amount$Detailed Cust_ Ledg_ Entry$SUM$Credit Amount",@3) AS "Credit Amount",ISNULL("SUB$Debit Amount (LCY)"."Debit Amount (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Debit Amount (LCY)",@3) AS "Debit Amount (LCY)",ISNULL("SUB$Credit Amount (LCY)"."Credit Amount (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Credit Amount (LCY)",@3) AS "Credit Amount (LCY)",ISNULL("SUB$Reminder Amounts"."Reminder Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Reminder Amounts",ISNULL("SUB$Reminder Amounts (LCY)"."Reminder Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Reminder Amounts (LCY)",-ISNULL("SUB$Pmt_ Disc_ Tolerance (LCY)"."Pmt_ Disc_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Pmt_ Disc_ Tolerance (LCY)",-ISNULL("SUB$Pmt_ Tolerance (LCY)"."Pmt_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Pmt_ Tolerance (LCY)",ISNULL("SUB$Refunds"."Refunds$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Refunds",ISNULL("SUB$Refunds (LCY)"."Refunds (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Refunds (LCY)",ISNULL("SUB$Other Amounts"."Other Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount",@3) AS "Other Amounts",ISNULL("SUB$Other Amounts (LCY)"."Other Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)",@3) AS "Other Amounts (LCY)","SUB$Bill-to No_ Of Archived Doc_"."$CNT" AS "Bill-to No_ Of Archived Doc_","SUB$Sell-to No_ Of Archived Doc_"."$CNT" AS "Sell-to No_ Of Archived Doc_",ISNULL("SUB$Contract Gain_Loss Amount"."Contract Gain_Loss Amount$Contract Gain_Loss Entry$SUM$Amount",@3) AS "Contract Gain_Loss Amount",ISNULL("SUB$Outstanding Serv_ Orders (LCY)"."Outstanding Serv_ Orders (LCY)$Service Line$SUM$Outstanding Amount (LCY)",@3) AS "Outstanding Serv_ Orders (LCY)",ISNULL("SUB$Serv Shipped Not Invoiced(LCY)"."Serv Shipped Not Invoiced(LCY)$Service Line$SUM$Shipped Not Invoiced (LCY)",@3) AS "Serv Shipped Not Invoiced(LCY)",ISNULL("SUB$Outstanding Serv_Invoices(LCY)"."Outstanding Serv_Invoices(LCY)$Service Line$SUM$Outstanding Amount (LCY)",@3) AS "Outstanding Serv_Invoices(LCY)","SUB$No_ of Quotes"."$CNT" AS "No_ of Quotes","SUB$No_ of Invoices"."$CNT" AS "No_ of Invoices","SUB$No_ of Credit Memos"."$CNT" AS "No_ of Credit Memos","SUB$No_ of Pstd_ Shipments"."$CNT" AS "No_ of Pstd_ Shipments","SUB$No_ of Pstd_ Invoices"."$CNT" AS "No_ of Pstd_ Invoices","SUB$No_ of Pstd_ Return Receipts"."$CNT" AS "No_ of Pstd_ Return Receipts","SUB$No_ of Pstd_ Credit Memos"."$CNT" AS "No_ of Pstd_ Credit Memos","SUB$No_ of Ship-to Addresses"."$CNT" AS "No_ of Ship-to Addresses","SUB$Bill-To No_ of Quotes"."$CNT" AS "Bill-To No_ of Quotes","SUB$Bill-To No_ of Invoices"."$CNT" AS "Bill-To No_ of Invoices","SUB$Bill-To No_ of Credit Memos"."$CNT" AS "Bill-To No_ of Credit Memos","SUB$Bill-To No_ of Pstd_ Shipments"."$CNT" AS "Bill-To No_ of Pstd_ Shipments","SUB$Bill-To No_ of Pstd_ Invoices"."$CNT" AS "Bill-To No_ of Pstd_ Invoices","SUB$Bill-To No_ of Pstd_ Return R_"."$CNT" AS "Bill-To No_ of Pstd_ Return R_","SUB$Bill-To No_ of Pstd_ Cr_ Memos"."$CNT" AS "Bill-To No_ of Pstd_ Cr_ Memos",ISNULL("SUB$District Manager Name"."District Manager Name$Employee$LOOKUP$Last Name",@2) AS "District Manager Name",ISNULL("SUB$Indexation Enabled"."Indexation Enabled$Customer Index$EXISTS",@0) AS "Indexation Enabled" FROM "CARE-2009-migration".dbo."Care NV$Customer" AS "Customer" WITH(READUNCOMMITTED)  OUTER APPLY (SELECT TOP (1) @10 AS "Comment$Comment Line$EXISTS",ISNULL("Comment$Comment Line"."Table Name",@5) AS "Comment$Comment Line$Table Name",ISNULL("Comment$Comment Line"."No_",@1) AS "Comment$Comment Line$No_",ISNULL("Comment$Comment Line"."Line No_",@4) AS "Comment$Comment Line$Line No_" FROM "CARE-2009-migration".dbo."Care NV$Comment Line" AS "Comment$Comment Line" WITH(READUNCOMMITTED)  WHERE (ISNULL("Comment$Comment Line"."Table Name",@5)=@11 AND "Comment$Comment Line"."No_"="Customer"."No_") ORDER BY "Comment$Comment Line$Table Name" ASC,"Comment$Comment Line$No_" ASC,"Comment$Comment Line$Line No_" ASC) AS "SUB$Comment"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Balance$Detailed Cust_ Ledg_ Entry"."SUM$Amount"),@3) AS "Balance$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry$VSIFT$5" AS "Balance$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Balance$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Balance"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Balance (LCY)$Detailed Cust_ Ledg_ Entry"."SUM$Amount (LCY)"),@3) AS "Balance (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry$VSIFT$5" AS "Balance (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Balance (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Balance (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Net Change$Detailed Cust_ Ledg_ Entry"."SUM$Amount"),@3) AS "Net Change$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry$VSIFT$5" AS "Net Change$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Net Change$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Net Change"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Net Change (LCY)$Detailed Cust_ Ledg_ Entry"."SUM$Amount (LCY)"),@3) AS "Net Change (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry$VSIFT$5" AS "Net Change (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Net Change (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Net Change (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Sales (LCY)$Cust_ Ledger Entry"."SUM$Sales (LCY)"),@3) AS "Sales (LCY)$Cust_ Ledger Entry$SUM$Sales (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Cust_ Ledger Entry$VSIFT$1" AS "Sales (LCY)$Cust_ Ledger Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Sales (LCY)$Cust_ Ledger Entry"."Customer No_"="Customer"."No_")) AS "SUB$Sales (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Profit (LCY)$Cust_ Ledger Entry"."SUM$Profit (LCY)"),@3) AS "Profit (LCY)$Cust_ Ledger Entry$SUM$Profit (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Cust_ Ledger Entry$VSIFT$1" AS "Profit (LCY)$Cust_ Ledger Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Profit (LCY)$Cust_ Ledger Entry"."Customer No_"="Customer"."No_")) AS "SUB$Profit (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Inv_ Discounts (LCY)$Cust_ Ledger Entry"."SUM$Inv_ Discount (LCY)"),@3) AS "Inv_ Discounts (LCY)$Cust_ Ledger Entry$SUM$Inv_ Discount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Cust_ Ledger Entry$VSIFT$1" AS "Inv_ Discounts (LCY)$Cust_ Ledger Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Inv_ Discounts (LCY)$Cust_ Ledger Entry"."Customer No_"="Customer"."No_")) AS "SUB$Inv_ Discounts (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Pmt_ Discounts (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Pmt_ Discounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Pmt_ Discounts (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE ("Pmt_ Discounts (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_" AND ISNULL("Pmt_ Discounts (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)>=@12 AND ISNULL("Pmt_ Discounts (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)<=@13)) AS "SUB$Pmt_ Discounts (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Balance Due$Detailed Cust_ Ledg_ Entry"."SUM$Amount"),@3) AS "Balance Due$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry$VSIFT$5" AS "Balance Due$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Balance Due$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Balance Due"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Balance Due (LCY)$Detailed Cust_ Ledg_ Entry"."SUM$Amount (LCY)"),@3) AS "Balance Due (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry$VSIFT$5" AS "Balance Due (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Balance Due (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Balance Due (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Payments$Detailed Cust_ Ledg_ Entry"."Amount"),@3) AS "Payments$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Payments$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Payments$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@14 AND ISNULL("Payments$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@15 AND "Payments$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Payments"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Invoice Amounts$Detailed Cust_ Ledg_ Entry"."Amount"),@3) AS "Invoice Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Invoice Amounts$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Invoice Amounts$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@16 AND ISNULL("Invoice Amounts$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@17 AND "Invoice Amounts$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Invoice Amounts"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Cr_ Memo Amounts$Detailed Cust_ Ledg_ Entry"."Amount"),@3) AS "Cr_ Memo Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Cr_ Memo Amounts$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Cr_ Memo Amounts$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@18 AND ISNULL("Cr_ Memo Amounts$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@19 AND "Cr_ Memo Amounts$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Cr_ Memo Amounts"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Finance Charge Memo Amounts$Detailed Cust_ Ledg_ Entry"."Amount"),@3) AS "Finance Charge Memo Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Finance Charge Memo Amounts$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Finance Charge Memo Amounts$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@20 AND ISNULL("Finance Charge Memo Amounts$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@21 AND "Finance Charge Memo Amounts$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Finance Charge Memo Amounts"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Payments (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Payments (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Payments (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Payments (LCY)$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@22 AND ISNULL("Payments (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@23 AND "Payments (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Payments (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Inv_ Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Inv_ Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Inv_ Amounts (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Inv_ Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@24 AND ISNULL("Inv_ Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@25 AND "Inv_ Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Inv_ Amounts (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Cr_ Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Cr_ Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Cr_ Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Cr_ Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@26 AND ISNULL("Cr_ Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@27 AND "Cr_ Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Cr_ Memo Amounts (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Fin_ Charge Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Fin_ Charge Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Fin_ Charge Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Fin_ Charge Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@28 AND ISNULL("Fin_ Charge Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@29 AND "Fin_ Charge Memo Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Fin_ Charge Memo Amounts (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Debit Amount$Detailed Cust_ Ledg_ Entry"."Debit Amount"),@3) AS "Debit Amount$Detailed Cust_ Ledg_ Entry$SUM$Debit Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Debit Amount$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE ("Debit Amount$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_" AND ISNULL("Debit Amount$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)<>@30)) AS "SUB$Debit Amount"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Credit Amount$Detailed Cust_ Ledg_ Entry"."Credit Amount"),@3) AS "Credit Amount$Detailed Cust_ Ledg_ Entry$SUM$Credit Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Credit Amount$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE ("Credit Amount$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_" AND ISNULL("Credit Amount$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)<>@31)) AS "SUB$Credit Amount"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Debit Amount (LCY)$Detailed Cust_ Ledg_ Entry"."Debit Amount (LCY)"),@3) AS "Debit Amount (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Debit Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Debit Amount (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE ("Debit Amount (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_" AND ISNULL("Debit Amount (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)<>@32)) AS "SUB$Debit Amount (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Credit Amount (LCY)$Detailed Cust_ Ledg_ Entry"."Credit Amount (LCY)"),@3) AS "Credit Amount (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Credit Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Credit Amount (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE ("Credit Amount (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_" AND ISNULL("Credit Amount (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)<>@33)) AS "SUB$Credit Amount (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Reminder Amounts$Detailed Cust_ Ledg_ Entry"."Amount"),@3) AS "Reminder Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Reminder Amounts$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Reminder Amounts$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@34 AND ISNULL("Reminder Amounts$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@35 AND "Reminder Amounts$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Reminder Amounts"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Reminder Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Reminder Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Reminder Amounts (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Reminder Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@36 AND ISNULL("Reminder Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@37 AND "Reminder Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Reminder Amounts (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Pmt_ Disc_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Pmt_ Disc_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Pmt_ Disc_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE ("Pmt_ Disc_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_" AND (ISNULL("Pmt_ Disc_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@38 OR ISNULL("Pmt_ Disc_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@39 OR ISNULL("Pmt_ Disc_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@40))) AS "SUB$Pmt_ Disc_ Tolerance (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Pmt_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Pmt_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Pmt_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE ("Pmt_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_" AND (ISNULL("Pmt_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@41 OR ISNULL("Pmt_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@42 OR ISNULL("Pmt_ Tolerance (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@43))) AS "SUB$Pmt_ Tolerance (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Refunds$Detailed Cust_ Ledg_ Entry"."Amount"),@3) AS "Refunds$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Refunds$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Refunds$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@44 AND ISNULL("Refunds$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@45 AND "Refunds$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Refunds"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Refunds (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Refunds (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Refunds (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Refunds (LCY)$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@46 AND ISNULL("Refunds (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@47 AND "Refunds (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Refunds (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Other Amounts$Detailed Cust_ Ledg_ Entry"."Amount"),@3) AS "Other Amounts$Detailed Cust_ Ledg_ Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Other Amounts$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Other Amounts$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@48 AND ISNULL("Other Amounts$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@49 AND "Other Amounts$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Other Amounts"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Other Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Amount (LCY)"),@3) AS "Other Amounts (LCY)$Detailed Cust_ Ledg_ Entry$SUM$Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Detailed Cust_ Ledg_ Entry" AS "Other Amounts (LCY)$Detailed Cust_ Ledg_ Entry" WITH(READUNCOMMITTED)  WHERE (ISNULL("Other Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Initial Document Type",@5)=@50 AND ISNULL("Other Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Entry Type",@5)=@51 AND "Other Amounts (LCY)$Detailed Cust_ Ledg_ Entry"."Customer No_"="Customer"."No_")) AS "SUB$Other Amounts (LCY)"  OUTER APPLY (SELECT TOP (1) COUNT("Bill-to No_ Of Archived Doc_$Sales Header Archive"."Document Type") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Header Archive" AS "Bill-to No_ Of Archived Doc_$Sales Header Archive" WITH(READUNCOMMITTED)  WHERE (ISNULL("Bill-to No_ Of Archived Doc_$Sales Header Archive"."Document Type",@5)=@52 AND "Bill-to No_ Of Archived Doc_$Sales Header Archive"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Bill-to No_ Of Archived Doc_"  OUTER APPLY (SELECT TOP (1) COUNT("Sell-to No_ Of Archived Doc_$Sales Header Archive"."Document Type") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Header Archive" AS "Sell-to No_ Of Archived Doc_$Sales Header Archive" WITH(READUNCOMMITTED)  WHERE (ISNULL("Sell-to No_ Of Archived Doc_$Sales Header Archive"."Document Type",@5)=@53 AND "Sell-to No_ Of Archived Doc_$Sales Header Archive"."Sell-to Customer No_"="Customer"."No_")) AS "SUB$Sell-to No_ Of Archived Doc_"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Contract Gain_Loss Amount$Contract Gain_Loss Entry"."SUM$Amount"),@3) AS "Contract Gain_Loss Amount$Contract Gain_Loss Entry$SUM$Amount" FROM "CARE-2009-migration".dbo."Care NV$Contract Gain_Loss Entry$VSIFT$3" AS "Contract Gain_Loss Amount$Contract Gain_Loss Entry" WITH(READUNCOMMITTED,NOEXPAND)  WHERE ("Contract Gain_Loss Amount$Contract Gain_Loss Entry"."Customer No_"="Customer"."No_")) AS "SUB$Contract Gain_Loss Amount"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Outstanding Serv_ Orders (LCY)$Service Line"."SUM$Outstanding Amount (LCY)"),@3) AS "Outstanding Serv_ Orders (LCY)$Service Line$SUM$Outstanding Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Service Line$VSIFT$3" AS "Outstanding Serv_ Orders (LCY)$Service Line" WITH(READUNCOMMITTED,NOEXPAND)  WHERE (ISNULL("Outstanding Serv_ Orders (LCY)$Service Line"."Document Type",@5)=@54 AND "Outstanding Serv_ Orders (LCY)$Service Line"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Outstanding Serv_ Orders (LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Serv Shipped Not Invoiced(LCY)$Service Line"."SUM$Shipped Not Invoiced (LCY)"),@3) AS "Serv Shipped Not Invoiced(LCY)$Service Line$SUM$Shipped Not Invoiced (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Service Line$VSIFT$3" AS "Serv Shipped Not Invoiced(LCY)$Service Line" WITH(READUNCOMMITTED,NOEXPAND)  WHERE (ISNULL("Serv Shipped Not Invoiced(LCY)$Service Line"."Document Type",@5)=@55 AND "Serv Shipped Not Invoiced(LCY)$Service Line"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Serv Shipped Not Invoiced(LCY)"  OUTER APPLY (SELECT TOP (1) ISNULL(SUM("Outstanding Serv_Invoices(LCY)$Service Line"."SUM$Outstanding Amount (LCY)"),@3) AS "Outstanding Serv_Invoices(LCY)$Service Line$SUM$Outstanding Amount (LCY)" FROM "CARE-2009-migration".dbo."Care NV$Service Line$VSIFT$3" AS "Outstanding Serv_Invoices(LCY)$Service Line" WITH(READUNCOMMITTED,NOEXPAND)  WHERE (ISNULL("Outstanding Serv_Invoices(LCY)$Service Line"."Document Type",@5)=@56 AND "Outstanding Serv_Invoices(LCY)$Service Line"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Outstanding Serv_Invoices(LCY)"  OUTER APPLY (SELECT TOP (1) COUNT("No_ of Quotes$Sales Header"."Document Type") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Header" AS "No_ of Quotes$Sales Header" WITH(READUNCOMMITTED)  WHERE (ISNULL("No_ of Quotes$Sales Header"."Document Type",@5)=@57 AND "No_ of Quotes$Sales Header"."Sell-to Customer No_"="Customer"."No_")) AS "SUB$No_ of Quotes"  OUTER APPLY (SELECT TOP (1) COUNT("No_ of Invoices$Sales Header"."Document Type") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Header" AS "No_ of Invoices$Sales Header" WITH(READUNCOMMITTED)  WHERE (ISNULL("No_ of Invoices$Sales Header"."Document Type",@5)=@58 AND "No_ of Invoices$Sales Header"."Sell-to Customer No_"="Customer"."No_")) AS "SUB$No_ of Invoices"  OUTER APPLY (SELECT TOP (1) COUNT("No_ of Credit Memos$Sales Header"."Document Type") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Header" AS "No_ of Credit Memos$Sales Header" WITH(READUNCOMMITTED)  WHERE (ISNULL("No_ of Credit Memos$Sales Header"."Document Type",@5)=@59 AND "No_ of Credit Memos$Sales Header"."Sell-to Customer No_"="Customer"."No_")) AS "SUB$No_ of Credit Memos"  OUTER APPLY (SELECT TOP (1) COUNT("No_ of Pstd_ Shipments$Sales Shipment Header"."No_") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Shipment Header" AS "No_ of Pstd_ Shipments$Sales Shipment Header" WITH(READUNCOMMITTED)  WHERE ("No_ of Pstd_ Shipments$Sales Shipment Header"."Sell-to Customer No_"="Customer"."No_")) AS "SUB$No_ of Pstd_ Shipments"  OUTER APPLY (SELECT TOP (1) COUNT("No_ of Pstd_ Invoices$Sales Invoice Header"."No_") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Invoice Header" AS "No_ of Pstd_ Invoices$Sales Invoice Header" WITH(READUNCOMMITTED)  WHERE ("No_ of Pstd_ Invoices$Sales Invoice Header"."Sell-to Customer No_"="Customer"."No_")) AS "SUB$No_ of Pstd_ Invoices"  OUTER APPLY (SELECT TOP (1) COUNT("No_ of Pstd_ Return Receipts$Return Receipt Header"."No_") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Return Receipt Header" AS "No_ of Pstd_ Return Receipts$Return Receipt Header" WITH(READUNCOMMITTED)  WHERE ("No_ of Pstd_ Return Receipts$Return Receipt Header"."Sell-to Customer No_"="Customer"."No_")) AS "SUB$No_ of Pstd_ Return Receipts"  OUTER APPLY (SELECT TOP (1) COUNT("No_ of Pstd_ Credit Memos$Sales Cr_Memo Header"."No_") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Cr_Memo Header" AS "No_ of Pstd_ Credit Memos$Sales Cr_Memo Header" WITH(READUNCOMMITTED)  WHERE ("No_ of Pstd_ Credit Memos$Sales Cr_Memo Header"."Sell-to Customer No_"="Customer"."No_")) AS "SUB$No_ of Pstd_ Credit Memos"  OUTER APPLY (SELECT TOP (1) COUNT("No_ of Ship-to Addresses$Ship-to Address"."Customer No_") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Ship-to Address" AS "No_ of Ship-to Addresses$Ship-to Address" WITH(READUNCOMMITTED)  WHERE ("No_ of Ship-to Addresses$Ship-to Address"."Customer No_"="Customer"."No_")) AS "SUB$No_ of Ship-to Addresses"  OUTER APPLY (SELECT TOP (1) COUNT("Bill-To No_ of Quotes$Sales Header"."Document Type") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Header" AS "Bill-To No_ of Quotes$Sales Header" WITH(READUNCOMMITTED)  WHERE (ISNULL("Bill-To No_ of Quotes$Sales Header"."Document Type",@5)=@60 AND "Bill-To No_ of Quotes$Sales Header"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Bill-To No_ of Quotes"  OUTER APPLY (SELECT TOP (1) COUNT("Bill-To No_ of Invoices$Sales Header"."Document Type") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Header" AS "Bill-To No_ of Invoices$Sales Header" WITH(READUNCOMMITTED)  WHERE (ISNULL("Bill-To No_ of Invoices$Sales Header"."Document Type",@5)=@61 AND "Bill-To No_ of Invoices$Sales Header"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Bill-To No_ of Invoices"  OUTER APPLY (SELECT TOP (1) COUNT("Bill-To No_ of Credit Memos$Sales Header"."Document Type") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Header" AS "Bill-To No_ of Credit Memos$Sales Header" WITH(READUNCOMMITTED)  WHERE (ISNULL("Bill-To No_ of Credit Memos$Sales Header"."Document Type",@5)=@62 AND "Bill-To No_ of Credit Memos$Sales Header"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Bill-To No_ of Credit Memos"  OUTER APPLY (SELECT TOP (1) COUNT("Bill-To No_ of Pstd_ Shipments$Sales Shipment Header"."No_") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Shipment Header" AS "Bill-To No_ of Pstd_ Shipments$Sales Shipment Header" WITH(READUNCOMMITTED)  WHERE ("Bill-To No_ of Pstd_ Shipments$Sales Shipment Header"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Bill-To No_ of Pstd_ Shipments"  OUTER APPLY (SELECT TOP (1) COUNT("Bill-To No_ of Pstd_ Invoices$Sales Invoice Header"."No_") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Invoice Header" AS "Bill-To No_ of Pstd_ Invoices$Sales Invoice Header" WITH(READUNCOMMITTED)  WHERE ("Bill-To No_ of Pstd_ Invoices$Sales Invoice Header"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Bill-To No_ of Pstd_ Invoices"  OUTER APPLY (SELECT TOP (1) COUNT("Bill-To No_ of Pstd_ Return R_$Return Receipt Header"."No_") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Return Receipt Header" AS "Bill-To No_ of Pstd_ Return R_$Return Receipt Header" WITH(READUNCOMMITTED)  WHERE ("Bill-To No_ of Pstd_ Return R_$Return Receipt Header"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Bill-To No_ of Pstd_ Return R_"  OUTER APPLY (SELECT TOP (1) COUNT("Bill-To No_ of Pstd_ Cr_ Memos$Sales Cr_Memo Header"."No_") AS "$CNT" FROM "CARE-2009-migration".dbo."Care NV$Sales Cr_Memo Header" AS "Bill-To No_ of Pstd_ Cr_ Memos$Sales Cr_Memo Header" WITH(READUNCOMMITTED)  WHERE ("Bill-To No_ of Pstd_ Cr_ Memos$Sales Cr_Memo Header"."Bill-to Customer No_"="Customer"."No_")) AS "SUB$Bill-To No_ of Pstd_ Cr_ Memos"  OUTER APPLY (SELECT TOP (1) ISNULL("District Manager Name$Employee"."Last Name",@2) AS "District Manager Name$Employee$LOOKUP$Last Name",ISNULL("District Manager Name$Employee"."No_",@1) AS "District Manager Name$Employee$No_" FROM "CARE-2009-migration".dbo."Care NV$Employee" AS "District Manager Name$Employee" WITH(READUNCOMMITTED)  WHERE ("District Manager Name$Employee"."No_"="Customer"."District Manager") ORDER BY "District Manager Name$Employee$No_" ASC) AS "SUB$District Manager Name"  OUTER APPLY (SELECT TOP (1) @63 AS "Indexation Enabled$Customer Index$EXISTS",ISNULL("Indexation Enabled$Customer Index"."Primary Key",@4) AS "Indexation Enabled$Customer Index$Primary Key" FROM "CARE-2009-migration".dbo."Care NV$Customer Index" AS "Indexation Enabled$Customer Index" WITH(READUNCOMMITTED)  WHERE ("Indexation Enabled$Customer Index"."Customer Code"="Customer"."No_") ORDER BY "Indexation Enabled$Customer Index$Primary Key" ASC) AS "SUB$Indexation Enabled"  ORDER BY "No_" ASC OPTION(OPTIMIZE FOR UNKNOWN, FAST 50)