"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", #FALSE#
"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",80,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]
2,"CAB2", #FALSE#
"SELECT NombreFiscal & ', con NIF ' & NIF AS dale, Direcciones.Direccion, CodigosPostales.CodPostal, CodigosPostales.Ciudad, Provincias.Provincia, * "
"FROM ((Clientes INNER JOIN Direcciones ON (Direcciones.CodDireccion = Clientes.CodDireccion) AND (Clientes.CodCliente = Direcciones.CodCliente)) LEFT JOIN CodigosPostales ON Direcciones.CodPostal = CodigosPostales.CodPostal) LEFT JOIN Provincias ON CodigosPostales.CodProvincia = Provincias.CodProvincia "
""
[ORDENACIONS] 1
"Clientes.CodCliente", "CodCliente", 3

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

[CAPSALERA]
0, 0, #TRUE#, 1, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 11
0,"Swift BIC: ",20,125,"ARIAL",9,0,0,"1000"
0,"Nmero de cuenta - IBAN:",70,125,"ARIAL",9,0,0,"1000"
3,"CAB2","dale",20,67,"ARIAL",10,0,0,"1000",""
3,"CAB2","NombreFiscal",110,20,"ARIAL",10,50,0,"1000",""
3,"CAB2","Direccion",110,25,"ARIAL",10,0,0,"1000",""
3,"CAB2","CodigosPostales.CodPostal",110,30,"ARIAL",10,0,0,"1000",""
3,"CAB2","Ciudad",124,30,"ARIAL",10,0,0,"1000",""
3,"CAB2","Provincia",110,35,"ARIAL",10,30,0,"1000",""
0,"Ref. Orden Domiciliacin:",20,41,"ARIAL",9,0,0,"0000"
3,"CAB2","Clientes.CodCliente",60,41,"ARIAL",10,50,0,"0000",""
3,"CAB2","NombreFiscal",47,190,"ARIAL",10,50,0,"0000",""
;0,"Entidad",120,120,"ARIAL",9,0,0,"1000"
;0,"Oficina",135,120,"ARIAL",9,0,0,"1000"
;0,"DC",150,120,"ARIAL",9,0,0,"1000"
;0,"Nm. Cuenta",160,120,"ARIAL",9,0,0,"1000"
;0,"Nombre Empresa ",20,110,"ARIAL",10,0,0,"1000"
;0,"NIF ",60,110,"ARIAL",10,0,0,"1000"
[FICAP]
[FIGRUP]




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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT CuentasBanc.BIC, CuentasBanc.CodCliente, CuentasBanc.CodEntidad, CuentasBanc.CodOficina, CuentasBanc.DC, CuentasBanc.NumCuenta, CuentasBanc.iban"
"FROM CuentasBanc LEFT JOIN BancosIBAN ON CuentasBanc.BIC = BancosIBAN.BIC"
""

[CONDICIONS] 1
"CuentasBanc.CodCliente", "CodCliente", 1, 1, "CAB2", "Clientes.CodCliente"
;"CodSubFamilia", "CodSubFamilia", 1, 1, "CAB3", "CodsubFamilia"


[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
3,"COS","BIC",40,125,"ARIAL",10,50,0,"1000",""
3,"COS","IBAN",113,125,"ARIAL",10,0,0,"1000","Total"
;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]



