"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] 2
3,"CABECERA","NombreComercial",10,2,"ARIAL",20,0,0,"1000",""
3,"CABECERA","Nif",10,9,"ARIAL",8,0,0,"1000",""
[FICAP]

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

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

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
5, 30, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 15
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, "Estadistica Ventas de Cliente", 105, 6, "ARIAL", 18, 0, 2, "1000"
1,"lineaH1", 5,22, 195,22,,,
0,"Cod.Articulo ", 5,23,"ARIAL",10,0,0,"1000"
0,"Descripcion", 30,23,"ARIAL",10,0,0,"1000"
0,"Albarn", 80,23,"ARIAL",10,0,0,"1000"
0,"Fecha", 100,23,"ARIAL",10,0,0,"1000"
0,"Seccion", 120,23,"ARIAL",10,0,0,"1000"
0,"Cantidad", 150,23,"ARIAL",10,0,1,"1000"
0,"Precio", 170,23,"ARIAL",10,0,1,"1000"
0,"Total", 190,23,"ARIAL",10,0,1,"1000"
1,"lineaH2",5,27, 195,27,,,
[FICAP]

[PEU]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total",150,0,"ARIAL",10,0,1,"1000"
;5,0,"Total",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB0", #FALSE#
"SELECT *"
"FROM Clientes"
""
[CONDICIONS] 1
"CodCliente","Codigo Cliente",0,1, -10
;"Nombre","Nombre",0,1

[ORDENACIONS] 1
"CodCliente","Codigo artculo",3
;"Descripcion","Descripcion",3

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
3,"CAB0","CodCliente",5,-13,"ARIAL",10,0,0,"1000",""
3,"CAB0","Nombre",35,-13,"ARIAL",10,100,0,"1000",""
[FICAP]

[PEU]
0, 10, #FALSE#, 2, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
1, "Cuadro", 115, 0, 195, 8, 1, 0,
0,"Total Cliente  . . . . . . . . . .    : ",120,2,"ARIAL",10,0,0,"1000"
5, 0,"TotalG",190,2,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT CodArticulo & ' - ' & Descripcion as titulo, *"
"FROM Articulos"
""
[CONDICIONS] 1
"CodArticulo","Codigo artculo",0,1
;"Descripcion","Descripcion",0,1

[ORDENACIONS] 1
"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,"1000",""
;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] 5
1,"lineaH1", 110, 0, 195, 0,,,
0,"Total Articulo: ",115, 1,"ARIAL",10,0,0,"1000"
5, 0,"TotalC",150, 1,"ARIAL",10,0,1,"1000","Cantidad"
8, "1", "DIV(CALCULO('TotalT'),CALCULO('TotalC')) ", 170, 1, "ARIAL", 10, 0, 1, "1000", "Precio"
5, 0,"TotalT",190, 1,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT Descripcion, Cantidad, Precio, VenAlbaLin.Total, VenAlbaLin.Seccion, VenAlbaLin.NumAlbaran, FechaAlbaran "
"FROM VenAlbaLin INNER JOIN VenAlba ON (VenAlbaLin.Seccion = VenAlba.Seccion) AND (VenAlbaLin.NumAlbaran = VenAlba.NumAlbaran) AND (VenAlbaLin.CodCliente = VenAlba.CodCliente) "
""
[CONDICIONS] 4
"VenAlbaLin.CodCliente","CodigoCli",1,1,"CAB0","CodCliente"
"CodArticulo","Codigo",1,1,"CAB1","CodArticulo"
"VenAlbaLin.Seccion","Seccion",0,1
"FechaFactura","Fecha Factura",0,2

[ORDENACIONS] 1
"FechaFactura","FechaFactura",3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
3,"COS","NumAlbaran", 80,0,"ARIAL",10,0,0,"0000",""
3,"COS","FechaAlbaran", 100,0,"ARIAL",10,0,0,"0000",""
3,"COS","Seccion",125,0,"ARIAL",10,0,0,"0000",""
3,"COS","Cantidad",150,0,"ARIAL",10,0,1,"0000","Cantidad"
3,"COS","Precio",170,0,"ARIAL",10,0,1,"0000","Precio"
3,"COS","Total",190,0,"ARIAL",10,0,1,"0000","Total"
;3,"COS","CodArticulo",5,0,"ARIAL",10,0,0,"0000",""
;3,"COS","Descripcion",40,0,"ARIAL",10,0,0,"0000",""
[FICAP]
[FIGRUP]


[CALCULS] 3
"TotalC","COS","Cantidad","CAB1"
"TotalT","COS","Total","CAB1"
"TotalG","COS","Total","CAB0"

[FIDOCUM]


