"VER1.0","Factura","Facturas de Clientes"
;Versio, Categoria, Descripcion


;Ampla, Llarg, [EspaiCos]
;MargenX, ,MargenY, EtiLin, EtiPag
[DOCUM]
 0, 0, 62
 -3, 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] 1
2, "Anagrama.bmp", 5, 5, 205, 42
;3, "CABECERA", "NombreFiscal", 120, 5, "ARIAL", 8, 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", ""
;0, "FAX. ", 150, 11, "ARIAL", 8, 0, 0, "0000"
;3, "CABECERA", "Fax", 157, 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", ""
;3, "CABECERA", "E-Mail", 120, 20, "ARIAL", 8, 0, 0, "0000", ""
;3, "CABECERA", "Web", 120, 23, "ARIAL", 8, 0, 0,"0000", ""
;0, "C.I.F. / N.I.F. :", 120, 26, "ARIAL", 8, 0, 0, "0000"
;3, "CABECERA", "Nif", 143, 26, "ARIAL", 8, 0, 0, "0000", ""
[FICAP]

; En Impresos recomendable crear con valor PrintAll a True
[PEU]
0, 7, #TRUE#, 2, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3, "CABECERA", "RegistroMercantil", 100, 0, "ARIAL", 6, 0,2, "0000", ""
[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] 27
1, "CuadroAdrea", 113, 33, 200, 75, 1, 0,
1, "CuadroFact", 5, 45, 102, 59, 1, 0,
1, "lineaH", 5, 50, 102, 50,,,
0,"Fecha",10,46,"ARIAL",8,0,0,"0000"
0,"N Factura",45,46,"ARIAL",8,0,0,"0000"
0,"Cliente",75,46,"ARIAL",8,0,0,"0000"
1, "CuadroOtros", 5, 60, 102, 74, 1, 0,
1, "lineaH", 5, 65, 102, 65,,,
0,"Su Proveedor",10,61,"ARIAL",8,0,0,"0000"
0,"C.I.F./N.I.F.",75,61,"ARIAL",8,0,0,"0000"
1, "CuadroCos", 5, 78, 205, -64, 1, 0,
1, "lineaH", 5, 83, 205, 83,,,
1, "lineaV", 20, 78, 20, -64,,,
1, "lineaV", 45, 78, 45, -64,,,
1, "lineaV", 80, 78, 80, -64,,,
1, "lineaV", 151, 78, 151, -64,,,
1, "lineaV", 165, 78, 165, -64,,,
1, "lineaV", 179, 78, 179, -64,,,
1, "lineaV", 185, 78, 185, -64,,,
0,"Albaran", 7,79,"ARIAL",8,0,0,"0000"
0,"Pedido", 22,79,"ARIAL",8,0,0,"0000"
0,"Cdigo", 55,79,"ARIAL",8,0,0,"0000"
0,"Descripcin", 90,79,"ARIAL",8,0,0,"0000"
0,"Cantidad",163,79,"ARIAL",8,0,1,"0000"
0,"Precio",176,79,"ARIAL",8,0,1,"0000"
0,"Iva",184,79,"ARIAL",8,0,1,"0000"
0,"Total",203,79,"ARIAL",8,0,1,"0000"
[FICAP]

[PEU]
0, 60, #FALSE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 17
1, "CuadroBrut", 5, 0, 175, 16, 1, 0,#FALSE#
0, "Importe Bruto", 8, 1,"ARIAL",8,0,0,"0000"
0, "% Dto. Comercial", 67, 1,"ARIAL",8,0,1,"0000"
0, "% Dto. Pronto Pago", 95, 1,"ARIAL",8,0,1,"0000"
0, "I.V.A.", 130, 1,"ARIAL",8,0,0,"0000"
0, "R.E.", 159, 1,"ARIAL",8,0,0,"0000"
1, "CuadroTot", 178, 0, 205, 16, 1, 0,
0, "Total", 195, 1,"ARIAL",12,0,1,"0000"
1, "CuadroFP", 5, 19, 82, 41, 1, 0,
0, "Condiciones de pago", 8, 20,"ARIAL",8,0,0,"0000"
1, "CuadroIva", 83, 19, 205, 41, 1, 0,
0, "Desglose de I.V.A.", 85, 20,"ARIAL",8,0,0,"0000"
0, "Tipo", 113, 20,"ARIAL", 8,0,0,"0000"
0, "B.Imponible", 123, 20,"ARIAL", 8,0,0,"0000"
0, "I.V.A.      Importe", 147, 20,"ARIAL",8,0,0,"0000"
0, "%  R.E.     Importe", 179, 20,"ARIAL",8,0,0,"0000"
0, "Domiciliacion :", 8, 42,"ARIAL",8,0,0,"0000"
;0, "OBSERVACIONES :", 0, 42,"ARIAL",9,0,0,"0000"
;0, "Total Euros :", 165, 35,"ARIAL",8,0,0,"0000"
[FIPEU]

[FIGRUP]


;-----------------------------------------
;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB 1", #TRUE#
"SELECT VenFacturas.*, VenImp.*, VenVto.*, Domiciliacion.*, CodigoPostal & ' - ' & Poblacion as Pueblo, VenFacturas.Provincia & ' - ' & VenFacturas.Pais as Ciudad, Monedas.Decimales, Clientes.*, Representantes.*, Descuento1 & ' ' & Descuento2 & ' ' & Descuento3 as Descuentos "
"FROM (((((VenFacturas LEFT JOIN VenImp ON (VenFacturas.Seccion = VenImp.Seccion) AND (VenFacturas.NumFactura = VenImp.NumFactura)) LEFT JOIN VenVto ON (VenFacturas.Seccion = VenVto.Seccion) AND (VenFacturas.NumFactura = VenVto.NumFactura)) LEFT JOIN Domiciliacion ON (Domiciliacion.CodCuenta = VenFacturas.CodCuentaBancaria) AND (VenFacturas.CodCliente = Domiciliacion.CodCliente)) LEFT JOIN Monedas ON (Monedas.CodMoneda = VenFacturas.CodMoneda)) LEFT JOIN Clientes ON (VenFacturas.CodCliente=Clientes.CodCliente)) LEFT JOIN Representantes ON (Clientes.CodRepresentante=Representantes.CodRepresentante)"
""

[CONDICIONS] 5
"VenFacturas.NumFactura","Nmero Factura",0,1
"VenFacturas.Seccion","Seccin",0,1
"VenFacturas.FechaFactura","Fecha",0,2
"VenFacturas.NombreFiscal","Nombre Cliente",0,1
"@COP", "Nmero Copias :", 9, "", ""

[ORDENACIONS] 1
"VenFacturas.NumFactura","Ordenacion1",3

[CAPSALERA]
0, 87, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 11
0,"Pgina",175,27,"ARIAL",8,0,0,"0000"
6,"Pagina",189,27,"ARIAL",8,0,0,"0000",""
3,"CAB 1","FechaFactura",10,52,"ARIAL",8,0,0,"0000",""
3,"CAB 1","VenFacturas.NumFactura",50,52,"ARIAL",8,0,0,"0000",""
3,"CAB 1","VenFacturas.CodCliente",75,52,"ARIAL",10,0,0,"0000",""
3,"CAB 1","VenFacturas.NombreFiscal",120,45,"ARIAL",10,0,0,"0000",""
3,"CAB 1","VenFacturas.Direccion",120,50,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Pueblo",120,55,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Ciudad",120,60,"ARIAL",10,0,0,"0000",""
3,"CAB 1","VenFacturas.NIF",75,67,"ARIAL",8,0,0,"0000",""
3,"CAB 1","sucodproveedor",10,67,"ARIAL",8,0,0,"0000",""
;3,"CAB 1","PersonaContacto",45,67,"ARIAL",8,0,0,"0000",""
[FICAP]

[PEU]
0, 60, #TRUE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 39
5, 0, "TotalBrut", 25, 10, "ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Descuentos", 45, 10, "ARIAL", 10, 0, 0, "0000",""
3, "CAB 1", "TDesCo", 67, 10, "ARIAL", 10, 0, 1, "0000","Total"
3, "CAB 1", "VenFacturas.DescuentoPP", 74, 10, "ARIAL", 10, 0, 0, "0000",""
3, "CAB 1", "TDesPP", 95, 10, "ARIAL", 10, 0, 1, "0000","Total"
3, "CAB 1", "BaseImponible1", 140, 25, "ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Iva1", 150, 25,"ARIAL", 10, 0, 1, "0000", ""
6, "@IVA1", 170, 25,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Re1", 185, 25, "ARIAL", 10, 0, 1, "0000",  ""
6, "@RE1", 203, 25,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "BaseImponible2", 140, 30, "ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Iva2", 150, 30,"ARIAL", 10, 0, 1, "0000", ""
6, "@IVA2", 170, 30,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Re2", 185, 30, "ARIAL", 10, 0, 1, "0000",  ""
6, "@RE2", 203, 30,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "BaseImponible3", 140, 35, "ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Iva3", 150, 35,"ARIAL", 10, 0, 1, "0000", ""
6, "@IVA3", 170, 35,"ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Re3", 185, 35, "ARIAL", 10, 0, 1, "0000",  ""
6, "@RE3", 203, 35,"ARIAL", 10, 0, 1, "0000", "Total"
6, "@IVA", 135, 10, "ARIAL", 10, 0, 1, "0000", "Total"
6, "@RE", 165, 10, "ARIAL", 10, 0, 1, "0000", "Total"
3, "CAB 1", "Total", 203, 10, "ARIAL", 12, 0, 1, "0000","Total"
3, "CAB 1", "Vto1", 10, 25, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto2", 10, 30, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto3", 10, 35, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto4", 45, 25, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto5", 45, 30, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Vto6", 45, 35, "ARIAL", 8, 0, 0, "0000", ""
3, "CAB 1", "Imp1", 40, 25, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp2", 40, 30, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp3", 40, 35, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp4", 75, 25, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp5", 75, 30, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "Imp6", 75, 35, "ARIAL", 8, 0, 1, "0000", "Total"
3, "CAB 1", "CodEntidad", 30, 42, "ARIAL", 10, 0, 0, "0000", ""
3, "CAB 1", "CodOficina", 42, 42, "ARIAL", 10, 0, 0, "0000", ""
3, "CAB 1", "NumCuenta", 53, 42, "ARIAL", 10, 0, 0, "0000", ""
3, "CAB 1", "DC", 75, 42, "ARIAL", 10, 0, 0, "0000", ""
;0, "ENTIDAD  OFICINA    NUM.CUENTA.    D.C.", 0, 42,"ARIAL",9,0,0,"0000"
;8, "1", "Campo('CAB 1','Total')*166.386  ", 203, 35, "ARIAL", 8, 0, 1, "0000", "###,###"
[FIPEU]
[FIGRUP]

;5,0,"Total1",190, 5,"ARIAL",12,0,1,"1001" ,"Total"
;3,"CAB1","Monedas.CodMoneda",195, 5,"ARIAL",12,0,0,"1000",""
;-----------------------------------------

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

[ORDENACIONS] 1
"FechaAlbaran, NumAlbaran","Ordenacion1",3

[CONDICIONS] 2
"NumFactura","Nmero de Factura",1,1,"CAB 1","VenFacturas.NumFactura"
"Seccion","Nmero de Seccion",1,1,"CAB 1","VenFacturas.Seccion"

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;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, 0, #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
;"SELECT CodCliente, Total, Recargo, Iva, CodIVA, CodDescuento, Precio, NumAlbaran, Cantidad, NumLinea, LineaNeta, Seccion, CodAlmacen, Descripcion, CodArticulo, Descuento1 & ' ' & Descuento2 & ' ' & Descuento3 as Descuentos, NumPedido "
;"FROM VenAlbaLin"
[GRUP]
3,"COS", #FALSE#
"SELECT VenAlbaLin.CodCliente, VenAlbaLin.Total, VenAlbaLin.Recargo, VenAlbaLin.Iva, VenAlbaLin.CodIVA, VenAlbaLin.CodDescuento, VenAlbaLin.Precio, VenAlbaLin.NumAlbaran, VenAlbaLin.Cantidad, VenAlbaLin.NumLinea, VenAlbaLin.LineaNeta, VenAlbaLin.Seccion, VenAlbaLin.CodAlmacen, VenAlbaLin.Descripcion, VenAlbaLin.CodArticulo,  VenAlbaLin.Descuento1 & ' ' & VenAlbaLin.Descuento2 & ' ' & VenAlbaLin.Descuento3 AS Descuentos, VenAlbaLin.NumPedido, Articulos.CodArticuloProveedor"
"FROM VenAlbaLin LEFT JOIN Articulos ON VenAlbaLin.CodArticulo = Articulos.CodArticulo"
""

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

[CONDICIONS] 4
"NumAlbaran","Nmero de albarn",1,0,"CAB 2","NumAlbaran"
"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"
"CodCliente","Nmero de albarn",1,1,"CAB 2","CodCliente"
"(VenAlbaLin.CodArticulo<>'' OR Total<>0)","",4

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 8
3,"COS","NumAlbaran", 7,0,"ARIAL",8,0,0,"0000",""
3,"COS","NumPedido", 22,0,"ARIAL",8,0,0,"0000",""
3,"COS","CodArticuloproveedor", 48,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion", 82,0,"ARIAL",8,70,0,"0000",""
3,"COS","Cantidad", 163,0,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","Precio", 177,0,"ARIAL",8,0,1,"0000","Precio"
3,"COS","Iva", 183,0,"ARIAL",8,0,1,"0000",""
3,"COS","Total", 203,0,"ARIAL",8,0,1,"0000","SubTotal"
;3,"COS","Descuentos",173,0,"ARIAL",8,0,1,"0000",""
[FICAP]
[FIGRUP]

[CALCULS] 6
"MiTotal", "COS", "Total", "CAB 2"
"TotalBrut", "COS", "Total", "CAB 1"
"@CAM", "CAB 1", "Cambio", "CAB 1"
"@DEC", "CAB 1", "Decimales", "CAB 1"
"@COP", "CAB 1", "NumCopiasFra", "CAB 1"
"@DES", "CAB 1", "VenFacturas", "CAB 1"


[FIDOCUM]

; "@DIV","CAB1","Monedas.CodMoneda","CAB1"
