"VER1.0","Albara","Facturas de Clientes"
;Versio, Categoria, Descripcion
;Ampla, Llarg, [EspaiCos]
;MargenX, MargenY, EtiLin, EtiPag
; 0, 152, 30
[DOCUM]
V, 9, 22
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)
;2, "Anagrama.BMP", 5, 5, 110, 32
[CAMPS] 16
2, "Anagrama.BMP", 5, 15, 100, 60
0, "DELIVERY NOTE", 135, 44, "ARIAL BLACK", 22, 0, 0, "0000"
3, "CABECERA", "NombreFiscal", 110, 5, "ARIAL", 14, 0, 0, "1000", ""
0, "Phone ", 110, 15, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Telefono1", 117,15, "ARIAL", 8, 0, 0, "0000", ""
0, "FAX. ", 140, 15, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Fax", 148, 15, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "Domicilio", 110, 19, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "Pueblo", 110, 23, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "ProvPais", 110, 27, "ARIAL", 8, 0, 0,"0000", ""
0, "C.I.F. / N.I.F. :", 110, 31, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Nif", 129, 31, "ARIAL", 8, 0, 0, "0000", ""
0, "eMail:", 110, 35, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "e-Mail", 119, 35, "ARIAL", 8, 0, 0, "0000", ""
0, "Web:", 110, 39, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Web", 119, 39, "ARIAL", 8, 0, 0, "0000", ""
;2, "Anagrama.BMP", 10, 9, 70, 40
;0, "VALLES INFORMATICA ", 80, 9, "COMIC SANS MS", 15, 0, 0, "0000"
;3, "CABECERA", "NombreFiscal", 80, 18, "ARIAL", 10, 0, 0, "1000", ""
;0, "Tel. ", 80, 27, "ARIAL", 8, 0, 0, "0000"
;3, "CABECERA", "Telefono1", 87,27, "ARIAL", 8, 0, 0, "0000", ""
;0, "E-mail: info@vallesinformatica.com", 80, 31, "ARIAL", 8, 0, 0, "0000"
;0, "www.vallesinformatica.com", 80, 35, "ARIAL", 8, 0, 0, "0000"
;3, "CABECERA", "Domicilio", 80, 23, "ARIAL", 8, 0, 0, "0000", ""
;0, "-", 125, 23, "ARIAL", 8, 0, 0, "0000"
;3, "CABECERA", "Pueblo", 130, 23, "ARIAL", 8, 0, 0, "0000", ""
;0, "-", 150, 23, "ARIAL", 8, 0, 0, "0000"
;3, "CABECERA", "ProvPais", 160, 23, "ARIAL", 8, 0, 0,"0000", ""
;0, "-    C.I.F. / N.I.F. :", 118, 18, "ARIAL", 8, 0, 0, "0000"
;3, "CABECERA", "Nif", 142, 18, "ARIAL", 8, 0, 0, "0000", ""
;3, "CABECERA", "Fax", 128, 35, "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)
;0,"Pedido",37,51,"ARIAL",8,0,0,"0000"
;0,"Dto",170,51,"ARIAL",8,0,1,"0000"
[CAMPS] 17
1, "CuadroAdrea", 115, 55, 202, 83, 1, 0,
1, "CuadroAlbaran", 5, 55, 105, 83, 1, 0,
1, "CuadroCos", 5, 90, 202, -52, 1, 0,
0,"Code Article",10,91,"ARIAL",8,0,0,"0000"
0,"Description",35,91,"ARIAL",8,0,0,"0000"
0,"Quant.",128,91,"ARIAL",8,0,1,"0000"
0,"Price",147,91,"ARIAL",8,0,1,"0000"
0,"Discount",168,91,"ARIAL",8,0,1,"0000"
0,"VTA",180,91,"ARIAL",8,0,1,"0000"
0,"Total",200,91,"ARIAL",8,0,1,"0000"
1, "lineaH", 5, 96, 202, 96,,,
1, "lineaV", 31, 90, 31, -52,,,
1, "lineaV", 111, 90, 111, -52,,,
1, "lineaV", 131, 90, 131, -52,,,
1, "lineaV", 151, 90, 151, -52,,,
1, "lineaV", 172, 90, 172, -52,,,
1, "lineaV", 182, 90, 182, -52,,,

[FICAP]

[PEU]
0, 19, #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 iif(importePorte>0,'+ ' & importePorte,'') as Port, VenAlba.*, CodigosPostales.CodPostal & ' - ' & CodigosPostales.Ciudad as Ciudad1, Provincias.Provincia & '  ' &  Paises.Pais as ProPais, Monedas.Decimales, Monedas.ValorVenta as Cambio, Clientes.NumCopiasAlb , Clientes.NumCopiasAlbSV  "
"FROM ((((VenAlba LEFT JOIN CodigosPostales ON (VenAlba.CodPostal = CodigosPostales.CodPostal) AND (VenAlba.CodPais = CodigosPostales.CodPais)) LEFT JOIN Provincias ON (CodigosPostales.CodPais = Provincias.CodPais) AND (CodigosPostales.CodProvincia = Provincias.CodProvincia)) LEFT JOIN Paises ON VenAlba.CodPais = Paises.CodPais) LEFT JOIN Monedas ON VenAlba.CodMoneda = Monedas.CodMoneda) LEFT JOIN Clientes ON VenAlba.CodCliente = Clientes.CodCliente"
""
[CONDICIONS] 5
"NumAlbaran","Nmero Albarn",0,0
"Seccion","Seccin",0,1
"FechaAlbaran","Fecha",0,2
"NombreCliente","Nombre Cliente",0,1
"@COP", "Nmero Copias :", 9, "", ""

[CAPSALERA]
0, 56, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 15
0,"Pgina",60,68,"ARIAL",9,0,0,"1000"
6,"Pagina",75,68,"ARIAL",9,0,0,"0000",""
3,"CAB 1","NombreCliente",120,60,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Direccion",120,65,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Ciudad1",120,70,"ARIAL",10,0,0,"0000",""
3,"CAB 1","ProPais",120,75,"ARIAL",10,0,0,"0000",""
0,"N Albarn",10,60,"ARIAL",9,0,0,"1000"
3,"CAB 1","NumAlbaran",30,60,"ARIAL",9,0,0,"0000",""
0,"Fecha",60,60,"ARIAL",9,0,0,"1000"
3,"CAB 1","FechaAlbaran",75,60,"ARIAL",9,0,0,"0000",""
3,"CAB 1","NIF",70,52,"ARIAL",9,0,0,"0000",""
0,"Cod. Cliente", 10, 68, "ARIAL", 9, 0, 0, "1000"
3,"CAB 1","CodCliente",30,68,"ARIAL",9,0,0,"0000",""
0,"N. oRDER", 10, 76, "ARIAL", 9, 0, 0, "1000"
3,"CAB 1","NumPedido",30,76,"ARIAL",9,0,0,"0000",""
[FICAP]

[PEU]
0, 45, #TRUE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
;5, 0, "Portes", 161, 5, "ARIAL", 8, 0, 1, "1000","Total"
[CAMPS] 19
1, "CuadroPeu", 5, 2, 202, 15, 1, 0,
1, "CuadroObser", 5, 17, 202, 25, 1, 0,
0,"OBSERVATIONS :", 12, 19,"ARIAL",9,0,0,"0000"
3, "CABECERA", "LineaObsAutomatica", 30, 19, "ARIAL", 9, 0, 0,"0000", ""
0, "Gross Amount", 28, 5, "ARIAL", 8, 0, 1, "1000"
0, "Discounts", 55, 5, "ARIAL", 8, 0, 1, "1000"
0, "Taxable base", 82, 5, "ARIAL", 8, 0, 1, "1000"
0, "VTA", 108, 5, "ARIAL", 8, 0, 1, "1000"
0, "R.E.", 135, 5, "ARIAL", 8, 0, 1, "1000"
0, "Carry", 161, 5, "ARIAL", 8, 0, 1, "1000"
0, "TOTAL", 195, 5, "ARIAL", 8, 0, 1, "1000"
3,"CAB 1","ImportePorte",161,10,"ARIAL",8,0,1,"1000","Total"
5, 0, "TotalBrut", 28, 10, "ARIAL", 8, 0, 1, "1000","Total"
6, "@DTO", 55, 10, "ARIAL", 8, 0, 1, "1000","Total"
6, "@BASE", 82, 10, "ARIAL", 8, 0, 1, "1000","Total"
6, "@IVA", 108, 10, "ARIAL", 8, 0, 1, "1000","Total"
6, "@RE", 135, 10, "ARIAL", 8, 0, 1, "1000","Total"
6, "@TOTAL", 194, 10, "ARIAL", 8, 0, 1, "1000","Total"
3,"CAB 1","Port",195,10,"ARIAL",8,0,0,"1000",""

;8, "1", "Campo('CAB 1','TOTAL') + Campo('CAB 1','ImportePorte')) ", 193, 0, "ARIAL", 28, 0, 1, "0000", "##0.00"
;0, "Total Ptas :", 150, 12, "ARIAL", 8, 0, 0, "1000"
;5, 0, "TotalEu", 200, 12, "ARIAL", 8, 0, 1, "1000","###,###,###"
[FIPEU]
[FIGRUP]

;--------------------------------------------------------
;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT CodCliente, Total, NumPedido, Recargo, Iva, CodIVA, CodDescuento, Precio, NumAlbaran, Cantidad, NumLinea, LineaNeta, Seccion, CodAlmacen, Descripcion, CodArticulo, Descuento1 & ' ' & Descuento2 & ' ' & Descuento3 as Descuentos "
"FROM VenAlbaLin"
""

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

[CONDICIONS] 3
"NumAlbaran","Nmero de albarn",1,0,"CAB 1","NumAlbaran"
"Seccion","Nmero de albarn",1,1,"CAB 1","Seccion"
"CodCliente","Nmero de albarn",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)
;3,"COS","NumPedido",37,0,"ARIAL",8,0,0,"0000",""
[CAMPS] 7
3,"COS","CodArticulo",10,45,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",35,45,"ARIAL",8,80,0,"0000",""
3,"COS","Cantidad",127,45,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","Precio",147,45,"ARIAL",8,0,1,"0000","Precio"
3,"COS","Descuentos",155,45,"ARIAL",8,0,0,"0000",""
3,"COS","Iva",180,45,"ARIAL",8,0,1,"0000",""
3,"COS","Total",202,45,"ARIAL",8,0,1,"0000","SubTotal"
[FICAP]
[FIGRUP]

[CALCULS] 5
"TotalBrut","COS","Total","CAB 1"
"@CAM","CAB 1","Cambio","CAB 1"
"@DEC","CAB 1","Decimales","CAB 1"
"@COP", "CAB 1", "NumCopiasAlb", "CAB 1"
"@DES", "CAB 1", "VenAlbaLin", "CAB 1"

[FIDOCUM]

