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
4860.0	MECHANIC	MECHANIC	June	1685680028623	WO23177186	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40062T	888810	7750	WARRANTY	RUNNING	2023-06-02 00:00:00.0000000	sanga sanga	SAMARINDA	interval service	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	completed	Arif Sumardianto	Arif Sumardianto	081357952617	arifsumardianto2@gmail.com	2023-06-02 11:27	2023-06-02 11:27	2023-06-02 11:27	2023-06-02 14:27	2023-06-02 11:27	2023-06-02 14:27	2023-06-03 08:35	2023-06-04 07:54	2023-06-04 07:54	1122.0	181.0	21.0	YES	0.0
4861.0	ADMIN	BRANCH	June	1685690946755	WO23180410	INDOTRUCK UTAMA, PT.	-	-	VCE	EC210D	232109	8.4	STOK	STANDBY	2023-06-02 00:00:00.0000000	Balikpapan	BALIKPAPAN	Pre Delivery Inspect EC210D SN232109 HM8	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	.	Fiqri Hamdani	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-06-02 14:29	2023-06-02 14:29	2023-06-02 14:33	2023-06-02 14:34	2023-06-02 14:33	2023-06-02 14:34	2023-06-02 15:44	2023-06-02 15:50	2023-06-02 15:51	1122.0	5.0	1.0	YES	0.0
4862.0	ADMIN	BRANCH	June	1685691439211	WO23180416	INDOTRUCK UTAMA, PT.	-	-	VCE	EC200D	250347	13	STOCK	RUNNING	-	PALEMBANG	PALEMBANG	PDI UNIT	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	start job	Ponco Krisno Pratomo	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-02 14:37	2023-06-02 14:37	2023-06-02 14:38	2023-06-02 14:38	2023-06-02 14:38	2023-06-02 14:38	2023-06-02 15:25	2023-06-02 15:25	2023-06-02 15:25	1122.0	1.0	0.0	YES	0.0
4863.0	ADMIN	BRANCH	June	1685694076325	WOCE177604	SENTOSA LAJU SEJAHTERA, PT.	-	-	VCE	A60H	320405	2003	WARRANTY	BREAKDOWN	2023-04-19 00:00:00.0000000	Ampah, Kalimantan Tengah	MUARA TEWEH	Engine Failure	ENGINE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	UNIT RFU	Subiyanto	Muara Teweh Admin	81366256198	muarateweh.sbs@indotruck-utama.co.id	2023-06-02 15:21	2023-06-02 15:21	-	-	-	-	2023-06-05 11:26	2023-06-05 11:26	2023-06-05 11:27	1122.0	-	68.0	YES	0.0
4864.0	ADMIN	BRANCH	June	1685696316852	WO23180426	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG956F	625039	6.2	STOCK	RUNNING	-	PALEMBANG	PALEMBANG	PDI UNIT	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	start job	Dimas Adi Nugroho	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-02 15:58	2023-06-03 10:58	2023-06-03 10:59	2023-06-03 10:59	2023-06-03 10:59	2023-06-03 10:59	2023-06-03 12:23	2023-06-03 12:23	2023-06-03 12:24	1122.0	1141.0	20.0	YES	1139.0
4865.0	ADMIN	BRANCH	May	1685505888356	WO23179116	INDOTRUCK UTAMA, PT.	-	-	VCE	EC210D	232102	-	STOK	STANDBY	2023-05-31 00:00:00.0000000	Surabaya	SURABAYA	PDI, Loading Unit, and Unloading Unit to Port	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Muhammad Hatta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-05-31 11:04	2023-05-31 11:04	2023-05-31 11:08	2023-05-31 11:58	2023-05-31 11:08	2023-05-31 11:58	2023-06-01 08:05	2023-06-02 05:58	2023-06-02 09:14	1124.0	54.0	21.0	YES	0.0
4866.0	ADMIN	BRANCH	May	1685505948079	WOCE180050	JASA TAMBANG , CV.	-	-	VCE	EC210D	252815	760	WARRANTY	RUNNING	-	MEULABOH	MEDAN	Trouble Shooting Injektor and Water Pump UC210 D SN 252815	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	traveling	Joko Firman Nababan	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-05-31 11:05	2023-05-31 11:06	2023-06-02 10:57	2023-06-02 10:57	2023-06-11 09:32	2023-06-13 08:53	2023-06-13 09:09	2023-06-13 09:20	2023-06-13 09:21	1124.0	2872.0	310.0	YES	0.0
4867.0	ADMIN	BRANCH	May	1685515525113	WOCE178639	SAMUDERA MULIA ABADI, PT	-	-	VCE	A60H	320410	6291	WARRANTY	BREAKDOWN	-	WEDABAY	MANADO	Exhaust Manifold Crack	ECT	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Bagus Dwi Setyawan	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2023-05-31 13:45	2023-05-31 13:49	2023-05-31 13:50	2023-05-31 13:50	2023-05-31 13:50	2023-05-31 13:50	2023-05-31 13:51	2023-05-31 13:51	2023-05-31 13:52	1124.0	5.0	0.0	YES	4.0
4868.0	ADMIN	BRANCH	May	1685515680720	WO23180098	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG936L	607155	0	STOK	STANDBY	2023-05-31 00:00:00.0000000	Surabaya	SURABAYA	Maintenance Storage	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Andi Sunaryo	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-05-31 13:48	2023-05-31 13:48	-	2023-05-31 14:00	-	2023-05-31 14:00	-	2023-05-31 15:02	2023-06-02 09:17	1124.0	12.0	-	YES	0.0
4869.0	ADMIN	BRANCH	May	1685515862959	WO23180110	PAMA PERSADA NUSANTARA, PT	-	-	VCE	A40G	324759	9	WARRANTY	STANDBY	-	SITE KPC	SANGATTA	COMMISIONING UNIT VOLVO A40G SN.324759	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Sangatta Admin	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-05-31 13:51	2023-05-31 13:51	2023-05-31 13:56	2023-05-31 15:04	2023-05-31 13:56	2023-05-31 15:04	2023-05-31 16:29	2023-06-01 10:12	2023-06-01 10:12	1124.0	73.0	2.0	YES	0.0