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
3610.0	ADMIN	BRANCH	April	1681790070597	WO23177511	ROSALIA INDAH TRANSPORT, PT.	-	-	VB	B11R	YV3T2T426LA200532	-	NON WARRANTY	RUNNING	-	PALUR	SEMARANG	YV3T2T426LA200532 WO23177511 T/S TRANSMISSION SYSTEM INCLUDE CALIBRATION SDD 165 VB ROSALIA INDAH TRANSPORT, PT. 2597 ITU-000010076 SRWE Invoiced Triyono Smg 4/18/2023 9.00	TRANSMISSION	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-04-18 10:54	2023-04-18 10:54	2023-04-18 10:54	2023-04-18 10:54	2023-04-18 10:54	2023-04-18 10:54	2023-04-18 18:48	2023-04-18 18:48	2023-04-18 18:48	1167.0	0.0	7.0	YES
3611.0	ADMIN	BRANCH	April	1681791840397	WO23177523	MENGGALA VICTORY JAYA, PT.	-	-	SDLG	E6210F	609295	750	WARRANTY	STANDBY	-	SORONG	SORONG	Service 750 Hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	Rheno Bayu Saputro	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-04-18 11:24	2023-04-18 11:24	2023-04-18 11:41	2023-04-18 14:06	2023-04-18 11:41	2023-04-18 14:06	2023-04-18 16:49	2023-04-18 18:38	2023-04-27 12:52	1167.0	162.0	5.0	YES
3612.0	ADMIN	BRANCH	April	1681793353613	WO23177462	ANDALAS AGRO INDUSTRI, PT	-	-	SDLG	LG933L	606448	4.8	WARRANTY	RUNNING	-	KINALI	PEKANBARU	Commisoning Unit	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di kantor	Sugeng Santoso	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-04-18 11:49	2023-04-18 11:49	2023-04-18 11:56	2023-04-19 08:03	2023-04-18 11:56	2023-04-19 08:03	2023-04-24 19:03	2023-04-26 12:09	2023-05-02 11:28	1167.0	1214.0	151.0	YES
3613.0	ADMIN	BRANCH	April	1681795316207	WO23176895	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	889000	7250	NON WARRANTY	RUNNING	-	SANGA-SANGA	SAMARINDA	SERVICE 250 HRS VT055	ENGINE	OTHER	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-04-18 12:21	2023-04-18 12:22	2023-04-18 12:23	2023-04-18 15:13	2023-04-18 12:23	2023-04-18 15:13	2023-04-18 17:23	2023-04-18 22:52	2023-04-18 22:52	1167.0	171.0	5.0	YES
3614.0	ADMIN	BRANCH	April	1681796349660	WO23176789	ETEX BUILDING PERFORMANCE, INDONESIA, PT	-	-	VCE	L60F	7015	21881	NON WARRANTY	STANDBY	-	GRESIK	SURABAYA	Install Headlamp, Wiring Harness, Rocker Arm, and Hyd. Hose	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Muhammad Hatta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-04-18 12:39	2023-04-18 12:39	2023-04-18 12:44	2023-04-18 15:14	2023-04-18 12:45	2023-04-18 15:14	2023-04-18 18:12	2023-04-19 06:59	2023-04-27 11:51	1167.0	155.0	5.0	YES
3615.0	ADMIN	BRANCH	April	1681799812627	WO23177538	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606450	7	STOK	STANDBY	2023-04-18 00:00:00.0000000	Balikpapan	BALIKPAPAN	Pre Delivery Inspection LG933L SN606450	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	.	Fiqri Hamdani	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-04-18 13:36	2023-04-18 13:37	2023-04-18 13:41	2023-04-18 13:42	2023-04-18 13:41	2023-04-18 13:42	2023-04-18 14:50	2023-04-18 15:50	2023-04-18 15:50	1167.0	6.0	1.0	YES
3616.0	ADMIN	BRANCH	April	1681804716227	WO23177547	PANCARAN DARAT TRANSPORT, PT	-	-	VT	FM44064R	A837515	-	NON WARRANTY	STANDBY	2023-04-18 00:00:00.0000000	Banyuwangi	SURABAYA	Replace Additional Water Sparator	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Nur Riyanto	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-04-18 14:58	2023-04-18 14:58	2023-04-18 15:02	2023-04-19 16:15	2023-04-18 15:02	2023-04-19 16:15	2023-04-19 18:06	2023-04-20 08:28	2023-04-20 11:37	1167.0	1517.0	27.0	YES
3617.0	ADMIN	BRANCH	April	1681869509574	0	GETSHEMANI INDAH,PT.	-	-	VCE	EC210B	-	-	NON WARRANTY	BREAKDOWN	2023-04-19 00:00:00.0000000	By pass - MINUT	MANADO	Troubleshooting Engine ECU	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	yg dikerjakan hanya engine ECU, unitnya tdk ada di lokasi	Riandy Hamzah	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2023-04-19 08:58	2023-04-19 08:58	2023-04-19 09:54	2023-04-19 10:34	2023-04-19 12:48	2023-04-19 10:34	2023-04-19 13:31	2023-04-19 15:07	2023-04-19 15:09	1167.0	96.0	4.0	YES
3618.0	ADMIN	BRANCH	April	1681869675685	WO23177579	INDOTRUCK UTAMA, PT.	-	-	VCE	EC210D	252905	1	STOCK	STANDBY	-	W/S PEKANBARU	PEKANBARU	Storage Maintenance	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	kembali	INDRA MAHDI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-04-19 09:01	2023-04-19 09:01	2023-04-19 09:41	2023-04-19 09:42	2023-04-19 09:41	2023-04-19 09:42	2023-04-19 09:59	2023-04-19 10:00	2023-05-02 09:12	1166.0	41.0	0.0	YES
3619.0	ADMIN	BRANCH	April	1681871185108	WOSD177593	PUTRA RIMBA NUSANTARA, PT	-	-	SDLG	E680F	607211	1445	WARRANTY	BREAKDOWN	-	LAMPUNG	PEKANBARU	Replace hyd pump	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	pku	Sapto Adi Putra	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-04-19 09:26	2023-04-19 09:26	2023-04-19 09:49	2023-04-19 11:00	2023-04-19 09:49	2023-04-19 11:00	2023-05-26 17:46	2023-05-26 17:46	2023-05-29 10:24	1166.0	95.0	896.0	NO