"VER1.0","Clientes","Listado de Clientes"
;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, 10, #FALSE#, 0, #TRUE#, #FALSE#, 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]

[PEU]
0, 10, #TRUE#, 2, #TRUE#, #FALSE#, 0
; 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]
0, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 14
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, "Ventas por Secciones", 105, 3, "ARIAL", 20, 0, 2, "1000"
0, "Alb.", 10, 18, "ARIAL", 8, 0, 0, "1000"
0, "Fecha", 20, 18, "ARIAL", 8, 0, 0, "1000"
0, "Cod", 40, 18, "ARIAL", 8, 0, 0, "1000"
0, "Descripcin", 80, 18, "ARIAL", 8, 0, 0, "1000"
0, "Base Imp.", 150, 18, "ARIAL", 8, 0, 1, "1000"
0, "Iva", 170, 18, "ARIAL", 8, 0, 1, "1000"
0, "R.E.", 180, 18, "ARIAL", 8, 0, 1, "1000"
0, "Total", 200, 18, "ARIAL", 8, 0, 1, "1000"
1, "lineaH1", 5, 17, 200, 17,,,
1, "lineaH2", 5, 22, 200, 22,,,
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
0,"Total Acumulado: ",80, 5,"ARIAL",12,0,0,"1001"
5,0,"TotalM",200, 5,"ARIAL",12,0,1,"1001" ,"Total"
[FIPEU]

[FIGRUP]

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



;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT  * "
"FROM Secciones"
""
[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] 3
0,"Total : ",80, 5,"ARIAL",12,0,0,"1001"
5,0,"TotalBI",150, 5,"ARIAL",12,0,1,"1001" ,"Total"
5,0,"Total1",200, 5,"ARIAL",12,0,1,"1001" ,"Total"
[FIPEU]
[FIGRUP]


;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT VenAlba.FechaAlbaran, VenAlbaLin.* , (VenAlbaLin.Total*iif([VenAlbaLin.Iva] is null,0,[VenAlbaLin.Iva]))/100+VenAlbaLin.Total as TotalReal"
"FROM VenAlba INNER JOIN VenAlbaLin ON (VenAlba.Seccion = VenAlbaLin.Seccion) AND (VenAlba.CodCliente = VenAlbaLin.CodCliente) AND (VenAlba.NumAlbaran = VenAlbaLin.NumAlbaran)"
""
[CONDICIONS] 2
"FechaAlbaran","Fecha",0,2
"VenAlbaLin.Seccion","Seccion",1,1,"CAB1","Seccion"

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 8
3,"COS","NumAlbaran",10,0,"ARIAL",8,0,0,"0000",""
3,"COS","FechaAlbaran",20,0,"ARIAL",8,0,0,"0000",""
3,"COS","CodArticulo",40,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",70,0,"ARIAL",8,60,0,"0000",""
3,"COS","Total",150,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","Iva",170,0,"ARIAL",8,0,1,"0000",""
3,"COS","Recargo",180,0,"ARIAL",8,0,1,"0000",""
3,"COS","TotalReal",200,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 3
"TotalBI","COS","Total","CAB1"
"Total1","COS","TotalReal","CAB1"
"TotalM","COS","TotalReal","GENERAL"
[FIDOCUM]

