"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] 4
3,"CABECERA","NombreComercial", 10,2,"ARIAL",20,0,0,"1000",""
3,"CABECERA","Nif", 10,9,"ARIAL",10,0,0,"1000",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"ARIAL",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,"ARIAL",12,0,1,"1000"
;5,0,"Total",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]
[FIGRUP]

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


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
5, 30, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 17
0,"Listado Comisiones Por Origen Venta",45,10,"ARIAL",18,0,0,"1001"
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",""
1,"linea2",5,24,195,24,,,
1,"linea1",5,29,195,29,,,
0,"N.Fact.",4,25,"ARIAL",8,0,0,"1000"
0,"Nombre Cliente",20,25,"ARIAL",8,0,0,"1000"
0,"Seccin",60,25,"ARIAL",8,0,0,"1000"
0,"F.Factura",138,25,"ARIAL",8,0,0,"1000"
0,"Base Comisin",175,25,"ARIAL",8,0,1,"1000"
0,"Comisin",192,25,"ARIAL",8,0,1,"1000"
0,"Representante",75,25,"ARIAL",8,0,0,"1000"
0,"% T.I.",105,25,"ARIAL",8,0,0,"1000"
0,"% T.T.",115,25,"ARIAL",8,0,0,"1000"
0,"% T.P.",125,25,"ARIAL",8,0,0,"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] 7
1, "Cuadro", 40, 0, 195, 8, 1, 0,
0,"Totales",50,2,"ARIAL",12,0,0,"1000"
5,0,"BASIMP1",168,2,"ARIAL",10,0,1,"1000","Total"
5,0,"TCOM",190,2,"ARIAL",10,0,1,"1000","Total"
8, "1", "DIV(CALCULO('TTInternet') , CALCULO('TTInternet') + CALCULO('TTTelefono') + CALCULO('TTPedido'))", 105, 2, "ARIAL", 10, 0, 0, "1000", "TOTAL"
8, "1", "DIV(CALCULO('TTTelefono') , CALCULO('TTInternet') + CALCULO('TTTelefono') + CALCULO('TTPedido'))", 115, 2, "ARIAL", 10, 0, 0, "1000", "TOTAL"
8, "1", "DIV(CALCULO('TTPedido') , CALCULO('TTInternet') + CALCULO('TTTelefono') + CALCULO('TTPedido'))", 125, 2, "ARIAL", 10, 0, 0, "1000", "TOTAL"
[FIPEU]

[FIGRUP]

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


;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB2", #FALSE#
"SELECT IIf([baseimponible1] Is Null,0,[baseimponible1])+IIf([baseimponible2] Is Null,0,[baseimponible2])+IIf([baseimponible3] Is Null,0,[baseimponible3]) AS Totalbase, VenFacturas.NumFactura, IIf([Totalbase]=0,([Bruto]-[TDesCo]-[Venfacturas.DescuentoPP]),[TotalBase]) AS BASEIMP1, Clientes.Nombre, Representantes.Iva, Representantes.IRPF, VenFacturas.Seccion, VenFacturas.Bruto, VenFacturas.TDesCo, Representantes.Nombre,VenFacturas.DescuentoPP ,*"
"FROM (Representantes INNER JOIN VenFacturas ON Representantes.CodRepresentante = VenFacturas.CodRepresentante) INNER JOIN Clientes ON VenFacturas.CodCliente = Clientes.CodCliente"
""
[ORDENACIONS] 1
"NumFactura", "Num. Factura", 3

[CONDICIONS] 3
"NumFactura", "Num. Factura", 0, 1
"FechaFactura","FechaFactura",0,2
"VenFacturas.CodRepresentante","Cod Representante",0,1


[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,"CAB2","Clientes.Nombre",20,0,"ARIAL",8,43,0,"0000",""
3,"CAB2","VenFacturas.CodRepresentante",75,0,"ARIAL",8,0,0,"0000",""
3,"CAB2","Representantes.Nombre",80,0,"ARIAL",8,22,0,"0000",""
3,"CAB2","Seccion",65,0,"ARIAL",8,50,1,"0000",""
3,"CAB2","NumFactura",7,0,"ARIAL",8,0,0,"0000",""
3,"CAB2","FechaFactura",153,0,"ARIAL",8,0,1,"0000",""
3,"CAB2","BASEIMP1",170,0,"ARIAL",8,0,1,"0000","Total"
3,"CAB2","TComision",190,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]

[PEU]
0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
8, "1", "DIV(CALCULO('TInternet') , CALCULO('TInternet') + CALCULO('TTelefono') + CALCULO('TPedido'))", 105, -5, "ARIAL", 9, 0, 0, "0000", "TOTAL"
8, "1", "DIV(CALCULO('TTelefono') , CALCULO('TInternet') + CALCULO('TTelefono') + CALCULO('TPedido'))", 115, -5, "ARIAL", 9, 0, 0, "0000", "TOTAL"
8, "1", "DIV(CALCULO('TPedido') , CALCULO('TInternet') + CALCULO('TTelefono') + CALCULO('TPedido'))", 125, -5, "ARIAL", 9, 0, 0, "0000", "TOTAL"
;0,"Total Internet:",10,0,"ARIAL",10,0,0,"1000"
;0,"Total Telefono:",60,0,"ARIAL",10,0,0,"1000"
;0,"Total Pedidos:",120,0,"ARIAL",10,0,0,"1000"
;5,0,"TPedido",160,0,"ARIAL",10,0,1,"1000","Total"
;5,0,"TInternet",50,0,"ARIAL",10,0,1,"1000","Total"
;3,"COS","BASEIMP1",170,0,"ARIAL",8,0,1,"0000","Total"
;8,"1", "DIV(CALCULO('Margen')*100, CALCULO('Base'))", 280, 5, "ARIAL", 10, 0, 1, "1000", "TOTAL"
;8, "0", "'Totales Familia ' + Campo('CAB1','CodFamilia') + ' :' ", 50, 2, "ARIAL", 9, 0, 0, "1000", ""
;5,0,"TTelefono",100,0,"ARIAL",10,0,1,"1000","Total"
[FIPEU]
[FIGRUP]



;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"SELECT VenFacturas.CodCliente, VenFacturas.NumFactura, VenFacturas.FechaFactura, VenAlba.NumAlbaran, VenAlba.CodRepresentante, VenAlba.OrigenVenta, VenAlba.FechaAlbaran, IIF(VenAlba.OrigenVenta='I',VenAlba.Total,0) as TotalInternet, IIF(VenAlba.OrigenVenta='T',VenAlba.Total,0) as TotalTelefono, IIF(VenAlba.OrigenVenta='P',VenAlba.Total,0) as TotalPedido "
"FROM VenFacturas INNER JOIN VenAlba ON (VenAlba.FechaFactura = VenFacturas.FechaFactura) AND (VenFacturas.NumFactura = VenAlba.NumFactura) AND (VenFacturas.Seccion = VenAlba.Seccion) AND (VenFacturas.CodCliente = VenAlba.CodCliente)"
""

[ORDENACIONS] 0
;"FechaFactura","Fecha",0,2

[CONDICIONS] 4
"VenFacturas.NumFactura", "Num. Factura", 1, 1, "CAB2", "NumFactura"
"VenAlba.OrigenVenta", "Origen Venta", 0, 1
"VenAlba.Seccion","Seccion",0,1
"((VenAlba.Facturado)=True) ","",4

[CAPSALERA]
0, 0, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Num. Albarn:",10,0,"ARIAL",8,0,0,"0000"
;0,"Origen Venta:",80,0,"ARIAL",8,0,0,"0000"
;0,"Fecha Albarn:",140,0,"ARIAL",8,0,0,"0000"
;3,"COS","NumAlbaran", 35,0,"ARIAL",8,0,0,"0000",""
;3,"COS","OrigenVenta", 110,0,"ARIAL",8,40,0,"0000",""
;3,"COS","FechaAlbaran", 165,0,"ARIAL",8,40,0,"0000",""
;3,"COS","VenAlbaLin.Descripcion", 85,0,"ARIAL",8,85,0,"0000",""
;3,"COS","Total", 190,0,"ARIAL",8,0,1,"0000","SubTotal"
;3,"COS","CodFamilia",7,0,"ARIAL",8,50,0,"0000",""
;3,"COS","VenAlbaLin.Seccion",16,0,"ARIAL",8,50,0,"0000",""
[FICAP]
[FIGRUP]


[CALCULS] 8
"BASIMP1","CAB2","BASEIMP1","GENERAL"
"TCom","CAB2","TComision","GENERAL"
"TInternet","COS","TotalInternet","CAB2"
"TTelefono","COS","TotalTelefono","CAB2"
"TPedido","COS","TotalPedido","CAB2"
"TTInternet","COS","TotalInternet","GENERAL"
"TTTelefono","COS","TotalTelefono","GENERAL"
"TTPedido","COS","TotalPedido","GENERAL"
[FIDOCUM]


