"VER1.0","Articulos","Listado de Movimientos articulos"
;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] 1
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
;3,"CABECERA","Domicilio",10,8,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Direc",10,11,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Provincia",10,14,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Tel",10,17,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Nif",10,20,"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] 11
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, "Listado de compra por familia y subfamilia", 105, 7, "ARIAL", 18, 0, 2, "1000"
1,"lineaH1",5,17,200,17,,,
0,"Cod Articulo",5,18,"ARIAL",10,0,0,"1000"
0,"Descripcin",40,18,"ARIAL",10,0,0,"1000"
0,"Cantidad",150,18,"ARIAL",10,0,1,"1000"
0,"Total",190,18,"ARIAL",10,0,1,"1000"
1,"lineaH2",5,22,200,22,,,
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
0,"Total",120,3,"ARIAL",10,0,1,"1000"
1, "Cuadrototal", 105, 0, 200, 9, 1, 0,
5,0,"Total4",142,3,"ARIAL",10,0,0,"1000",""
5,0,"Total3",176,3,"ARIAL",10,0,0,"1000","Total"
[FIPEU]



[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT CodFamilia & ' - ' & Descripcion as titulo, *"
"FROM Familias"
""
[CONDICIONS] 1
"CodFamilia","Codigo de Familia",0,1
;"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"

[ORDENACIONS] 0
;"CodArticulo","Codigo artculo",3
;"Descripcion","Descripcion",3

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

[PEU]
0, 8, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
0,"Total : ",120,0,"ARIAL",10,0,0,"1000"
5, 0,"Total2",150,0,"ARIAL",10,0,1,"1000",""
5, 0,"Total1",190,0,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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



;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT Articulos.CodFamilia, Articulos.CodSubFamilia, Sum(ComAlbaLin.Cantidad) AS SumaDeCantidad, Sum(ComAlbaLin.Total) AS SumaDeTotal, SubFamilias.Descripcion"
"FROM (((Proveedores INNER JOIN ComAlbaLin ON Proveedores.CodProveedor = ComAlbaLin.CodProveedor) INNER JOIN ComAlba ON (ComAlbaLin.Seccion = ComAlba.Seccion) AND (ComAlbaLin.NumAlbaran =ComAlba.NumAlbaran) AND (ComAlbaLin.CodProveedor = ComAlba.CodProveedor)) LEFT JOIN Articulos ON ComAlbaLin.CodArticulo = Articulos.CodArticulo) LEFT JOIN SubFamilias ON Articulos.CodSubFamilia = SubFamilias.CodSubFamilia"
"GROUP BY Articulos.CodFamilia, Articulos.CodSubFamilia, SubFamilias.Descripcion"


[CONDICIONS] 5
"CodFamilia","Codigo",1,1,"CAB1","CodFamilia"
"TipoArticulo","Tipo de Articulo",0,1
"CodSubFamilia","Codigo de Subfamilia",0,1
"FechaAlbaran","Fecha",0,2
"Facturado","Facturado (S/N)",0,5
;"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"

[ORDENACIONS] 0
;"CodArticulo","Codigo artculo",3
;"Descripcion","Descripcion",3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
3,"COS","CodSubFamilia",5,0,"ARIAL",10,0,0,"0000",""
3,"COS","Descripcion",40,0,"ARIAL",10,0,0,"0000",""
3,"COS","SumaDeCantidad",150,0,"ARIAL",10,0,1,"0000",""
3,"COS","SumaDeTotal",190,0,"ARIAL",10,0,1,"0000","Total"
[FICAP]




[FIGRUP]


[CALCULS] 4
"Total1","COS","SumaDeTotal","CAB1"
"Total2","COS","SumaDeCantidad","CAB1"
"Total3","COS","SumaDeTotal","GENERAL"
"Total4","COS","SumaDeCantidad","GENERAL"

[FIDOCUM]


