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
4111.0	ADMIN	BRANCH	May	1683690181593	‪‪‪WO23179466‬‬	RIMBA PERKASA UTAMA, PT	-	-	VCE	A60H	320623	8	Warranty	RUNNING	-	PENDINGIN	SAMARINDA	COMMISIONING	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	rfu	Yanuar Yacob	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-10 10:43	2023-05-10 10:43	2023-05-10 10:43	2023-05-10 11:43	2023-05-10 10:43	2023-05-10 11:43	2023-05-10 22:44	2023-05-10 22:45	2023-05-10 22:45	1129.0	60.0	12.0	YES	0.0
4112.0	ADMIN	BRANCH	May	1683690304651	WO23178682	MANNA, CV	-	-	VCE	EC200D	281343	182	WARRANTY	STANDBY	-	KENDARI	KENDARI	Reset auto Idle EC200D SN281343	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive	RAHMAN GUSTI YAKSA	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-05-10 10:45	2023-05-10 10:45	2023-05-10 10:47	2023-05-10 10:50	2023-05-10 10:47	2023-05-10 10:50	2023-05-10 10:55	2023-05-10 10:55	2023-05-10 11:21	1129.0	5.0	0.0	YES	0.0
4113.0	ADMIN	BRANCH	May	1683690552585	WO23177113	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	894956	3000	NON WARRANTY	RUNNING	-	PENDINGIN	SAMARINDA	SERVICE 1000 HRS VT076	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	do e	Arman Maulana Saputra	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-10 10:49	2023-05-10 10:49	2023-05-10 10:50	2023-05-10 13:18	2023-05-10 10:50	2023-05-10 13:18	2023-05-11 06:45	2023-05-11 08:56	2023-05-11 08:56	1129.0	149.0	19.0	YES	0.0
4114.0	ADMIN	BRANCH	May	1683690832123	WO23177652	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	895868	3750	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 250 HRS VT075	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-10 10:53	2023-05-10 10:54	2023-05-10 10:54	2023-05-10 12:11	2023-05-11 08:56	2023-05-11 12:23	2023-05-11 19:22	2023-05-11 20:55	2023-05-11 20:55	1129.0	77.0	8.0	YES	0.0
4115.0	ADMIN	BRANCH	May	1683691339912	WO23178684	INDOTRUCK UTAMA, PT.	-	-	SDLG	E6210F	609603	5.3	STOCK	STANDBY	-	W/S PEKANBARU	PEKANBARU	Storage Maintenance	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	DARMO SUWITO	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-10 11:02	2023-05-10 11:02	2023-05-10 11:06	2023-05-10 11:06	2023-05-10 11:06	2023-05-10 11:06	2023-05-10 11:37	2023-05-10 11:38	2023-05-10 11:40	1129.0	5.0	0.0	YES	0.0
4116.0	ADMIN	BRANCH	May	1683692362366	WO23178685	MANNA, CV	-	-	VCE	EC200D	281109	819	WARRANTY	STANDBY	-	KENDARI	KENDARI	Service mandatory and Reset auto idle EC200D SN281109	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch office	RAHMAN GUSTI YAKSA	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-05-10 11:19	2023-05-10 11:19	2023-05-10 12:17	2023-05-10 12:18	2023-05-10 12:17	2023-05-10 12:18	2023-05-10 12:20	2023-05-10 12:21	2023-05-10 13:54	1129.0	59.0	1.0	YES	0.0
4117.0	MECHANIC	MECHANIC	May	1683692822217	WOCE175534	SAMUDERA MULIA ABADI, PT	-	-	VCE	EC950E	370170	-	WARRANTY	RUNNING	2023-05-10 00:00:00.0000000	Bakan	MANADO	Campaign EMP55	ETC	OTHER	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	arrived in branch	Ramadhan Setiawan Argi	Ramadhan Setiawan Argi	082119528541	ramadhan.argi@gmail.com	2023-05-10 11:27	2023-05-10 11:27	2023-05-10 11:27	2023-05-10 11:27	2023-05-10 11:31	2023-05-10 11:31	2023-05-10 20:09	2023-05-10 20:09	2023-05-23 09:04	1129.0	1.0	8.0	YES	0.0
4118.0	MECHANIC	MECHANIC	May	1683693068702	WOCE174779	SAMUDERA MULIA ABADI, PT	-	-	VCE	EC950E	370170	-	WARRANTY	BREAKDOWN	2023-05-10 00:00:00.0000000	Bakan	MANADO	Install part warranty engine oil mixed fuel	ENGINE	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	arrived	Ramadhan Setiawan Argi	Ramadhan Setiawan Argi	082119528541	ramadhan.argi@gmail.com	2023-05-10 11:31	2023-05-10 20:07	2023-05-10 20:07	2023-05-10 20:07	2023-05-10 20:07	2023-05-10 20:07	2023-05-11 19:52	2023-05-11 19:54	2023-05-23 09:04	1129.0	517.0	32.0	YES	516.0