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
6080.0	ADMIN	BRANCH	July	1689062958409	WO23183793	BUKIT SAWIT SEMESTA, PT.	-	-	SDLG	LG936L	603551	15423	NON WARRANTY	RUNNING	-	MANGGOPO	PEKANBARU	Repair unit	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	BELLIARD SUSANTO	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-07-11 15:09	2023-07-11 15:09	2023-07-22 08:00	2023-07-22 09:21	2023-07-22 08:00	2023-07-22 09:21	2023-07-23 16:42	2023-07-24 21:43	2023-07-25 10:13	1083.0	1166.0	50.0	YES	0.0
6081.0	ADMIN	BRANCH	July	1689069194636	WO23182807	MACMAHON MINING SERVICES, PT	-	-	VCE	A60H	320537	1178	NON WARRANTY	RUNNING	-	MARTABE	JAKARTA	Upgrade head lamp Helogen to LED	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Tomi Jullio	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-07-11 16:53	2023-07-11 16:53	2023-07-11 16:54	2023-07-11 16:54	2023-07-11 16:54	2023-07-11 16:54	2023-07-11 16:54	2023-07-11 16:55	2023-07-11 16:55	1083.0	1.0	0.0	YES	0.0
6082.0	BRANCH	BRANCH	July	1688693115770	WO23183698	SAMBAS KARYA PERKASA, PT.	-	-	SDLG	E6138F	606463	62.5	WARRANTY	RUNNING	-	BADAU	PONTIANAK	COMMISIONING UNIT	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back to office	Doni Ardiansyah	Ferlya Juliza Admin Pontianak	081545464290	ferlyajulizaa@gmail.com	2023-07-07 08:25	2023-07-07 08:26	2023-07-07 08:26	2023-07-07 22:54	2023-07-07 08:26	2023-07-07 22:54	2023-07-10 08:22	2023-07-11 13:50	2023-07-11 13:50	1088.0	869.0	71.0	YES	1.0
6083.0	ADMIN	BRANCH	July	1688694965676	WO23182907	PUTRA MAGA NANDIRAMA, PT	-	-	VCE	A40G	325002	4	WARRANTY	RUNNING	2023-07-07 00:00:00.0000000	Bengkulu utara	BENGKULU	commisioning unit	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Agus Nugroho	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-07-07 08:56	2023-07-07 08:56	2023-07-07 10:56	2023-07-07 15:25	2023-07-07 10:56	2023-07-07 15:25	2023-07-07 18:55	2023-07-08 02:16	2023-07-08 02:16	1088.0	389.0	9.0	YES	0.0
6084.0	ADMIN	BRANCH	July	1688697032379	WO23182910	HILLCONJAYA SAKTI, PT	-	-	VCE	EC210D	231900	494	WARRANTY	STANDBY	2023-07-07 00:00:00.0000000	Muara Teweh, Kalimantan Tengah	MUARA TEWEH	Periodical Service 500 HM	ETC	OTHER	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED		Muhamad Erdi Setiawan	Muara Teweh Admin	81366256198	muarateweh.sbs@indotruck-utama.co.id	2023-07-07 09:30	2023-07-07 09:30	2023-07-07 15:38	2023-07-07 15:38	2023-07-07 15:38	2023-07-07 15:38	-	2023-07-07 18:18	2023-07-07 18:18	1087.0	368.0	-	YES	0.0
6085.0	ADMIN	BRANCH	July	1688697290687	WO23182779	INDOTRUCK UTAMA, PT.	-	-	SDLG	E6210F	609626	13.8	STOK	STANDBY	2023-07-07 00:00:00.0000000	Balikpapan	BALIKPAPAN	Pre Delivery Inspect E6210F SN609626 HM13.8	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	p	Nova Ardianto	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-07-07 09:34	2023-07-07 09:35	2023-07-07 09:38	2023-07-07 09:38	2023-07-07 09:38	2023-07-07 09:38	2023-07-08 05:23	2023-07-08 05:24	2023-07-08 05:24	1087.0	4.0	19.0	YES	0.0
6086.0	ADMIN	BRANCH	July	1688699152715	WO23183008	INDOTRUCK UTAMA, PT.	-	-	VT	FMX37064T	YV2XS02GXPB426625	10	STOCK	RUNNING	-	YARD	JAKARTA	PDI	ENGINE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	arrived	Noval Qomaruzzaman Rasyid	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-07-07 10:05	2023-07-07 10:06	2023-07-07 12:48	2023-07-07 12:48	2023-07-07 12:48	2023-07-07 12:48	2023-07-07 20:13	2023-07-07 20:13	2023-07-10 10:37	1087.0	163.0	10.0	YES	0.0
6087.0	ADMIN	BRANCH	July	1688699809811	WO23182917	MANDIRI SEJAHTERA SENTRA, PT	-	-	VCE	EC480DL	284797	2005	NON WARRANTY	RUNNING	-	PURWAKARTA	JAKARTA	PM 2000	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Start from office	Yusuf Rhama Dhani	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-07-07 10:16	2023-07-07 10:17	2023-07-07 10:57	2023-07-21 09:33	2023-07-07 10:57	2023-07-21 09:33	2023-07-21 09:34	2023-07-21 09:34	2023-07-21 09:34	1087.0	20117.0	335.0	YES	0.0
6088.0	ADMIN	BRANCH	July	1688703216475	WO23182797	SUARDI SYAM	-	-	SDLG	E690F	600709	2043	NON WARRANTY	RUNNING	-	TIPO	PALU	FREE SERVICE & PART 2000HM E690F SN 600709	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-07-07 11:13	2023-07-07 11:14	2023-07-07 11:15	2023-07-07 12:19	2023-07-07 11:15	2023-07-07 12:19	2023-07-10 06:59	2023-07-10 07:48	2023-07-10 10:19	1087.0	66.0	67.0	YES	0.0
6089.0	ADMIN	BRANCH	July	1688718112114	WO23182936	INDOTRUCK UTAMA, PT.	-	-	SDLG	L956F	625259	1	WARRANTY	RUNNING	-	WORKSHOP MEDAN	MEDAN	Arrival Inspection Unit L956 F SN 625259	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	finished	Ferdian Dinata	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-07-07 15:21	2023-07-07 15:22	2023-07-25 19:14	2023-07-25 19:14	2023-07-25 19:14	2023-07-25 19:14	2023-07-25 19:14	2023-07-25 19:42	2023-07-25 19:42	1087.0	26153.0	435.0	YES	0.0