"VER1.0","Clientes","Listado de Clientes"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
H, 9, 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] 3
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
0,"Condiciones : ",10,10,"ARIAL",8,0,0,"1000"
6,"Condiciones",35,10,"ARIAL",8,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, 30, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 20
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, "Listado de impresos especiales clientes", 105, 7, "ARIAL", 22, 0, 2, "1000"
1, "lineaH1", 5, 17, 290, 17,,,
0,"Cdigo",5,21,"ARIAL",10,0,0,"1000"
0,"Nombre",30,21,"ARIAL",10,0,0,"1000"
0,"NIF",100,21,"ARIAL",10,0,0,"1000"
0,"Persona Contacto",130,21,"ARIAL",10,0,0,"1000"
0,"Telfono",170,21,"ARIAL",10,0,0,"1000"
0,"Impreso",215,17,"ARIAL",10,0,0,"1000"
0,"Pedido",215,21,"ARIAL",10,0,0,"1000"
0,"Impreso",235,17,"ARIAL",10,0,0,"1000"
0,"Impreso",255,17,"ARIAL",10,0,0,"1000"
0,"Impreso",275,17,"ARIAL",10,0,0,"1000"
0,"Presup.",235,21,"ARIAL",10,0,0,"1000"
0,"Albarn",255,21,"ARIAL",10,0,0,"1000"
0,"Factura",275,21,"ARIAL",10,0,0,"1000"
1, "lineaH2", 5, 26, 290, 26,,,
[FICAP]

[PEU]
0, 30, #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 Clientes.*, Direcciones.CodPostal, *"
"FROM Clientes LEFT JOIN Direcciones ON (Clientes.CodDireccion = Direcciones.CodDireccion) AND (Clientes.CodCliente = Direcciones.CodCliente)"
""
[CONDICIONS] 8
"Direcciones.CodCliente", "Codigo",0,1, -10
"Nombre", "Nombre", 0, 1
"CodRepresentante", "Cod Representante", 0, 1
"CodPostal", "Cod Postal", 0, 1
"NumDocPedido", "Num. Doc. Pedido", 0, 0
"NumDocPresupuesto", "Num. Doc. Presupuesto", 0, 0
"NumDocAlbaran", "Num. Doc. Albarn", 0, 0
"NumDocFactura", "Num. Doc. Factura", 0, 0
;"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"

[ORDENACIONS] 3
"Clientes.CodCliente", "Codigo cliente", 3
"Nombre", "Nombre", 3
"NIF", "N.I.F.", 3

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 9
3,"COS","Clientes.CodCliente",5,0,"ARIAL",10,0,0,"0000",""
3,"COS","Nombre",30,0,"ARIAL",10,70,0,"0000",""
3,"COS","NIF",100,0,"ARIAL",10,0,0,"0000",""
3,"COS","PersonaContacto",130,0,"ARIAL",10,30,0,"0000",""
3,"COS","clientes.Telefono",170,0,"ARIAL",10,0,0,"0000",""
3,"COS","NumDocPedido",220,0,"ARIAL",10,0,0,"0000",""
3,"COS","NumDocPresupuesto",240,0,"ARIAL",10,0,0,"0000",""
3,"COS","NumDocAlbaran",260,0,"ARIAL",10,0,0,"0000",""
3,"COS","NumDocFactura",280,0,"ARIAL",10,0,0,"0000",""
[FICAP]
[FIGRUP]

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

[FIDOCUM]


