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
2540.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	1201.0	81.0	7.0	YES	0.0
2541.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	1201.0	170.0	9.0	YES	0.0
2542.0	ADMIN	BRANCH	March	1678854075584	WO23175033	DIAN NOVITASARI	-	-	SDLG	E660FL	625338	259	WARRANTY	RUNNING	-	KEC. DAMSOL, DONGGALA, PANTAI BARAT	PALU	SERVICE 250 HM E660FL SN. 625338	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Sampai Di Office	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-03-15 11:21	2023-03-15 11:25	2023-03-15 11:54	2023-03-15 17:40	2023-03-15 11:54	2023-03-15 17:40	2023-03-15 21:00	2023-03-16 07:47	2023-03-20 07:55	1201.0	379.0	9.0	YES	3.0
2543.0	ADMIN	BRANCH	March	1678857367061	WO23175197	BALIKPAPAN READYMIX, PT	-	-	VCE	EC210D	231887	235	WARRANTY	RUNNING	-	BULURI, PALU BARAT	PALU	SERVICE 250 HM EC21OD SN. 231887	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	ARRIVE IN BRANCH OFFICE PALU	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-03-15 12:16	2023-03-15 12:18	2023-03-15 12:35	2023-03-15 13:33	2023-03-15 12:35	2023-03-15 13:33	2023-03-15 14:23	2023-03-15 15:26	2023-03-20 09:57	1201.0	77.0	2.0	YES	2.0
2544.0	ADMIN	BRANCH	March	1678862256853	-	PAMA PERSADA NUSANTARA, PT	-	-	VCE	A40G	322426	15363	NON WARRANTY	STANDBY	-	SEPARI, JEMBAYAN	SAMARINDA	2166 TRANSMISSION PROBLEM	TRANSMISSION	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	unit ready for use	Marsono	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-03-15 13:37	2023-03-15 13:38	2023-03-15 13:38	2023-03-15 14:20	2023-03-15 13:38	2023-03-15 14:20	2023-03-15 16:04	2023-03-15 18:21	2023-03-15 18:22	1201.0	43.0	2.0	YES	0.0
2545.0	ADMIN	BRANCH	March	1678863564432	WO23174747	PENTHA AGRO PRIMA, CV	-	-	SDLG	L956F	625024	250	WARRANTY	RUNNING	2023-03-15 00:00:00.0000000	WENGGA PALEM, BANJARBARU	BANJARMASIN	SERVICE 250HM	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	.	Widianto	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-03-15 13:59	2023-03-15 13:59	2023-03-16 09:23	2023-03-16 09:24	2023-03-16 09:23	2023-03-16 09:24	2023-03-16 09:24	2023-03-16 09:24	2023-03-16 09:24	1201.0	1165.0	19.0	YES	0.0
2546.0	ADMIN	BRANCH	March	1678865964063	WO23174786	INDOTRUCK UTAMA, PT.	-	-	VCE	L220H	12421	7	STOK	STANDBY	2023-03-15 00:00:00.0000000	Balikpapan	BALIKPAPAN	PDI L220H sn12421	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	pdi	Muklis	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-03-15 14:39	2023-03-15 14:39	2023-03-15 14:46	2023-03-15 14:48	2023-03-15 14:46	2023-03-15 14:48	2023-03-15 16:16	2023-03-15 16:16	2023-03-15 16:16	1201.0	9.0	1.0	YES	0.0
2547.0	ADMIN	BRANCH	March	1678867394987	WO23174791	INDOTRUCK UTAMA, PT.	-	-	VCE	EC210D	231933	6	STOK	STANDBY	2023-03-15 00:00:00.0000000	Balikpapan	BALIKPAPAN	Arrival Inspect EC210D SN231933	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	pdi	Muklis	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-03-15 15:03	2023-03-15 15:03	2023-03-15 15:10	2023-03-15 15:11	2023-03-15 15:10	2023-03-15 15:11	2023-03-15 16:13	2023-03-15 16:13	2023-03-15 16:15	1201.0	8.0	1.0	YES	0.0
2548.0	ADMIN	BRANCH	March	1678868162131	WO23176366	GANDAERAH HENDANA, PT	-	-	VCE	EC210BLC	24034	0	NON WARRANTY	BREAKDOWN	-	UKUI	PEKANBARU	Replace handpump water separator	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai dikantor	GALIH PERMADI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-03-15 15:16	2023-03-15 15:16	2023-04-03 11:17	2023-04-03 19:17	2023-04-03 11:17	2023-04-03 19:17	2023-04-04 16:39	2023-04-08 18:59	2023-04-13 11:42	1201.0	600.0	31.0	YES	0.0
2549.0	ADMIN	BRANCH	March	1678869203242	23174783	DINAS PEKERJAAN UMUM DAN PENATAAN RUANG KABUPATEN BATANGHARI	-	-	VCE	EC210D	231851	250	WARRANTY	RUNNING	-	BATANGHARI	JAMBI	MANDATORY SERVICE 250 H	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Nyampai Office	Hafiz Rusydi	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-03-15 15:33	2023-03-15 15:33	2023-03-16 09:51	2023-03-16 13:11	2023-03-16 09:51	2023-03-16 13:11	2023-03-16 15:01	-	2023-03-16 17:56	1201.0	1298.0	23.0	YES	0.0