"VER1.0","Pedido","Pedidos a Proveedores (moderno)"
;Versio, Categoria, Descripcion
;Ampla, Llarg, [EspaiCos]
;MargenX, MargenY, EtiLin, EtiPag
; 0, 152, 30
[DOCUM]
0, 0, 34
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] 13
2, "Anagrama.png", 5, 5, 95, 27
0, "PEDIDO A PROVEEDOR", 5, 33, "ARIAL BLACK", 13, 0, 0, "0000"
3, "CABECERA", "NombreFiscal", 120, 5, "ARIAL", 11, 1, 0, "1000", ""
3, "CABECERA", "Domicilio", 120, 11, "ARIAL", 8, 0, 0, "0000", ""
0, "Tel. ", 120, 15, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Telefono1", 127,15, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "Pueblo", 120, 19, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "ProvPais", 120, 23, "ARIAL", 8, 0, 0,"0000", ""
3, "CABECERA", "E-Mail", 120, 27, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "Web", 120, 31, "ARIAL", 8, 0, 0,"0000", ""
0, "C.I.F. / N.I.F. :", 120, 35, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Nif", 143, 35, "ARIAL", 8, 0, 0, "0000", ""
1, "lineaCab", 5, 40, 203, 40,,,
[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] 25
1, "CuadroAdreca", 113, 41, 203, 79, 1, 0,
0, "DATOS DEL PROVEEDOR", 116, 44, "ARIAL", 8, 1, 0, "0000"
1, "CuadroFact", 6, 41, 102, 58, 1, 0,
0, "DATOS DEL PEDIDO", 9, 44, "ARIAL", 8, 1, 0, "0000"
0,"Fecha",9,52,"ARIAL",8,0,0,"0000"
0,"Nº Pedido",9,56,"ARIAL",8,0,0,"0000"
1, "CuadroOtros", 6, 60, 102, 79, 1, 0,
0, "ENTREGA", 9, 63, "ARIAL", 8, 1, 0, "0000"
0,"Fecha entrega",9,68,"ARIAL",8,0,0,"0000"
0,"Forma de pago",9,73,"ARIAL",8,0,0,"0000"
1, "CuadroCos", 0, 82, 203, -11, 1, 0,
1, "lineaH", 0, 88, 203, 88,,,
1, "lineaV", 187, 82, 187, -11,,,
1, "lineaV", 177, 82, 177, -11,,,
1, "lineaV", 167, 82, 167, -11,,,
1, "lineaV", 151, 82, 151, -11,,,
1, "lineaV", 137, 82, 137, -11,,,
1, "lineaV", 29, 82, 29, -11,,,
0,"Código",5,83,"ARIAL",8,1,0,"0000"
0,"Descripción",30,83,"ARIAL",8,1,0,"0000"
0,"Cantidad",150,83,"ARIAL",8,1,1,"0000"
0,"Precio",165,83,"ARIAL",8,1,1,"0000"
0,"Dto",175,83,"ARIAL",8,1,1,"0000"
0,"Iva",183,83,"ARIAL",8,1,1,"0000"
0,"Total",199,83,"ARIAL",8,1,1,"0000"
[FICAP]

[PEU]
0, 11, #FALSE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
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
[GRUP]
2,"CAB 1", #TRUE#
"SELECT ComPrev.*, CodigosPostales.CodPostal & ' - ' & CodigosPostales.Ciudad as Ciudad1, Provincias.Provincia & '  ' &  Paises.Pais as ProPais, Monedas.Decimales, Monedas.ValorVenta as Cambio, Nz(ComPrev.FechaPedido, ComPrev.Fecha) AS FechaDoc "
"FROM (((ComPrev LEFT JOIN CodigosPostales ON (ComPrev.CodPais = CodigosPostales.CodPais) AND (ComPrev.CodPostal = CodigosPostales.CodPostal)) LEFT JOIN Provincias ON (CodigosPostales.CodProvincia = Provincias.CodProvincia) AND (CodigosPostales.CodPais = Provincias.CodPais)) LEFT JOIN Paises ON ComPrev.CodPais = Paises.CodPais) LEFT JOIN Monedas ON ComPrev.CodMoneda = Monedas.CodMoneda"
""
[CONDICIONS] 4
"Numero","Número Pedido",0,0
"Seccion","Sección",0,1
"Fecha","Fecha",0,2
"NombreProveedor","Nombre Proveedor",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] 16
0,"Página",68,68,"ARIAL",8,0,0,"0000"
6,"Pagina",78,68,"ARIAL",8,0,0,"0000",""
3,"CAB 1","CodProveedor",120,60,"ARIAL",10,0,0,"0000",""
3,"CAB 1","NombreProveedor",120,45,"ARIAL",10,1,0,"0000",""
3,"CAB 1","Direccion",120,50,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Ciudad1",120,55,"ARIAL",10,0,0,"0000",""
3,"CAB 1","ProPais",120,60,"ARIAL",10,0,0,"0000",""
3,"CAB 1","FechaDoc",25,52,"ARIAL",8,0,0,"0000",""
3,"CAB 1","Numero",40,56,"ARIAL",8,0,0,"0000",""
3,"CAB 1","FechaEntrega",30,68,"ARIAL",8,0,0,"0000",""
0, "Dto. pronto pago", 9, 76, "ARIAL", 8, 0, 0, "1000"
3, "CAB 1", "DescuentoPP", 42, 76, "ARIAL", 8, 0, 1, "0000", ""
0, "%", 46, 76, "ARIAL", 8, 0, 0, "0000"
0, "Portes", 60, 73, "ARIAL", 8, 0, 0, "1000"
3, "CAB 1", "ImportePorte", 90, 73, "ARIAL", 8, 0, 1, "0000", ""
0, "C.I.F./N.I.F.", 60, 68, "ARIAL", 7, 0, 0, "1000"
[FICAP]

[PEU]
0,20, #TRUE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 8
1, "CuadroResumen", 130, 0, 203, 20, 1, 0,
0, "Base imponible", 133, 1, "ARIAL", 8, 0, 0, "0000"
5, 0, "TotalBrut", 199, 1, "ARIAL", 8, 0, 1, "0000","Total"
0, "IVA", 133, 6, "ARIAL", 8, 0, 0, "0000"
5, 0, "IvaTotalPedPro", 199, 6, "ARIAL", 8, 0, 1, "0000","Total"
0, "Recargo equiv.", 133, 11, "ARIAL", 8, 0, 0, "0000"
5, 0, "RETotalPedPro", 199, 11, "ARIAL", 8, 0, 1, "0000","Total"
3, "CABECERA", "LineaObsAutomatica", 5, 5, "ARIAL", 9, 0, 0,"0000", ""
[FIPEU]
[FIGRUP]

;--------------------------------------------------------
;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT CodProveedor, Total, Total*Iva/100 as ImporteIvaLinea, Total*Recargo/100 as ImporteReLinea, Recargo, Iva, CodIVA, CodDescuento, Precio, Numero, Cantidad, NumLinea, LineaNeta, Seccion, CodAlmacen, Descripcion, CodArticulo, Descuento1 & ' ' & Descuento2 & ' ' & Descuento3 as Descuentos "
"FROM ComPrevLin"
""

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

[CONDICIONS] 3
"Numero","Número de pedido",1,0,"CAB 1","Numero"
"Seccion","Número de pedido",1,1,"CAB 1","Seccion"
"CodProveedor","Número de pedido",1,1,"CAB 1","CodProveedor"

[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",10,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",40,0,"ARIAL",8,80,0,"0000",""
3,"COS","Cantidad",145,0,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Precio",160,0,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Descuentos",175,0,"ARIAL",8,0,0,"0000","","CodArticulo<>"
3,"COS","Iva",183,0,"ARIAL",8,0,1,"0000","","CodArticulo<>"
3,"COS","Total",200,0,"ARIAL",8,0,1,"0000","","CodArticulo<>"
[FICAP]
[FIGRUP]

[CALCULS] 5
"TotalBrut","COS","Total","CAB 1"
"IvaTotalPedPro","COS","ImporteIvaLinea","CAB 1"
"RETotalPedPro","COS","ImporteReLinea","CAB 1"
"@CAM","CAB 1","Cambio","CAB 1"
"@DEC","CAB 1","Decimales","CAB 1"
[FIDOCUM]
