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

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
0, 0, 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 : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"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]

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

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


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "DISENY", #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] 6
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","dd-mm-yyyy"
0, "Listado de clientes", 105, 2, "ARIAL", 22, 0, 2, "1000"
1, "lineaH1", 5, 17, 200, 17,,,
;0,"Cdigo",5,18,"ARIAL",8,0,0,"1000"
;0,"Nombre",25,18,"ARIAL",8,0,0,"1000"
;0,"NIF",80,18,"ARIAL",8,0,0,"1000"
;0,"Persona Contacto",100,18,"ARIAL",8,0,0,"1000"
;0,"Cargo Contacto",140,18,"ARIAL",8,0,0,"1000"
;0,"Telfono",185,18,"ARIAL",8,0,0,"1000"
;0,"Domicilio",25,22,"ARIAL",8,0,0,"1000"
;0,"Poblacin",140,22,"ARIAL",8,0,0,"1000"
;0,"Fax",185,22,"ARIAL",8,0,0,"1000"
;1, "lineaH2", 5, 27, 200, 27,,,

[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total Acumulado",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 T1.CodCliente, Sum(VenFacturas.Total) AS SumaDeTotal, Direccion.CodPostal & ' - ' & Direccion.Ciudad AS pobla, Direccion.Direccion, T1.CodRepresentante , T1.CodFormaPago, T1.CodTipoPago, T1.Dia1Pago, T1.Dia2Pago, T1.DescuentoEnLinea, T1.DescuentoComercial, T1.DescuentoPP, ModoPago.Descripcion, TipoPago.Descripcion, T1.CodCliente, T1.Nombre, T1.NombreFiscal, T1.NIF, T1.PersonaContacto, T1.CargoContacto, T1.Telefono, T1.FAX, T1.Mail, T1.Web, T1.Observaciones, Direccion.CodPostal, (SELECT Last(VenFacturas.Total) FROM VenFacturas GROUP BY VenFacturas.CodCliente HAVING (Last(VenFacturas.Total)>200) AND (VenFacturas.CodCliente)=T1.CodCliente) AS UltimoDeTotal, (SELECT Last (VenFacturas.FechaFactura) FROM VenFacturas GROUP BY VenFacturas.CodCliente HAVING (Last(VenFacturas.Total)>200) AND (VenFacturas.CodCliente)=T1.CodCliente) AS UltimoDeFechaFactura "
" FROM ((((Clientes AS T1 LEFT JOIN Direccion ON (T1.CodCliente = Direccion.CodCliente) AND (T1.CodDireccion = Direccion.CodDireccion)) LEFT JOIN ModoPago ON T1.CodFormaPago = ModoPago.CodPago) LEFT JOIN TipoPago ON T1.CodTipoPago = TipoPago.CodPago) INNER JOIN VenFacturas ON T1.CodCliente = VenFacturas.CodCliente)"
" GROUP BY T1.CodCliente, Direccion.CodPostal & ' - ' & Direccion.Ciudad, Direccion.Direccion, T1.CodRepresentante, T1.CodFormaPago, T1.CodTipoPago, T1.Dia1Pago, T1.Dia2Pago, T1.DescuentoEnLinea, T1.DescuentoComercial, T1.DescuentoPP, ModoPago.Descripcion, TipoPago.Descripcion, T1.CodCliente, T1.Nombre, T1.NombreFiscal, T1.NIF, T1.PersonaContacto, T1.CargoContacto, T1.Telefono, T1.FAX, T1.Mail, T1.Web, T1.Observaciones, Direccion.CodPostal "
;" ORDER BY Max(VenFacturas.FechaFactura)"

[CONDICIONS] 4
"T1.CodCliente","Codigo",0,1, -10
"Nombre","Nombre",0,1
"CodRepresentante", "Cod Representante", 0, 1
"FechaFactura", "Fecha Factura", 0, 2
;" (ultimaventa2.UltimoDeTotal>=100 ) ","",4
;"CodFamilia", "Cod", 1, 1, "CAB1", "CodFamilia"
;"CodProveedor", "proveedor", 1, 1, "CAB2", "CodProveedor"
;"CodIva", "Iva", 1, 1, "CAB3", "CodIva"
;" (Servido = false ) ","",4
;" (AlbaranDeposito = false ) ","",4

[ORDENACIONS] 3
"T1.CodCliente","Codigo cliente",3
"Nombre","Nombre",3
"CodPostal","Cod. Postal",3

[CAPSALERA]
0, 35, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 45
0,"Cdigo:",5,0,"ARIAL",8,0,0,"1000"
3,"COS","CodCliente",20,0,"ARIAL",8,0,0,"0000",""
0,"Nombre:",45,0,"ARIAL",8,0,0,"1000"
3,"COS","Nombre",60,0,"ARIAL",8,70,0,"1000",""
0,"N. Fiscal:",130,0,"ARIAL",8,0,0,"1000"
3,"COS","NombreFiscal",150,0,"ARIAL",8,40,0,"0000",""
0,"NIF:",5,5,"ARIAL",8,0,0,"1000"
3,"COS","NIF",20,5,"ARIAL",8,0,0,"0000",""
0,"Contacto:",45,5,"ARIAL",8,0,0,"1000"
3,"COS","PersonaContacto",60,5,"ARIAL",8,0,0,"0000",""
0,"Cargo Cont:",90,5,"ARIAL",8,0,0,"1000"
3,"COS","CargoContacto",110,5,"ARIAL",8,0,0,"0000",""
0,"Telfono:",130,5,"ARIAL",8,0,0,"1000"
3,"COS","Telefono",145,5,"ARIAL",8,0,0,"0000",""
0,"FAX:",165,5,"ARIAL",8,0,0,"1000"
3,"COS","Fax",180,5,"ARIAL",8,0,0,"0000",""
0,"Direccin:",5,10,"ARIAL",8,0,0,"1000"
3,"COS","Direccion",25,10,"ARIAL",8,0,0,"0000",""
0,"Poblacin:",130,10,"ARIAL",8,0,0,"1000"
3,"COS","Pobla",150,10,"ARIAL",8,0,0,"0000",""
0,"eMail:",5,15,"ARIAL",8,0,0,"1000"
3,"COS","mail",25,15,"ARIAL",8,0,0,"0000",""
0,"Web:",90,15,"ARIAL",8,0,0,"1000"
3,"COS","Web",100,15,"ARIAL",8,0,0,"0000",""
0,"F. de pago:",5,20,"ARIAL",8,0,0,"1000"
3,"COS","TipoPago.Descripcion",40,20,"ARIAL",8,0,0,"0000",""
3,"COS","ModoPago.Descripcion",25,20,"ARIAL",8,0,0,"0000",""
0,"Dia pago:",85,20,"ARIAL",8,0,0,"1000"
3,"COS","Dia1Pago",100,20,"ARIAL",8,0,0,"0000",""
3,"COS","Dia2Pago",110,20,"ARIAL",8,0,0,"0000",""
0,"Dto.Linea:",125,20,"ARIAL",8,0,0,"1000"
3,"COS","DescuentoEnLinea",142,20,"ARIAL",8,0,0,"0000",""
0,"Dto comercial:",147,20,"ARIAL",8,0,0,"1000"
3,"COS","Descuentocomercial",170,20,"ARIAL",8,0,0,"0000",""
0,"Dto pr. pago:",175,20,"ARIAL",8,0,0,"1000"
3,"COS","DescuentoPP",195,20,"ARIAL",8,0,0,"0000",""
0,"Observaciones:",5,25,"ARIAL",8,0,0,"1000"
3,"COS","Observaciones",30,25,"ARIAL",8,0,0,"0000",""
0,"Ventas:",85,25,"ARIAL",10,0,0,"1000"
3,"COS","SumaDeTotal",100,25,"ARIAL",10,0,0,"1000",""
0,"lt. Comp:",122,25,"ARIAL",8,0,0,"1000"
3,"COS","UltimoDeFechaFactura",139,25,"ARIAL",8,0,0,"0000",""
0,"Val. lt Comp:",158,25,"ARIAL",8,0,0,"1000"
3,"COS","UltimoDeTotal",180,25,"ARIAL",8,0,0,"0000",""
1, "lineaH2", 80, 30, 118, 30,,,




[FICAP]
[FIGRUP]

[CALCULS] 0
;"TotalF","COS","PrecioCoste","CAB1"
;"TotalP","COS","PrecioCoste","CAB2"
;"TotalI","COS","PrecioCoste","CAB3"
;"Total","COS","PrecioCoste","GENERAL"

[FIDOCUM]





