_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-429 MANUEL MORANTE SORIA,114-02-429,,2340388000016777618,other_current_asset,-0.10,0.00,0.00,0.00,true,-0.10,Deudora,,, 114-02-434 JUAN RODRIGO PIMENTEL,114-02-434,,2340388000016777625,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-445 ROBERTO JOSE AROCHI DE LA TORRE,114-02-445,,2340388000016777632,other_current_asset,-64525.57,0.00,0.00,0.00,true,-64525.57,Deudora,,, 114-02-465 JOSE ANTONIO AROCHI DE LA TORRE,114-02-465,,2340388000016777639,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-470 TAXIS UBER CABIFY,114-02-470,,2340388000016777646,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-471 MAURICIO LOPEZ GONZALEZ GARZA,114-02-471,,2340388000016777653,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-479 STEPHANY DAFNE MENDEZ PEREZ,114-02-479,,2340388000016777660,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-480 ALBERTO SANTOS,114-02-480,,2340388000016777667,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-492 KARLA FLORES,114-02-492,,2340388000016777674,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-504 CENTRO TEMPUS SA,114-02-504,,2340388000016777681,other_current_asset,-9499.89,0.00,0.00,0.00,true,-9499.89,Deudora,,, 114-02-510 FERNANDO PEREZ,114-02-510,,2340388000016777688,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-511 GERARDO MANCERA,114-02-511,,2340388000016777695,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-523 VIAJES JORDAN SA DE CV,114-02-523,,2340388000016777702,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-524 IMPI,114-02-524,,2340388000016777709,other_current_asset,-36456.13,0.00,0.00,0.00,true,-36456.13,Deudora,,, 114-02-526 MARISOL CERDA,114-02-526,,2340388000022830932,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-538 DANIEL MENDOZA,114-02-538,,2340388000016777716,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-544 CARLOS CESAR LEDEZMA CABALLERO,114-02-544,,2340388000016777723,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-547 FRANCISCO ESTEBAN LEON MORENO,114-02-547,,2340388000016777730,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-549 CENTRO TEMPUS DESCUENTOS,114-02-549,,2340388000016777737,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-550 SANDRA HERNANDEZ ARESTEGUI,114-02-550,,2340388000016777744,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-566 MARIO URIBE OLVERA,114-02-566,,2340388000016777751,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-575 JORGE AROCHI ESCALANTE,114-02-575,,2340388000016777758,other_current_asset,70597.64,0.00,0.00,0.00,true,70597.64,Deudora,,, 114-02-578 PAMELA GISHOLT,114-02-578,,2340388000016777765,other_current_asset,20982.00,0.00,0.00,0.00,true,20982.00,Deudora,,, 114-02-581 AEROMEXICO INVESTIGACIONES,114-02-581,,2340388000016777772,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-587 ZENEN TEOBAL,114-02-587,,2340388000016777779,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-589 KARLA FABIOLA VAZQUEZ,114-02-589,,2340388000016777786,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-596 LAURA MARIANA VENEGAS JERONIMO,114-02-596,,2340388000016777793,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-598 KAREN CALVO RODRIGUEZ,114-02-598,,2340388000023300044,other_current_asset,-0.01,0.00,0.00,0.00,true,-0.01,Deudora,,, 114-02-599 SEGUROS,114-02-599,,2340388000016777800,other_current_asset,482439.01,0.00,0.00,0.00,true,482439.01,Deudora,,, 114-02-602 AEROMEXICO,114-02-602,,2340388000016777807,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-610 DIANA DOMINGUEZ,114-02-610,,2340388000016777814,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-621 LUIS PABLO VELAZQUEZ RANSA,114-02-621,,2340388000016777821,other_current_asset,-0.68,0.00,0.00,0.00,true,-0.68,Deudora,,, 114-02-622 MONICA DE NARVAEZ GIL,114-02-622,,2340388000016777828,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-623 ARIANA CORTES VAZQUEZ,114-02-623,,2340388000016777835,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-624 EDUARDO CAMARENA,114-02-624,,2340388000016777842,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-629 PEDRO PABLO LEON MARTINEZ,114-02-629,,2340388000016777849,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-635 ERNESTO BOJORGUEZ,114-02-635,,2340388000016777856,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-642 SPORT CITY R,114-02-642,,2340388000016777863,other_current_asset,736103.30,17781.75,0.00,-17781.75,false,718321.55,Deudora,,, 114-02-643 SPORT CITY DESC,114-02-643,,2340388000016777870,other_current_asset,-17771.89,0.00,0.00,0.00,true,-17771.89,Deudora,,, 114-02-646 CESAR ALVARADO GONZALEZ,114-02-646,,2340388000017405891,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-652 GONZALO ALVAREZ SUAREZ,114-02-652,,2340388000016777877,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-674 CAMILA RODRIGUEZ CASTRO,114-02-674,,2340388000016777884,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-676 CELMIRA SANCHEZ PEREZ,114-02-676,,2340388000016777891,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-681 ANA CASTRO DOSAL,114-02-681,,2340388000016777898,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-682 LORENA FORTANET LOPEZ,114-02-682,,2340388000016777905,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-684 INMOBILIARIA AROCHI,114-02-684,,2340388000016777912,other_current_asset,1705737.27,0.00,0.00,0.00,true,1705737.27,Deudora,,, 114-02-714 JOSE EDUARDO RIVERA,114-02-714,,2340388000016777919,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-715 ALEJANDRO DELGADO HERRERA,114-02-715,,2340388000016777926,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-723 DIEGO ALFONSO ANZURES ALCALA,114-02-723,,2340388000016777933,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-745 EDUARDO HERNANDEZ ANDRES,114-02-745,,2340388000016777940,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-747 JARED RODRIGO MENDOZA INIGUEZ,114-02-747,,2340388000016777947,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-750 GUSTAVO MONASTERIO CASTILLO,114-02-750,,2340388000016777954,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-760 ORTIZ MARTINEZ RAYMUNDO,114-02-760,,2340388000016777961,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-768 JOVANNA G TEUTLI MONTERO,114-02-768,,2340388000016777968,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-779 JOSE LUIS HERNANDEZ,114-02-779,,2340388000016777975,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-785 AML S.A. DE C.V. PRESTAMO,114-02-785,,2340388000016777982,other_current_asset,1159399.95,2549999.98,2550000.00,0.02,true,1159399.97,Deudora,,, 114-02-805 CARLOS EDUARDO DAVILA PENICHE,114-02-805,,2340388000016777989,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-808 ARTURO REYES,114-02-808,,2340388000016777996,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-817 JOHN MUNPHY,114-02-817,,2340388000016778003,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-821 CENTRO LIBANES,114-02-821,,2340388000016778010,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-838 STEPHANY LESLIE FLORES,114-02-838,,2340388000016778017,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-873 VERONICA SITEN,114-02-873,,2340388000016778024,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-875 SALVADOR CAMACHO HERNANDEZ,114-02-875,,2340388000016778031,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-876 GIRTAB FACTURACION DE AR,114-02-876,,2340388000016778038,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-877 CENTRO TEMPUS FACT,114-02-877,,2340388000016778045,other_current_asset,461071.94,0.00,0.00,0.00,true,461071.94,Deudora,,, 114-02-901 SIXTO JUAN CARLOS LOPEZ HERNANDEZ,114-02-901,,2340388000016778052,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-910 SAT,114-02-910,,2340388000016778059,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-911 LUIS AGUILERA BEGUERISSE,114-02-911,,2340388000016778066,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-912 ENDERED MEXICO,114-02-912,,2340388000016778073,other_current_asset,54886.54,0.00,0.00,0.00,true,54886.54,Deudora,,, 114-02-914 PICACHO AJUSCO SA DE CV,114-02-914,,2340388000016778080,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-919 LUCRECIA ARAMBURU,114-02-919,,2340388000016778087,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-920 TERESA LIST,114-02-920,,2340388000016778094,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-921 VICTOR ALDAIR ROMERO TERREROS,114-02-921,,2340388000016778101,other_current_asset,0.07,0.00,0.00,0.00,true,0.07,Deudora,,, 114-02-922 LUIS HUMBERTO VEGA CASTAÑEDA,114-02-922,,2340388000016778108,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-926 FRIDA CRUCES,114-02-926,,2340388000016778115,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-927 THANIA MENDEZ PEREZ,114-02-927,,2340388000016778122,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-930 GRECIA ALAMILLA PIEDRA,114-02-930,,2340388000016778129,other_current_asset,-2.00,0.00,0.00,0.00,true,-2.00,Deudora,,, 114-02-931 JUAN PABLO RUBALCABA,114-02-931,,2340388000016778136,other_current_asset,0.45,0.00,0.00,0.00,true,0.45,Deudora,,, 114-02-932 LINETH MENDIVIL,114-02-932,,2340388000023373663,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-933 CHRISTIAN RAMON INFANTE,114-02-933,,2340388000016778143,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-935 CENTRO TEMPUS PRESTAMO,114-02-935,,2340388000016778150,other_current_asset,100000.38,350000.29,350000.00,-0.29,false,100000.09,Deudora,,, 114-02-936 BIBIANA AGUDELO,114-02-936,,2340388000016778157,other_current_asset,-0.49,0.00,0.00,0.00,true,-0.49,Deudora,,, 114-02-938 THOMSON ELITE,114-02-938,,2340388000016778164,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-939 CENTRO TEMPUS PAGO A CUENTA DE TERCEROS,114-02-939,,2340388000016778171,other_current_asset,240269.06,10000.00,84590.85,74590.85,true,314859.91,Deudora,,, 114-02-940 GIRTAB PRESTAMOS,114-02-940,,2340388000016778178,other_current_asset,1.03,0.00,0.00,0.00,true,1.03,Deudora,,, 114-02-945 CARLOS GONZALES MORENO,114-02-945,,2340388000016778185,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-950 HAYDEE PEREZ,114-02-950,,2340388000029286483,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-951 PAULINA HERNANDEZ FERNANDEZ,114-02-951,,2340388000023300037,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-02-952 AROCHI & LINDNER SLU - ESP,114-02-952,,2340388000036970673,other_current_asset,1254571.23,0.00,0.00,0.00,true,1254571.23,Deudora,,, 114-03-000 SOCIOS O ACCIONISTAS,114-03-000,,2340388000003218455,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,107.02, 114-04-000 PARTES RELACIONADAS,114-04-000,,2340388000003218462,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,107.03, 114-04-008 JERONIMO ALEJANDRO GOMEZ DE LA CRUZ,114-04-008,,2340388000016778192,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-05-000 CUENTA TRANSITORIA,114-05-000,,2340388000016660502,other_current_asset,-329454.81,0.00,0.00,0.00,true,-329454.81,Deudora,Detalle,107.03, 114-05-001 AROCHI SL,114-05-001,ESPAÑA,2340388000016660509,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,,,, 114-05-002 TEMPUS,114-05-002,COMEDOR YEVENTOS,2340388000016660515,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,,,, 114-05-003 AM&L,114-05-003,AM&L SA DE CV,2340388000016660521,other_current_asset,45109.14,0.00,0.00,0.00,true,45109.14,,,, 114-05-004 INO,114-05-004,INMOBILIARIA AROCHI,2340388000016660527,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,,,, 114-05-005 RAE,114-05-005,,2340388000016660533,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,,,, 114-05-006 HLL,114-05-006,,2340388000016660539,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,,,, 114-05-007 DEVOLUCIONES,114-05-007,,2340388000016676844,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,,,, 114-06-000 ANTICIPO A PROVEEDORES,114-06-000,,2340388000016778199,other_current_asset,24475.38,0.00,0.00,0.00,true,24475.38,Deudora,Detalle,107.05, 114-06-024 CENTRO TEMPUS IURIS S DE RL DE CV,114-06-024,,2340388000016778206,other_current_asset,-1.28,0.00,0.00,0.00,true,-1.28,Deudora,,, 114-06-025 MILLENIUM BROADWAY,114-06-025,,2340388000016778213,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-06-027 AML ANTICIPO PROVEEDORES,114-06-027,,2340388000016778220,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-06-028 SEGUROS POR DEVENGAR,114-06-028,,2340388000016778227,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-09-000 RESERVA CUENTAS DIFICIL RECUPERACIÓN,114-09-000,,2340388000027843651,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,107.05, 114-09-001 RVA AROCHI MARROQUIN Y ASOCIADOS,114-09-001,,2340388000027843658,other_current_asset,1210785.00,0.00,0.00,0.00,true,1210785.00,Deudora,,, 114-10-000 DEUDORES DIVERSOS USD,114-10-000,,2340388000016778301,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,107.05, 114-10-012 AM & L SA DE CV PRESTAMO DLLS,114-10-012,,2340388000016778308,other_current_asset,174205.81,0.00,0.00,0.00,true,174205.81,Deudora,,, 114-10-021 AROCHI &LINDNER SL (MADRID),114-10-021,,2340388000016778315,other_current_asset,1147928.00,0.00,0.00,0.00,true,1147928.00,Deudora,,, 114-10-022 AROCHI MARROQUIN LINDNER & ASOCIADOS SLP,114-10-022,,2340388000016778322,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-10-025 HEDWIG A LINDNER LOPEZ,114-10-025,,2340388000016778329,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-10-027 HENSON,114-10-027,,2340388000016778336,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 114-11-000 DEUDORES DIVERSOS EUR,114-11-000,,2340388000016778343,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,107.05, 114-11-001 AROCHI LINDNER SL (MADRID),114-11-001,,2340388000016778350,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 115-00-000 PAGOS ANTICIPADOS,115-00-000,,2340388000003218504,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,109, 115-01-000 PAGOS ANTICIPADOS (B),115-01-000,An asset account that reports amounts paid in advance while purchasing goods or services from a vendor.,2340388000000070010,other_current_asset,8081762.39,9500757.54,11374179.28,1873421.74,true,9955184.13,Deudora,Detalle,109.23, 115-02-000 OTROS PAGOS ANTICIPADOS,115-02-000,,2340388000003218518,other_current_asset,143351.69,0.00,0.00,0.00,true,143351.69,Deudora,Detalle,109.23, 115-03-000 ANTICIPO A PROVEEDORES,115-03-000,,2340388000003218511,other_current_asset,218446.77,0.00,0.00,0.00,true,218446.77,Deudora,Detalle,109.23, 116-00-000 IVA ACREDITABLE,116-00-000,,2340388000003218525,other_current_asset,1239.06,0.00,0.00,0.00,true,1239.06,Deudora,Acumulativa,118, 116-01-000 IVA ACREDITABLE (B),116-01-000,Importe de dinero que se le ha cargado como impuesto en sus facturas de proveedor y gastos .,2340388000008649218,input_tax,10016519.44,5009.77,1666273.45,1661263.68,true,11677783.12,Deudora,Detalle,118.01, 116-02-000 IVA ACREDITABLE PAGADO AL 11%,116-02-000,,2340388000003218539,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,118.01, 116-03-000 IVA RETENIDO POR ACREDITAR,116-03-000,,2340388000003218546,other_current_asset,14188.08,0.00,0.00,0.00,true,14188.08,Deudora,Detalle,118.01, 116-04-000 IVA PAGADO EN IMPORTACIÓN,116-04-000,,2340388000003218553,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,118.02, 116-05-000 IVA ACREDITABLE PAGADO AL 16%,116-05-000,,2340388000003218532,other_current_asset,22291664.70,0.00,0.00,0.00,true,22291664.70,Deudora,Detalle,118.01, 117-00-000 IVA ACREDITABLE POR PAGAR,117-00-000,,2340388000003218560,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,119, 117-01-000 IVA ACREDITABLE PROVISIONADO 16%,117-01-000,,2340388000003218567,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,119.01, 117-02-000 IVA ACREDITABLE 11%,117-02-000,,2340388000003218574,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,119.01, 117-03-000 IVA RETENIDO PROVISIÓN POR ACREDITAR,117-03-000,,2340388000003218581,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,119.01, 117-04-000 IVA DE IMPORTACIÓN PENDIENTE DE PAGO,117-04-000,,2340388000003218588,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,119.02, 118-00-000 SALDOS A FAVOR DE IMPUESTOS,118-00-000,IMPUESTOS A TERCER NIVEL,2340388000003218595,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,113, 118-01-000 ANTICIPO DE ISR,118-01-000,,2340388000003218602,other_current_asset,4586623.00,0.00,194297.00,194297.00,true,4780920.00,Deudora,Detalle,113.02, 118-01-006 ISR RETENIDO DEL EXTRANJERO COLOMBIA,118-01-006,,2340388000029286490,other_current_asset,212889.19,0.00,0.00,0.00,true,212889.19,Deudora,,, 118-01-008 ISR A FAVOR 2005,118-01-008,,2340388000029286497,other_current_asset,-1062581.45,0.00,0.00,0.00,true,-1062581.45,Deudora,,, 118-01-009 ISR A FAVOR 2006,118-01-009,,2340388000029286504,other_current_asset,151806.00,0.00,0.00,0.00,true,151806.00,Deudora,,, 118-01-010 SALDO A FAVOR 2007,118-01-010,,2340388000029286511,other_current_asset,15209.00,0.00,0.00,0.00,true,15209.00,Deudora,,, 118-01-012 ISR A FAVOR 2009,118-01-012,,2340388000029286518,other_current_asset,31018.00,0.00,0.00,0.00,true,31018.00,Deudora,,, 118-01-013 SALDO A FAVOR DE 2013,118-01-013,,2340388000029286525,other_current_asset,4818.00,0.00,0.00,0.00,true,4818.00,Deudora,,, 118-01-016 ISR A FAVOR 2011,118-01-016,,2340388000029286532,other_current_asset,805.00,0.00,0.00,0.00,true,805.00,Deudora,,, 118-01-017 IVA A FAVOR PERIODOS,118-01-017,,2340388000029286539,other_current_asset,6238.38,0.00,0.00,0.00,true,6238.38,Deudora,,, 118-01-018 IVA A FAVOR 2005,118-01-018,,2340388000029286546,other_current_asset,21508.67,0.00,0.00,0.00,true,21508.67,Deudora,,, 118-01-019 IVA A FAVOR 2006,118-01-019,,2340388000029286553,other_current_asset,37352.91,0.00,0.00,0.00,true,37352.91,Deudora,,, 118-01-020 IVA A FAVOR 2007,118-01-020,,2340388000029286560,other_current_asset,40512.16,0.00,0.00,0.00,true,40512.16,Deudora,,, 118-01-021 IVA A FAVOR 2008,118-01-021,,2340388000029286567,other_current_asset,19520.00,0.00,0.00,0.00,true,19520.00,Deudora,,, 118-01-022 IVA ACREDITABLE A FAVOR,118-01-022,,2340388000029286574,other_current_asset,737.06,0.00,0.00,0.00,true,737.06,Deudora,,, 118-01-023 IVA A FAVOR 2014,118-01-023,,2340388000029286581,other_current_asset,0.47,0.00,0.00,0.00,true,0.47,Deudora,,, 118-01-025 IVA A FAVOR 2016,118-01-025,,2340388000029286588,other_current_asset,153753.92,0.00,0.00,0.00,true,153753.92,Deudora,,, 118-01-026 IVA A FAVOR 2017,118-01-026,,2340388000029286595,other_current_asset,11763.96,0.00,0.00,0.00,true,11763.96,Deudora,,, 118-01-027 IVA A FAVOR 2020,118-01-027,,2340388000029286602,other_current_asset,-0.07,0.00,0.00,0.00,true,-0.07,Deudora,,, 118-01-028 IMPUESTOS A FAVOR GIRTAB ,118-01-028,,2340388000029286609,other_current_asset,212255.11,0.00,0.00,0.00,true,212255.11,Deudora,,, 118-01-029 IVA A FAVOR 2021,118-01-029,,2340388000029286616,other_current_asset,-1.41,0.00,0.00,0.00,true,-1.41,Deudora,,, 118-01-030 ISR A FAVOR 2021,118-01-030,,2340388000029286623,other_current_asset,27836.00,0.00,0.00,0.00,true,27836.00,Deudora,,, 118-01-031 ISR DIVIDENDOS,118-01-031,,2340388000040826294,other_current_asset,300866.56,0.00,0.00,0.00,true,300866.56,Deudora,,, 118-01-110 IETU,118-01-110,,2340388000029286630,other_current_asset,21.00,0.00,0.00,0.00,true,21.00,Deudora,,, 118-01-111 IDE,118-01-111,,2340388000029286637,other_current_asset,12269.10,0.00,0.00,0.00,true,12269.10,Deudora,,, 118-01-112 IVA A FAVOR 2018,118-01-112,,2340388000029286644,other_current_asset,175063.64,0.00,0.00,0.00,true,175063.64,Deudora,,, 118-01-117 IVA A FAVOR 2019,118-01-117,,2340388000029286651,other_current_asset,0.89,0.00,0.00,0.00,true,0.89,Deudora,,, 118-01-118 ISR ASIMILADOS A FAVOR 2020,118-01-118,,2340388000029286658,other_current_asset,140395.73,0.00,0.00,0.00,true,140395.73,Deudora,,, 118-01-119 ISR A FAVOR 2019,118-01-119,,2340388000029286665,other_current_asset,101094.88,0.00,0.00,0.00,true,101094.88,Deudora,,, 118-01-120 ISR A FAVOR 2022,118-01-120,,2340388000049708822,other_current_asset,454635.00,0.00,0.00,0.00,true,454635.00,Deudora,,, 118-02-000 ISR BANCARIO RETENIDO,118-02-000,,2340388000003218609,other_current_asset,448.06,0.00,2.66,2.66,true,450.72,Deudora,Detalle,113.02, 118-03-000 CREDITO AL SALARIO,118-03-000,,2340388000003218616,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,113.06, 118-04-000 ISR RET EXTRANJEROS (B),118-04-000,,2340388000003218623,other_current_asset,493834.97,0.00,30542.99,30542.99,true,524377.96,Deudora,Detalle,113.02, 118-05-000 ISR RETENIDO DEL EXTRANJERO COLOMBIA (B),118-05-000,,2340388000003218630,other_current_asset,129809.09,0.00,0.00,0.00,true,129809.09,Deudora,Detalle,113.02, 118-06-000 IETU,118-06-000,,2340388000003218637,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,113.03, 118-07-000 IDE,118-07-000,,2340388000003218644,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,113.04, 118-08-000 IVA A FAVOR,118-08-000,,2340388000003218651,other_current_asset,-47167.00,0.00,0.00,0.00,true,-47167.00,Deudora,Detalle,113.01, 118-09-000 ISR FAVOR,118-09-000,,2340388000003218658,other_current_asset,1605253.00,0.00,0.00,0.00,true,1605253.00,Deudora,Detalle,113.02, 119-00-000 PAGO PROVISIONAL COI,119-00-000,,2340388000003218665,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,114, 119-01-000 PAGO PROVISIONAL (B),119-01-000,"Any tax which is paid in advance is recorded into the advance tax account. This advance tax payment could be a quarterly, half yearly or yearly payment.",2340388000000000370,other_current_asset,-4086479.00,0.00,0.00,0.00,true,-4086479.00,Deudora,Detalle,114.01, 120-00-000 SUBSIDIO PARA EL EMPLEO,120-00-000,,2340388000003218679,other_current_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,110, 120-01-000 SUBSIDIO PARA EL EMPLEO,120-01-000,,2340388000003218686,other_current_asset,542.21,0.00,0.00,0.00,true,542.21,Deudora,Detalle,110.01, 155-00-000 MOBILIARIO Y EQUIPO NO DEPRECIABLE,155-00-000,,2340388000003218693,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,155, 155-01-000 MOBILIARIO Y EQUIPO NO DEPRECIABLE,155-01-000,,2340388000033392134,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,155.01, 155-01-001 ADQUISICIONES 1995,155-01-001,,2340388000003218700,fixed_asset,11909.00,0.00,0.00,0.00,true,11909.00,Deudora,,, 155-01-002 ADQUISICIONES 1996,155-01-002,,2340388000003218707,fixed_asset,27000.00,0.00,0.00,0.00,true,27000.00,Deudora,,, 155-01-003 ADQUISICIONES 1997,155-01-003,,2340388000003218714,fixed_asset,3043.47,0.00,0.00,0.00,true,3043.47,Deudora,,, 155-01-004 ADQUICISIONES DE 1998,155-01-004,,2340388000003218721,fixed_asset,109570.00,0.00,0.00,0.00,true,109570.00,Deudora,,, 155-01-005 ADQUISICIONES 2004,155-01-005,,2340388000003218728,fixed_asset,673527.60,0.00,0.00,0.00,true,673527.60,Deudora,,, 155-01-006 ADQUICISIONES 2005,155-01-006,,2340388000003218735,fixed_asset,14400.00,0.00,0.00,0.00,true,14400.00,Deudora,,, 155-01-007 ADQUICISIONES 2008,155-01-007,,2340388000003218742,fixed_asset,173776.50,0.00,0.00,0.00,true,173776.50,Deudora,,, 155-01-008 ADQUICISIONES 2010,155-01-008,,2340388000003218749,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 155-01-009 ADQUICISIONES 2011,155-01-009,,2340388000003218756,fixed_asset,323872.00,0.00,0.00,0.00,true,323872.00,Deudora,,, 155-01-010 ADQUICISIONES 2012,155-01-010,,2340388000003218763,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 155-01-011 ADQUICISIONES 2013,155-01-011,,2340388000003218770,fixed_asset,91722.12,0.00,0.00,0.00,true,91722.12,Deudora,,, 155-01-012 ADQUICISIONES 2014,155-01-012,,2340388000003218777,fixed_asset,40000.00,0.00,0.00,0.00,true,40000.00,Deudora,,, 155-01-013 ADQUISIONES 2017,155-01-013,,2340388000003218784,fixed_asset,30000.00,0.00,0.00,0.00,true,30000.00,Deudora,,, 155-01-014 ADQUICISIONES 2018,155-01-014,,2340388000003218791,fixed_asset,50000.00,0.00,0.00,0.00,true,50000.00,Deudora,,, 156-00-000 MOBILIARIO Y EQUIPO,156-00-000,,2340388000003218798,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,155, 156-01-000 MOBILIARIO Y EQUIPO,156-01-000,,2340388000033392187,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,155.01, 156-01-001 ADQUISICIONES 1994,156-01-001,,2340388000003218805,fixed_asset,8717.15,0.00,0.00,0.00,true,8717.15,Deudora,,, 156-01-002 ADQUISICIONES 1995,156-01-002,,2340388000003218812,fixed_asset,12053.80,0.00,0.00,0.00,true,12053.80,Deudora,,, 156-01-003 ADQUISICIONES 1996.,156-01-003,,2340388000003218819,fixed_asset,175815.37,0.00,0.00,0.00,true,175815.37,Deudora,,, 156-01-004 ADQUISICIONES 1997,156-01-004,,2340388000003218826,fixed_asset,27799.68,0.00,0.00,0.00,true,27799.68,Deudora,,, 156-01-005 ADQUISICIONES 1998,156-01-005,,2340388000003218833,fixed_asset,557050.80,0.00,0.00,0.00,true,557050.80,Deudora,,, 156-01-006 ADQUISICIONES 1999,156-01-006,,2340388000003218840,fixed_asset,523883.93,0.00,0.00,0.00,true,523883.93,Deudora,,, 156-01-007 ADQUISICIONES 2000,156-01-007,,2340388000003218847,fixed_asset,54434.05,0.00,0.00,0.00,true,54434.05,Deudora,,, 156-01-008 ADQUISICIONES 2001,156-01-008,,2340388000003218854,fixed_asset,129065.87,0.00,0.00,0.00,true,129065.87,Deudora,,, 156-01-009 ADQUISICIONES 2002,156-01-009,,2340388000003218861,fixed_asset,187409.34,0.00,0.00,0.00,true,187409.34,Deudora,,, 156-01-010 ADQ. FEBRERO DE 1995.,156-01-010,,2340388000003218868,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 156-01-011 ADQUSICIONES 2003,156-01-011,,2340388000003218875,fixed_asset,25735.48,0.00,0.00,0.00,true,25735.48,Deudora,,, 156-01-012 ADQIOSICIONES INSURGENTES SUR 1605 2003,156-01-012,,2340388000003218882,fixed_asset,467553.24,0.00,0.00,0.00,true,467553.24,Deudora,,, 156-01-013 ADQUISICIONES 2004 INSURGENTES SUR,156-01-013,,2340388000003218889,fixed_asset,937856.08,0.00,0.00,0.00,true,937856.08,Deudora,,, 156-01-014 ADQUICISIONES INSURGENTES 2005,156-01-014,,2340388000003218896,fixed_asset,263608.50,0.00,0.00,0.00,true,263608.50,Deudora,,, 156-01-015 ADQUICISIONES INSURG 2006,156-01-015,,2340388000003218903,fixed_asset,132998.18,0.00,0.00,0.00,true,132998.18,Deudora,,, 156-01-016 ADQUICISIONES 2007,156-01-016,,2340388000003218910,fixed_asset,122256.01,0.00,0.00,0.00,true,122256.01,Deudora,,, 156-01-017 ADQUICISIONES 2008,156-01-017,,2340388000003218917,fixed_asset,206412.19,0.00,0.00,0.00,true,206412.19,Deudora,,, 156-01-018 ADQUICISIONES 2009,156-01-018,,2340388000003218924,fixed_asset,319900.72,0.00,0.00,0.00,true,319900.72,Deudora,,, 156-01-019 ADQUICISIONES 2010,156-01-019,,2340388000003218931,fixed_asset,136226.51,0.00,0.00,0.00,true,136226.51,Deudora,,, 156-01-020 ADQUICISIONES 2011,156-01-020,,2340388000003218938,fixed_asset,214217.54,0.00,0.00,0.00,true,214217.54,Deudora,,, 156-01-021 ADQUICISIONES 2012,156-01-021,,2340388000003218945,fixed_asset,328146.68,0.00,0.00,0.00,true,328146.68,Deudora,,, 156-01-022 ADQUISICIONES 2013,156-01-022,,2340388000003218952,fixed_asset,310052.77,0.00,0.00,0.00,true,310052.77,Deudora,,, 156-01-023 ADQUICISIONES 2014,156-01-023,,2340388000003218959,fixed_asset,1480453.96,0.00,0.00,0.00,true,1480453.96,Deudora,,, 156-01-024 ADQUISICIONES 2015,156-01-024,,2340388000003218966,fixed_asset,1862395.45,0.00,0.00,0.00,true,1862395.45,Deudora,,, 156-01-025 ADQUISICIONES 2016,156-01-025,,2340388000003218973,fixed_asset,2373834.66,0.00,0.00,0.00,true,2373834.66,Deudora,,, 156-01-026 ADQUISICIONES 2017,156-01-026,,2340388000003218980,fixed_asset,285696.44,0.00,0.00,0.00,true,285696.44,Deudora,,, 156-01-027 ADQUISICIONES 2018,156-01-027,,2340388000003218987,fixed_asset,479000.86,0.00,0.00,0.00,true,479000.86,Deudora,,, 156-01-028 MOBILIARIO Y EQUIPO 2019,156-01-028,,2340388000029266257,fixed_asset,29520.82,0.00,0.00,0.00,true,29520.82,Deudora,,, 156-01-029 MOBILIARIO Y EQUIPO 2020,156-01-029,,2340388000029266280,fixed_asset,142302.24,0.00,0.00,0.00,true,142302.24,Deudora,,, 157-00-000 EQUIPO DE TRANSPORTE,157-00-000,,2340388000003218994,fixed_asset,0.00,518508.63,0.00,-518508.63,false,-518508.63,Deudora,Acumulativa,154, 157-01-000 EQUIPO DE TRANSPORTE,157-01-000,,2340388000033392386,fixed_asset,617990.00,0.00,0.00,0.00,true,617990.00,Deudora,Detalle,154.01, 157-01-035 AUDI HLL,157-01-035,,2340388000003219001,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 157-01-040 JAGUAR 2012,157-01-040,,2340388000003219008,fixed_asset,837289.66,0.00,0.00,0.00,true,837289.66,Deudora,,, 157-01-041 JAGUAR 2013,157-01-041,,2340388000003219015,fixed_asset,1340456.90,0.00,0.00,0.00,true,1340456.90,Deudora,,, 157-01-042 CRV 2014,157-01-042,,2340388000003219022,fixed_asset,310258.62,0.00,0.00,0.00,true,310258.62,Deudora,,, 157-01-043 FIESTA 2014,157-01-043,,2340388000003219029,fixed_asset,166637.93,0.00,0.00,0.00,true,166637.93,Deudora,,, 157-01-044 HIGHLINDER 2014,157-01-044,,2340388000003219036,fixed_asset,460689.66,0.00,0.00,0.00,true,460689.66,Deudora,,, 157-01-045 CAMIONETA MERCEDES BENZ,157-01-045,,2340388000003219043,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 157-01-046 BMW 2015,157-01-046,,2340388000003219050,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 157-01-047 CAMIONETA MERCEDES 2016,157-01-047,,2340388000003219057,fixed_asset,835172.42,0.00,0.00,0.00,true,835172.42,Deudora,,, 157-01-048 CAMIONETA AUDI 6 CILINDROS 2017,157-01-048,,2340388000003219064,fixed_asset,518508.63,0.00,0.00,0.00,true,518508.63,Deudora,,, 157-01-049 AUTO AUDI 4 CILINDROS 2017,157-01-049,,2340388000003219071,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 157-01-050 KIA MOTORS,157-01-050,,2340388000003219078,fixed_asset,570603.44,0.00,0.00,0.00,true,570603.44,Deudora,,, 157-01-051 MOTO SCOTTER TERRA 150CC,157-01-051,,2340388000003219085,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 157-01-052 AUDI 2019,157-01-052,,2340388000029266351,fixed_asset,1142375.00,0.00,0.00,0.00,true,1142375.00,Deudora,,, 157-01-053 AUDI A7 HYBRID,157-01-053,,2340388000029266378,fixed_asset,908492.24,0.00,0.00,0.00,true,908492.24,Deudora,,, 157-01-054 SEAT ATECA 2022,157-01-054,,2340388000029266385,fixed_asset,513706.90,0.00,0.00,0.00,true,513706.90,Deudora,,, 157-01-055 CHEVROLET SUBURBAN HIGH COUNTRY,157-01-055,,2340388000029266394,fixed_asset,1489741.38,0.00,0.00,0.00,true,1489741.38,Deudora,,, 157-01-056 VENTO STARTLINE 1.6 L,157-01-056,,2340388000022893456,fixed_asset,256397.41,0.00,0.00,0.00,true,256397.41,Deudora,,, 157-01-057  HONDA CRV TOURING CVT,157-01-057,,2340388000033479425,fixed_asset,706810.35,0.00,0.00,0.00,true,706810.35,Deudora,,, 157-01-058 Highlander 2025 RAE,157-01-058,"Unidad TOYOTA Highlander LTD HEV Modelo:2025 No Motor:A25-ARD09147",2340388000068364298,fixed_asset,972700.00,0.00,0.00,0.00,true,972700.00,Deudora,,, 158-00-000 EQUIPO DE COMPUTO,158-00-000,,2340388000003219092,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,156, 158-01-000 EQUIPO DE COMPUTO,158-01-000,,2340388000033392678,fixed_asset,45914.75,0.00,0.00,0.00,true,45914.75,Deudora,Detalle,156.01, 158-01-008 ADQUISICIONES 2001,158-01-008,,2340388000003219099,fixed_asset,65713.40,0.00,0.00,0.00,true,65713.40,Deudora,,, 158-01-012 ADQUISICIONES 2004,158-01-012,,2340388000003219106,fixed_asset,75336.88,0.00,0.00,0.00,true,75336.88,Deudora,,, 158-01-013 ADQUICISIONES 2005,158-01-013,,2340388000003219113,fixed_asset,272314.68,0.00,0.00,0.00,true,272314.68,Deudora,,, 158-01-014 ADQUICISIONES 2006,158-01-014,,2340388000003219120,fixed_asset,104761.20,0.00,0.00,0.00,true,104761.20,Deudora,,, 158-01-015 ADQUICISIONES 2007,158-01-015,,2340388000003219127,fixed_asset,58522.01,0.00,0.00,0.00,true,58522.01,Deudora,,, 158-01-016 ADQUICISIONES 2008,158-01-016,,2340388000003219134,fixed_asset,161512.02,0.00,0.00,0.00,true,161512.02,Deudora,,, 158-01-017 ADQUICISIONES 2009,158-01-017,,2340388000003219141,fixed_asset,51752.04,0.00,0.00,0.00,true,51752.04,Deudora,,, 158-01-018 ADQUICISIONES 2010,158-01-018,,2340388000003219148,fixed_asset,151925.78,0.00,0.00,0.00,true,151925.78,Deudora,,, 158-01-019 ADQUICISIONES 2011,158-01-019,,2340388000003219155,fixed_asset,1850384.96,0.00,0.00,0.00,true,1850384.96,Deudora,,, 158-01-020 ADQUICISIONES 2012,158-01-020,,2340388000003219162,fixed_asset,471738.59,0.00,0.00,0.00,true,471738.59,Deudora,,, 158-01-021 ADQUICISIONES 2013,158-01-021,,2340388000003219169,fixed_asset,644759.35,0.00,0.00,0.00,true,644759.35,Deudora,,, 158-01-022 ADQUICISIONES 2014,158-01-022,,2340388000003219176,fixed_asset,356644.16,0.00,0.00,0.00,true,356644.16,Deudora,,, 158-01-023 ADQUICISIONES 2015,158-01-023,,2340388000003219183,fixed_asset,73335.62,0.00,0.00,0.00,true,73335.62,Deudora,,, 158-01-024 ADQUISICIONES 2016,158-01-024,,2340388000003219190,fixed_asset,457979.52,0.00,0.00,0.00,true,457979.52,Deudora,,, 158-01-025 ADQUISICIONES 2017,158-01-025,,2340388000003219197,fixed_asset,255356.38,0.00,0.00,0.00,true,255356.38,Deudora,,, 158-01-026 ADQUISICIONES 2018,158-01-026,,2340388000003219204,fixed_asset,529972.86,0.00,0.00,0.00,true,529972.86,Deudora,,, 158-01-027 ADQUICISIONES 2019,158-01-027,,2340388000029266405,fixed_asset,507494.03,0.00,0.00,0.00,true,507494.03,Deudora,,, 158-01-028 ADQUISICIONES 2020,158-01-028,,2340388000029266412,fixed_asset,80319.00,0.00,0.00,0.00,true,80319.00,Deudora,,, 158-01-029 ADQUISICIONES 2021,158-01-029,,2340388000028722054,fixed_asset,424185.71,0.00,0.00,0.00,true,424185.71,Deudora,,, 158-01-030 ADQUISICIONES 2022,158-01-030,,2340388000028819330,fixed_asset,59818.27,0.00,0.00,0.00,true,59818.27,Deudora,,, 158-01-031 ADQUISICIONES 2023,158-01-031,,2340388000033473485,fixed_asset,386041.37,0.00,0.00,0.00,true,386041.37,Deudora,,, 159-00-000 MAQUINARIA Y EQUIPO,159-00-000,,2340388000003219211,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,153, 159-01-000 MAQUINARIA Y EQUIPO,159-01-000,,2340388000003219218,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,153.01, 159-01-001 PLANTA DE ENERGIA,159-01-001,,2340388000029266419,fixed_asset,34746.54,0.00,0.00,0.00,true,34746.54,Deudora,,, 166-00-000 DEP'N ACUM. MOBILIARIO Y EQUIPO,166-00-000,,2340388000003219225,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Acreedora,Acumulativa,171, 166-01-000 DEP'N ACUM. MOBILIARIO Y EQUIPO,166-01-000,,2340388000003219232,fixed_asset,-11582449.64,57677.12,0.00,-57677.12,false,-11640126.76,Acreedora,Detalle,171.04, 167-00-000 DP'N ACUM.DE EQUIPO DE TRANSPORTE,167-00-000,,2340388000003219239,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Acreedora,Acumulativa,171, 167-01-000 DP'N ACUM.DE EQUIPO DE TRANSPORTE,167-01-000,,2340388000003219246,fixed_asset,-8707140.82,15671.24,518508.63,502837.39,true,-8204303.43,Deudora,Detalle,171.03, 168-00-000 DEP'N ACUM. EQUIPO DE COMPUTO,168-00-000,,2340388000003219253,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Acreedora,Acumulativa,171, 168-01-000 DEP'N ACUM. EQUIPO DE COMPUTO,168-01-000,,2340388000003219260,fixed_asset,-7999600.94,69144.63,0.00,-69144.63,false,-8068745.57,Acreedora,Detalle,171.05, 169-00-000 DEP'N ACUM. MAQUINARIA Y EQUIPO,169-00-000,,2340388000003219267,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Acreedora,Acumulativa,171, 169-01-000 DEP'N ACUM. MAQUINARIA Y EQUIPO,169-01-000,,2340388000003219274,fixed_asset,-34746.55,0.00,0.00,0.00,true,-34746.55,Acreedora,Detalle,171.02, 190-00-000 MEJORAS EN LOCALES ARRENDADOS,190-00-000,,2340388000003219281,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Acumulativa,170, 190-01-000 MEJORAS EN LOCALES ARRENDADOS,190-01-000,,2340388000033392819,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,170.01, 190-01-001 ADAPTACIONES Y MEJORAS 1994,190-01-001,,2340388000003219288,fixed_asset,257123.45,0.00,0.00,0.00,true,257123.45,Deudora,,, 190-01-002 ADAPTACIONES Y MEJORAS 1995,190-01-002,,2340388000003219295,fixed_asset,48273.21,0.00,0.00,0.00,true,48273.21,Deudora,,, 190-01-003 ADAPTACIONES Y MEJORAS 1996,190-01-003,,2340388000003219302,fixed_asset,222912.21,0.00,0.00,0.00,true,222912.21,Deudora,,, 190-01-004 ADAPTACIONES Y MEJORAS 1997,190-01-004,,2340388000003219309,fixed_asset,180063.96,0.00,0.00,0.00,true,180063.96,Deudora,,, 190-01-005 ADAPTACIONES Y MEJORAS 1998,190-01-005,,2340388000003219316,fixed_asset,1223658.14,0.00,0.00,0.00,true,1223658.14,Deudora,,, 190-01-006 ADAPTACIONES Y MEJORAS 1999,190-01-006,,2340388000003219323,fixed_asset,1116537.84,0.00,0.00,0.00,true,1116537.84,Deudora,,, 190-01-007 ADAPTACIONES Y MEJORAS 2000,190-01-007,,2340388000003219330,fixed_asset,47994.74,0.00,0.00,0.00,true,47994.74,Deudora,,, 190-01-008 ADAPTACIONES Y MEJORAS 2001,190-01-008,,2340388000003219337,fixed_asset,197450.99,0.00,0.00,0.00,true,197450.99,Deudora,,, 190-01-009 ADAPTACIONES Y MEJORAS 2002,190-01-009,,2340388000003219344,fixed_asset,36091.64,0.00,0.00,0.00,true,36091.64,Deudora,,, 190-01-012 ADAPTACIONES Y MEJORAS 2006,190-01-012,,2340388000003219351,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-01-013 ADAPTACIONES Y MEJORAS 2007,190-01-013,,2340388000003219358,fixed_asset,-0.60,0.00,0.00,0.00,true,-0.60,Deudora,,, 190-01-014 ADAPTACIONES Y MEJORAS 2008,190-01-014,,2340388000003219365,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-01-015 ADAPTACIONES 2009,190-01-015,,2340388000003219372,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-01-016 ADAPTACIONES Y MEJORAS 2010,190-01-016,,2340388000003219379,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-01-018 ADAPTACIONES Y MEJORAS 2011,190-01-018,,2340388000003219386,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-01-019 ADAPTACIONES Y MEJORAS 2012,190-01-019,,2340388000003219393,fixed_asset,13176.28,0.00,0.00,0.00,true,13176.28,Deudora,,, 190-01-020 ADAPTACIONES 2013,190-01-020,,2340388000003219400,fixed_asset,7176554.25,0.00,0.00,0.00,true,7176554.25,Deudora,,, 190-01-021 ADAPTACIONES 2014,190-01-021,,2340388000003219407,fixed_asset,6542737.19,0.00,0.00,0.00,true,6542737.19,Deudora,,, 190-01-022 ADAPTACIONES 2015,190-01-022,,2340388000003219414,fixed_asset,3940483.69,0.00,0.00,0.00,true,3940483.69,Deudora,,, 190-01-023 ADAPTACIONES 2016,190-01-023,,2340388000003219421,fixed_asset,14676181.63,0.00,0.00,0.00,true,14676181.63,Deudora,,, 190-01-024 ADAPTACIONES 2017,190-01-024,,2340388000003219428,fixed_asset,3069113.72,0.00,0.00,0.00,true,3069113.72,Deudora,,, 190-01-025 ADAPTACIONES 2018,190-01-025,,2340388000003219435,fixed_asset,4838314.26,0.00,0.00,0.00,true,4838314.26,Deudora,,, 190-01-026 ADAPTACIONES 2019,190-01-026,,2340388000029266426,fixed_asset,353753.85,0.00,0.00,0.00,true,353753.85,Deudora,,, 190-01-027 ADAPTACIONES 2025,190-01-027,,2340388000086281397,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-01-028 Adaptaciones y Mejoras 2026,190-01-028,Adaptaciones a Locales Arrendados 2026,2340388000088375635,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,, 190-03-000 MOJORAS EN LOCAL GUADALAJARA,190-03-000,,2340388000033392880,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,170.01, 190-03-001 MEJORAS 1998,190-03-001,,2340388000003219442,fixed_asset,4910.00,0.00,0.00,0.00,true,4910.00,Deudora,,, 190-10-000 ADECUACIONES INSURGENTES SUR,190-10-000,,2340388000033392889,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,170.01, 190-10-001 37834,190-10-001,,2340388000003219449,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-10-002 37895,190-10-002,,2340388000003219456,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-10-003 37926,190-10-003,,2340388000003219463,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-10-005 37987,190-10-005,,2340388000003219470,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 190-11-000 ADECUACIONES INSURGENTES SUR 1605-1,190-11-000,,2340388000033392904,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,Detalle,170.01, 190-11-001 ADECUACIONES 2004,190-11-001,,2340388000003219477,fixed_asset,0.00,0.00,0.00,0.00,true,0.00,Deudora,,, 191-00-000 BODEGA,191-00-000,,2340388000003219484,fixed_asset,8000.00,0.00,0.00,0.00,true,8000.00,Deud "300", "message" => "ERROR - [wsInvoiceSF] Parametros incompletos para el Servicio Web, faltan el Propoietario de la Aplicación"); $Resultado = json_encode($j_array); echo $Resultado; return; } if($bRecId == "") { $j_array = array('code' => "300", "message" => "ERROR - [wsCancelAsyncInvoiceSFJ_v33] Parametros incompletos para el Servicio Web, faltan el ID del CFDI a actualizar"); $Resultado = json_encode($j_array); echo $Resultado; return; } if($bDatPAC == "") { $j_array = array('code' => "300", "message" => "ERROR - [wsCancelAsyncInvoiceSFJ_v33] Parametros incompletos para el Servicio Web, faltan los Datos del PAC"); $Resultado = json_encode($j_array); echo $Resultado; return; } ### 0. EXTRACCION DE PARAMETROS PARA EL CFDI ###################################################### #== Primero, extraemos el JSON del string en base 64 echo $bDatPAC; $bdDatPAC = base64_decode($bDatPAC); echo "decode"; echo $bdDatPAC; #== Segundo, decodificamos el JSON a un arreglo $abdDatPAC = json_decode($bdDatPAC,true); $dirBase = realpath("../"); # Configuración de zona horaria date_default_timezone_set('America/Mexico_City'); // ### DEFINICIÓN DE CONSTANTES ################################################### $SendaPEMS = "archs_pem/"; $SendaCFDI = "archs_cfdi/"; // Datos de acceso del usuario (proporcionados por el PAC). if($abdDatPAC["tipoTim"] == 1){ ## Timbrado en producción $urlPAC = "https://solucionfactible.com/ws/services/Cancelacion?wsdl"; } else { ## Timbrado en pruebas $urlPAC = "https://testing.solucionfactible.com/ws/services/Cancelacion?wsdl"; } // Datos para la configuracion del SOAP y los resultados. $username = $abdDatPAC["username"]; $password = $abdDatPAC["password"]; $bdUUID = $abdDatPAC["UUID"]; $fact_serie = $abdDatPAC["serie"]; $fact_folio = $abdDatPAC["folio"]; $invoiceNumber = $abdDatPAC["invoice"]; $invoiceID = $abdDatPAC["invoiceID"]; $RfcEmisor = $abdDatPAC["RfcEmi"]; // Datos "constantes" para los archivos CER y KEY del cliente $noCertificado = $abdDatPAC["Certificado_SAT"]; $file_cer = $abdDatPAC["Archivo_CER"]; $file_key = $abdDatPAC["Archivo_KEY"]; $clavePrivada = $abdDatPAC["Clave_Privada"]; $organi_id_ZB = $abdDatPAC["organization_id_ZB"]; $authtoken_ZB = $abdDatPAC["authtoken_ZB"]; $authtoken_ZC = $abdDatPAC["authtoken_ZC"]; // Leemos el archivo CER del cliente $nombre_fichero = $SendaPEMS.$file_cer; $gestor = fopen($nombre_fichero, "r"); $cerFile = fread($gestor, filesize($nombre_fichero)); fclose($gestor); // Leemos el archivo KEY del cliente $nombre_fichero = $SendaPEMS.$file_key; $gestor = fopen($nombre_fichero, "r"); $keyFile = fread($gestor, filesize($nombre_fichero)); fclose($gestor); // Conversion de los archivos CER y KEY leidos a formato Base64 $bCertB64 = base64_encode($cerFile); $bKeyB64 = base64_encode($keyFile); /* echo "Tipo Timbrado: ".$abdDatPAC["tipoTim"]; echo "
"; echo "username: ".$username; echo "
"; echo "password: ".$password; echo "
"; echo "bdUUID: ".$bdUUID; echo "
"; echo "Motivo: ".$motCancela; echo "
"; echo "UUID Sust: ".$uuidSustit; echo "
"; echo "fact_serie: ".$fact_serie; echo "
"; echo "fact_folio: ".$fact_folio; echo "
"; echo "invoiceNumber: ".$invoiceNumber; echo "
"; echo "invoiceID: ".$invoiceID; echo "
"; echo "RfcEmisor: ".$RfcEmisor; echo "
"; echo "urlPAC: ".$urlPAC; echo "
"; echo "file_cer: ".$SendaPEMS.$file_cer; echo "
"; echo "bCertB64: ".$bCertB64; echo "
"; echo "file_key: ".$SendaPEMS.$file_key; echo "
"; echo "bKeyB64: ".$bKeyB64; echo "
"; echo "
"; */ ### PROCESO DE CACELACION ######################################################## $response = ''; // Datos para la localización del WebService para resolución del WSDL. if($abdDatPAC["tipoTim"] == 1){ ## Timbrado en producción $urlLocation = 'https://solucionfactible.com/ws/services/Cancelacion'; } else { ## Timbrado en pruebas $urlLocation = 'https://testing.solucionfactible.com/ws/services/Cancelacion'; } #== Se lleva a cabo cancelacion del CFDI ============================ try { $client = new SoapClient($urlPAC); $client->__setLocation($urlLocation); //JFA: Cambio por SF para enviar el motivo de cancelacion $params = array('usuario' => $username, 'password' => $password, 'uuid' => $bdUUID . $motCancela . $uuidSustit, 'rfcEmisor' => $RfcEmisor, 'emailNotifica' => "", 'derCertCSDBase64' => $bCertB64, 'derKeyCSDBase64' => $bKeyB64, 'contrasenaCSD' => $clavePrivada, 'properties' => ""); $response = $client->__soapCall('cancelarAsincrono', array('parameters' => $params)); } catch (SoapFault $fault) { $j_array = array('code' => "900", "message" => "Error al ejecutar el WebService del PAC (SOAP)", 'status' => $fault->faultcode,'mensaje' => $fault->faultstring); //$j_array = array('code' => "900", "message" => $fault->faultcode."-".$fault->faultstring); $Resultado = json_encode($j_array); echo $Resultado; return; } /* print_r($response); echo "
"; echo "
"; */ $ret = $response->return; if($ret->status != 200) { $sErrMsg = $ret->mensaje; /* switch ($ret->status) { case 204: $sErrMsg = "El comprobante no se puede cancelar"; case 211: $sErrMsg = "La cancelación está en proceso"; case 213: $sErrMsg = "La solicitud de cancelación fue rechazada por el receptor"; case 303: $sErrMsg = "El certificado CSD no corresponde al RFC del contribuyente."; case 305: $sErrMsg = "La fecha de cancelación no está dentro del la vigencia del CSD del emisor."; case 306: $sErrMsg = "Las llaves utilizadas para sellar no corresponden a un CSD."; case 308: $sErrMsg = "El certificado CSD no fue emitido por la Autoridad de SAT."; case 402: $sErrMsg = "El RFC del contribuyente no existe conforme al régimen autorizado LCO."; case 500: $sErrMsg = "Han ocurrido errores internos que han impedido que se registre la solicitud de cancelación, reintentar."; case 501: $sErrMsg = "Ha ocurrido un error interno de comunicación con la base de datos, reintentar."; case 601: $sErrMsg = "Error de autenticación, el nombre de usuario o contraseña son incorrectos."; case 602: $sErrMsg = "La cuenta de usuario se encuentra bloqueada."; case 603: $sErrMsg = "La contraseña de la cuenta ha expirado."; case 604: $sErrMsg = "Se ha superado el número máximo permitido de intentos fallidos de autenticación."; case 605: $sErrMsg = "El usuario se encuentra inactivo."; case 611: $sErrMsg = "Los datos recibidos están incompletos o no se encuentran donde se esperarían."; case 620: $sErrMsg = "Permiso denegado."; case 621: $sErrMsg = "Los datos recibidos no son válidos."; case 633: $sErrMsg = "Uso indebido de cuenta de producción en pruebas o cuenta de prueba en producción."; case 701: $sErrMsg = "Ya existe una transacción asíncrona para el UUID especificado."; } */ $j_array = array('code' => "901", "message" => "Se presento un problema al momento de realizar la cancelación. ", 'status' => $ret->status,'mensaje' => $sErrMsg); $Resultado = json_encode($j_array); echo $Resultado; return; } $RespServ = $ret; $j_array = array('code' => "200", "message" => "Proceso de cancelacion de CFDI fue exitoso", 'status' => $ret->status, 'mensaje' => $ret->mensaje); $Resultado = json_encode($j_array); echo $Resultado; return;