"VER1.0","Clientess","Listado de Clientes"
;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", #TRUE#
"SELECT * , Domicilio & ' - ' & CodigoPostal & ' - ' & Poblacion & ' - ' & Provincia as Direc, 'En ' & Poblacion & ' a ' & date() as ole, 'Tel : ' & Telefono1 as Tel, NombreComercial & ' com NIF: ' & NIF as Titul "
"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] 7
3,"CABECERA","ole",20,70,"ARIAL",10,0,0,"0000",""
3,"CABECERA","NombreFiscal",20,33,"ARIAL",8,0,0,"0000",""
3,"CABECERA","Direc",20,37,"ARIAL",8,0,0,"0000",""
3,"CABECERA","Tel",20,41,"ARIAL",8,0,0,"0000",""
0,"NIF:",20,45,"ARIAL",8,0,0,"0000"
3,"CABECERA","Nif",28,45,"ARIAL",8,0,0,"0000",""
2, "Anagrama.bmp", 20, 5, 60, 50
[FICAP]

[FIGRUP]

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

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #TRUE#
""
""
""
;[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] 23
0,"ORDEN DE DOMICILIACIN DE ADEUDO DIRECTO SEPA.",20,83,"ARIAL",10,0,0,"1000"
0,"Mediante la firma de esta Orden de Domiciliacin,  autoriza al acreedor identificado en la cabecera de esta carta",20,100,"ARIAL",10,0,0,"0000"
0,"a enviar rdenes a su entidad financiera para adeudar en su cuenta  y a su entidad financiera para  adeudar los",20,106,"ARIAL",10,0,0,"0000"
0,"importes correspondientes en su cuenta de acuerdo con las ordenes del acreedor indicado.",20,112,"ARIAL",10,0,0,"0000"
0,"Como parte de sus derechos, el deudor est legitimado al reembolso por su entidad en los trminos y condiciones",20,118,"ARIAL",10,0,0,"0000"
0,"del contrato subscrito con la misma. La solicitud de reembolso deber efectuarse dentro de las ocho semanas",20,124,"ARIAL",10,0,0,"0000"
0,"que siguen a la fecha de adeudo en cuenta.",20,130,"ARIAL",10,0,0,"0000"
0,"Rogamos revisen los datos que disponemos en nuestra base de datos y los verifiquen: ",20,142,"ARIAL",10,0,0,"0000"
0,"En caso de existir alguna anomala en los datos arriba indicados, les rogamos indiquen aqu los datos correctos: ",20,170,"ARIAL",10,0,0,"0000"
1, "Cuadro3", 17, 148,170, 164, 8, 0,
1, "Cuadro4", 17, 176,170, 192, 8, 0,
1, "CuadroFirma", 17, 222,120, 257, 8, 0,
0,"Swift BIC: ",20,178,"ARIAL",9,0,0,"1000"
0,"IBAN:",70,178,"ARIAL",9,0,0,"1000"
0,"__________________",35,178,"ARIAL",9,0,0,"1000"
0,"___________________________________________",80,178,"ARIAL",9,0,0,"1000"
0,"Tipo de pago",20,200,"ARIAL",9,0,0,"1000"
1, "Cuadrorecurrente", 53, 200,57, 204, 8, 0,
1, "Cuadrunico", 79, 200,83, 204, 8, 0,
0,"Recurrente            nico",58,200,"ARIAL",9,0,0,"1000"
0,"X",54,200,"ARIAL",12,0,0,"1000"
0,"Firma y sello de",20,215,"ARIAL",10,0,0,"0000"
0,"Por favor, devolver este original firmado al acreedor, guarde una copia para su custodia.",20,260,"ARIAL",10,0,0,"1000"
;0,"IMPORTE.................................     ",20,144,"ARIAL",10,0,0,"1000"
;0,"CIF o NIF..................................     ",20,151,"ARIAL",10,0,0,"1000"
;0,"Primer Trimestre ",30,158,"ARIAL",10,0,0,"1100"
;0,"Segundo Trimestre ",70,158,"ARIAL",10,0,0,"1100"
;0,"Tercer Trimestre ",110,158,"ARIAL",10,0,0,"1100"
;0,"Cuarto Trimestre ",150,158,"ARIAL",10,0,0,"1100"
;0,"Muy Sres. Nuestros:",20,63,"ARIAL",0,0,0,"0000"
;3,"CABECERA","Titul",60,93,"ARIAL",0,0,0,"0000",""


[FICAP]

[PEU]
0, 5, #TRUE#, 0, #FALSE#, #FALSE#, 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,"T2",195,0,"ARIAL",12,0,1,"1000","Total"
[FIPEU]

[FIGRUP]



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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #TRUE#
"SELECT NombreFiscal & ', con NIF ' & NIF AS dale, Clientes.*, CuentasBanc.*, BancosIBAN.*, Direcciones.*, CodigosPostales.*, Provincias.*"
; 3/11 (auditoria de listados): la linea del FROM estaba partida en tres con saltos de linea dentro de la cadena: el
; motor leia solo el primer trozo, la consulta fallaba y el respaldo imprimia la tabla de codigos postales
; entera (3305 paginas). Unida en una.
"FROM (CodigosPostales RIGHT JOIN (((Clientes INNER JOIN CuentasBanc ON (Clientes.CodCliente = CuentasBanc.CodCliente) AND (Clientes.CodCuentaBancaria = CuentasBanc.CodCuenta)) LEFT JOIN BancosIBAN ON CuentasBanc.BIC = BancosIBAN.BIC) INNER JOIN Direcciones ON (Direcciones.CodDireccion = Clientes.CodDireccion) AND (Clientes.CodCliente = Direcciones.CodCliente)) ON CodigosPostales.CodPostal = Direcciones.CodPostal) LEFT JOIN Provincias ON CodigosPostales.CodProvincia = Provincias.CodProvincia"
""

[CONDICIONS] 2
"Clientes.CodCliente", "CodCliente", 0, 1, -10
"Clientes.CodFormaPago", "Cdigo Forma Pago", 0, 1


[CAPSALERA]
0, 150, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 14
0,"Swift BIC: ",20,125,"ARIAL",9,0,0,"1000"
0,"Nmero de cuenta - IBAN:",70,125,"ARIAL",9,0,0,"1000"
3,"COS","dale",20,67,"ARIAL",10,0,0,"1000",""
3,"COS","NombreFiscal",110,20,"ARIAL",10,0,0,"1000",""
8, "0", "LEFT$(Campo('COS','Direcciones.Direccion'),45)",110,25,"ARIAL",10,0,0,"1000",""
8, "0", "MID$(Campo('COS','Direcciones.Direccion'),46,45)",110,30,"ARIAL",10,0,0,"1000",""
3,"COS","CodigosPostales.CodPostal",110,35,"ARIAL",10,0,0,"1000",""
3,"COS","CodigosPostales.Ciudad",124,35,"ARIAL",10,0,0,"1000",""
3,"COS","Provincia",110,40,"ARIAL",10,30,0,"1000",""
0,"Ref. Orden Domiciliacin:",20,41,"ARIAL",9,0,0,"0000"
3,"COS","Clientes.CodCliente",60,41,"ARIAL",10,50,0,"0000",""
3,"COS","NombreFiscal",47,190,"ARIAL",10,0,0,"0000",""
3,"COS","CuentasBanc.BIC",40,125,"ARIAL",10,50,0,"1000",""
3,"COS","IBAN",113,125,"ARIAL",10,0,0,"1000","Total"
;3,"COS","Direcciones.Direccion",110,25,"ARIAL",10,0,0,"1000",""
;3,"COS","CodEntidad",40,130,"ARIAL",10,0,0,"1000",""
;3,"COS","CodOficina",50,130,"ARIAL",10,0,0,"1000",""
;3,"COS","DC",60,130,"ARIAL",10,0,0,"1000",""
;3,"COS","NumCuenta",67,130,"ARIAL",10,30,0,"1000",""
;3,"COS","SumaDeTotal",80,120,"ARIAL",10,0,0,"1000","Precio"
;3,"COS","PrimerTrimestre",40,138,"ARIAL",10,0,0,"0000","Precio"
[FICAP]
[FIGRUP]

[CALCULS] 
;"T2","COS","SumaDeTotal","GENERAL"

[FIDOCUM]



