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
1640.0	ADMIN	BRANCH	February	1676517406984	23172986	PRIMA SARANA MUSTIKA, PT	-	-	SDLG	G9138	600594	241	WARRANTY	RUNNING	-	KARANGAN	SANGATTA	SEALING KIT BROKEN SDLG G9138F SN.600594	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Sofian Ghazali Rakhman	Christina	082354650329	svcadm.sangata@indotruck-utama.co.id	2023-02-16 10:16	2023-02-16 10:17	2023-02-16 13:44	2023-02-16 15:04	2023-02-16 13:44	2023-02-16 15:04	2023-02-17 08:04	2023-02-20 16:12	2023-02-21 07:29	1228.0	288.0	21.0	YES
1641.0	BRANCH	BRANCH	February	1676517683087	WO23173445	UMUM PEMERINTAH DKI JAKARTA	-	-	VCE	EC210B	84582	-	NON WARRANTY	RUNNING	-	TANAH ABANG - JAKARTA PUSAT	JAKARTA	MIP UNIT XL-40 YEARLY INSPECTION SCHEDULED	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampe	Ismail Fauzi	Helmy Wishnu Apriyono	082297165756	helmy.mekanik.indotruck@gmail.com	2023-02-16 10:21	2023-02-16 10:21	2023-02-16 10:54	2023-02-16 12:28	2023-02-16 10:54	2023-02-16 12:28	2023-02-16 16:12	2023-02-16 16:58	2023-02-22 11:03	1228.0	127.0	5.0	YES
1642.0	BRANCH	BRANCH	February	1676523534048	WO23172951	USAHA MANDIRI TEHNIK, PT	-	-	VCE	EC210D	283568	1538	NON WARRANTY	RUNNING	2023-02-16 00:00:00.0000000	Serpong	CILEGON	General Check and Clean Up Injector Gasket Incld Test	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Complete	Rizqin Aminullah	Danu Adi pamungkas	085700225603	danu.pamungkas@indotruck-utama.co.id	2023-02-16 11:58	2023-02-16 11:59	2023-02-16 13:14	2023-02-16 14:35	2023-02-20 08:39	2023-02-20 13:13	2023-02-20 17:10	2023-02-20 17:11	2023-02-21 13:38	1228.0	156.0	4.0	YES
1643.0	MECHANIC	MECHANIC	February	1676524509279	WO23172951	USAHA MANDIRI TEHNIK, PT	-	-	VCE	EC200D	283568	1538	NON WARRANTY	RUNNING	2023-02-16 00:00:00.0000000	Serpong	CILEGON	General check and clean up injector gasket include test	ETC	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job Complete	Muhammad Abdurrofi	Muhammad Abdurrofi	089650505566	abdurrofim19@gmail.com	2023-02-16 12:15	2023-02-16 12:15	2023-02-16 13:01	2023-02-16 14:33	2023-02-20 08:39	2023-02-20 13:17	2023-02-20 17:11	2023-02-21 13:30	2023-02-21 13:37	1228.0	138.0	4.0	YES
1644.0	MECHANIC	MECHANIC	February	1676546828889	23171685	SUNGAI RANGIT,PT.	-	-	VCE	EC210D	283479	6079	NON WARRANTY	RUNNING	2023-02-16 00:00:00.0000000	Sukamara kotawarungin barat	BANJARMASIN	Inspection Engine Lowe piwer EC 210 D.SN 283479	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Redy	Muksim Triharyadi	Muksim Triharyadi	085246182601	muksimtrharyadi@gmail.com	2023-02-16 18:27	2023-02-16 18:27	2023-02-16 18:27	2023-02-16 18:27	2023-02-16 18:27	2023-02-16 18:27	2023-02-16 18:28	2023-02-16 18:28	2023-02-16 18:29	1228.0	0.0	0.0	YES
1645.0	MECHANIC	MECHANIC	February	1676547053683	23171682	SUNGAI RANGIT,PT.	-	-	VCE	EC210D	283469	4000	NON WARRANTY	BREAKDOWN	2023-02-16 00:00:00.0000000	Sukamara kotawaringin barat	BANJARMASIN	Inspection Main Pump EC 210D ,SN:283469	ETC	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Unit Breack Down	Muksim Triharyadi	Muksim Triharyadi	085246182601	muksimtrharyadi@gmail.com	2023-02-16 18:30	2023-02-16 18:31	2023-02-16 18:31	2023-02-16 18:31	2023-02-16 18:31	2023-02-16 18:31	2023-02-16 18:31	2023-02-16 18:32	2023-02-16 18:32	1228.0	1.0	0.0	YES
1646.0	MECHANIC	MECHANIC	February	1676598311309	WO23176110	SAMUDERA MULIA ABADI, PT	-	-	VCE	A40G	322991	18694	NON WARRANTY	BREAKDOWN	2023-02-17 00:00:00.0000000	bakan	MANADO	install part order MIP & check oil engine mix coolant	ENGINE	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	job completed	Ramadhan Setiawan Argi	Ramadhan Setiawan Argi	082119528541	ramadhan.argi@gmail.com	2023-02-17 08:45	2023-02-17 08:45	2023-02-17 08:45	2023-02-17 08:45	2023-02-17 08:45	2023-02-17 08:45	2023-03-17 08:21	2023-03-17 08:21	2023-04-14 10:15	1228.0	1.0	671.0	YES
1647.0	BRANCH	BRANCH	February	1676598433121	wo23172712	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	309039	998	NON WARRANTY	RUNNING	2023-02-16 00:00:00.0000000	Batuah	SAMARINDA	periodic service 1000hours VT90	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Erni Wati	082353253757	admin.service.smd@indotruck-utama.co.id	2023-02-17 08:47	2023-02-17 08:47	2023-02-17 08:48	2023-02-17 11:54	2023-02-17 08:48	2023-02-17 11:54	2023-02-17 18:32	2023-02-17 20:31	2023-02-17 20:31	1228.0	187.0	9.0	YES
1648.0	BRANCH	BRANCH	February	1676598763227	wo23172711	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	309021	995	NON WARRANTY	RUNNING	2023-02-16 00:00:00.0000000	Batuah TMU	SAMARINDA	periode service 1000hrs VT89	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Erni Wati	082353253757	admin.service.smd@indotruck-utama.co.id	2023-02-17 08:52	2023-02-17 08:53	2023-02-17 08:53	2023-02-17 11:54	2023-02-17 08:53	2023-02-17 11:54	2023-02-17 18:32	2023-02-17 20:30	2023-02-17 20:31	1228.0	181.0	9.0	YES
1649.0	BRANCH	BRANCH	February	1676598991004	wo23172714	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	895842	2739	NON WARRANTY	RUNNING	2023-02-16 00:00:00.0000000	Batuah TMU	SAMARINDA	periodic service 250hrs VT74	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Erni Wati	082353253757	admin.service.smd@indotruck-utama.co.id	2023-02-17 08:56	2023-02-17 08:56	2023-02-17 11:55	2023-02-17 13:35	2023-02-17 11:55	2023-02-17 13:35	2023-02-17 18:32	2023-02-17 20:30	2023-02-17 20:31	1228.0	279.0	9.0	YES