"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]
[CAPSALERA]
10, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 17
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",""
0, "Estado Amortizaciones", 95, 7, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,17,200,17,,,
0,"Inversion",5,18,"ARIAL",8,0,0,"1000"
0,"Cuenta",23,18,"ARIAL",8,0,0,"1000"
0,"Ficha",48,18,"ARIAL",8,0,1,"1000"
0,"F.Compra",54,18,"ARIAL",8,0,0,"1000"
0,"Inmovilizado",69,18,"ARIAL",8,0,0,"1000"
0,"Compra",137,18,"ARIAL",8,0,1,"1000"
0,"Tipo",139,18,"ARIAL",8,0,0,"1000"
0,"Amort.",161,18,"ARIAL",8,0,1,"1000"
0,"Reali.",179,18,"ARIAL",8,0,1,"1000"
0,"Pendi.",198,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",5,22,200,22,,,
[FICAP]

[PEU]
0, 0, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Totales:",5,0,"ARIAL",8,0,0,"1000"
;5,0,"TIVA", 165,0,"ARIAL",8,0,1,"1000","Total"
;5,0,"T",200,10,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT  * "
"FROM Secciones"
""
[CONDICIONS] 1
"Seccion","Seccin",0,1

[ORDENACIONS] 1
"Seccion","Seccion",3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB1","NombreSeccion",10,0,"ARIAL",10,0,0,"1001",""
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 5
0,"Total Seccion : ",80, 2,"ARIAL",12,0,0,"1000"
5,0,"TC",137, 2,"ARIAL",10,0,1,"1000" ,"Total"
5,0,"TA",161, 2,"ARIAL",10,0,1,"1000" ,"Total"
5,0,"TR",179, 2,"ARIAL",10,0,1,"1000" ,"Total"
5,0,"TP",198, 2,"ARIAL",10,0,1,"1000" ,"Total"
[FIPEU]
[FIGRUP]


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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB3", #FALSE#
"SELECT I_Amortizacion.SubInmovilizado, SubCuentas.Titulo "
" FROM I_Amortizacion INNER JOIN SubCuentas ON I_Amortizacion.SubInmovilizado = SubCuentas.CodCuenta WHERE I_Amortizacion.FechaBaja IS NULL AND I_Amortizacion.ImpAmortizado<I_Amortizacion.ImpCompra"
" GROUP BY I_Amortizacion.SubInmovilizado, SubCuentas.Titulo"

[CONDICIONS] 1
"Seccion", "Seccion", 1, 1, "CAB1", "Seccion"
;"SubAmortizacion", "SubAmortizacion", 1, 1, "CAB2", "SubAmortizacion"
;" Calculo<>0 ","",4

[ORDENACIONS] 0
;"SubAmortizacion","SubAmortizacion",3

[CAPSALERA]
0, 1, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;;3,"CAB1","NombreSeccion",10,0,"ARIAL",10,0,0,"1001",""
[FICAP]

[PEU]
0, 7, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 7
0,"Total ",5, 1,"ARIAL",10,0,0,"1000"
3, "CAB3", "SubInmovilizado", 17,1,"ARIAL",10,0,0,"1000",""
3, "CAB3", "Titulo", 38,1,"ARIAL",10,0,0,"1000",""
5,0,"ToC",137, 1,"ARIAL",10,0,1,"1000" ,"Total"
5,0,"ToA",161, 1,"ARIAL",10,0,1,"1000" ,"Total"
5,0,"ToR",179, 1,"ARIAL",10,0,1,"1000" ,"Total"
5,0,"ToP",198, 1,"ARIAL",10,0,1,"1000" ,"Total"
[FIPEU]
[FIGRUP]


;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
" SELECT *, IIF(Meses>0, ImpCompra*12/Meses, ImpCompra*Tipo/100) AS AmortiA, IIF(Meses>0, 1200.0/Meses, Tipo) AS TipoAnual, ImpCompra-ImpAmortizado AS Pendi "
" FROM I_Amortizacion WHERE ImpAmortizado<ImpCompra AND FechaBaja IS NULL "
""

[CONDICIONS] 2
"Seccion", "Seccion", 1, 1, "CAB1", "Seccion"
"SubInmovilizado", "SubInmovilizado", 1, 1, "CAB3", "SubInmovilizado"
;"FechaFactura","Fecha",0,2

[ORDENACIONS] 0
;"FechaFactura, NumFactura","Fecha Factura",3


[CAPSALERA]
0, 4.5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 10
3, "COS", "SubAmortizacion", 5,0,"ARIAL",8,0,0,"0000",""
3, "COS", "SubInmovilizado", 23,0,"ARIAL",8,85,0,"0000",""
3, "COS", "CodInventario", 41,0,"ARIAL",8,0,0,"0000",""
3, "COS", "Fecha Compra", 54,0,"ARIAL",8,115,0,"0000",""
3, "COS", "Concepto", 69,0,"ARIAL",8,115,0,"0000",""
3, "COS", "ImpCompra", 137,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "TipoAnual", 148,0,"ARIAL",8,0,1,"0000",""
3, "COS", "AmortiA", 161,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "ImpAmortizado", 179,0,"ARIAL",8,0,1,"0000","Total"
3, "COS", "Pendi", 198,0,"ARIAL",8,0,1,"0000","Total"
;8, "1", "Campo('COS','ImpCompra')*Campo('COS','Tipo')/100", 165,0,"ARIAL",8,0,1,"0000","Total"
;3, "COS", "ImpAmortizado", 182,0,"ARIAL",8,0,1,"0000","Total"
;8, "1", "Campo('COS','ImpCompra')+(Campo('COS','ImpAmortizado')*-1)", 198,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 8
"ToC","COS","ImpCompra","CAB3"
"ToA","COS","AmortiA","CAB3"
"ToR","COS","ImpAmortizado","CAB3"
"ToP","COS","Pendi","CAB3"
"TC","COS","ImpCompra","CAB1"
"TA","COS","AmortiA","CAB1"
"TR","COS","ImpAmortizado","CAB1"
"TP","COS","Pendi","CAB1"
[FIDOCUM]




