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
3000.0	ADMIN	BRANCH	March	1679973640281	WO23175780	EKO SISWANTO	-	-	VCE	EC210D	VCEC210DE00253394	995	WARRANTY	RUNNING	-	KUDUS	SEMARANG	VCEC210DE00253394 WO23175780 MANDATORY SERVICES 1000 H VCE EKO SISWANTO. 4626 ITU-000017389 SRWI-SVC Created Triyono Smg 3/29/2023 11.00	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-03-28 10:20	2023-03-28 10:20	2023-03-28 10:21	2023-03-28 10:21	2023-03-28 10:21	2023-03-28 10:21	2023-03-29 13:46	2023-03-29 13:46	2023-03-29 13:46	1188.0	1.0	27.0	YES	0.0
3001.0	MECHANIC	MECHANIC	March	1679986497390	WO23174738	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898742	4250	WARRANTY	RUNNING	2023-03-28 00:00:00.0000000	batuah	SAMARINDA	VT63 PS250H	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	done	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-03-28 13:54	2023-03-28 13:57	2023-03-28 13:57	2023-03-28 17:29	2023-03-28 13:57	2023-03-28 17:29	2023-03-29 06:21	2023-03-29 06:21	2023-03-29 06:22	1188.0	215.0	16.0	YES	2.0
3002.0	ADMIN	BRANCH	March	1679993730971	WO23175814	MUDA BERJAYA BEUTARI, CV	-	-	SDLG	E6210F	609400	629	WARRANTY	RUNNING	-	PANTE CEURMEN, MEULABOH	MEDAN	MANDATORY SERVICE 500 HOURS UNIT E6210F	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Finish	Joko Firman Nababan	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-03-28 15:55	2023-03-28 15:55	2023-03-29 14:11	2023-03-29 20:15	2023-03-29 14:11	2023-03-29 20:15	2023-03-31 21:25	-	2023-04-11 10:55	1188.0	1700.0	77.0	YES	0.0
3003.0	ADMIN	BRANCH	March	1679993926305	WO23175839	RODATEKNINDO PURAJAYA, PT	-	-	VCE	SD110B	552049	5235	NON WARRANTY	RUNNING	2023-03-28 00:00:00.0000000	Bengkulu	BENGKULU	Troubleshooting vibration	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Agus Nugroho	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-03-28 15:58	2023-03-28 15:58	2023-03-29 09:28	2023-03-29 10:36	2023-03-29 09:28	2023-03-29 10:36	2023-03-29 14:04	2023-03-29 19:37	2023-03-29 19:37	1188.0	1118.0	22.0	YES	0.0
3004.0	ADMIN	BRANCH	March	1679994358068	WO23175807	LANGKAT MAKMUR SAWIT SEJATI, PT	-	-	SDLG	L956L	624727	503	WARRANTY	RUNNING	-	PADANG TUALANG - LANGKAT	MEDAN	MANDATORY SERVICE 500 HOURS UNIT L956F	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Didik Choiril	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-03-28 16:05	2023-03-28 16:06	2023-03-29 09:24	2023-03-29 13:15	2023-03-29 09:24	2023-03-29 13:15	2023-03-29 17:51	2023-03-29 19:29	2023-03-30 14:11	1188.0	1270.0	25.0	YES	0.0
3005.0	ADMIN	BRANCH	March	1680052651439	WO23175858	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606443	4	WARRANTY	RUNNING	2023-03-29 00:00:00.0000000	Makassar	MAKASSAR	Arrival Inspection Program	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Marcel Kelvin	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-03-29 08:17	2023-03-29 08:17	2023-03-29 08:20	2023-03-29 08:20	2023-03-29 08:20	2023-03-29 08:20	2023-03-29 12:15	2023-03-29 12:17	2023-03-29 12:36	1188.0	3.0	3.0	YES	0.0
3006.0	MECHANIC	MECHANIC	March	1680060039080	WO23171374	PIONIRBETON INDUSTRI, PT	-	-	SDLG	LG958F	620072	13514	NON WARRANTY	RUNNING	2023-03-29 00:00:00.0000000	serpong banten	JAKARTA	service 500 hrs wl7A	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampe	Ismail Fauzi	Ismail Fauzi	082213141199	fauziismail26@gmail.com	2023-03-29 10:20	2023-03-29 10:21	2023-03-29 10:21	2023-03-29 13:05	2023-03-29 10:21	2023-03-29 13:05	2023-03-29 16:01	2023-03-29 18:00	2023-04-07 08:12	1187.0	165.0	5.0	YES	0.0
3007.0	ADMIN	BRANCH	March	1680060769224	WO23175697	DERMAGA SUKSES MANDIRI, PT.	-	-	SDLG	L956F	624046	2062	NON WARRANTY	RUNNING	2023-03-29 00:00:00.0000000	Belawan	MEDAN	Maintenance Service 2000 Hours	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	BTO	Andrianto	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-03-29 10:32	2023-03-29 10:32	2023-03-29 17:34	-	2023-03-29 17:34	-	2023-03-29 17:35	2023-03-29 17:39	2023-03-29 17:40	1187.0	-	7.0	YES	0.0
3008.0	ADMIN	BRANCH	March	1680078318706	WO23175901	I NYOMAN WETAN ADI PUTRA	-	-	SDLG	LG953	622004	296	WARRANTY	RUNNING	2023-03-29 00:00:00.0000000	Kuta Selatan	SURABAYA	Service 250 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Muhammad Hatta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-03-29 15:25	2023-03-29 15:25	2023-03-29 17:10	2023-03-30 08:19	2023-03-29 17:10	2023-03-30 08:19	2023-03-31 08:58	2023-03-31 19:39	2023-04-18 08:10	1187.0	1014.0	41.0	YES	0.0
3009.0	ADMIN	BRANCH	March	1680080254064	23175857	BARA PRIMA PRATAMA, PT	-	-	VT	FMX44084R-I SHIFT	A319125	1191.8	WARRANTY	RUNNING	-	BATU AMPAR	JAMBI	COMMISSIONING	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Noval Qomaruzzaman Rasyid	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-03-29 15:57	2023-03-29 15:57	2023-03-29 16:03	2023-03-29 16:04	2023-03-29 16:03	2023-03-29 16:04	2023-03-29 20:52	2023-03-29 20:53	2023-03-29 20:53	1187.0	7.0	4.0	YES	0.0