S","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084139","BOOKS_PARENT_ID":"2340388000068084139","Batch":"65"}, {"Fecha_Gasto":"11-Feb-25","Fuente":"GASTO","Total":"94.89","Total_FCY":"94.89","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084164","BOOKS_PARENT_ID":"2340388000068084164","Batch":"65"}, {"Fecha_Gasto":"11-Feb-25","Fuente":"GASTO","Total":"94.89","Total_FCY":"94.89","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084164","BOOKS_PARENT_ID":"2340388000068084164","Batch":"65"}, {"Fecha_Gasto":"11-Feb-25","Fuente":"GASTO","Total":"170.43","Total_FCY":"170.43","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084189","BOOKS_PARENT_ID":"2340388000068084189","Batch":"65"}, {"Fecha_Gasto":"11-Feb-25","Fuente":"GASTO","Total":"170.43","Total_FCY":"170.43","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084189","BOOKS_PARENT_ID":"2340388000068084189","Batch":"65"}, {"Fecha_Gasto":"11-Feb-25","Fuente":"GASTO","Total":"252.07","Total_FCY":"252.07","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084240","BOOKS_PARENT_ID":"2340388000068084240","Batch":"65"}, {"Fecha_Gasto":"11-Feb-25","Fuente":"GASTO","Total":"252.07","Total_FCY":"252.07","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084240","BOOKS_PARENT_ID":"2340388000068084240","Batch":"65"}, {"Fecha_Gasto":"11-Feb-25","Fuente":"GASTO","Total":"5698.49","Total_FCY":"5698.49","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084273","BOOKS_PARENT_ID":"2340388000068084273","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"588.42","Total_FCY":"588.42","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0475","Abogado":"4069147000000995149","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0475 - LPVR- LUIS PABLO VELAZQUEZ RABASA","BOOKS_ID":"2340388000068084304","BOOKS_PARENT_ID":"2340388000068084304","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"57.35","Total_FCY":"57.35","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084329","BOOKS_PARENT_ID":"2340388000068084329","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"57.35","Total_FCY":"57.35","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084329","BOOKS_PARENT_ID":"2340388000068084329","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"206.33","Total_FCY":"206.33","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0475","Abogado":"4069147000000995149","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0475 - LPVR- LUIS PABLO VELAZQUEZ RABASA","BOOKS_ID":"2340388000068084362","BOOKS_PARENT_ID":"2340388000068084362","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"159.53","Total_FCY":"159.53","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084387","BOOKS_PARENT_ID":"2340388000068084387","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"159.53","Total_FCY":"159.53","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084387","BOOKS_PARENT_ID":"2340388000068084387","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"16.78","Total_FCY":"16.78","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084420","BOOKS_PARENT_ID":"2340388000068084420","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"16.78","Total_FCY":"16.78","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084420","BOOKS_PARENT_ID":"2340388000068084420","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"188.15","Total_FCY":"188.15","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084445","BOOKS_PARENT_ID":"2340388000068084445","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"188.15","Total_FCY":"188.15","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084445","BOOKS_PARENT_ID":"2340388000068084445","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"646.68","Total_FCY":"646.68","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084478","BOOKS_PARENT_ID":"2340388000068084478","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"69.07","Total_FCY":"69.07","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084509","BOOKS_PARENT_ID":"2340388000068084509","Batch":"65"}, {"Fecha_Gasto":"12-Feb-25","Fuente":"GASTO","Total":"69.07","Total_FCY":"69.07","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084509","BOOKS_PARENT_ID":"2340388000068084509","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"742.72","Total_FCY":"742.72","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084542","BOOKS_PARENT_ID":"2340388000068084542","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"742.72","Total_FCY":"742.72","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084542","BOOKS_PARENT_ID":"2340388000068084542","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"9.9","Total_FCY":"9.9","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084567","BOOKS_PARENT_ID":"2340388000068084567","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"325.65","Total_FCY":"325.65","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084614","BOOKS_PARENT_ID":"2340388000068084614","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"325.65","Total_FCY":"325.65","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084614","BOOKS_PARENT_ID":"2340388000068084614","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"263.58","Total_FCY":"263.58","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084639","BOOKS_PARENT_ID":"2340388000068084639","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"2595.78","Total_FCY":"2595.78","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084662","BOOKS_PARENT_ID":"2340388000068084662","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"21.6","Total_FCY":"21.6","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084701","BOOKS_PARENT_ID":"2340388000068084701","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"21.81","Total_FCY":"21.81","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084724","BOOKS_PARENT_ID":"2340388000068084724","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"148.87","Total_FCY":"148.87","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084755","BOOKS_PARENT_ID":"2340388000068084755","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"209.06","Total_FCY":"209.06","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084778","BOOKS_PARENT_ID":"2340388000068084778","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"206.65","Total_FCY":"206.65","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084809","BOOKS_PARENT_ID":"2340388000068084809","Batch":"65"}, {"Fecha_Gasto":"13-Feb-25","Fuente":"GASTO","Total":"206.65","Total_FCY":"206.65","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084809","BOOKS_PARENT_ID":"2340388000068084809","Batch":"65"}, {"Fecha_Gasto":"14-Feb-25","Fuente":"GASTO","Total":"43.41","Total_FCY":"43.41","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084834","BOOKS_PARENT_ID":"2340388000068084834","Batch":"65"}, {"Fecha_Gasto":"14-Feb-25","Fuente":"GASTO","Total":"798.39","Total_FCY":"798.39","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084857","BOOKS_PARENT_ID":"2340388000068084857","Batch":"65"}, {"Fecha_Gasto":"15-Feb-25","Fuente":"GASTO","Total":"583.27","Total_FCY":"583.27","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084880","BOOKS_PARENT_ID":"2340388000068084880","Batch":"65"}, {"Fecha_Gasto":"15-Feb-25","Fuente":"GASTO","Total":"583.27","Total_FCY":"583.27","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068084880","BOOKS_PARENT_ID":"2340388000068084880","Batch":"65"}, {"Fecha_Gasto":"15-Feb-25","Fuente":"GASTO","Total":"345.07","Total_FCY":"345.07","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084905","BOOKS_PARENT_ID":"2340388000068084905","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"2.05","Total_FCY":"2.05","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084928","BOOKS_PARENT_ID":"2340388000068084928","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"4.96","Total_FCY":"4.96","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084951","BOOKS_PARENT_ID":"2340388000068084951","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"3758.2","Total_FCY":"3758.2","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084974","BOOKS_PARENT_ID":"2340388000068084974","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"24","Total_FCY":"24","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068084997","BOOKS_PARENT_ID":"2340388000068084997","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"71","Total_FCY":"71","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068089020","BOOKS_PARENT_ID":"2340388000068089020","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"1350","Total_FCY":"1350","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089066","BOOKS_PARENT_ID":"2340388000068089066","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"1350","Total_FCY":"1350","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089066","BOOKS_PARENT_ID":"2340388000068089066","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"400.88","Total_FCY":"400.88","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089091","BOOKS_PARENT_ID":"2340388000068089091","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"400.88","Total_FCY":"400.88","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089091","BOOKS_PARENT_ID":"2340388000068089091","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"71.38","Total_FCY":"71.38","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089116","BOOKS_PARENT_ID":"2340388000068089116","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"71.38","Total_FCY":"71.38","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089116","BOOKS_PARENT_ID":"2340388000068089116","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"105.51","Total_FCY":"105.51","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089141","BOOKS_PARENT_ID":"2340388000068089141","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"105.51","Total_FCY":"105.51","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089141","BOOKS_PARENT_ID":"2340388000068089141","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"158.22","Total_FCY":"158.22","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089166","BOOKS_PARENT_ID":"2340388000068089166","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"158.22","Total_FCY":"158.22","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089166","BOOKS_PARENT_ID":"2340388000068089166","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"212.48","Total_FCY":"212.48","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089191","BOOKS_PARENT_ID":"2340388000068089191","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"212.48","Total_FCY":"212.48","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089191","BOOKS_PARENT_ID":"2340388000068089191","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"239.66","Total_FCY":"239.66","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089216","BOOKS_PARENT_ID":"2340388000068089216","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"239.66","Total_FCY":"239.66","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089216","BOOKS_PARENT_ID":"2340388000068089216","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"443.62","Total_FCY":"443.62","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089241","BOOKS_PARENT_ID":"2340388000068089241","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"443.62","Total_FCY":"443.62","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089241","BOOKS_PARENT_ID":"2340388000068089241","Batch":"65"}, {"Fecha_Gasto":"17-Feb-25","Fuente":"GASTO","Total":"165.99","Total_FCY":"165.99","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068089266","BOOKS_PARENT_ID":"2340388000068089266","Batch":"65"}, {"Fecha_Gasto":"18-Feb-25","Fuente":"GASTO","Total":"159.5","Total_FCY":"159.5","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089289","BOOKS_PARENT_ID":"2340388000068089289","Batch":"65"}, {"Fecha_Gasto":"18-Feb-25","Fuente":"GASTO","Total":"159.5","Total_FCY":"159.5","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089289","BOOKS_PARENT_ID":"2340388000068089289","Batch":"65"}, {"Fecha_Gasto":"18-Feb-25","Fuente":"GASTO","Total":"167.54","Total_FCY":"167.54","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089314","BOOKS_PARENT_ID":"2340388000068089314","Batch":"65"}, {"Fecha_Gasto":"18-Feb-25","Fuente":"GASTO","Total":"167.54","Total_FCY":"167.54","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089314","BOOKS_PARENT_ID":"2340388000068089314","Batch":"65"}, {"Fecha_Gasto":"19-Feb-25","Fuente":"GASTO","Total":"199.77","Total_FCY":"199.77","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089339","BOOKS_PARENT_ID":"2340388000068089339","Batch":"65"}, {"Fecha_Gasto":"19-Feb-25","Fuente":"GASTO","Total":"199.77","Total_FCY":"199.77","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089339","BOOKS_PARENT_ID":"2340388000068089339","Batch":"65"}, {"Fecha_Gasto":"20-Feb-25","Fuente":"GASTO","Total":"273.5","Total_FCY":"273.5","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089364","BOOKS_PARENT_ID":"2340388000068089364","Batch":"65"}, {"Fecha_Gasto":"20-Feb-25","Fuente":"GASTO","Total":"273.5","Total_FCY":"273.5","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089364","BOOKS_PARENT_ID":"2340388000068089364","Batch":"65"}, {"Fecha_Gasto":"20-Feb-25","Fuente":"GASTO","Total":"12.56","Total_FCY":"12.56","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068089389","BOOKS_PARENT_ID":"2340388000068089389","Batch":"65"}, {"Fecha_Gasto":"20-Feb-25","Fuente":"GASTO","Total":"12.78","Total_FCY":"12.78","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068089412","BOOKS_PARENT_ID":"2340388000068089412","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"299","Total_FCY":"299","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068089435","BOOKS_PARENT_ID":"2340388000068089435","Batch":"65"}, {"Fecha_Gasto":"20-Feb-25","Fuente":"GASTO","Total":"234.04","Total_FCY":"234.04","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089458","BOOKS_PARENT_ID":"2340388000068089458","Batch":"65"}, {"Fecha_Gasto":"20-Feb-25","Fuente":"GASTO","Total":"234.04","Total_FCY":"234.04","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089458","BOOKS_PARENT_ID":"2340388000068089458","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"21.85","Total_FCY":"21.85","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089483","BOOKS_PARENT_ID":"2340388000068089483","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"21.85","Total_FCY":"21.85","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089483","BOOKS_PARENT_ID":"2340388000068089483","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"73.36","Total_FCY":"73.36","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089508","BOOKS_PARENT_ID":"2340388000068089508","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"73.36","Total_FCY":"73.36","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089508","BOOKS_PARENT_ID":"2340388000068089508","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"147.46","Total_FCY":"147.46","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089562","BOOKS_PARENT_ID":"2340388000068089562","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"147.46","Total_FCY":"147.46","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089562","BOOKS_PARENT_ID":"2340388000068089562","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"156.83","Total_FCY":"156.83","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089587","BOOKS_PARENT_ID":"2340388000068089587","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"156.83","Total_FCY":"156.83","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089587","BOOKS_PARENT_ID":"2340388000068089587","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"199.7","Total_FCY":"199.7","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089612","BOOKS_PARENT_ID":"2340388000068089612","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"199.7","Total_FCY":"199.7","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089612","BOOKS_PARENT_ID":"2340388000068089612","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"219.99","Total_FCY":"219.99","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089637","BOOKS_PARENT_ID":"2340388000068089637","Batch":"65"}, {"Fecha_Gasto":"21-Feb-25","Fuente":"GASTO","Total":"219.99","Total_FCY":"219.99","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089637","BOOKS_PARENT_ID":"2340388000068089637","Batch":"65"}, {"Fecha_Gasto":"22-Feb-25","Fuente":"GASTO","Total":"87.42","Total_FCY":"87.42","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089662","BOOKS_PARENT_ID":"2340388000068089662","Batch":"65"}, {"Fecha_Gasto":"22-Feb-25","Fuente":"GASTO","Total":"87.42","Total_FCY":"87.42","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089662","BOOKS_PARENT_ID":"2340388000068089662","Batch":"65"}, {"Fecha_Gasto":"22-Feb-25","Fuente":"GASTO","Total":"105.31","Total_FCY":"105.31","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089687","BOOKS_PARENT_ID":"2340388000068089687","Batch":"65"}, {"Fecha_Gasto":"22-Feb-25","Fuente":"GASTO","Total":"105.31","Total_FCY":"105.31","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089687","BOOKS_PARENT_ID":"2340388000068089687","Batch":"65"}, {"Fecha_Gasto":"22-Feb-25","Fuente":"GASTO","Total":"145.9","Total_FCY":"145.9","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089712","BOOKS_PARENT_ID":"2340388000068089712","Batch":"65"}, {"Fecha_Gasto":"22-Feb-25","Fuente":"GASTO","Total":"145.9","Total_FCY":"145.9","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089712","BOOKS_PARENT_ID":"2340388000068089712","Batch":"65"}, {"Fecha_Gasto":"23-Feb-25","Fuente":"GASTO","Total":"474.73","Total_FCY":"474.73","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068089742","BOOKS_PARENT_ID":"2340388000068089742","Batch":"65"}, {"Fecha_Gasto":"23-Feb-25","Fuente":"GASTO","Total":"428.5","Total_FCY":"428.5","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089767","BOOKS_PARENT_ID":"2340388000068089767","Batch":"65"}, {"Fecha_Gasto":"23-Feb-25","Fuente":"GASTO","Total":"428.5","Total_FCY":"428.5","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089767","BOOKS_PARENT_ID":"2340388000068089767","Batch":"65"}, {"Fecha_Gasto":"23-Feb-25","Fuente":"GASTO","Total":"68.25","Total_FCY":"68.25","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089797","BOOKS_PARENT_ID":"2340388000068089797","Batch":"65"}, {"Fecha_Gasto":"23-Feb-25","Fuente":"GASTO","Total":"68.25","Total_FCY":"68.25","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089797","BOOKS_PARENT_ID":"2340388000068089797","Batch":"65"}, {"Fecha_Gasto":"23-Feb-25","Fuente":"GASTO","Total":"40.36","Total_FCY":"40.36","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068089822","BOOKS_PARENT_ID":"2340388000068089822","Batch":"65"}, {"Fecha_Gasto":"23-Feb-25","Fuente":"GASTO","Total":"807.53","Total_FCY":"807.53","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068089845","BOOKS_PARENT_ID":"2340388000068089845","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"129","Total_FCY":"129","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@0004 - HLL - HEDWIG LINDNER LOPEZ","BOOKS_ID":"2340388000068089868","BOOKS_PARENT_ID":"2340388000068089868","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"2282.57","Total_FCY":"2282.57","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089891","BOOKS_PARENT_ID":"2340388000068089891","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"2282.57","Total_FCY":"2282.57","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089891","BOOKS_PARENT_ID":"2340388000068089891","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"39.16","Total_FCY":"39.16","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089916","BOOKS_PARENT_ID":"2340388000068089916","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"39.16","Total_FCY":"39.16","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089916","BOOKS_PARENT_ID":"2340388000068089916","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"58.1","Total_FCY":"58.1","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089941","BOOKS_PARENT_ID":"2340388000068089941","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"58.1","Total_FCY":"58.1","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089941","BOOKS_PARENT_ID":"2340388000068089941","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"91.07","Total_FCY":"91.07","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089998","BOOKS_PARENT_ID":"2340388000068089998","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"91.07","Total_FCY":"91.07","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068089998","BOOKS_PARENT_ID":"2340388000068089998","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"211.59","Total_FCY":"211.59","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090023","BOOKS_PARENT_ID":"2340388000068090023","Batch":"65"}, {"Fecha_Gasto":"24-Feb-25","Fuente":"GASTO","Total":"211.59","Total_FCY":"211.59","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090023","BOOKS_PARENT_ID":"2340388000068090023","Batch":"65"}, {"Fecha_Gasto":"25-Feb-25","Fuente":"GASTO","Total":"157.46","Total_FCY":"157.46","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090048","BOOKS_PARENT_ID":"2340388000068090048","Batch":"65"}, {"Fecha_Gasto":"25-Feb-25","Fuente":"GASTO","Total":"157.46","Total_FCY":"157.46","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090048","BOOKS_PARENT_ID":"2340388000068090048","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"34.38","Total_FCY":"34.38","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090073","BOOKS_PARENT_ID":"2340388000068090073","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"34.38","Total_FCY":"34.38","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090073","BOOKS_PARENT_ID":"2340388000068090073","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"47.02","Total_FCY":"47.02","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090098","BOOKS_PARENT_ID":"2340388000068090098","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"47.02","Total_FCY":"47.02","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090098","BOOKS_PARENT_ID":"2340388000068090098","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"131.45","Total_FCY":"131.45","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090123","BOOKS_PARENT_ID":"2340388000068090123","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"131.45","Total_FCY":"131.45","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090123","BOOKS_PARENT_ID":"2340388000068090123","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"143.98","Total_FCY":"143.98","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090148","BOOKS_PARENT_ID":"2340388000068090148","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"143.98","Total_FCY":"143.98","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090148","BOOKS_PARENT_ID":"2340388000068090148","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"213.93","Total_FCY":"213.93","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090173","BOOKS_PARENT_ID":"2340388000068090173","Batch":"65"}, {"Fecha_Gasto":"26-Feb-25","Fuente":"GASTO","Total":"213.93","Total_FCY":"213.93","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090173","BOOKS_PARENT_ID":"2340388000068090173","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"215.77","Total_FCY":"215.77","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090223","BOOKS_PARENT_ID":"2340388000068090223","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"215.77","Total_FCY":"215.77","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090223","BOOKS_PARENT_ID":"2340388000068090223","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"431.53","Total_FCY":"431.53","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090248","BOOKS_PARENT_ID":"2340388000068090248","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"431.53","Total_FCY":"431.53","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090248","BOOKS_PARENT_ID":"2340388000068090248","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"647.3","Total_FCY":"647.3","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090273","BOOKS_PARENT_ID":"2340388000068090273","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"647.3","Total_FCY":"647.3","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090273","BOOKS_PARENT_ID":"2340388000068090273","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"141.9","Total_FCY":"141.9","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090298","BOOKS_PARENT_ID":"2340388000068090298","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"141.9","Total_FCY":"141.9","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090298","BOOKS_PARENT_ID":"2340388000068090298","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"23.56","Total_FCY":"23.56","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0004","Abogado":"4069147000000994793","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBLES","Centro_de_Costo":"@GASTOS - PLL- PABLO LINDNER","BOOKS_ID":"2340388000068090323","BOOKS_PARENT_ID":"2340388000068090323","Batch":"65"}, {"Fecha_Gasto":"27-Feb-25","Fuente":"GASTO","Total":"23.56","Total_FCY":"23.56","Moneda":"MXN","Tipo_de_Cambio":"1.00","TKPR":"0001","Abogado":"4069147000000995589","Cuenta_Contable":"600-01-000 ANTICIPOS DE REMANENTES DISTRIBUIBL "400", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Anio de vigencia."); $Resultado = json_encode($j_array); // echo $Resultado; return; } if($mesCata == "") { $j_array = array('code' => "400", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Mes de vigencia."); $Resultado = json_encode($j_array); // echo $Resultado; return; } if($tipoEnvio == "") { $j_array = array('code' => "400", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Tipo de Envio."); $Resultado = json_encode($j_array); // echo $Resultado; return; } if($csvFileName == "") { $j_array = array('code' => "400", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Nombre del Archivo CSV a procesar."); $Resultado = json_encode($j_array); // echo $Resultado; return $Resultado; } if($organi_id_ZB == "") { $j_array = array('code' => "306", "message" => "ERROR - [wsBalanzaComp_v14] Parametros incompletos para el Servicio Web, faltan el Organization ID de Books"); $Resultado = json_encode($j_array); // echo $Resultado; return $Resultado; } $dirBase = realpath("../"); ### DEFINICIÓN DE CONSTANTES ################################################### $SendaCVS = "archs_csv/"; $SendaXML = "archs_xml/"; $SendaZIP = "archs_zip/"; #---------------------------------------------------------------- # Creamos la conexión a la base de datos #---------------------------------------------------------------- $conn = mysqli_connect("127.0.0.1", "aptuslegal", "#Aptus2021#", "vendorbills"); if (!$conn) { echo "Error: No se pudo conectar a MySQL." . PHP_EOL; echo "errno de depuración: " . mysqli_connect_errno() . PHP_EOL; exit; } #---------------------------------------------------------------- # Traemos los valores de conexión utilizando el organizationId #---------------------------------------------------------------- $sql = 'SELECT * FROM conndetails WHERE organization_id = ' . $organi_id_ZB; if($result = $conn->query($sql)) { $row = $result->fetch_assoc(); } else exit('No se ejecuto la consulta'); #---------------------------------------------------------------- # Cerramos la conexión #---------------------------------------------------------------- mysqli_close($conn); #---------------------------------------------------------------- # Variables para Zoho Workdrive #---------------------------------------------------------------- $wdrv_parent_id = $row['zworkdrvbalcom_id']; $woa_RefreshToken = $row['zworkdrv_rtoken']; $woa_ClientId = $row['zworkdrvclient_id']; $woa_ClientSecret = $row['zworkdrvclient_secret']; $woa_RedirectUri = $row['RedirectUri']; $woa_AuthUrl = 'https://accounts.zoho.com/oauth/v2/token'; $woa_GrantType = "refresh_token"; #---------------------------------------------------------------- # RFC de la Organización #---------------------------------------------------------------- $regFeCa = $row['rfc']; #== Creación de la variable de tipo DOM, aquí se conforma el XML a timbrar posteriormente. $xml = new DOMdocument('1.0', 'UTF-8'); $root = $xml->createElement("BCE:Balanza"); $root = $xml->appendChild($root); #== Apertura, lectura y conversión de CSV a JSON. $fileName = $SendaCVS.$csvFileName; $csvToJson = csvToJson($fileName); $arrayJson = json_decode( $csvToJson, true ); // Invertimos el orden del arreglo para los calculos. $jsonArray = array_reverse($arrayJson, true); #== Se procesan las cuentas conservando valores originales y calculando sumas correctamente ====== $totalCargos = 0; $totalAbonos = 0; $arrayDetalle = array(); $Account1count = 0; // 1. Primero cargamos todos los valores originales foreach($arrayJson as $item => $value) { $codCue = substr($value['account_code'],0,3); if(is_numeric($codCue) && $value['account.CF.Codigo del SAT'] != "") { $arrayDetalle[$value['account_code']] = array( "ClaveSat" => $value['account.CF.Codigo del SAT'], "NumCta" => $value['account_code'], "SaldoIni" => floatval($value['opening_balance']), "Debe" => floatval($value['debit_total']), "Haber" => floatval($value['credit_total']), "SaldoFin" => floatval($value['closing_balance']), "EsDetalle" => ($value['account.CF.Tipo SAT'] == 'Detalle') ); $Account1count++; } } // 2. Función para obtener el nivel de una cuenta function obtenerNivelCuenta($codigo) { $partes = explode('-', $codigo); if(count($partes) != 3) return 0; if($partes[2] != '000') return 3; if($partes[1] != '00') return 2; return 1; } // 3. Calcular sumas jerárquicas $sumasNiveles = array(); // Primero procesamos cuentas de nivel 3 (las más detalladas) foreach($arrayDetalle as $codigo => $datos) { if(obtenerNivelCuenta($codigo) == 3) { $prefijoNivel2 = substr($codigo, 0, 6); // Ej: "101-01" de "101-01-001" $prefijoNivel1 = substr($codigo, 0, 3); // Ej: "101" de "101-01-001" // Acumular para nivel 2 if(!isset($sumasNiveles[$prefijoNivel2])) { $sumasNiveles[$prefijoNivel2] = array( 'SaldoIni' => 0, 'Debe' => 0, 'Haber' => 0, 'SaldoFin' => 0 ); } $sumasNiveles[$prefijoNivel2]['SaldoIni'] += $datos['SaldoIni']; $sumasNiveles[$prefijoNivel2]['Debe'] += $datos['Debe']; $sumasNiveles[$prefijoNivel2]['Haber'] += $datos['Haber']; $sumasNiveles[$prefijoNivel2]['SaldoFin'] += $datos['SaldoFin']; // Acumular para nivel 1 if(!isset($sumasNiveles[$prefijoNivel1])) { $sumasNiveles[$prefijoNivel1] = array( 'SaldoIni' => 0, 'Debe' => 0, 'Haber' => 0, 'SaldoFin' => 0 ); } $sumasNiveles[$prefijoNivel1]['SaldoIni'] += $datos['SaldoIni']; $sumasNiveles[$prefijoNivel1]['Debe'] += $datos['Debe']; $sumasNiveles[$prefijoNivel1]['Haber'] += $datos['Haber']; $sumasNiveles[$prefijoNivel1]['SaldoFin'] += $datos['SaldoFin']; } } // 4. Actualizar cuentas de nivel 2 (solo si son cuentas de detalle y no tienen valores) foreach($arrayDetalle as $codigo => &$datos) { $nivel = obtenerNivelCuenta($codigo); $prefijo = substr($codigo, 0, ($nivel == 2 ? 6 : 3)); if($nivel == 2 && $datos['EsDetalle'] && $datos['SaldoIni'] == 0 && $datos['Debe'] == 0 && $datos['Haber'] == 0 && $datos['SaldoFin'] == 0) { // Solo actualizamos si es una cuenta de detalle sin valores if(isset($sumasNiveles[$prefijo])) { $datos['SaldoIni'] = $sumasNiveles[$prefijo]['SaldoIni']; $datos['Debe'] = $sumasNiveles[$prefijo]['Debe']; $datos['Haber'] = $sumasNiveles[$prefijo]['Haber']; $datos['SaldoFin'] = $sumasNiveles[$prefijo]['SaldoFin']; } } } // 5. Actualizar cuentas de nivel 1 (solo si son cuentas de detalle y no tienen valores) foreach($arrayDetalle as $codigo => &$datos) { $nivel = obtenerNivelCuenta($codigo); $prefijo = substr($codigo, 0, 3); if($nivel == 1 && $datos['EsDetalle'] && $datos['SaldoIni'] == 0 && $datos['Debe'] == 0 && $datos['Haber'] == 0 && $datos['SaldoFin'] == 0) { // Solo actualizamos si es una cuenta de detalle sin valores if(isset($sumasNiveles[$prefijo])) { $datos['SaldoIni'] = $sumasNiveles[$prefijo]['SaldoIni']; $datos['Debe'] = $sumasNiveles[$prefijo]['Debe']; $datos['Haber'] = $sumasNiveles[$prefijo]['Haber']; $datos['SaldoFin'] = $sumasNiveles[$prefijo]['SaldoFin']; } } } // 6. Calcular totales generales foreach($arrayDetalle as $cuenta) { $totalCargos += $cuenta['Debe']; $totalAbonos += $cuenta['Haber']; } // 7. Convertir el array asociativo a indexado para mantener compatibilidad $arrayDetalle = array_values($arrayDetalle); #== Se crea e inserta el primer nodo donde se declaran los namespaces ====== cargaAttNodo($root, array("Version"=>"1.3", "RFC"=>$regFeCa, "Mes"=>$mesCata, "Anio"=>$anioCat, "TipoEnvio"=>$tipoEnvio,"xsi:schemaLocation"=>"http://www.sat.gob.mx/esquemas/ContabilidadE/1_3/BalanzaComprobacion http://www.sat.gob.mx/esquemas/ContabilidadE/1_3/BalanzaComprobacion/BalanzaComprobacion_1_3.xsd", "xmlns:xsi"=>"http://www.w3.org/2001/XMLSchema-instance", "xmlns:BCE"=>"http://www.sat.gob.mx/esquemas/ContabilidadE/1_3/BalanzaComprobacion") ); $arrayToCSV = Array(); $arrayToCSV[] = array('NumCta','SaldoIni', 'Debe', 'Haber', 'SaldoFin', 'ClaveSat'); foreach($arrayDetalle as $item => $value) { if($value['ClaveSat'] != "") { $codCue = substr($value['NumCta'],0,3); if(is_numeric($codCue)) { $cuentas = $xml->createElement("BCE:Ctas"); $cuenta = $root->appendChild($cuentas); cargaAttNodo($cuenta, array( "SaldoFin"=>$value['SaldoFin'], "Haber"=>$value['Haber'], "Debe"=>$value['Debe'], "SaldoIni"=>$value['SaldoIni'], "NumCta"=>$value['NumCta'] ) ); // Creamos el array para el archivo CSV $arrayToCSV[] = array($value['NumCta'],$value['SaldoIni'], $value['Debe'], $value['Haber'], $value['SaldoFin'], $value['ClaveSat']); } } } #=== Se guarda el archivo .XML de la Balanza de Comprobación ======================= $xmlFilesPath = 'archs_xml/'; $csvFilesPath = 'archs_csv/'; $zipFilesPath = 'archs_zip/'; if($tipoEnvio == "N") { $file_name_with_full_path = $xmlFilesPath.$regFeCa.$anioCat.$mesCata."BN.xml"; $file_name_csv_full_path = $csvFilesPath.$regFeCa.$anioCat.$mesCata."BN.csv"; } else { $file_name_with_full_path = $xmlFilesPath.$regFeCa.$anioCat.$mesCata."BC.xml"; $file_name_csv_full_path = $csvFilesPath.$regFeCa.$anioCat.$mesCata."BC.csv"; } #=== Si existe el archivo CSV se elimina para crear el nuevo ======================= if(!file_exists($file_name_csv_full_path)){ unlink($file_name_csv_full_path); } $fp = fopen($file_name_csv_full_path, 'w'); foreach ($arrayToCSV as $fields) { fputcsv($fp, $fields); } fclose($fp); #=== Si existe el archivo XML se elimina para crear el nuevo ======================= if(!file_exists($file_name_with_full_path)){ unlink($file_name_with_full_path); } #=== Se guarda el archivo XML creado ======================= $cfdi = $xml->saveXML(); $xml->formatOutput = true; $xml->save($file_name_with_full_path); unset($xml); #=== Se dan permisos de escritura al archivo .xml. ========================= if($tipoEnvio == "N") { chmod($SendaXML.$regFeCa.$anioCat.$mesCata."BN.xml", 0777); } else { chmod($SendaXML.$regFeCa.$anioCat.$mesCata."BC.xml", 0777); } #=== Se procede a crear el archivo ZIP del Catalogo de Cuentas ========================= $zip = new ZipArchive(); $zipFilesPath = 'archs_zip/'; if($tipoEnvio == "N") { $nombreArchivoZip = $zipFilesPath.$regFeCa.$anioCat.$mesCata."BN.zip"; $nameArchZip = $regFeCa.$anioCat.$mesCata."BN.zip"; } else { $nombreArchivoZip = $zipFilesPath.$regFeCa.$anioCat.$mesCata."BC.zip"; $nameArchZip = $regFeCa.$anioCat.$mesCata."BC.zip"; } #=== Si existe el archivo ZIP se elimina para crear el nuevo ======================= if(!file_exists($nombreArchivoZip)){ unlink($nombreArchivoZip); } if (!$zip->open($nombreArchivoZip, ZipArchive::CREATE | ZipArchive::OVERWRITE)) { exit("Error abriendo ZIP en $nombreArchivoZip"); } $nombre = basename($file_name_with_full_path); $zip->addFile($file_name_with_full_path, $nombre); $resultado = $zip->close(); if (!$resultado) { // echo "Error creando archivo"; exit("Error creando archivo ZIP"); } #=== FIN DEL PROCESO ======================= $resultData = array( 'xmlFilesPath' => $xmlFilesPath, 'xmlFileName' => $regFeCa.$anioCat.$mesCata."BN.xml", 'csvFilesPath' => $csvFilesPath, 'csvFileName' => $regFeCa.$anioCat.$mesCata."BN.csv", 'zipFilesPath' => $zipFilesPath, 'zipFileName' => $regFeCa.$anioCat.$mesCata."BN.zip", 'totalCargos' => round($totalCargos,2), 'totalAbonos' => round($totalAbonos,2), 'totalCuentas' => $Account1count, 'cantidadDeudoras' => 333); if($tipoEnvio == "N") { $j_array = array('code' => "200", 'message' => 'Proceso de creacion de Archivo (NORMAL) de Balanza de Comprobacion fue exitoso', 'data' => $resultData); } else { $j_array = array('code' => "200", 'message' => "Proceso de creacion de Archivo (COMPLEMENTARIO) de Balanza de Comprobacion fue exitoso", 'data' => $resultData); } $Resultado = json_encode($j_array); echo $Resultado; return $Resultado; ### FUNCIONES DEL MÓDULO ######################################################### # Funcion para convertir CSV a formato JSON function csvToJson($fname) { if (!($fp = fopen($fname, 'r'))) { die("No se pudo abrir el arcivo CSV..."); } $key = fgetcsv($fp,"1024",","); $json = array(); while ($row = fgetcsv($fp,"1024",",")) { $json[] = array_combine($key, $row); } fclose($fp); return json_encode($json); } # Función que integra los nodos al archivo .XML function cargaAttNodo(&$nodo, $attr){ global $xmldoc; foreach ($attr as $key => $val){ $val = preg_replace('/\s\s+/', ' ', $val); $val = trim($val); if (strlen($val)>0){ $val = utf8_encode(str_replace("|","/",$val)); $nodo->setAttribute($key,$val); } } }