{"success":true,"count":10,"debug_invoice_amount_column":"grand_total","data":[{"sn":1,"invoice_id":"18","delivery_order_id":"18","do_id":"18","product_sales_id":"","company_name":"Samsung C&T Corporation","company_address":"N106  Thomson slip road Gate 15","project_name":"N106","contact_person":"Mahendiran","contact_number":"82068600","email_id":"mahendiran.g@samsung.com","system_name":"Subscription 4G internet service with Mobile app Monitoring $ 55 / month","estimate_number":"EST2026013","do_number":"DO2026013","invoice_number":"INV2026013","invoice_amount":"275.00","system_sn_number":"ENV2026018","calibration_cert_number":"ENV2026018","date_of_calibration":"2024-11-11","next_calibration":"2025-11-11","sensor_type":"TSS Sensor","sensor_number":"24260570005S","sim_card_no":"87804651","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","product_delivery_date":"2026-03-24","installation_date":"","warranty_period":""},{"sn":2,"invoice_id":"14","delivery_order_id":"14","do_id":"14","product_sales_id":"","company_name":"Samsung C&T Corporation","company_address":"N106  Thomson slip road Gate 15","project_name":"N106","contact_person":"Mahendiran","contact_number":"82068600","email_id":"mahendiran.g@samsung.com","system_name":"PUB SIDS-CCTV Monitoring System (Complete Set)","estimate_number":"EST2026009","do_number":"DO2026009","invoice_number":"INV2026009","invoice_amount":"1450.00","system_sn_number":"ENV2026018","calibration_cert_number":"ENV2026018","date_of_calibration":"2024-11-11","next_calibration":"2025-11-11","sensor_type":"TSS Sensor","sensor_number":"24260570005S","sim_card_no":"87804651","date_of_activation":"2024-10-26","next_renewal":"2025-10-26","product_delivery_date":"2026-03-24","installation_date":"","warranty_period":""},{"sn":3,"invoice_id":"13","delivery_order_id":"13","do_id":"13","product_sales_id":"2","company_name":"KTC Civil Engineering & Construction Pte Ltd","company_address":"27 Pandan Crescent, Singapore-128476Project: KTC-HSB JV # INFRA WORKS AT BULIM PHASE2","project_name":"BULIM PHASE2","contact_person":"Reeza","contact_number":"89770889","email_id":"md.shahreeza@ktcgroup.com.sg","system_name":"Auto Silt Stopper -ECM Monitoring System with (PUB SIDS CCTV )","estimate_number":"EST2026008","do_number":"DO2026008","invoice_number":"INV2026008","invoice_amount":"5950.00","system_sn_number":"","calibration_cert_number":"","date_of_calibration":"0000-00-00","next_calibration":"0000-00-00","sensor_type":"","sensor_number":"","sim_card_no":"","date_of_activation":"0000-00-00","next_renewal":"0000-00-00","product_delivery_date":"2026-03-24","installation_date":"2026-03-24","warranty_period":"2026-03-24 to 2027-03-23"},{"sn":4,"invoice_id":"12","delivery_order_id":"12","do_id":"12","product_sales_id":"3","company_name":"KTC Civil Engineering & Construction Pte Ltd","company_address":"27 Pandan Crescent, Singapore-128476 Project Name : CR206 Design and Construction of Maju Station and Tunnels for Cross Island Line","project_name":"CR206","contact_person":"Raja","contact_number":"96574260","email_id":"ramasamy.raja@ktcgroup.com.sg","system_name":"Auto Silt Stopper -ECM Monitoring System with (PUB SIDS CCTV )","estimate_number":"EST2026007","do_number":"DO2026007","invoice_number":"INV2026007","invoice_amount":"11900.00","system_sn_number":"ENV2026030","calibration_cert_number":"","date_of_calibration":"","next_calibration":"","sensor_type":"","sensor_number":"","sim_card_no":"88671492","date_of_activation":"2026-03-13","next_renewal":"2027-03-13","product_delivery_date":"2026-03-24","installation_date":"2026-03-24","warranty_period":"2026-03-24 to 2027-03-23"},{"sn":5,"invoice_id":"11","delivery_order_id":"11","do_id":"11","product_sales_id":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","company_address":"Project Name : Bus Depot at Simpang ,Project Code : LTA B202Site\r\nAddress: 2B Yishun Ave 7 ,Singapore 768929","project_name":"B202","contact_person":"Karthik","contact_number":"98981207","email_id":"ramasamy.karthi@ktcgroup.com.sg","system_name":"Auto Silt Stopper -ECM Monitoring System with (PUB SIDS CCTV )","estimate_number":"EST2026006","do_number":"DO2026006","invoice_number":"INV2026006","invoice_amount":"6200.00","system_sn_number":"ENV2026032","calibration_cert_number":"ENV2026032","date_of_calibration":"2026-03-01","next_calibration":"2027-03-01","sensor_type":"TSS Sensor","sensor_number":"25300570003S","sim_card_no":"88675483","date_of_activation":"2026-03-12","next_renewal":"2027-03-12","product_delivery_date":"2026-03-24","installation_date":"","warranty_period":""},{"sn":6,"invoice_id":"10","delivery_order_id":"10","do_id":"10","product_sales_id":"","company_name":"KTC Civil Engineering & Construction Pte Ltd","company_address":"27 Pandan Crescent, Singapore-128476","project_name":"CR211","contact_person":"Mr.Ilango","contact_number":"84378451","email_id":"ilango.malaiyandi@ktcgroup.com.sg","system_name":"Auto Silt Stopper -ECM Monitoring System with (PUB SIDS CCTV )","estimate_number":"EST2025005","do_number":"DO2026005","invoice_number":"INV2026005","invoice_amount":"5950.00","system_sn_number":"ENV2026034","calibration_cert_number":"","date_of_calibration":"","next_calibration":"","sensor_type":"","sensor_number":"","sim_card_no":"88670611","date_of_activation":"2026-03-22","next_renewal":"2027-03-22","product_delivery_date":"2026-03-24","installation_date":"","warranty_period":""},{"sn":7,"invoice_id":"9","delivery_order_id":"9","do_id":"9","product_sales_id":"","company_name":"Samsung C&T Corporation","company_address":"CR112 Project\r\n2A Hougang central #01-03\r\nSingapore 538729","project_name":"CR112","contact_person":"Ramesh","contact_number":"90892720","email_id":"v.ramesh@samsung.com","system_name":"Auto Silt Stopper -ECM Monitoring System with (PUB SIDS CCTV )","estimate_number":"EST2025004","do_number":"DO2026004","invoice_number":"INV2026004","invoice_amount":"4800.00","system_sn_number":"ENV2026026","calibration_cert_number":"ENV2026026","date_of_calibration":"2025-10-09","next_calibration":"2026-10-09","sensor_type":"TSS Sensor","sensor_number":"202501020000004","sim_card_no":"89237943","date_of_activation":"2025-10-10","next_renewal":"2026-10-10","product_delivery_date":"2026-03-24","installation_date":"","warranty_period":""},{"sn":8,"invoice_id":"8","delivery_order_id":"8","do_id":"8","product_sales_id":"","company_name":"Kimly Construction Pte Ltd","company_address":"3 New Industrial Rd, #05-01/02 Kimly Building, Singapore 536197","project_name":"KBGC3","contact_person":"Ms Yu Ying","contact_number":"9154 3923","email_id":"yuying@kimly.com.sg","system_name":"Auto Silt Stopper -ECM Monitoring System with (PUB SIDS CCTV )","estimate_number":"EST2025003","do_number":"DO2026003","invoice_number":"INV2026003","invoice_amount":"4990.00","system_sn_number":"ENV2026025","calibration_cert_number":"ENV2026025","date_of_calibration":"2025-10-06","next_calibration":"2026-10-06","sensor_type":"TSS Sensor","sensor_number":"25220570001S","sim_card_no":"87685203","date_of_activation":"2025-10-07","next_renewal":"2026-10-07","product_delivery_date":"2026-03-24","installation_date":"","warranty_period":""},{"sn":9,"invoice_id":"7","delivery_order_id":"7","do_id":"7","product_sales_id":"","company_name":"BHCC Construction Pte Ltd","company_address":"No 1 Tampines North Drive 3,#08-01 ,BHCC Space Singapore 528499","project_name":"Building Works at Project BG,","contact_person":"Mr.Muthumanikam","contact_number":"8523 0345","email_id":"muthumanickam@bhcc.com.sg","system_name":"WBGT-Auto Heat Stress Monitoring System","estimate_number":"EST2025002","do_number":"DO2026002","invoice_number":"INV2026002","invoice_amount":"2950.00","system_sn_number":"","calibration_cert_number":"","date_of_calibration":"","next_calibration":"","sensor_type":"","sensor_number":"","sim_card_no":"","date_of_activation":"","next_renewal":"","product_delivery_date":"2026-03-24","installation_date":"","warranty_period":""},{"sn":10,"invoice_id":"6","delivery_order_id":"6","do_id":"6","product_sales_id":"4","company_name":"Kimly Construction Pte Ltd","company_address":"3 New Industrial Rd, #05-01/02 Kimly Building, Singapore 536197","project_name":"NUS","contact_person":"Ms Chook Xin Yin (Jo)","contact_number":"8261 2664","email_id":"xinyinchook@kimly.com.sg","system_name":"Solar Power Backup (60W/30Ah)","estimate_number":"EST2025001","do_number":"DO2026001","invoice_number":"INV2026001","invoice_amount":"490.00","system_sn_number":"ENV2026024","calibration_cert_number":"ENV2026024","date_of_calibration":"2025-09-01","next_calibration":"2026-09-01","sensor_type":"TSS Sensor","sensor_number":"24490570005S","sim_card_no":"87809361","date_of_activation":"2025-09-03","next_renewal":"2026-09-03","product_delivery_date":"2026-03-24","installation_date":"2026-03-26","warranty_period":"2026-03-26 to 2027-03-25"}]}