{ "ReportVersion": "2025.4.1.0", "ReportGuid": "5aa7b9e554bf43a3966f4324cc8826c8", "ReportName": "Auditoria de Relacion de Cartera", "ReportAlias": "Auditoria de Relacion de Cartera", "ReportCreated": "/Date(1710963192000+0100)/", "ReportChanged": "/Date(1760349963071+0200)/", "EngineVersion": "EngineV2", "ScriptLanguage": "CSharp", "Script": "using System;\r\nusing System.Drawing;\r\nusing System.Windows.Forms;\r\nusing System.Data;\r\nusing Stimulsoft.Controls;\r\nusing Stimulsoft.Base.Drawing;\r\nusing Stimulsoft.Report;\r\nusing Stimulsoft.Report.Dialogs;\r\nusing Stimulsoft.Report.Components;\r\n\r\nnamespace Reports\r\n{\r\n public class Auditoria_de_Relacion_de_Cartera : Stimulsoft.Report.StiReport\r\n {\r\n public Auditoria_de_Relacion_de_Cartera() {\r\n this.InitializeComponent();\r\n }\r\n\r\n #region StiReport Designer generated code - do not modify\r\n\t\t#endregion StiReport Designer generated code - do not modify\r\n }\r\n}\r\n", "CalculationMode": "Interpretation", "ReferencedAssemblies": { "0": "System.Dll", "1": "System.Drawing.Dll", "2": "System.Windows.Forms.Dll", "3": "System.Data.Dll", "4": "System.Xml.Dll", "5": "Stimulsoft.Controls.Dll", "6": "Stimulsoft.Base.Dll", "7": "Stimulsoft.Report.Dll" }, "Dictionary": { "Resources": { "0": { "Name": "AuditoriaRelacionCartera", "Alias": "AuditoriaRelacionCartera", "Type": "Json", "Image": "LfeVdYHbapnceoT5URiSmpqQ3VMKw/pevGmMmBz/lKmXgUZ+ojXzvoWDSAGLCAYcZgGU97POESxZDGf1edGVcESVkl2JwcpOwz2sOxhD2DaxtVXVXEzkdItJfvjll+v5TfDwG6U4yU24Ylpqd1Z1/gck8hIbcDbxaKss1iuULzPun+F5IjYpx2WqkVSNrWqVQFNvWwPQDOAKi6r/q2a5SKdP+ZevAnYgc7TY+DHWBtgOwzHWTGCMTgvaai8QFf11DptH71pXeLnlGUPaVyYuhb3AyQvy9k7vz8CqGh4LCeIGcwwEhZhZfRGomKLucWC6MMZlBnVdSeFkNVWXNF1ofRilKxnfp3iMMu9Q9HFWxMoPMdl9EMR4IEItWkKYCKzh27pdln27Gp/oGNMvD6z81G1rXvq84xcnhxlKRM1rbtBQGxgj/Jf4FI/18XyLYCp4Hosc8tcD3UqywO5dQVgQmvsHG20Pbyv2I7/EXO8snq3hLxf+XvMg6hO3H4qvqqoKnKVhayBGk+AVFBYyKRySsR+hi9zfLfZwrxscyk+12fZ4xfueFSI6w9FZIOLYjltLUP3fbzAjdaR0VnivRreSgXBT/OJHRlRniAss8u2E9f63QmAk6VWLmHSvN8tXDl41fz0vY9CDEPvjORaR33BkvSYxaNeZSE6DIhuYUEm3/iFgmGRMQoN9p7n400GJbVni94wedkjV0dwhNDHl2UYGWN35KDwiRaq9IxLoU6C4MB4HpBSQUTM8istNYf6wBdo6d/jj/BPiLelmtb2lYHg7G9xKWZdliCuaWD5Kt+cbEr1TLPkL/pFc0EuZoJ4rQGIv4T2NcwSxLuWgepP1w+Y5YzM9SDDR2Sb/T4IZaYxqJCrrbNABSucM3QWOYO8JSoTzay7UFgZhw9g/4fk1eUkxLxyAPZhpEWOMNR6IfOoWhAiBF1fz4d1Gl0I6aJY/rgZ2vhFLI85Zkhlm9BN4Z2jyP+ZxVGsXql7BNSudKPseucXwaC+quqH3aU8lcjjP+FuVmPDTEmXfN003Uv1Ot9NrkXToYoZED05vQdHxcbWEHQ9D+Jgm+a2UgnMqOjeC4Qvk7kntNilqu/Xb6ZaUSrikyVrd7/KL/427teRUp2Mvv622G7h2u+jFQn3QDNWRMLOCSwPzufxDt568VYrrXO0eZJVboCUJF2ddaFPh2yztZuIYhCujwr2bHSXMAMLaidYcwn1FV+lB19McXqN82tPqPuh0SGdfYP0iZ2l5dESKXG90SQwmiPyEPmAcmo1ORFyB3SUPejWrXeu4oCDS5qmeRWiRr347Spc+x4fWK2cxNFTfT+gP3TdnxeHPr96i26wUbbh3jBcPmxFF19SE3SzP/JAFZOsO33o8iUHn/6datlaLFiIX/4Vr9n7YrRcHfXRhAUpgDo0H75Bx5XHpc9NooHW+1tIwVUMwYMc5hIuD3SFBjt04qYTNhnW8Q+NTTUNq0tv1IfEBc7+ASOqeyEDode1MZKMDbcWSVBMrv8li8KPryJiDFhtfJdbdV8ugMpvc7D8Jn+lZkonbOeSqFe+mMBi0OYWYkQSS2qDKlpIyX6fNUnVgF1LUfGkfQl6HfS0TazHPHE2+p73st0OTiryw2rbFO/umlfIANNAAHUp/EcWtZhkbjg9hKLpUjkEfnnu8lmsF2vVXGNpyKUiy8DeroYrVi42GVMJH+eChqOXg2UIVX6cPYzAWboojE5xA3Yxy/FlmPj5hd0Cs8J9RyMNV03rUeaBuyERS2UJ/VeEDfirHb7UsERA12kZVJmUnQIQgR+dND7C8BOJqcpWWRjcICaD4E1+4mwDGrsXDfURZc2zFOFww3M9soVa/aZa3w21nIpsO2gGNMy2MIUqUCc5mkEXRCXmqNLxy3X+I6Bv7Cy692F+5/J/QylWm3H7nV5nMtnj+iWPwzJEIJPnRwpjWEI4ac/wmu6hGTIijerjc1A8XAbKdeepJmkPjXc/DWJLvyfsP/p2P4TwGskMBinAcww4QGqHBlzA99weXzp2yeSl2FDlMsdb9ezdkibpigMEs2wkBI8p9lrxFXxEpcsn2NNirj8IE/WT+GIjLWkyeAbrfCrCtM2KbezaZywoVMjVk3cRdO0m4GeO0YgVhpDTqpj3joZy3rJ6k4LeCTIuMSCGVEmrP116LKc0wZOVHVhfOxlufkRjb2TMQXe+6cqs2Kfu2SSiox1+n3Dx76gwLpUDGLDPEYcsc/SlKckJ5OtQrLHgQc62kqWCS5gpFRD2dX6vHX65NnpSysYrNKIbl8PB3Mfw9vw8jyWWF9/7dHqzjy77DUPSxPL+7S6NIEbcTkPZKriP1ZbOAYNNDsh3AqQRbEJkgf3Rsa2jwH2U2Tv/5dAvkYVk+umK7NpSLpfJlH48bVwUpow31hRmymoVDqGQNFfsfb1AGCSq2BlAsTfyFBQS/bInpQbHZ1hxRl2IW9EKU/rwgg+RZimKxB2+8X9J4mMXvVEeZ+5RQMqy3EK9rYkP5d2hp3guxA5WxzRl89ToXv68huSgKt7HwFEndOc6GSyqgt4j3qKJM2iqnUqMo+tylyGXTeZ0WCfpYn63sjpLvZFXb6Q5fh8NaneWQ6106B0nRBRHzfzJ58hzrYAiJJhFz6LzlaPy6OezfDA087g5wc1HQBufQ1CLZ5SU6HtJpYcYpZGxc/1VvByDzOsqFxzr/TinljdkjN+w0U9m+q7tATeKRhA7ynkxaCB7rUoMCNbF+1ToBki9Z4xJRH8IEzeD8TT7PRggYtZjNBb0dYN3AYPVDQlPBGjFPZV0Qd1TQxpbNd4RQfZDG2VNdqccGPCCwtaAs/Y/hmfFFBh/oLmKpyudU7Nxmr4NJKRbHs6wPiz/2N1d8IfwyYpH4BIK/APsfA27MOT1LfyiBiUdjQ1jgcTqKp6TmjqdYCd+peNQRQ5MExso2gKezh6Ck3MOqz9K59p0YAsdZsEYtp3EH2xng4on7rrgV/gRKv2IOeZBDPCXHWY3kCsc7Uzuql7hzNdQ9oz6ZjD1mwQgC7sQ7LWxZ+5h59D9Wp6lyQt76SZfQ4L8X0Ynk98Hvp0IadPM44V+wWw68LjkVWkmW0K7B5Kiek7Nwlw4Hzz80shKDY1Lb044YLF48ivehvuMKXlD+QB5gNUNxlBDYVlr4FrFI8U7Wm0oxo/2QCbE4G5cR1r00vRidKDjYw1miVmF9EpzMg3N+AD2ptGbbenxNwmj/JWVPtAKeRmwtY3BEdpxGjaEWntPrrA2HQVeb+51nrRTlhYJK/hBDjGivaHW2rrxSSybZ2YlEHksVzeq7KrGnPYhR4o59sFsfXZNZFZ4ueZlzhepkbAJVBn/nBZw9Y54mkjsK7tOJybbE8155RxIge6zVWQnrHM2xUL1MgjfAX8qQExYP8sr70w07Pg+NgfJ53Kyt+nlg5z1RXrnxDoIVq9nlg+vIfxCigLPeDA5n8/5Pf4c+JnbxSKhcGvwbrSTaAlAawSJje4G+9Ba9NE6LpnEXWC5YQLFH9FMATnHYb459cgM8tT7USTxgDdcHxPyZ8kGmJteekwStuu0H2M9YMP6W5iuQEVX+uX5zJRgISqzYY7VsmLDY3gK5dyDmsrn02nmEnE0RIokwjuXm6M/sjiuFcLm4CjDUKfwITUcP/8w+CNVQkUrERpMpbtaL+fOnHwF6FGrDtqmK9SfxdSy9PLvVlRxNT2LafDxP3IZVETjsULB6VFJ3zNaTN1KPVbcRcsGJHStXQgdBamC1zYucJbbC8cuUMuUAMSs7ugX9Pr8lQBMU4lw8tBMOQe/GI6/+Fx0pCyc0J+oexlgCh9qAsR3jcYTnhTIXmUU+oKwqe2LbTlOoMsEzhAW0YhWmb9SkZaJNq4YfU0WHLPMDYqql4AolF4AjNbmQSKjsznf6f3YILNHlWi8XZqzYIVblv9R367M+5WNPS/Fduhjlg0Ao3b+zmQJJDGDOrVzA4JVKfDnpJw4FCw+0rWt/7U+/01rXvs3QxSRsDWJFJDADCqHJ8KARKk2lepmzSwDMlUDpq76CPrMZURWUPHd7Tqmw24BGG+/xLs/Q0joeIYlW7qY0uGw0189wamzf6X5wc7e5Jg/l/YB27F+/6hSkTkxSR89wWzPReDodfeUVRMrny0IaJ42gqAnAjVXEcbkesAzaAbY47Ovjh2PvQ+iVa4AHNfMtNFjO+Uh3P/U8G9dmmGmw4euqN97Y9CXyQJLBOmldBUCgVPMVZUlRGC/wUK8mHxk/j885HoFggSqEXqAcI4m8/Jj3hVI/UHkr1+16qoqb6dYW4ZnRgvd/f9c9wZ2i+dJOKUkY3NAsHIsBjufCIrZD15iOQwVGjSgu+3nwA4/CJob0GnUXE47PavDB4DJundCV/LxVX6332F/KWwFWXpnSeIEwqNfjWK7TDEOP+B1sY5lBXdiQmVMZ5oqXRM3Oc7KEjUE0FC90GJYHcTGEHSgO5OsZZ5BmNrVSHTBu4neYw4wneqwe9v+CO+8IN5RBC8pT2ZNRaDQJGffJQpE3rM8xxqJ7WVMDqf9ri8j3yiPLwloI2/AsL1IEhrJhCmHBeoF6z0Daa4JunBz5LPuYOweYdpinZ19t+XJ+1sgJSFyfE+sji7cfhCwj1T3NBmmmhKks2XrgUwtG+PaElSuvNFM92GiqcYxlwgzA7Sx86qUgrjK832y/45tPdrhd52bM2bw4lgGldKsF3GyvRhXpf7+7zujfajLjmyOUwUnVszO5/oeDpA4w1v1mD0X1FlViXpstj0cd5WJSEIeoX+eYbrOyUT3H6awInbDPzeiZUAESjrRlpFz40xLvEmtWokLzQ1GcwpgLMhwfA9accaOQ7j7Xzem7zmDKwRBz/3o7FsR6+YUOY9yW77GbFMTpQeJV4fkDZN/LuBccrvnlSLlxlc0OTpsCWiZg6h3m2MwL8buUIwiqH/QkUjwLRQpN9EYjQ/EMwMdrafNquX8cvFAz2ZAlV1tFILPcH4entFV2ggL1DJ0SXMd7Naaw5h47fjTJP2qtP/R5jAnGumDcg4ERGbceyuyte7/Wg75onVWnyUnRzXzo6J/QGfgvFvxJseiWjG/RUhEnQDAlH1HT5Tr7jQxsqnmJZWlEGaUhM4E1iZEUf5mH24izB2ChEJsOjEyglpDtdHxCTXEIuG/w/z2RVVjK0keL75vxcIV2l04Gzsdvk0Dmppzafrqh8ax/XBi+CxspRMRqVE9Irg1JqwirUOBtv1CD7hfzRhUEP+50wRMKvyObx5R2PvCYrILzb1nlMfMCRKjtArFpdUNxmYwmDUYu+V6UDzGhGk0ShWw4s6M5FVplQbWR" } }, "Variables": { "0": { "Value": "Sum(root_datos.Saldo_referencia)", "Name": "TotalSaldoPorTercero", "Alias": "TotalSaldoPorTercero", "Type": "System.Double", "Description": "TotalSaldoPorTercero", "InitBy": "Expression", "DialogInfo": { "DateTimeType": "DateAndTime", "SortDirection": "None" } } }, "DataSources": { "0": { "Ident": "StiDataTableSource", "Name": "root", "Alias": "root", "Key": "693686e5cb6c4f4c98d829431b0b045c", "Columns": { "0": { "Name": "cabeceras", "Index": -1, "NameInSource": "cabeceras", "Alias": "cabeceras", "Type": "System.String" }, "1": { "Name": "data", "Index": -1, "NameInSource": "data", "Alias": "data", "Type": "System.String" }, "2": { "Name": "datos", "Index": -1, "NameInSource": "datos", "Alias": "datos", "Type": "System.String" }, "3": { "Name": "filtros", "Index": -1, "NameInSource": "filtros", "Alias": "filtros", "Type": "System.String" }, "4": { "Name": "table_name", "Index": -1, "NameInSource": "table_name", "Alias": "table_name", "Type": "System.String" } }, "NameInSource": "AuditoriaRelacionCartera.root" }, "1": { "Ident": "StiDataTableSource", "Name": "root_cabeceras", "Alias": "root_cabeceras", "Key": "895fa4e4805449109507d7e0b2057d4d", "Columns": { "0": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "1": { "Name": "value", "Index": -1, "NameInSource": "value", "Alias": "value", "Type": "System.String" } }, "NameInSource": "AuditoriaRelacionCartera.root_cabeceras" }, "2": { "Ident": "StiDataTableSource", "Name": "root_data", "Alias": "root_data", "Key": "57de17af5a8e4decaf7462c396c6109b", "Columns": { "0": { "Name": "empresa", "Index": -1, "NameInSource": "empresa", "Alias": "empresa", "Type": "System.String" }, "1": { "Name": "fecha", "Index": -1, "NameInSource": "fecha", "Alias": "fecha", "Type": "System.String" }, "2": { "Name": "hora", "Index": -1, "NameInSource": "hora", "Alias": "hora", "Type": "System.String" }, "3": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "AuditoriaRelacionCartera.root_data" }, "3": { "Ident": "StiDataTableSource", "Name": "root_data_empresa", "Alias": "root_data_empresa", "Key": "84c3b49629124d16aafe1ac88754f073", "Columns": { "0": { "Name": "agenteRetencionFuente", "Index": -1, "NameInSource": "agenteRetencionFuente", "Alias": "agenteRetencionFuente", "Type": "System.Boolean" }, "1": { "Name": "agenteRetencionIva", "Index": -1, "NameInSource": "agenteRetencionIva", "Alias": "agenteRetencionIva", "Type": "System.String" }, "2": { "Name": "autoretenedorFuente", "Index": -1, "NameInSource": "autoretenedorFuente", "Alias": "autoretenedorFuente", "Type": "System.Boolean" }, "3": { "Name": "codigoActividadEconomica", "Index": -1, "NameInSource": "codigoActividadEconomica", "Alias": "codigoActividadEconomica", "Type": "System.String" }, "4": { "Name": "createdAt", "Index": -1, "NameInSource": "createdAt", "Alias": "createdAt", "Type": "System.DateTime" }, "5": { "Name": "digitoVerificacion", "Index": -1, "NameInSource": "digitoVerificacion", "Alias": "digitoVerificacion", "Type": "System.String" }, "6": { "Name": "direccion", "Index": -1, "NameInSource": "direccion", "Alias": "direccion", "Type": "System.String" }, "7": { "Name": "enabled", "Index": -1, "NameInSource": "enabled", "Alias": "enabled", "Type": "System.Boolean" }, "8": { "Name": "granContribuyente", "Index": -1, "NameInSource": "granContribuyente", "Alias": "granContribuyente", "Type": "System.String" }, "9": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "10": { "Name": "municipio", "Index": -1, "NameInSource": "municipio", "Alias": "municipio", "Type": "System.String" }, "11": { "Name": "numeroDocumento", "Index": -1, "NameInSource": "numeroDocumento", "Alias": "numeroDocumento", "Type": "System.String" }, "12": { "Name": "pais", "Index": -1, "NameInSource": "pais", "Alias": "pais", "Type": "System.String" }, "13": { "Name": "razonSocial", "Index": -1, "NameInSource": "razonSocial", "Alias": "razonSocial", "Type": "System.String" }, "14": { "Name": "regimenSimpleTributacion", "Index": -1, "NameInSource": "regimenSimpleTributacion", "Alias": "regimenSimpleTributacion", "Type": "System.Boolean" }, "15": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "16": { "Name": "responsabilidadesFiscales", "Index": -1, "NameInSource": "responsabilidadesFiscales", "Alias": "responsabilidadesFiscales", "Type": "System.String" }, "17": { "Name": "responsableIva", "Index": -1, "NameInSource": "responsableIva", "Alias": "responsableIva", "Type": "System.Boolean" }, "18": { "Name": "retecreeId", "Index": -1, "NameInSource": "retecreeId", "Alias": "retecreeId", "Type": "System.String" }, "19": { "Name": "sedes", "Index": -1, "NameInSource": "sedes", "Alias": "sedes", "Type": "System.String" }, "20": { "Name": "telefono", "Index": -1, "NameInSource": "telefono", "Alias": "telefono", "Type": "System.String" }, "21": { "Name": "tipoDocumento", "Index": -1, "NameInSource": "tipoDocumento", "Alias": "tipoDocumento", "Type": "System.String" }, "22": { "Name": "tipoEmpresa", "Index": -1, "NameInSource": "tipoEmpresa", "Alias": "tipoEmpresa", "Type": "System.String" }, "23": { "Name": "updatedAt", "Index": -1, "NameInSource": "updatedAt", "Alias": "updatedAt", "Type": "System.DateTime" } }, "NameInSource": "AuditoriaRelacionCartera.root_data_empresa" }, "4": { "Ident": "StiDataTableSource", "Name": "root_data_empresa_codigoActividadEconomica", "Alias": "root_data_empresa_codigoActividadEconomica", "Key": "42f8c74ce1584db3a9b0a8ef9c0cf470", "Columns": { "0": { "Name": "codigo", "Index": -1, "NameInSource": "codigo", "Alias": "codigo", "Type": "System.String" }, "1": { "Name": "descripcion", "Index": -1, "NameInSource": "descripcion", "Alias": "descripcion", "Type": "System.String" }, "2": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "3": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "AuditoriaRelacionCartera.root_data_empresa_codigoActividadEconomica" }, "5": { "Ident": "StiDataTableSource", "Name": "root_data_empresa_municipio", "Alias": "root_data_empresa_municipio", "Key": "05f20cfb07e244428c9f519afd731c20", "Columns": { "0": { "Name": "codigo", "Index": -1, "NameInSource": "codigo", "Alias": "codigo", "Type": "System.String" }, "1": { "Name": "descripcion", "Index": -1, "NameInSource": "descripcion", "Alias": "descripcion", "Type": "System.String" }, "2": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "3": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "AuditoriaRelacionCartera.root_data_empresa_municipio" }, "6": { "Ident": "StiDataTableSource", "Name": "root_data_empresa_pais", "Alias": "root_data_empresa_pais", "Key": "ccfa8b4e115a415380ef086d5ad30a5d", "Columns": { "0": { "Name": "codigo", "Index": -1, "NameInSource": "codigo", "Alias": "codigo", "Type": "System.String" }, "1": { "Name": "descripcion", "Index": -1, "NameInSource": "descripcion", "Alias": "descripcion", "Type": "System.String" }, "2": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "3": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "AuditoriaRelacionCartera.root_data_empresa_pais" }, "7": { "Ident": "StiDataTableSource", "Name": "root_data_empresa_responsabilidadesFiscales", "Alias": "root_data_empresa_responsabilidadesFiscales", "Key": "4a5b19b558ac4319b060a0b3a44390a2", "Columns": { "0": { "Name": "descripcion", "Index": -1, "NameInSource": "descripcion", "Alias": "descripcion", "Type": "System.String" }, "1": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "2": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" } }, "NameInSource": "AuditoriaRelacionCartera.root_data_empresa_responsabilidadesFiscales" }, "8": { "Ident": "StiDataTableSource", "Name": "root_data_empresa_sedes", "Alias": "root_data_empresa_sedes", "Key": "dab607050f6f4aba936aaa60b4c40019", "Columns": { "0": { "Name": "codigo", "Index": -1, "NameInSource": "codigo", "Alias": "codigo", "Type": "System.String" }, "1": { "Name": "createdAt", "Index": -1, "NameInSource": "createdAt", "Alias": "createdAt", "Type": "System.DateTime" }, "2": { "Name": "descripcion", "Index": -1, "NameInSource": "descripcion", "Alias": "descripcion", "Type": "System.String" }, "3": { "Name": "direccion", "Index": -1, "NameInSource": "direccion", "Alias": "direccion", "Type": "System.String" }, "4": { "Name": "enabled", "Index": -1, "NameInSource": "enabled", "Alias": "enabled", "Type": "System.Boolean" }, "5": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "6": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "7": { "Name": "updatedAt", "Index": -1, "NameInSource": "updatedAt", "Alias": "updatedAt", "Type": "System.DateTime" } }, "NameInSource": "AuditoriaRelacionCartera.root_data_empresa_sedes" }, "9": { "Ident": "StiDataTableSource", "Name": "root_data_empresa_tipoEmpresa", "Alias": "root_data_empresa_tipoEmpresa", "Key": "95c2c73492eb4983be6a2426e7d613b3", "Columns": { "0": { "Name": "descripcion", "Index": -1, "NameInSource": "descripcion", "Alias": "descripcion", "Type": "System.String" }, "1": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "2": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "3": { "Name": "tipo", "Index": -1, "NameInSource": "tipo", "Alias": "tipo", "Type": "System.String" } }, "NameInSource": "AuditoriaRelacionCartera.root_data_empresa_tipoEmpresa" }, "10": { "Ident": "StiDataTableSource", "Name": "root_datos", "Alias": "root_datos", "Key": "90eda4a96b524b9d9a89dea8d96d6b37", "Columns": { "0": { "Name": "clase_documento_descripcion", "Index": -1, "NameInSource": "clase_documento_descripcion", "Alias": "clase_documento_descripcion", "Type": "System.String" }, "1": { "Name": "created_at", "Index": -1, "NameInSource": "created_at", "Alias": "created_at", "Type": "System.DateTime" }, "2": { "Name": "descripcion", "Index": -1, "NameInSource": "descripcion", "Alias": "descripcion", "Type": "System.String" }, "3": { "Name": "doc_referencia", "Index": -1, "NameInSource": "doc_referencia", "Alias": "doc_referencia", "Type": "System.String" }, "4": { "Name": "establecimiento_comercio_codigo", "Index": -1, "NameInSource": "establecimiento_comercio_codigo", "Alias": "establecimiento_comercio_codigo", "Type": "System.String" }, "5": { "Name": "establecimiento_comercio_nombre_comercial", "Index": -1, "NameInSource": "establecimiento_comercio_nombre_comercial", "Alias": "establecimiento_comercio_nombre_comercial", "Type": "System.String" }, "6": { "Name": "fecha_elaboracion", "Index": -1, "NameInSource": "fecha_elaboracion", "Alias": "fecha_elaboracion", "Type": "System.DateTime" }, "7": { "Name": "municipio_descripcion", "Index": -1, "NameInSource": "municipio_descripcion", "Alias": "municipio_descripcion", "Type": "System.String" }, "8": { "Name": "numero_documento", "Index": -1, "NameInSource": "numero_documento", "Alias": "numero_documento", "Type": "System.String" }, "9": { "Name": "puc_id", "Index": -1, "NameInSource": "puc_id", "Alias": "puc_id", "Type": "System.String" }, "10": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "11": { "Name": "tercero_apellido1", "Index": -1, "NameInSource": "tercero_apellido1", "Alias": "tercero_apellido1", "Type": "System.String" }, "12": { "Name": "tercero_apellido2", "Index": -1, "NameInSource": "tercero_apellido2", "Alias": "tercero_apellido2", "Type": "System.String" }, "13": { "Name": "tercero_direccion", "Index": -1, "NameInSource": "tercero_direccion", "Alias": "tercero_direccion", "Type": "System.String" }, "14": { "Name": "tercero_email", "Index": -1, "NameInSource": "tercero_email", "Alias": "tercero_email", "Type": "System.String" }, "15": { "Name": "tercero_id", "Index": -1, "NameInSource": "tercero_id", "Alias": "tercero_id", "Type": "System.String" }, "16": { "Name": "tercero_n_documento", "Index": -1, "NameInSource": "tercero_n_documento", "Alias": "tercero_n_documento", "Type": "System.String" }, "17": { "Name": "tercero_nombre1", "Index": -1, "NameInSource": "tercero_nombre1", "Alias": "tercero_nombre1", "Type": "System.String" }, "18": { "Name": "tercero_nombre2", "Index": -1, "NameInSource": "tercero_nombre2", "Alias": "tercero_nombre2", "Type": "System.String" }, "19": { "Name": "tercero_razon_social", "Index": -1, "NameInSource": "tercero_razon_social", "Alias": "tercero_razon_social", "Type": "System.String" }, "20": { "Name": "tercero_telefono", "Index": -1, "NameInSource": "tercero_telefono", "Alias": "tercero_telefono", "Type": "System.String" }, "21": { "Name": "valor_credito", "Index": -1, "NameInSource": "valor_credito", "Alias": "valor_credito", "Type": "System.Double" }, "22": { "Name": "valor_debito", "Index": -1, "NameInSource": "valor_debito", "Alias": "valor_debito", "Type": "System.Double" }, "23": { "Name": "vencimiento", "Index": -1, "NameInSource": "vencimiento", "Alias": "vencimiento", "Type": "System.DateTime" }, "24": { "Name": "vendedor_codigo", "Index": -1, "NameInSource": "vendedor_codigo", "Alias": "vendedor_codigo", "Type": "System.String" }, "25": { "Name": "zona_codigo", "Index": -1, "NameInSource": "zona_codigo", "Alias": "zona_codigo", "Type": "System.String" }, "26": { "Name": "Saldo_referencia", "Index": -1, "NameInSource": "Column", "Alias": "Saldo_referencia", "Type": "System.Double", "Ident": "Calc", "Expression": "root_datos.valor_debito-root_datos.valor_credito" } }, "NameInSource": "AuditoriaRelacionCartera.root_datos" }, "11": { "Ident": "StiDataTableSource", "Name": "root_filtros", "Alias": "root_filtros", "Key": "4752915ebb764fe89c295d5c4dd28f87", "Columns": { "0": { "Name": "relationId", "Index": -1, "NameInSource": "relationId", "Alias": "relationId", "Type": "System.String" }, "1": { "Name": "value", "Index": -1, "NameInSource": "value", "Alias": "value", "Type": "System.String" } }, "NameInSource": "AuditoriaRelacionCartera.root_filtros" } }, "Databases": { "0": { "Ident": "StiJsonDatabase", "Name": "AuditoriaRelacionCartera", "Alias": "AuditoriaRelacionCartera", "CastToColumnType": "CastToColumnType", "PathData": "resource://AuditoriaRelacionCartera", "HeadersString": "" } }, "Relations": { "0": { "Name": "root", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "cabeceras" }, "NameInSource": "root_cabeceras", "Alias": "root", "JoinType": "Left" }, "1": { "Name": "root", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "datos" }, "NameInSource": "root_datos", "Alias": "root", "JoinType": "Left" }, "2": { "Name": "root", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "cabeceras" }, "NameInSource": "root_cabeceras", "Alias": "root", "JoinType": "Left", "ParentSource": "root", "ChildSource": "root_cabeceras" }, "3": { "Name": "root", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "data" }, "NameInSource": "root_data", "Alias": "root", "JoinType": "Left", "ParentSource": "root", "ChildSource": "root_data" }, "4": { "Name": "root_data", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "empresa" }, "NameInSource": "root_data_empresa", "Alias": "root_data", "JoinType": "Left", "ParentSource": "root_data", "ChildSource": "root_data_empresa" }, "5": { "Name": "root_data_empresa", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "codigoActividadEconomica" }, "NameInSource": "root_data_empresa_codigoActividadEconomica", "Alias": "root_data_empresa", "JoinType": "Left", "ParentSource": "root_data_empresa", "ChildSource": "root_data_empresa_codigoActividadEconomica" }, "6": { "Name": "root_data_empresa", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "municipio" }, "NameInSource": "root_data_empresa_municipio", "Alias": "root_data_empresa", "JoinType": "Left", "ParentSource": "root_data_empresa", "ChildSource": "root_data_empresa_municipio" }, "7": { "Name": "root_data_empresa", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "pais" }, "NameInSource": "root_data_empresa_pais", "Alias": "root_data_empresa", "JoinType": "Left", "ParentSource": "root_data_empresa", "ChildSource": "root_data_empresa_pais" }, "8": { "Name": "root_data_empresa", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "responsabilidadesFiscales" }, "NameInSource": "root_data_empresa_responsabilidadesFiscales", "Alias": "root_data_empresa", "JoinType": "Left", "ParentSource": "root_data_empresa", "ChildSource": "root_data_empresa_responsabilidadesFiscales" }, "9": { "Name": "root_data_empresa", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "sedes" }, "NameInSource": "root_data_empresa_sedes", "Alias": "root_data_empresa", "JoinType": "Left", "ParentSource": "root_data_empresa", "ChildSource": "root_data_empresa_sedes" }, "10": { "Name": "root_data_empresa", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "tipoEmpresa" }, "NameInSource": "root_data_empresa_tipoEmpresa", "Alias": "root_data_empresa", "JoinType": "Left", "ParentSource": "root_data_empresa", "ChildSource": "root_data_empresa_tipoEmpresa" }, "11": { "Name": "root", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "datos" }, "NameInSource": "root_datos", "Alias": "root", "JoinType": "Left", "ParentSource": "root", "ChildSource": "root_datos" }, "12": { "Name": "root", "ChildColumns": { "0": "relationId" }, "ParentColumns": { "0": "filtros" }, "NameInSource": "root_filtros", "Alias": "root", "JoinType": "Left", "ParentSource": "root", "ChildSource": "root_filtros" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "940f623f62eafc53a50dedf8d680a862", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageHeaderBand", "Name": "PageHeaderBand1", "Guid": "e0f9737de5ed1b752dbe0f09cdba4b75", "ClientRectangle": "0,0.4,19.6,3.8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text28", "Guid": "0a21bcbc4d9a72356d2c26ca7fcfc53d", "ClientRectangle": "14.9,1.7,4.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Pagina {PageNumber} De {TotalPageCount}" }, "VertAlignment": "Center", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text1", "Guid": "72445df23ae1726506c6eee99cf79cd9", "ClientRectangle": "0.3,0,14.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{root_data_empresa.razonSocial}" }, "Font": "Tahoma;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text2", "Guid": "f5caec2b66a3bb565a7e46fd8c66eded", "ClientRectangle": "5.3,0.96,9.2,1.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{ReportName.ToUpper()}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Tahoma;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text3", "Guid": "e2b800dfadb4d2e71bf92a254276b5ab", "ClientRectangle": "14.9,1,4.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Fecha y hora: {root_data.fecha} {root_data.hora}" }, "VertAlignment": "Center", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text4", "Guid": "5b91a1d4d773849a6c6c520580b3f8c9", "ClientRectangle": "0.3,0.6,4.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{root_data_empresa.tipoDocumento}. {root_data_empresa.numeroDocumento}" }, "VertAlignment": "Center", "Font": "Tahoma;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text6", "Guid": "71067da24f0da1924b13463eea940177", "ClientRectangle": "8.8,2.6,1.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Fecha:" }, "VertAlignment": "Bottom", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text7", "Guid": "f122836fefdb2bfaa387da6171fe8d54", "ClientRectangle": "10.4,2.6,1.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Vencimiento:" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text11", "Guid": "c3b3ae6c8cffa8b97c0284731dd18b62", "ClientRectangle": "13,2.4,1.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Valor \r\nDebito:" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text47", "Guid": "8c3b8aac494bff7d1c6e910dfdad08c4", "ClientRectangle": "0.2,3.36,2.13,0.38", "Interaction": { "Ident": "StiInteraction" }, "Expressions": { "0": { "Name": "Font" } }, "Text": { "Value": "Filtros\r\n" }, "Font": ";10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text25", "Guid": "10726daccab3caf7827162fc35db4c63", "ClientRectangle": "15.2,2.4,1.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Valor \r\nCredito:" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "10": { "Ident": "StiText", "Name": "Text12", "Guid": "78924acfdf585f5a4d2a88e54a06a9f6", "ClientRectangle": "17.6,2.4,1.8,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Saldo:" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "11": { "Ident": "StiText", "Name": "Text5", "Guid": "a249c1527ecb6d11729babd62341ef74", "ClientRectangle": "4.8,2.6,2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "# Dcoumento:" }, "VertAlignment": "Bottom", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "12": { "Ident": "StiText", "Name": "Text48", "Guid": "72d722805cd6c20bced2850c1edd23c3", "ClientRectangle": "6.8,2.6,2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "# Referencia:" }, "VertAlignment": "Bottom", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "13": { "Ident": "StiText", "Name": "Text8", "Guid": "adf91f56167bc127e5bff9d8fd88f1bc", "ClientRectangle": "0.2,2.4,2,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Tipo\r\nDcoumento:" }, "VertAlignment": "Bottom", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "14": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive2", "Guid": "dc8a0a31c4ceac454bb168768ab6bf05", "ClientRectangle": "0.63,3.23,18.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "15": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive1", "ClientRectangle": "5.3,0.85,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "7786dfed6f3d48ba91cb23719ec4e62d" }, "16": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive1", "ClientRectangle": "14.7,2.28,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "7786dfed6f3d48ba91cb23719ec4e62d" } } }, "1": { "Ident": "StiPageFooterBand", "Name": "PageFooterBand1", "Guid": "50e3be539af41d1264b222bd947f9445", "ClientRectangle": "0,24.7,19.6,1.2", "Interaction": { "Ident": "StiInteraction" }, "CanShrink": true, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text46", "Guid": "8c5e64ef51f31243c1e9f171e4b8ef9f", "ClientRectangle": "0,0.87,9.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Generado e impreso por: ERPCLOUD SOFTBUSINESS | www.softbusiness.com.co" }, "HorAlignment": "Right", "VertAlignment": "Bottom", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive1", "ClientRectangle": "0,0.7,19.6,0.0254", "Interaction": { "Ident": "StiInteraction" }, "Color": "0,112,192", "Size": 2.0, "StartCap": ";;;", "EndCap": ";;;" } } }, "2": { "Ident": "StiTable", "Name": "Table1", "ClientRectangle": "0,5,19.6,0.53", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;None;;;;solid:0,0,0", "Brush": "solid:", "Components": { "0": { "Ident": "StiTableCell", "Name": "Table1_Cell1", "ClientRectangle": "0,0,19.58,0.53", "Restrictions": "AllowMove, AllowSelect, AllowChange", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{root_filtros.value}" }, "Border": "All;105,105,105;;None;;;;solid:105,105,105", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn", "ID": 0 } }, "MinHeight": 0.2, "DataSourceName": "root_filtros", "AutoWidth": "Table", "RowCount": 1, "ColumnCount": 1, "NumberID": 25 }, "3": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand1", "ClientRectangle": "0,6.33,19.6,1.2", "Enabled": false, "Interaction": { "Ident": "StiBandInteraction" }, "Expressions": { "0": { "Name": "Enabled", "Expression": "{Totals.Sum(GroupHeaderBand1, root_datos.Saldo_referencia) != 0}" } }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text13", "Guid": "371e16c2e4b26d1036fbfc24a1e044f4", "ClientRectangle": "0.2,0.07,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Tercero:" }, "VertAlignment": "Center", "Font": "Tahoma;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text14", "Guid": "bc6ea98626574946fb8dcc82eefa0cf0", "ClientRectangle": "2.4,0.07,10.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{root_datos.tercero_n_documento+\" \"+root_datos.tercero_razon_social}" }, "VertAlignment": "Center", "Font": "Tahoma;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text15", "Guid": "ad56da2585e4d86d9f0651cbed1a1bff", "ClientRectangle": "0.4,0.47,1.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Direccion:" }, "VertAlignment": "Center", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text16", "Guid": "113d5638c10f920af981ace5f76d0c2f", "ClientRectangle": "13.8,0.07,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "expression 1" }, "VertAlignment": "Center", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text20", "Guid": "ab99949ff43ae2d150795bac48756d0f", "ClientRectangle": "16.6,0.07,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,root_datos.Saldo_referencia) != 0}" }, "VertAlignment": "Center", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text17", "Guid": "1633243b3fd7f3bf0ff126c772842521", "ClientRectangle": "2.4,0.47,10,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{root_datos.tercero_direccion}" }, "VertAlignment": "Center", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text35", "Guid": "6ebdc92ed7664666897de8ad5cb937cd", "ClientRectangle": "16.4,0.67,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,root_datos.Saldo_referencia)}" }, "VertAlignment": "Center", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text37", "Guid": "56dcfdf4d3bb41b49977cb9db74c145c", "ClientRectangle": "13.8,0.67,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "expression 2" }, "VertAlignment": "Center", "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" } }, "Condition": { "Value": "{root_datos.tercero_n_documento}" } }, "4": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand2", "ClientRectangle": "0,8.33,19.6,0.4", "Enabled": false, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Condition": { "Value": "{root_datos.doc_referencia}" } }, "5": { "Ident": "StiDataBand", "Name": "DataBand1", "ClientRectangle": "0,9.53,19.6,0.4", "Enabled": false, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "DataSourceName": "root_datos", "DataRelationName": null }, "6": { "Ident": "StiGroupFooterBand", "Name": "GroupFooterBand2", "ClientRectangle": "0,10.73,19.6,0.4", "Enabled": false, "Interaction": { "Ident": "StiInteraction" }, "Expressions": { "0": { "Name": "Enabled", "Expression": "Sum(DataBand1,root_datos.Saldo_referencia) != 0" } }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text22", "Guid": "9a4f1a86ba1141048b083533196ff47b", "ClientRectangle": "0,0.07,4.2,0.3", "Interaction": { "Ident": "StiInteraction" }, "CanShrink": true, "CanGrow": true, "Text": { "Value": "{root_datos.clase_documento_descripcion}" }, "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "Text23", "Guid": "ba36137ac1fe44a9be50bee8c72b15f4", "ClientRectangle": "4.6,0.07,2,0.3", "Interaction": { "Ident": "StiInteraction" }, "CanGrow": true, "Text": { "Value": "{root_datos.numero_documento}" }, "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text24", "Guid": "171fd72aab7548d0b41f00d23d618799", "ClientRectangle": "6.6,0.07,2,0.3", "Interaction": { "Ident": "StiInteraction" }, "CanShrink": true, "CanGrow": true, "Text": { "Value": "{root_datos.doc_referencia}" }, "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text26", "Guid": "58fd0cf5cafe44b5972d481f8fe191c0", "ClientRectangle": "8.8,0.07,1.8,0.3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{root_datos.fecha_elaboracion}" }, "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiDateFormatService", "StringFormat": "dd/MM/yyyy" }, "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text27", "Guid": "0ecb609ee06c4cac8f85473c474a122b", "ClientRectangle": "10.4,0.07,1.8,0.3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,root_datos.Saldo_referencia) != 0}" }, "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text32", "Guid": "32e01e1292dd4097b469c368dc60714b", "ClientRectangle": "17.2,0.1,2.6,0.3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,root_datos.Saldo_referencia)}" }, "HorAlignment": "Right", "Font": "Tahoma;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text33", "Guid": "e4bf84b46f3341c6a2ea54aa78dfa659", "ClientRectangle": "14.6,0.07,2.6,0.3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,root_datos.valor_credito)}" }, "HorAlignment": "Right", "Font": "Tahoma;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text34", "Guid": "fc8989edba9c4762991e77bda4ae4f8e", "ClientRectangle": "12.2,0.07,2.6,0.3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,root_datos.valor_debito)}" }, "HorAlignment": "Right", "Font": "Tahoma;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" } } }, "7": { "Ident": "StiGroupFooterBand", "Name": "GroupFooterBand1", "ClientRectangle": "0,11.93,19.6,0.4", "Enabled": false, "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:" }, "8": { "Ident": "StiReportSummaryBand", "Name": "ReportSummaryBand1", "ClientRectangle": "0,13.13,19.6,0.8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text38", "Guid": "d371dba78a682aeb3711efcdf8cc6c75", "ClientRectangle": "0.4,0.27,2.8,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total General" }, "Font": "Tahoma;;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text36", "Guid": "164ff3533121dc48ff5ce54be02d33a3", "ClientRectangle": "17,0.3,2.6,0.3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,root_datos.saldo_referencia)}" }, "HorAlignment": "Right", "Font": "Tahoma;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text41", "Guid": "6605bec89f1fd87a15351968238a6395", "ClientRectangle": "14.6,0.27,2.6,0.3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,root_datos.valor_credito)}" }, "HorAlignment": "Right", "Font": "Tahoma;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text42", "Guid": "3990c46bbb17aeb519b085130714850b", "ClientRectangle": "12.4,0.27,2.6,0.3", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Sum(DataBand1,root_datos.valor_debito)}" }, "HorAlignment": "Right", "Font": "Tahoma;;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "DecimalSeparator": ",", "DecimalDigits": 0, "GroupSeparator": ".", "State": "DecimalDigits" }, "Type": "Expression" }, "4": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive4", "Guid": "0cf518c981cff6bebc1c31feb4861afa", "ClientRectangle": "0.4,0.07,18.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } } }, "9": { "Ident": "StiRectanglePrimitive", "Name": "RectanglePrimitive1", "Guid": "7786dfed6f3d48ba91cb23719ec4e62d", "ClientRectangle": "5.3,1.25,9.4,1.43", "Interaction": { "Ident": "StiInteraction" } } }, "PaperSize": "Letter", "PageWidth": 21.6, "PageHeight": 27.9, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1.0, "Right": 1.0, "Top": 1.0, "Bottom": 1.0 }, "ReportUnit": { "Ident": "StiCentimetersUnit" } } } }