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
4970.0	MECHANIC	MECHANIC	June	1685859478621	0	HILLCON JAYASAKTI, PT	-	-	VCE	EC210D	231901	222	WARRANTY	RUNNING	2023-06-04 00:00:00.0000000	muara laung	BANJARMASIN	pm service 250 hours	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	unit RFU	Risky Prabowo	Risky Prabowo	085820339919	riskybowo674@gmail.com	2023-06-04 13:17	2023-06-04 13:18	2023-06-04 13:19	2023-06-04 13:22	2023-06-04 13:19	2023-06-04 13:22	2023-06-04 19:41	2023-06-04 20:05	2023-06-04 20:07	1120.0	5.0	6.0	YES	0.0
4971.0	ADMIN	BRANCH	June	1685926386172	WO23180578	RAKA NAVARA, PT	-	-	VCE	EC210D	252806	1675	WARRANTY	RUNNING	-	KOLAKA UTARA	KENDARI	Repair oil lube pipe turbocharger EC210D SN252806	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	complated	Debysantoso	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-06-05 07:53	2023-06-05 07:53	2023-06-05 07:55	2023-06-05 09:36	2023-06-05 07:55	2023-06-05 09:36	2023-06-05 21:02	2023-06-06 06:50	2023-06-06 06:51	1120.0	104.0	13.0	YES	0.0
4972.0	ADMIN	BRANCH	June	1685935335565	WO23180577	BUMEN JAYA MANDIRI, CV	-	-	VCE	EC210D	231931	2	WARRANTY	RUNNING	2023-06-05 00:00:00.0000000	Bengkulu utara	BENGKULU	commisioning unit	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Agus Nugroho	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-06-05 10:22	2023-06-05 10:22	2023-06-05 10:41	2023-06-05 12:25	2023-06-05 10:41	2023-06-05 12:25	2023-06-05 16:22	2023-06-05 21:42	2023-06-05 21:43	1119.0	123.0	6.0	YES	0.0
4973.0	ADMIN	BRANCH	June	1685936081261	WO23181616	INTERNATIONAL GREEN ENERGY PT	-	-	SDLG	L956F	624029	1951	NON WARRANTY	RUNNING	-	TANJUNG BUTON	PEKANBARU	Brake system problem	BRAKE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	BELLIARD SUSANTO	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-06-05 10:34	2023-06-05 10:34	2023-06-17 08:43	2023-06-17 13:33	2023-06-17 08:43	2023-06-17 13:33	2023-06-17 15:31	2023-06-17 18:23	2023-06-19 10:49	1119.0	294.0	6.0	YES	0.0
4974.0	ADMIN	BRANCH	June	1685938836795	WO23180626	MENGGALA VICTORY JAYA, PT.	-	-	SDLG	E6210F	609295	1000	WARRANTY	RUNNING	-	SORONG	SORONG	SERVICE 1000 HOURS	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch office	Service koordinator (Sorong - Nusa tenggara)	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-06-05 11:20	2023-06-05 11:20	2023-06-05 11:46	2023-06-05 11:52	2023-06-05 11:46	2023-06-05 11:52	2023-06-05 15:15	2023-06-05 15:48	2023-06-09 08:53	1119.0	32.0	3.0	YES	0.0
4975.0	ADMIN	BRANCH	June	1685948093660	WO23180060	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	309021	2750	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 250 HRS VT089 HM2750	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-06-05 13:54	2023-06-05 13:55	2023-06-05 13:55	2023-06-05 17:19	2023-06-05 13:55	2023-06-05 17:19	2023-06-06 05:14	2023-06-06 06:20	2023-06-06 08:15	1119.0	205.0	15.0	YES	0.0
4976.0	ADMIN	BRANCH	June	1685973069996	WO23180661	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324509	3600	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 3600 jam AD70 SN 324509 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch office	Dedi Ermanto Pribowo	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-06-05 20:51	2023-06-05 20:56	2023-06-06 08:29	2023-06-06 15:11	2023-06-06 08:29	2023-06-06 15:11	-	2023-06-06 18:50	2023-06-07 10:37	1119.0	409.0	-	YES	5.0
4977.0	ADMIN	BRANCH	June	1686016785051	WO23180381	PUTRA ARYA SATYA, PT	-	-	SDLG	LG953	622059	750	WARRANTY	STANDBY	2023-06-06 00:00:00.0000000	Bali	SURABAYA	Service 750 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Andi Sunaryo	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-06-06 08:59	2023-06-06 08:59	2023-06-06 09:10	2023-06-06 12:50	2023-06-06 09:10	2023-06-06 12:50	2023-06-06 18:33	2023-06-06 18:34	2023-06-07 08:25	1119.0	231.0	9.0	YES	0.0
4978.0	MECHANIC	MECHANIC	June	1686019347498	23180597	RAKINDO UNITRUST MANDIRI, PT	-	-	SDLG	G9138	600578	1000	WARRANTY	RUNNING	2023-06-06 00:00:00.0000000	Sei Gelam Jambi	JAMBI	Maintenance Service 1000 Hours	ETC	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	sampai dengan selamat 😂	Ardiansyahnur	Ardiansyahnur	082353107865	ardiansyahnur2002@gmail.com	2023-06-06 09:42	2023-06-06 09:42	2023-06-06 10:08	2023-06-06 11:28	2023-06-06 10:08	2023-06-06 11:28	2023-06-06 17:03	2023-06-06 17:03	2023-06-06 17:04	1118.0	106.0	7.0	YES	0.0
4979.0	ADMIN	BRANCH	June	1686020059805	-	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	-	5000	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 1000 HRS VT073	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-06-06 09:54	2023-06-06 09:55	2023-06-06 09:55	2023-06-06 13:30	2023-06-06 09:55	2023-06-06 13:30	2023-06-06 18:11	2023-06-07 06:12	2023-06-07 06:13	1118.0	216.0	8.0	YES	0.0