"VER1.0","Proveedores","Listado de Proveedores"
;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, 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 Proveedores", 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#
"SELECT First(Proveedores.TipoTarifa) AS PrimeroDeTipoTarifa, First(Proveedores.DescuentoPP) AS PrimeroDeDescuentoPP, First(Proveedores.CodIva) AS PrimeroDeCodIva, First(Direccion.CodPostal & ' - ' & Direccion.Ciudad) AS pobla, First(Direccion.Direccion) AS PrimeroDeDireccion, First(Proveedores.CodRepresentante) AS PrimeroDeCodRepresentante, First(Proveedores.CodFormaPago) AS PrimeroDeCodFormaPago, First(Representantes.Nombre) AS PrimeroDeNombre, First(CuentasBanc.CodCuenta) AS PrimeroDeCodCuenta, First(CuentasBanc.CodEntidad) AS PrimeroDeCodEntidad, First(CuentasBanc.CodOficina) AS PrimeroDeCodOficina, First(CuentasBanc.NumCuenta) AS PrimeroDeNumCuenta, First(CuentasBanc.DC) AS PrimeroDeDC, First(CuentasBanc.BIC) AS PrimeroDeBIC, First(CuentasBanc.IBAN) AS PrimeroDeIBAN, First(Agencias.NombreAgencia) AS PrimeroDeNombreAgencia, First(CuentasBanc.FechaFirma) AS PrimeroDeFechaFirma, Proveedores.CodProveedor as Client, Proveedores.CodProveedor, First(Proveedores.Nombre) AS PrimeroDeNombre1, First(Proveedores.NombreFiscal) AS PrimeroDeNombreFiscal, First(Proveedores.NIF) AS PrimeroDeNIF, First(Proveedores.PersonaContacto) AS PrimeroDePersonaContacto, First(Proveedores.CargoContacto) AS PrimeroDeCargoContacto,  First(Proveedores.Telefono) AS PrimeroDeTelefono, First(Proveedores.FAX) AS PrimeroDeFAX, First(Proveedores.Mail) AS PrimeroDeMail, First(Proveedores.Web) AS PrimeroDeWeb, First(Proveedores.mailEnvio) AS PrimeroDemailEnvio, First(Proveedores.CodFormaPago) AS PrimeroDeCodFormaPago1, First(Proveedores.CodTipoPago) AS PrimeroDeCodTipoPago, First(Proveedores.CodRepresentante) AS PrimeroDeCodRepresentante1, First(Representantes.Nombre) AS PrimeroDeNombre2, First(Proveedores.CodAgenciaTransporte) AS PrimeroDeCodAgenciaTransporte, First(Agencias.NombreAgencia) AS PrimeroDeNombreAgencia1, First(Proveedores.Observaciones) AS PrimeroDeObservaciones, Sum(ComFacturas.Total) AS SumaDeTotal, Max(ComFacturas.FechaFactura) AS UltimoDeFechaFactura, Max(ComFacturas.Total) AS UltimoDeTotalFactura , Count(ComFacturas.Total) AS NumeroDeFactura"
"FROM ((((Proveedores LEFT JOIN Direccion ON (Proveedores.CodProveedor = Direccion.CodCliente) AND (Proveedores.CodDireccion = Direccion.CodDireccion)) LEFT JOIN Representantes ON Proveedores.CodRepresentante = Representantes.CodRepresentante) LEFT JOIN CuentasBanc ON (Proveedores.CodProveedor = CuentasBanc.CodCliente) AND (Proveedores.CodCuentaBancaria = CuentasBanc.CodCuenta)) LEFT JOIN Agencias ON Proveedores.CodAgenciaTransporte = Agencias.CodAgencia) LEFT JOIN ComFacturas ON Proveedores.CodProveedor = ComFacturas.CodProveedor "
" GROUP BY Proveedores.CodProveedor"

[CONDICIONS] 5
"Proveedores.CodProveedor","Codigo Prov.",0,1, -10
"Proveedores.Nombre","Nombre",0,1
"Proveedores.CodRepresentante", "Cod Representante", 0, 1
"Proveedores.CodFormaPago", "Cod Forma Pago", 0, 1
"FechaFactura", "Fecha", 0, 2
;Clientes.CodRepresentante"PrimeroDeCodRepresentante", "Cod Representante", 0, 1

;"CodFamilia", "Cod", 1, 1, "CAB1", "CodFamilia"
;"CodProveedor", "proveedor", 1, 1, "CAB2", "CodProveedor"
;"CodIva", "Iva", 1, 1, "CAB3", "CodIva"

[ORDENACIONS] 3
"Proveedores.CodProveedor","Codigo Prov",3
"PrimeroDeNombre1","Nombre",3
"PrimeroDeCodPostal","Cod. Postal",3
;"UltimoDeFechaFactura", "Fecha", 3



[CAPSALERA]
0, 60, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 71
0,"Cdigo:",5,0,"ARIAL",8,0,0,"1000"
3,"COS","CodProveedor",20,0,"ARIAL",8,0,0,"0000",""
0,"Nombre:",45,0,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeNombre1",60,0,"ARIAL",8,70,0,"1000",""
0,"N. Fiscal:",130,0,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeNombreFiscal",150,0,"ARIAL",8,40,0,"0000",""
0,"NIF:",5,5,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeNIF",20,5,"ARIAL",8,0,0,"0000",""
0,"Contacto:",45,5,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDePersonaContacto",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","PrimeroDeTelefono",145,5,"ARIAL",8,0,0,"0000",""
0,"FAX:",165,5,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeFax",180,5,"ARIAL",8,0,0,"0000",""
0,"Direccin:",5,10,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeDireccion",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","PrimeroDemail",17,15,"ARIAL",8,0,0,"0000",""
0,"eMail Envio:",75,15,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDemailEnvio",95,15,"ARIAL",8,0,0,"0000",""
0,"Web:",150,15,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeWeb",160,15,"ARIAL",8,0,0,"0000",""
0,"Cod. Forma Pago:",5,20,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeCodFormaPago",32,20,"ARIAL",8,0,0,"0000",""
0,"Cod. Tipo Pago:",40,20,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeCodTipoPago",65,20,"ARIAL",8,0,0,"0000",""
0,"Temporada:",74,20,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeTemporada",95,20,"ARIAL",8,0,0,"0000",""
0,"Ramo:",105,20,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDePropios2",120,20,"ARIAL",8,0,0,"0000",""
0,"Situacin:",130,20,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDePropios3",145,20,"ARIAL",8,0,0,"0000",""
0,"Entidad:",85,25,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeCodEntidad",98,25,"ARIAL",8,0,0,"0000",""
0,"Oficina",110,25,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeCodOficina",125,25,"ARIAL",8,0,0,"0000",""
0,"DC:",140,25,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeDC",150,25,"ARIAL",8,0,0,"0000",""
0,"Num.Cuenta:",165,25,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeNumCuenta",185,25,"ARIAL",8,0,0,"0000",""
0,"BIC:",5,25,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeBIC",12,25,"ARIAL",8,0,0,"0000",""
0,"IBAN:",32,25,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeIBAN",42,25,"ARIAL",8,0,0,"0000",""
0,"Fecha Firma:",165,20,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeFechaFirma",185,20,"ARIAL",8,0,0,"0000",""
0,"Representante:",5,30,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeNombre",29,30,"ARIAL",8,0,0,"0000",""
0,"Agencia Trans.:",80,30,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeNombreAgencia",104,30,"ARIAL",8,0,0,"0000",""
0,"Tipo Tarifa:",5,35,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeTipoTarifa",32,35,"ARIAL",8,0,0,"0000",""
0,"Descuento P.P.:",40,35,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeDescuentoPP",65,35,"ARIAL",8,0,0,"0000",""
0,"Tipo Iva:",74,35,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeCodIva",95,35,"ARIAL",8,0,0,"0000",""
0,"Observaciones:",5,45,"ARIAL",8,0,0,"1000"
3,"COS","PrimeroDeObservaciones",30,45,"ARIAL",8,0,0,"0000",""
0,"Total Facturado:",5,40,"ARIAL",8,0,0,"1000"
3,"COS","SumaDeTotal",30,40,"ARIAL",8,0,0,"0000",""
0,"Importe Factura Mayor:",46,40,"ARIAL",8,0,0,"1000"
3,"COS","UltimoDeTotalFactura",81,40,"ARIAL",8,0,0,"0000",""
0,"Fecha ltima factura:",100,40,"ARIAL",8,0,0,"1000"
3,"COS","UltimoDeFechaFactura",135,40,"ARIAL",8,0,0,"0000",""
0,"Cantidad de facturas:",155,40,"ARIAL",8,0,0,"1000"
3,"COS","NumeroDeFactura",188,40,"ARIAL",8,0,0,"0000",""
1, "lineaH2", 85, 55, 130, 55,,,

[FICAP]
[FIGRUP]

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

[FIDOCUM]





