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
2990.0	ADMIN	BRANCH	March	1679879550738	WOCE175673	SRI RAHAYU, A.MD.KEB	-	-	VCE	EC200D	281114	2479	WARRANTY	BREAKDOWN	2023-03-27 00:00:00.0000000	Malili	MAKASSAR	Water pump leak	ENGINE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Davit Witanto	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-03-27 08:12	2023-03-27 08:12	2023-03-27 08:14	2023-03-28 06:21	2023-03-27 08:14	2023-03-28 06:21	2023-03-28 14:53	2023-03-29 07:38	2023-03-29 08:13	1190.0	1329.0	30.0	YES	0.0
2991.0	ADMIN	BRANCH	March	1679882204455	WO23174316	JASA TAMBANG , CV.	-	-	VCE	EC210D	252815	1386	WARRANTY	RUNNING	2023-03-27 00:00:00.0000000	Geumpang	MEDAN	Mandatory Service 750 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di itu medan	Joys Alfedro Siregar	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-03-27 08:56	2023-03-27 08:56	2023-03-29 17:32	2023-03-31 23:55	2023-03-29 17:32	2023-03-31 23:55	2023-04-02 19:28	-	2023-04-05 13:20	1190.0	6659.0	154.0	YES	0.0
2992.0	ADMIN	BRANCH	March	1679882326664	WOCE175671	MACMAHON MINING SERVICES, PT	-	-	VCE	A60H	320328	10231	WARRANTY	RUNNING	-	MARTABE	JAKARTA	Exhaust manifold crack HM 10231	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Rizky Abdillah	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-03-27 08:58	2023-03-27 08:59	2023-03-27 09:01	2023-03-27 09:02	2023-03-27 09:01	2023-03-27 09:02	2023-03-27 09:02	2023-03-27 09:03	2023-03-27 09:04	1190.0	3.0	0.0	YES	0.0
2993.0	ADMIN	BRANCH	March	1679887495933	-	GRAHA BENUA ETAM, PT	-	-	SDLG	L956F	624701	-	NON WARRANTY	RUNNING	-	RING ROAD 2	SAMARINDA	SERVICE 2000 HRS	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	RFU after service 2000 hrs	Yanuar Yacob	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-03-27 10:24	2023-03-27 10:26	2023-03-27 10:27	2023-03-27 11:11	2023-03-27 10:27	2023-03-27 11:11	2023-03-27 18:30	2023-03-27 18:30	2023-03-27 18:31	1189.0	47.0	8.0	YES	1.0
2994.0	ADMIN	BRANCH	March	1679901412752	WO23175725	ARKAN JAYA SENTOSA CV	-	-	SDLG	E660FL	625482	1227	WARRANTY	RUNNING	2023-03-27 00:00:00.0000000	lampung selatan	LAMPUNG	serv on call	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	pekerjaan selesai	Heri Sucipto	Lampung Admin	81366256194	lampung.sbs@indotruck-utama.co.id	2023-03-27 14:16	2023-03-27 14:20	2023-03-27 14:22	2023-03-27 15:46	2023-03-27 14:22	2023-03-27 15:46	2023-03-27 18:58	2023-03-28 08:14	2023-03-28 08:22	1189.0	90.0	4.0	YES	3.0
2995.0	MECHANIC	MECHANIC	March	1679910905241	WO23175471	UTAMA TRAKTOR,CV.	-	-	SDLG	L968L	620575	1500	WARRANTY	RUNNING	2023-03-27 00:00:00.0000000	Site BP pulau panggung	MUARA ENIM	Service 1500	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	RFU	Ichsan Ali Rosidi	Ichsan Ali Rosidi	081315343354	xzanalirosidi313@gmail.com	2023-03-27 16:55	-	2023-03-28 09:25	-	2023-03-28 09:25	-	-	-	2023-03-28 17:59	1189.0	-	-	YES	-
2996.0	ADMIN	BRANCH	March	1679965511669	WO23175690	ARODYA BIRU PERSADA, PT	-	-	VCE	SD110	59384	100	WARRANTY	RUNNING	-	PRABUMULIH	PALEMBANG	Service 100 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	arrival office palembang 19 : 00 28.032023	Edy Nugroho	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-03-28 08:05	2023-03-28 08:05	2023-03-28 08:05	2023-03-29 06:03	2023-03-28 08:05	2023-03-29 06:03	2023-03-29 06:05	-	2023-03-29 06:06	1189.0	1318.0	22.0	YES	0.0
2997.0	ADMIN	BRANCH	March	1679967960195	WO23175654	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324474	3600	WARRANTY	STANDBY	-	MUARA LAWAI	MUARA ENIM	PM service 3600 jam AD 66 SN 324474 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	Agus Prabowo	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-03-28 08:46	2023-03-28 08:46	2023-04-05 09:50	2023-04-05 10:29	2023-04-05 09:50	2023-04-05 10:29	2023-04-05 11:08	2023-04-05 11:32	2023-04-05 11:36	1189.0	41.0	1.0	YES	0.0
2998.0	MECHANIC	MECHANIC	March	1679970463635	23174688	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	EC480DL	276588	8368	WARRANTY	RUNNING	2023-03-28 00:00:00.0000000	SITE BGG	MUARA ENIM	SERVICE 400	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	RFU	Ichsan Ali Rosidi	Ichsan Ali Rosidi	081315343354	xzanalirosidi313@gmail.com	2023-03-28 09:27	-	2023-03-28 09:28	-	2023-03-28 09:28	-	-	-	2023-03-28 17:59	1188.0	-	-	YES	-
2999.0	ADMIN	BRANCH	March	1679971232994	WO23175743	ULIMA NITRA, PT	-	-	VCE	EC480DL	276937	3500	WARRANTY	STANDBY	-	UN	MUARA ENIM	S 3500 HM AB 267 SN 276937 UN	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	Gabby Hade Octafiando	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-03-28 09:40	2023-03-28 09:42	2023-03-31 14:00	2023-03-31 14:19	2023-03-31 14:00	2023-03-31 14:19	2023-03-31 14:44	2023-03-31 15:09	2023-03-31 15:12	1188.0	355.0	6.0	YES	1.0