"VER1.0","Clientes","Listado de Clientes"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
H, 9, 0
0, 0, 0, 0

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT * , CodigoPostal & ' - ' & Poblacion as Direc, 'Tel : ' & Telefono1 as Tel "
"FROM Configuracion"
""
[CAPSALERA]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
0,"Condiciones : ",10,10,"ARIAL",8,0,0,"1000"
6,"Condiciones",35,10,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Domicilio",10,8,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Direc",10,11,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Provincia",10,14,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Tel",10,17,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Nif",10,20,"ARIAL",8,0,0,"1000",""
[FICAP]

[FIGRUP]

;-----------------------------------------

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 15
0,"Pgina :",170,0,"ARIAL",8,0,0,"1000"
6,"Pagina",200,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",170,5,"ARIAL",8,0,0,"1000"
6,"Fecha",200,5,"ARIAL",8,0,1,"1000",""
0, "Listado de clientes", 105, 7, "ARIAL", 22, 0, 2, "1000"
1, "lineaH1", 5, 17, 288, 17,,,
0,"Cdigo",5,18,"ARIAL",10,0,0,"1000"
0,"Nombre",30,18,"ARIAL",10,0,0,"1000"
0,"NIF",100,18,"ARIAL",10,0,0,"1000"
0,"Persona Contacto",125,18,"ARIAL",10,0,0,"1000"
0,"Telfono",160,18,"ARIAL",10,0,0,"1000"
0,"Impreso",185,18,"ARIAL",10,0,0,"1000"
0,"Riesgo MAX",200,18,"ARIAL",10,0,0,"1000"
0,"R. Ped.       R. Alb.        R.Rec.       Total",222,18,"ARIAL",10,0,0,"1000"
1, "lineaH2", 5, 22, 288, 22,,,
[FICAP]

[PEU]
0, 25, #TRUE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total",160,0,"ARIAL",12,0,1,"1000"
;5,0,"Total",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]

[FIGRUP]

;-----------------------------------------

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT a.*, Direcciones.CodPostal, *,(SELECT sum(Importe) as ImpRec FROM VenRecibos WHERE CodCliente=a.CodCliente AND Contabilizado=False group by CodCliente) as ImpRec, (SELECT sum(Total) as ImpAlb FROM VenAlba WHERE CodCliente=a.CodCliente AND Facturado=FALSE 
group by CodCliente) as ImpAlb, (SELECT sum(Total) as ImpPed FROM VenPrev WHERE CodCliente=a.CodCliente AND Pedido=TRUE AND Servido=FALSE group by CodCliente) as ImpPed, iif(isnull(ImpPed),0,ImpPed)+iif(isnull(ImpAlb),0,ImpAlb)+iif(isnull(ImpRec),0,ImpRec) as RiesgoTotal"
"FROM Clientes as a LEFT JOIN Direcciones ON (a.CodDireccion = Direcciones.CodDireccion) AND (a.CodCliente = Direcciones.CodCliente)"
""
[CONDICIONS] 4
"Direcciones.CodCliente", "Codigo",0,1, -10
"Nombre", "Nombre", 0, 1
"CodRepresentante", "Cod Representante", 0, 1
"CodPostal", "Cod Postal", 0, 1
;"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"

[ORDENACIONS] 3
"a.CodCliente", "Codigo cliente", 3
"Nombre", "Nombre", 3
"NIF", "N.I.F.", 3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 11
3,"COS","a.CodCliente",5,0,"ARIAL",10,0,0,"0000",""
3,"COS","Nombre",30,0,"ARIAL",10,70,0,"0000",""
3,"COS","NIF",100,0,"ARIAL",10,0,0,"0000",""
3,"COS","PersonaContacto",128,0,"ARIAL",10,30,0,"0000",""
3,"COS","a.Telefono",160,0,"ARIAL",10,0,0,"0000",""
3,"COS","ImpresoRiesgo",190,0,"ARIAL",10,0,3,"0000",""
3,"COS","Riesgo",210,0,"ARIAL",10,0,1,"0000",""
3,"COS","ImpPed",230,0,"ARIAL",10,0,1,"0000","Total"
3,"COS","ImpAlb",248,0,"ARIAL",10,0,1,"0000","Total"
3,"COS","ImpRec",270,0,"ARIAL",10,0,1,"0000","Total"
3,"COS","RiesgoTotal",290,0,"ARIAL",10,0,1,"1000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 0
;"Total","COS","PrecioCoste","GENERAL"

[FIDOCUM]


