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
5700.0	ADMIN	BRANCH	June	1687837878560	WOSD181702	BARA REZEKI HAMIZAN, PT	-	-	SDLG	G9220	600594	257	WARRANTY	STANDBY	2023-06-27 00:00:00.0000000	BINUANG	BANJARMASIN	ENGINE OVERHEAT	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	after install new water pump unit rfu	Junaidi Arsyandi	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-06-27 10:51	2023-06-27 10:51	2023-06-27 11:26	2023-06-27 11:27	2023-06-27 11:26	2023-06-27 11:27	2023-07-06 13:19	2023-07-06 13:19	2023-07-06 13:20	1097.0	36.0	218.0	YES	0.0
5701.0	ADMIN	BRANCH	June	1687838282214	WOCE181817	HILLCON JAYASAKTI, PT	-	-	VCE	A60H	320455	5572	WARRANTY	STANDBY	2023-06-27 00:00:00.0000000	KOTABARU	BANJARMASIN	ENGINE LOW POWER	ENGINE	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	install injektor and competed calibrate injektor by VTT	Wardani	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-06-27 10:58	2023-06-27 10:58	-	-	-	-	-	-	2023-06-30 05:54	1097.0	-	-	YES	0.0
5702.0	ADMIN	BRANCH	June	1687838534872	WO23181778	CAKRAWALA KENCANA INDONESIA, PT	-	-	VCE	R100E	111078 VI	44	WARRANTY	RUNNING	2023-06-27 00:00:00.0000000	PROJECT CK	BANJARMASIN	SERVICE 50	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	complited job	Gondo	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-06-27 11:02	2023-06-27 11:02	2023-06-27 11:13	2023-06-27 11:38	2023-06-27 11:13	2023-06-27 11:38	2023-06-27 12:23	2023-06-27 12:25	2023-06-27 12:26	1097.0	36.0	1.0	YES	0.0
5703.0	ADMIN	BRANCH	June	1687839507277	WOCE181993	HASNUR RIUNG SINERGI, PT.	-	-	VCE	R100E	111054	7033	NON WARRANTY	RUNNING	2023-06-27 00:00:00.0000000	BINUANG	BANJARMASIN	INJECTOR FUEL PIPE NO.4 BROKEN /HDT733 R100E	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	waiting part	Junaidi Arsyandi	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-06-27 11:18	2023-06-27 11:18	2023-06-27 11:26	2023-06-27 11:27	2023-06-27 11:26	2023-06-27 11:27	2023-07-06 13:21	2023-07-06 13:21	2023-07-06 13:21	1097.0	9.0	218.0	YES	0.0
5704.0	ADMIN	BRANCH	June	1687571186827	WOCE182058	ANDALAN ARTHA PRIMANUSA, PT.	-	-	VCE	A40G	324737	2800	WARRANTY	BREAKDOWN	-	MUARA LAWAI	MUARA ENIM	Warranty pump unit ADT933 SN 324737 AAP	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di kantor	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-06-24 08:46	2023-06-24 08:48	2023-06-26 10:32	2023-06-26 19:45	2023-06-26 10:32	2023-06-26 19:45	2023-06-27 07:35	2023-06-27 07:56	2023-06-27 08:39	1101.0	619.0	22.0	YES	2.0
5705.0	ADMIN	BRANCH	June	1687571287620	WO23182069	ULIMA NITRA, PT	-	-	VCE	EC480DL	284419	2500	NON WARRANTY	RUNNING	-	CBR	MUARA ENIM	PM service 2500 jam AB278 SN 284419 UN CBR	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di office	Agus Hadi Hariyono	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-06-24 08:48	2023-06-24 08:48	2023-06-26 10:05	2023-06-26 13:38	2023-06-26 10:05	2023-06-26 13:38	2023-06-26 15:03	2023-06-26 16:52	2023-06-27 08:39	1101.0	252.0	5.0	YES	0.0
5706.0	ADMIN	BRANCH	June	1687597111478	WOSD182101	UTAMA TRAKTOR,CV.	-	-	SDLG	L968F	620575	2000	WARRANTY	RUNNING	-	BP	MUARA ENIM	Warranty hose fuel L968F L-06 SN 620575 UT BP	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	Janu Ramadhan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-06-24 15:58	2023-06-24 15:58	2023-07-07 15:00	2023-07-07 15:35	2023-07-07 15:00	2023-07-07 15:35	2023-07-07 16:14	2023-07-07 16:30	2023-07-07 16:30	1100.0	49.0	1.0	YES	0.0
5707.0	ADMIN	BRANCH	June	1687660347675	WO23182203	SURIANA, SP	-	-	SDLG	LG933L	606446	500	WARRANTY	RUNNING	2023-06-25 00:00:00.0000000	Bungku	MAKASSAR	Servis 500 Hour	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Ardona	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-06-25 09:32	2023-06-25 09:34	2023-06-25 09:38	2023-06-25 20:01	2023-06-25 09:38	2023-06-25 20:01	2023-06-27 14:01	2023-06-28 09:41	2023-06-28 10:14	1099.0	629.0	49.0	YES	1.0
5708.0	ADMIN	BRANCH	June	1687738358385	WOCE181926	BENNY ANGKASA INDONESIA, PT	-	-	VCE	EC200D	281153	1404	WARRANTY	BREAKDOWN	-	MOROWALI	KENDARI	Replace Injector 4 EC200D SN281153	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Debysantoso	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-06-26 07:12	2023-06-26 07:13	2023-06-26 07:17	2023-06-26 12:36	2023-06-26 07:17	2023-06-26 12:36	2023-06-26 22:03	2023-06-27 07:14	2023-06-27 07:14	1099.0	324.0	14.0	YES	0.0
5709.0	ADMIN	BRANCH	June	1687744541544	WO23182126	MANDIRI HERINDO ADIPERKASA, PT	-	-	VCE	EW205	281287	12	WARRANTY	STANDBY	-	BENGALON SITE KPC	SANGATTA	COMMISIONING UNIT VOLVO EW205D SN.281287	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Tri Hadi Sentosa	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-06-26 08:55	2023-06-26 08:55	2023-06-26 11:16	2023-06-26 13:02	2023-06-26 11:16	2023-06-26 13:02	2023-06-26 16:11	2023-06-27 07:05	2023-06-27 07:05	1099.0	247.0	7.0	YES	0.0