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
2531.0	ADMIN	BRANCH	March	1678846127714	WO23174226	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FM40084R	898639	3750	WARRANTY	RUNNING	-	BATUAH	SAMARINDA	2116 SERVICE 3750 HOURS DT61	ECT	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-03-15 09:08	2023-03-15 09:09	2023-03-15 09:09	2023-03-15 11:41	2023-03-15 09:09	2023-03-15 11:41	2023-03-15 21:22	2023-03-16 00:31	2023-03-16 00:31	1185.0	152.0	12.0	YES	0.0
2532.0	ADMIN	BRANCH	March	1678846385768	WO23174613	BINTANG ALAM REJEKI, PT.	-	-	VCE	A40G	322115	18500	NON WARRANTY	RUNNING	-	SANGA-SANGA	SAMARINDA	2165 Service 500 Hours B119	ECT	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Arman Maulana Saputra	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-03-15 09:13	2023-03-15 09:13	2023-03-15 09:13	2023-03-15 12:54	2023-03-15 09:13	2023-03-15 12:54	2023-03-15 16:58	2023-03-15 18:03	2023-03-15 18:03	1185.0	222.0	7.0	YES	0.0
2533.0	MECHANIC	MECHANIC	March	1678846624103	WO23174752	JAPFA COMFEED INDONESIA TBK, PT	-	-	SDLG	LG958L	9012745	-	NON WARRANTY	STANDBY	2023-03-15 00:00:00.0000000	Surabaya	SURABAYA	Replace Air Dryer	ETC	REPAIR	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job done	Muhammad Hatta	Muhammad Hatta	081365916683	mhatta037@gmail.com	2023-03-15 09:17	2023-03-15 09:17	2023-03-15 09:29	2023-03-15 09:52	2023-03-15 09:29	2023-03-15 09:52	2023-03-15 14:09	2023-03-15 14:10	2023-03-15 17:07	1185.0	36.0	4.0	YES	0.0
2534.0	MECHANIC	MECHANIC	March	1678846829995	-	BINTANG ALAM REJEKI, PT.	-	-	VCE	A40G	322115	-	NON WARRANTY	RUNNING	2023-03-15 00:00:00.0000000	sanga sanga	SAMARINDA	servis 500 hrs	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	rfu do servis 500hrs	ilham	ilham	082350786118	ilhamscreenscreen@gmail.com	2023-03-15 09:20	2023-03-15 09:21	2023-03-15 09:21	2023-03-15 10:41	2023-03-15 09:21	2023-03-15 10:41	2023-03-15 16:50	2023-03-15 18:16	2023-03-15 18:17	1185.0	81.0	7.0	YES	0.0
2535.0	ADMIN	BRANCH	March	1678846839089	WOCE174373	MANADO KARYA ANUGRAH, PT.	-	-	VCE	L120F	26697	11602	WARRANTY	BREAKDOWN	2023-03-15 00:00:00.0000000	Tokatindung	MANADO	Replace Injector 6 pcs	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job completed	Febryanto Ishak Aihua	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2023-03-15 09:20	2023-03-15 09:21	2023-03-15 11:48	2023-03-15 12:10	2023-03-15 11:48	2023-03-15 12:10	2023-03-15 19:05	2023-03-15 19:06	2023-04-14 10:19	1185.0	170.0	9.0	YES	0.0
2536.0	ADMIN	BRANCH	March	1678846978239	WO23174760	ARIFUDDIN	-	-	SDLG	E680F	607217	1017	WARRANTY	RUNNING	2023-02-09 00:00:00.0000000	SEBATIK	TARAKAN	SERVICE 1000HRS	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Finish	Christian Oktavianto	Tarakan Admin	89538317607	tarakan.sbs@indotruck-utama.co.id	2023-03-15 09:22	2023-03-15 09:23	2023-03-15 09:35	2023-03-15 11:37	2023-03-15 09:35	2023-03-15 11:37	2023-03-15 18:21	2023-03-16 07:35	2023-03-16 07:41	1185.0	135.0	8.0	YES	0.0
2537.0	ADMIN	BRANCH	March	1678848361283	WOSD174762	ADHIMIX RMC INDONESIA, PT.	-	-	SDLG	L956F	624028	1043	WARRANTY	STANDBY	-	SENTUL	JAKARTA	install fan condensor & exaust manifold gasket LG 956F 624028	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Done	Yusuf Rhama Dhani	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-03-15 09:46	2023-03-15 09:46	2023-03-15 10:59	2023-03-15 12:40	2023-03-15 10:59	2023-03-15 12:40	2023-03-15 14:45	2023-03-19 19:26	2023-03-19 19:26	1185.0	174.0	5.0	YES	0.0
2538.0	ADMIN	BRANCH	March	1678848458122	WO23174761	SUSANDIE, CV	-	-	SDLG	LG938	9021763	1	NON WARRANTY	BREAKDOWN	-	JAKABARING	PALEMBANG	Install transmission after overhaul	TRANSMISSION	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	READY	Bayu Pradana	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-03-15 09:47	2023-03-15 09:48	2023-03-15 09:48	2023-03-15 13:22	2023-03-15 09:48	2023-03-15 13:22	2023-03-21 09:46	2023-03-21 09:46	2023-03-21 09:47	1185.0	214.0	143.0	YES	0.0
2539.0	ADMIN	BRANCH	March	1678849124252	WO23174707	HUTAMA KARYA INFRASTRUKTUR PT	-	-	VCE	SD110	58962	4300	NON WARRANTY	RUNNING	-	PRABUMULIH	PALEMBANG	Service PM 1000 hours	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Ready job	Binharun Sipahutar	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-03-15 09:58	2023-03-15 09:59	2023-04-10 11:36	2023-04-12 06:20	2023-04-10 11:36	2023-04-12 06:27	2023-04-12 08:30	2023-04-12 08:31	2023-04-12 08:31	1185.0	2565.0	44.0	YES	0.0
2540.0	ADMIN	BRANCH	March	1678849342652	WO23174755	TIGER ENERGY SERVICES ROI, PT	-	-	VT	FM37064T	YV2XSG0DXHB829362	-	NON WARRANTY	RUNNING	-	DIENG, WONOSOBO	SEMARANG	YV2XSG0DXHB829362 WO23174755 T/S Transmission System. Abnormal air system VT NPS ENERGY INDONESIA, PT. 2564 ITU-000006748 SRWE Invoiced Triyono Smg 3/15/2023 18.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-03-15 10:02	2023-03-15 10:07	2023-03-15 10:07	2023-03-15 10:07	2023-03-15 10:07	2023-03-15 10:07	2023-03-17 13:49	2023-03-17 13:50	2023-03-17 13:50	1185.0	5.0	51.0	YES	5.0