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
3590.0	ADMIN	BRANCH	April	1681783331755	WOSD177493	PRIMA MULIA, CV	-	-	SDLG	L956F	624699	654	WARRANTY	RUNNING	-	TANJABBAR	JAMBI	REPLACE BUZZER ALARM	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	nyampai office jam 20.00 tanggal 9 mei 2023	Hafiz Rusydi	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-04-18 09:02	2023-04-18 09:02	2023-05-09 14:03	2023-05-09 19:42	2023-05-09 14:03	2023-05-09 19:42	2023-05-09 19:43	-	2023-05-10 04:26	1167.0	30880.0	514.0	YES	0.0
3591.0	ADMIN	BRANCH	April	1681786966277	WO23176590	WAYAN SUKARJA, IR	-	-	SDLG	E660FL	625838	140	WARRANTY	RUNNING	-	TARIPA -POSO	PALU	FREE SERVICE 100HM E660FL	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	mekanik tiba	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-04-18 10:02	2023-04-18 10:03	2023-04-18 10:03	2023-04-19 13:02	2023-04-18 10:03	2023-04-19 14:25	2023-04-19 14:37	2023-04-19 14:38	2023-04-19 14:40	1167.0	1620.0	28.0	YES	0.0
3592.0	ADMIN	BRANCH	April	1681787328746	WO23177553	LOURY NAJOAN	-	-	SDLG	E660FL	625754	-	WARRANTY	RUNNING	2023-04-18 00:00:00.0000000	Maumbi	MANADO	Service periodic 250 hrs	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job service 250 done	Riandy Hamzah	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2023-04-18 10:08	2023-04-18 10:08	2023-04-18 10:52	2023-04-18 12:57	2023-04-18 10:52	2023-04-18 12:57	2023-04-18 13:28	2023-04-18 14:22	2023-04-18 15:16	1167.0	169.0	3.0	YES	0.0
3593.0	ADMIN	BRANCH	April	1681788732663	WO23177507	DERMAGA SUKSES MANDIRI, PT.	-	-	VCE	EC200D	250304	1500	NON WARRANTY	RUNNING	-	BELAWAN	MEDAN	Maintenance service	ECT	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	bto	Andrianto	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-04-18 10:32	2023-04-18 10:40	2023-04-18 10:40	2023-04-18 13:14	2023-04-18 10:40	2023-04-18 13:14	2023-04-18 15:32	-	2023-04-19 16:13	1167.0	162.0	5.0	YES	8.0
3594.0	ADMIN	BRANCH	April	1681806611840	WO23177526	INDOTRUCK UTAMA, PT.	-	-	SDLG	E6210F	609327	1	STOCK	STANDBY	-	W/S PEKANBARU	PEKANBARU	Storage Maintenance	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	kembali	INDRA MAHDI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-04-18 15:30	2023-04-18 15:30	2023-04-18 15:42	2023-04-18 15:42	2023-04-18 15:42	2023-04-18 15:42	2023-04-18 16:03	2023-04-18 16:03	2023-05-02 09:14	1167.0	13.0	0.0	YES	0.0
3595.0	ADMIN	BRANCH	April	1681827961040	WO23177566	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324524	3200	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 3200 jam AD69 SN 324524 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	14:30 completed doc	Agus Hadi Hariyono	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-18 21:26	2023-04-18 21:26	2023-04-19 12:52	2023-04-19 12:53	2023-04-19 12:52	2023-04-19 12:53	2023-04-19 21:59	-	2023-04-19 22:00	1167.0	257.0	13.0	YES	0.0
3596.0	ADMIN	BRANCH	April	1681864055162	WO23177590	INDONESIA PRATAMA, PT	-	-	VCE	A40G	322859	7839	NON WARRANTY	RUNNING	2023-04-19 00:00:00.0000000	Muara Pahu	BALIKPAPAN	install racore A40G sn322859 PT IP	ENGINE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	RFU	Fiqri Hamdani	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-04-19 07:27	2023-04-19 07:27	2023-04-19 07:30	2023-04-19 11:17	2023-04-19 07:30	2023-04-19 11:17	2023-04-19 14:28	2023-04-19 17:11	2023-04-19 17:11	1167.0	230.0	7.0	YES	0.0
3597.0	ADMIN	BRANCH	April	1681866547736	23177577	BARA PRIMA PRATAMA, PT	-	-	VT	FMX44084R-I SHIFT	A319125	4636	WARRANTY	RUNNING	-	BATU AMPAR	JAMBI	MANDATORY SERVICE 500 H	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	done tanggal 19	Noval Qomaruzzaman Rasyid	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-04-19 08:09	2023-04-19 08:09	2023-04-19 14:07	2023-04-19 14:07	2023-04-19 14:07	2023-04-19 14:07	-	-	2023-04-28 11:13	1167.0	359.0	-	YES	0.0
3598.0	ADMIN	BRANCH	April	1681535844097	WOCE177233	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	323788	9631	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	Warranty injector 1 EA AD56 SN 323788 LDA	ENGINE	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai jam 21.00	Ichsan Ali Rosidi	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-15 12:17	2023-04-15 12:17	2023-04-18 10:50	2023-04-18 13:08	2023-04-18 10:50	2023-04-18 13:08	2023-04-18 20:13	2023-04-18 21:22	2023-04-18 21:23	1170.0	142.0	9.0	YES	0.0
3599.0	ADMIN	BRANCH	April	1681700074320	WO23176903	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898731	4500	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 500 HRS VT062	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-04-17 09:54	2023-04-17 09:54	2023-04-17 09:55	2023-04-17 14:37	2023-04-17 09:55	2023-04-17 14:37	2023-04-17 19:32	2023-04-17 20:45	2023-04-17 20:45	1168.0	283.0	9.0	YES	0.0