---
--- Skus de campaña que son hijos desde lista de precios
---
select a.strcodlin, a.strSKUPadre 
from tblsku a, tbllistasprecios b
where 
	a.strCodLin = b.strCodLin
	and b.strCampaña = '201908'
	and isnull(a.strSKUPadre,'') <> '' 

---
--- Skus de campaña desde lista de precios
---
select * 
from tblsku a, tbllistasprecios b
where 
	a.strCodLin = b.strCodLin
	and b.strCampaña = '201908'

---
---Pendientes asesora
---
select * from tblpendientes where strCodigoAsesora = '00043725964' and strSKU in ('520555','553900')

---
---Producto excluido IVA
---	
select * from [dbo].[tbl_ciudades_productosexcluidos] where sku = '557627'

---
---Zonas sin facturas
---
select a.strNumDoc, b.strCodigoZona  from tbl_pedcab a, tblterceros b
where
	b.strCodigo = a.strCodTer
	and a.strTipDoc = 'pd'
	and a.strCamGen = '201908'
	and b.strCodigoZona in (
		'020005','020006','020007','020008','020009','020014','020015','020016','020038','020039','020040','020041','020042','020043','020044','100002',
		'100005','100006','100009','100010','100012','100013','100014','100017','100019','100026','100027','100029','100030','200002','200003','200004',
		'200005','200006','200007','200008','200009','200011','200012','200013','200014','200015','200016','200017','070015','070014','070019','070017'
	) and not exists (
		select * from tbldoc c where c.strCamGen = a.strCamGen and c.strCodCA = a.strCodTer and c.strTipDoc = 'fc'
	)

---
---Pedidos facturados
---
select a.* from tbldoc a with (nolock) 
join tblterceros c with (nolock) on a.strCodCA = c.strCodigo
join tblzonas d with (nolock) on c.strCodigoZona = d.strCodigo and a.strCamGen = '201908' and d.STRMAILGROUP = 'G' and a.strTipDoc = 'FC'

---
---Pedidos no facturados
---
select a.* from tbl_pedcab a
join tblterceros c on a.strCodTer = c.strCodigo 
join tblzonas d on c.strCodigoZona = d.strCodigo
and a.strCamGen = '201908' and d.STRMAILGROUP = 'I' and not exists (
	select * from tbldoc b where b.strCodCA = a.strCodTer and b.strCamGen = a.strCamGen and b.strTipDoc = 'FC'
) 
--and a.strNumDoc = '0019487124'
and a.intOrdenimpresion > 0 
order by a.dtmfechaimpresion desc

---
---Detalles de la factura campaña actual
---
select * from tbl_facdet where strTipDoc = 'fc' and strNumDoc = '0013384224'

---
---E.Factura Asesora 
---
select * from tbldoc where strTipDoc = 'fc' and strCamGen = '201908' and strCodCA = '00040176445' or strNumDoc = ''

---
---Facturacion combo mágico
---
select * from tbl_peddet a join tbl_pedcab b on a.strTipDoc = b.strTipDoc and a.strNumDoc = b.strNumDoc 
where 
a.strcodlin = '100678' and a.strTipDoc = 'pd' and b.strCamGen = '201908' and b.logFacturado = 1
and strcodter not in (
	select distinct strcodter from tbl_facdet a join tbl_faccab b on a.strNumDoc = b.strNumDoc and a.strTipDoc = b.strTipDoc 
	where a.strAtributo = '9' and b.strTipDoc = 'fc' and b.strCamGen = '201908'
)