"VER1.0","Articulos","Listado de Almacen"
;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] 8
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",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"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] 12
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, "Inventario Almacenes (Precio Coste Materia Prima + gasto estructural)", 100, 3, "ARIAL", 11, 0, 2, "1000"
1, "lineaH1", 5, 17, 200, 17,,,
0,"Cdigo",10,18,"ARIAL",8,0,0,"1000"
0,"Descripcin",35,18,"ARIAL",8,0,0,"1000"
0,"Cantidad",150,18,"ARIAL",8,0,1,"1000"
0,"P. Coste MP",170,18,"ARIAL",8,0,1,"1000"
0,"Total",190,18,"ARIAL",8,0,1,"1000"
1, "lineaH2", 5, 22, 200, 22,,,
[FICAP]

[PEU]
0, 15, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
0,"Total Final : ",120,0,"ARIAL",14,0,0,"1000"
5,0,"TotalFinal",188,0,"ARIAL",14,0,1,"1000","Total"
;0,"Total",160,0,"ARIAL",12,0,1,"1000"
;5,0,"Total",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT CodAlmacen & ' - ' & Descripcion as Titulo,*"
"FROM Almacenes"
""
[CONDICIONS] 1
"CodAlmacen","CodAlmacen",0,1

[ORDENACIONS] 1
"CodAlmacen","Codigo Almacn",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",10,0,"ARIAL",10,0,0,"1001",""
[FICAP]

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

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
" SELECT Stocks.CodArticulo, Articulos.Descripcion, Stocks.CodAlmacen, Stocks.StockActual, Sum([Articulos_1].[PrecioCoste]*[Cantidad]*GastosEstructurales) AS PrecioCosteB, Sum([Articulos_1].[PrecioCoste]*[Cantidad]*[StockActual]*GastosEstructurales) AS ValorTotal "
" FROM Configuracion, ((Articulos INNER JOIN Stocks ON Articulos.CodArticulo = Stocks.CodArticulo) INNER JOIN MateriasPrimas ON Articulos.CodArticulo = MateriasPrimas.CodArticulo) INNER JOIN Articulos AS Articulos_1 ON MateriasPrimas.CodMP = Articulos_1.CodArticulo "
" GROUP BY Stocks.CodArticulo, Articulos.Descripcion, Stocks.CodAlmacen, Stocks.StockActual "
[CONDICIONS] 2
"Stocks.CodAlmacen","Cod. Almacn",1,1,"CAB1","CodAlmacen"
"Stocks.CodArticulo","Cod. Artculo",0,1
;"CodFamilia","Cod. Familia",0,1

[ORDENACIONS] 2
"Stocks.CodArticulo", "Codigo articulo", 3
"Articulos.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] 5
3,"COS","CodArticulo",10,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",35,0,"ARIAL",8,110,0,"0000",""
3,"COS","StockActual",150,0,"ARIAL",8,0,1,"0000",""
3,"COS","PrecioCosteB",170,0,"ARIAL",8,0,1,"0000","Precio"
3,"COS","ValorTotal",190,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 2
"Total","COS","ValorTotal","CAB1"
"TotalFinal","COS","ValorTotal","GENERAL"

[FIDOCUM]






