"VER1.0","Albaranes","Listado de Facturas"
;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] 2
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,8,"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] 16
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, "Bienes de Inversion", 95, 7, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,17,195,17,,,
0,"NOrden",17,18,"ARIAL",8,0,1,"1000"
0,"Fecha",20,18,"ARIAL",8,0,0,"1000"
0,"N Fac.",35,18,"ARIAL",8,0,0,"1000"
0,"Nombre",50,18,"ARIAL",8,0,0,"1000"
0,"NIF",119,18,"ARIAL",8,0,0,"1000"
0,"Base Imp.",155,18,"ARIAL",8,0,1,"1000"
0,"I%",162,18,"ARIAL",8,0,1,"1000"
0,"IVA",178,18,"ARIAL",8,0,1,"1000"
0,"Total",195,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",5,22,195,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] 4
0,"Totales:",55,2,"ARIAL",8,0,0,"1000"
5,0,"TBI", 155,2,"ARIAL",8,0,1,"1000","Total"
5,0,"TIVA", 178,2,"ARIAL",8,0,1,"1000","Total"
5,0,"T",195,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 Apuntes.CodCuenta, Apuntes.CantidadD-Apuntes.CantidadH AS BaseImponible, INT((Apuntes.CantidadD-Apuntes.CantidadH)*Iva1+.5)/100 AS IVA, * "
"FROM ComFacturas INNER JOIN Apuntes ON ComFacturas.Asiento = Apuntes.Asiento AND ComFacturas.FechaAsiento = Apuntes.FechaAsiento AND ComFacturas.Seccion = Apuntes.Seccion WHERE LEFT(Apuntes.CodCuenta, 1) = '2' "
""

[CONDICIONS] 5
"Apuntes.Seccion","Seccin",0,1
"NumFactura","N Factura",0,0
"NOrden","N de Orden",0,0
"FechaFactura","Fecha Factura",0,2
"ComFacturas.FechaAsiento","Fecha Contable",0,2

[ORDENACIONS] 2
" VAL(NumFactura) ","Numero Factura",3
" 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] 9
3, "COS", "NOrden", 17,0,"ARIAL",8,0,1,"0000",""
3, "COS", "FechaFactura", 20,0,"ARIAL",8,0,0,"0000",""
3, "COS", "NumFactura", 35,0,"ARIAL",8,0,0,"0000",""
3, "COS", "NombreFiscal", 50,0,"ARIAL",8,68,0,"0000",""
3, "COS", "Nif", 119,0,"ARIAL",8,0,0,"0000",""
3, "COS", "BaseImponible", 155,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "Iva1", 162,0,"ARIAL",8,0,1,"0000",""
3, "COS", "IVA", 178,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "Total", 195,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 3
"TBI","COS","BaseImponible","GENERAL"
"TIVA","COS","IVA","GENERAL"
"T","COS","Total","GENERAL"

[FIDOCUM]




