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

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

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


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "DISENY", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 28, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 16
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","dd-mm-yyyy"
0, "Listado de proveedores", 105, 7, "ARIAL", 22, 0, 2, "1000"
1, "lineaH1", 5, 17, 200, 17,,,
0,"Cdigo",5,18,"ARIAL",8,0,0,"1000"
0,"Nombre",25,18,"ARIAL",8,0,0,"1000"
0,"NIF",80,18,"ARIAL",8,0,0,"1000"
0,"Persona Contacto",100,18,"ARIAL",8,0,0,"1000"
0,"Cargo Contacto",140,18,"ARIAL",8,0,0,"1000"
0,"Telfono",185,18,"ARIAL",8,0,0,"1000"
0,"Domicilio",25,22,"ARIAL",8,0,0,"1000"
0,"Poblacin",140,22,"ARIAL",8,0,0,"1000"
0,"Fax",185,22,"ARIAL",8,0,0,"1000"
1, "lineaH2", 5, 27, 200, 27,,,

[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total Acumulado",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#
; 3/11 (auditoria de listados): la poblacion sale de CodigosPostales; Direcciones no tiene columna Ciudad.
"SELECT Proveedores.CodProveedor, Proveedores.Nombre, Proveedores.NIF, Proveedores.PersonaContacto, Proveedores.CargoContacto, Proveedores.Telefono, Proveedores.Fax, Direccion.CodPostal & ' - ' & CodigosPostales.Ciudad as pobla, Direccion.Direccion "
"FROM (Proveedores Left JOIN Direccion ON (Proveedores.CodDireccion = Direccion.CodDireccion) AND (Proveedores.CodProveedor = Direccion.CodCliente)) LEFT JOIN CodigosPostales ON (Direccion.CodPais = CodigosPostales.CodPais) AND (Direccion.CodPostal = CodigosPostales.CodPostal)"
""
[CONDICIONS] 2
"Proveedores.CodProveedor","Codigo",0,1, -10
"Proveedores.Nombre","Nombre",0,1
;"CodFamilia", "Cod", 1, 1, "CAB1", "CodFamilia"
;"CodProveedor", "proveedor", 1, 1, "CAB2", "CodProveedor"
;"CodIva", "Iva", 1, 1, "CAB3", "CodIva"

[ORDENACIONS] 2
"Proveedores.CodProveedor","Codigo proveedor",3
"Proveedores.Nombre","Nombre",3

[CAPSALERA]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 9
3,"COS","CodProveedor",5,0,"ARIAL",8,0,0,"1000",""
3,"COS","Nombre",25,0,"ARIAL",8,50,0,"1000",""
3,"COS","NIF",80,0,"ARIAL",8,0,0,"0000",""
3,"COS","PersonaContacto",100,0,"ARIAL",8,0,0,"0000",""
3,"COS","CargoContacto",140,0,"ARIAL",8,0,0,"0000",""
3,"COS","Direccion",25,5,"ARIAL",8,0,0,"0000",""
3,"COS","Pobla",140,5,"ARIAL",8,0,0,"0000",""
3,"COS","Telefono",185,0,"ARIAL",8,0,0,"0000",""
3,"COS","Fax",185,5,"ARIAL",8,0,0,"0000",""
[FICAP]
[FIGRUP]

[CALCULS] 0
;"TotalF","COS","PrecioCoste","CAB1"
;"TotalP","COS","PrecioCoste","CAB2"
;"TotalI","COS","PrecioCoste","CAB3"
;"Total","COS","PrecioCoste","GENERAL"

[FIDOCUM]





