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
5810.0	ADMIN	BRANCH	June	1687839797002	WOCE182032	SENTOSA LAJU SEJAHTERA, PT.	-	-	VCE	EC480DL	284428	2441	NON WARRANTY	RUNNING	2023-06-27 00:00:00.0000000	TAMIYANG LAYANG	BANJARMASIN	BUCKET HOSE CRACK - WOCE EX101-10	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Waiting part	Junaidi Arsyandi	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-06-27 11:23	2023-06-27 11:23	2023-07-06 13:18	2023-07-06 13:18	2023-07-06 13:18	2023-07-06 13:18	2023-07-06 13:20	2023-07-06 13:21	2023-07-06 13:21	1097.0	13075.0	217.0	YES	0.0
5811.0	ADMIN	BRANCH	June	1687840430072	WOSD182200	PRIMA SARANA MUSTIKA, PT	-	-	SDLG	G9220	600591	1971	WARRANTY	STANDBY	2023-06-27 00:00:00.0000000	.	BANJARMASIN	VBELT BROKEN	ENGINE	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Unit Ready For Use	Piter Setiawan	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-06-27 11:33	2023-06-27 11:33	2023-06-29 14:46	2023-06-29 14:47	2023-06-29 14:46	2023-06-29 14:47	2023-06-29 14:49	2023-06-29 14:49	2023-06-29 14:50	1097.0	3073.0	51.0	YES	0.0
5812.0	ADMIN	BRANCH	June	1687850093815	WO23182229	INDOTRUCK UTAMA, PT.	-	-	SDLG	L956F	625325	1	STOK	STANDBY	2023-06-27 00:00:00.0000000	Surabaya	SURABAYA	Maintenance Storage	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Ajik Pramusinta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-06-27 14:14	2023-06-27 14:15	2023-06-27 14:27	2023-06-27 14:28	2023-06-27 14:27	2023-06-27 14:28	2023-06-28 08:24	2023-06-28 09:25	2023-06-28 09:26	1097.0	13.0	18.0	YES	0.0
5813.0	ADMIN	BRANCH	June	1687920357955	WO23182279	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606443	-	WARRANTY	RUNNING	2023-06-28 00:00:00.0000000	Makassar	MAKASSAR	PDI unit	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Rudini	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-06-28 09:45	2023-06-28 09:46	2023-06-28 09:56	2023-06-28 12:08	2023-06-28 09:56	2023-06-28 12:08	2023-06-28 16:20	2023-06-28 18:02	2023-06-28 19:49	1096.0	142.0	6.0	YES	0.0
5814.0	ADMIN	BRANCH	June	1687924949538	WO23182270	INDOTRUCK UTAMA, PT.	-	-	SDLG	E660FL	625953	4	STOCK	STANDBY	-	PALEMBANG	PALEMBANG	ARRIVAL INSPECTION	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	start job	Krisna Damas Prasetya	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-28 11:02	2023-06-28 11:02	2023-06-28 11:03	2023-06-28 11:28	2023-06-28 11:03	2023-06-28 11:28	2023-06-28 16:55	2023-06-28 16:55	2023-06-28 16:56	1096.0	26.0	5.0	YES	0.0
5815.0	ADMIN	BRANCH	June	1687926402573	WO23182277	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606454	4	STOCK	STANDBY	-	PALEMBANG	PALEMBANG	MAINTENANCE STORAGE JUNI'23	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	start job	Ponco Krisno Pratomo	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-28 11:26	2023-06-28 11:27	2023-06-28 11:27	2023-06-28 11:29	2023-06-28 11:27	2023-06-28 11:29	2023-06-28 16:52	2023-06-28 16:52	2023-06-28 16:52	1096.0	3.0	5.0	YES	0.0
5816.0	ADMIN	BRANCH	June	1687939313477	WO23183623	GUNUNG SAWIT ABADI, PT.	-	-	SDLG	LG936L	604038	28712	NON WARRANTY	RUNNING	-	PASAMAN	PEKANBARU	Replace gasket cylinder head	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	BELLIARD SUSANTO	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-06-28 15:01	2023-06-28 15:02	2023-07-18 10:34	2023-07-18 13:33	2023-07-18 10:34	2023-07-18 13:33	2023-07-21 11:11	2023-07-24 21:44	2023-07-25 10:35	1096.0	10210.0	239.0	YES	0.0
5817.0	ADMIN	BRANCH	June	1687944003242	WO23181956	DINAS PEKERJAAN UMUM KABUPATEN KUTAI TIMUR	-	-	VCE	EC55D	233907	558	WARRANTY	RUNNING	-	SANGATTA	SANGATTA	SERVICE 500 HOURS UNIT VOLVO EC55D SN.233907	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	COMPLETED, FTF	Sangatta Admin	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-06-28 16:20	2023-06-28 16:20	2023-06-28 16:44	2023-06-28 17:23	2023-06-28 16:44	2023-06-28 17:23	2023-06-28 18:23	2023-06-30 17:18	2023-06-30 17:18	1096.0	64.0	2.0	YES	0.0
5818.0	ADMIN	BRANCH	June	1687947739350	WO23182314	MANDIRI HERINDO ADIPERKASA, PT	-	-	VCE	EC750DL	280947	12	WARRANTY	STANDBY	-	BENGALON	SANGATTA	EXPAND UNDERCARIDGE VOLVO EC750DL SN.280947	ECT	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	ON PROGRESS INSTALL	Sangatta Admin	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-06-28 17:22	2023-06-28 17:22	2023-06-28 18:23	2023-06-30 17:17	2023-06-28 18:23	2023-06-30 17:17	2023-07-04 09:13	2023-07-05 14:39	2023-07-05 14:39	1096.0	2875.0	135.0	YES	0.0
5819.0	MECHANIC	MECHANIC	June	1687956845856	401	BAHTERA PUTERA NUSANTARA, PT.	-	-	VT	FH1655064T	Pm 60012	41662	NON WARRANTY	RUNNING	2023-06-28 00:00:00.0000000	Slr km 14	MUARA ENIM	T/s display off	ENGINE	REPAIR	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Action:Travelling to km 5,T/s electric , can'nt start, check fuse, relay, repair relay , test start , repair cable impuls sensor, test , ok Travelling	Jumingan	Jumingan	085271117559	jumingan.volvo@gmail.com	2023-06-28 19:54	-	2023-06-28 19:55	2023-06-28 21:00	2023-06-28 19:55	2023-06-29 01:48	2023-06-29 00:09	-	2023-06-29 01:52	1096.0	67.0	4.0	YES	-