"VER1.0","Presupuesto","Presupuesto de Clientes"
;Versio, Categoria, Descripcion
;Ampla, Llarg, [EspaiCos]
;MargenX, MargenY, EtiLin, EtiPag
; 0, 152, 30
[DOCUM]
 V, 9, 102
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] 36
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, 190, 1, 0,
1, "lineaH", 10, 84, 203, 84,,,
1, "lineaV", 187, 78, 187, 190,,,
1, "lineaV", 177, 78, 177, 190,,,
1, "lineaV", 167, 78, 167, 190,,,
1, "lineaV", 151, 78, 151, 190,,,
1, "lineaV", 137, 78, 137, 190,,,
1, "lineaV", 38, 78, 38, 190,,,
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"
3, "CABECERA", "LOPD1", 1, 244,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD2", 1, 247,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD3", 1, 250,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD4", 1, 253,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD5", 1, 256,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD6", 1, 259,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD7", 1, 262,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD8", 1, 265,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD9", 1, 268,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD10", 1, 271,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD11", 1, 274,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD12", 1, 277,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD13", 1, 280,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD14", 1, 283,"ARIAL",7, 0, 0,"0000", ""
3, "CABECERA", "LOPD15", 1, 286,"ARIAL",7, 0, 0,"0000", ""

[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 iif(len(VenPrev.Direccion)>=50,'1','0') as DireLarga,iif(len(VenPrev.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, 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.*, Direcciones.Observaciones as Obs1, Direcciones.Observaciones1 as Obs2, Direcciones.Observaciones2 as Obs3, Direcciones.Observaciones3 as Obs4"
"FROM (TipoPago RIGHT JOIN (((((VenPrev LEFT JOIN CodigosPostales ON (VenPrev.CodPostal = CodigosPostales.CodPostal) AND (VenPrev.CodPais = CodigosPostales.CodPais)) LEFT JOIN Provincias ON (CodigosPostales.CodPais = Provincias.CodPais) AND (CodigosPostales.CodProvincia = Provincias.CodProvincia)) 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) LEFT JOIN Direcciones ON (VenPrev.CodCliente = Direcciones.CodCliente) AND (VenPrev.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,103, #TRUE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 21
0,"OBSERVACIONES :", 12, 2,"ARIAL",9,0,0,"1001"
0,"TOTALES :", 12, 14,"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, "Imp.Bruto", 58, 14, "ARIAL", 8, 0, 1, "1000"
0, "IVA", 108, 14, "ARIAL", 8, 0, 1, "1000"
0, "TOTAL", 200, 14, "ARIAL", 8, 0, 1, "1000"
5, 0, "TotalBrut", 58, 19, "ARIAL", 8, 0, 1, "1000","Total"
5, 0, "CuotaIvaaa", 108, 19, "ARIAL", 8, 0, 1, "1000","Total"
5, 0, "CuotaNeto", 198, 19, "ARIAL", 8, 0, 1, "1000","Total"
0, "", 200, 19, "ARIAL", 8, 0, 0, "1000"
1, "CuadroPeu", 10, 0, 202, 10, 1, 0,
1, "CuadroModoPago", 10, 12, 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",""
[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] 5
"TotalBrut","COS","Total","CAB 1"
"CuotaIvaaa","COS","CuotaIva","CAB 1"
"CuotaNeto","COS","Neto","CAB 1"
"@CAM","CAB 1","Cambio","CAB 1"
"@DEC","CAB 1","Decimales","CAB 1"
[FIDOCUM]
