"VER1.0","Albaranes","Listado de Facturas"
;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] 4
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,8,"ARIAL",8,0,0,"1000",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"ARIAL",8,0,0,"1000",""
[FICAP]

[FIGRUP]

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

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]

[CONDICIONS] 1
"@PAG", "Nmero Pagina :", 9, "", ""

[CAPSALERA]
10, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 19
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, "Diario de Iva Compras", 95, 3, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,17,265,17,,,
0,"NOrden",17,18,"ARIAL",8,0,1,"1000"
0,"Fecha",25,18,"ARIAL",8,0,0,"1000"
0,"N Fac.",45,18,"ARIAL",8,0,0,"1000"
0,"Nombre",70,18,"ARIAL",8,0,0,"1000"
0,"NIF",139,18,"ARIAL",8,0,0,"1000"
0,"Base Imp.",180,18,"ARIAL",8,0,1,"1000"
0,"I%",185,18,"ARIAL",8,0,1,"1000"
0,"IVA",198,18,"ARIAL",8,0,1,"1000"
0,"R%",205,18,"ARIAL",8,0,1,"1000"
0,"IRPF",235,18,"ARIAL",8,0,1,"1000"
0,"RE",215,18,"ARIAL",8,0,1,"1000"
0,"Total",265,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",5,22,265,22,,,
;0,"%RE",155,18,"ARIAL",8,0,1,"1000"
[FICAP]

[PEU]
0, 5, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
0,"Totales:",5,2,"ARIAL",8,0,0,"1000"
5,0,"TBI", 180,2,"ARIAL",8,0,1,"1000","Total"
5,0,"TIVA", 198,2,"ARIAL",8,0,1,"1000","Total"
5,0,"TRE", 219,2,"ARIAL",8,0,1,"1000","Total"
5,0,"TTIRPF", 235,2,"ARIAL",8,0,1,"1000","Total"
5,0,"T",265,2,"ARIAL",9,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
;"SELECT *, BaseImponible + iif(Iva is null,0,Iva)+iif(Re is null,0,Re) as TotalL "
[GRUP]
3,"COS", #FALSE#
"SELECT * "
; 3/11 (auditoria de listados): la consulta guardada _DiarioIvasComprasIRPF no la crea ningun .dbq (estaba en
; postgres\Actualiza.DBQ, que el programa no lee) y el listado salia vacio. Va aqui como subconsulta: una
; fila por cada tipo de IVA de la factura (1, 2 y 3); el Total y el IRPF solo en la primera, para que el pie no los
; sume dos veces (IrpfFactura lleva el IRPF en todas, para poder filtrar por el).
; UNION ALL y no UNION: dos lineas de IVA iguales de la misma factura no se pueden juntar en una.
"FROM (SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodProveedor, NIF, FechaAsiento, Asiento, NOrden, TIRPF AS IrpfFactura, TIRPF, BaseImponible1 AS BaseImponible, Iva1 AS IvaP, TIva1 AS Iva, RE1 AS ReP, TRE1 AS Re, Total FROM ComFacturas WHERE BaseImponible1 <> 0 OR TIva1 <> 0 UNION ALL SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodProveedor, NIF, FechaAsiento, Asiento, NOrden, TIRPF, 0, BaseImponible2, Iva2, TIva2, RE2, TRE2, 0 FROM ComFacturas WHERE BaseImponible2 <> 0 OR TIva2 <> 0 UNION ALL SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodProveedor, NIF, FechaAsiento, Asiento, NOrden, TIRPF, 0, BaseImponible3, Iva3, TIva3, RE3, TRE3, 0 FROM ComFacturas WHERE BaseImponible3 <> 0 OR TIva3 <> 0) AS DIC"
""

[CONDICIONS] 5
"Seccion","Seccin",0,1
"CodProveedor","Cdigo Proveedor",0,1
"NOrden","Numero de Orden",0,0
"FechaFactura","Fecha Natural",0,2
"FechaAsiento","Fecha Contable",0,2

[ORDENACIONS] 1
" VAL(NOrden) ","Numero de Orden",3


[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 12
3, "COS", "NOrden", 17,0,"ARIAL",8,0,1,"0000",""
3, "COS", "FechaFactura", 25,0,"ARIAL",8,0,0,"0000",""
3, "COS", "NumFactura", 45,0,"ARIAL",8,0,0,"0000",""
3, "COS", "NombreFiscal", 70,0,"ARIAL",8,58,0,"0000",""
3, "COS", "Nif", 139,0,"ARIAL",8,0,0,"0000",""
3, "COS", "BaseImponible", 180,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "IVAP", 185,0,"ARIAL",8,0,1,"0000",""
3, "COS", "IVA", 198,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "ReP", 205,0,"ARIAL",8,0,1,"0000",""
3, "COS", "Re", 219,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "TIRPF", 235,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "Total", 265,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 5
"TBI","COS","BaseImponible","GENERAL"
"TIVA","COS","Iva","GENERAL"
"TRE","COS","Re","GENERAL"
"TTIRPF","COS","TIRPF","GENERAL"
"T","COS","Total","GENERAL"

[FIDOCUM]




