"VER1.0","Albara","Facturas de Proveedores"
;Versio, Categoria, Descripcion


;Ampla, Llarg, [EspaiCos]
;MargenX, ,MargenY, EtiLin, EtiPag
[DOCUM]
 V, 9, 40
 0, 0, 0, 0
;-----------------------------------------


;Tipo, NomGrup, Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT *, CodigoPostal & ' - ' & Poblacion as Pueblo, Provincia & ' ' & Pais as  ProvPais"
"FROM Configuracion"
""
[CAPSALERA]
0, 0, #TRUE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 5
3,"CABECERA","NombreFiscal",120,15,"ARIAL",10,0,0,"0000",""
3, "CABECERA", "Nif", 70, 36, "ARIAL", 10, 0, 0, "0000", ""
3, "CABECERA", "Domicilio", 120, 20, "ARIAL", 10, 0, 0, "0000", ""
3, "CABECERA", "Pueblo", 120, 25, "ARIAL", 10, 0, 0, "0000", ""
3, "CABECERA", "ProvPais", 120, 30, "ARIAL", 10, 0, 0,"0000", ""
;3, "CABECERA", "Provincia", 10, 35, "ARIAL", 8, 0, 0,"0000", ""
;3, "CABECERA", "Pais", 26, 35, "ARIAL", 8, 0, 0,"0000", ""
;3, "CABECERA", "CodigoPostal", 10, 32, "ARIAL", 8, 0, 0, "0000", ""
;3, "CABECERA", "Poblacion", 23, 32, "ARIAL", 8, 0, 0, "0000", ""
;2, "Anagrama.BMP", 0, 10, 156, 50
[FICAP]

; En Impresos recomendable crear con valor PrintAll a True
[PEU]
0, 5, #TRUE#, 2, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[FIPEU]
[FIGRUP]

;-----------------------------------------
;Tipo, NomGrup, Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""

;[ordenaciones] y [condiciones]

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 22
1, "CuadroAdrea", 113, 10, 203, 40, 1, 0,
1, "CuadroFact", 6, 30, 102, 41, 1, 0,
0,"Fecha",15,32,"ARIAL",8,0,0,"0000"
0,"N Factura",40,32,"ARIAL",8,0,0,"0000"
0,"C.I.F./D.N.I.",75,32,"ARIAL",8,0,0,"0000"
1, "CuadroOtros", 6, 43, 102, 51, 1, 0,
0,"Repr.",15,44,"ARIAL",8,0,0,"0000"
1, "lineaH", 0, 59, 203, 59,,,
1, "lineaV", 182, 53, 182, 245,,,
1, "lineaV", 167, 53, 167, 245,,,
1, "lineaV", 151, 53, 151, 245,,,
1, "lineaV", 137, 53, 137, 245,,,
1, "lineaV", 28, 53, 28, 245,,,
0,"Cdigo",5,54,"ARIAL",8,0,0,"0000"
0,"Descripcin",30,54,"ARIAL",8,0,0,"0000"
0,"Cantidad",150,54,"ARIAL",8,0,1,"0000"
0,"Precio",165,54,"ARIAL",8,0,1,"0000"
0,"Iva",175,54,"ARIAL",8,0,1,"0000"
0,"Total",199,54,"ARIAL",8,0,1,"0000"
0,"Pgina",70,44,"ARIAL",8,0,0,"0000"
6,"Pagina",70,48,"ARIAL",8,0,0,"0000",""
1, "CuadroCos", 0, 53, 203, 245, 1, 0,
[FICAP]

[PEU]
0, 38, #FALSE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 15
1, "CuadroBrut", 0, 0, 170, 10, 1, 0,#FALSE#
0, "Importe Bruto", 3, 1,"ARIAL",8,0,0,"0000"
0, "I.V.A.", 125, 1,"ARIAL",8,0,0,"0000"
0, "R.E.", 154, 1,"ARIAL",8,0,0,"0000"
1, "CuadroTot", 173, 0, 203, 10, 1, 0,
0, "Total", 183, 1,"ARIAL",9,0,1,"0000"
1, "CuadroFP", 0, 12, 77, 30, 1, 0,
0, "Condiciones de pago", 3, 12,"ARIAL",8,0,0,"0000"
1, "CuadroIva", 78, 12, 203, 30, 1, 0,
0, "Desglose de I.V.A.", 80, 14,"ARIAL",8,0,0,"0000"
0, "Tipo", 108, 14,"ARIAL",8,0,0,"0000"
0, "B.Imponible", 118, 14,"ARIAL",8,0,0,"0000"
0, "I.V.A.      Importe", 142, 14,"ARIAL",8,0,0,"0000"
0, "%  R.E.     Importe", 174, 14,"ARIAL",8,0,0,"0000"
0, "OBSERVACIONES :", 0, 30,"ARIAL",9,0,0,"0000"
;0, "Total Ptas :", 160, 35,"ARIAL",8,0,0,"0000"
[FIPEU]

[FIGRUP]


;-----------------------------------------
;tipo, NomGrup, Select, From, GropBy

[GRUP]
2,"CAB 1", #TRUE#
"SELECT ComFacturas.*, ComImp.*, ComVto.*, CodigoPostal & ' - ' & Poblacion as Pueblo, Provincia & ' - ' & Pais as Ciudad "
"FROM (ComFacturas LEFT JOIN ComImp ON (ComFacturas.Seccion = ComImp.Seccion) AND (ComFacturas.NumFactura = ComImp.NumFactura)) LEFT JOIN ComVto ON (ComFacturas.Seccion = ComVto.Seccion) AND (ComFacturas.NumFactura = ComVto.NumFactura)"
""
[CONDICIONS] 4
"ComFacturas.NumFactura","Nmero Factura",0,1
"ComFacturas.Seccion","Seccin",0,1
"ComFacturas.FechaFactura","Fecha",0,2
"ComFacturas.NombreFiscal","Nombre Proveedor",0,1


[CAPSALERA]
0, 60, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 8
3,"CAB 1","NombreFiscal",10,3,"ARIAL",16,0,0,"1000",""
3,"CAB 1","Direccion",10,10,"ARIAL",10,0,0,"1000",""
3,"CAB 1","Pueblo",10,15,"ARIAL",10,0,0,"1000",""
3,"CAB 1","Ciudad",10,20,"ARIAL",10,0,0,"1000",""
3,"CAB 1","FechaFactura",12,36,"ARIAL",8,0,0,"0000",""
3,"CAB 1","ComFacturas.NumFactura",45,36,"ARIAL",8,0,0,"0000",""
0, "C.I.F :", 10, 25, "ARIAL", 8, 0, 0, "1000"
3,"CAB 1","NIF",23,25,"ARIAL",8,0,0,"1000",""
0,"Pgina",70,44,"ARIAL",8,0,0,"0000"
6,"Pagina",70,48,"ARIAL",8,0,0,"0000","";0, "Tel. ", 10, 34, "ARIAL", 8, 0, 0, "1000"
;3, "CAB 1", "Telefono", 17, 34, "ARIAL", 8, 0, 0, "1000", ""
;0, "FAX. ", 40, 34, "ARIAL", 8, 0, 0, "1000"
;3, "CAB 1", "Fax", 47, 34, "ARIAL", 8, 0, 0, "1000", ""
[FICAP]



[PEU]
0, 43, #TRUE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 31
3, "CAB 1", "Total", 200, 10, "ARIAL", 12, 0, 1, "0000","Total"
3, "CAB 1", "BaseImponible1", 135, 25, "ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Iva1", 145, 25,"ARIAL", 10, 0, 1, "0000", ""
6, "@IVA1", 165, 25,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Re1", 180, 25, "ARIAL", 10, 0, 1, "0000",  ""
6, "@RE1", 200, 25,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "BaseImponible2", 135, 30, "ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Iva2", 145, 30,"ARIAL", 10, 0, 1, "0000", ""
6, "@IVA2", 165, 30,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Re2", 180, 30, "ARIAL", 10, 0, 1, "0000",  ""
6, "@RE2", 200, 30,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "BaseImponible3", 135, 35, "ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Iva3", 145, 35,"ARIAL", 10, 0, 1, "0000", ""
6, "@IVA3", 165, 35,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Re3", 180, 35, "ARIAL", 10, 0, 1, "0000",  ""
6, "@RE3", 200, 35,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Vto1", 5, 25, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto2", 5, 30, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto3", 5, 35, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto4", 40, 25, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto5", 40, 30, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto6", 40, 35, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Imp1", 35, 25, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp2", 35, 30, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp3", 35, 35, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp4", 70, 25, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp5", 70, 30, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp6", 70, 35, "ARIAL", 8, 0, 1, "0000", "Total"
6, "@IVA", 130, 10, "ARIAL", 10, 0, 1, "0000", "Total"
6, "@RE", 160, 10, "ARIAL", 10, 0, 1, "0000", "Total"
5, 0, "TotalBrut", 20, 10, "ARIAL", 10, 0, 0, "0000", "Total"
;8, "1", "Val(Campo('CAB 1','Total')*166.386  ", 180, 35, "ARIAL", 8, 0, 0, "0000", "###,###,###"
[FIPEU]
[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB 2", #FALSE#
"SELECT *, 'Num. Albarn : ' & NumAlbaran & '    Fecha Albarn : ' & FechaAlbaran as NumyFecha "
"FROM ComAlba"
""

[CONDICIONS] 3
"NumFactura","Nmero de ppppp",1,1,"CAB 1","ComFacturas.NumFactura"
"Seccion","Nmero de ppppp",1,1,"CAB 1","ComRecibos.Seccion"
"CodProveedor","Proveedor",1,1,"CAB 1","CodProveedor"

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB 2","NumyFecha",30,0,"ARIAL",8,0,0,"0000",""
;0,"Nmero Albarn",10,0,"ARIAL",10,0,0,"1000"
;3,"CAB 2","NumAlbaran",40,0,"ARIAL",10,0,0,"1000",""
;0,"Fecha Albarn",70,0,"ARIAL",10,0,0,"1000"
;3,"CAB 2","FechaAlbaran",100,0,"ARIAL",10,0,0,"1000",""
[FICAP]

[PEU]
0, 5, #FALSE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;5,1,"MiTotal",115,0,"ARIAL",10,0,0,"0000",""
;0,"Fin Albarn",10,0,"ARIAL",10,0,0,"1000"
;5,0,"MiTotal",100,0,"ARIAL",10,0,0,"1000",""
;5,2,"MiTotal",300,0,"ARIAL",10,0,0,"1000",""
;5,"COS","Total",300,0,"ARIAL",10,0,0,"1000",""
[FIPEU]
[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT CodProveedor, Total, Recargo, Iva, CodIVA, CodDescuento, Precio, NumAlbaran, Cantidad, NumLinea, LineaNeta, Seccion, CodAlmacen, Descripcion, CodArticulo "
"FROM ComAlbaLin"
""

[CONDICIONS] 3
"NumAlbaran","Nmero de albarn",1,0,"CAB 2","NumAlbaran"
"Seccion","Seccion",1,1,"CAB 2","Seccion"
"CodProveedor","Proveedor",1,1,"CAB 2","CodProveedor"

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
3,"COS","CodArticulo",5,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",30,0,"ARIAL",8,105,0,"0000",""
3,"COS","Cantidad",148,0,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","Precio",165,0,"ARIAL",8,0,1,"0000","Precio"
3,"COS","Iva",175,0,"ARIAL",8,0,1,"0000",""
3,"COS","Total",200,0,"ARIAL",8,0,1,"0000","SubTotal"
[FICAP]
[FIGRUP]

[CALCULS] 3
"MiTotal","COS","Total","CAB 2"
"TotalBrut","COS","Total","CAB 1"
"@DES", "CAB 1", "VenFacturas", "CAB 1"

[FIDOCUM]