2026 09 15 09:33:54 basdat
2026 09 15 09:37:07 {"status":"success","message":"Cuentas procesadas correctamente","accounts_errors":[]}
2026 09 15 09:37:08 200 OK Cron -> BD ->basdat -> datos_enviados => {"Clientes":[{"country_code":"CO","customer_code":"20885823","email":"multiserviciosyrepuestosavila@hotmail.com","email_fe":"multiserviciosyrepuestosavila@hotmail.com","first_surname":"BOHORQUEZ","second_surname":"DE AVILA","first_name":"MARIA","second_name":"DEL CARMEN","complete_name":"BOHORQUEZ DE AVILA MARIA DEL CARMEN","phone":"3118772636","phone2":"3123915649","fax_number":"","mobile_number":"3115389018","address":"CR 7 NO 5-127 BARRIO JUAN 23","city_code":"73001","city_name":"IBAGUE","department_code":"73","department_name":"TOLIMA","country":"169","name_country":"COLOMBIA","region_code":"006","region_name":"TOLIMA HUILA","customer_type":"PAR","seller_code":"IB3","seller_name":"PALACIOS DAWER","seller_email":"dpalacios@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2016-11-16","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2021-03-31","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2022-10-10","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"multiserviciosyrepuestosavila@hotmail.com","discount":"26.50","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"243","last_update_quota":"2026-06-25","date_first_sale":"2016-11-30","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281362"},{"country_code":"CO","customer_code":"3210260","email":null,"email_fe":"luissegus@hotmail.com","first_surname":"CAMACHO","second_surname":"HERNANDEZ","first_name":"LUIS SEGUNDO","second_name":"","complete_name":"CAMACHO HERNANDEZ LUIS SEGUNDO","phone":"","phone2":"","fax_number":"","mobile_number":"3204980501","address":"CALLE 69C N\u00b0 22-66 SUR","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"PAR","seller_code":"BT48","seller_name":"PENAGOS VELOZA DAVID ESTEBAN","seller_email":"dpenagos@automundial.com.co","invoice_period":"39","bill_rejects":"N","bill_secure":"N","creation_date":"2018-01-10","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-08-13","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"EMPLEADO AUTOMUNDIAL","email_contact":null,"discount":"25.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"1017","last_update_quota":"2026-06-25","date_first_sale":"2018-01-10","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281363"},{"country_code":"CO","customer_code":"13377235","email":null,"email_fe":"fguerreros331@gmail.com","first_surname":"","second_surname":"","first_name":"GUERRERO SALAZAR FREDY","second_name":"","complete_name":"GUERRERO SALAZAR FREDY","phone":"3157453556","phone2":"","fax_number":"","mobile_number":"","address":"VERSALLES CAMPESTRE MANZANA 6 CASA 24","city_code":"68276","city_name":"FLORIDABLANCA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG32","seller_name":"LEON SILVA SANDY BIAN","seller_email":"sleon@automundial.com.co","invoice_period":"39","bill_rejects":"N","bill_secure":"N","creation_date":"2016-10-13","status":"Q","status_name":"CONTADO SIN CANCELAR","observation":"","last_invoice_date":"2024-02-12","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"30.50","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"60","last_update_quota":"2026-06-25","date_first_sale":"2016-10-21","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88281361"},{"country_code":"CO","customer_code":"74180481","email":"contabilidad@cooflonorte.com","email_fe":"contabilidad@cooflonorte.com","first_surname":"VERGARA","second_surname":"DIAZ","first_name":"JHONN","second_name":"WILSON","complete_name":"VERGARA DIAZ JHONN WILSON","phone":"6783193","phone2":"2270028","fax_number":"","mobile_number":"","address":"CARRERA 65 NO. 165-40","city_code":"15759","city_name":"SOGAMOSO","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYH","seller_name":"HIGUERA BOLIVAR LADY DIAHANN","seller_email":"lhiguera@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"S","creation_date":"2007-09-26","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"DOCUMENTOS COMPLETOS-AVAL FENALCO, PDTE DATACREDITO.","last_invoice_date":"2021-12-21","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"contabilidad@cooflonorte.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"5198","last_update_quota":"2026-06-25","date_first_sale":"2007-09-28","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281347"},{"country_code":"CO","customer_code":"891401699","email":null,"email_fe":"cotransb@hotmail.com","first_surname":"","second_surname":"","first_name":"COOP.DE TRANSPORTADORES DE BELEN DE UMBRIA","second_name":"","complete_name":"COOP.DE TRANSPORTADORES DE BELEN DE UMBRIA","phone":"3116306627","phone2":"3528243","fax_number":"","mobile_number":"3216453616","address":"TV 9 1-103 EDS COTTRANSBEL","city_code":"66088","city_name":"BELEN DE UMBRIA","department_code":"66","department_name":"RISARALDA","country":"169","name_country":"COLOMBIA","region_code":"008","region_name":"VIEJO CALDAS","customer_type":"DIS","seller_code":"PE11","seller_name":"LADINO CHIQUITO CLISSMAN LEA","seller_email":"cladino@automundial.com.co","invoice_period":"01","bill_rejects":null,"bill_secure":null,"creation_date":"2010-03-19","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2021-03-31","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"MARIA ROCIO ZULUAGA","email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"161","last_update_quota":"2026-06-25","date_first_sale":"2010-03-19","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281360"},{"country_code":"CO","customer_code":"74381570","email":"vialrefo@hotmail.com","email_fe":"vialrefo@hotmail.com","first_surname":"REYES","second_surname":"FORERO","first_name":"VICTOR","second_name":"ALFONSO","complete_name":"REYES FORERO VICTOR ALFONSO","phone":"","phone2":"","fax_number":"","mobile_number":"3108622991","address":"CL 34 16 44","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYK","seller_name":"CORTES CARLOS ARTURO","seller_email":"ccortes@automundial.com.co","invoice_period":"03","bill_rejects":"S","bill_secure":"N","creation_date":"2017-12-18","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-12-02","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2023-08-04","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"vialrefo@hotmail.com","discount":"43.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"114","last_update_quota":"2026-06-25","date_first_sale":"2021-07-31","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88281345"},{"country_code":"CO","customer_code":"74380687","email":"cesar.silva@coflonorte.com","email_fe":"cesar.silvap@outlook.com","first_surname":"SILVA","second_surname":"PEREZ","first_name":"CESAR","second_name":"ELISEO","complete_name":"SILVA PEREZ CESAR ELISEO","phone":"","phone2":"","fax_number":"","mobile_number":"3102655368","address":"CR 9 14 19","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYK","seller_name":"CORTES CARLOS ARTURO","seller_email":"ccortes@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"S","creation_date":"2016-09-13","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-02-17","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"20000000.00","actualization_date":"2023-08-04","average_sales":"2696509.666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"SILVA PEREZ CESAR ELISEO","email_contact":"cesar.silva@coflonorte.com","discount":"43.00","contado":"2733200.02","por_vencer":"0.0","vencido":"2733200.02","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"1366600.01","mas_de_120_dias":"1366600.01","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"2","days_before_last_invoice":"1","last_update_quota":"2026-06-25","date_first_sale":"2016-12-30","payment_method_rf":"S","customer_category":"A","type_record":"UPDATE","idmovimiento":"88281119"},{"country_code":"CO","customer_code":"4242913","email":"raulmedina2010@live.com","email_fe":"raulmedina2010@live.com","first_surname":"MEDINA","second_surname":"GARCIA","first_name":"RAUL","second_name":"","complete_name":"MEDINA GARCIA RAUL","phone":"","phone2":"","fax_number":"","mobile_number":"3102574545","address":"CR 1 B 6 A 15","city_code":"15693","city_name":"SANTA ROSA DE VITERBO","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYK","seller_name":"CORTES CARLOS ARTURO","seller_email":"ccortes@automundial.com.co","invoice_period":"03","bill_rejects":"N","bill_secure":"N","creation_date":"2016-05-10","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-10-25","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.66666666666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"MEDINA GARCIA RAUL","email_contact":"raulmedina2010@live.com","discount":"43.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"116","last_update_quota":"2026-06-25","date_first_sale":"2016-06-09","payment_method_rf":"N","customer_category":"B","type_record":"UPDATE","idmovimiento":"88281118"},{"country_code":"CO","customer_code":"7217847","email":"nohoramanchego@hotmail.com","email_fe":"nohoramanchego@hotmail.com","first_surname":"MANOSALVA","second_surname":"MANOSALVA","first_name":"NELSON","second_name":"RENE","complete_name":"MANOSALVA MANOSALVA NELSON RENE","phone":"","phone2":"","fax_number":"","mobile_number":"3105702568","address":"CL 7 CR 28 C 02","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYK","seller_name":"CORTES CARLOS ARTURO","seller_email":"ccortes@automundial.com.co","invoice_period":"03","bill_rejects":"S","bill_secure":"N","creation_date":"2017-12-18","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-06-24","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2023-06-17","average_sales":"114833.16666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"nohoramanchego@hotmail.com","discount":"43.00","contado":"1377998.0","por_vencer":"0.0","vencido":"1377998.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"1377998.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"1","days_before_last_invoice":"716","last_update_quota":"2026-06-25","date_first_sale":"2019-04-30","payment_method_rf":"N","customer_category":"B","type_record":"UPDATE","idmovimiento":"88281117"},{"country_code":"CO","customer_code":"7214336","email":"carolinatiria@gmail.com","email_fe":"carolinatiria@gmail.com","first_surname":"TIRIA","second_surname":"GONZALEZ","first_name":"ISRAEL","second_name":"","complete_name":"TIRIA GONZALEZ ISRAEL","phone":"","phone2":"","fax_number":"","mobile_number":"3208405099","address":"CL 18 2 19","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYL","seller_name":"PEDRAZA GLORIA MERCEDES","seller_email":"gpedraza@automundial.com.co","invoice_period":"07","bill_rejects":"N","bill_secure":"S","creation_date":"2018-01-24","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-09-06","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"10000000.00","actualization_date":"2022-11-08","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"BLANCA PAEZ","email_contact":"carolinatiria@gmail.com","discount":"30.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"36","last_update_quota":"2026-06-25","date_first_sale":"2018-02-01","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281116"},{"country_code":"CO","customer_code":"7213550","email":"adripinzonm@hotmail.com","email_fe":"adripinzonm@hotmail.com","first_surname":"PINZON","second_surname":"","first_name":"JULIO","second_name":"","complete_name":"PINZON  JULIO","phone":"","phone2":"","fax_number":"","mobile_number":"3102388394","address":"CR 45 4 107","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYK","seller_name":"CORTES CARLOS ARTURO","seller_email":"ccortes@automundial.com.co","invoice_period":"03","bill_rejects":"N","bill_secure":"N","creation_date":"2016-08-20","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2025-05-13","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2023-05-23","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"PINZON JULIO","email_contact":"adripinzonm@hotmail.com","discount":"43.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"257","last_update_quota":"2026-06-25","date_first_sale":"2016-08-31","payment_method_rf":"N","customer_category":"B","type_record":"UPDATE","idmovimiento":"88281115"},{"country_code":"CO","customer_code":"79306421","email":"luis.chaparro421@gmail.com","email_fe":"luis.chaparro421@gmail.com","first_surname":"CHAPARRO","second_surname":"MERCHAN","first_name":"LUIS","second_name":"EDUARDO","complete_name":"CHAPARRO MERCHAN LUIS EDUARDO","phone":"3185481742","phone2":"","fax_number":"","mobile_number":"3185481742","address":"CALLE 54 # 10C-131 PISO 2","city_code":"15759","city_name":"SOGAMOSO","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYL","seller_name":"PEDRAZA GLORIA MERCEDES","seller_email":"gpedraza@automundial.com.co","invoice_period":"07","bill_rejects":"N","bill_secure":"N","creation_date":"2019-08-17","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-01-31","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"8000000.00","actualization_date":null,"average_sales":"2406541.333333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"LUIS EDUARDO CHAPARRO","email_contact":"luis.chaparro421@gmail.com","discount":"26.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"2","last_update_quota":"2026-06-25","date_first_sale":"2019-09-11","payment_method_rf":"S","customer_category":"A","type_record":"UPDATE","idmovimiento":"88281114"},{"country_code":"CO","customer_code":"830057706","email":null,"email_fe":"FacturaElectronicaCO@la-bridgestone.com","first_surname":"","second_surname":"","first_name":"BRIDGESTONE DE COLOMBIA S.A.S.","second_name":"","complete_name":"BRIDGESTONE DE COLOMBIA S.A.S.","phone":"6544000","phone2":"6544005","fax_number":"","mobile_number":"","address":"CALLE 26 NO.92-32 BLOQUE G2 PISO 2 OFC 2-115","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"IND","seller_code":"BTI","seller_name":"GERENCIA REGIONAL CENTRO","seller_email":"cagarcia@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2020-08-20","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-05-27","contributory_code":"1","contributory_name":"GRANDES CONTRIBUYENTES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"S","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.41","por_vencer":"0.0","vencido":"0.41","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.41","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"1","days_before_last_invoice":"42","last_update_quota":"2026-06-25","date_first_sale":"2020-08-27","payment_method_rf":"N","customer_category":"A","type_record":"UPDATE","idmovimiento":"88281113"},{"country_code":"CO","customer_code":"91489920","email":null,"email_fe":"jaimebriceno21@gmail.com","first_surname":"QUIROGA","second_surname":"","first_name":"CARLOS","second_name":"EDUARDO","complete_name":"QUIROGA  CARLOS EDUARDO","phone":"3215470281","phone2":"","fax_number":"","mobile_number":"","address":"CALLE REAL 5-84 CASA 8 CIUDADELA REAL DE MINAS","city_code":"68001","city_name":"BUCARAMANGA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG29","seller_name":"HOYOS MIGUEL ANGEL","seller_email":"mhoyos@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2019-05-24","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-10-21","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"164","last_update_quota":"2026-06-25","date_first_sale":"2019-06-19","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281112"},{"country_code":"CO","customer_code":"74183657","email":"cesarfc749@hotmail.com","email_fe":"cesarfc749@hotmail.com","first_surname":"FONSECA","second_surname":"CAMACHO","first_name":"JULIO","second_name":"CESAR","complete_name":"FONSECA CAMACHO JULIO CESAR","phone":"","phone2":"","fax_number":"","mobile_number":"3107932712","address":"CL 34 16 44","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYK","seller_name":"CORTES CARLOS ARTURO","seller_email":"ccortes@automundial.com.co","invoice_period":"03","bill_rejects":"N","bill_secure":"N","creation_date":"2017-07-07","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-04-22","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2023-07-07","average_sales":"114833.16666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"FONSECA JULIO","email_contact":"cesarfc749@hotmail.com","discount":"43.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"236","last_update_quota":"2026-06-25","date_first_sale":"2017-11-29","payment_method_rf":"N","customer_category":"A","type_record":"UPDATE","idmovimiento":"88281346"},{"country_code":"CO","customer_code":"7503618","email":null,"email_fe":"oscarojas04@gmail.com","first_surname":"PULECIO","second_surname":"","first_name":"ANIBAL","second_name":"","complete_name":"PULECIO  ANIBAL","phone":"7462687","phone2":"","fax_number":"","mobile_number":"","address":"CR 16 10N-28 PROVIDENCIA","city_code":"63001","city_name":"ARMENIA","department_code":"63","department_name":"QUINDIO","country":"169","name_country":"COLOMBIA","region_code":"008","region_name":"VIEJO CALDAS","customer_type":"PAR","seller_code":"PE20","seller_name":"RICARDO MARIN","seller_email":"rmarin@automundial.com.co","invoice_period":"01","bill_rejects":null,"bill_secure":null,"creation_date":"2005-08-26","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"CON DOCUMENTOS","last_invoice_date":"2022-03-31","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"FLO","contract_pcpk":"N","contact":"COOBURQUIN E INVERS. METROPOLI","email_contact":null,"discount":"20.70","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"296","last_update_quota":"2026-06-25","date_first_sale":"2005-09-21","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281111"},{"country_code":"CO","customer_code":"1005771985","email":"jared2548@gmail.com","email_fe":"jared2548@gmail.com","first_surname":"PEREZ","second_surname":"VASQUEZ","first_name":"JARED","second_name":"DAVID","complete_name":"PEREZ VASQUEZ JARED DAVID","phone":"","phone2":"","fax_number":"3115407493","mobile_number":"3107885181","address":"CLL 12  NO 10-24","city_code":"73268","city_name":"ESPINAL","department_code":"73","department_name":"TOLIMA","country":"169","name_country":"COLOMBIA","region_code":"006","region_name":"TOLIMA HUILA","customer_type":"PAR","seller_code":"IB3","seller_name":"PALACIOS DAWER","seller_email":"dpalacios@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2021-03-17","status":"M","status_name":"CREDITO CERRADO MAL MANEJO CAR","observation":"","last_invoice_date":"2023-07-12","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2022-09-14","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"jared2548@gmail.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"254","last_update_quota":"2026-06-25","date_first_sale":"2021-03-18","payment_method_rf":"S","customer_category":"","type_record":"UPDATE","idmovimiento":"88281107"},{"country_code":"CO","customer_code":"1073157722","email":"gustavoarboleda4@gmail.com","email_fe":"gustavoarboleda4@gmail.com","first_surname":"MURCIA","second_surname":"HERRERA","first_name":"DINEY","second_name":"","complete_name":"MURCIA HERRERA DINEY","phone":"3102588639","phone2":"3124858115","fax_number":"","mobile_number":"3124858115","address":"CLL 42 SUR # 37-03","city_code":"50001","city_name":"VILLAVICENCIO","department_code":"50","department_name":"META","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BT81","seller_name":"ABOGADO GRUPO CONCRED","seller_email":"","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2021-05-24","status":"C","status_name":"CLIENTE CON CARTERA CASTIGADA","observation":"","last_invoice_date":"2022-04-19","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"gustavoarboleda4@gmail.com","discount":"45.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"6","last_update_quota":"2026-06-25","date_first_sale":"2021-06-23","payment_method_rf":"S","customer_category":"","type_record":"UPDATE","idmovimiento":"88281110"},{"country_code":"CO","customer_code":"5969604","email":null,"email_fe":"mariaortiz050907@gmail.com","first_surname":"AROCA","second_surname":"ROJAS","first_name":"HENRY","second_name":"","complete_name":"AROCA ROJAS HENRY","phone":"","phone2":"","fax_number":"","mobile_number":"3223948947","address":"MZ 7 CSA 8 BARRIO BALKANES","city_code":"73268","city_name":"ESPINAL","department_code":"73","department_name":"TOLIMA","country":"169","name_country":"COLOMBIA","region_code":"008","region_name":"VIEJO CALDAS","customer_type":"PAR","seller_code":"PE20","seller_name":"RICARDO MARIN","seller_email":"rmarin@automundial.com.co","invoice_period":"39","bill_rejects":"S","bill_secure":"N","creation_date":"2021-10-08","status":"U","status_name":"DESBLOQUEO BASICO","observation":"","last_invoice_date":"2024-08-26","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"24","last_update_quota":"2026-06-25","date_first_sale":"2022-03-05","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88281109"},{"country_code":"CO","customer_code":"18514781","email":null,"email_fe":"granadajosericardo@gmail.com","first_surname":"GRANADA","second_surname":"","first_name":"JOSE","second_name":"RICARDO","complete_name":"GRANADA  JOSE RICARDO","phone":"3215955856","phone2":"","fax_number":"","mobile_number":"","address":"ZONA 1 CASA 92 DOS QUEBRADAS RISARALDA","city_code":"17616","city_name":"RISARALDA","department_code":"17","department_name":"CALDAS","country":"169","name_country":"COLOMBIA","region_code":"008","region_name":"VIEJO CALDAS","customer_type":"PAR","seller_code":"PE20","seller_name":"RICARDO MARIN","seller_email":"rmarin@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2022-01-25","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-03-31","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"29","last_update_quota":"2026-06-25","date_first_sale":"2022-01-27","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281108"},{"country_code":"CO","customer_code":"900475730","email":null,"email_fe":"facturacion@ariguani.com.co","first_surname":"","second_surname":"","first_name":"CONSTRUCTORA ARIGUANI S.A.S","second_name":"","complete_name":"CONSTRUCTORA ARIGUANI S.A.S","phone":"6203877","phone2":"6298985","fax_number":"","mobile_number":"","address":"CRA 45 N.122-56 OF 602","city_code":"20060","city_name":"BOSCONIA","department_code":"20","department_name":"CESAR","country":"169","name_country":"COLOMBIA","region_code":"005","region_name":"COSTA ATLANTICA","customer_type":"INF","seller_code":"BQ39","seller_name":"VIANNELA CASTRO","seller_email":"vcastro@automundial.com.co","invoice_period":"03","bill_rejects":"S","bill_secure":"N","creation_date":"2016-04-19","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-01-23","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"80000000.00","actualization_date":null,"average_sales":"6778850.75","mark":"S","branch":"S","branch_code":"","customer_group":"FCO","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"25.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"6","last_update_quota":"2026-06-25","date_first_sale":"2016-04-20","payment_method_rf":"N","customer_category":"AAA","type_record":"UPDATE","idmovimiento":"88281105"},{"country_code":"CO","customer_code":"74187897","email":"quintana289@yahoo.es","email_fe":"quintana289@yahoo.es","first_surname":"ALFONSO","second_surname":"ALVAREZ","first_name":"HOLMAN","second_name":"JAVIER","complete_name":"ALFONSO ALVAREZ HOLMAN JAVIER","phone":"","phone2":"","fax_number":"","mobile_number":"3115562526","address":"CR 28 B 21 40","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYK","seller_name":"CORTES CARLOS ARTURO","seller_email":"ccortes@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2020-01-29","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-03-31","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"JAVIER ALFONSO","email_contact":"quintana289@yahoo.es","discount":"28.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"21","last_update_quota":"2026-06-25","date_first_sale":"2020-01-29","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281104"},{"country_code":"CO","customer_code":"901354231","email":"llantasveraorozco@outlook.com","email_fe":"contabilidadmontallantasvera@gmail.com","first_surname":"","second_surname":"","first_name":"MONTALLANTAS VERA OROZCO S.A.S","second_name":"","complete_name":"MONTALLANTAS VERA OROZCO S.A.S","phone":"3138718322","phone2":"","fax_number":"","mobile_number":"3138718322","address":"ANILLO VIAL ORIENTAL NO 41 DE CENS","city_code":"54001","city_name":"CUCUTA","department_code":"54","department_name":"NORTE DE SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"DIS","seller_code":"BG43","seller_name":"JOSE LAZO","seller_email":"jlazo@automundial.com.co","invoice_period":"06","bill_rejects":"S","bill_secure":"S","creation_date":"2022-02-08","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-06-20","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"50000000.00","actualization_date":null,"average_sales":"20939953.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"JOSE DEL CARNMEN VERA.","email_contact":"llantasveraorozco@outlook.com","discount":"42.00","contado":"49711333.0","por_vencer":"0.0","vencido":"49711333.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"9180104.5","de_31_a_45_dias":"6559370.5","de_46_a_60_dias":"13748178.5","de_61_a_75_dias":"19990593.5","de_76_a_90_dias":"1078811.0","de_91_a_105_dias":"-845725.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"10","days_before_last_invoice":"3","last_update_quota":"2026-06-25","date_first_sale":"2022-02-16","payment_method_rf":"N","customer_category":"AAA","type_record":"UPDATE","idmovimiento":"88281103"},{"country_code":"CO","customer_code":"60411116","email":null,"email_fe":"asfaro71@hotmail.com","first_surname":"ROA","second_surname":"","first_name":"ASTRID","second_name":"FABIOLA","complete_name":"ROA  ASTRID FABIOLA","phone":"4676153","phone2":"","fax_number":"","mobile_number":"3125862918","address":"CONJUNTO RESIDENCIAL MAYORCA CASA 30","city_code":"54001","city_name":"CUCUTA","department_code":"54","department_name":"NORTE DE SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG43","seller_name":"JOSE LAZO","seller_email":"jlazo@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2019-10-10","status":"M","status_name":"CREDITO CERRADO MAL MANEJO CAR","observation":"","last_invoice_date":"2026-01-14","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"764166.41666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"41.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"168","last_update_quota":"2026-06-25","date_first_sale":"2019-10-10","payment_method_rf":"S","customer_category":"A","type_record":"UPDATE","idmovimiento":"88281102"},{"country_code":"CO","customer_code":"860069804","email":"recepcion.electronica@cerrejon.com.co","email_fe":"recepcion.cerrejon@factura1.com.co","first_surname":"","second_surname":"","first_name":"CARBONES DEL CERREJON LIMITED","second_name":"","complete_name":"CARBONES DEL CERREJON LIMITED","phone":"5952560","phone2":"","fax_number":"","mobile_number":"","address":"CALLE 100 NO 19-54 PISO 12 BGOTA","city_code":"44035","city_name":"ALBANIA - GUA","department_code":"44","department_name":"LA GUAJIRA","country":"169","name_country":"COLOMBIA","region_code":"005","region_name":"COSTA ATLANTICA","customer_type":"MIN","seller_code":"BT92","seller_name":"DANIEL SERRANO","seller_email":"dserrano@automundial.com.co","invoice_period":"05","bill_rejects":"N","bill_secure":"N","creation_date":"2011-08-16","status":"B","status_name":"CLIENTE ACTIVO","observation":"0","last_invoice_date":"2026-06-01","contributory_code":"1","contributory_name":"GRANDES CONTRIBUYENTES","assigned_quota":"0.00","actualization_date":null,"average_sales":"25970347.416666666666666666666667","mark":"S","branch":"S","branch_code":"","customer_group":"FCO","contract_pcpk":"N","contact":null,"email_contact":"recepcion.electronica@cerrejon.com.co","discount":"30.00","contado":"-95805391.0","por_vencer":"0.0","vencido":"-95805391.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"1759201.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"-97564592.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"1","days_before_last_invoice":"39","last_update_quota":"2026-06-25","date_first_sale":"2011-08-29","payment_method_rf":"N","customer_category":"AAA","type_record":"UPDATE","idmovimiento":"88281106"},{"country_code":"CO","customer_code":"5371530","email":"mayraluna210391@hotmail.com","email_fe":"mayraluna210391@hotmail.com","first_surname":"ROSERO","second_surname":"PAREDES","first_name":"RODRIGO","second_name":"GILBERTO","complete_name":"ROSERO PAREDES RODRIGO GILBERTO","phone":"","phone2":"","fax_number":"","mobile_number":"3206424595","address":"CARRERA 12 #19-43 BARRIO SAN SEBASTIAN","city_code":"52838","city_name":"TUQUERRES","department_code":"52","department_name":"NARINO","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG29","seller_name":"HOYOS MIGUEL ANGEL","seller_email":"mhoyos@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2021-12-27","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2023-12-18","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"mayraluna210391@hotmail.com","discount":"40.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"79","last_update_quota":"2026-06-25","date_first_sale":"2022-01-26","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281101"},{"country_code":"CO","customer_code":"900102248","email":"TRASPORTESJREYES@YAHOO.ES","email_fe":"transportesjreyes@yahoo.es","first_surname":"","second_surname":"","first_name":"TRANSPORTS Y SERVICIOS JR","second_name":"","complete_name":"TRANSPORTES Y SERVICIOS JR","phone":"6348905","phone2":"","fax_number":"","mobile_number":"3124318668","address":"CALLE 25 # 21-51 BARRIO PROVIVIENDA YOPAL","city_code":"85001","city_name":"YOPAL","department_code":"85","department_name":"CASANARE","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYP","seller_name":"OTALORA OSCAR","seller_email":"jotalora@automundial.com.co","invoice_period":"39","bill_rejects":"N","bill_secure":"N","creation_date":"2016-07-22","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-03-06","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"NANCY RIOS","email_contact":"TRASPORTESJREYES@YAHOO.ES","discount":"26.50","contado":"-118958.0","por_vencer":"0.0","vencido":"-118958.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"-118958.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"1","last_update_quota":"2026-06-25","date_first_sale":"2016-08-31","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88281096"},{"country_code":"CO","customer_code":"19137630","email":"pecosbil049@gmail.com","email_fe":"pecosbil049@gmail.com","first_surname":"CORREDOR","second_surname":"JAIMES","first_name":"INDALECIO","second_name":"","complete_name":"CORREDOR JAIMES INDALECIO","phone":"0","phone2":"","fax_number":"","mobile_number":"3102917391","address":"CR 45 4 67","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYH","seller_name":"HIGUERA BOLIVAR LADY DIAHANN","seller_email":"lhiguera@automundial.com.co","invoice_period":"01","bill_rejects":null,"bill_secure":null,"creation_date":"1995-03-30","status":"F","status_name":"CLIENTE FALLECIDO","observation":"PDTE FOTOCOPIAS,CLIENTE INACTIVO,CUPO NOASIGND,RENOVAR SOLICIT","last_invoice_date":"2023-01-31","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2022-09-06","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"CORREDOR JAIMES INDALECIO","email_contact":"pecosbil049@gmail.com","discount":"35.36","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"10","last_update_quota":"2026-06-25","date_first_sale":"2016-09-30","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281100"},{"country_code":"CO","customer_code":"52055197","email":"claudia.bayona@hotmail.com","email_fe":"claudiap@hotmail.com","first_surname":"BAYONA","second_surname":"DIAZ","first_name":"CLAUDIA","second_name":"PATRICIA","complete_name":"BAYONA DIAZ CLAUDIA PATRICIA","phone":"","phone2":"","fax_number":"","mobile_number":"3107773557","address":"CL 126 52A 96 APTO 331","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYH","seller_name":"HIGUERA BOLIVAR LADY DIAHANN","seller_email":"lhiguera@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2017-12-15","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-04-30","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2022-10-24","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"claudia.bayona@hotmail.com","discount":"35.36","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"61","last_update_quota":"2026-06-25","date_first_sale":"2019-12-13","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281099"},{"country_code":"CO","customer_code":"900690799","email":"facturacion@gmcontables.com","email_fe":"facturacion@gmcontabl.com","first_surname":"","second_surname":"","first_name":"CORPORACION POSCONSUMO DE LLANTAS RUEDA VERDE","second_name":"","complete_name":"CORPORACION POSCONSUMO DE LLANTAS RUEDA VERDE","phone":"4849170","phone2":"EXT 2566","fax_number":"","mobile_number":"3124233135","address":"CALLE 72 N\u00b0 10-34 TORRE A OF 1005","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"PAR","seller_code":"BTI","seller_name":"GERENCIA REGIONAL CENTRO","seller_email":"cagarcia@automundial.com.co","invoice_period":"03","bill_rejects":null,"bill_secure":null,"creation_date":"2017-09-20","status":"E","status_name":"DESBLOQUEO ESPECIAL","observation":"","last_invoice_date":"2025-01-31","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"facturacion@gmcontables.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"15","last_update_quota":"2026-06-25","date_first_sale":"2017-09-20","payment_method_rf":"N","customer_category":"AAA","type_record":"UPDATE","idmovimiento":"88281098"},{"country_code":"CO","customer_code":"9395100","email":"josesixtoduran@gmail.com","email_fe":"josesixtoduran@gmail.com","first_surname":"DURAN","second_surname":"PEREZ","first_name":"JOSE","second_name":"SIXTO","complete_name":"DURAN PEREZ JOSE SIXTO","phone":"","phone2":"","fax_number":"","mobile_number":"3108717176","address":"DG 59 11B 04","city_code":"15759","city_name":"SOGAMOSO","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"DIS","seller_code":"BYL","seller_name":"PEDRAZA GLORIA MERCEDES","seller_email":"gpedraza@automundial.com.co","invoice_period":"03","bill_rejects":"S","bill_secure":"N","creation_date":"2016-04-27","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-06-19","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"20000000.00","actualization_date":"2022-10-21","average_sales":"5318700.666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"DIS","contract_pcpk":"N","contact":"DURAN PEREZ JOSE SIXTO","email_contact":"josesixtoduran@gmail.com","discount":"40.00","contado":"30641030.0","por_vencer":"0.0","vencido":"30641030.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"5934501.0","de_31_a_45_dias":"17373547.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"5216982.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"2116000.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"8","days_before_last_invoice":"7","last_update_quota":"2026-06-25","date_first_sale":"2016-05-31","payment_method_rf":"N","customer_category":"AA","type_record":"UPDATE","idmovimiento":"88281097"},{"country_code":"CO","customer_code":"1047391","email":"diahann_123@hotmail.com","email_fe":"diahann_123@hotmail.com","first_surname":"HIGUERA","second_surname":"SEGUNDO","first_name":"GABRIEL","second_name":"","complete_name":"HIGUERA SEGUNDO GABRIEL","phone":"7627977","phone2":"","fax_number":"","mobile_number":"3125869560","address":"DG 11 13 99","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYL","seller_name":"PEDRAZA GLORIA MERCEDES","seller_email":"gpedraza@automundial.com.co","invoice_period":"07","bill_rejects":null,"bill_secure":null,"creation_date":"2009-06-02","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"CONTADO","last_invoice_date":"2024-04-05","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"4000000.00","actualization_date":"2022-10-22","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"diahann_123@hotmail.com","discount":"30.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"632","last_update_quota":"2026-06-25","date_first_sale":"2016-08-22","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280861"},{"country_code":"CO","customer_code":"7223194","email":"operativo@coflonorte.com","email_fe":"operativo@coflonorte.com","first_surname":"RODRIGUEZ","second_surname":"SANABRIA","first_name":"EDGAR","second_name":"TOBIAS","complete_name":"RODRIGUEZ SANABRIA EDGAR TOBIAS","phone":"","phone2":"","fax_number":"","mobile_number":"3103104317","address":"CL 8 14 06","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYU","seller_name":"CHINOME ZANDRA","seller_email":"zchinome@automundial.com.co","invoice_period":"03","bill_rejects":"S","bill_secure":"N","creation_date":"2016-08-10","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-04-19","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2023-07-05","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"operativo@coflonorte.com","discount":"35.36","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"67","last_update_quota":"2026-06-25","date_first_sale":"2016-10-31","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88281095"},{"country_code":"CO","customer_code":"1030601750","email":"pulido-jose.1991@hotmail.com","email_fe":"pulido-jose.1991@hotmail.com","first_surname":"PULIDO","second_surname":"VALERO","first_name":"JOSE","second_name":"LUIS","complete_name":"PULIDO VALERO JOSE LUIS","phone":"","phone2":"","fax_number":"","mobile_number":"3107519195","address":"CALLE   33 SUR NO 87D-03","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"PAR","seller_code":"BQ32","seller_name":"GONZALEZ FABIAN","seller_email":"fgonzalez@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"N","creation_date":"2015-12-01","status":"B","status_name":"CLIENTE ACTIVO","observation":"EL CLIENTE TIENE CHEQUES DEVUELTOS","last_invoice_date":"2026-03-09","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"16000000.00","actualization_date":null,"average_sales":"3024298.5","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"pulido-jose.1991@hotmail.com","discount":"28.00","contado":"19293279.0","por_vencer":"0.0","vencido":"19293279.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"6017515.8","de_46_a_60_dias":"0.0","de_61_a_75_dias":"7258315.8","de_76_a_90_dias":"0.0","de_91_a_105_dias":"6017447.4","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"2","days_before_last_invoice":"10","last_update_quota":"2026-06-25","date_first_sale":"2015-12-01","payment_method_rf":"S","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280862"},{"country_code":"CO","customer_code":"35462772","email":null,"email_fe":"jaimesalazar@tix-colombia.com","first_surname":"URIBE","second_surname":"ARANGO","first_name":"MARIA","second_name":"DEL PILAR","complete_name":"URIBE ARANGO MARIA DEL PILAR","phone":"2611113","phone2":"","fax_number":"","mobile_number":"3208472265","address":"CRA 53 NO.17-31","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"PAR","seller_code":"BT81","seller_name":"ABOGADO GRUPO CONCRED","seller_email":"","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2016-08-12","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-09-27","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"799502.16666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"FCO","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"35.00","contado":"2811575.0","por_vencer":"0.0","vencido":"2811575.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"2811575.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"7","last_update_quota":"2026-06-25","date_first_sale":"2016-08-12","payment_method_rf":"N","customer_category":"AA","type_record":"UPDATE","idmovimiento":"88280863"},{"country_code":"CO","customer_code":"12118954","email":"jaimendez07@hotmail.com","email_fe":"jaimendez07@hotmail.com","first_surname":"MENDEZ","second_surname":"ANDRADE","first_name":"JAIME","second_name":"","complete_name":"MENDEZ ANDRADE JAIME","phone":"","phone2":"","fax_number":"","mobile_number":"3142191543","address":"CLL 41 NO 7A-18","city_code":"41001","city_name":"NEIVA","department_code":"41","department_name":"HUILA","country":"169","name_country":"COLOMBIA","region_code":"006","region_name":"TOLIMA HUILA","customer_type":"PAR","seller_code":"NEI","seller_name":"ALVARO SAENZ","seller_email":"asaenz@automundial.com.co","invoice_period":"07","bill_rejects":null,"bill_secure":null,"creation_date":"2015-09-07","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-05-30","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"5000000.00","actualization_date":"2023-04-21","average_sales":"1783990.583333333333333333333333","mark":"S","branch":"S","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"jaimendez07@hotmail.com","discount":"32.00","contado":"1881002.0","por_vencer":"0.0","vencido":"1881002.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"412334.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"412334.0","de_61_a_75_dias":"644000.0","de_76_a_90_dias":"412334.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"3","days_before_last_invoice":"53","last_update_quota":"2026-06-25","date_first_sale":"2015-09-07","payment_method_rf":"S","customer_category":"A","type_record":"UPDATE","idmovimiento":"88281089"},{"country_code":"CO","customer_code":"1116783020","email":null,"email_fe":"eduwin1203@hotmail.com","first_surname":"ALVAREZ","second_surname":"PARALES","first_name":"EDUWIN","second_name":"MAURICIO","complete_name":"ALVAREZ EDWIN MAURICIO","phone":"4204350","phone2":"","fax_number":"","mobile_number":"","address":"COMISIONES","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYP","seller_name":"OTALORA OSCAR","seller_email":"jotalora@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2019-05-17","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2020-08-11","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"0","last_update_quota":"2026-06-25","date_first_sale":"2020-08-11","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281090"},{"country_code":"CO","customer_code":"83247785","email":"ananiasrodriguez15@gmail.com","email_fe":"ananiasrodriguez15@gmail.com","first_surname":"RODRIGUEZ","second_surname":"","first_name":"ANANIAS","second_name":"","complete_name":"RODRIGUEZ  ANANIAS","phone":"","phone2":"","fax_number":"","mobile_number":"3163098341","address":"CLL 1E NO 27-48 B\/ACACIAS 2 ETAPA","city_code":"41001","city_name":"NEIVA","department_code":"41","department_name":"HUILA","country":"169","name_country":"COLOMBIA","region_code":"006","region_name":"TOLIMA HUILA","customer_type":"PAR","seller_code":"NEI","seller_name":"ALVARO SAENZ","seller_email":"asaenz@automundial.com.co","invoice_period":"07","bill_rejects":"N","bill_secure":"N","creation_date":"2018-08-14","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-05-12","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"3000000.00","actualization_date":"2023-04-27","average_sales":"35289.25","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"ANANIASRODRIGUEZ15@GMAIL.COM","email_contact":"ananiasrodriguez15@gmail.com","discount":"0.00","contado":"-270856.0","por_vencer":"0.0","vencido":"-270856.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"-270856.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"248","last_update_quota":"2026-06-25","date_first_sale":"2018-08-17","payment_method_rf":"S","customer_category":"B","type_record":"UPDATE","idmovimiento":"88281091"},{"country_code":"CO","customer_code":"47425261","email":"inpinzoncar@gmail.com","email_fe":"lnpinzoncar@gmail.com","first_surname":"PINZON","second_surname":"CARDOZO","first_name":"INES","second_name":"","complete_name":"PINZON CARDOZO INES","phone":"","phone2":"","fax_number":"","mobile_number":"3133009774","address":"VEREDA SANTA ANA FICA LA VEREMOS","city_code":"85325","city_name":"SAN LUIS DE PALENQUE","department_code":"85","department_name":"CASANARE","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYP","seller_name":"OTALORA OSCAR","seller_email":"jotalora@automundial.com.co","invoice_period":"07","bill_rejects":null,"bill_secure":null,"creation_date":"2018-12-21","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-08-20","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"4000000.00","actualization_date":"2022-11-17","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"inpinzoncar@gmail.com","discount":"33.00","contado":"-11000.0","por_vencer":"0.0","vencido":"-11000.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"-11000.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"91","last_update_quota":"2026-06-25","date_first_sale":"2019-03-14","payment_method_rf":"S","customer_category":"B","type_record":"UPDATE","idmovimiento":"88281092"},{"country_code":"CO","customer_code":"10390032","email":"trianaefrain@gmail.com","email_fe":"trianaefrain@gmail.com","first_surname":"TRIANA","second_surname":"","first_name":"EFRAIN","second_name":"","complete_name":"TRIANA  EFRAIN","phone":"","phone2":"","fax_number":"","mobile_number":"3114721781","address":"CLL 11B NO 5-18 B\/LIBERTADORES 2 ETAPA","city_code":"41396","city_name":"LA PLATA","department_code":"41","department_name":"HUILA","country":"169","name_country":"COLOMBIA","region_code":"006","region_name":"TOLIMA HUILA","customer_type":"PAR","seller_code":"NE10","seller_name":"JOSE LUIS PERDOMO","seller_email":"jperdomo@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2022-03-17","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-03-31","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2023-05-02","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"trianaefrain@gmail.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"0","last_update_quota":"2026-06-25","date_first_sale":"2022-03-31","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88281093"},{"country_code":"CO","customer_code":"93357072","email":"edisong64@yahoo.com","email_fe":"edisong64@yahoo.com","first_surname":"GUTIERREZ","second_surname":"FERNANDEZ","first_name":"JESUS","second_name":"EDINSON","complete_name":"GUTIERREZ FERNANDEZ JESUS EDINSON","phone":"2692633","phone2":"","fax_number":"","mobile_number":"3175438721","address":"CR 48 SUR NO 85-91 BARRIO ALCAR","city_code":"73001","city_name":"IBAGUE","department_code":"73","department_name":"TOLIMA","country":"169","name_country":"COLOMBIA","region_code":"006","region_name":"TOLIMA HUILA","customer_type":"PAR","seller_code":"NE7","seller_name":"SALAZAR GERMAN","seller_email":"gsalazar@automundial.com.co","invoice_period":"39","bill_rejects":"S","bill_secure":"S","creation_date":"2016-09-07","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-02-14","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"20000000.00","actualization_date":"2022-09-15","average_sales":"106348.91666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"edisong64@yahoo.com","discount":"30.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"319","last_update_quota":"2026-06-25","date_first_sale":"2016-09-13","payment_method_rf":"N","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280859"},{"country_code":"CO","customer_code":"4431145","email":"fernandosoto1759@gmail.com","email_fe":"fernandosoto1759@gmail.com","first_surname":"SOTO","second_surname":"GRISALES","first_name":"FERNANDO","second_name":"DE JESUS","complete_name":"SOTO GRISALES FERNANDO DE JESUS","phone":"3104480537","phone2":"","fax_number":"","mobile_number":"3104480537","address":"CRA 16 #3-43 VALLE CANGREJO","city_code":"76869","city_name":"VIJES","department_code":"76","department_name":"VALLE DEL CAUCA","country":"169","name_country":"COLOMBIA","region_code":"002","region_name":"OCCIDENTE","customer_type":"PAR","seller_code":"CA59","seller_name":"GIRONZA YOLANDA","seller_email":"ygironza@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2022-01-20","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-10-21","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2026-01-14","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"fernandosoto1759@gmail.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"24","last_update_quota":"2026-06-25","date_first_sale":"2022-01-20","payment_method_rf":"S","customer_category":"","type_record":"UPDATE","idmovimiento":"88280860"},{"country_code":"CO","customer_code":"1030588591","email":null,"email_fe":"jorgereyesgomez591@gmail.com","first_surname":"REYES","second_surname":"GOMEZ","first_name":"JORGE","second_name":"GABRIEL","complete_name":"REYES GOMEZ JORGE GABRIEL","phone":"3183135296","phone2":"","fax_number":"","mobile_number":"","address":"TV 9 ESTE # 46 B 32","city_code":"25754","city_name":"SOACHA","department_code":"25","department_name":"CUNDINAMARCA","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"DIS","seller_code":"BT33","seller_name":"GARCIA WILCHES WILLIAM","seller_email":"wgarcia@automundial.com.co","invoice_period":"39","bill_rejects":"N","bill_secure":"N","creation_date":"2021-07-06","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2025-05-19","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"28.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"323","last_update_quota":"2026-06-25","date_first_sale":"2021-07-12","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88281094"},{"country_code":"CO","customer_code":"900332590","email":"gerencia@promoambientalvalle.com","email_fe":"siesaferecepcion@siesafe.co","first_surname":"","second_surname":"","first_name":"PROMOCALI SA ESP","second_name":"","complete_name":"PROMOCALI SA ESP","phone":"4877070","phone2":"6561953","fax_number":"","mobile_number":"3184152323","address":"CALLE 70 7E BIS-04","city_code":"76001","city_name":"CALI","department_code":"76","department_name":"VALLE DEL CAUCA","country":"169","name_country":"COLOMBIA","region_code":"002","region_name":"OCCIDENTE","customer_type":"IND","seller_code":"CA15","seller_name":"CIRO SANTOS MARIA FERNANDA","seller_email":"mciro@automundial.com.co","invoice_period":"03","bill_rejects":"S","bill_secure":"N","creation_date":"2012-01-11","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-07-25","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"30000000.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"FCO","contract_pcpk":"N","contact":null,"email_contact":"gerencia@promoambientalvalle.com","discount":"32.00","contado":"-466328.0","por_vencer":"0.0","vencido":"-466328.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"-466328.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"71","last_update_quota":"2026-06-25","date_first_sale":"2012-01-11","payment_method_rf":"N","customer_category":"AAA","type_record":"UPDATE","idmovimiento":"88280851"},{"country_code":"CO","customer_code":"800186313","email":"contabilidad@agmdesarrollos.com","email_fe":"contabilidad@agmdesarrollos.com","first_surname":"","second_surname":"","first_name":"AGM DESARROLLOS S.A.S","second_name":"","complete_name":"AGM DESARROLLOS S.A.S","phone":"6878230","phone2":"3163845046","fax_number":"","mobile_number":"","address":"CL 11 3 33","city_code":"13001","city_name":"CARTAGENA","department_code":"13","department_name":"BOLIVAR","country":"169","name_country":"COLOMBIA","region_code":"005","region_name":"COSTA ATLANTICA","customer_type":"INF","seller_code":"BQ19","seller_name":"RIASCOS HEIDY","seller_email":"hriascos@automundial.com.co","invoice_period":"03","bill_rejects":"N","bill_secure":"S","creation_date":"2019-11-19","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-05-02","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"100000000.00","actualization_date":null,"average_sales":"927011.91666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"contabilidad@agmdesarrollos.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"43","last_update_quota":"2026-06-25","date_first_sale":"2020-02-25","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280852"},{"country_code":"CO","customer_code":"820002002","email":"agregadossantalucialtda@hotmail.com","email_fe":"facturacionagregadossantalucia@gmail.com","first_surname":"","second_surname":"","first_name":"AGREGADOS SANTA LUCIA S.A.S","second_name":"","complete_name":"AGREGADOS SANTA LUCIA S.A.S","phone":"","phone2":"","fax_number":"","mobile_number":"3102879958","address":"KM 19 VIA TUNJA VILLA DE LEYVA","city_code":"15224","city_name":"CUCAITA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"IND","seller_code":"BYK","seller_name":"CORTES CARLOS ARTURO","seller_email":"ccortes@automundial.com.co","invoice_period":"03","bill_rejects":"S","bill_secure":"N","creation_date":"2021-05-29","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-04-14","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"15000000.00","actualization_date":"2022-10-13","average_sales":"4996745.5","mark":"S","branch":"N","branch_code":"","customer_group":"FCO","contract_pcpk":"N","contact":"OBDULIO LARROTA","email_contact":"agregadossantalucialtda@hotmail.com","discount":"35.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"49","last_update_quota":"2026-06-25","date_first_sale":"2021-05-31","payment_method_rf":"N","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280853"},{"country_code":"CO","customer_code":"900400707","email":"gerencia@transportesmicarga.com","email_fe":"facturacion@transportesmicarga.com","first_surname":"","second_surname":"","first_name":"MI CARGA SAS","second_name":"","complete_name":"MI CARGA SAS","phone":"","phone2":"","fax_number":"","mobile_number":"3124231320","address":"CR 29 A 21 05","city_code":"85001","city_name":"YOPAL","department_code":"85","department_name":"CASANARE","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"FNT","seller_code":"BYU","seller_name":"CHINOME ZANDRA","seller_email":"zchinome@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"N","creation_date":"2022-01-24","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-09-30","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"50000000.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"FCO","contract_pcpk":"N","contact":null,"email_contact":"gerencia@transportesmicarga.com","discount":"30.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"285","last_update_quota":"2026-06-25","date_first_sale":"2022-03-31","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280854"},{"country_code":"CO","customer_code":"91351852","email":"cvargasbarajas@gmail.com","email_fe":"eliasv348@hotmail.com","first_surname":"VARGAS","second_surname":"BARAJAS","first_name":"CAMPO","second_name":"ELIAS","complete_name":"VARGAS BARAJAS CAMPO ELIAS","phone":"3115910083","phone2":"","fax_number":"","mobile_number":"3115910083","address":"CALLE 1B 16-56","city_code":"68547","city_name":"PIEDECUESTA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG32","seller_name":"LEON SILVA SANDY BIAN","seller_email":"sleon@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"S","creation_date":"2009-03-13","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-06-06","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"8000000.00","actualization_date":null,"average_sales":"686419.58333333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"cvargasbarajas@gmail.com","discount":"35.00","contado":"3947999.01","por_vencer":"0.0","vencido":"3947999.01","de_0_a_15_dias":"1315999.67","de_16_a_30_dias":"0.0","de_31_a_45_dias":"1315999.67","de_46_a_60_dias":"0.0","de_61_a_75_dias":"1315999.67","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"1","days_before_last_invoice":"130","last_update_quota":"2026-06-25","date_first_sale":"2009-03-13","payment_method_rf":"N","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280855"},{"country_code":"CO","customer_code":"4259737","email":"antoniifernandes977@gmail.com","email_fe":"antoniifernandes977@gmail.com","first_surname":"FERNANDEZ","second_surname":"SIERRA","first_name":"ANTONIO","second_name":"","complete_name":"FERNANDEZ SIERRA ANTONIO","phone":"","phone2":"","fax_number":"","mobile_number":"3114997152","address":"CL 2 10 70","city_code":"15759","city_name":"SOGAMOSO","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYL","seller_name":"PEDRAZA GLORIA MERCEDES","seller_email":"gpedraza@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"N","creation_date":"2014-01-16","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-02-28","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"60000000.00","actualization_date":null,"average_sales":"2977876.666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"FERNANDEZ SIERRA ANTONIO","email_contact":"antoniifernandes977@gmail.com","discount":"35.00","contado":"12856720.01","por_vencer":"0.0","vencido":"12856720.01","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"3775800.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"3775800.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"5305120.01","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"3","days_before_last_invoice":"5","last_update_quota":"2026-06-25","date_first_sale":"2014-01-30","payment_method_rf":"S","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280850"},{"country_code":"CO","customer_code":"1082803672","email":null,"email_fe":"wilmercito0489@hotmail.com","first_surname":"AYA","second_surname":"","first_name":"WILMER","second_name":"","complete_name":"AYA  WILMER","phone":"","phone2":"","fax_number":"","mobile_number":"3102667673","address":"CLL 17A NO 50-54 BARRIO VICTOR FELIX","city_code":"41001","city_name":"NEIVA","department_code":"41","department_name":"HUILA","country":"169","name_country":"COLOMBIA","region_code":"006","region_name":"TOLIMA HUILA","customer_type":"DIS","seller_code":"NE10","seller_name":"JOSE LUIS PERDOMO","seller_email":"jperdomo@automundial.com.co","invoice_period":"39","bill_rejects":"N","bill_secure":"N","creation_date":"2017-11-18","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-04-30","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2022-09-12","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"38.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"39","last_update_quota":"2026-06-25","date_first_sale":"2018-04-07","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280856"},{"country_code":"CO","customer_code":"10221716","email":null,"email_fe":"jotamal716@hotmail.com","first_surname":"ARIAS","second_surname":"LOPEZ","first_name":"JOSE","second_name":"MARINO","complete_name":"ARIAS LOPEZ JOSE MARINO","phone":"3126822074","phone2":"","fax_number":"","mobile_number":"3126822074","address":"CRA 12 N. 8-60","city_code":"66682","city_name":"SANTA ROSA DE CABAL","department_code":"66","department_name":"RISARALDA","country":"169","name_country":"COLOMBIA","region_code":"008","region_name":"VIEJO CALDAS","customer_type":"PAR","seller_code":"PE11","seller_name":"LADINO CHIQUITO CLISSMAN LEA","seller_email":"cladino@automundial.com.co","invoice_period":"06","bill_rejects":"S","bill_secure":"N","creation_date":"2018-07-25","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-05-25","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"8000000.00","actualization_date":null,"average_sales":"640166.83333333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"35.00","contado":"4638001.0","por_vencer":"1855200.4","vencido":"2782800.6","de_0_a_15_dias":"0.0","de_16_a_30_dias":"927600.2","de_31_a_45_dias":"0.0","de_46_a_60_dias":"927600.2","de_61_a_75_dias":"0.0","de_76_a_90_dias":"927600.2","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"237","last_update_quota":"2026-06-25","date_first_sale":"2018-07-31","payment_method_rf":"S","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280845"},{"country_code":"CO","customer_code":"1026562488","email":null,"email_fe":"carlosforero1989@gmail.com","first_surname":"FORERO","second_surname":"PINEDA","first_name":"CARLOS","second_name":"RODOLFO","complete_name":"FORERO PINEDA CARLOS RODOLFO","phone":"","phone2":"","fax_number":"","mobile_number":"3118590427","address":"CRA 8 N\u00c2\u00b0 6-24","city_code":"85440","city_name":"VILLANUEVA - CAS","department_code":"85","department_name":"CASANARE","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"PAR","seller_code":"BT80","seller_name":"SANTIAGO MORERA","seller_email":"smorera@automundial.com.co","invoice_period":"07","bill_rejects":"N","bill_secure":"N","creation_date":"2022-03-01","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-06-01","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"8000000.00","actualization_date":null,"average_sales":"994292.25","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"30.00","contado":"3760000.0","por_vencer":"1504000.0","vencido":"2256000.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"752000.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"752000.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"752000.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"212","last_update_quota":"2026-06-25","date_first_sale":"2022-03-01","payment_method_rf":"S","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280857"},{"country_code":"CO","customer_code":"79894359","email":"leotes@hotmail.es","email_fe":"leotes@hotmail.es","first_surname":"TORRES","second_surname":"","first_name":"LEONEL","second_name":"","complete_name":"TORRES  LEONEL","phone":"","phone2":"","fax_number":"","mobile_number":"3112838164","address":"CRA 10 #13 - 59","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"PAR","seller_code":"BT35","seller_name":"PORRAS MORA MANUEL","seller_email":"mporras@automundial.com.co","invoice_period":"07","bill_rejects":"N","bill_secure":"N","creation_date":"2020-05-28","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-02-17","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"8000000.00","actualization_date":null,"average_sales":"170993.25","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"leotes@hotmail.es","discount":"22.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"251","last_update_quota":"2026-06-25","date_first_sale":"2020-05-28","payment_method_rf":"N","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280858"},{"country_code":"CO","customer_code":"1057544591","email":null,"email_fe":"diahann_123@hotmail.com","first_surname":"QUINTERO","second_surname":"","first_name":"ALEXANDER","second_name":"","complete_name":"QUINTERO ESCOBAR WILMER ALEXANDER","phone":"3106070586","phone2":"","fax_number":"","mobile_number":"3106070586","address":"MONTALLANTAS CHARU","city_code":"15753","city_name":"SOATA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYU","seller_name":"CHINOME ZANDRA","seller_email":"zchinome@automundial.com.co","invoice_period":"39","bill_rejects":"N","bill_secure":"N","creation_date":"2018-01-15","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-05-23","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"722291.33333333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"CARLOS ORTEGA","email_contact":null,"discount":"25.50","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"1","last_update_quota":"2026-06-25","date_first_sale":"2018-03-16","payment_method_rf":"N","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280849"},{"country_code":"CO","customer_code":"79466834","email":"ARNOLDTORRES6@HOTMAIL.COM","email_fe":"arnoltorres6@hotmail.com","first_surname":"TORRES","second_surname":"MIRANDA","first_name":"ARNOL","second_name":"GERMAN","complete_name":"TORRES MIRANDA ARNOL GERMAN","phone":"2902836","phone2":"","fax_number":"","mobile_number":"3153247944","address":"TV 53 BIS # 2A - 64","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"PAR","seller_code":"BQ32","seller_name":"GONZALEZ FABIAN","seller_email":"fgonzalez@automundial.com.co","invoice_period":"03","bill_rejects":null,"bill_secure":null,"creation_date":"2006-12-14","status":"B","status_name":"CLIENTE ACTIVO","observation":"EL CLIENTE TIENE CHEQUES DEVUELTOS","last_invoice_date":"2026-04-07","contributory_code":"2","contributory_name":"PERSONAS NATURALES RETENEDORAS","assigned_quota":"10000000.00","actualization_date":null,"average_sales":"744678.83333333333333333333333333","mark":"S","branch":"S","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"ARNOLDTORRES6@HOTMAIL.COM","discount":"25.00","contado":"1825486.0","por_vencer":"0.0","vencido":"1825486.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"1825486.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"1","days_before_last_invoice":"161","last_update_quota":"2026-06-25","date_first_sale":"2007-01-16","payment_method_rf":"S","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280848"},{"country_code":"CO","customer_code":"37391853","email":null,"email_fe":"todoenllantasjpo@gmail.com","first_surname":"OMANA","second_surname":"URIBE","first_name":"YURLEY","second_name":"CAROLINA","complete_name":"OMANA URIBE YURLEY CAROLINA","phone":"3112600137","phone2":"","fax_number":"","mobile_number":"","address":"AV 9 # 1-90 BARRIO CALLEJON","city_code":"54001","city_name":"CUCUTA","department_code":"54","department_name":"NORTE DE SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"DIS","seller_code":"BG29","seller_name":"HOYOS MIGUEL ANGEL","seller_email":"mhoyos@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2021-03-09","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2023-08-04","contributory_code":"2","contributory_name":"PERSONAS NATURALES RETENEDORAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"DIS","contract_pcpk":"N","contact":"YURLEY CAROLINA OMA\u00f1A","email_contact":null,"discount":"45.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"256","last_update_quota":"2026-06-25","date_first_sale":"2021-03-17","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280847"},{"country_code":"CO","customer_code":"74376033","email":"willianl@hotmail.com","email_fe":"willianl@hotmail.com","first_surname":"LOPEZ","second_surname":"DIAZ","first_name":"WILLIAN","second_name":"IGNACIO","complete_name":"LOPEZ DIAZ WILLIAN IGNACIO","phone":"","phone2":"","fax_number":"","mobile_number":"3124495994","address":"CRA 15 # 11-38","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"005","region_name":"COSTA ATLANTICA","customer_type":"PAR","seller_code":"BAG","seller_name":"LEGUIZAMON FATIMA","seller_email":"fleguizamon@automundial.com.co","invoice_period":"39","bill_rejects":"N","bill_secure":"N","creation_date":"2018-06-26","status":"Q","status_name":"CONTADO SIN CANCELAR","observation":"","last_invoice_date":"2026-06-05","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"1337088.5","mark":"S","branch":"S","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"WILLIAM LOPEZ DIAZ","email_contact":"willianl@hotmail.com","discount":"35.00","contado":"-7.0","por_vencer":"0.0","vencido":"-7.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"-7.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"4","last_update_quota":"2026-06-25","date_first_sale":"2018-06-26","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280846"},{"country_code":"CO","customer_code":"1038770381","email":"carlosrestreporamirez95@gmail.com","email_fe":"carlosrestreporamirez95@gmail.com","first_surname":"RESTREPO","second_surname":"RAMIREZ","first_name":"CARLOS","second_name":"HUMBERTO","complete_name":"RESTREPO RAMIREZ CARLOS HUMBERTO","phone":"","phone2":"","fax_number":"","mobile_number":"3226320845","address":"CARRERA 18 N.21-29","city_code":"05001","city_name":"MEDELLIN","department_code":"05","department_name":"ANTIOQUIA","country":"169","name_country":"COLOMBIA","region_code":"003","region_name":"ANTIOQUIA","customer_type":"PAR","seller_code":"MEY1","seller_name":"ALEXANDER MONTOYA","seller_email":"amontoya@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2015-04-22","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-09-09","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"CREADO CON M.O 4245112","email_contact":"carlosrestreporamirez95@gmail.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"94","last_update_quota":"2026-06-25","date_first_sale":"2015-05-16","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280843"},{"country_code":"CO","customer_code":"1118259632","email":"martinezolayaenrique@gmail.com","email_fe":"martinezolayaenrique@gmail.com","first_surname":"MARTINEZ","second_surname":"MONTOYA","first_name":"LUIS","second_name":"ENRIQUE","complete_name":"MARTINEZ MONTOYA LUIS ENRIQUE","phone":"3127065051","phone2":"","fax_number":"","mobile_number":"3127065051","address":"KILOMETRO 1 VIA RESTREPO FINCA LA ALBERCA","city_code":"76869","city_name":"VIJES","department_code":"76","department_name":"VALLE DEL CAUCA","country":"169","name_country":"COLOMBIA","region_code":"002","region_name":"OCCIDENTE","customer_type":"PAR","seller_code":"CA37","seller_name":"GUSTAVO SARMIENTO","seller_email":"gsarmiento@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2016-09-19","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-10-18","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"martinezolayaenrique@gmail.com","discount":"0.00","contado":"2373761.0","por_vencer":"0.0","vencido":"2373761.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"2373761.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"2","days_before_last_invoice":"246","last_update_quota":"2026-06-25","date_first_sale":"2016-09-19","payment_method_rf":"S","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280842"},{"country_code":"CO","customer_code":"1037570078","email":null,"email_fe":"carlos_parejac@hotmail.com","first_surname":"PAREJA","second_surname":"CADAVID","first_name":"CARLOS","second_name":"ANDRES","complete_name":"PAREJA CADAVID CARLOS ANDRES","phone":"4170392","phone2":"","fax_number":"","mobile_number":"3166933149","address":"CLL 17 SUR #44-159","city_code":"05001","city_name":"MEDELLIN","department_code":"05","department_name":"ANTIOQUIA","country":"169","name_country":"COLOMBIA","region_code":"003","region_name":"ANTIOQUIA","customer_type":"PAR","seller_code":"MEY1","seller_name":"ALEXANDER MONTOYA","seller_email":"amontoya@automundial.com.co","invoice_period":"06","bill_rejects":null,"bill_secure":null,"creation_date":"2018-05-25","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-09-09","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"4000000.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"35.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"10","last_update_quota":"2026-06-25","date_first_sale":"2018-06-06","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280841"},{"country_code":"CO","customer_code":"1037583755","email":null,"email_fe":"lauritamgq@hotmail.com","first_surname":"GONZALEZ","second_surname":"QUIJANO","first_name":"LAURA","second_name":"MARCELA","complete_name":"GONZALEZ QUIJANO LAURA MARCELA","phone":"","phone2":"","fax_number":"","mobile_number":"3146315473","address":"CALLE 17SUR N.44-159","city_code":"05001","city_name":"MEDELLIN","department_code":"05","department_name":"ANTIOQUIA","country":"169","name_country":"COLOMBIA","region_code":"003","region_name":"ANTIOQUIA","customer_type":"PAR","seller_code":"MEY1","seller_name":"ALEXANDER MONTOYA","seller_email":"amontoya@automundial.com.co","invoice_period":"01","bill_rejects":null,"bill_secure":null,"creation_date":"2018-11-06","status":"P","status_name":"NO TIENE CUPO DISPONIBLE","observation":"","last_invoice_date":"2023-07-05","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"CONTADO","email_contact":null,"discount":"35.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"144","last_update_quota":"2026-06-25","date_first_sale":"2018-12-03","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280840"},{"country_code":"CO","customer_code":"901266180","email":"noraldihoyoscaicedo@hotmail.com","email_fe":"llantasymasllantasmiguesas@gmail.com","first_surname":"","second_surname":"","first_name":"LLANTAS Y MAS LLANTAS MIGUE SAS","second_name":"","complete_name":"LLANTAS Y MAS LLANTAS MIGUE SAS","phone":"3122786907","phone2":"","fax_number":"","mobile_number":"","address":"CALLE 25 NO. 33-178 VARIANTE SUR","city_code":"19001","city_name":"POPAYAN","department_code":"19","department_name":"CAUCA","country":"169","name_country":"COLOMBIA","region_code":"002","region_name":"OCCIDENTE","customer_type":"DIS","seller_code":"CA6","seller_name":"ANIBAL CADAVID","seller_email":"acadavid@automundial.com.co","invoice_period":"03","bill_rejects":null,"bill_secure":null,"creation_date":"2019-05-02","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-06-10","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"30000000.00","actualization_date":null,"average_sales":"1150652.083333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"DIS","contract_pcpk":"N","contact":null,"email_contact":"noraldihoyoscaicedo@hotmail.com","discount":"40.00","contado":"1348048.0","por_vencer":"0.0","vencido":"1348048.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"1348058.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"-10.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"1","days_before_last_invoice":"130","last_update_quota":"2026-06-25","date_first_sale":"2019-05-21","payment_method_rf":"N","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280839"},{"country_code":"CO","customer_code":"1098612021","email":null,"email_fe":"davidoliveros@hotmail.com","first_surname":"OLIVEROS","second_surname":"MADIEDO","first_name":"DAVID","second_name":"RENE","complete_name":"OLIVEROS MADIEDO DAVID RENE","phone":"3187121913","phone2":"","fax_number":"","mobile_number":"","address":"CALLE 15 NO. 19-43 B. SAN FRANCISCO","city_code":"68001","city_name":"BUCARAMANGA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG36","seller_name":"HERRERA L JORGE LEONA","seller_email":"jherrera@automundial.com.co","invoice_period":"39","bill_rejects":"S","bill_secure":"S","creation_date":"2013-11-21","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2025-01-23","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"15","last_update_quota":"2026-06-25","date_first_sale":"2013-11-30","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280838"},{"country_code":"CO","customer_code":"1140863553","email":null,"email_fe":"crestrepoj@hotmail.com","first_surname":"RESTREPO","second_surname":"VALDES","first_name":"CARLOS","second_name":"MARIO","complete_name":"RESTREPO VALDES CARLOS MARIO","phone":"3204585954","phone2":"3145967110","fax_number":"","mobile_number":"3204585954","address":"CLL 133 NO.51B-40 BARRIO VILLA CAMPESTRE","city_code":"08001","city_name":"BARRANQUILLA","department_code":"08","department_name":"ATLANTICO","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG40","seller_name":"SANDRA MUNOZ","seller_email":"slmunoz@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2021-10-11","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2021-12-07","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2022-08-29","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"1","last_update_quota":"2026-06-25","date_first_sale":"2021-10-11","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280837"},{"country_code":"CO","customer_code":"901178879","email":"macaresfo@hotmail.com","email_fe":"macaresfo@hotmail.com","first_surname":"","second_surname":"","first_name":"CONSTRUCCIONES MACARES SAS","second_name":"","complete_name":"CONSTRUCCIONES MACARES SAS","phone":"","phone2":"","fax_number":"","mobile_number":"3144139769","address":"FCA SANTA BARBARA UNO VDA SIATOCA ABAJO","city_code":"15187","city_name":"CHIVATA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYK","seller_name":"CORTES CARLOS ARTURO","seller_email":"ccortes@automundial.com.co","invoice_period":"39","bill_rejects":"S","bill_secure":"N","creation_date":"2022-01-19","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-09-30","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"macaresfo@hotmail.com","discount":"30.00","contado":"-40000.0","por_vencer":"0.0","vencido":"-40000.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"-40000.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"763","last_update_quota":"2026-06-25","date_first_sale":"2022-02-28","payment_method_rf":"N","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280844"},{"country_code":"CO","customer_code":"900803020","email":null,"email_fe":"gcpoblado@gmail.com","first_surname":"","second_surname":"","first_name":"GRUPO CORPORATIVO POBLADO S.A.S.","second_name":"","complete_name":"GRUPO CORPORATIVO POBLADO S.A.S.","phone":"","phone2":"","fax_number":"","mobile_number":"3107515271","address":"CALLE 75A NO. 66-51","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BT81","seller_name":"ABOGADO GRUPO CONCRED","seller_email":"","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2019-05-04","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-01-23","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"4322123.0","mark":"S","branch":"N","branch_code":"","customer_group":"FCO","contract_pcpk":"A","contact":null,"email_contact":null,"discount":"0.00","contado":"78122692.0","por_vencer":"0.0","vencido":"78122692.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"78122692.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"11","days_before_last_invoice":"2","last_update_quota":"2026-06-25","date_first_sale":"2019-12-19","payment_method_rf":"N","customer_category":"AA","type_record":"UPDATE","idmovimiento":"88280836"},{"country_code":"CO","customer_code":"1093737864","email":"rosa.gomez1986@yahoo.com.co","email_fe":"crgm1986@gmail.com","first_surname":"GOMEZ","second_surname":"MOLINA","first_name":"CARMEN","second_name":"ROSA","complete_name":"GOMEZ MOLINA CARMEN ROSA","phone":"3208505702","phone2":"","fax_number":"","mobile_number":"3132704268","address":"TV 26 33 B 135","city_code":"08001","city_name":"BARRANQUILLA","department_code":"08","department_name":"ATLANTICO","country":"169","name_country":"COLOMBIA","region_code":"005","region_name":"COSTA ATLANTICA","customer_type":"PAR","seller_code":"BT81","seller_name":"ABOGADO GRUPO CONCRED","seller_email":"","invoice_period":"01","bill_rejects":"S","bill_secure":"S","creation_date":"2022-02-05","status":"C","status_name":"CLIENTE CON CARTERA CASTIGADA","observation":"","last_invoice_date":"2023-06-15","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"rosa.gomez1986@yahoo.com.co","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"31","last_update_quota":"2026-06-25","date_first_sale":"2022-02-11","payment_method_rf":"S","customer_category":"","type_record":"UPDATE","idmovimiento":"88280833"},{"country_code":"CO","customer_code":"1101757361","email":"chuyito1592_@hotmail.com","email_fe":"chuyito1592_@hotmail.com","first_surname":"SUAREZ","second_surname":"PARDO","first_name":"JHORMAN","second_name":"DAVID","complete_name":"SUAREZ PARDO JHORMAN DAVID","phone":"","phone2":"0","fax_number":"","mobile_number":"3142422179","address":"CR 2      # 3A-44BRR RICAUTE","city_code":"68861","city_name":"VELEZ","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"005","region_name":"COSTA ATLANTICA","customer_type":"PAR","seller_code":"BQ19","seller_name":"RIASCOS HEIDY","seller_email":"hriascos@automundial.com.co","invoice_period":"39","bill_rejects":"S","bill_secure":"N","creation_date":"2022-03-31","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-08-09","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":"2023-05-03","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"chuyito1592_@hotmail.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"324","last_update_quota":"2026-06-25","date_first_sale":"2022-03-31","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280835"},{"country_code":"CO","customer_code":"900120877","email":null,"email_fe":"inv.flotahuila@hotmail.com","first_surname":"","second_surname":"","first_name":"INVERSIONES FLOTA HUILA S.A","second_name":"","complete_name":"INVERSIONES FLOTA HUILA S.A","phone":"6088734648","phone2":"3013309403","fax_number":"","mobile_number":"3164674483","address":"CLL 19 SUR NO 10-18 ZONA INDUSTRIAL","city_code":"41001","city_name":"NEIVA","department_code":"41","department_name":"HUILA","country":"169","name_country":"COLOMBIA","region_code":"006","region_name":"TOLIMA HUILA","customer_type":"DIS","seller_code":"NE10","seller_name":"JOSE LUIS PERDOMO","seller_email":"jperdomo@automundial.com.co","invoice_period":"01","bill_rejects":null,"bill_secure":null,"creation_date":"2015-02-11","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-12-09","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":"2022-10-07","average_sales":"0.0","mark":"S","branch":"S","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"CARLOS GARAVITO","email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"9","last_update_quota":"2026-06-25","date_first_sale":"2015-02-28","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280834"},{"country_code":"CO","customer_code":"91254986","email":"mrvinmendez1967@gmail.com","email_fe":"marvinmendez1967@gmail.com","first_surname":"MENDEZ","second_surname":"BAUTISTA","first_name":"MARVIN","second_name":"","complete_name":"MENDEZ BAUTISTA MARVIN","phone":"","phone2":"","fax_number":"","mobile_number":"3144149091","address":"CRA 9 B OCCIDENTE #41-44","city_code":"68001","city_name":"BUCARAMANGA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG36","seller_name":"HERRERA L JORGE LEONA","seller_email":"jherrera@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"N","creation_date":"2019-10-21","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-12-09","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"16000000.00","actualization_date":null,"average_sales":"325333.33333333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"mrvinmendez1967@gmail.com","discount":"35.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"333","last_update_quota":"2026-06-25","date_first_sale":"2019-10-21","payment_method_rf":"S","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280606"},{"country_code":"CO","customer_code":"91219681","email":"aliriobg19@gmail.com","email_fe":"aliriobg19@gmail.com","first_surname":"BARAJAS","second_surname":"GOMEZ","first_name":"PEDRO","second_name":"ALIRIO","complete_name":"BARAJAS GOMEZ PEDRO ALIRIO","phone":"6076396816","phone2":"","fax_number":"","mobile_number":"3153752068","address":"RUITOQUE CONDOMINIO BALMORAL CASA 38","city_code":"68276","city_name":"FLORIDABLANCA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BGJ","seller_name":"JAIME SUAREZ","seller_email":"jsuarez@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"S","creation_date":"1997-03-01","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-04-28","contributory_code":"2","contributory_name":"PERSONAS NATURALES RETENEDORAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"17496.66666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"aliriobg19@gmail.com","discount":"38.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"84","last_update_quota":"2026-06-25","date_first_sale":"2005-08-05","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280605"},{"country_code":"CO","customer_code":"900078484","email":"servicar_gerencia@hotmail.com","email_fe":"gerencia@torrescarsa.com","first_surname":"","second_surname":"","first_name":"TORRESCAR S.A.","second_name":"","complete_name":"TORRESCAR S.A.","phone":"6076450551","phone2":"3187348159","fax_number":"","mobile_number":"3158112051","address":"AV. QUEBRADASECA NO. 21-07","city_code":"68001","city_name":"BUCARAMANGA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"013","region_name":"LEY 1116","customer_type":"DIS","seller_code":"BG31","seller_name":"GOMEZ JAIME ANDRES","seller_email":"jgomez@automundial.com.co","invoice_period":"39","bill_rejects":"S","bill_secure":"N","creation_date":"2007-04-24","status":"B","status_name":"CLIENTE ACTIVO","observation":"ADMINISTRADOR: EDGAR NAVAS","last_invoice_date":"2026-04-28","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"1324999.666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"DIS","contract_pcpk":"N","contact":null,"email_contact":"servicar_gerencia@hotmail.com","discount":"40.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"45","last_update_quota":"2026-06-25","date_first_sale":"2007-04-27","payment_method_rf":"N","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280604"},{"country_code":"CO","customer_code":"804010104","email":null,"email_fe":"servinacional@hotmail.com","first_surname":"","second_surname":"","first_name":"SERVINACIONAL","second_name":"","complete_name":"SERVINACIONAL","phone":"6334631","phone2":"","fax_number":"","mobile_number":"","address":"CRA. 12  #26-26 GIRARDOT","city_code":"68001","city_name":"BUCARAMANGA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"DIS","seller_code":"BG36","seller_name":"HERRERA L JORGE LEONA","seller_email":"jherrera@automundial.com.co","invoice_period":"03","bill_rejects":null,"bill_secure":null,"creation_date":"2000-10-18","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-12-05","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"10000000.00","actualization_date":null,"average_sales":"54808.83333333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"DIS","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"45.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"387","last_update_quota":"2026-06-25","date_first_sale":"2005-09-03","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280603"},{"country_code":"CO","customer_code":"1020829685","email":null,"email_fe":"brader.transport@gmail.com","first_surname":"DELGADO","second_surname":"","first_name":"BRAYAN","second_name":"ALEJANDRO","complete_name":"DELGADO  BRAYAN ALEJANDRO","phone":"3185911899","phone2":"","fax_number":"","mobile_number":"","address":"AVENIDA CORDIALIDAD","city_code":"08001","city_name":"BARRANQUILLA","department_code":"08","department_name":"ATLANTICO","country":"169","name_country":"COLOMBIA","region_code":"005","region_name":"COSTA ATLANTICA","customer_type":"PAR","seller_code":"BAG","seller_name":"LEGUIZAMON FATIMA","seller_email":"fleguizamon@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2020-10-17","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2024-10-08","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"3000000.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"388","last_update_quota":"2026-06-25","date_first_sale":"2020-10-17","payment_method_rf":"S","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280602"},{"country_code":"CO","customer_code":"1096186779","email":"andre182_@hotmail.com","email_fe":"andre182_@hotmail.com","first_surname":"NIETO","second_surname":"LEAL","first_name":"VICTOR","second_name":"ANDRES","complete_name":"NIETO LEAL VICTOR ANDRES","phone":"","phone2":"","fax_number":"","mobile_number":"3123804674","address":"EDS SAN ANDRES","city_code":"68081","city_name":"BARRANCABERMEJA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG14","seller_name":"RICO RIATIGA HECTOR ARMANDO","seller_email":"hrico@automundial.com.co","invoice_period":"39","bill_rejects":"S","bill_secure":"S","creation_date":"2019-11-07","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2025-09-23","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"3820.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"andre182_@hotmail.com","discount":"38.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"64","last_update_quota":"2026-06-25","date_first_sale":"2019-11-18","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280601"},{"country_code":"CO","customer_code":"23764302","email":null,"email_fe":"celyllantas@hotmail.com","first_surname":"MONTANEZ","second_surname":"GUTIERREZ","first_name":"MARIA","second_name":"DEL CARMEN","complete_name":"MONTANEZ GUTIERREZ MARIA DEL CARMEN","phone":"7720897","phone2":"","fax_number":"","mobile_number":"3115929057","address":"CR 20 11A 57","city_code":"15759","city_name":"SOGAMOSO","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"DIS","seller_code":"BYU","seller_name":"CHINOME ZANDRA","seller_email":"zchinome@automundial.com.co","invoice_period":"39","bill_rejects":"N","bill_secure":"N","creation_date":"2007-09-12","status":"B","status_name":"CLIENTE ACTIVO","observation":"EL CLIENTE TIENE CHEQUES DEVUELTOS","last_invoice_date":"2026-05-20","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"30000000.00","actualization_date":null,"average_sales":"760000.0","mark":"S","branch":"N","branch_code":"","customer_group":"DIS","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"26.50","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"909","last_update_quota":"2026-06-25","date_first_sale":"2005-08-10","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280600"},{"country_code":"CO","customer_code":"891801604","email":"cootranscol9@yahoo.es","email_fe":"cootranscol9@yahoo.es","first_surname":"","second_surname":"","first_name":"COOPERATIVA INTEGRAL DE TRANSPORTES COLONIAL COOTR","second_name":"","complete_name":"COOPERATIVA INTEGRAL DE TRANSPORTES COLONIAL COO","phone":"","phone2":"","fax_number":"","mobile_number":"3104844333","address":"CL 12 6 26","city_code":"15001","city_name":"TUNJA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"DIS","seller_code":"BYU","seller_name":"CHINOME ZANDRA","seller_email":"zchinome@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2004-10-28","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"EL CLIENTE NO TIENE CUPO PARA ELABORARLE ESTE DESPACHO","last_invoice_date":"2022-08-08","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":"2023-09-13","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"DIS","contract_pcpk":"N","contact":"ARMANDO","email_contact":"cootranscol9@yahoo.es","discount":"20.70","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"130","last_update_quota":"2026-06-25","date_first_sale":"2005-08-11","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280599"},{"country_code":"CO","customer_code":"74860678","email":"fredygutierrez74@hotmail.com","email_fe":"fredygutierrez74@hotmail.com","first_surname":"GUTIERREZ","second_surname":"","first_name":"FREDY","second_name":"ARNALDO","complete_name":"GUTIERREZ  FREDY ARNALDO","phone":"","phone2":"","fax_number":"","mobile_number":"3212097557","address":"CRA 14B N 37A - 30","city_code":"85001","city_name":"YOPAL","department_code":"85","department_name":"CASANARE","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYW","seller_name":"CRISTIAN CASTILLO","seller_email":"ccastillo@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"S","creation_date":"2018-09-21","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-02-22","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"fredygutierrez74@hotmail.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"1090","last_update_quota":"2026-06-25","date_first_sale":"2018-09-21","payment_method_rf":"S","customer_category":"","type_record":"UPDATE","idmovimiento":"88280607"},{"country_code":"CO","customer_code":"844000205","email":"aux-contable@tecnitransportes.com","email_fe":"facturacion@tecnitransportes.com","first_surname":"","second_surname":"","first_name":"TECNITRANSPORTES SAS","second_name":"","complete_name":"TECNITRANSPORTES SAS","phone":"","phone2":"3102302560","fax_number":"","mobile_number":"3107730227","address":"KM 2 VIA YOPAL - AGUAZUL","city_code":"85001","city_name":"YOPAL","department_code":"85","department_name":"CASANARE","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"FNT","seller_code":"BYL","seller_name":"PEDRAZA GLORIA MERCEDES","seller_email":"gpedraza@automundial.com.co","invoice_period":"06","bill_rejects":"N","bill_secure":"N","creation_date":"2001-09-07","status":"B","status_name":"CLIENTE ACTIVO","observation":"EL CLIENTE TIENE CHEQUES DEVUELTOS","last_invoice_date":"2026-05-30","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"80000000.00","actualization_date":"2022-12-15","average_sales":"8070512.0","mark":"S","branch":"N","branch_code":"","customer_group":"FCO","contract_pcpk":"N","contact":"CARLOS JULIO","email_contact":"aux-contable@tecnitransportes.com","discount":"38.00","contado":"-2045003.0","por_vencer":"0.0","vencido":"-2045003.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"-2045003.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"91","last_update_quota":"2026-06-25","date_first_sale":"2005-10-29","payment_method_rf":"N","customer_category":"AAA","type_record":"UPDATE","idmovimiento":"88280598"},{"country_code":"CO","customer_code":"1098703588","email":"mauro_9108@hotmail.com","email_fe":"mauro_9108@hotmail.com","first_surname":"PENA","second_surname":"MERCHAN","first_name":"OSCAR","second_name":"MAURICIO","complete_name":"PENA MERCHAN OSCAR MAURICIO","phone":"3222958528","phone2":"","fax_number":"","mobile_number":"3209142874","address":"CLL 16A #7B-77","city_code":"54405","city_name":"LOS PATIOS","department_code":"54","department_name":"NORTE DE SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"002","region_name":"OCCIDENTE","customer_type":"PAR","seller_code":"CA15","seller_name":"CIRO SANTOS MARIA FERNANDA","seller_email":"mciro@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2022-03-12","status":"V","status_name":"VENDIO VEHICULOS","observation":"","last_invoice_date":"2023-08-01","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"mauro_9108@hotmail.com","discount":"0.00","contado":"-767000.0","por_vencer":"0.0","vencido":"-767000.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"-767000.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"1","last_update_quota":"2026-06-25","date_first_sale":"2022-03-15","payment_method_rf":"S","customer_category":"","type_record":"UPDATE","idmovimiento":"88280593"},{"country_code":"CO","customer_code":"1002092429","email":"llanteriaomnipotentes@gmail.com","email_fe":"llanteriaomnipotentes@gmail.com","first_surname":"PADILLA","second_surname":"DE LA RAN","first_name":"ANA","second_name":"ISABEL","complete_name":"PADILLA DE LA RAN ANA ISABEL","phone":"3335952","phone2":"","fax_number":"","mobile_number":"3045818286","address":"CLL 110 AC 6-335","city_code":"08001","city_name":"BARRANQUILLA","department_code":"08","department_name":"ATLANTICO","country":"169","name_country":"COLOMBIA","region_code":"005","region_name":"COSTA ATLANTICA","customer_type":"DIS","seller_code":"BQ23","seller_name":"BERNAL KANYA","seller_email":"kbernal@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2020-08-13","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2023-02-06","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"llanteriaomnipotentes@gmail.com","discount":"45.40","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"9","last_update_quota":"2026-06-25","date_first_sale":"2020-10-31","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280597"},{"country_code":"CO","customer_code":"900998932","email":null,"email_fe":"concretransportessas@gmail.com","first_surname":"","second_surname":"","first_name":"CONCRETRANSPORTES SAS","second_name":"","complete_name":"CONCRETRANSPORTES SAS","phone":"6447255","phone2":"","fax_number":"","mobile_number":"3116975063","address":"SECTOR DO\u00f1A MANUELA BARRIO TERNERA LT1","city_code":"13001","city_name":"CARTAGENA","department_code":"13","department_name":"BOLIVAR","country":"169","name_country":"COLOMBIA","region_code":"005","region_name":"COSTA ATLANTICA","customer_type":"IND","seller_code":"BQ19","seller_name":"RIASCOS HEIDY","seller_email":"hriascos@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"N","creation_date":"2019-06-29","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-06-20","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"20000000.00","actualization_date":null,"average_sales":"2250662.666666666666666666666667","mark":"S","branch":"N","branch_code":"","customer_group":"FCO","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"560379.0","por_vencer":"162993.0","vencido":"397386.0","de_0_a_15_dias":"23800.0","de_16_a_30_dias":"162993.0","de_31_a_45_dias":"23800.0","de_46_a_60_dias":"162993.0","de_61_a_75_dias":"23800.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"1","days_before_last_invoice":"2","last_update_quota":"2026-06-25","date_first_sale":"2020-02-05","payment_method_rf":"N","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280596"},{"country_code":"CO","customer_code":"13718742","email":null,"email_fe":"javierportilla@covolco.com","first_surname":"PORTILLA","second_surname":"SUAREZ","first_name":"JAVIER","second_name":"","complete_name":"PORTILLA SUAREZ JAVIER","phone":"6076458903","phone2":"","fax_number":"","mobile_number":"3102459894","address":"CLL 65 NO.47-26 BARRIO LA FLORESTA","city_code":"68001","city_name":"BUCARAMANGA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG36","seller_name":"HERRERA L JORGE LEONA","seller_email":"jherrera@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2001-06-12","status":"D","status_name":"DUDOSO RECAUDO","observation":"","last_invoice_date":"2024-10-24","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"S","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"35.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"22","last_update_quota":"2026-06-25","date_first_sale":"2007-09-29","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280595"},{"country_code":"CO","customer_code":"800253444","email":null,"email_fe":"asistente.empresascfc@gmail.com","first_surname":"","second_surname":"","first_name":"CFC PROCESADORA DE ALIMENTOS S.A.S","second_name":"","complete_name":"CFC PROCESADORA DE ALIMENTOS S.A.S","phone":"6025575075","phone2":"","fax_number":"","mobile_number":"3224632194","address":"CARRERA 7 N\u00c2\u00b0 134 BODEGA 20 PARQUE INDUSTRIAL LAS","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"PAR","seller_code":"BT33","seller_name":"GARCIA WILCHES WILLIAM","seller_email":"wgarcia@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2022-03-31","status":"C","status_name":"CLIENTE CON CARTERA CASTIGADA","observation":"","last_invoice_date":"2022-04-02","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"35.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"0","last_update_quota":"2026-06-25","date_first_sale":"2022-04-02","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280594"},{"country_code":"CO","customer_code":"4602587","email":null,"email_fe":"jorge.ramirez56@gmail.com","first_surname":"RAMIREZ","second_surname":"RAMIREZ","first_name":"JORGE","second_name":"LUIS","complete_name":"RAMIREZ RAMIREZ JORGE LUIS","phone":"3183973959","phone2":"","fax_number":"","mobile_number":"3183973959","address":"CRA 11 # 8-40 CENTRO","city_code":"17877","city_name":"VITERBO","department_code":"17","department_name":"CALDAS","country":"169","name_country":"COLOMBIA","region_code":"008","region_name":"VIEJO CALDAS","customer_type":"PAR","seller_code":"PE12","seller_name":"ZAPATA ANZOLA MIGUEL","seller_email":"mzapata@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"N","creation_date":"2019-05-28","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2025-06-05","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"6000000.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"187","last_update_quota":"2026-06-25","date_first_sale":"2019-07-05","payment_method_rf":"S","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280592"},{"country_code":"CO","customer_code":"901061899","email":"direccion@ferremontana.com","email_fe":"direccion@ferremontana.com","first_surname":"","second_surname":"","first_name":"FERREMONTANAS S.A.S.","second_name":"","complete_name":"FERREMONTANAS S.A.S.","phone":"8513364","phone2":"","fax_number":"","mobile_number":"3206720018","address":"CORREGIMIENTO DE PINGURO SEC LA TRAVESIA","city_code":"05001","city_name":"MEDELLIN","department_code":"05","department_name":"ANTIOQUIA","country":"169","name_country":"COLOMBIA","region_code":"003","region_name":"ANTIOQUIA","customer_type":"PAR","seller_code":"ME30","seller_name":"OCHOA EDWIN ALEXANDER","seller_email":"eochoa@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2020-12-04","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2025-03-17","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":"CONTADO","email_contact":"direccion@ferremontana.com","discount":"32.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"228","last_update_quota":"2026-06-25","date_first_sale":"2020-12-15","payment_method_rf":"N","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280591"},{"country_code":"CO","customer_code":"826001767","email":"transunicol@hotmail.com","email_fe":"transunicol@hotmail.com","first_surname":"","second_surname":"","first_name":"TRANSPORTADORES UNIDOS DE COLOMBIA SA","second_name":"","complete_name":"TRANSPORTADORES UNIDOS DE COLOMBIA SA","phone":"","phone2":"3124332129","fax_number":"","mobile_number":"3153723441","address":"KM 3 VIA DUITAMA PAIPA","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYU","seller_name":"CHINOME ZANDRA","seller_email":"zchinome@automundial.com.co","invoice_period":"06","bill_rejects":"S","bill_secure":"N","creation_date":"2008-11-12","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-05-30","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"100000000.00","actualization_date":"2022-10-18","average_sales":"1382942.333333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"FLO","contract_pcpk":"N","contact":"ALEJANDRO","email_contact":"transunicol@hotmail.com","discount":"20.50","contado":"5369656.01","por_vencer":"0.0","vencido":"5369656.01","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"999633.34","de_46_a_60_dias":"1054500.0","de_61_a_75_dias":"999633.34","de_76_a_90_dias":"1488401.99","de_91_a_105_dias":"999633.34","de_106_a_120_dias":"0.0","mas_de_120_dias":"-172146.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"4","days_before_last_invoice":"15","last_update_quota":"2026-06-25","date_first_sale":"2008-11-26","payment_method_rf":"S","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280590"},{"country_code":"CO","customer_code":"91282877","email":"betoafanador@gmail.com","email_fe":"betoafanador@gmail.com","first_surname":"AFANADOR","second_surname":"HERNANDEZ","first_name":"ELIBERTO","second_name":"","complete_name":"AFANADOR HERNANDEZ ELIBERTO","phone":"","phone2":"","fax_number":"","mobile_number":"3134190139","address":"CARRERA 29D 20-25 APTO 1 SAN ALONSO","city_code":"68001","city_name":"BUCARAMANGA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BGJ","seller_name":"JAIME SUAREZ","seller_email":"jsuarez@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"N","creation_date":"2000-04-03","status":"B","status_name":"CLIENTE ACTIVO","observation":"RESPALDO COVICHEQUEDOCUMENTOS COMPLETOSOJO DATA","last_invoice_date":"2026-06-01","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"60000000.00","actualization_date":null,"average_sales":"2354502.833333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"betoafanador@gmail.com","discount":"38.00","contado":"5152438.0","por_vencer":"0.0","vencido":"5152438.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"353333.33","de_31_a_45_dias":"353333.33","de_46_a_60_dias":"353333.33","de_61_a_75_dias":"786666.0","de_76_a_90_dias":"786666.0","de_91_a_105_dias":"786666.0","de_106_a_120_dias":"433331.34","mas_de_120_dias":"1299108.67","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"5","days_before_last_invoice":"17","last_update_quota":"2026-06-25","date_first_sale":"2005-08-09","payment_method_rf":"S","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280588"},{"country_code":"CO","customer_code":"1002528517","email":"jp.hernandezr1@outlook.com","email_fe":"juan.pablo.hernandez.r.06@gmail.com","first_surname":"HERNANDEZ","second_surname":"ROJAS","first_name":"JUAN","second_name":"PABLO","complete_name":"HERNANDEZ ROJAS JUAN PABLO","phone":"","phone2":"","fax_number":"","mobile_number":"3102023752","address":"CL 13 27 60 APTO 106","city_code":"11001","city_name":"BOGOTA","department_code":"11","department_name":"BOGOTA D.C","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYU","seller_name":"CHINOME ZANDRA","seller_email":"zchinome@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"S","creation_date":"2022-01-31","status":"E","status_name":"DESBLOQUEO ESPECIAL","observation":"","last_invoice_date":"2024-10-24","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"15000000.00","actualization_date":"2022-10-22","average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"jp.hernandezr1@outlook.com","discount":"30.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"41","last_update_quota":"2026-06-25","date_first_sale":"2022-01-31","payment_method_rf":"S","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280587"},{"country_code":"CO","customer_code":"10222240","email":"LUCHISQUINTEROC@GMAIL.COM","email_fe":"luchisquinteroc@gmail.com","first_surname":"QUINTERO","second_surname":"CRUZ","first_name":"LUIS","second_name":"ALBERTO","complete_name":"QUINTERO CRUZ LUIS ALBERTO","phone":"8739261","phone2":"","fax_number":"","mobile_number":"3108222905","address":"CRA 42C NO.10C-06 SDO PISO","city_code":"17001","city_name":"MANIZALES","department_code":"17","department_name":"CALDAS","country":"169","name_country":"COLOMBIA","region_code":"008","region_name":"VIEJO CALDAS","customer_type":"DIS","seller_code":"PE11","seller_name":"LADINO CHIQUITO CLISSMAN LEA","seller_email":"cladino@automundial.com.co","invoice_period":"01","bill_rejects":null,"bill_secure":null,"creation_date":"2010-11-02","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2023-09-19","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"LUCHISQUINTEROC@GMAIL.COM","discount":"30.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"117","last_update_quota":"2026-06-25","date_first_sale":"2010-11-12","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280586"},{"country_code":"CO","customer_code":"900318997","email":"gestiondocumental@agregadosdelasierra.com","email_fe":"gestiondocumental@agregadosdelasierra.com","first_surname":"","second_surname":"","first_name":"AGREGADOS DE LA SIERRA S.A.","second_name":"","complete_name":"AGREGADOS DE LA SIERRA S.A.","phone":"4444744","phone2":"6040111","fax_number":"","mobile_number":"","address":"CALLE 18 N.35-69 OFICINA 412","city_code":"05001","city_name":"MEDELLIN","department_code":"05","department_name":"ANTIOQUIA","country":"169","name_country":"COLOMBIA","region_code":"003","region_name":"ANTIOQUIA","customer_type":"INF","seller_code":"ME30","seller_name":"OCHOA EDWIN ALEXANDER","seller_email":"eochoa@automundial.com.co","invoice_period":"03","bill_rejects":"S","bill_secure":"N","creation_date":"2013-04-06","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2025-02-05","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"20000000.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"S","branch_code":"","customer_group":"FLO","contract_pcpk":"N","contact":"CREADO CON SOLICITUD DE CREDIT","email_contact":"gestiondocumental@agregadosdelasierra.com","discount":"26.50","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No reencauche pero si llanta nueva","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"63","last_update_quota":"2026-06-25","date_first_sale":"2013-04-10","payment_method_rf":"N","customer_category":"AA","type_record":"UPDATE","idmovimiento":"88280585"},{"country_code":"CO","customer_code":"24551975","email":"PAO-MONY-PIPE@HOTMAIL.COM","email_fe":"paola.lopez0302@gmail.com","first_surname":"LOPEZ","second_surname":"LOPEZ","first_name":"PAULA","second_name":"ANDREA","complete_name":"LOPEZ LOPEZ PAULA ANDREA","phone":"3421400","phone2":"","fax_number":"","mobile_number":"3146426773","address":"MZ 20 CASA 25 VILLA DEL CAMPO DOS QUEBRADAS","city_code":"66170","city_name":"DOSQUEBRADAS","department_code":"66","department_name":"RISARALDA","country":"169","name_country":"COLOMBIA","region_code":"008","region_name":"VIEJO CALDAS","customer_type":"PAR","seller_code":"PE12","seller_name":"ZAPATA ANZOLA MIGUEL","seller_email":"mzapata@automundial.com.co","invoice_period":"07","bill_rejects":null,"bill_secure":null,"creation_date":"2014-06-20","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-03-16","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"5000000.00","actualization_date":null,"average_sales":"306666.58333333333333333333333333","mark":"S","branch":"S","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"PAO-MONY-PIPE@HOTMAIL.COM","discount":"35.00","contado":"2207999.0","por_vencer":"0.0","vencido":"2207999.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"735999.8","de_46_a_60_dias":"0.0","de_61_a_75_dias":"735999.8","de_76_a_90_dias":"0.0","de_91_a_105_dias":"735999.4","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"1","days_before_last_invoice":"270","last_update_quota":"2026-06-25","date_first_sale":"2015-03-31","payment_method_rf":"S","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280584"},{"country_code":"CO","customer_code":"900870549","email":null,"email_fe":"facturacion@sercopalma.com","first_surname":"","second_surname":"","first_name":"SERCOPALMA SAS","second_name":"","complete_name":"SERCOPALMA SAS","phone":"3207889436","phone2":"3144379886","fax_number":"","mobile_number":"","address":"CL 7A KR 16 MZ 419 CA 17 P 01","city_code":"76001","city_name":"CALI","department_code":"76","department_name":"VALLE DEL CAUCA","country":"169","name_country":"COLOMBIA","region_code":"002","region_name":"OCCIDENTE","customer_type":"PAR","seller_code":"CA64","seller_name":"PENA LINA","seller_email":"lpena@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2018-09-25","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2023-02-23","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"1","last_update_quota":"2026-06-25","date_first_sale":"2018-09-25","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280583"},{"country_code":"CO","customer_code":"37751710","email":null,"email_fe":"nubiaapp2005@hotmail.com","first_surname":"PLATA","second_surname":"PAEZ","first_name":"RAQUEL","second_name":"","complete_name":"PLATA PAEZ RAQUEL","phone":"","phone2":"","fax_number":"","mobile_number":"3124352969","address":"CLL 101 N. 23-49 PROVENZA","city_code":"68001","city_name":"BUCARAMANGA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG36","seller_name":"HERRERA L JORGE LEONA","seller_email":"jherrera@automundial.com.co","invoice_period":"07","bill_rejects":"S","bill_secure":"N","creation_date":"2019-05-21","status":"B","status_name":"CLIENTE ACTIVO","observation":"EL CLIENTE TIENE CHEQUES DEVUELTOS","last_invoice_date":"2025-10-25","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"3000000.00","actualization_date":null,"average_sales":"154025.33333333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"35.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"358","last_update_quota":"2026-06-25","date_first_sale":"2019-05-23","payment_method_rf":"N","customer_category":"B","type_record":"UPDATE","idmovimiento":"88280589"},{"country_code":"CO","customer_code":"51652129","email":"mcastillo746@hotmail.com","email_fe":"mcastillo746@hotmail.com","first_surname":"CASTILLO","second_surname":"MORA","first_name":"MELBA","second_name":"LUCIA","complete_name":"CASTILLO MORA MELBA LUCIA","phone":"5165212","phone2":"","fax_number":"","mobile_number":"3173814796","address":"CALLE 30A # 83 - 25","city_code":"05001","city_name":"MEDELLIN","department_code":"05","department_name":"ANTIOQUIA","country":"169","name_country":"COLOMBIA","region_code":"001","region_name":"CENTRO","customer_type":"PAR","seller_code":"BT75","seller_name":"ESTUPINAN IRMA","seller_email":"iestupinan@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2016-08-13","status":"D","status_name":"DUDOSO RECAUDO","observation":"","last_invoice_date":"2024-06-05","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"S","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"mcastillo746@hotmail.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"217","last_update_quota":"2026-06-25","date_first_sale":"2016-09-01","payment_method_rf":"S","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280582"},{"country_code":"CO","customer_code":"91497594","email":"pablocesarestupinan@hotmail.com","email_fe":"pablocesarestupinan@hotmail.com","first_surname":"ESTUPINAN","second_surname":"RUIZ","first_name":"JUANO","second_name":"PABLO","complete_name":"ESTUPINAN RUIZ PABLO","phone":"3134317232","phone2":"","fax_number":"","mobile_number":"","address":"CALLE 4A NO.16A-56","city_code":"68547","city_name":"PIEDECUESTA","department_code":"68","department_name":"SANTANDER","country":"169","name_country":"COLOMBIA","region_code":"004","region_name":"SANTANDER","customer_type":"PAR","seller_code":"BG32","seller_name":"LEON SILVA SANDY BIAN","seller_email":"sleon@automundial.com.co","invoice_period":"01","bill_rejects":"S","bill_secure":"N","creation_date":"2010-01-26","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"CONTADO","last_invoice_date":"2022-03-31","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"S","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"pablocesarestupinan@hotmail.com","discount":"18.50","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"541","last_update_quota":"2026-06-25","date_first_sale":"2010-01-26","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280347"},{"country_code":"CO","customer_code":"27115591","email":"miralbamontero@gmail.com","email_fe":"miralbamontero@gmail.com","first_surname":"MONTERO","second_surname":"","first_name":"MIRALBA","second_name":"","complete_name":"MONTERO  MIRALBA","phone":"","phone2":"3105127125","fax_number":"","mobile_number":"3105127125","address":"CRA 47B #51-82","city_code":"76001","city_name":"CALI","department_code":"76","department_name":"VALLE DEL CAUCA","country":"169","name_country":"COLOMBIA","region_code":"002","region_name":"OCCIDENTE","customer_type":"PAR","seller_code":"CA15","seller_name":"CIRO SANTOS MARIA FERNANDA","seller_email":"mciro@automundial.com.co","invoice_period":"01","bill_rejects":"N","bill_secure":"N","creation_date":"2022-02-16","status":"K","status_name":"CLIENTE SIN COMPRAS ULTIMO ANO","observation":"","last_invoice_date":"2022-04-23","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"0.00","actualization_date":null,"average_sales":"0.0","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"miralbamontero@gmail.com","discount":"0.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"","gestion_comercial":"N","cantidad_facturas_vencidas":"0","days_before_last_invoice":"0","last_update_quota":"2026-06-25","date_first_sale":"2022-04-23","payment_method_rf":"N","customer_category":"","type_record":"UPDATE","idmovimiento":"88280581"},{"country_code":"CO","customer_code":"901135926","email":null,"email_fe":"alex-arias32@hotmail.com","first_surname":"","second_surname":"","first_name":"TRANSPORTES AAA SAS","second_name":"","complete_name":"TRANSPORTES AAA SAS","phone":"","phone2":"","fax_number":"","mobile_number":"3207128979","address":"CR 35  43D 12","city_code":"05001","city_name":"MEDELLIN","department_code":"05","department_name":"ANTIOQUIA","country":"169","name_country":"COLOMBIA","region_code":"003","region_name":"ANTIOQUIA","customer_type":"PAR","seller_code":"ME66","seller_name":"JENNIFER ORTIZ","seller_email":"gortiz@automundial.com.co","invoice_period":"39","bill_rejects":"S","bill_secure":"N","creation_date":"2020-02-21","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-03-18","contributory_code":"3","contributory_name":"PERSONAS JURIDICAS","assigned_quota":"0.00","actualization_date":null,"average_sales":"305772.5","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"30.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No llanta nueva pero si reencauche","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"869","last_update_quota":"2026-06-25","date_first_sale":"2020-03-12","payment_method_rf":"N","customer_category":"C","type_record":"UPDATE","idmovimiento":"88280580"},{"country_code":"CO","customer_code":"890911431","email":null,"email_fe":"facturacion@coninsa.co","first_surname":"","second_surname":"","first_name":"CONINSA S.A.S.","second_name":"","complete_name":"CONINSA S.A.S.","phone":"5116199","phone2":"3091044","fax_number":"","mobile_number":"","address":"CALLE 55 N.45-55","city_code":"05001","city_name":"MEDELLIN","department_code":"05","department_name":"ANTIOQUIA","country":"169","name_country":"COLOMBIA","region_code":"003","region_name":"ANTIOQUIA","customer_type":"INF","seller_code":"ME30","seller_name":"OCHOA EDWIN ALEXANDER","seller_email":"eochoa@automundial.com.co","invoice_period":"03","bill_rejects":"N","bill_secure":"N","creation_date":"2012-12-19","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-06-23","contributory_code":"1","contributory_name":"GRANDES CONTRIBUYENTES","assigned_quota":"80000000.00","actualization_date":null,"average_sales":"9840057.5","mark":"S","branch":"S","branch_code":"","customer_group":"FLO","contract_pcpk":"N","contact":null,"email_contact":null,"discount":"23.00","contado":"52167420.0","por_vencer":"0.0","vencido":"41777786.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"5601218.0","de_31_a_45_dias":"9867694.0","de_46_a_60_dias":"15596026.0","de_61_a_75_dias":"12232898.0","de_76_a_90_dias":"-652441.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"-867609.0","mas_de_120_dias":"0.0","remisiones":"10389634.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"7","days_before_last_invoice":"17","last_update_quota":"2026-06-25","date_first_sale":"2013-01-29","payment_method_rf":"N","customer_category":"AA","type_record":"UPDATE","idmovimiento":"88280579"},{"country_code":"CO","customer_code":"7219693","email":"LUINANO63@HOTMAIL.COM","email_fe":"luinano63@hotmail.com","first_surname":"SUAREZ","second_surname":"","first_name":"LUIS","second_name":"HERNANDO","complete_name":"SUAREZ  LUIS HERNANDO","phone":"","phone2":"","fax_number":"","mobile_number":"3113968080","address":"CALLE 20A 20-33","city_code":"15238","city_name":"DUITAMA","department_code":"15","department_name":"BOYACA","country":"169","name_country":"COLOMBIA","region_code":"007","region_name":"BOYACA","customer_type":"PAR","seller_code":"BYU","seller_name":"CHINOME ZANDRA","seller_email":"zchinome@automundial.com.co","invoice_period":"07","bill_rejects":"N","bill_secure":"N","creation_date":"2012-11-26","status":"B","status_name":"CLIENTE ACTIVO","observation":"","last_invoice_date":"2026-03-16","contributory_code":"4","contributory_name":"PERSONAS NATURALES","assigned_quota":"20000000.00","actualization_date":null,"average_sales":"309299.08333333333333333333333333","mark":"S","branch":"N","branch_code":"","customer_group":"PAR","contract_pcpk":"N","contact":null,"email_contact":"LUINANO63@HOTMAIL.COM","discount":"30.00","contado":"0.0","por_vencer":"0.0","vencido":"0.0","de_0_a_15_dias":"0.0","de_16_a_30_dias":"0.0","de_31_a_45_dias":"0.0","de_46_a_60_dias":"0.0","de_61_a_75_dias":"0.0","de_76_a_90_dias":"0.0","de_91_a_105_dias":"0.0","de_106_a_120_dias":"0.0","mas_de_120_dias":"0.0","remisiones":"0.00","comportamiento_vtas":"No aplica","gestion_comercial":"S","cantidad_facturas_vencidas":"0","days_before_last_invoice":"47","last_update_quota":"2026-06-25","date_first_sale":"2012-11-29","payment_method_rf":"N","customer_category":"A","type_record":"UPDATE","idmovimiento":"88280578"}]}- Respuesta=>{"status":"success","message":"Cuentas procesadas correctamente","accounts_errors":[]}
2026 09 15 09:37:10 dbecuador
2026 09 15 09:37:12 No hay clientes para enviar.
2026 09 15 09:37:12 {"status":"error","message":"No se han recibido clientes para crear o actualizar."}
2026 09 15 09:37:12 400 BadRequest Cron -> BD ->dbecuador -> datos_enviados => {"Clientes":[]}- Respuesta=>{"status":"error","message":"No se han recibido clientes para crear o actualizar."}
2026 09 17 01:44:49 basdat