WITH cbe_contacts as (
select
CAST(c.ClientIdSubId AS VARCHAR(MAX)) AS ClientIdSubId,
c.ClientSortName,
ce.FirmEmailTypeName,
cbe.StatementFlag,
cbe.InvoiceFlag
--CASE WHEN cbe.StatementFlag IS NOT NULL OR cbe.InvoiceFlag IS NOT NULL THEN 'true' ELSE 'False' END as FLAG_CBE_CONTACT,
--CASE WHEN cbe.StatementFlag = 'T' OR cbe.InvoiceFlag = 'T' THEN 'true' ELSE 'false' END as FLAG_EDIT_CONTACT,


FROM  {CONNECTION_ADDON}CLIENTBILLINGEMAIL cbe
inner join {CONNECTION_ADDON}CLIENTEMAIL ce on ce.EmailIdent = cbe.ClientEmailIdent
inner join {CONNECTION_ADDON}CLIENT c on c.ClientIdent = cbe.ClientIdent
WHERE 1=1
and (ce.EmailAddress <> '{SCHEMA_NAME}@inbound.aiwyn.ai' or EmailAddress is null)
AND ce.ISCLIENTBILLINGADDRESSFLAG = 'true'
  {CLIENT_EXCLUSION_CONDITION} 
)

  select
  	cbe.ClientIdSubId AS "Client ID.Client Sub ID",
	cbe.ClientSortName AS "Client Sort Name",
	cbe.FirmEmailTypeName AS "Email Type",
    'FALSE' as "Receive Invoice",
    'TRUE' as "Receive Statement"
    --ContactInfoPMSRef
  from cbe_contacts cbe
  WHERE NOT (cbe.StatementFlag IS NULL AND cbe.InvoiceFlag IS NULL) -- Drops (NULL, NULL)
  AND NOT (cbe.StatementFlag = 'F' AND cbe.InvoiceFlag = 'F')     -- Drops ('F', 'F')
  Order by ClientIdSubId