"VER1.0","Recibos","Listado de riesgos bancarios"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
0, 0, 5
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] 17
0,"Pgina :",165,0,"ARIAL",8,0,0,"1000"
6,"Pagina",195,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",165,5,"ARIAL",8,0,0,"1000"
6,"Fecha",195,5,"ARIAL",8,0,1,"1000",""
0,"Riesgo Cliente",85,0,"ARIAL",14,0,0,"1000"
1, "lineaH1", 5, 17, 195, 17,,,
0,"T.Doc.",8,18,"ARIAL",8,0,0,"1000"
0,"NDoc.",23,18,"ARIAL",8,0,0,"1000"
0,"Fecha",42,18,"ARIAL",8,0,0,"1000"
0,"Vencimiento",75,18,"ARIAL",8,0,1,"1000"
0,"Importe",100,18,"ARIAL",8,0,1,"1000"
0,"T.Pago",120,18,"ARIAL",8,0,1,"1000"
0,"Contabilizado",160,18,"ARIAL",8,0,1,"1000"
0,"Acumulado",190,18,"ARIAL",8,0,1,"1000"
1, "lineaH2", 5, 22, 195, 22,,,
0,"Condiciones : ",30,13,"ARIAL",8,0,0,"1000"
6,"Condiciones",55,13,"ARIAL",8,0,0,"1000",""
[FICAP]

[PEU]
0, 0, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
[FIPEU]

[FIGRUP]

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


;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"PARAMETERS [CodClienteI] CHAR(20), [FechaI] DateTime, [CodClienteF] CHAR(20), [FechaF] DateTime;
SELECT 1 AS Orden, 'RE' AS Tipo, NumFactura, FechaEmision, FechaVencimiento, Importe, CodPago, IIF(Contabilizado,'SI','NO') AS Conta FROM VenRecibos WHERE CodCliente=[CodClienteI] AND (FechaVencimiento>=([FechaI]-10) OR Contabilizado=False) 
UNION
SELECT 2, 'AL', NumAlbaran, FechaAlbaran, Null, Total, CodFormaPago, 'NO' FROM VenAlba WHERE CodCliente=[CodClienteI] AND Facturado=FALSE 
UNION
SELECT 3, 'PE', Numero, FechaEntrega, Null, Total, CodFormaPago, 'NO' FROM VenPrev WHERE CodCliente=[CodClienteI] AND Pedido=TRUE AND Servido=FALSE "
""
" ORDER BY Orden, FechaVencimiento, FechaEmision"

[CONDICIONS] 2
"CodCliente", "Cod. Cliente", 0, 1
"Fecha", "Fecha", 0, 2

[ORDENACIONS] 0

[CAPSALERA]
0, 4.5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 8
3,"COS","Tipo",8,0,"ARIAL",8,0,0,"0000",""
3,"COS","NumFactura",23,0,"ARIAL",8,0,0,"0000",""
3,"COS","FechaEmision",42,0,"ARIAL",8,100,0,"0000",""
3,"COS","FechaVencimiento",75,0,"ARIAL",8,0,1,"0000",""
3,"COS","Importe",100,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","CodPago",120,0,"ARIAL",8,0,1,"0000",""
3,"COS","Conta",160,0,"ARIAL",8,0,1,"0000",""
5, 0, "Total", 190, 0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

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

[FIDOCUM]


