"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] 6
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]

[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 :",165,0,"ARIAL",8,0,0,"1000"
6,"Pagina",195,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",165,5,"ARIAL",8,0,0,"1000"
6,"Fecha",195,5,"ARIAL",8,0,1,"1000",""
0, "Proveedores ms de 3.005,06", 105, 7, "ARIAL", 20, 0, 2, "1000"
1, "lineaH1", 5, 17, 195, 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,"Cod. Postal",120,18,"ARIAL",8,0,1,"1000"
0,"B.Imponible",140,18,"ARIAL",8,0,1,"1000"
0,"IVA Mes",160,18,"ARIAL",8,0,1,"1000"
0,"RE Mes",175,18,"ARIAL",8,0,1,"1000"
0,"Total",195,18,"ARIAL",8,0,1,"1000"
1, "lineaH2", 5, 22, 195, 22,,,
[FICAP]

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

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT ComFacturas.CodProveedor, First(ComFacturas.CodigoPostal) AS CodPostal, Sum(IIf([BaseImponible1] Is Null,0,[BaseImponible1])+IIf([BaseImponible2] Is Null,0,[BaseImponible2])+IIf([BaseImponible3] Is Null,0,[BaseImponible3])) AS BI, Sum(IIf([TIva1] Is Null,0,[TIva1])+IIf([TIva2] Is Null,0,[TIva2])+IIf([TIva3] Is Null,0,[TIva3])) AS IVA, Sum(IIf([TRE1] Is Null,0,[TRE1])+IIf([TRE2] Is Null,0,[TRE2])+IIf([TRE3] Is Null,0,[TRE3])) AS RE, Sum(ComFacturas.Total) AS SumaDeTotal, Proveedores.NIF, Proveedores.NombreFiscal"
"FROM ComFacturas INNER JOIN Proveedores ON ComFacturas.CodProveedor = Proveedores.CodProveedor"
"GROUP BY ComFacturas.CodProveedor, Proveedores.NIF, Proveedores.NombreFiscal
HAVING (((Sum(ComFacturas.Total))>=3005.06))"

[CONDICIONS] 3
"ComFacturas.CodProveedor","Codigo",0,1, -10
"Seccion","Seccin",0,1
"FechaFactura","Fecha",0,2
;"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"

[ORDENACIONS] 2
"ComFacturas.CodProveedor", "Codigo Proveedor", 3
"NombreFiscal", "Nombre Proveedor", 3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 8
3,"COS","CodProveedor",5,0,"ARIAL",8,0,0,"0000",""
3,"COS","NombreFiscal",25,0,"ARIAL",8,50,0,"0000",""
3,"COS","NIF",80,0,"ARIAL",8,0,0,"0000",""
3,"COS","CodPostal",115,0,"ARIAL",8,0,1,"0000",""
3,"COS","BI",140,0,"ARIAL",8,30,1,"0000","Total"
3,"COS","IVA",160,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","RE",175,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","SumaDeTotal",195,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 1
"T2","COS","SumaDeTotal","GENERAL"

[FIDOCUM]



