"VER1.0","Albara","Facturas de Proveedores"
;Versio, Categoria, Descripcion
;Ampla, Llarg, [EspaiCos]
;MargenX, MargenY, EtiLin, EtiPag
; 0, 152, 30
[DOCUM]
0, 0, 11
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] 5
3,"CABECERA","NombreFiscal",120,20,"ARIAL",10,0,0,"0000",""
3, "CABECERA", "Nif", 120, 15, "ARIAL", 10, 0, 0, "0000", ""
3, "CABECERA", "Domicilio", 120, 25, "ARIAL", 10, 0, 0, "0000", ""
3, "CABECERA", "Pueblo", 120, 30, "ARIAL", 10, 0, 0, "0000", ""
3, "CABECERA", "ProvPais", 120, 35, "ARIAL", 10, 0, 0,"0000", ""
;3, "CABECERA", "Provincia", 10, 40, "ARIAL", 8, 0, 0,"0000", ""
;3, "CABECERA", "Pais", 26, 40, "ARIAL", 8, 0, 0,"0000", ""
;3, "CABECERA", "CodigoPostal", 10, 37, "ARIAL", 8, 0, 0, "0000", ""
;3, "CABECERA", "Poblacion", 23, 37, "ARIAL", 8, 0, 0, "0000", ""
;2, "Anagrama.BMP", 0, 10, 156, 50
[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] 20
1, "CuadroAdrea", 104, 11, 202, 41, 1, 0,
0,"Fecha",10,45,"ARIAL",8,0,0,"0000"
0,"Num Albarn",48,45,"ARIAL",8,0,0,"0000"
1, "CuadroCos", 7, 50, 202, -11, 1, 0,
0,"Cdigo",10,51,"ARIAL",8,0,0,"0000"
0,"Pedido",30,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"
1, "lineaH", 7, 55, 202, 55,,,
1, "lineaV", 29, 50, 29, -11,,,
1, "lineaV", 41, 50, 41, -11,,,
1, "lineaV", 135, 50, 135, -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,,,
[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 ComAlba.*, CodigosPostales.CodPostal & ' - ' & CodigosPostales.Ciudad as Ciudad1, Provincias.Provincia, Paises.Pais "
"FROM ((ComAlba LEFT JOIN CodigosPostales ON (ComAlba.CodPais = CodigosPostales.CodPais) AND (ComAlba.CodPostal = CodigosPostales.CodPostal)) LEFT JOIN Provincias ON (CodigosPostales.CodProvincia = Provincias.CodProvincia) AND (CodigosPostales.CodPais = Provincias.CodPais)) LEFT JOIN Paises ON ComAlba.CodPais = Paises.CodPais"
""
[CONDICIONS] 4
"NumAlbaran","Nmero Albarn",0,0
"Seccion","Seccin",0,1
"FechaAlbaran","Fecha",0,2
"NombreProveedor","Nombre Proveedor",0,1

[CAPSALERA]
0, 56, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 9
0,"Pgina",170,45,"ARIAL",8,0,0,"0000"
6,"Pagina",187,45,"ARIAL",8,0,0,"0000",""
3,"CAB 1","NombreProveedor",10,15,"ARIAL",15,0,0,"0000",""
3,"CAB 1","Direccion",10,25,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Ciudad1",10,30,"ARIAL",10,0,0,"0000",""
3,"CAB 1","Pais",10,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",10,20,"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] 1
5, 0, "TotalBrut", 200, 0, "ARIAL", 12, 0, 1, "1000","Total"
[FIPEU]
[FIGRUP]

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

[CONDICIONS] 3
"NumAlbaran","Nmero de albarn",1,0,"CAB 1","NumAlbaran"
"Seccion","Nmero de albarn",1,1,"CAB 1","Seccion"
"CodProveedor","Nmero de albarn",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] 8
3,"COS","CodArticulo",10,0,"ARIAL",8,0,0,"0000",""
3,"COS","NumPedido",30,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",50,0,"ARIAL",8,80,0,"0000",""
3,"COS","Cantidad",145,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","Descuentos",175,0,"ARIAL",8,0,0,"0000",""
3,"COS","Total",200,0,"ARIAL",8,0,1,"0000","SubTotal"
[FICAP]
[FIGRUP]

[CALCULS] 1
"TotalBrut","COS","Total","CAB 1"

[FIDOCUM]