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
3680.0	ADMIN	BRANCH	April	1681875290010	WO23177889	RAY ANJERRAH RESOURCES, PT	-	-	VCE	SD110	58803	5042	NON WARRANTY	BREAKDOWN	-	BONTANG	SAMARINDA	SPEED MAJU MUNDUR TIDAK MAKSIMAL	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job Inspect Done untuk waiting Part belum tersuply krn kendala payment.jadi wo inspect di close. nnt part datang pakai WO baru yaitu install Part.	Marsono	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-04-19 10:34	2023-04-19 10:35	2023-04-19 10:35	2023-04-19 17:18	2023-04-19 10:35	2023-04-19 17:18	2023-04-20 14:34	2023-04-21 11:08	2023-06-07 13:49	1166.0	404.0	27.0	YES	0.0
3681.0	BRANCH	BRANCH	April	1681878513442	WOCE177584	SUMBER MITRA JAYA, PT	-	-	VCE	A40G	324738	1053	WARRANTY	STANDBY	2023-04-19 00:00:00.0000000	site SBE	BERAU	Replace keyboard	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job closed	Ferdy	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-04-19 11:28	2023-04-19 11:28	2023-04-20 07:30	2023-04-20 08:18	2023-04-20 07:30	2023-04-20 08:18	2023-04-20 14:34	2023-04-20 15:41	2023-04-20 15:42	1166.0	1250.0	27.0	YES	0.0
3682.0	ADMIN	BRANCH	April	1681888081651	WOCE177641	INDOTRUCK UTAMA, PT.	-	-	VCE	EC200D	281397	4.1	WARRANTY	STANDBY	-	YARD PURWAKARTA	JAKARTA	Campaign installation WECU 4.1 EC200D SN 281397 ITU Purwakarta	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	CAMPAIGN WECU 4.1 jam 13.00	Mochamad Alfan Nafas	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-04-19 14:08	2023-04-19 14:08	2023-05-20 10:05	2023-05-20 12:02	2023-05-20 10:07	2023-05-20 12:02	2023-05-23 11:13	2023-05-23 11:13	2023-05-23 11:14	1166.0	44514.0	813.0	YES	0.0
3683.0	MECHANIC	MECHANIC	April	1681950546706	CC23177122	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	AA302353	-	WARRANTY	RUNNING	2023-04-20 00:00:00.0000000	MSF bangko barat muara enim	MUARA ENIM	Schedule service pm400 hours DT3010-05	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Complete and Ready	M. Riski Ibrahim	M. Riski Ibrahim	0895610719859	mriskiibrahim999@gmail.com	2023-04-20 07:29	2023-04-20 07:29	2023-04-20 07:43	2023-04-20 08:01	2023-04-20 07:43	2023-04-20 08:01	2023-04-20 14:01	2023-04-20 14:22	2023-04-20 14:23	1166.0	32.0	6.0	YES	0.0
3684.0	ADMIN	BRANCH	April	1681952196314	WO23177825	INDOTRUCK UTAMA, PT.	-	-	SDLG	E6138F	606351	7.3	STOK	STANDBY	2023-04-20 00:00:00.0000000	Balikpapan	BALIKPAPAN	Arrival Inspection E6138F SN606351 HM7.3	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	arrival	Nova Ardianto	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-04-20 07:56	2023-04-20 07:56	2023-04-20 07:58	2023-04-20 07:58	2023-04-20 07:58	2023-04-20 07:58	2023-04-21 03:01	2023-04-21 03:01	2023-04-21 03:01	1166.0	2.0	19.0	YES	0.0
3685.0	MECHANIC	MECHANIC	April	1681975135747	CC23177121	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	AA302275	2395	WARRANTY	RUNNING	2023-04-20 00:00:00.0000000	MSF bangko barat muara enim	MUARA ENIM	schedule service pm400 hours DT3010-03	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Complete and Ready	M. Riski Ibrahim	M. Riski Ibrahim	0895610719859	mriskiibrahim999@gmail.com	2023-04-20 14:18	2023-04-20 14:19	2023-04-20 15:26	2023-04-20 15:31	2023-04-20 15:26	2023-04-20 15:31	2023-04-20 17:07	2023-04-20 18:23	2023-04-20 18:24	1165.0	72.0	2.0	YES	0.0
3686.0	ADMIN	BRANCH	April	1681976764596	WOCE177706	INDOTRUCK UTAMA, PT.	-	-	VCE	EC480DL	285033	1	WARRANTY	STANDBY	-	YARD PURWAKARTA	JAKARTA	Campaign WECU 4.1	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Septian Dwi Handarian	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-04-20 14:46	2023-04-20 14:46	2023-04-24 13:17	2023-04-28 10:31	2023-04-28 10:30	2023-04-28 10:31	2023-04-28 10:33	-	2023-04-28 10:34	1165.0	11266.0	187.0	YES	0.0
3687.0	ADMIN	BRANCH	April	1681978883310	WO23177981	TIBER JAYA MANDIRI, PT	-	-	SDLG	E6210F	609694	80	WARRANTY	RUNNING	2023-04-14 00:00:00.0000000	JUATA	TARAKAN	SERVICE 50 HRS	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job finished.	Riko Wahyu Darusman	Tarakan Admin	89538317607	tarakan.sbs@indotruck-utama.co.id	2023-04-20 15:21	2023-04-20 15:21	2023-04-20 15:31	2023-04-20 16:05	2023-04-20 15:31	2023-04-20 16:05	2023-04-20 16:26	-	2023-04-20 20:06	1165.0	44.0	1.0	NO	0.0
3688.0	ADMIN	BRANCH	April	1682039389627	WO23177486	RAKA NAVARA, PT	-	-	VCE	EC210D	252810	1706	WARRANTY	RUNNING	-	KOLAKA UTARA	KENDARI	Service Mandatory EC210D SN 252810	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Done	Arfandi yahya	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-04-21 08:09	2023-04-21 08:37	2023-04-21 08:40	2023-04-21 13:27	2023-04-21 08:40	2023-04-21 13:27	2023-04-21 13:32	-	2023-04-22 09:48	1165.0	318.0	5.0	YES	28.0
3689.0	MECHANIC	MECHANIC	April	1682061515464	-	DINAS PERTANIAN DAN PETERNAKAN KABUPATEN KUTAI KARTANEGARA	-	-	SDLG	E660FL	625766	522.1	WARRANTY	RUNNING	2023-04-21 00:00:00.0000000	Separi	SAMARINDA	Service 500 H	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	completed service PS500 SDLG E660FL	Diky Maulana Tarmiji	Diky Maulana Tarmiji	081356619526	iamdiky15@gmail.com	2023-04-21 14:18	2023-04-21 14:19	2023-04-21 14:19	2023-04-21 21:57	2023-04-21 14:19	2023-04-21 21:57	2023-04-21 21:58	2023-04-21 21:58	2023-04-21 21:59	1164.0	459.0	7.0	YES	0.0