"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] 1
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,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, 28, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 16
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, 7, "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#
; 3/11 (auditoria de listados): la poblacion sale de CodigosPostales; Direcciones no tiene columna Ciudad y
; la consulta fallaba entera ("no value given"): el listado salia sin direccion ni poblacion.
"SELECT Clientes.CodCliente, Clientes.Nombre, Clientes.NIF, Clientes.PersonaContacto, Clientes.CargoContacto, Clientes.Telefono, Clientes.Fax, Direccion.CodPostal & ' - ' & CodigosPostales.Ciudad as pobla, Direccion.Direccion, Clientes.CodRepresentante "
"FROM (Clientes Left JOIN Direccion ON (Clientes.CodDireccion = Direccion.CodDireccion) AND (Clientes.CodCliente = Direccion.CodCliente)) LEFT JOIN CodigosPostales ON (Direccion.CodPais = CodigosPostales.CodPais) AND (Direccion.CodPostal = CodigosPostales.CodPostal)"
""
[CONDICIONS] 3
"Clientes.CodCliente","Codigo",0,1, -10
"Clientes.Nombre","Nombre",0,1
"Clientes.CodRepresentante", "Cod Representante", 0, 1
;"CodFamilia", "Cod", 1, 1, "CAB1", "CodFamilia"
;"CodProveedor", "proveedor", 1, 1, "CAB2", "CodProveedor"
;"CodIva", "Iva", 1, 1, "CAB3", "CodIva"

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

[CAPSALERA]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 9
3,"COS","CodCliente",5,0,"ARIAL",8,0,0,"1000",""
3,"COS","Nombre",25,0,"ARIAL",8,50,0,"1000",""
3,"COS","NIF",80,0,"ARIAL",8,0,0,"0000",""
3,"COS","PersonaContacto",100,0,"ARIAL",8,0,0,"0000",""
3,"COS","CargoContacto",140,0,"ARIAL",8,0,0,"0000",""
3,"COS","Direccion",25,5,"ARIAL",8,0,0,"0000",""
3,"COS","Pobla",140,5,"ARIAL",8,0,0,"0000",""
3,"COS","Telefono",185,0,"ARIAL",8,0,0,"0000",""
3,"COS","Fax",185,5,"ARIAL",8,0,0,"0000",""
[FICAP]
[FIGRUP]

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

[FIDOCUM]





