"VER1.0","Articulos","Estadstica albaranes no facturados"
;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] 3
3,"CABECERA","NombreComercial",10,3,"ARIAL",14,0,0,"1000",""
0,"Condiciones : ",10,20,"ARIAL",8,0,0,"1000"
6,"Condiciones",35,20,"ARIAL",8,0,0,"1000",""
;3,"CABECERA","Nif",10,12,"ARIAL",8,0,0,"1000",""
[FICAP]

[PEU]
0, 10, #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]
0, 35, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 20
0,"Modelo 347 - Compras.",45,11,"ARIAL",16,0,0,"1001"
0,"Pgina :",255,5,"ARIAL",8,0,0,"1000"
6,"Pagina",279,5,"ARIAL",8,0,1,"1000",""
0,"Fecha :",255,10,"ARIAL",8,0,0,"1000"
6,"Fecha",279,10,"ARIAL",8,0,1,"1000",""
1,"linea2",3,20,290,20,,,
1,"linea1",3,29,290,29,,,
0,"Codigo",11,25,"ARIAL",8,0,0,"1000"
0,"Nombre Fiscal",30,25,"ARIAL",8,0,0,"1000"
0,"NIF.",92,25,"ARIAL",8,0,0,"1000"
0,"Cd. Pos.",122,25,"ARIAL",8,0,1,"1000"
0,"B.Impo.",139,25,"ARIAL",8,0,1,"1000"
0,"I.V.A.",153,25,"ARIAL",8,0,1,"1000"
0,"R.E.",170,25,"ARIAL",8,0,1,"1000"
0,"TOTAL",190,25,"ARIAL",8,0,1,"1000"
0,"1er.Trim.",210,25,"ARIAL",8,0,1,"1000"
0,"2o. Trim.",230,25,"ARIAL",8,0,1,"1000"
0,"3er. Trim.",250,25,"ARIAL",8,0,1,"1000"
0,"4o. Trim.",270,25,"ARIAL",8,0,1,"1000"
0,"Imp.Metal.",290,25,"ARIAL",8,0,1,"1000"
;0,"%",281,25,"ARIAL",8,0,1,"1000"
;0,"Margen",298,25,"ARIAL",8,0,1,"1000"
;0,"%",285,25,"ARIAL",8,0,1,"1000"
[FICAP]

[PEU]
0, 35, #TRUE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 10
1, "Cuadro", 40, 3, 290, 12, 1, 0,
0,"Totales..:",90,5,"ARIAL",10,0,1,"1000"
5,0,"TBI",136,5,"ARIAL",8,0,1,"1000","Total"
5,0,"TIVA",155,5,"ARIAL",8,0,1,"1000","Total"
5,0,"TSDT",190,5,"ARIAL",8,0,1,"1000","Total"
5,0,"T1T",210,5,"ARIAL",8,0,1,"1000","Total"
5,0,"T2T",230,5,"ARIAL",8,0,1,"1000","Total"
5,0,"T3T",250,5,"ARIAL",8,0,1,"1000","Total"
5,0,"T4T",270,5,"ARIAL",8,0,1,"1000","Total"
5,0,"TIM",288,5,"ARIAL",8,0,1,"1000","Total"
[FIPEU]
[FIGRUP]

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

;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
"PARAMETERS SeccionI TEXT,SeccionF TEXT, FechaI DATETIME, FechaF DATETIME; SELECT CodProveedor, NombreFiscal, NIF, CodigoPostal, SumaDeTotal, ImporteBI, ImporteIVA, ImporteMetalicoSC as ImporteMetalico, ImporteRE, PrimerTrimestre, SegundoTrimestre, TercerTrimestre, CuartoTrimestre"
"FROM ConsultaModelo347Compras"
""

[CONDICIONS] 2
"Fecha","Fecha Factura(Rellenar Obligatorio)",0,2
"Seccion", "Seccin(Rellenar Obligatorio)", 0, 1
;"(SumaDeTotal>=305) ","",4
;"CodArticulo","Codigo art",0,1
;"CodFamilia", "Cod. Familia", 1, 1, "CAB2", "CodFamilia"
;"Fecha", "Otra Fecha", 0, 2
;"CodPostal","Zona",0,1
;"CodRepresentante","Representante",0,1
;" (Seccion='0') ","",4
;"Seccion","Sec",0,1
;" (CodAlmacen = '1') ","",4
;"CodCliente","Codigo",0,1, -10

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 15
3,"COS","CodProveedor",8,0,"ARIAL",8,0,0,"0000",""
3,"COS","NombreFiscal",30,0,"ARIAL",8,50,0,"0000",""
3,"COS","NIF",92,0,"ARIAL",8,0,0,"0000",""
3,"COS","CodigoPostal",120,0,"ARIAL",8,0,1,"0000",""
1,"lineaPequeitoSeparadora",122,0,122,5,,,
3,"COS","ImporteBI",139,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","ImporteIVA",155,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","ImporteRE",170,0,"ARIAL",8,0,1,"0000","Total"
1,"lineaPequeitoSeparadora1",172,0,172,5,,,
3,"COS","SumaDeTotal",190,0,"ARIAL",8,0,1,"1000","Total"
3,"COS","ImporteMetalico",288,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","PrimerTrimestre",210,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","SegundoTrimestre",230,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","TercerTrimestre",250,0,"ARIAL",8,0,1,"0000","Total"
3,"COS","CuartoTrimestre",270,0,"ARIAL",8,0,1,"0000","Total"
;3,"COS","ImpDT",251,0,"ARIAL",8,0,1,"0000","Total"
;3,"COS","Margen",268,0,"ARIAL",8,0,1,"0000","Total"
;3,"COS","PCMedio",217,0,"ARIAL",8,0,1,"0000","Total"
;8, "1", "Campo('COS','PCMedio')*Campo('COS','CantidadVentas')", 240, 0, "ARIAL",8,0,1,"0000","Total"
;3,"COS","Porciento",285,0,"ARIAL",8,0,1,"0000","Total"
;3,"COS","MP",200,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 8
"TSDT","COS","SumaDeTotal","GENERAL"
"TIM","COS","ImporteMetalico","GENERAL"
"T1T","COS","PrimerTrimestre","GENERAL"
"T2T","COS","SegundoTrimestre","GENERAL"
"T3T","COS","TercerTrimestre","GENERAL"
"T4T","COS","CuartoTrimestre","GENERAL"
"TBI","COS","ImporteBI","GENERAL"
"TIVA","COS","ImporteIVA","GENERAL"
;"ToBe","COS","Benef","GENERAL"
;"ToPo","COS","POR","GENERAL"
;"ToC","COS","Cantidad","GENERAL"

[FIDOCUM]


