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
4660.0	ADMIN	BRANCH	May	1684922222668	WO23179685	ASRINDO CITRASENI SATRIA, PT	-	-	VT	FMX44066T	A779653	25790	NON WARRANTY	RUNNING	-	DURI	PEKANBARU	Electrical and air system problem	BRAKE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	NOVI HENDRA	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-24 16:57	2023-05-24 16:57	2023-05-25 08:03	2023-05-25 09:43	2023-05-25 08:03	2023-05-25 09:43	2023-05-25 18:03	2023-05-25 20:03	2023-05-26 14:45	1131.0	1006.0	25.0	YES	0.0
4661.0	ADMIN	BRANCH	May	1684979032688	WO23179514	TERMINAL PETIKEMAS SURABAYA, PT	-	-	VT	FM40084R	A883276	8189	WARRANTY	STANDBY	2023-05-25 00:00:00.0000000	Surabaya	SURABAYA	Warranty Selenoid Valve	ETC	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Nur Riyanto	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-05-25 08:43	2023-05-25 08:44	2023-05-25 10:29	2023-05-25 11:43	2023-05-25 10:29	2023-05-25 11:43	2023-05-25 15:54	2023-05-25 16:38	2023-05-25 16:51	1131.0	179.0	7.0	YES	0.0
4662.0	ADMIN	BRANCH	May	1684980226461	WO23179706	ARKAN JAYA SENTOSA CV	-	-	SDLG	E660FL	625750	254	WARRANTY	RUNNING	2023-05-25 00:00:00.0000000	Suoh	LAMPUNG	MS, serv 250h	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Pekerjaan selesai	Heri Sucipto	Lampung Admin	81366256194	lampung.sbs@indotruck-utama.co.id	2023-05-25 09:03	2023-05-25 09:04	2023-05-25 09:04	2023-05-25 10:37	2023-05-25 09:04	2023-05-25 10:37	2023-05-25 17:18	2023-05-25 20:14	2023-05-30 19:31	1130.0	93.0	8.0	YES	0.0
4663.0	ADMIN	BRANCH	May	1684982934778	23179713	BARA PRIMA PRATAMA, PT	-	-	VT	FMX44084R-I SHIFT	A301990	28562.6	WARRANTY	RUNNING	-	SELENSEN	JAMBI	REPLACE PASS THROUGH	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	DT 102 RFU 2915 H 28562.6 KM	Ari subarkah	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-05-25 09:48	2023-05-25 09:49	2023-05-25 14:57	2023-05-25 15:02	2023-05-25 14:57	2023-05-25 15:02	-	-	2023-05-25 16:46	1130.0	314.0	-	YES	0.0
4664.0	ADMIN	BRANCH	May	1684984573134	WO23179944	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	312383	1750	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 750 HRS VT093	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-25 10:16	2023-05-25 10:16	2023-05-25 10:17	2023-05-25 11:50	2023-05-25 10:17	2023-05-25 11:50	2023-05-25 21:02	2023-05-25 22:34	2023-05-25 22:35	1130.0	94.0	10.0	YES	0.0
4665.0	ADMIN	BRANCH	May	1684990673157	WO23179736	MULTI TERMINAL INDONESIA, PT	-	-	VT	FM37064T	B701593	-	NON WARRANTY	BREAKDOWN	-	TJ. PRIOK - JAKARTA	JAKARTA	Replace ESCL B 9314 UIW at Tj. Priok	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Eko Suharyanto	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-25 11:57	2023-05-25 11:58	2023-05-26 14:25	2023-05-26 14:26	2023-05-26 14:25	2023-05-26 14:26	2023-05-26 17:00	2023-05-26 17:22	2023-05-26 17:23	1130.0	1588.0	29.0	YES	0.0
4666.0	MECHANIC	MECHANIC	May	1684994832356	0	JHONLIN BARATAMA, PT	-	-	VCE	R60D	111094	84.3	WARRANTY	RUNNING	2023-05-25 00:00:00.0000000	Serongga	BANJARMASIN	brake problem	ELECTRICAL	REPAIR	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	completed	Ridwan Wahyu	Ridwan Wahyu	082256295575	wahyuridwan150@gmail.com	2023-05-25 13:07	2023-05-25 13:07	2023-05-25 13:07	2023-05-25 13:07	2023-05-25 13:07	2023-05-25 13:07	2023-05-25 13:10	2023-05-25 13:10	2023-05-25 13:11	1130.0	1.0	0.0	YES	0.0
4667.0	ADMIN	BRANCH	May	1685001514944	WO23179746	MULTI TERMINAL INDONESIA, PT	-	-	VT	FM37064T	B701509	133331	NON WARRANTY	BREAKDOWN	-	TJ. PRIOK - JAKARTA	JAKARTA	Repair as QO-230014054	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor 17.00	Mochamad Aniqun Umar Farauq	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-25 14:58	2023-05-25 14:58	2023-06-06 15:28	2023-06-06 15:29	2023-06-19 11:28	2023-06-19 11:29	2023-06-19 17:02	2023-06-19 17:02	2023-06-21 09:52	1130.0	17310.0	289.0	YES	0.0
4668.0	MECHANIC	MECHANIC	May	1685010819749	-	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	312383	1750	WARRANTY	RUNNING	2023-05-25 00:00:00.0000000	batuah	SAMARINDA	VT93 ps250h	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-05-25 17:33	2023-05-25 17:40	2023-05-25 17:40	2023-05-25 17:41	2023-05-25 17:40	2023-05-25 17:41	2023-05-25 18:40	2023-05-25 19:45	2023-05-25 19:46	1130.0	7.0	1.0	YES	6.0
4669.0	ADMIN	BRANCH	May	1685065866257	WOCE179779	INDOTRUCK UTAMA, PT.	-	-	VCE	A60H	320611	1	STOCK	STANDBY	-	PURWAKARTA YARD	JAKARTA	CAMPAIGN HMQ-51 VCB VALVE	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job finish	Aa Sugiono	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-26 08:51	2023-05-26 08:55	2023-05-26 09:25	2023-05-26 12:32	2023-05-26 09:25	2023-05-26 12:32	2023-05-26 16:22	2023-05-26 18:05	2023-05-26 18:05	1130.0	221.0	7.0	YES	4.0