"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] 2
3,"CABECERA","NombreComercial",10,0,"ARIAL",22,0,0,"1000",""
3,"CABECERA","Nif",10,10,"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, 7, "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
"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 = True) ","",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]


