Monthly Report Dashboard

Sl No	Inquiry Source	Input Source	Job Created Month	Booking Id	WO Number	Customer Name	Customer Phone	Customer PIC	Product	Unit Model	Serial Number	Hour Meter	Unit Status	Unit Condition	Failure Date	Location	Branch Support	Issue	Function Group	Service Code	Service Type	Job Code	Job Group	Job Description	Creator Group	Status	Status Note	Note	Mechanic Name	Creator Name	Creator Phone	Creator Email	Job Created	First Responce Time	OTW to Site	Arrive On Site	OTW to Site Final	Arrive On Site Final	Back To Office	Arrive in Branch Office	Completed Date	Aging	ART	MTTR	FTF	FRT
3750.0	ADMIN	BRANCH	April	1682770583754	WO23177882	ULIMA NITRA, PT	-	-	VCE	EC480DL	274717	500	WARRANTY	STANDBY	-	BANKO	MUARA ENIM	S 500 HM AB 185	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	Gabby Hade Octafiando	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-29 19:16	2023-04-29 19:16	2023-05-02 11:50	2023-05-02 13:23	2023-05-02 11:50	2023-05-02 13:23	2023-05-02 13:49	2023-05-02 16:07	2023-05-02 16:09	1156.0	113.0	2.0	YES	0.0
3751.0	ADMIN	BRANCH	April	1682771059566	WO23177890	ULIMA NITRA, PT	-	-	VCE	EC480DL	284404	3000	WARRANTY	STANDBY	-	MUARA LAWAI	MUARA ENIM	S 3000 HM AB 274	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	Gabby Hade Octafiando	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-29 19:24	2023-04-29 19:24	2023-05-02 11:51	2023-05-02 13:25	2023-05-02 11:51	2023-05-02 13:25	2023-05-02 16:24	2023-05-02 16:26	2023-05-02 16:28	1156.0	99.0	4.0	YES	0.0
3752.0	ADMIN	BRANCH	April	1682771387374	WO23177935	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324481	4000	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	S 4000 HM AD 65	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor tgl 10/5/23 jam 19.00	Agus Prabowo	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-29 19:29	2023-04-29 19:30	2023-05-10 15:02	2023-05-13 09:46	2023-05-10 15:02	2023-05-13 09:46	2023-05-13 09:47	2023-05-13 09:48	2023-05-13 09:53	1156.0	5768.0	96.0	YES	0.0
3753.0	ADMIN	BRANCH	April	1682771706737	WO23177955	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324474	4000	WARRANTY	STANDBY	-	MUARA LAWAI	MUARA ENIM	S 4000 HM AD 66	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	Agung Dwi Bimatara	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-29 19:35	2023-04-29 19:35	2023-05-13 10:31	2023-05-13 11:53	2023-05-13 10:31	2023-05-13 11:53	2023-05-13 15:39	2023-05-13 16:04	2023-05-13 16:06	1156.0	84.0	5.0	YES	0.0
3754.0	ADMIN	BRANCH	April	1682476306175	WOCE177795	HILLCONJAYA SAKTI, PT	-	-	VCE	EC300DL	272520	792	WARRANTY	RUNNING	2023-04-26 00:00:00.0000000	KOTABARU	BANJARMASIN	AC HOT EC300D SN272520	ELECTRICAL	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	install expansion valve new,install filter,receive dryer new,install compressor AC new,adjustment v belt compressor AC charger refrigerant AC, tes(ok)	Wardani	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-04-26 09:31	2023-04-26 09:31	-	-	-	-	-	-	2023-04-28 16:00	1159.0	-	-	YES	0.0
3755.0	MECHANIC	MECHANIC	April	1682477541252	0	BERKAH ANUGERAH RIZQI ABADI COAL PT	-	-	VCE	A40G	324431	4351	WARRANTY	RUNNING	2023-04-26 00:00:00.0000000	Sungai Danau	BANJARMASIN	AC Hot replace sensor temperatur	ELECTRICAL	REPAIR	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	rfu	Ahmad Riduansyah	Ahmad Ridwansyah	081278001393	ahmadridwansyah96@gmail.com	2023-04-26 09:52	2023-04-26 09:52	2023-04-26 09:52	2023-04-26 09:52	2023-04-26 09:52	2023-04-26 09:52	2023-04-26 09:53	2023-04-26 09:53	2023-04-26 09:54	1159.0	1.0	0.0	YES	0.0
3756.0	MECHANIC	MECHANIC	April	1682504678498	-	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R-IShift	888954	-	STOK	RUNNING	2023-04-26 00:00:00.0000000	Bentuas	SAMARINDA	make sbs	ETC	OTHER	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	completed	Diky Maulana Tarmiji	Diky Maulana Tarmiji	081356619526	iamdiky15@gmail.com	2023-04-26 17:24	2023-04-26 17:26	2023-04-26 17:26	2023-04-26 19:07	2023-04-26 17:26	2023-04-26 19:07	2023-04-26 20:32	2023-04-26 21:07	2023-04-26 21:07	1159.0	102.0	3.0	YES	1.0
3757.0	ADMIN	BRANCH	April	1682561628739	WO23177849	UMUM PEMERINTAH DKI JAKARTA	-	-	VCE	EC210B	77727	5236	NON WARRANTY	RUNNING	-	ANCOL - JAKARTA UTARA	JAKARTA	TROUBLESHOOTING ERROR APPEAR ON DISPLAY XS-24	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Septian Dwi Handarian	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-04-27 09:13	2023-04-27 09:14	2023-04-27 10:14	2023-04-27 13:10	2023-04-27 10:14	2023-04-27 13:10	2023-04-27 15:38	2023-04-27 16:45	2023-04-27 16:45	1158.0	236.0	6.0	YES	0.0
3758.0	ADMIN	BRANCH	April	1682567669025	WO23177615	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	888967	7500	NON WARRANTY	RUNNING	-	SANGA-SANGA	SAMARINDA	SERVICE 500HRS VT052	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Complete ps500	Tulus Setrio	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-04-27 10:54	2023-04-27 10:54	2023-04-27 10:55	2023-04-27 12:02	2023-04-28 10:31	2023-04-28 10:31	2023-04-28 16:55	2023-04-29 09:32	2023-04-29 09:55	1158.0	68.0	2.0	YES	0.0
3759.0	ADMIN	MECHANIC	April	1682579453215	WO23178446	SAMUDERA MULIA ABADI, PT	-	-	VCE	A60H	320512	2454	WARRANTY	BREAKDOWN	-	BAKAN	MANADO	Inspeksi Engine Oil Mixed Fuel	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive	Herdiyansyah	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2023-04-27 14:10	2023-04-27 14:11	2023-04-27 14:11	2023-04-27 14:12	2023-04-27 14:11	2023-04-27 14:12	2023-04-28 12:47	2023-04-28 12:47	2023-05-05 14:01	1158.0	1.0	22.0	YES	0.0