"VER1.0","Articulos","Listado de articulos"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
H, 9, 0
0,0,0,0

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT * , CodigoPostal & ' - ' & Poblacion as Direc, 'Tel : ' & Telefono1 as Tel "
"FROM Configuracion"
""
[CAPSALERA]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,8,"ARIAL",8,0,0,"1000",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"ARIAL",8,0,0,"1000",""
[FICAP]

[FIGRUP]

;-----------------------------------------

; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
10, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 21
0,"Pgina :",165,0,"ARIAL",8,0,0,"1000"
6,"Pagina",195,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",165,5,"ARIAL",8,0,0,"1000"
6,"Fecha",195,5,"ARIAL",8,0,1,"1000",""
0, "Efectos de Clientes extendido", 105, 5, "ARIAL", 20, 0, 2, "1000"
1, "lineaH1", 5, 17, 290, 17,,,
0,"Factura",5,18,"ARIAL",8,0,0,"1000"
0,"Recibo",20,18,"ARIAL",8,0,0,"1000"
0,"Cod.",35,18,"ARIAL",8,0,0,"1000"
0,"Nombre", 55 ,18,"ARIAL",8,0,0,"1000"
0,"Emision",110,18,"ARIAL",8,0,1,"1000"
0,"Vencimiento",130,18,"ARIAL",8,0,1,"1000"
0,"Cobrado",150,18,"ARIAL",8,0,1,"1000"
0,"Emitido",165,18,"ARIAL",8,0,1,"1000"
0,"Realizado",183,18,"ARIAL",8,0,1,"1000"
0,"Contabilizado",203,18,"ARIAL",8,0,1,"1000"
0,"Importe",215,18,"ARIAL",8,0,1,"1000"
0,"Bases",235,18,"ARIAL",8,0,1,"1000"
0,"Ivas",252,18,"ARIAL",8,0,1,"1000"
0,"Modo",270,18,"ARIAL",8,0,1,"1000"
1, "lineaH2", 5, 22, 290, 22,,,
[FICAP]

[PEU]
0, 15, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
0,"Total",160,5,"ARIAL",11,0,1,"1000"
5,0,"Total",195,5,"ARIAL",11,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

;-----------------------------------------

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT ModoPago.Descripcion, IIf(IsNull(Base1),0,Base1)+IIf(IsNull(Base2),0,Base2)+IIf(IsNull(Base3),0,Base3) AS Bases, IIf(IsNull(Iva1),0,Iva1)+IIf(IsNull(Iva2),0,Iva2)+IIf(IsNull(Iva3),0,Iva3) AS Ivas, IIf(EMitido,'S','N') AS Emi, IIf(Realizado,'S','N') AS Rea, IIf(Contabilizado,'S','N') AS Conta, *"
"FROM (VenRecibos INNER JOIN Clientes ON VenRecibos.CodCliente = Clientes.CodCLiente) LEFT JOIN ModoPago ON VenRecibos.CodPago = ModoPago.CodPago"
""
[CONDICIONS] 3
"Clientes.CodCliente","Cod. Cliente",0,1, -10
"NumFactura","Num. Factura",0,1
"FechaVencimiento","Fecha Vencimiento",0,2
;"Seccion","Nmero de albarn",1,1,"CAB 2","Seccion"

[ORDENACIONS] 3
"NumFactura","Nmero de factura",3
"Clientes.CodCliente","Cod. Cliente",3
"FechaVencimiento","Fecha Vencimiento",3


[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 14
3,"COS","NumFactura",5,0,"ARIAL",8,0,0,"0000",""
3,"COS","NumRecibo",23,0,"ARIAL",8,0,0,"0000",""
3,"COS","Clientes.CodCliente",35,0,"ARIAL",8,100,0,"0000",""
3,"COS","Nombre", 55 ,0,"ARIAL",8,40,0,"0000",""
3,"COS","FechaEmision",110,0,"ARIAL",8,0,1,"0000",""
3,"COS","FechaVencimiento",130,0,"ARIAL",8,0,1,"0000",""
3,"COS","FechaAsiento",150,0,"ARIAL",8,0,1,"0000",""
3,"COS","Emi",158,0,"ARIAL",8,0,0,"0000",""
3,"COS","Rea",175,2,"ARIAL",8,0,0,"0000",""
3,"COS","Conta",195,0,"ARIAL",8,0,0,"0000",""
3,"COS","Importe",215,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","Bases",235,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","Ivas",255,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","Descripcion",259,0,"ARIAL",8,0,0,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 1
"Total","COS","Importe","GENERAL"

[FIDOCUM]



