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
5770.0	ADMIN	BRANCH	June	1687921134666	WO23182280	INDOTRUCK UTAMA, PT.	-	-	VCE	EC55D	233957	-	WARRANTY	RUNNING	2023-06-28 00:00:00.0000000	Makassar	MAKASSAR	Arrival Inspection Program	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Rudini	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-06-28 09:58	2023-06-28 09:59	2023-06-28 10:02	2023-06-28 12:07	2023-06-28 10:02	2023-06-28 12:07	2023-06-28 16:20	2023-06-28 18:02	2023-06-28 19:49	1096.0	129.0	6.0	YES	0.0
5771.0	ADMIN	BRANCH	June	1687924787200	WO23182253	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG956F	625353	2	STOCK	STANDBY	-	PALEMBANG	PALEMBANG	ARRIVAL INSPECTION	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	start job	Ponco Krisno Pratomo	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-28 10:59	2023-06-28 11:00	2023-06-28 11:01	2023-06-28 11:28	2023-06-28 11:01	2023-06-28 11:28	2023-06-28 17:03	2023-06-28 17:04	2023-06-28 17:04	1096.0	29.0	6.0	YES	0.0
5772.0	ADMIN	BRANCH	June	1687946432005	WO23182311	MANDIRI HERINDO ADIPERKASA, PT	-	-	VCE	EC750DL	280972	11	WARRANTY	STANDBY	-	SANGATTA	SANGATTA	EXPAND UNDERCARIDGE UNIT VOLVO EC750DL SN.280972	ECT	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	BACK TO OFFICE	Sangatta Admin	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-06-28 17:00	2023-06-28 17:00	2023-06-28 17:22	2023-06-28 18:23	2023-06-28 17:22	2023-06-28 18:23	2023-06-30 17:17	2023-07-04 09:13	2023-07-04 09:14	1096.0	83.0	48.0	YES	0.0
5773.0	ADMIN	BRANCH	June	1688089032171	WOCE182335	PUTRA MAGA NANDIRAMA, PT	-	-	VCE	A40G	324271	7365	WARRANTY	RUNNING	2023-06-30 00:00:00.0000000	bengkulu utara	BENGKULU	replace keyboard	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Harmanto	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-06-30 08:37	2023-06-30 08:37	2023-06-30 09:11	2023-06-30 11:45	2023-06-30 09:11	2023-06-30 11:45	2023-06-30 12:34	2023-06-30 14:01	2023-06-30 14:02	1095.0	188.0	3.0	YES	0.0
5774.0	ADMIN	CALL CENTER	June	1688092782586	WO23177145	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FM44064R	894964	3500	NON WARRANTY	RUNNING	-	SANGA SANGA	SAMARINDA	service 500	ECT	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-06-30 09:39	2023-06-30 09:41	2023-07-01 05:21	2023-07-01 11:11	2023-07-01 05:21	2023-07-01 11:11	2023-07-01 15:55	2023-07-01 20:23	2023-07-01 20:23	1094.0	1532.0	30.0	YES	1.0
5775.0	MECHANIC	BRANCH	June	1688092905032	23182344	KHOIRUL ANWAR	-	-	SDLG	E680F	607242	603	WARRANTY	RUNNING	2023-06-30 00:00:00.0000000	tulang bawang tengah	LAMPUNG	mandatory service 500h	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	pekerjaan selesai	Rheno Bayu Saputro	Rheno Bayu Saputro	81270803080	renodeui@gmail.com	2023-06-30 09:41	-	2023-06-30 09:42	2023-06-30 10:32	2023-06-30 09:42	2023-06-30 10:32	2023-06-30 14:33	2023-07-01 16:06	2023-07-08 21:47	1094.0	51.0	4.0	YES	-
5776.0	ADMIN	CALL CENTER	June	1688093471346	WOSD181667	BINTANG ALAM REJEKI, PT.	-	-	SDLG	L956L	624698	2284	WARRANTY	RUNNING	-	SEBULU	SAMARINDA	Replace Fan	ECT	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Syadikin	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-06-30 09:51	2023-06-30 09:51	2023-07-02 10:43	2023-07-02 13:00	2023-07-02 10:43	2023-07-02 13:00	2023-07-02 18:18	2023-07-02 18:25	2023-07-02 18:26	1094.0	3070.0	56.0	YES	0.0
5777.0	ADMIN	BRANCH	June	1688109574581	WO23181658	AMMAN MINERAL NUSA TENGGARA, PT	-	-	VT	FM37064T	B640349	-	NON WARRANTY	BREAKDOWN	2023-06-30 00:00:00.0000000	Surabaya	SURABAYA	Overhaul Engine TR-19	ENGINE	OVERHAUL	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Rudi Saputra	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-06-30 14:19	2023-06-30 14:19	2023-07-03 08:19	2023-07-03 08:43	2023-07-03 08:19	2023-07-03 08:43	2023-07-12 17:00	2023-07-12 17:00	2023-07-13 08:31	1094.0	3983.0	290.0	YES	0.0
5778.0	ADMIN	BRANCH	June	1688109957816	WOCE182293	MACMAHON MINING SERVICES, PT	-	-	VCE	A60H	320604	1316	WARRANTY	RUNNING	-	MARTABE	JAKARTA	PFR TD 9148 Altenator failure	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Tomi Jullio	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-06-30 14:25	2023-06-30 14:27	2023-06-30 14:32	2023-06-30 14:39	2023-06-30 14:32	2023-06-30 14:39	2023-06-30 14:39	2023-06-30 14:40	2023-06-30 14:40	1094.0	13.0	0.0	YES	1.0
5779.0	ADMIN	BRANCH	June	1688112274583	WOCE182353	INDOTRUCK UTAMA, PT.	-	-	VCE	EC210D	232103	11.5	WARRANTY	RUNNING	-	PURWAKARTA YARD	JAKARTA	Campaign installWECU 4.1	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Mochamad Alfan Nafas	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-06-30 15:04	2023-06-30 15:04	2023-07-06 09:59	-	2023-07-06 09:59	-	2023-07-06 10:01	2023-07-06 10:02	2023-07-06 10:02	1094.0	-	138.0	YES	0.0