"VER1.0","Albara","Facturas de Clientes"
;Versio, Categoria, Descripcion
;Ampla, Llarg, [EspaiPeu]
;MargenX, MargenY, EtiLin, EtiPag
;     0, 152, 30 Corto  y    0, 0, 11 Largo
[DOCUM]
0, 152, 30
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] 11
2, "Anagrama.BMP", 5, 5, 110, 32
3, "CABECERA", "NombreFiscal", 10, 32, "ARIAL", 8, 0, 0, "1000", ""
0, "C.I.F./N.I.F.", 69, 32, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Nif", 85, 32, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "Domicilio", 10, 35, "ARIAL", 8, 0, 0, "0000", ""
0, "Tel. ", 75, 38, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Telefono1", 85, 38, "ARIAL", 8, 0, 0, "0000", ""
0, "FAX. ", 75, 41, "ARIAL", 8, 0, 0, "0000"
3, "CABECERA", "Fax", 85, 41, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "Pueblo", 10, 38, "ARIAL", 8, 0, 0, "0000", ""
3, "CABECERA", "ProvPais", 10, 41, "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] 10
1, "CuadroAdrea", 104, 11, 202, 41, 1, 0,
1, "CuadroCos", 7, 50, 202, -11, 1, 0,
1, "lineaH", 7, 55, 202, 55,,,
1, "lineaV", 36, 50, 36, -11,,,
1, "lineaV", 48, 50, 48, -11,,,
1, "lineaV", 130, 50, 130, -11,,,
1, "lineaV", 147, 50, 147, -11,,,
1, "lineaV", 162, 50, 162, -11,,,
1, "lineaV", 172, 50, 172, -11,,,
1, "lineaV", 182, 50, 182, -11,,,
;0,"Fecha",10,45,"ARIAL",8,0,0,"0000"
;0,"Num Albarn",48,45,"ARIAL",8,0,0,"0000"
;0,"Cdigo",10,51,"ARIAL",8,0,0,"0000"
;0,"Pedido",37,51,"ARIAL",8,0,0,"0000"
;0,"Descripcin",50,51,"ARIAL",8,0,0,"0000"
;0,"Cant.",145,51,"ARIAL",8,0,1,"0000"
;0,"Precio",160,51,"ARIAL",8,0,1,"0000"
;0,"Iva",170,51,"ARIAL",8,0,1,"0000"
;0,"Dto",180,51,"ARIAL",8,0,1,"0000"
;0,"Total",200,51,"ARIAL",8,0,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] 0
;0, "TOTAL :", 170, 0,"ARIAL",12,0,1,"1000"
;0, "Total Euros:", 170, 5,"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 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] 20
0,"Fecha",10,45,"ARIAL",8,0,0,"0000"
0,"Num Albarn",48,45,"ARIAL",8,0,0,"0000"
0,"Cdigo",10,51,"ARIAL",8,0,0,"0000"
0,"Pedido",37,51,"ARIAL",8,0,0,"0000"
0,"Descripcin",50,51,"ARIAL",8,0,0,"0000"
0,"Cant.",141,51,"ARIAL",8,0,1,"0000"
0,"Precio",160,51,"ARIAL",8,0,1,"0000"
0,"Iva",170,51,"ARIAL",8,0,1,"0000"
0,"Dto",180,51,"ARIAL",8,0,1,"0000"
0,"Total",200,51,"ARIAL",8,0,1,"0000"
0,"Pgina",170,45,"ARIAL",8,0,0,"0000"
6,"Pagina",187,45,"ARIAL",8,0,0,"0000",""
3,"CAB 1","CodCliente",120,15,"ARIAL",10,0,0,"0000",""
3,"CAB 1","NombreCliente",120,20,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Direccion",120,25,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Ciudad1",120,30,"ARIAL",10,0,0,"0000",""
3,"CAB 1","ProPais",120,35,"ARIAL",10,0,0,"0000",""
3,"CAB 1","FechaAlbaran",25,45,"ARIAL",8,0,0,"0000",""
3,"CAB 1","NumAlbaran",70,45,"ARIAL",8,0,0,"0000",""
3,"CAB 1","NIF",70,52,"ARIAL",8,0,0,"0000",""
[FICAP]

[PEU]
0,11, #TRUE#, 0, #FALSE#, #TRUE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
0, "TOTAL :", 170, 0,"ARIAL",12,0,1,"1000"
0, "Total Euros:", 170, 5,"ARIAL",12,0,1,"1000"
0,"OBSERVACIONES :", 0, 5,"ARIAL",9,0,0,"0000"
3, "CABECERA", "LineaObsAutomatica", 30, 5, "ARIAL", 9, 0, 0,"0000", ""
5, 0, "TotalBrut", 200, 0, "ARIAL", 12, 0, 1, "1000","Total"
5, 0, "TotalEu", 200, 5, "ARIAL", 12, 0, 1, "1000","###,##0.00"
[FIPEU]
[FIGRUP]

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

[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)
[CAMPS] 9
3,"COS","CodArticulo",10,0,"ARIAL",8,0,0,"0000",""
3,"COS","NumPedido",37,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",50,0,"ARIAL",8,80,0,"0000",""
3,"COS","Cantidad",141,0,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","Precio",160,0,"ARIAL",8,0,1,"0000","Precio"
3,"COS","Iva",170,0,"ARIAL",8,0,1,"0000",""
3,"COS","Articulos.TipoUnidad",142,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descuentos",175,0,"ARIAL",8,0,0,"0000",""
3,"COS","Total",200,0,"ARIAL",8,0,1,"0000","SubTotal"
[FICAP]
[FIGRUP]

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

[FIDOCUM]
