"VER1.0","Articulos","Listado de 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] 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]

[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] 13
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, "Listado de Artculos Bajo Mnimos", 105, 3, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,17,195,17,,,
0,"Alm.",5,18,"ARIAL",8,0,0,"1000"
0,"Cod.Art.",16,18,"ARIAL",8,0,0,"1000"
0,"Descripcion",39,18,"ARIAL",8,0,0,"1000"
0,"Actual",157,18,"ARIAL",8,0,1,"1000"
0,"Mnimo",176,18,"ARIAL",8,0,1,"1000"
0,"Diferencia",195,18,"ARIAL",8,0,1,"1000"
1,"lineaH2",5,22,195,22,,,
;0,"Prov.",115,18,"ARIAL",8,0,0,"1000"
;0,"Fam.",136,18,"ARIAL",8,0,0,"1000"
[FICAP]

[PEU]
0, 0, #TRUE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;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]
3,"COS", #FALSE#
"SELECT Stocks.*, Articulos.Descripcion, CodFamilia, CodProveedor, (Stocks.StockMinimo-Stocks.StockActual) AS Diferencia "
"FROM Stocks INNER JOIN Articulos ON Stocks.CodArticulo = Articulos.CodArticulo "
""
[CONDICIONS] 4
"CodAlmacen","CodAlmacen",0,1
"Stocks.CodArticulo","Codigo",0,1
"CodProveedor","CodProveedor",0,1, -10
" (Stocks.StockActual < Stocks.StockMinimo) ","",4

[ORDENACIONS] 3
"Stocks.CodArticulo","Codigo artculo",3
"CodFamilia","Cdigo de familia",3
"CodProveedor","Cdigo proveedor",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","CodAlmacen",5,0,"ARIAL",10,0,0,"0000",""
3,"COS","CodArticulo",13,0,"ARIAL",10,90,0,"0000",""
3,"COS","Descripcion",39,0,"ARIAL",10,90,0,"0000",""
3,"COS","StockActual",157,0,"ARIAL",10,0,1,"0000","Cantidad"
3,"COS","StockMinimo",176,0,"ARIAL",10,0,1,"0000","Cantidad"
3,"COS","Diferencia",195,0,"ARIAL",10,0,1,"0000","Cantidad"
;3,"COS","CodFamilia",136,0,"ARIAL",10,0,0,"0000",""
;3,"COS","CodProveedor",115,0,"ARIAL",10,0,0,"0000",""
[FICAP]
[FIGRUP]

[CALCULS] 0
;"Total","COS","PrecioCoste","GENERAL"

[FIDOCUM]



