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
17365.0	MECHANIC	MECHANIC	May	1716881724393	-	BUPALA ALAM PERKASA, PT	-	-	VCE	SD110	59531	4	WARRANTY	RUNNING	2024-05-28 00:00:00.0000000	Falabisahaya	MANADO	Commisionning	ETC	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	-	-	Akbar Muharam	Akbar Muharam	085721041959	akbarmuharam587@gmail.com	2024-05-28 14:35	2024-05-28 14:36	2024-05-28 14:39	2024-05-28 14:40	2024-05-28 14:39	2024-05-28 14:40	2024-05-28 14:43	2024-05-30 15:38	2024-05-30 15:38	761.0	5.0	0.0	-
17366.0	ADMIN	BRANCH	May	1716882476174	WOCE211461	CAKRAWALA KENCANA INDONESIA, PT	-	-	VCE	A40G	324997	4497	WARRANTY	STANDBY	2024-05-28 00:00:00.0000000	JB SEBAMBAN	BANJARMASIN	SHOCK ABSORBER LEAK	ETC	OTHER	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	ARRIVE ON SITE	.	Ihza Assajadin. A	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2024-05-28 14:47	2024-05-28 14:48	2024-05-28 14:48	2024-05-28 14:48	2024-05-28 14:48	2024-05-28 14:48	2024-06-04 18:31	2024-06-04 18:32	2024-06-04 18:33	761.0	0.0	171.0	-
17367.0	ADMIN	BRANCH	May	1716884762494	WOCE211038	INDOTRUCK UTAMA, PT.	-	-	VCE	A40G	VCE0A40GL00325385	26	STOK	STANDBY	2024-05-28 00:00:00.0000000	balikpapan	BALIKPAPAN	Problem Transmissi slip A40G sn325385 hm26	ETC	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ramadhan Fatoni	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2024-05-28 15:26	2024-05-28 15:26	2024-05-28 15:27	2024-05-28 15:27	2024-05-28 15:27	2024-05-28 15:27	2024-05-29 07:23	2024-05-29 07:23	2024-05-29 07:23	761.0	1.0	15.0	YES
17368.0	ADMIN	BRANCH	May	1716884927449	WOCE210974	BERKAT JAYA KONSTRUKSI, PT	-	-	VCE	SD110	VCE0S110E00059513	12	WARRANTY	RUNNING	2024-05-28 00:00:00.0000000	Balikpapan	BALIKPAPAN	problem Hour Meter SD110D Sn59513 PT BJK	ETC	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Fiqri Hamdani	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2024-05-28 15:28	2024-05-28 15:28	2024-05-28 15:29	2024-05-28 15:29	2024-05-28 15:29	2024-05-28 15:29	2024-05-29 07:24	2024-05-29 07:24	2024-05-29 07:24	761.0	1.0	15.0	NO
17369.0	ADMIN	BRANCH	May	1716886039828	pending wo	HILLCONJAYA SAKTI, PT	-	-	VCE	EC210D	231879	785	WARRANTY	BREAKDOWN	-	WEDABAY	MANADO	Compressor broken	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	MUHAMAD RIZKY MISBAHUDIN	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2024-05-28 15:47	2024-05-28 15:47	2024-05-28 22:10	2024-05-28 22:15	2024-05-28 22:10	2024-05-28 22:15	2024-05-28 22:24	2024-05-28 22:27	2024-05-30 10:50	761.0	388.0	6.0	YES
17370.0	ADMIN	BRANCH	May	1716888331456	WO24211482	KARYA BANGSA INDONESIA, PT	-	-	SDLG	L956HE	620374	318	WARRANTY	RUNNING	-	HALABAN	PEKANBARU	Service 250 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	pekerjaan selesai. hm unit 318	Sapto Adi Putra	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2024-05-28 16:25	2024-05-28 16:26	2024-05-28 16:29	2024-05-29 10:29	2024-05-28 16:29	2024-05-29 10:29	2024-05-30 15:28	2024-05-31 08:23	2024-06-03 15:37	761.0	1084.0	47.0	YES
17371.0	ADMIN	BRANCH	May	1716948574740	QO-240019215	WAHANA INDO TRADA MOBILINDO,PT.	-	-	VB	B11R	200529	480000	NON WARRANTY	RUNNING	-	CIBINONG	JAKARTA	Annual service - B11R - 200529	ENGINE	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	-	EFRANS GADING SYLVANUS	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2024-05-29 09:09	2024-05-29 09:09	2024-05-29 09:10	2024-05-29 13:11	2024-05-29 09:10	2024-05-29 13:11	2024-05-30 08:36	2024-05-30 08:36	2024-05-30 13:08	760.0	242.0	23.0	YES