"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] 6
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] 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, "Ordenes fabricacin pendientes", 100, 7, "ARIAL", 16, 0, 2, "1000"
1, "lineaH1", 5, 17, 200, 17,,,
1, "lineaH2", 5, 22, 200, 22,,,
0,"N.Orden",5,18,"ARIAL",8,0,0,"1000"
0,"Fecha",20,18,"ARIAL",8,0,0,"1000"
0,"Cod. Articulo",35,18,"ARIAL",8,0,0,"1000"
0,"Descripcion", 55 ,18,"ARIAL",8,0,0,"1000"
0,"CodCliente",120,18,"ARIAL",8,0,0,"1000"
0,"Nombre",150,18,"ARIAL",8,0,0,"1000"
0,"Cantidad",200,18,"ARIAL",8,0,1,"1000"
[FICAP]

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

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT OrdenesFabricacion.*, Articulos.Descripcion, Clientes.Nombre "
"FROM (OrdenesFabricacion inner JOIN Articulos ON OrdenesFabricacion.CodArticulo = Articulos.CodArticulo) left JOIN Clientes ON OrdenesFabricacion.CodCliente = Clientes.CodCliente  "
""
[CONDICIONS] 3
"OrdenesFabricacion.CodCliente","Cod. Cliente",0,1, -10
"Fecha","Fecha",0,2
" ( Completada= false) ","",4


[ORDENACIONS] 2
"NumOrden","Nmero de orden",3
"OrdenesFabricacion.CodCliente","Cod. Cliente",3


[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 7
3,"COS","NumOrden",5,0,"ARIAL",8,0,0,"0000",""
3,"COS","Fecha",20,0,"ARIAL",8,0,0,"0000",""
3,"COS","CodArticulo", 35 ,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion", 55 ,0,"ARIAL",8,  60,0,"0000",""
3,"COS","CodCliente", 120 ,0,"ARIAL",8,100,0,"0000",""
3,"COS","Nombre", 150 ,0,"ARIAL",8,40,0,"0000",""
3,"COS","Cantidad",200,0,"ARIAL",8,0,1,"0000",""
[FICAP]
[FIGRUP]

[CALCULS] 1
"Total","COS","Importe","GENERAL"

[FIDOCUM]



