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
4200.0	ADMIN	BRANCH	May	1683712786007	WOCE178704	HILLCONJAYA SAKTI, PT	-	-	VCE	EC300DL	272521	130	WARRANTY	RUNNING	2023-05-10 00:00:00.0000000	KOTABARU	BANJARMASIN	SWITCH NOT FUNCTION	ELECTRICAL	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	unit RFU ( tidak ada pergantian part ) repair	Mauldan Riansyah	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-05-10 16:59	2023-05-10 16:59	2023-05-16 14:49	2023-05-16 14:50	2023-05-16 14:49	2023-05-16 14:50	2023-06-26 16:05	2023-06-26 16:06	2023-06-26 16:06	1145.0	8510.0	1127.0	YES	0.0
4201.0	MECHANIC	MECHANIC	May	1683712839319	WOCE175887	INDOTRUCK UTAMA, PT.	-	-	VCE	EC200D	281373	10.3	STOK	RUNNING	2023-05-10 00:00:00.0000000	Yard Purwakarta	JAKARTA	Campaign W-ECU 4.1	ELECTRICAL	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Done back to office	Yusuf Rhama Dhani	Yusuf Rhama Dhani	082129756665	rhamay076@gmail.com	2023-05-10 17:00	2023-05-10 17:01	2023-05-10 17:01	2023-05-10 17:01	2023-05-10 17:01	2023-05-10 17:01	2023-05-10 17:02	2023-05-16 16:22	2023-05-16 16:24	1145.0	1.0	0.0	YES	0.0
4202.0	ADMIN	BRANCH	May	1683713009150	WO23178713	HASNUR RIUNG SINERGI, PT.	-	-	VCE	EC480DL	270981	17050	NON WARRANTY	RUNNING	2023-05-10 00:00:00.0000000	RANTAU	BANJARMASIN	MIP EC480DL	ETC	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	.	Rahmad	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-05-10 17:03	2023-05-10 17:03	2023-05-10 17:56	2023-05-10 17:56	2023-05-10 17:56	2023-05-10 17:56	2023-05-12 06:47	2023-05-17 11:06	2023-05-17 11:08	1145.0	53.0	37.0	YES	0.0
4203.0	MECHANIC	MECHANIC	May	1683716031311	23178707	HASNUR RIUNG SINERGI, PT.	-	-	VCE	EC480DL	274616	17205	NON WARRANTY	STANDBY	2023-05-10 00:00:00.0000000	Rantau	BANJARMASIN	MIP	ETC	INSPECTION	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	.	Rahmad	Rahmad	+628115031218	rahmadal889@gmail.com	2023-05-10 17:53	2023-05-10 17:55	2023-05-10 17:58	2023-05-10 17:55	2023-05-10 17:58	2023-05-10 17:59	2023-05-12 06:47	2023-05-17 11:05	2023-05-17 11:06	1145.0	2.0	36.0	YES	1.0
4204.0	ADMIN	BRANCH	May	1683768565130	WO23178662	INDOTRUCK UTAMA, PT.	-	-	SDLG	E690F	601042	5	STOCK	RUNNING	-	ITU PALU	PALU	ARIVAL INSPECTION E690F SN 601042	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-05-11 08:29	2023-05-11 08:29	2023-05-11 08:30	2023-05-11 08:34	2023-05-11 08:30	2023-05-11 08:34	2023-05-11 10:11	2023-05-11 10:12	2023-05-11 13:37	1145.0	5.0	1.0	YES	0.0
4205.0	ADMIN	BRANCH	May	1683769536075	WO23178733	MITRA HIJAU LESTARI, PT	-	-	SDLG	E6138F	606352	6.2	WARRANTY	RUNNING	-	PERAWANG	PEKANBARU	Commisioning unit	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	DARMO SUWITO	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-11 08:45	2023-05-11 08:45	2023-05-11 10:45	2023-05-11 15:45	2023-05-11 10:45	2023-05-11 15:45	2023-05-11 21:05	2023-05-11 22:21	2023-05-12 09:30	1145.0	420.0	12.0	YES	0.0
4206.0	ADMIN	BRANCH	May	1683773135710	WOCE178762	BUKIT INTAN MANUNGGAL, PT	-	-	VCE	L120GZ	672371	765	WARRANTY	BREAKDOWN	-	MUARA TEWEH, KALIMANTAN TENGAH	MUARA TEWEH	AC HOT	ENGINE	OTHER	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	RFU	Catur Laksono	Muara Teweh Admin	81366256198	muarateweh.sbs@indotruck-utama.co.id	2023-05-11 09:45	2023-05-11 09:45	-	-	-	-	-	-	2023-05-15 07:22	1144.0	-	-	YES	0.0
4207.0	ADMIN	BRANCH	May	1683773137641	WO23178746	SEJATI ABADI PERKASA, PT	-	-	SDLG	LG9138L	600619	105	WARRANTY	RUNNING	2023-05-11 00:00:00.0000000	Bengkulu tengah	BENGKULU	service 100	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Agus Nugroho	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-05-11 09:45	2023-05-11 09:46	2023-05-11 09:53	2023-05-11 14:24	2023-05-11 09:53	2023-05-11 14:24	2023-05-11 15:58	2023-05-11 16:34	2023-05-11 16:34	1144.0	279.0	6.0	YES	0.0
4208.0	ADMIN	BRANCH	May	1683778422990	WOCE175877	INDOTRUCK UTAMA, PT.	-	-	VCE	EC200D	281372	3	STOCK	STANDBY	-	PURWAKARTA YARD	JAKARTA	CAMPAIGN INSTALL WECU 4.1	ELECTRICAL	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	complet	Aa Sugiono	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-11 11:13	2023-05-11 11:14	2023-05-11 11:14	2023-05-11 12:37	2023-05-11 11:14	2023-05-11 12:37	-	-	2023-05-15 11:30	1144.0	83.0	-	YES	0.0
4209.0	ADMIN	MECHANIC	May	1683797065637	WO23178791	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG953	622185	-	STOK	STANDBY	2023-05-11 00:00:00.0000000	Surabaya	SURABAYA	PDI and Loading Unit	ETC	INSPECTION	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job done	Dwi Setiawan	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-05-11 16:24	2023-05-11 16:24	2023-05-11 16:27	2023-05-11 16:35	2023-05-11 16:27	2023-05-11 16:35	2023-05-12 09:39	2023-05-15 11:07	2023-05-15 11:23	1144.0	11.0	17.0	YES	0.0