"VER1.0","Albaranes","Listado de Facturas"
;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] 4
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,8,"ARIAL",8,0,0,"1000",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"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",""
[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] 19
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, "Pago de facturas de Proveedores", 95, 3, "ARIAL", 20, 0, 2, "1000"
1,"lineaH1",5,17,280,17,,,
0,"Sec.",5,18,"ARIAL",10,0,0,"1000"
0,"Codigo",14,18,"ARIAL",10,0,0,"1000"
0,"Provee.",32,18,"ARIAL",10,0,0,"1000"
0,"N Factura",92,18,"ARIAL",10,0,0,"1000"
0,"Fecha Fac.",115,18,"ARIAL",10,0,0,"1000"
0,"Total",147,18,"ARIAL",10,0,3,"1000"
0,"Rec.",151,18,"ARIAL",10,0,0,"1000"
0,"Imp.R.",174,18,"ARIAL",10,0,1,"1000"
0,"F. Asi.",180,18,"ARIAL",10,0,0,"1000"
0,"Cuenta",200,18,"ARIAL",10,0,0,"1000"
0,"Pago",220,18,"ARIAL",10,0,0,"1000"
0,"Forma Pago.",250,18,"ARIAL",10,0,0,"1000"
1,"lineaH2",5,22,280,22,,,
[FICAP]


[PEU]
0, 5, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
0,"Total",100,0,"ARIAL",12,0,1,"1000"
5,0,"MiTotal",147,0,"ARIAL",10,0,3,"1000","Total"
5,0,"MiTotalRecibo",174,0,"ARIAL",10,0,3,"1000","Total"
[FIPEU]

[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT ComFacturas.Seccion, ComFacturas.CodProveedor, ComFacturas.NombreFiscal, ComFacturas.NumFactura, ComFacturas.FechaFactura, ComFacturas.Total, ComRecibos.NumRecibo, ComRecibos.Importe, ComRecibos.FechaAsiento, Apuntes.CodCuenta, SubCuentas08.Titulo, ModoPago.Descripcion"
"FROM ((Apuntes INNER JOIN (ComFacturas RIGHT JOIN ComRecibos ON (ComFacturas.NumFactura = ComRecibos.NumFactura) AND (ComFacturas.Seccion = ComRecibos.Seccion) AND (ComFacturas.FechaFactura = ComRecibos.FechaEmision) AND (ComFacturas.CodProveedor = ComRecibos.CodProveedor)) ON (Apuntes.FechaAsiento = ComRecibos.FechaAsiento) AND (Apuntes.Asiento = ComRecibos.Asiento) AND (Apuntes.Seccion = ComRecibos.Seccion)) INNER JOIN SubCuentas08 ON Apuntes.CodCuenta = SubCuentas08.CodCuenta) LEFT JOIN ModoPago ON ComRecibos.CodPago = ModoPago.CodPago"
""

[CONDICIONS] 6
"ComFacturas.NumFactura","Nmero Factura",0,1
"ComFacturas.CodProveedor","Codigo Proveedor",0,1, -10
"ComFacturas.FechaFactura","Fecha",0,2
"ComFacturas.Seccion","Seccin",0,1
"Apuntes.CodCuenta","Cdigo Cuenta",0,1 , -10
" (Apuntes.CodCuenta>='570' And Apuntes.CodCuenta<'574') OR (Apuntes.CodCuenta>='520' And Apuntes.CodCuenta<'521') ","",4

[ORDENACIONS] 2
"ComFacturas.FechaFactura","Fecha",3
"ComFacturas.NumFactura","Nmero de Factura",3


[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 12
3, "COS", "Seccion", 5,0,"ARIAL",10,0,0,"0000",""
3, "COS", "CodProveedor", 10,0,"ARIAL",10,115,0,"0000",""
3, "COS", "NombreFiscal", 32,0,"ARIAL",10,58,0,"0000",""
3, "COS", "NumFactura", 92,0,"ARIAL",10,0,0,"0000",""
3, "COS", "FechaFactura", 115,0,"ARIAL",10,115,0,"0000",""
3, "COS", "Total", 146,0,"ARIAL",10,0,3,"0000","Total"
3, "COS", "NumRecibo", 152,0,"ARIAL",10,0,0,"0000",""
3, "COS", "Importe", 170,0,"ARIAL",10,0,3,"0000","Total"
3, "COS", "FechaAsiento", 180,0,"ARIAL",10,115,0,"0000",""
3, "COS", "CodCuenta", 200,0,"ARIAL",10,0,0,"0000",""
3, "COS", "Titulo", 220,0,"ARIAL",10,28,0,"0000","Total"
3, "COS", "Descripcion", 250,0,"ARIAL",10,20,0,"0000","Total"
[FICAP]
[FIGRUP]


[CALCULS] 2
"Mitotal","COS","Total","GENERAL"
"MitotalRecibo","COS","Importe","GENERAL"

[FIDOCUM]





