"VER1.0","Presupuesto","Presupuesto de Clientes"
;Versio, Categoria, Descripcion
;Ampla, Llarg, [EspaiCos]
;MargenX, MargenY, EtiLin, EtiPag
; 0, 152, 30
[DOCUM]
 V, 9, 62
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] 10
2, "Anagrama.bmp", 5, 5, 110, 42
0, "PRESUPUESTO", 120, 21, "ARIAL BLACK", 22, 0, 0, "0000"
3, "CABECERA", "NombreFiscal", 120, 4, "ARIAL", 10, 0, 0, "1000", ""
3, "CABECERA", "Domicilio", 120, 8, "ARIAL", 8, 0, 0, "0000", ""
0, "Tel. ", 120, 11, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Telefono1", 127,11, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "Pueblo", 120, 14, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "ProvPais", 120, 17, "ARIAL", 8, 0, 0,"0000", ""
0, "C.I.F. / N.I.F. :", 150, 11, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Nif", 166, 11, "ARIAL", 8, 0, 0, "0000", ""
;3, "CABECERA", "E-Mail", 145, 17, "ARIAL", 8, 0, 0, "0000", ""
;;3, "CABECERA", "Web", 120, 23, "ARIAL", 8, 0, 0,"0000", ""
[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#
""
""
""
[CAPSALERA]
0, 0, #TRUE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 21
1, "CuadroAdrea", 113, 33, 203, 75, 1, 0,
1, "CuadroFact", 10, 45, 102, 58, 1, 0,
1, "CuadroFact", 10, 60, 102, 73, 1, 0,
0,"Fecha",15,46,"ARIAL",8,0,0,"1000"
0,"N Presupuesto",40,46,"ARIAL",8,0,0,"1000"
0,"Repr.",15,60,"ARIAL",8,0,0,"1000"
1, "CuadroCos", 10, 78, 203, 235, 1, 0,
1, "lineaH", 10, 84, 203, 84,,,
1, "lineaV", 187, 78, 187, 235,,,
1, "lineaV", 177, 78, 177, 235,,,
1, "lineaV", 167, 78, 167, 235,,,
1, "lineaV", 151, 78, 151, 235,,,
1, "lineaV", 137, 78, 137, 235,,,
1, "lineaV", 38, 78, 38, 235,,,
0,"Cdigo",12,79,"ARIAL",8,0,0,"1000"
0,"Descripcin",42,79,"ARIAL",8,0,0,"1000"
0,"Cantidad",150,79,"ARIAL",8,0,1,"1000"
0,"Precio",165,79,"ARIAL",8,0,1,"1000"
0,"Dto",175,79,"ARIAL",8,0,1,"1000"
0,"Iva",183,79,"ARIAL",8,0,1,"1000"
0,"Total",199,79,"ARIAL",8,0,1,"1000"


[FICAP]

[PEU]
0, 51, #FALSE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0, "TOTAL :", 170, 0,"ARIAL",12,0,1,"1000"
;0,"OBSERVACIONES :", 0, 5,"ARIAL",9,0,0,"0000"

[FIPEU]
[FIGRUP]

;--------------------------------------------------------------------------
;tipo, NomGrup, Select, From, GropBy
;"SELECT ModoPago.Linea1,ModoPago.Linea2,ModoPago.Linea3,ModoPago.Linea4,ModoPago.Descripcion & ' - ' & TipoPago.Descripcion as Pagament, VenPrev.*, CodigosPostales.CodPostal & ' - ' & CodigosPostales.Ciudad AS Ciudad1, Provincias.Provincia & '  ' & Paises.Pais AS ProPais, Monedas.Decimales, Monedas.ValorVenta AS Cambio, [Total]*[CodIVA]/100 AS CuotaIva, [Total]+[CuotaIva] AS Neto, ModoPago.*, TipoPago.*"
;"FROM TipoPago RIGHT JOIN (((((VenPrev LEFT JOIN CodigosPostales ON (VenPrev.CodPais = CodigosPostales.CodPais) AND (VenPrev.CodPostal = CodigosPostales.CodPostal)) LEFT JOIN Provincias ON (CodigosPostales.CodProvincia = Provincias.CodProvincia) AND (CodigosPostales.CodPais = Provincias.CodPais)) LEFT JOIN Paises ON VenPrev.CodPais = Paises.CodPais) LEFT JOIN Monedas ON VenPrev.CodMoneda = Monedas.CodMoneda) LEFT JOIN ModoPago ON VenPrev.CodFormaPago = ModoPago.CodPago) ON TipoPago.CodPago = VenPrev.CodTipoPago"

[GRUP]
2,"CAB 1", #TRUE#
"SELECT (SELECT first(Defecto.TipoIva) FROM Defecto) as TipoIva1, (SELECT First(iif(isnull(VenPrevLin.CodIva),0,VenPrevLin.CodIva)) AS SumaDeTotal FROM VenPrevLin WHERE (VenPrevLin.CodIva<>(SELECT first(Defecto.TipoIva) FROM Defecto)) AND (VP.Seccion=VenPrevLin.Seccion) AND (VP.Numero=VenPrevLin.Numero) GROUP BY 
VenPrevLin.Numero, VenPrevLin.Seccion) as TipoIva2, VP.ImportePorte as Portes, (SELECT Sum(iif(isnull(VenPrevLin.Total),0,VenPrevLin.Total)) AS SumaDeTotal FROM VenPrevLin WHERE (VenPrevLin.CodIva=(SELECT first(Defecto.TipoIva) FROM Defecto)) AND (VP.Seccion=VenPrevLin.Seccion) AND (VP.Numero=VenPrevLin.Numero) GROUP BY 
VenPrevLin.Numero, VenPrevLin.Seccion) AS NETO1, (SELECT Sum(iif(isnull(VenPrevLin.Total),0,VenPrevLin.Total)) AS SumaDeTotal FROM VenPrevLin WHERE (VenPrevLin.CodIva<>(SELECT first(Defecto.TipoIva) FROM Defecto)) AND (VP.Seccion=VenPrevLin.Seccion) AND (VP.Numero=VenPrevLin.Numero) GROUP BY 
VenPrevLin.Numero, VenPrevLin.Seccion) AS NETO2, (SELECT Sum(iif(isnull(VenPrevLin.Total),0,VenPrevLin.Total)) AS SumaDeTotal FROM VenPrevLin WHERE (VenPrevLin.CodIva=(SELECT first(Defecto.TipoIva) FROM Defecto)) AND (VP.Seccion=VenPrevLin.Seccion) AND (VP.Numero=VenPrevLin.Numero) GROUP BY VenPrevLin.Numero, VenPrevLin.Seccion)*-1/100*(IIf(IsNull(VP.DescuentoPP),0,VP.DescuentoPP)) AS DstoBASE1, (SELECT Sum(iif(isnull(VenPrevLin.Total),0,VenPrevLin.Total)) AS SumaDeTotal FROM VenPrevLin WHERE (VenPrevLin.CodIva<>(SELECT first(Defecto.TipoIva)
FROM Defecto)) AND (VP.Seccion=VenPrevLin.Seccion) AND (VP.Numero=VenPrevLin.Numero) GROUP BY 
VenPrevLin.Numero, VenPrevLin.Seccion)*-1/100*(IIf(IsNull(VP.DescuentoPP),0,VP.DescuentoPP)) AS DstoBASE2, NETO1+DstoBase1 + iif(isnull(VP.ImportePorte),0,VP.ImportePorte) AS BaseImponible1, NETO2+DstoBase2 AS BaseImponible2, (SELECT Sum(iif(isnull(VenPrevLin.Total),0,VenPrevLin.Total)*iif(isnull(VenPrevLin.CodIVA),0,VenPrevLin.CodIVA)/100) AS SumaDeTotal FROM VenPrevLin WHERE (VP.Seccion=VenPrevLin.Seccion) AND (VP.Numero=VenPrevLin.Numero) GROUP BY VenPrevLin.Numero, VenPrevLin.Seccion) AS IvaLineas, BaseImponible1*(SELECT first(Defecto.TipoIva) FROM Defecto)/100 AS IvaBase1, BaseImponible2*(SELECT First(iif(isnull(VenPrevLin.CodIva),0,VenPrevLin.CodIva)) AS SumaDeTotal FROM VenPrevLin WHERE (VenPrevLin.CodIva<>(SELECT first(Defecto.TipoIva) FROM Defecto)) AND (VP.Seccion=VenPrevLin.Seccion) AND (VP.Numero=VenPrevLin.Numero) GROUP BY 
VenPrevLin.Numero, VenPrevLin.Seccion)/100 AS IvaBase2,iif(isnull(BaseImponible1),0,BaseImponible1)+iif(isnull(IvaBase1),0,IvaBase1)+iif(isnull(BaseImponible2),0,BaseImponible2)+iif(isnull(IvaBase2),0,IvaBase2) as TotalBueno, ((IIf(IsNull(VP.DescuentoPP),0,VP.DescuentoPP)*VP.total/100)*-1) AS DstoPP, (VP.Total-((IIf(IsNull(VP.DescuentoPP),0,VP.DescuentoPP)*VP.total/100))+IIf(IsNull(VP.ImportePorte),0,VP.ImportePorte)) AS BaseImpo, IIf(Len(VP.Direccion)>=50,'1','0') AS DireLarga, IIf(Len(VP.Direccion)<50,'1','0') AS DireCorta, ModoPago.Linea1 AS L1, ModoPago.Linea2 AS L2, ModoPago.Linea3 AS L3, ModoPago.Linea4 AS L4, ModoPago.Descripcion & ' - ' & TipoPago.Descripcion AS Pagament, VP.*, CodigosPostales.CodPostal & ' - ' & CodigosPostales.Ciudad AS Ciudad1, Provincias.Provincia & '  ' & Paises.Pais AS ProPais, Monedas.Decimales, Monedas.ValorVenta AS Cambio, [Total]*[CodIVA]/100 AS CuotaIva, [Total]+[CuotaIva] AS Neto, ModoPago.*, TipoPago.*, Direcciones.Observaciones AS Obs1, Direcciones.Observaciones1 AS Obs2, Direcciones.Observaciones2 AS Obs3, Direcciones.Observaciones3 AS Obs4"
"FROM (TipoPago RIGHT JOIN (((((VenPrev AS VP LEFT JOIN CodigosPostales ON (VP.CodPostal = CodigosPostales.CodPostal) AND (VP.CodPais = CodigosPostales.CodPais)) LEFT JOIN Provincias ON (CodigosPostales.CodPais = Provincias.CodPais) AND (CodigosPostales.CodProvincia = Provincias.CodProvincia)) LEFT JOIN Paises ON VP.CodPais = Paises.CodPais) LEFT JOIN Monedas ON VP.CodMoneda = Monedas.CodMoneda) LEFT JOIN ModoPago ON VP.CodFormaPago = ModoPago.CodPago) ON TipoPago.CodPago = VP.CodTipoPago) LEFT JOIN Direcciones ON (VP.CodCliente = Direcciones.CodCliente) AND (VP.CodDireccionEnvio = Direcciones.CodDireccion)"
""

[CONDICIONS] 4
"Numero","Nmero Presupuesto",0,0
"Seccion","Seccin",0,1
"Fecha","Fecha",0,2
"NombreCliente","Nombre Cliente",0,1

[CAPSALERA]
0, 87, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 12
0,"Pgina",70,60,"ARIAL",8,0,0,"1000"
6,"Pagina",70,65,"ARIAL",8,0,0,"0000",""
3,"CAB 1","Fecha",13,52,"ARIAL",8,0,0,"0000",""
3,"CAB 1","Numero",45,52,"ARIAL",8,0,0,"0000",""
3,"CAB 1","CodCliente",120,40,"ARIAL",10,0,0,"0000",""
3,"CAB 1","NombreCliente",120,45,"ARIAL",10,0,0,"0000",""
8, "0", "LEFT$(Campo('CAB 1','Direccion'),50)",120,50,"ARIAL",10,0,0,"0000",""
8, "0", "MID$(Campo('CAB 1','Direccion'),51,50)",120,55,"ARIAL",10,0,0,"0000",""
8, "0", " LEFT$(Campo('CAB 1','Ciudad1'),ABS(140*Campo('CAB 1','DireLarga')))", 120, 60, "ARIAL", 10, 0, 0, "0000", ""
8, "0", " LEFT$(Campo('CAB 1','ProPais'),ABS(140*Campo('CAB 1','DireLarga')))", 120, 65, "ARIAL", 10, 0, 0, "0000", ""
8, "0", " LEFT$(Campo('CAB 1','Ciudad1'),ABS(140*Campo('CAB 1','DireCorta')))", 120, 55, "ARIAL", 10, 0, 0, "0000", ""
8, "0", " LEFT$(Campo('CAB 1','ProPais'),ABS(140*Campo('CAB 1','DireCorta')))", 120, 60, "ARIAL", 10, 0, 0, "0000", ""

[FICAP]

[PEU]
0,51, #TRUE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 35
0,"OBSERVACIONES :", 12, 2,"ARIAL",9,0,0,"1001"
0,"TOTALES :", 12, 12,"ARIAL",9,0,0,"1001"
0,"MODO PAGO :", 12, 28,"ARIAL",9,0,0,"1001"
3, "CAB 1", "NumDoc", 45, 2, "ARIAL", 9, 0, 0,"0000", ""
3, "CAB 1", "Pagament", 45, 28, "ARIAL", 9, 0, 0,"0000", ""
3, "CAB 1", "ModoPago.Observaciones", 45, 32, "ARIAL", 9, 0, 0,"0000", ""
3, "CABECERA", "LineaObsAutomatica", 10, 45, "ARIAL", 9, 0, 0,"0000", ""
0, "Tipo Iva", 42, 11, "ARIAL", 8, 0, 1, "1000"
0, "Imp.Bruto", 60, 11, "ARIAL", 8, 0, 1, "1000"
0, "Desc. P.P.", 85, 11, "ARIAL", 8, 0, 1, "1000"
0, "Base Imp.", 110, 11, "ARIAL", 8, 0, 1, "1000"
0, "Portes", 148, 11, "ARIAL", 8, 0, 1, "1000"
0, "IVA", 128, 11, "ARIAL", 8, 0, 1, "1000"
0, "Portes", 148, 11, "ARIAL", 8, 0, 1, "1000"
0, "TOTAL", 200, 11, "ARIAL", 9, 0, 1, "1000"
3, "CAB 1", "TipoIva1", 42, 16, "ARIAL", 8, 0, 1,"0000", ""
3, "CAB 1", "TipoIva2", 42, 19, "ARIAL", 8, 0, 1,"0000", ""
3, "CAB 1", "Neto1", 58, 16, "ARIAL", 8, 0, 1,"0000", "Total"
3, "CAB 1", "Neto2", 58, 19, "ARIAL", 8, 0, 1,"0000", "Total"
3, "CAB 1", "DstoBASE1", 83, 16, "ARIAL", 8, 0, 1,"0000", "Total"
3, "CAB 1", "DstoBASE2", 83, 19, "ARIAL", 8, 0, 1,"0000", "Total"
3, "CAB 1", "BaseImponible1", 108, 16, "ARIAL", 8, 0, 1,"0000", "Total"
3, "CAB 1", "BaseImponible2", 108, 19, "ARIAL", 8, 0, 1,"0000", "Total"
3, "CAB 1", "IvaBase1", 128, 16, "ARIAL", 8, 0, 1,"0000", "Total"
3, "CAB 1", "IvaBase2", 128, 19, "ARIAL", 8, 0, 1,"0000", "Total"
3, "CAB 1", "Portes", 148, 16, "ARIAL", 8, 0, 1,"0000", "Total"
3, "CAB 1", "TotalBueno", 198, 16, "ARIAL", 12, 0, 1,"1000", "Total"
0, "", 199, 16, "ARIAL", 12, 0, 0, "1000"
1, "CuadroPeu", 10, 0, 202, 8, 1, 0,
1, "CuadroModoPago", 10, 10, 202, 24, 1, 0,
1, "CuadroObservaciones", 10, 26, 202, 46, 1, 0,
3,"CAB 1","L1",140,28,"ARIAL",9,0,0,"1000",""
3,"CAB 1","L2",140,33,"ARIAL",9,0,0,"0000",""
3,"CAB 1","L3",140,37,"ARIAL",9,0,0,"0000",""
3,"CAB 1","L4",140,41,"ARIAL",9,0,0,"0000",""
;5, 0, "CuotaNeto", 198, 15, "ARIAL", 8, 0, 1, "1000","Total"
;5, 0, "TotalBrut", 58, 15, "ARIAL", 8, 0, 1, "0000","Total"
;5, 0, "CuotaIvaaaa", 128, 19, "ARIAL", 8, 0, 1, "1000","Total"
;3, "CAB 1", "DstoPP", 83, 15, "ARIAL", 8, 0, 1,"0000", "Total"
[FIPEU]
[FIGRUP]

;--------------------------------------------------------
;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT IIf(LineaNeta,' Neta','') & Descuento1 & ' ' & Descuento2 & ' ' & Descuento3 AS Descuentos, IIf(IsNull([Total]),0,[Total])*IIf(IsNull([Iva]),0,[Iva])/100 AS CuotaIva, IIf(IsNull([Total]),0,[Total])+[CuotaIva] AS Neto, VenPrevLin.Iva, VenPrevLin.CodCliente, VenPrevLin.Total, VenPrevLin.Recargo, VenPrevLin.Iva, VenPrevLin.CodIVA, VenPrevLin.CodDescuento, VenPrevLin.Precio, VenPrevLin.Numero, VenPrevLin.Cantidad, VenPrevLin.NumLinea, VenPrevLin.LineaNeta, VenPrevLin.Seccion, VenPrevLin.CodAlmacen, VenPrevLin.Descripcion, VenPrevLin.CodArticulo"
"FROM VenPrevLin"
""

[ORDENACIONS] 1
"NumLinea","NumLinea",3

[CONDICIONS] 3
"Numero","Nmero de presupuesto",1,0,"CAB 1","Numero"
"Seccion","Nmero de presupuesto",1,1,"CAB 1","Seccion"
"CodCliente","Nmero de presupuesto",1,1,"CAB 1","CodCliente"

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 7
3,"COS","CodArticulo",12,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",40,0,"ARIAL",8,110,0,"0000",""
3,"COS","Cantidad",150,0,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","Precio",165,0,"ARIAL",8,0,1,"0000","Precio"
3,"COS","Descuentos",175,0,"ARIAL",8,0,1,"0000",""
3,"COS","Iva",185,0,"ARIAL",8,0,1,"0000",""
3,"COS","Total",200,0,"ARIAL",8,0,1,"0000","SubTotal"
;3,"COS","CuotaTotalIva",200,0,"ARIAL",8,0,1,"0000","SubTotal"
;3,"COS","CuotaNeto",200,0,"ARIAL",8,0,1,"0000","SubTotal"
;3,"COS","NumPedido",37,0,"ARIAL",8,0,0,"0000",""
[FICAP]

[FIGRUP]

[CALCULS] 6
"TotalBrut","COS","Total","CAB 1"
"CuotaIvaaa","COS","CuotaIva","CAB 1"
"CuotaIvaaaa","COS","IVAPablo","CAB 1"
"CuotaNeto","COS","Neto","CAB 1"
"@CAM","CAB 1","Cambio","CAB 1"
"@DEC","CAB 1","Decimales","CAB 1"
[FIDOCUM]
