"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 Ventas", 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 _DiarioIvasVentas no la crea ningun .dbq y el listado
; salia vacio. Va aqui como subconsulta: una fila por tipo de IVA (1, 2 y 3), el Total solo en la primera.
; El IVA, el RE y el Total van con los nombres que pide el papel (Iva10, Re10, Total10) y el IRPF solo en la primera
; fila. Lleva CodCliente (el filtro por cliente no tenia columna) y NumSerieFactura (para que el motor pueda
; dejar fuera los tickets canjeados, r641).
"FROM (SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodCliente, NIF, FechaAsiento, Asiento, NOrden, NumSerieFactura, TIRPF, BaseImponible1 AS BaseImponible, Iva1 AS IvaP, TIva1 AS Iva10, RE1 AS ReP, TRE1 AS Re10, Total AS Total10 FROM VenFacturas WHERE BaseImponible1 <> 0 OR TIva1 <> 0 UNION ALL SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodCliente, NIF, FechaAsiento, Asiento, NOrden, NumSerieFactura, 0, BaseImponible2, Iva2, TIva2, RE2, TRE2, 0 FROM VenFacturas WHERE BaseImponible2 <> 0 OR TIva2 <> 0 UNION ALL SELECT FechaFactura, Seccion, NumFactura, NombreFiscal, CodCliente, NIF, FechaAsiento, Asiento, NOrden, NumSerieFactura, 0, BaseImponible3, Iva3, TIva3, RE3, TRE3, 0 FROM VenFacturas WHERE BaseImponible3 <> 0 OR TIva3 <> 0) AS DIV"
""

[CONDICIONS] 4
"Seccion","Seccin",0,1
"CodCliente","Cdigo Cliente",0,1
"FechaFactura","Fecha Natural",0,2
"FechaAsiento","Fecha Contable",0,2


[ORDENACIONS] 1
"NumFactura","Nmero Factura",0,1
" VAL(NumFactura) ","Numero de Factura",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", 5,0,"ARIAL",8,0,0,"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", "IVA10", 198,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "ReP", 205,0,"ARIAL",8,0,1,"0000",""
3, "COS", "Re10", 219,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "TIRPF", 235,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "Total10", 265,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 5
"TBI","COS","BaseImponible","GENERAL"
"TIVA","COS","Iva10","GENERAL"
"TRE","COS","Re10","GENERAL"
"TTIRPF","COS","TIRPF","GENERAL"
"T","COS","Total10","GENERAL"

[FIDOCUM]




