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
6937.0	MECHANIC	MECHANIC	August	1691118245427	SD184779	RAKINDO UNITRUST MANDIRI, PT	-	-	SDLG	G9138	600578	1689	WARRANTY	RUNNING	2023-08-04 00:00:00.0000000	sungai gelam	JAMBI	replace seal kit	ETC	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	job completed	Teten Kurniyawan	Teten Kurniyawan	082266061369	tecikndlahom@gmail.com	2023-08-04 10:04	-	2023-08-04 10:04	2023-08-04 13:24	2023-08-04 10:04	2023-08-04 13:24	2023-08-04 19:38	2023-08-04 19:39	2023-08-04 19:39	1075.0	200.0	9.0	YES	-
6938.0	ADMIN	BRANCH	August	1691119164233	WO23184823	WIJAYA INTI SENTOSA, PT	-	-	VCE	EC200D	280020	1	NON WARRANTY	BREAKDOWN	2023-08-04 00:00:00.0000000	Dompu - NTB	SURABAYA	Troubleshoot Engine Overheat	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Andi Sunaryo	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-08-04 10:19	2023-08-04 10:19	2023-08-04 16:45	2023-08-05 11:14	2023-08-05 11:14	2023-08-05 11:14	2023-08-11 16:12	2023-08-15 08:08	2023-08-15 11:41	1075.0	1495.0	173.0	YES	0.0
6939.0	ADMIN	BRANCH	August	1691120742422	WO23184818	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606652	3	STOCK	RUNNING	-	W/S PEKANBARU	PEKANBARU	Arrival unit	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di kantor	Sugeng Santoso	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-08-04 10:45	2023-08-04 10:46	2023-08-04 10:53	2023-08-04 14:03	2023-08-04 10:53	2023-08-04 14:03	2023-08-04 16:08	2023-08-04 16:18	2023-08-08 14:44	1075.0	198.0	5.0	YES	0.0
6940.0	ADMIN	BRANCH	August	1691121035514	WO23184821	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG953	622300	2.2	STOCK	RUNNING	-	W/S PEKANBARU	PEKANBARU	Arrival unit	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di kantor	Sugeng Santoso	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-08-04 10:50	2023-08-04 10:51	2023-08-04 11:03	2023-08-04 14:38	2023-08-04 11:03	2023-08-04 14:38	2023-08-04 14:57	2023-08-04 15:04	2023-08-08 14:42	1075.0	228.0	4.0	YES	1.0
6941.0	ADMIN	BRANCH	August	1691121300618	23184404	BARA PRIMA PRATAMA, PT	-	-	VT	FMX44084R-I SHIFT	A895085	40801	WARRANTY	RUNNING	-	BATU AMPAR	JAMBI	REPLACE CONDENSER	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back	Mulyadi	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-08-04 10:55	2023-08-04 10:55	2023-08-04 13:25	2023-08-04 13:25	2023-08-04 13:25	2023-08-04 13:25	2023-08-04 14:54	-	2023-08-04 14:55	1075.0	151.0	4.0	YES	0.0
6942.0	MECHANIC	MECHANIC	August	1691125253263	23184819	BUANA PRIMA MULIA, PT	-	-	SDLG	LG953	622181	250	WARRANTY	RUNNING	2023-08-04 00:00:00.0000000	Tungkal	JAMBI	Ms 100 And 250 Hours	ETC	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	done	Ardiansyahnur	Ardiansyahnur	082353107865	ardiansyahnur2002@gmail.com	2023-08-04 12:00	2023-08-04 12:01	2023-08-04 12:01	2023-08-04 22:05	2023-08-04 12:01	2023-08-04 22:05	2023-08-04 22:06	2023-08-04 22:07	2023-08-04 22:07	1075.0	605.0	10.0	YES	0.0
6943.0	ADMIN	BRANCH	August	1691133501528	-	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898731	-	WARRANTY	RUNNING	-	BATUAH	SAMARINDA	REPLACE CABEL HARNES TRANSMISI	TRANSMISSION	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Tulus Setrio	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-08-04 14:18	2023-08-04 14:18	2023-08-04 14:19	2023-08-04 14:26	2023-08-04 14:19	2023-08-04 14:26	2023-08-08 16:59	2023-08-09 07:01	2023-08-09 07:02	1075.0	8.0	15.0	YES	0.0
6944.0	ADMIN	BRANCH	August	1691133734172	-	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40066R	899434	6000	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 2000HRS VT073	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-08-04 14:22	2023-08-04 14:22	2023-08-04 14:23	2023-08-04 14:46	2023-08-04 14:23	2023-08-04 14:46	2023-08-04 22:35	2023-08-05 05:40	2023-08-05 05:41	1075.0	24.0	8.0	YES	0.0
6945.0	ADMIN	BRANCH	August	1691134959269	WO23184377	BINTANG ALAM REJEKI, PT.	-	-	VCE	A40G	1000	1000	NON WARRANTY	RUNNING	-	BANTUAS	SAMARINDA	SERVICE 1000HRS	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Diky Maulana Tarmiji	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-08-04 14:42	2023-08-04 14:42	2023-08-04 14:43	2023-08-04 14:44	2023-08-04 14:43	2023-08-04 14:44	2023-08-04 18:08	2023-08-05 05:41	2023-08-05 05:42	1075.0	2.0	3.0	YES	0.0
6946.0	ADMIN	BRANCH	August	1691136560894	WO23184831	PALU JAYA PERKASA, PT	-	-	VCE	EC200D	250348	1579	WARRANTY	RUNNING	-	PANTAI BARAT	PALU	INSPECTION SEAL WATERPUMP & BELT EC200D SN 250348	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-08-04 15:09	2023-08-04 15:10	2023-08-04 15:10	2023-08-04 17:13	2023-08-04 15:10	2023-08-04 17:13	2023-08-04 20:20	2023-08-04 21:36	2023-08-05 09:32	1075.0	124.0	5.0	YES	1.0