MASTER 41bZa01Mq4xqfLn4Y1zpY4sM2YlNbHuF8U39/U0AdxPCyK3LxEtD8WFHecxhdKV70ciViM1Io5DiWOGcTnQt1w== MASTER Principal ProdCodEstr,System.String ItNFProdNome,System.String EntCod,System.String EntNome,System.String CtrlLoteLocArmItNFQtd,System.Decimal Lote,System.String Notas,System.String Transp,System.String DataIni,System.DateTime DataFim,System.DateTime Empresa,System.String EstqLocArmazLocaliz,System.String NomeTransp,System.String 0 Principal MASTER pEmpCod,pEmpCod,22,20 DataIni,DataIni,31,0 DataFim,DataFim,31,0 Notas,Notas,22,20 Transp,Transp,22,40 Entidade,Entidade,22,20 SELECT INF.ProdCodEstr, INF.ItNFProdNome, E.EntCod, E.EntNome, SUM(CLLAINF.CtrlLoteLocArmItNFQtd) AS CtrlLoteLocArmItNFQtd, SUBSTRING(CLLAINF.CtrlLoteNum, 8,5) as Lote, CONVERT(VARCHAR(255), @Notas) AS Notas, CONVERT(VARCHAR(7), @Transp) AS Transp, CONVERT(DATETIME, @DataIni) AS DataIni, CONVERT(DATETIME, @DataFim) AS DataFim, CONVERT(VARCHAR(2), @pEmpCod ) AS Empresa, ELA.EstqLocArmazLocaliz, (+NF.NFTranspEntCod+ ' - '+ E.EntNome) As NomeTransp FROM NOTA_FISCAL NF WITH(NOLOCK), ITEM_NF INF WITH(NOLOCK), ENTIDADE E WITH(NOLOCK), CTRL_LOTE_LOC_ARM_IT_NF CLLAINF WITH(NOLOCK), PROD_UNID_MED PUM WITH(NOLOCK), ESTQ_LOC_ARMAZ ELA WITH(NOLOCK) WHERE ((CharIndex('*'+CONVERT(VARCHAR, CONVERT(INT, NF.NFNum))+'*', @Notas) > 0) OR @Notas = '') AND (NF.NFTranspEntCod = @Transp or @Transp = '') AND NF.NFDataEmis >= @DataIni AND NF.NFDataEmis <= @DataFim AND NF.EmpCod = @pEmpCod AND ((CharIndex('*'+CONVERT(VARCHAR, CONVERT(INT, NF.EntCod))+'*', @Entidade) > 0) OR @Entidade = '') AND NF.NFCancelada = 'Não' AND NF.EmpCod = INF.EmpCod AND NF.CtrlDFModForm = INF.CtrlDFModForm AND NF.CtrlDFSerie = INF.CtrlDFSerie AND NF.NFNum = INF.NFNum AND NF.NFTranspEntCod = E.EntCod AND INF.EmpCod = CLLAINF.EmpCod AND INF.CtrlDFModForm = CLLAINF.CtrlDFModForm AND INF.CtrlDFSerie = CLLAINF.CtrlDFSerie AND INF.NFNum = CLLAINF.NFNum AND INF.ItNFSeq = CLLAINF.ItNFSeq AND INF.ProdCodEstr = PUM.ProdCodEstr AND PUM.ProdUnidMedCod = 'CX' AND CLLAINF.ProdCodEstr = ELA.ProdCodEstr AND NF.EmpCod = ELA.EmpCod AND ELA.LocArmazCodEstr = CLLAINF.LocArmazCodEstr GROUP BY INF.ProdCodEstr, INF.ItNFProdNome, E.EntCod, E.EntNome, SUBSTRING(CLLAINF.CtrlLoteNum, 8,5),ELA.EstqLocArmazLocaliz,(+NF.NFTranspEntCod+ ' - '+ E.EntNome) ORDER BY ELA.EstqLocArmazLocaliz,INF.ProdCodEstr, SUBSTRING(CLLAINF.CtrlLoteNum, 8,5) EmpresaFilial EMPCOD,System.String EMPNOME,System.String EMPLOGOTIPO,System.Byte[] 0 EmpresaFilial MASTER pEmpCod,pEmpCod,22,20 SELECT EF.EMPCOD, EF.EMPNOME, EF.EMPLOGOTIPO FROM EMPRESA_FILIAL EF WITH(NOLOCK) WHERE EF.EMPCOD = @pEmpCod NFS EntCod,System.String NFEntNome,System.String NFNUm,System.String Cliente,System.String NFQtdVol,System.Decimal 0 NFS MASTER pEmpCod,pEmpCod,22,20 DataIni,DataIni,31,0 DataFim,DataFim,31,0 Notas,Notas,22,20 Transp,Transp,22,40 Entidade,Entidade,22,20 SELECT NF.EntCod, NF.NFEntNome, NF.NFNUm, NF.EntCod + ' - ' + NF.NFEntNome AS Cliente, NF.NFQtdVol FROM NOTA_FISCAL NF WITH(NOLOCK) WHERE ((CharIndex('*'+CONVERT(VARCHAR, CONVERT(INT, NF.NFNum))+'*', @Notas) > 0) OR @Notas = '') AND (NF.NFTranspEntCod = @Transp or @Transp = '') AND NF.NFDataEmis >= @DataIni AND NF.NFDataEmis <= @DataFim AND NF.EmpCod = @pEmpCod AND ((CharIndex('*'+CONVERT(VARCHAR, CONVERT(INT, NF.EntCod))+'*', @Entidade) > 0) OR @Entidade = '') AND NF.NFCancelada = 'Não' ORDER BY NF.NFNUm ,pEmpCod,pEmpCod,,System.String,_x0031_,False,False,True ,DataIni,DataIni,,System.DateTime,_x0031__x002F_1_x002F_2017_x0020_1:06:01_x0020_PM,False,False,True ,DataFim,DataFim,,System.DateTime,_x0036__x002F_12_x002F_2017_x0020_1:06:12_x0020_PM,False,False,True ,Notas,Notas,,System.String,_x002A_125494_x002A_125495_x002A_125496_x002A_,False,False,True ,Transp,Transp,,System.String,,False,False,True ,Entidade,Entidade,,System.String,,False,False,True ,Usuario,Usuario,,System.String,,False,False,True EngineV2 None;Black;2;Solid;False;4;Black Transparent Top, Left, Right;Black;1;Solid;False;4;Black Transparent 0,0.4,20.4,4.87 Transparent 0.14,1.83,20.09,0.6 Arial,16,Bold Center 0,0,0,0 Text1 RELATÓRIO DE SEPARAÇÃO POR ITEM E LOTE Black Typographic Center Transparent 0.19,3.28,20.02,0.6 Arial,8,Bold Center 0,0,0,0 Text2 {string.Concat("Período: ", Format("{0:dd/MM/yyyy}", DataIni) , " á ", Format("{0:dd/MM/yyyy}", DataFim))} Black Typographic Expression Center Transparent 0.19,2.59,20.04,0.6 Arial,8,Bold Center 0,0,0,0 Text3 {string.Format("Empresa: {0} - {1}", EmpresaFilial.EMPCOD, EmpresaFilial.EMPNOME)} Black Typographic Center Transparent 0.21,3.96,20.02,0.6 Arial,11,Bold| Italic Center 0,0,0,0 Text5 Transportadora: {IIF(Principal.Parameters["Transp"].ParameterValue=="","Todas",(Principal.NomeTransp))} Black Typographic Expression Center Transparent 17.39,0.31,2.81,0.51 Arial,8,Bold| Italic Right 0,0,0,0 Text4 Página: {PageNumber} Black Typographic Expression Center Transparent 0.12,0.08,15.54,1.68 EmpresaFilial.EMPLOGOTIPO Image1 True PageHeaderBand1 Top;Black;1;Solid;False;4;Black Transparent 0,26.66,20.4,1.04 PageFooterBand1 Transparent -0.01,26.78,18.9,0.6 Arial,9,Bold Center 0,0,0,0 Text30 Impresso por: {Usuario} Black Typographic Center All;Black;1;Solid;False;4;Black Transparent 0,6.07,20.4,0.76 Transparent 0.09,0.05,2.02,0.6 Arial,9,Bold Center 0,0,0,0 Text6 SEPARAÇÃO Black Typographic Center Transparent 2.58,0.02,7.13,0.6 Arial,9,Bold 0,0,0,0 Text7 PRODUTO Black Typographic Center Transparent 9.91,0.04,1.83,0.6 Arial,9,Bold Center 0,0,0,0 Text8 ENDEREÇO Black Typographic Center Transparent 11.98,0.05,1.73,0.6 Arial,8,Bold Center 0,0,0,0 Text9 LOTE Black Typographic Center Transparent 13.9,0.04,1.6,0.6 Arial,9,Bold Center 0,0,0,0 Text10 QTDE Black Typographic Center Transparent 16.91,0.05,1.8,0.6 Arial,9,Bold Center 0,0,0,0 Text11 CONF 01 Black Typographic Expression Center Transparent 18.8,0.05,1.6,0.6 Arial,9,Bold 9d0b3186c4bd4d079b0bd0ba46a662d3 Center 0,0,0,0 Text31 CONF 02 Black Typographic Expression Center Transparent 15.8,0.04,0.8,0.6 Arial,9,Bold ab08418f45d2472c8708af9aefe9756a Center 0,0,0,0 Text32 Total Black Typographic Expression Center 2.33,0.02,0,0 StartPointPrimitive1 88bf6b5b0f184fcab928939b508247c1 2.35,0.75,0,0 EndPointPrimitive1 88bf6b5b0f184fcab928939b508247c1 9.83,0.02,0,0 StartPointPrimitive2 dad706d9b9f94cac9dbb6a5eb581116b 9.83,0.75,0,0 EndPointPrimitive2 dad706d9b9f94cac9dbb6a5eb581116b 11.8,0.02,0,0 StartPointPrimitive3 b203f3c8d8b54c5bbc69f81c51b67259 11.8,0.75,0,0 EndPointPrimitive3 b203f3c8d8b54c5bbc69f81c51b67259 13.81,0.01,0,0 StartPointPrimitive4 c6996c9f7b57426580e456e1dc927c0c 13.81,0.75,0,0 EndPointPrimitive4 c6996c9f7b57426580e456e1dc927c0c 15.58,0.02,0,0 StartPointPrimitive5 1ec7bf923da343b1b91117bee95cbf89 15.58,0.75,0,0 EndPointPrimitive5 1ec7bf923da343b1b91117bee95cbf89 18.8,0.02,0,0 StartPointPrimitive18 72d8e9f010224edebd6ed21aa302bf28 18.8,0.75,0,0 EndPointPrimitive18 72d8e9f010224edebd6ed21aa302bf28 16.8,0.02,0,0 StartPointPrimitive19 94504557be3c494180bdfa894b3266c7 16.8,0.75,0,0 EndPointPrimitive19 94504557be3c494180bdfa894b3266c7 ReportTitleBand1 Left, Right, Bottom;Black;1;Solid;False;4;Black Transparent 0,7.63,20.4,0.76 Transparent True 2.4,0.11,7.18,0.51 Arial,7 0,0,0,0 Text12 {Principal.ProdCodEstr} - {Principal.ItNFProdNome} Black ,,,,WordWrap=True,A=0 Typographic Expression Center Transparent 9.89,0.09,1.85,0.51 Arial,7 Center 0,0,0,0 Text14 {Principal.EstqLocArmazLocaliz} Black Typographic Center Transparent 11.87,0.08,1.8,0.51 Arial,7 Center 0,0,0,0 Text15 {Principal.Lote} Black Typographic Center Transparent 14.04,0.09,1.45,0.51 Arial,7 Center 0,0,0,0 Text16 {Principal.CtrlLoteLocArmItNFQtd} Black 0 , 1 False False Typographic Center 2.33,0.01,0,0 StartPointPrimitive6 026af93bc75d4ec8b2efde8ded3c0e1d 2.33,0.74,0,0 EndPointPrimitive6 026af93bc75d4ec8b2efde8ded3c0e1d 9.83,0,0,0 StartPointPrimitive7 584262f304654d28ae65c240c4926460 9.83,0.73,0,0 EndPointPrimitive7 584262f304654d28ae65c240c4926460 11.8,0.03,0,0 StartPointPrimitive8 868e573580df48b098d82e5700be0077 11.8,0.73,0,0 EndPointPrimitive8 868e573580df48b098d82e5700be0077 13.81,0,0,0 StartPointPrimitive9 9231bb20c35143d9864404e744a2d83d 13.8,0.76,0,0 EndPointPrimitive9 9231bb20c35143d9864404e744a2d83d 15.58,0.01,0,0 StartPointPrimitive10 20dcb57601884ce6b657e8228d96d17b 15.58,0.74,0,0 EndPointPrimitive10 20dcb57601884ce6b657e8228d96d17b 16.8,-0.03,0,0 StartPointPrimitive20 0d16556809df410a8bae16ae8d3a2222 16.8,0.7,0,0 EndPointPrimitive20 0d16556809df410a8bae16ae8d3a2222 18.8,-0.03,0,0 StartPointPrimitive21 aca115e66f4a4e8eb9655529836cf5bd 18.8,0.7,0,0 EndPointPrimitive21 aca115e66f4a4e8eb9655529836cf5bd Principal DataBand1 Left, Right;Black;1;Solid;False;4;Black Transparent 0,9.19,20.4,1.29 Transparent 11.97,0.25,1.55,0.73 Arial,11,Bold Center 0,0,0,0 Text13 TOTAL: Black Typographic Center Transparent 13.83,0.28,1.85,0.69 Arial,11,Bold Center 0,0,0,0 Text17 {Sum(Principal.CtrlLoteLocArmItNFQtd)} Black 0 , 1 False False Typographic Expression Center ColumnFooterBand1 Left, Right;Black;1;Solid;False;4;Black Transparent 0,11.28,20.4,1.62 Transparent 0.06,-0.09,20.32,0.63 Arial,12,Bold| Underline Center 0,0,0,0 Text18 NOTAS FISCAIS RELACIONADAS Black Typographic Center Transparent 0.09,0.88,12.01,0.6 Arial,10,Bold Center 0,0,0,0 Text19 ENTIDADE Black Typographic Center Transparent 12.28,0.87,2.49,0.6 Arial,10,Bold Center 0,0,0,0 Text20 NOTAS Black Typographic Center Transparent 14.98,0.86,1.93,0.6 Arial,10,Bold Center 0,0,0,0 Text21 VOLUMES Black Typographic Center Transparent 17.08,0.87,1.86,0.6 Arial,10,Bold Center 0,0,0,0 Text22 OK Black Typographic Center 0.02,0.77,20.37,0.0254 Black Black HorizontalLinePrimitive1 Black 12.18,0.8,0,0 StartPointPrimitive14 4e7413623779445084e8ec0682d9b41b 12.18,1.56,0,0 EndPointPrimitive14 4e7413623779445084e8ec0682d9b41b 14.88,0.8,0,0 StartPointPrimitive15 f994613f66c84b06ae2af2af95a41c65 14.88,1.61,0,0 EndPointPrimitive15 f994613f66c84b06ae2af2af95a41c65 17,0.77,0,0 StartPointPrimitive16 c1542ddb62204dbd966fbc2c08d6763c 17,1.58,0,0 EndPointPrimitive16 c1542ddb62204dbd966fbc2c08d6763c ChildBand1 All;Black;1;Solid;False;4;Black Transparent 0,13.7,20.4,0.76 Transparent 0.07,0.11,12.04,0.51 Arial,10 Center 0,0,0,0 Text23 {NFS.Cliente} Black Typographic Center Transparent 12.26,0.11,2.51,0.51 Arial,10 Center 0,0,0,0 Text24 {NFS.NFNUm} Black Typographic Center Transparent 14.93,0.11,1.98,0.51 Arial,10 Center 0,0,0,0 Text25 {NFS.NFQtdVol} Black 0 , 1 False False Typographic Center 12.18,0.02,0,0 StartPointPrimitive11 af6df93ea2d14faf8d333a3e72df9ffa 12.18,0.75,0,0 EndPointPrimitive11 af6df93ea2d14faf8d333a3e72df9ffa 14.87,0.01,0,0 StartPointPrimitive12 7cb029937c19426f9ba111f69d9931dc 14.87,0.74,0,0 EndPointPrimitive12 7cb029937c19426f9ba111f69d9931dc 17.01,0,0,0 StartPointPrimitive13 c360f6a83ec540dfa53f8c3b7ea7f6a9 17.01,0.73,0,0 EndPointPrimitive13 c360f6a83ec540dfa53f8c3b7ea7f6a9 NFS DataBand2 Left, Right, Bottom;Black;1;Solid;False;4;Black Transparent 0,15.26,20.4,1.86 Transparent 8.3,-0.02,3.71,0.75 Arial,10,Bold 98be2dd42e6940c7ba80070d1b663a63 Center 0,0,0,0 Text26 TOTAL DE NOTAS: Black Typographic Center Transparent 12.22,0.01,2.43,0.69 Arial,10,Bold 887fe654e21a4523ab8f8e9941bb9972 Center 0,0,0,0 Text27 {Count()} Black 0 , 1 False False Typographic Center Transparent 14.8,0.04,2.16,0.64 Arial,10,Bold Center 0,0,0,0 Text28 {Sum(NFS.NFQtdVol)} Black 0 , 1 False False Typographic Expression Center Transparent 0.12,1.09,3.05,0.6 Arial,11,Bold Center 0,0,0,0 Text29 CONFERENTE: Black Typographic Center 0.01,0.98,20.4,0.0254 Black Black HorizontalLinePrimitive2 Black 3.34,0.99,0,0 StartPointPrimitive17 bdc34776b5fe418ab79656e304069c19 3.34,1.85,0,0 EndPointPrimitive17 bdc34776b5fe418ab79656e304069c19 ColumnFooterBand2 2.33,6.09,0.0254,0.73 Black Black 88bf6b5b0f184fcab928939b508247c1 VerticalLinePrimitive1 Black 9.83,6.09,0.0254,0.73 Black Black dad706d9b9f94cac9dbb6a5eb581116b VerticalLinePrimitive2 Black 11.8,6.09,0.0254,0.73 Black Black b203f3c8d8b54c5bbc69f81c51b67259 VerticalLinePrimitive3 Black 13.81,6.08,0.0254,0.74 Black Black c6996c9f7b57426580e456e1dc927c0c VerticalLinePrimitive4 Black 15.58,6.09,0.0254,0.73 Black Black 1ec7bf923da343b1b91117bee95cbf89 VerticalLinePrimitive5 Black 2.33,7.64,0.0254,0.73 Black Black 026af93bc75d4ec8b2efde8ded3c0e1d VerticalLinePrimitive6 Black 9.83,7.63,0.0254,0.73 Black Black 584262f304654d28ae65c240c4926460 VerticalLinePrimitive7 Black 11.8,7.66,0.0254,0.7 Black Black 868e573580df48b098d82e5700be0077 VerticalLinePrimitive8 Black 13.81,7.63,0.0254,0.76 Black Black 9231bb20c35143d9864404e744a2d83d VerticalLinePrimitive9 Black 15.58,7.64,0.0254,0.73 Black Black 20dcb57601884ce6b657e8228d96d17b VerticalLinePrimitive10 Black 12.18,13.72,0.0254,0.73 Black Black af6df93ea2d14faf8d333a3e72df9ffa VerticalLinePrimitive11 Black 14.87,13.71,0.0254,0.73 Black Black 7cb029937c19426f9ba111f69d9931dc VerticalLinePrimitive12 Black 17.01,13.7,0.0254,0.73 Black Black c360f6a83ec540dfa53f8c3b7ea7f6a9 VerticalLinePrimitive13 Black 12.18,12.08,0.0254,0.76 Black Black 4e7413623779445084e8ec0682d9b41b VerticalLinePrimitive14 Black 14.88,12.08,0.0254,0.81 Black Black f994613f66c84b06ae2af2af95a41c65 VerticalLinePrimitive15 Black 17,12.05,0.0254,0.81 Black Black c1542ddb62204dbd966fbc2c08d6763c VerticalLinePrimitive16 Black 3.34,16.25,0.0254,0.86 Black Black bdc34776b5fe418ab79656e304069c19 VerticalLinePrimitive17 Black 18.8,6.09,0.0254,0.73 Black Black 72d8e9f010224edebd6ed21aa302bf28 VerticalLinePrimitive18 Black 16.8,6.09,0.0254,0.73 Black Black 94504557be3c494180bdfa894b3266c7 VerticalLinePrimitive19 Black 16.8,7.6,0.0254,0.73 Black Black 0d16556809df410a8bae16ae8d3a2222 VerticalLinePrimitive20 Black 18.8,7.6,0.0254,0.73 Black Black aca115e66f4a4e8eb9655529836cf5bd VerticalLinePrimitive21 Black 452c460a47064d4397b8df51c300fac1 0.3,0.3,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Log_030A_Separacao_De_Volumes_NFS_Item_Lote 6/19/2017 3:49:43 PM 11/11/2016 11:31:09 AM Z:\\Log_030A_Separacao_De_Volumes_NFS_Item_Lote.mrt a102dd75d04a4448910e82e821318c06 Log_030A_Separacao_De_Volumes_NFS_Item_Lote Centimeters 2015.1.0 CSharp