"VER1.0","Clientes","Listado de Clientes"
;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, 10, #FALSE#, 0, #TRUE#, #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,10,"ARIAL",8,0,0,"1000",""
0,"Condiciones : ",20,23,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,23,"ARIAL",8,0,0,"1000",""
[FICAP]

[PEU]
0, 10, #TRUE#, 2, #TRUE#, #FALSE#, 0
; 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]
0, 25, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 17
0,"Pgina :",165,0,"ARIAL",8,0,0,"1000"
6,"Pagina",195,0,"ARIAL",8,0,1,"1000",""
0,"Fecha :",165,4,"ARIAL",8,0,0,"1000"
6,"Fecha",195,4,"ARIAL",8,0,1,"1000",""
0, "Detalle Albaranes Depositos de Clientes",90, 3, "ARIAL", 18, 0, 2, "1000"
0, "Ped.", 7, 18, "ARIAL", 8, 0, 0, "1000"
0, "Fecha", 22, 18, "ARIAL", 8, 0, 0, "1000"
0, "Lnea", 35, 18, "ARIAL", 8, 0, 0, "1000"
0, "Cdigo Art.", 47, 18, "ARIAL", 8, 0, 0, "1000"
0, "Descripcin", 85, 18, "ARIAL", 8, 0, 0, "1000"
0, "C. Pendiente", 149, 18, "ARIAL", 8, 0, 1, "1000"
0, "Precio", 160, 18, "ARIAL", 8, 0, 1, "1000"
0, "Total", 175, 18, "ARIAL", 8, 0, 1, "1000"
0, "F. Entrega", 195, 18, "ARIAL", 8, 0, 1, "1000"
0, "Referencia", 220, 18, "ARIAL", 8, 0, 1, "1000"
1, "lineaH1", 5, 17, 240, 17,,,
1, "lineaH2", 5, 22, 240, 22,,,
[FICAP]

[PEU]
0, 0, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total",160,0,"ARIAL",12,0,1,"1000"
;5,0,"T2",190,0,"ARIAL",12,0,3,"1000","Total"
;0,"Total Acumulado",160,0,"ARIAL",12,0,1,"1000"
;5,0,"Total",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]

[FIGRUP]

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



;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB1", #FALSE#
"SELECT CodCliente & ' - ' & Nombre as Titulo, * "
"FROM Clientes"
""
[ORDENACIONS] 2
"CodCliente","Codigo Cliente",3
"Nombre","Nombre Cliente",3
"CodRepresentante", "Cod Representante", 0, 1

[CONDICIONS] 2
"CodCliente","Codigo Cliente",0,1, -10
"Nombre","Nombre",0,1
"CodRepresentante", "Cod Representante", 0, 1

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB1","Titulo",10,0,"ARIAL",10,0,0,"1001",""
;3,"CAB1","AlbaranDeposito",90,0,"ARIAL",8,0,0,"1000",""
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
0,"Total : ",140, 5,"ARIAL",10,0,0,"1000"
5,0,"Total1",175, 5,"ARIAL",10,0,1,"1000" ,"Total"
[FIPEU]
[FIGRUP]


;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
" SELECT VenPrev.AlbaranDeposito, VenPrev.NumDoc, VenPrev.Fecha, VenPrev.FechaEntrega, VenPrevLin.*,  Cantidad - CantidadServida  as CantidadPendiente, VenPrev.CodRepresentante "
" FROM VenPrev INNER JOIN VenPrevLin ON (VenPrev.Seccion = VenPrevLin.Seccion) AND (VenPrev.CodCliente = VenPrevLin.CodCliente) AND (VenPrev.Numero = VenPrevLin.Numero) "
"ORDER BY VenPrev.Numero, VenPrevLin.NumLinea"
""
[CONDICIONS] 8
; 3/11 (auditoria de listados): campo cualificado; sin la tabla, Access no sabe de cual de las del FROM es y la consulta fallaba al filtrar.
"VenPrev.FechaEntrega","Fecha Entrega",0,2
"Fecha","Fecha",0,2
"VenPrevLin.CodCliente","CodCliente",1,1,"CAB1","CodCliente"
" ( VenPrev.Pedido = True) ","",4
" ( CantidadServida < Cantidad ) ","",4
" ( VenPrev.AlbaranDeposito = false) ","",4
"CodRepresentante", "Cod Representante", 0, 1
"VenPrev.Seccion", "Seccin",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] 10
3,"COS","Numero", 7,0,"ARIAL",8,0,0,"0000",""
3,"COS","Fecha", 22,0,"ARIAL",8,0,0,"0000",""
3,"COS","NumLinea", 38,0,"ARIAL",8,0,0,"0000",""
3,"COS","CodArticulo", 43,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion", 65,0,"ARIAL",8,90,0,"0000",""
3,"COS","CantidadPendiente", 145,0,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","Precio", 160,0,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","Total", 175,0,"ARIAL",8,0,1,"0000","Cantidad"
3,"COS","FechaEntrega", 195,0,"ARIAL",8,0,1,"0000",""
3,"COS","NumDoc", 220,0,"ARIAL",8,0,1,"0000",""


[FICAP]
[FIGRUP]


[CALCULS] 2
"Total1","COS","Total","CAB1"
"T2","COS","Total","GENERAL"

[FIDOCUM]


