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
2070.0	BRANCH	BRANCH	February	1677559144014	WO23173502	INDOTRUCK UTAMA, PT.	-	-	VCE	EW205	281273	3	WARRANTY	RUNNING	2023-02-28 00:00:00.0000000	Workshop ITU Medan	MEDAN	Arrival Inspection	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Joko Firman Nababan	Annisa Shaila Ambar Wulan	081361470025	shailadithia@gmail.com	2023-02-28 11:39	2023-02-28 11:39	2023-03-03 08:11	2023-03-06 08:46	2023-03-03 08:11	2023-03-06 08:46	2023-03-07 08:19	2023-03-07 15:36	2023-03-07 15:36	1216.0	8467.0	164.0	YES
2071.0	ADMIN	BRANCH	February	1677569243563	WO23173793	BARADINAMIKA MUDASUKSES, PT.	-	-	VCE	L220H	12286	3880	NON WARRANTY	RUNNING	-	LOREH - MALINAU	TARAKAN	INSTALL LINK ARM	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job complete reporting	AMIRUDDIN	Salmiah ADMIN Tarakan	085251084008	salmiah.itu@indotruck-utama.co.id	2023-02-28 14:27	2023-02-28 14:27	2023-02-28 14:32	2023-02-28 16:47	2023-02-28 14:32	2023-02-28 16:47	2023-03-01 15:23	2023-03-01 17:36	2023-03-01 19:15	1216.0	140.0	24.0	YES
2072.0	ADMIN	BRANCH	February	1677570420885	WO23173803	MUSTARING	-	-	SDLG	E660FL	625728	7	WARRANTY	RUNNING	2023-02-28 00:00:00.0000000	SEBATIK	TARAKAN	COMMISIONING UNIT	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job finish Reporting	Christian Oktavianto	Salmiah ADMIN Tarakan	085251084008	salmiah.itu@indotruck-utama.co.id	2023-02-28 14:47	2023-02-28 14:47	2023-02-28 14:51	-	2023-02-28 15:10	-	2023-03-01 19:47	2023-03-01 20:49	2023-03-02 07:22	1216.0	-	28.0	YES
2073.0	ADMIN	BRANCH	February	1677575095853	WO23173651	ARIS WIDODO	-	-	VCE	EC210B	WO23173651	3457	NON WARRANTY	RUNNING	2023-02-28 00:00:00.0000000	Jogja	SEMARANG	WO23173651 REPLACE HIGH PRESSURE PUMP EC210B OTH ARIS WIDODO 4622 ITU-000008861 SRWI-SVC Created Triyono Smg 2/27/2023 5.00	ENGINE	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	WO23173651 REPLACE HIGH PRESSURE PUMP EC210B OTH ARIS WIDODO 4622 ITU-000008861 SRWI-SVC Created Triyono Smg 2/27/2023 5.00	Muchammad Rivkhi Indiarta	Muchammad Rivkhi Indiarta	083838871090	rivkhi.indiarta@indotruck-utama.co.id	2023-02-28 16:04	2023-02-28 16:05	2023-02-28 16:05	2023-02-28 16:05	2023-02-28 16:05	2023-02-28 16:05	2023-02-28 16:06	2023-02-28 16:06	2023-02-28 16:06	1216.0	1.0	0.0	YES
2074.0	BRANCH	BRANCH	February	1677579459505	173801	ETHAN GROUP CV	-	-	VCE	EC200D	281155	680	WARRANTY	BREAKDOWN	2023-02-28 00:00:00.0000000	KUJAN BULIK	BANJARMASIN	ENGINE CANT START	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	.	Muksim Triharyadi	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-02-28 17:17	2023-02-28 17:17	2023-03-07 10:42	2023-03-07 10:42	2023-03-07 10:42	2023-03-07 10:42	2023-03-07 10:42	2023-03-07 10:42	2023-03-07 10:43	1216.0	9685.0	161.0	YES
2075.0	ADMIN	BRANCH	February	1677581390337	WO23173836	TIBER JAYA MANDIRI, PT	-	-	SDLG	G9138	600604	48	WARRANTY	RUNNING	2023-02-28 00:00:00.0000000	JUATA	TARAKAN	SERVICE 50 HRS	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Finish Reporting	Isak	Salmiah ADMIN Tarakan	085251084008	salmiah.itu@indotruck-utama.co.id	2023-02-28 17:49	2023-02-28 17:50	2023-02-28 17:53	2023-02-28 18:09	2023-02-28 17:53	2023-02-28 18:09	2023-02-28 18:40	2023-02-28 19:00	2023-02-28 21:42	1216.0	20.0	0.0	YES
2076.0	BRANCH	BRANCH	March	1677634805379	WO23173903	RAKA NAVARA, PT	-	-	VCE	EC210D	252809	1058.2	WARRANTY	RUNNING	-	KOLAKA UTARA	KENDARI	troubleshooting AC Hot	ELECTRICAL	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Debysantoso	Sri Masriana	081342985588	sri.suyuti@indotruck-utama.co.id	2023-03-01 08:40	2023-03-01 08:40	2023-03-01 08:44	2023-03-02 10:00	2023-03-01 08:44	2023-03-02 10:00	2023-03-04 07:23	2023-03-05 05:35	2023-03-05 07:41	1216.0	1520.0	70.0	YES
2077.0	BRANCH	BRANCH	February	1677462876335	WO23173681	JAGAAMAN SARANA, PT	-	-	VCE	EC350DL	271228	970	WARRANTY	RUNNING	-	WATURAMBAHA	KENDARI	service 1000 first	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Debysantoso	Sri Masriana	081342985588	sri.suyuti@indotruck-utama.co.id	2023-02-27 08:54	2023-02-27 08:54	-	2023-02-27 12:10	-	2023-02-27 12:10	2023-02-27 14:43	2023-03-01 08:44	2023-03-01 08:49	1218.0	196.0	5.0	YES
2078.0	ADMIN	BRANCH	February	1677477913926	WO23173625	PALU JAYA PERKASA, PT	-	-	VCE	EC200D	250348	499	WARRANTY	RUNNING	-	PANTAI BARAT	PALU	Free service 500 HM	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di branch office palu	Ahmad Jafar M	Lucky Yotari Admin Palu	081298128289	lucky.yotari@indotruck-utama.co.id	2023-02-27 13:05	2023-02-27 13:05	2023-02-27 13:09	2023-02-27 14:27	2023-02-27 13:09	2023-02-27 14:27	2023-02-27 15:16	2023-02-27 15:40	2023-02-27 15:41	1217.0	82.0	2.0	YES
2079.0	BRANCH	BRANCH	February	1677491032716	23172548	DERMAGA SUKSES MANDIRI, PT.	-	-	SDLG	L956F	624044	2919	NON WARRANTY	RUNNING	2023-02-27 00:00:00.0000000	Medan	MEDAN	Maintenance Service	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	finish	Andrianto	Annisa Shaila Ambar Wulan	081361470025	shailadithia@gmail.com	2023-02-27 16:43	2023-02-27 16:44	2023-02-28 11:51	2023-02-28 14:41	2023-02-28 11:51	2023-02-28 14:41	2023-02-28 17:33	2023-03-01 00:50	2023-03-01 15:15	1217.0	1318.0	24.0	NO