"VER1.0","Representantes","Listado de Representantes"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
0, 0, 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] 2
3,"CABECERA","NombreComercial", 10,2,"Times New Roman",20,0,0,"1000",""
3,"CABECERA","Nif", 10,9,"Times New Roman",10,0,0,"1000",""
;0,"Condiciones : ",20,23,"Times New Roman",8,0,0,"1000"
;6,"Condiciones",45,23,"Times New Roman",8,0,0,"1000",""
[FICAP]

[PEU]
0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total General",160,0,"Times New Roman",12,0,1,"1000"
;5,0,"Total",170,0,"Times New Roman",10,0,0,"1000","Total"
[FIPEU]
[FIGRUP]

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


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
5, 40, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 11
0,"Relacin de facturas de comisiones",45,6,"Times New Roman",18,0,0,"1001"
0,"Fecha :",165,5,"Times New Roman",8,0,0,"1000"
6,"Fecha",195,5,"Times New Roman",8,0,1,"1000",""
1,"linea2",5,29,195,29,,,
1,"linea1",5,34,195,34,,,
0,"Nombre Cliente",5,30,"Times New Roman",8,0,0,"1000"
0,"N.Factura",100,30,"Times New Roman",8,0,1,"1000"
0,"Fecha",120,30,"Times New Roman",8,0,1,"1000"
0,"% Com.",135,30,"Times New Roman",8,0,1,"1000"
0,"Base",170,30,"Times New Roman",8,0,1,"1000"
0,"Comisin",190,30,"Times New Roman",8,0,1,"1000"
;0,"Bruto",152,25,"Times New Roman",8,0,1,"1000"
;0,"Seccin",80,25,"Times New Roman",8,0,1,"1000"
;0,"Pgina :",165,0,"Times New Roman",8,0,0,"1000"
;6,"Pagina",195,0,"Times New Roman",8,0,1,"1000",""

[FICAP]

[PEU]
0, 8, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
1, "Cuadro", 90, 0, 195, 8, 1, 0,
0,"Total General",100,2,"Times New Roman",12,0,0,"1000"
5,0,"TotalPG",170,2,"Times New Roman",10,0,1,"1000","Total"
5,0,"TotalCG",190,2,"Times New Roman",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

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


;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB2", #FALSE#
"SELECT CodRepresentante & ' - ' & Nombre as Titulo2, irpf & ' %' as irpf1, iva & ' %' as iva1, * "
"FROM Representantes"
""
[ORDENACIONS] 1
"CodRepresentante", "Codigo", 3

[CONDICIONS] 2
"CodRepresentante", "Cdigo", 0, 1
"Nombre", "Nombre", 0, 1

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB2","Titulo2",5,-20,"Times New Roman",10,0,0,"1001",""
[FICAP]

[PEU]
0, 30, #TRUE#, 2, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 14
0,"Total Representante",120,5,"Times New Roman",10,0,1,"1000"
5,0,"TotalP",170,5,"Times New Roman",10,0,1,"1000","Total"
5,0,"TotalC",190,5,"Times New Roman",10,0,1,"1000","Total"
0,"% IRPF Representante:",120,10,"Times New Roman",10,0,1,"1000"
3,"CAB2","Irpf1",135,10,"Times New Roman",10,0,1,"1000",""
0,"% IVA Representante:",120,20,"Times New Roman",10,0,1,"1000"
0,"Resta:",120,15,"Times New Roman",10,0,1,"1000"
0,"Total Factura:",120,25,"Times New Roman",10,0,1,"1000"
0,"Total Factura:",120,25,"Times New Roman",10,0,1,"1000"
3,"CAB2","Iva1",135,20,"Times New Roman",10,0,1,"1000",""
8, "1", "-(Calculo('TotalC')*val(Campo('CAB2','IRPF'))/100", 190, 10, "Times New Roman",10,0,1,"1000","Total"
8, "1", "(Calculo('TotalC')*1-((Calculo('TotalC')*val(Campo('CAB2','IRPF'))/100))", 190, 15, "Times New Roman",10,0,1,"1000","Total"
8, "1", "(Calculo('TotalC')*val(Campo('CAB2','iva'))/100", 190, 20, "Times New Roman",10,0,1,"1000","Total"
8, "1", "(Calculo('TotalC')*1-(Calculo('TotalC')*(val(Campo('CAB2','IRPF'))*1+(val(Campo('CAB2','IVA'))*-1))/100)", 190, 25, "Times New Roman",10,0,1,"1000","Total"
;8, "1", "(val(Campo('CAB2','IRPF'))*-1+(val(Campo('CAB2','IVA'))*1)", 190, 30, "Times New Roman",10,0,1,"1000","Total"
[FIPEU]
[FIGRUP]



;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT Representantes.CodRepresentante, Representantes.Nombre, VenAlba.CodCliente, VenAlba.NombreCliente, VenAlba.Seccion, VenAlba.FechaFactura, VenAlba.NumFactura, VenAlbaLin.Comision AS Com, Sum(VenAlbaLin.Total) AS SumaDeTotal, TotalBase*Com/100 AS TotalComision, First(VenFacturas.TDesCo) AS PrimeroDeTDesCo, First(VenFacturas.TDesPP) AS PrimeroDeTDesPP, [SumaDeTotal]-[PrimeroDeTDesCo]-[PrimeroDeTDesPP] AS TotalBase, Clientes.CodGrupo"
"FROM (((Representantes INNER JOIN VenAlba ON Representantes.CodRepresentante = VenAlba.CodRepresentante) INNER JOIN VenAlbaLin ON (VenAlba.CodCliente = VenAlbaLin.CodCliente) AND (VenAlba.NumAlbaran = VenAlbaLin.NumAlbaran) AND (VenAlba.Seccion = VenAlbaLin.Seccion)) INNER JOIN VenFacturas ON (VenAlba.Seccion = VenFacturas.Seccion) AND (VenAlba.FechaFactura = VenFacturas.FechaFactura) AND (VenAlba.NumFactura = VenFacturas.NumFactura)) INNER JOIN Clientes ON VenFacturas.CodCliente = Clientes.CodCliente"
"GROUP BY Representantes.CodRepresentante, Representantes.Nombre, VenAlba.CodCliente, VenAlba.NombreCliente, VenAlba.Seccion, VenAlba.FechaFactura, VenAlba.NumFactura, VenAlbaLin.Comision, Clientes.CodGrupo"

[ORDENACIONS] 1
"VenAlba.FechaFactura","Fecha",0,2

[CONDICIONS] 5
"representantes.CodRepresentante", "representantes.CodRepresentante", 1, 1, "CAB2", "CodRepresentante"
"VenAlba.FechaFactura","Fecha",0,2
"Seccion","Seccion",0,1
"CodGrupo","Cod. Grupo",0,1
" (VenAlbaLin.Comision>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] 6
3,"COS","NombreCliente",5,0,"Times New Roman",8,0,0,"0000",""
3,"COS","NumFactura",100,0,"Times New Roman",8,0,1,"0000",""
3,"COS","FechaFactura",120,0,"Times New Roman",8,0,1,"0000",""
3,"COS","TotalBase",170,0,"Times New Roman",8,0,1,"0000","Total"
3,"COS","Com",130,0,"Times New Roman",8,0,1,"0000",""
3,"COS","TotalComision",190,0,"Times New Roman",8,0,1,"0000","Total"
;3,"COS","SumaDeTotal",152,0,"Times New Roman",8,0,1,"0000","Total"
;3,"COS","Seccion",78,0,"Times New Roman",8,50,1,"0000",""
[FICAP]
[FIGRUP]


[CALCULS] 4
"TotalP","COS","TotalBase","CAB2"
"TotalC","COS","TotalComision","CAB2"
"TotalPG","COS","TotalBase","GENERAL"
"TotalCG","COS","TotalComision","GENERAL"

[FIDOCUM]


