"VER1.0","Extractos","Extracto de cuentas"
;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,2,"ARIAL",14,0,0,"1000",""
3,"CABECERA","Nif",10,8,"ARIAL",8,0,0,"1000",""
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total General",160,0,"ARIAL",12,0,1,"1000"
;5,0,"Total",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]
[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] 14
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, "Extracto de cuentas", 105, 3, "ARIAL", 22, 0, 2, "1000"
1,"lineaH1",8,17,197,17,,,
0,"Fecha", 10,18,"ARIAL",10,0,0,"1000"
0,"Asiento", 40,18,"ARIAL",10,0,1,"1000"
0,"Apunte", 55,18,"ARIAL",10,0,1,"1000"
0,"Descripcin", 65,18,"ARIAL",10,0,0,"1000"
0,"Debe", 153,18,"ARIAL",10,0,1,"1000"
0,"Haber", 175,18,"ARIAL",10,0,1,"1000"
0,"Saldo", 197,18,"ARIAL",10,0,1,"1000"
1,"lineaH2",8,22,197,22,,,
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FIPEU]

[FIGRUP]

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


;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB2", #FALSE#
"SELECT CodCuenta & ' - ' & Titulo as Titulo2,  CodCuenta "
"FROM SubCuentas "
""
[ORDENACIONS] 0
;"CodFamilia", "Codigo Familia", 3

[CONDICIONS] 2
"CodCuenta","Cuenta",0,1, -10
"Titulo","Titulo",0,1

[CAPSALERA]
0, 6, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB2","Titulo2",15,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] 4
0,"Totales .......  :",130,0,"ARIAL",10,0,1,"1000"
5,0,"TD",153,0,"ARIAL",10,0,1,"1000","Total"
5,0,"TH",175,0,"ARIAL",10,0,1,"1000","Total"
5,0,"TS",197,0,"ARIAL",10,0,1,"1000","Total"
[FIPEU]
[FIGRUP]


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


;tipo, NomGrup, Select, From, GropBy
;[GRUP]
;2,"CAB3", #FALSE#
;[CAPSALERA]
;0, 6, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
;[CAMPS] 2
;0, "Saldo Anterior : ", 130, 1, "ARIAL", 10, 0, 1, "1000"
;3, "CAB3", "Saldo", 195, 0, "ARIAL", 10, 0, 1, "1000", "Total"
;3, "CAB3", "SumaD", 180, 0, "ARIAL", 10, 0, 1, "1000", "Total"
;3, "CAB3", "SumaH", 200, 0, "ARIAL", 10, 0, 1, "1000", "Total"
;[FICAP]
;
;[PEU]
;0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
;[CAMPS] 0
;0, "Totales Periodo: ", 156, 1, "ARIAL", 10, 0, 1, "1000"
;5, 0, "TD", 180, 1, "ARIAL", 10, 0, 1, "1000", "Total"
;5, 0, "TH", 200, 1, "ARIAL", 10, 0, 1, "1000", "Total"
;0, "Saldo Periodo: ", 35, 1, "ARIAL", 10,  0,  0, "1000"
;8, "1", "Calculo('TD') + Calculo('TH')*-1", 90, 1, "ARIAL",10,0,1,"1000","Total"
;0, "Totales Acumulados: ", 156, 6, "ARIAL", 10, 0, 1, "1000"
;3, "CAB3", "SumaD", 180, 6, "ARIAL", 10, 0, 1, "1000", "Total"
;3, "CAB3", "SumaH", 200, 6, "ARIAL", 10, 0, 1, "1000", "Total"
;0, "Saldo Actual: ", 35, 6, "ARIAL", 10,  0,  0, "1000"
;8, "1", "Campo('CAB3','SumaD') + Campo('CAB3','SumaH')*-1", 90, 6, "ARIAL",10,0,1,"1000","Total"
;;
;;0,"Total Proveedor",140,0,"ARIAL",10,0,0,"0001"
;;5,0,"TotalP",170,0,"ARIAL",10,0,0,"1000","Total"
;;
;;0, "Totales Acumulados: ", 156, 6, "ARIAL", 10, 0, 1, "1000"
;;8, "1", "Calculo('TD') + Campo('CAB3','SumaD')", 180, 6, "ARIAL",10,0,1,"1000","Total"
;;8, "1", "Calculo('TH') + Campo('CAB3','SumaH')", 200, 6, "ARIAL",10,0,1,"1000","Total"
;;0, "Saldo Ac.", 55, 6, "ARIAL", 10,  0,  0, "1000"
;;8, "1", "Calculo('TD') + Campo('CAB3','SumaD') + (Calculo('TH') +Campo('CAB3','SumaH'))*-1", 90, 6, "ARIAL",10,0,1,"1000","Total"
;[FIPEU]
;[FIGRUP]



;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"PARAMETERS XXXI Text, XXXF Text, FFAI Datetime, FFAF Datetime, FFDI Datetime, FFDF Datetime, SSSI Text, SSSF Text; SELECT CodCuenta,  (FFDI-1) AS FechaAsiento, 0 AS Asiento, 0 AS Apunte, 'Saldo Inicial' AS Descripcion, Sum(CantidadD) AS SumaD, Sum(CantidadH) AS SumaH,  SumaD-SumaH AS Saldo FROM Apuntes WHERE CodCuenta=XXXI AND Seccion>=SSSI AND Seccion<=SSSF AND FechaAsiento>=FFAI AND FechaAsiento<=(FFDI-1) GROUP BY CodCuenta "
" UNION SELECT CodCuenta, FechaAsiento, Asiento, Apunte, Descripcion, CantidadD, CantidadH, CantidadD-CantidadH FROM Apuntes WHERE CodCuenta=XXXI AND Seccion>=SSSI AND Seccion<=SSSF AND FechaAsiento>=FFDI AND FechaAsiento<=FFDF"
""

[CONDICIONS] 4
"XXX", "CodCuenta", 1, 1, "CAB2", "CodCuenta"
"FFA", "Fecha Acumulado", 0, 2
"FFD", "Fecha", 0, 2
"SSS", "Seccion", 0, 1

[ORDENACIONS] 1
"FechaAsiento, Asiento, Apunte","Fecha, Asiento, Apunte",3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 7
3, "COS", "FechaAsiento", 22,0,"ARIAL",10,0,1,"0000",""
3, "COS", "Asiento", 40,0,"ARIAL",10,0,1,"0000",""
3, "COS", "Apunte", 55,0,"ARIAL",10,0,1,"0000",""
3, "COS", "Descripcion", 65,0,"ARIAL",10,65,0,"0000",""
3, "COS", "SumaD", 153,0,"ARIAL",10,0,1,"0000","Total"
3, "COS", "SumaH", 175,0,"ARIAL",10,0,1,"0000","Total"
8, "1", "CALCULO('TS')", 197, 0, "ARIAL", 10, 0, 1, "0000", "Total"
;8, "1", "CAMPO('COS','Saldo')+CALCULO('TD')+CALCULO('TH')*-1", 195, 0, "ARIAL", 10, 0, 1, "0000", "Total"
[FICAP]
[FIGRUP]

[CALCULS] 3
"TD","COS","SumaD","CAB2"
"TH","COS","SumaH","CAB2"
"TS","COS","Saldo","CAB2"

[FIDOCUM]


