O relatório em anexo apresenta a composição dos juros a apropriar (Acima de 60 dias), o ideal é armazená-lo no relatório Relatórios >> Contabilidade
- objeto ppReport1: TppReport AutoStop = Falso DataPipeline = daZQueryDataView1.Conta_Gr_fica PrinterSetup.BinName = 'Padrão' PrinterSetup.DocumentName = 'Relatório' PrinterSetup.Orientation = poLandscape PrinterSetup.PaperseName = 'A4' PrinterSetup.PrinterseSetup.Setup.Setup.BinName = 'Padrão' PrinterSetup.DocumentName = 'Relatório' PrinterSetup.Orientation = poLandscape PrinterSetup.PaperseName = 'A4' PrinterSetup.Printerse PrinterSetup.mmMarginBottom = 6350 PrinterSetup.mmMarginLeft = 6350 PrinterSetup.mmMarginRight = 6350 PrinterSetup.mmMarginTop = 6350 PrinterSetup.mmPaperHeight = 210000 PrinterSetup.mmPaperWidth = 297000 PrinterSetup.mmPaperWidth = 297000 PrinterSetup.Paperoft ' rios_socios \ Contabilidade \ Composi '# 231 # 227'o Juros Apro' + 'priar - Copia.rtm' Template.Format = ftASCII ArchiveFileName = '($ MyDocuments) \ ReportArchive.raf' DeviceType = 'Tela'DefaultFileDeviceType = 'PDF' EmailSettings.ReportFormat = 'PDF' LanguageID = 'Padrão' ModalPreview = False OnPreviewFormCreate = ppReport1PreviewFormCreate OutlineSettings.CreateNode = True OutlineSettings.CreatePageNodes = True OutlineSettings.CreatePageNodes = True OutlineSettings.CreatePageNodes = True OutlineSettings.CreatePageNodes = True OutlineSettings.Enpages PDFSettings.EncryptSettings.AllowCopy = Verdadeiro PDFSettings.EncryptSettings.AllowInteract = Verdadeiro PDFSettings.EncryptSettings.AllowModify = Verdadeiro PDFSettings.EncryptSettings.AllowPrint = True PDFSettings.EncryptSettings.EncabledSettings.EncabledSettings.EncabledSettings.EncabledSettingsSettings.EncabledFsettings.EnvolvedorFormwarePDF RTFSettings.DefaultFont.Charset = DEFAULT_CHARSET RTFSettings.DefaultFont.Color = clWindowText RTFSettings.DefaultFont.Height = -13 RTFSettings.DefaultFont.Name = 'Arial' RTFSettings.DefaultFont.Style = [] TextFileName = '($ MyDocuments) \ Report.pdf' TextSearchSettings.DefaultString = '' TextSearchSettings.Enabled = Falso XLSSettings.AppName = 'ReportBiulder' XLSSettings.Authorder ' ReportBuilder 'XLSSettings.Subject =' Relatório 'XLSSettings.Title =' Relatório 'Esquerda = 16 Top = 328 Versão = '14 .08' mmColumnWidth = 0 DataPipelineName = 'Conta_Gr_fica' objeto ppHeaderBand1: TppHeaderBand Background.Brush.Style = 0 bsHeaderBand Background.Brush.Style = 0 = 27252 mmPrintPosition = 0 objeto ppLabel1: TppLabel UserName = 'Label1' Caption = 'Ag' # 234'ncia 'Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name =' Arial 'Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 2117 mmTop = 21431 mmWidth = 13494 BandType = 0 LayerName = Objeto final do primeiro plano ppLabel2: TppLabel UserName = 'Label2' Caption = 'Conta' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 24871 mmTop = 21431 mmWidth = 10054 BandType = 0 LayerName = Objeto final do primeiro plano ppLabel3: TppLabel UserName = 'Label3 'Caption =' Modelo 'Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name =' Arial 'Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 59002 mmTop = 21431 mmWidth = 12435 BandType = 0 LayerName = Objeto final do primeiro plano ppLabel4: TppLabel UserName = 'Label4' Caption = 'Ano' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 88106 mmTop = 21431 mmWidth = 6615 BandType = 0 LayerName = Objeto final do primeiro plano ppLabel5: TppLabel UserName = 'Label5' Caption = 'Contrato' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 112448 mmTop = 21431 mmWidth = 14817 BandType = 0 LayerName = Objeto final do primeiro plano ppLabel6: TppLabel UserName = 'Label6' Caption = 'Total' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Fonte.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 234157 mmTop = 21431 mmWidth = 8202 BandType = 0 LayerName = Objeto final do primeiro plano ppLine1: TppLine UserName = 'Line1' Weight = 0.750000000000000000 mmHeight = 1323 mmLeft = 2117 mmWidth = 2117 mmWidth = 2117 mmWidth 270140 BandType = 0 LayerName = objeto final de primeiro plano ppLine2: TppLine UserName = 'Line2' Weight = 0,750000000000000000 mmHeight = 1323 mmLeft = 2117 mmTop = 26723 mmWidth = 270140 BandType = 0 LayerName = objeto final de primeiro plano ppDBText7: TppDBText7 'DBText7' 'codage' DataPipeline = plPara Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] ParentDataPipeline = Falso Transparent = True DataPipelineName = 'plPara'mmHeight = 4233 mmLeft = 2117 mmTop = 14817 mmWidth = 17198 BandType = 0 LayerName = Objeto final do primeiro plano ppDBText8: TppDBText UserName = 'DBText8' DataField = 'nomage' DataPipeline = plPara Font.Charset = DEFAULT_CHARSET Font.Color = DEFAULT_CHARSET Font.Color = DEFAULT_CHARSET Font.Color = DEFAULT_CHARSET Font.Color 'Arial' Font.Size = 10 Font.Style = [fsBold] ParentDataPipeline = False Transparent = True DataPipelineName = 'plPara' mmHeight = 4233 mmLeft = 22754 mmTop = 14817 mmWidth = 48683 BandType = 0 LayerName = Foreground nome do usuário final do objeto ppLabel7: TppLabel UserName = 'Label7' Caption = 'Composi' # 231 # 227'o Juros Apropriar em '# 233' data Cont '# 225'bil' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 18 Fonte.Style = [fsBold] Transparent = True mmHeight = 7408 mmLeft = 85461 mmTop = 2381 mmWidth = 140494 BandType = 0 LayerName = Objeto final do primeiro plano ppLabel9: TppLabel UserName = 'Label9' Caption = 'CC Modelo' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4191 mmLeft = 142611 mmTop = 21431 mmWidth = 19431 BandType = 0 LayerName = Objeto final do primeiro plano ppLabel10: TppLabel UserName = ' Label10 'Caption =' CC Juros ap '# 243's 60 d' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparente = True mmHeight = 4191 mmLeft = 184680 mmTop = 21431 mmWidth = 33782 BandType = 0 LayerName = Objeto final do primeiro plano ppDetailBand1: TppDetailBand Background1.Brush.Style = bsClear Background2.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 6615 mmPrintPosition = 0 objeto ppDBText1: TppDBText UserName = 'DBText1' DataField = 'CODAGE' DataPipeline = daZQuery.ClearDataView1.Conta_har_fieldConta_Field CLEULTAR_Field.Clolor.Conta_FONTECHAR_Field = CLULTAR_FieldConta_FONFONFONTOFONTO_FONTO_FONTO_FONTO_FONTOARConta_FONTAR_FieldConta_FONTOFONTO_FONTO_FONTOFONTO_FONTOFONTOARFALHA = DEZQueryDataView1. Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Conta_Gr_fica' mmHeight = 4022 mmLeft = 2117 mmTop = 529 mmWidth = 17198 BandType = 4 LayerName = Objeto final em primeiro plano ppDBText2: TppDBText UserName = 'DBText2' DataField = 'CTASOC' DataPipeline = daZQueryDataView1.Conta_Gr_fica Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Conta_Gr_fica'mmHeight = 3969 = 24871 mmLeft mmTop = 529 = 17198 mmWidth BandType = 4 = layerName primeiro plano objecto final ppDBText3: TppDBText UserName = 'DBText3' DataField = 'CODMOD' DataPipeline = daZQueryDataView1.Conta_Gr_fica Font.Charset = DEFAULT_CHARSET Font.Color = clBlack fonte. Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Conta_Gr_fica' mmHeight = 3969 mmLeft = 59002 mmTop = 529 mmWidth = 17198 BandType = 4 LayerName = Objeto final do primeiro plano ppDBText4: TppDBText UserName = ' DBText4 'DataField =' ANOCED 'DataPipeline = daZQueryDataView1.Conta_Gr_fica Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name =' Arial 'Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName =' Conta_Gr_fica 'mmHeight = 3969 = 88106 mmLeft mmTop = 529 = 17198 mmWidth BandType = 4 = layerName primeiro plano objecto final ppDBText5: TppDBText UserName = 'DBText5' DataField = 'NROCED' DataPipeline = daZQueryDataView1.Conta_Gr_fica Font.Charset = DEFAULT_CHARSET Font.Color = clBlack fonte. Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Conta_Gr_fica' mmHeight = 3969 mmLeft = 112448 mmTop = 529 mmWidth = 25929 BandType = 4 LayerName = Objeto final do primeiro plano ppDBText6: TppDBText UserName = ' DBText6 'DataField =' valor 'DataPipeline = daZQueryDataView1.Conta_Gr_fica DisplayFormat =' $ #, 0.00; - $ #, 0.00 'Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name =' Arial 'Font.Size = 10 Font. Style = [] Transparent = True DataPipelineName = 'Conta_Gr_fica'mmHeight = 3969 mmLeft = 234157 mmTop = 529 mmWidth = 38100 BandType = 4 LayerName = Objeto final em primeiro plano ppDBText9: TppDBText UserName = 'DBText9' DataField = 'conta_contabil_do_modelo' DataPipeline = daZQueryDataView1.Conta_Gr. Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Conta_Gr_fica' mmHeight = 3969 mmLeft = 142611 mmTop = 529 mmWidth = 25929 BandType = 4 LayerName = Objeto final do primeiro plano ppDBText10: TppDBText UserName = ' DBText10 'DataField =' conta_apropriar 'DataPipeline = daZQueryDataView1.Conta_Gr_fica Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name =' Arial 'Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName =' Conta_Gr_fica 'mmHeight = 3969 mmLeft = 184680 mmTop = 529 mmWidth = 25929 BandType = 4 LayerName = Objeto final do primeiro plano ppFooterBand1: TppFooterBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 6879 mmPrintPosition = 0ppLineNome do usuário: objeto TppLine = 0ppLineName Pen4 'PenPrintLine = 0 do objeto Line4' .Width = 2 Weight = 1.500000000000000000 mmHeight = 1058 mmLeft = 0 mmTop = 0 mmWidth = 272257 BandType = 8 LayerName = Objeto final do primeiro plano ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' HyperlinkEnabled = False VarType = False VarType = 8 LayerName = Objeto final de primeiro plano ppSystemVariable1: TppSystemVariable UserName = 'SystemVariable1' HyperlinkEnabled = False VarTypeSource = Font.CharType_vtPrint clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True mmHeight = 3969 mmLeft = 11377 mmTop = 794 mmWidth = 37306 BandType = 8 LayerName = Objeto final do primeiro plano ppSystemVariable2: TppSystemVariable UserName = 'SystemVariable2'HyperlinkEnabled = Falso VarType = vtPageNoDesc Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] TextAlignment = taRightJustified Transparent = True mmHeight = 3969 mmLeft = 258498 mmTop = 79498 mmLeft = 258498 mmTop = 79498 mmLeft = 13758 BandType = 8 LayerName = Objeto final do primeiro plano ppImage1: TppImage UserName = 'Image1' AlignHorizontal = ahCenter AlignVertical = avCenter AutoSize = True MaintainAspectRatio = Imagem falsa.Dados = {07544269746D61703E050000424D3E0500000000000036000000280000001E00 00000E000000010018000000000008050000232E0000232E0000000000000000 0000FF5757FF2626FF2424FF2424FF2424FF2424FF2424FF2424FF2828FF6464 FFBABAFFE4E4FF4C4CFF6E6EFFE0E0FFC9C9FF8181FF4444FF2525FF2424FF24 24FF2424FF2424FF2424FF2828FF6363FFDADAFFFFFFFFFFFFFFFFFF0000FF1D 1DFF0000FF0000FF0000FF0000FF0000FF0000FF0202FF3E3EFFD4D4FFF9F9FF FDFDFF9797FF2B2BFF8D8DFFFAFAFFE9E9FFAFAFFF3434FF0404FF0000FF0000 FF0000FF0000FF0000FF0B0BFF9393FFFFFFFFFFFFFFFFFF0000FF5656FF0101 FF0000FF0000FF0000FF0000FF0000FF2525FFBCBCFFFEFEFFFFFFFFFFFFFFE9 E9FF7373FF2323FFCECEFFFCFCFFFBFBFFCACAFF4F4FFF0707FF0000FF0000FF 0000FF0000FF0000FF5151FFFEFEFFFFFFFFFFFF0000FF9A9AFF0A0AFF0000FF 0000FF0000FF0000FF0505FF6D6DFFEFEFFFFFFFFFFFFFFFFFFFFFFEFEFFE1E1 FF5757FF4242FFD3D3FFFCFCFFFDFDFFD9D9FF4D4DFF0000FF0000FF0000FF0000FF0000FF1111FFEFEFFFFEFEFFFFFF0000FFC2C2FF1F1FFF0000FF0000FF00 00FF0000FF0D0DFF9090FFF8F8FFFEFEFFF6F6FFD4D4FFC1C1FFBFBFFFA7A7FF 2424FF7474FFEBEBFFFEFEFFFBFBFFC2C2FF0E0EFF0000FF0000FF0000FF0000 FF0101FFC2C2FFFEFEFFFFFF0000FFE0E0FF4747FF0000FF0000FF0000FF0000 FF1111FF9A9AFFFBFBFFFDFDFFB5B5FF3131FF1A1AFF2121FF4040FF8080FF2A 2AFF9898FFFCFCFFFEFEFFFBFBFF5F5FFF0303FF0000FF0000FF0000FF0000FF 8282FFF9F9FFFFFF0000FFF3F3FF7979FF0808FF0000FF0000FF0000FF0A0AFF 8686FFF6F6FFFCFCFFB2B2FF1C1CFF2424FF8080FF8F8FFFBEBEFF5959FF1F1F FFDCDCFFFEFEFFFFFFFFB7B7FF1414FF0000FF0000FF0000FF0000FF4949FFE9 E9FFFFFF0000FFFBFBFFA3A3FF1414FF0000FF0000FF0000FF0303FF5D5DFFE9 E9FFFEFEFFE5E5FF5555FF3030FFB0B0FF9393FF7F7FFF3F3FFF0404FF8C8CFF F9F9FFFFFFFFD6D6FF3131FF0000FF0000FF0000FF0000FF2828FFCACAFFFEFE 0000FFFEFEFFD2D2FF2E2EFF0000FF0000FF0000FF0000FF2020FFBDBDFFFEFEFFFCFCFFD5D5FF2727FF5B5BFF6161FF2222FF1F1FFF1D1DFF8F8FFFF9F9FFFF FFFFDFDFFF4040FF0000FF0000FF0000FF0000FF1111FF9999FFF9F90000FFFF FFFFEEEEFF5757FF0000FF0000FF0000FF0000FF0303FF5555FFF4F4FFFEFEFF FDFDFF9898FF2B2BFF7A7AFFC1C1FFC2C2FFC7C7FFF2F2FFFEFEFFFFFFFFDBDB FF3838FF0000FF0000FF0000FF0000FF0404FF6B6BFFEFEF0000FFFFFFFFFAFA FF8A8AFF0000FF0000FF0000FF0000FF0000FF0A0AFFA0A0FFF6F6FFFEFEFFE7 E7FF6A6AFF2626FFD7D7FFFDFDFFFFFFFFFFFFFFFFFFFFFFFFFFC3C3FF1D1DFF 0000FF0000FF0000FF0000FF0000FF4242FFDEDE0000FFFFFFFFFDFDFFD2D2FF 0303FF0000FF0000FF0000FF0000FF0000FF1414FF8080FFE0E0FFFDFDFFDFDF FF5353FF4545FFD5D5FFFCFCFFFFFFFFFEFEFFF3F3FF5A5AFF0202FF0000FF00 00FF0000FF0000FF0000FF1717FFB8B80000FFFFFFFFFEFEFFF7F7FF2C2CFF01 01FF0000FF0000FF0000FF0000FF0000FF1111FF5959FFC9C9FFF0F0FFCBCBFF 2626FF7373FFEAEAFFFCFCFFE7E7FF9292FF0A0AFF0000FF0000FF0000FF0000FF0000FF0000FF0808FF94940000FFFFFFFFFFFFFFFEFEFFA9A9FF4343FF2A2A FF2A2AFF2A2AFF2A2AFF2A2AFF2A2AFF2F2FFF5858FF9B9BFFDEDEFF8A8AFF3F 3FFFB9B9FFDCDCFF8989FF4141FF2A2AFF2A2AFF2A2AFF2A2AFF2A2AFF2A2AFF 2A2AFF3A3AFFB4B40000} mmHeight = 3704 = 1588 mmLeft mmTop = 794 = 7938 mmWidth BandType = 8 layerName = Plano extremidade final objecto ppSummaryBand1: TppSummaryBand Background.Brush.Style = bsClear mmBottomOffset = 0 mmHeight = 8731 = 0 mmPrintPosition ppDBCalc1 objeto: TppDBCalc Nome_do_utilizador = 'DBCalc1' DataField = 'valor' DataPipeline = daZQueryDataView1.Conta_Gr_fica DisplayFormat = '$ #, 0,00; - $ #, 0,00' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [] Transparent = True DataPipelineName = 'Conta_Gr_fica'mmHeight = 3969 mmLeft = 234157 mmTop = 3704 mmWidth = 38100 BandType = 7 LayerName = Objeto final do primeiro plano ppLabel8: TppLabel UserName = 'Label8' Caption = 'Total' Font.Charset = DEFAULT_CHARSET Font.Color = clBlack Font.Name = 'Arial' Font.Size = 10 Font.Style = [fsBold] Transparent = True mmHeight = 4233 mmLeft = 219605 mmTop = 3704 mmWidth = 8202 BandType = 7 LayerName = Objeto final do primeiro plano ppLine3: TppLine UserName = 'Line3' Weight = 0.75000000000000 mmHeight = 0.75000000000000 mmHeight = 1.75000000000000 mmHeight = 1323 mmLeft000000000000 = 2117 mmTop = 794 mmWidth = 270140 BandType = 7 LayerName = Objeto final do primeiro plano daDataModule1: Objeto TdaDataModule daZQueryDataView1: TdaZQueryDataView UserName = 'Query_TdaZQueryDataView'Height = 313 Left = 232 NameColumnWidth = 105 SizeColumnWidth = 35 SortMode = 0 Top = 81 TypeColumnWidth = 52 Width = 496 AutoSearchTabOrder = 0 objeto Conta_Gr_fica: TppChildDBPipeline AutoCreateFields = Falso UserName = 'TppField' objeto FieldName = ContaAlfica 'FieldName =' ContaAlfica 'FieldName campo =' ContaAlfica 'FieldName ppField1 valor Fieldias = campoField1 valor Fieldias1% campo = pppField2Field2fields = Falso valorCampoField1 valor = FieldNamePppField1 campo = pppField1fieldFields = objeto campo = pppField = campo = campoField1 campo = pppField2Fields campo = campo de campo = campo1 = campoFields = campoFields = Falso UserName 'valor' FieldLength = 0 DataType = dtDouble DisplayWidth = 10 Position = 0 objeto final ppField2: TppField FieldAlias = 'codmod' FieldName = 'codmod' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 1 objeto final ppField3: TppField FieldAlias = ' anoced 'FieldName =' anoced 'FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 2 objeto final ppField4: TppField FieldAlias =' nroced 'FieldName =' nroced 'FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 3 objeto final ppField5: TppField FieldAlias = 'codage' FieldName = 'codage' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 4 objeto final ppField6: TppField FieldAlias = 'ctasoc' FieldName = 'ctasoc' FieldLength = 0 DataType = dtInteger DisplayWidth = 10 Position = 5 objeto final ppField7: TppField FieldAlias = 'conta_contabil_do_modelo' FieldName = 'conta_contabil_do_modelo' FieldLength = 30 DisplayWidth = 30 Position = 6 objeto final ppField8: TppAlias 'Fieldalias = 6 final campo ppField8: TppAlias' FieldName = 'conta_apropriar' FieldLength = 30 DisplayWidth = 30 Position = objeto final 7 daSQL1: TdaSQL CollationType = ctASCII DatabaseName = 'acGere' DatabaseType = dtOracle DataPipelineName = 'Conta_Gr_fica 'EditSQLAsText = True IsCaseSensitive = True LinkColor = clMaroon LinkType = ltParameterizedSQL MaxSQLFieldAliasLength = 25 SQLText.Strings = (' '' '' selecionar round (sum (vlrcgr), 2) como valor, cgra.codoced, cgra. 'cgra.nroced, cgra.codage, cgra.ctasoc, modc.clapla as conta_cont' + 'abil_do_modelo, (selecione crehis de hist onde codhis = historic' + 'ojurosapropriar) como conta_apropriar' '' 'de cgra join modc em cgra. codmod = modc.codmod '' where '' datcgr <= (selecionar p_dctb do para) e '' clapla ilike '# 39'16%' # 39 'e' '(cgra.codhis = historicojurosapropriar ou' 'cgra.codhis = historico_transferencia_juros_apropriar) '' '' group by cgra.codmod, cgra.anoced, cgra.nroced, cgra.codage, cg '+ 'ra.ctasoc, modc.clapla, historicojurosapropriar' 'tendo soma (vlrcgr) <> 0' 'ordenar por cgra.anoced, cgra.codmod, cgra.nroced, cgra.codage, cg' + 'ra.ctasoc, modc .clapla ') SQLType = sqSQL2 objeto daField1: TdaField Alias =' valor 'DataType = dtDouble DisplayWidth = 10 FieldAlias =' valor 'FieldLength = 0 FieldName =' valor 'SQLFieldName =' valor 'objeto final daField2: TdaField Alias =' codmod ' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'codmod' FieldLength = 0 FieldName = 'codmod' SQLFieldName = 'codmod' objeto final daField3: TdaField Alias = 'anoced' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'anoced' FieldLength = 0 FieldName = 0 FieldName 'anoced' SQLFieldName = 'anoced' objeto final daField4:TdaField Alias = 'nroced' DataType = dtInteger DisplayWidth = 10 FieldAlias = 'nroced' FieldLength = 0 FieldName = 'nroced' SQLFieldName = 'nroced' objeto final daField5: TdaField Alias = 'codage' DataType = dtIntegerias DisplayWidth = 10 FieldName 'FieldLength = 0 FieldName =' codage 'SQLFieldName =' codage 'objeto final daField6: TdaField Alias =' ctasoc 'DataType = dtInteger DisplayWidth = 10 FieldAlias =' ctasoc 'FieldLength = 0 FieldName =' ctasoc 'SQLFieldName =' ctasoc 'objeto final daField7: TdaField Alias = 'conta_contabil_do_modelo' DisplayWidth = 30 FieldAlias = 'conta_contabil_do_modelo' FieldLength = 30 FieldName = 'conta_contabil_do_modelo' SQLFieldName = 'conta_contabil_do_modelo' objeto final daField8:TdaField Alias = 'conta_apropriar' DisplayWidth = 30 FieldAlias = 'conta_apropriar' FieldLength = 30 FieldName = 'conta_apropriar' SQLFieldName = 'conta_apropriar' end end end end objeto ppDesignLayers1: Objeto TppDesignLayers ppDesignLayer1: TppDesignLayer 'Nome do usuário =' ForegroundLayer = 'Nome do usuário do TppB ppDesignLayer1:' end end objeto ppParameterList1: TppParameterList end end