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
6640.0	ADMIN	BRANCH	July	1690417575412	WO23184152	INDOTRUCK UTAMA, PT.	-	-	SDLG	E680F	607346	-	WARRANTY	RUNNING	2023-07-27 00:00:00.0000000	Makassar	MAKASSAR	Arrival Inspection Program	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Andi Musfidal Hidayat	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-07-27 07:26	2023-07-27 07:26	2023-07-27 07:32	2023-07-27 08:41	2023-07-27 07:32	2023-07-27 08:41	2023-07-27 17:58	2023-07-28 07:09	2023-07-28 07:16	1068.0	75.0	10.0	YES	0.0
6641.0	MECHANIC	MECHANIC	July	1690417867149	WO23187164	ANEKA TAMBANG, PT	-	-	VCE	EC330BLC	15194	0	NON WARRANTY	BREAKDOWN	2023-07-27 00:00:00.0000000	tayan	PONTIANAK	general overhoul	-	OVERHAUL	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	instal sparepart general overhoul ec330blc	Doni Ardiansyah	Doni Ardiansyah	081285851832	ardiansyahdoni69@gmail.com	2023-07-27 07:31	2023-07-27 07:33	2023-07-27 07:33	2023-07-27 23:02	2023-07-27 07:33	2023-07-27 23:02	2023-08-21 08:47	2023-08-22 14:39	2023-08-22 14:39	1068.0	932.0	601.0	YES	2.0
6642.0	ADMIN	BRANCH	July	1690422096763	WO 23184153	I GEDE HERMAWAN	-	-	SDLG	E660FL	625951	6	WARRANTY	RUNNING	-	POSO PESISIR UTARA	PALU	COMMISIONING E660FL SN 625951	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-07-27 08:41	2023-07-27 08:42	2023-07-27 08:43	2023-07-27 13:01	2023-07-27 08:43	2023-07-27 13:01	2023-07-27 14:21	2023-07-28 07:27	2023-07-28 09:41	1068.0	260.0	5.0	YES	0.0
6643.0	ADMIN	BRANCH	July	1690422550382	WO23184025	INDOTRUCK UTAMA, PT.	-	-	VT	FM37064T	YV2XSG0D8PA317653	20	WARRANTY	RUNNING	-	YARD PURWAKARTA	JAKARTA	Campaign S2753 Air horn, install YV2XSG0D8PA317653	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Mochamad Aniqun Umar Farauq	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-07-27 08:49	2023-07-27 08:49	2023-07-28 08:41	2023-07-28 08:41	2023-07-28 08:41	2023-07-28 08:41	2023-07-28 08:41	2023-07-28 08:42	2023-07-28 08:43	1068.0	1432.0	23.0	YES	0.0
6644.0	ADMIN	BRANCH	July	1690424339971	WO23184161	STATIKA MITRASARANA, PT	-	-	SDLG	L956F	625348	95	WARRANTY	RUNNING	-	PADANG	PEKANBARU	Service 100 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	Ilham rahmat illahi	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-07-27 09:18	2023-07-27 09:19	2023-07-27 13:48	2023-07-28 08:35	2023-07-27 13:48	2023-07-28 08:35	2023-07-28 17:47	2023-07-29 06:14	2023-08-02 10:40	1067.0	1396.0	32.0	YES	0.0
6645.0	ADMIN	BRANCH	July	1690425772017	WO23184077	PP. LONDON SUMATRA INDONESIA TBK, PT	-	-	VCE	EC210B	81253	2000	NON WARRANTY	RUNNING	-	KUBAR	SAMARINDA	SERVICE 2000HRS	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Machine RFU	Bukhori	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-07-27 09:42	2023-07-27 09:44	2023-07-27 09:46	2023-07-28 11:46	2023-07-27 09:46	2023-07-28 11:46	2023-07-30 21:59	2023-08-01 05:44	2023-08-01 05:44	1067.0	1563.0	84.0	YES	1.0
6646.0	ADMIN	BRANCH	July	1690429970527	WOCE184176	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324766	2000	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	Warranty sensor temp cabin SE8706 AD71 SN 324766 LDA	ELECTRICAL	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive on pt itu enim	Aditya Ryan Saputra	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-07-27 10:52	2023-07-27 10:53	2023-07-28 09:50	2023-07-28 11:19	2023-07-28 09:50	2023-07-28 11:19	2023-07-29 08:32	2023-07-29 08:32	2023-07-29 08:33	1067.0	132.0	23.0	YES	0.0
6647.0	ADMIN	BRANCH	July	1690430968418	WO23184175	MNC GUNA USAHA INDONESIA, PT	-	-	VCE	EC210D	280099	2500	NON WARRANTY	RUNNING	-	SEMARANG	SEMARANG	280099 WO23184175 GENERAL INSPECTION UNIT EC210D MA 4862 ITU-000016352 SRWE Created Triyono Smg 7/27/2023 2.00	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-07-27 11:09	2023-07-27 11:09	2023-07-27 11:09	2023-07-27 11:09	2023-07-27 11:09	2023-07-27 11:09	2023-07-28 08:29	2023-07-28 08:29	2023-07-28 08:30	1067.0	0.0	21.0	YES	0.0
6648.0	ADMIN	BRANCH	July	1690502779649	WO23184150	AGEN PERKAPALAN PERUSAHAAN PELAYARAN MULTI LINES, PT	-	-	SDLG	E660FL	622791	1000	Warranty	STANDBY	2023-07-28 00:00:00.0000000	Sorong	SORONG	Mandatory Service 1000 Hours	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Done	Service koordinator (Sorong - Nusa tenggara)	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-07-28 07:06	2023-07-28 07:07	2023-07-29 07:08	2023-07-29 07:48	2023-07-29 07:08	2023-07-29 07:48	2023-07-29 12:33	2023-07-31 06:39	2023-07-31 06:43	1067.0	1482.0	26.0	YES	1.0
6649.0	ADMIN	BRANCH	July	1690505489502	WO23184213	SUMBER ALAM MATA WAWATU, PT	-	-	VCE	EC210D	280079	80001	NON WARRANTY	RUNNING	-	MORAMO	KENDARI	Re-seal silinder bucker EC210D SN280079	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done and unit ready for use	Arfandi yahya	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-07-28 07:51	2023-07-28 07:51	2023-07-28 08:08	2023-07-28 09:38	2023-07-28 08:08	2023-07-28 17:44	2023-07-28 17:45	2023-07-28 19:11	2023-07-28 21:11	1067.0	107.0	9.0	YES	0.0