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
1920.0	BRANCH	BRANCH	February	1677030351202	23173316	TUMINGANTO	-	-	SDLG	E660FL	625812	1	WARRANTY	RUNNING	2023-02-21 00:00:00.0000000	KUJAN BULIK	BANJARMASIN	COMMISSIONING UNIT E660FL SN625812	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	.	Muksim Triharyadi	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-02-22 08:45	2023-02-22 08:46	2023-03-07 10:49	2023-03-07 10:50	2023-03-07 10:49	2023-03-07 10:50	2023-03-07 10:50	2023-03-07 10:50	2023-03-07 10:51	1223.0	18844.0	314.0	YES	0.0
1921.0	ADMIN	BRANCH	February	1677030594930	23173359	ALAM RIMBA INDAH, PT.	-	-	SDLG	G9138	600285	9320	NON WARRANTY	RUNNING	-	TANJABTIM	JAMBI	TROUBLE SHOOTING ELECTRICAL	ELECTRICAL	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job completed	Eko Febri Hariyadi	Karlina Aulia Fitri JMB ADMIN	081366256191	serviceadmin.jambi@indotruck-utama.co.id	2023-02-22 08:49	2023-02-22 08:50	2023-02-22 09:07	2023-02-22 09:10	2023-02-22 09:09	2023-02-22 09:10	2023-02-22 09:17	2023-02-22 09:17	2023-02-22 09:18	1223.0	21.0	0.0	YES	0.0
1922.0	BRANCH	BRANCH	February	1677030596972	WO23174359	MANADO KARYA ANUGRAH, PT.	-	-	VCE	L120F	26697	-	WARRANTY	BREAKDOWN	-	TOKATINDUNG	MANADO	Inspection Engine Problem	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	ok	Febryanto Ishak Aihua	jeanet.kauwo	081527884719	jeanet.kauwo@indotruck-utama.co.id	2023-02-22 08:49	2023-02-22 08:50	2023-02-22 08:51	2023-02-22 11:09	2023-02-28 08:36	2023-03-08 08:24	2023-03-08 08:26	-	2023-03-08 08:28	1223.0	139.0	7.0	YES	0.0
1923.0	BRANCH	BRANCH	February	1677035359158	WO23173438	TAPALOSA CIPTA SARANA, PT	-	-	SDLG	LG933L	606309	130	WARRANTY	RUNNING	-	BARUGA	KENDARI	Service 100 first	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	back to office	Arfandi yahya	Sri Masriana	081342985588	sri.suyuti@indotruck-utama.co.id	2023-02-22 10:09	2023-02-22 10:09	2023-02-22 10:10	2023-02-22 10:14	2023-02-22 10:10	2023-02-22 10:14	2023-02-22 13:24	2023-02-22 14:05	2023-02-22 14:06	1222.0	6.0	3.0	YES	0.0
1924.0	MECHANIC	MECHANIC	February	1677036453839	23173424	UMY SOLEHA	-	-	SDLG	LG933L	606469	99	WARRANTY	RUNNING	2023-02-22 00:00:00.0000000	Banjar agung	LAMPUNG	MS.service 100h	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	job completed	Heri Sucipto	Heri Sucipto	081373645025	herisucipto135@gmail.com	2023-02-22 10:27	2023-02-22 10:28	2023-02-22 10:29	2023-02-22 13:13	2023-02-22 10:29	2023-02-22 13:13	2023-02-22 15:09	2023-02-22 19:37	2023-03-02 15:55	1222.0	166.0	4.0	YES	0.0
1925.0	BRANCH	BRANCH	February	1677056820971	WO23173768	TITIAN TRANS ENERGY, PT	-	-	VCE	A40G	-	-	NON WARRANTY	RUNNING	2023-02-22 00:00:00.0000000	Tabang	SAMARINDA	hydraulic leak inspect hydraulic leak	ETC	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ardani	Erni Wati	082353253757	admin.service.smd@indotruck-utama.co.id	2023-02-22 16:07	2023-02-22 16:07	2023-02-22 16:07	2023-02-23 11:18	2023-02-23 08:56	2023-02-23 11:18	-	-	2023-02-25 18:33	1222.0	1151.0	-	YES	0.0
1926.0	ADMIN	BRANCH	February	1677064006139	WO23173489	AKR TRANSPORTASI INDONESIA, PT	-	-	VT	FMX44084R	YV2XM30D4GB778443	547888	NON WARRANTY	RUNNING	2023-02-22 00:00:00.0000000	Semarang	SEMARANG	YV2XM30D4GB778443 WO23173489 T/S TRANSMISSION SYSTEM B 9735 BEI VT AKR TRANSPORTASI INDONESIA, PT 0038 ITU-000005912 SRWE Created Triyono Smg 2/22/20	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	9	Andri Kurniawan	Muchammad Rivkhi Indiarta	083838871090	rivkhi.indiarta@indotruck-utama.co.id	2023-02-22 18:06	2023-02-22 18:06	2023-02-22 18:07	2023-02-22 18:07	2023-02-22 18:07	2023-02-22 18:07	2023-02-28 15:50	2023-02-28 15:50	2023-02-28 15:50	1222.0	1.0	141.0	YES	0.0
1927.0	ADMIN	BRANCH	February	1677064125160	WO23173497	BERDIKARI PUTRA PERKASA, PT.	-	-	VCE	EC210D	280099	3466	NON WARRANTY	RUNNING	2023-02-22 00:00:00.0000000	semarang	SEMARANG	280099 WO23173497 T/S ENGINE OVER HEATING EC 210 D VCE BERDIKARI PUTRA PERKASA, PT. 2252 ITU-000007781 SRWE Created Triyono Smg 2/22/2023 10.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	9	Ahmad Saimin	Muchammad Rivkhi Indiarta	083838871090	rivkhi.indiarta@indotruck-utama.co.id	2023-02-22 18:08	2023-02-22 18:08	2023-02-22 18:09	2023-02-22 18:09	2023-02-22 18:09	2023-02-22 18:09	2023-02-28 15:50	2023-02-28 15:51	2023-02-28 15:51	1222.0	1.0	141.0	YES	0.0
1928.0	ADMIN	BRANCH	February	1677064323815	WO23173500	JAPFA COMFEED INDONESIA TBK, PT	-	-	SDLG	L958L	VLG0958LEE9009434	5678	NON WARRANTY	RUNNING	2023-02-22 00:00:00.0000000	SRAGEN	SEMARANG	VLG0958LEE9009434 WO23173500 General Inspection Engine SDLG Japfa Comfeed Indonesia PT. 0549 ITU-000002802 SRWE Created Triyono Smg 2/22/2023 10.00	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	9	Ahmad Saimin	Muchammad Rivkhi Indiarta	083838871090	rivkhi.indiarta@indotruck-utama.co.id	2023-02-22 18:12	2023-02-22 18:12	2023-02-22 18:12	2023-02-22 18:12	2023-02-22 18:12	2023-02-22 18:12	2023-02-28 15:51	2023-02-28 15:51	2023-02-28 15:51	1222.0	1.0	141.0	YES	0.0
1929.0	MECHANIC	MECHANIC	February	1677108824391	000373	BUKIT ASAM ( Persero ) TBK., PT	-	-	VCE	EC480DL	275446	20648.2	NON WARRANTY	STANDBY	2023-02-23 00:00:00.0000000	Pit 2 Bangko Barat	MUARA ENIM	Instal part baclog	ELECTRICAL	REPAIR	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	• Replace New Cable + Bateray 1 Pcs • Replace New Cable - Bateray 1 pcs • Replace New Cable Seri 1 pcs • Replace New Venting • Replace New Latch	Bagus Kuncoro	Bagus Kuncoro	082176654390	bagusargg@gmail.com	2023-02-23 06:33	-	-	-	-	-	-	-	2023-02-23 06:35	1222.0	-	-	NO	-