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
6650.0	ADMIN	BRANCH	July	1690507827851	WO23184215	MITRA HIJAU LESTARI, PT	-	-	SDLG	E680F	607266	375	WARRANTY	RUNNING	-	BUTON	PEKANBARU	Service 250 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	TRISKI ADRIAN	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-07-28 08:30	2023-07-28 08:30	2023-07-28 08:53	2023-07-28 14:33	2023-07-28 08:53	2023-07-28 14:33	2023-07-28 17:14	2023-07-28 21:09	2023-08-02 10:42	1067.0	363.0	8.0	YES	0.0
6651.0	ADMIN	BRANCH	July	1690507895712	WO23184216	EKO SISWANTO	-	-	VCE	EC210D	VCEC210DE00253394	2000	WARRANTY	RUNNING	-	KUDUS	SEMARANG	VCEC210DE00253394 WO23184216 MANDATORY SERVICES 2000 H VCE EKO SISWANTO. 4626 ITU-000017389 SRWE Created Triyono Smg 7/28/2023 20.00	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-07-28 08:31	2023-07-28 08:31	2023-07-28 08:31	2023-07-28 08:32	2023-07-28 08:31	2023-07-28 08:32	2023-07-31 08:27	2023-07-31 08:28	2023-07-31 08:28	1067.0	0.0	71.0	YES	0.0
6652.0	ADMIN	BRANCH	July	1690508986457	WO23184212	ARIEF NURALYM SUYATNO	-	-	SDLG	E660FL	622792	750	WARRANTY	STANDBY	2023-07-28 00:00:00.0000000	Sorong	SORONG	Mandatory Service 750 Hours	ETC	OTHER	-	-	-	-	LEADER	COMPLETED	COMPLETED	Job Done	Service koordinator (Sorong - Nusa tenggara)	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-07-28 08:49	2023-07-28 08:50	2023-07-29 11:29	2023-07-29 11:29	2023-07-29 11:29	2023-07-29 11:29	2023-07-29 12:33	2023-07-31 06:38	2023-07-31 06:41	1067.0	1600.0	27.0	YES	0.0
6653.0	ADMIN	BRANCH	July	1690528673722	WO 23184244	INDOTRUCK UTAMA, PT.	-	-	SDLG	E660FL	625926	8	STOCK	RUNNING	-	PALU	PALU	ARIVAL INSPECTION E660FL SN 625926	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Alfraldo	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-07-28 14:17	2023-07-28 14:21	2023-07-28 14:22	2023-07-28 14:29	2023-07-28 14:22	2023-07-28 14:29	2023-07-28 15:53	2023-07-28 15:53	2023-07-28 21:09	1066.0	12.0	1.0	YES	3.0
6654.0	ADMIN	BRANCH	July	1690529223781	WO23184266	I WAYAN SUTAYASA	-	-	SDLG	E660FL	625926	8	WARRANTY	RUNNING	-	SAUSU	PALU	COMMISIONING E660FL SN625926	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-07-28 14:27	2023-07-28 14:27	2023-07-28 14:27	2023-07-28 15:57	2023-07-28 14:27	2023-07-28 15:57	2023-07-28 18:34	2023-07-28 20:47	2023-07-28 21:01	1066.0	90.0	4.0	YES	0.0
6655.0	MECHANIC	MECHANIC	July	1690533679494	0	SENTOSA LAJU SEJAHTERA, PT.	-	-	VCE	EC480DL	284429	-	WARRANTY	RUNNING	2023-07-25 00:00:00.0000000	Kuala Kurun	BANJARMASIN	Leak oil hyd	ETC	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	RFU	Ahmad Ridwansyah	Ahmad Ridwansyah	081278001393	ahmadridwansyah96@gmail.com	2023-07-28 15:41	2023-07-28 15:44	2023-07-28 15:45	2023-07-28 15:45	2023-07-28 15:45	2023-07-28 15:45	2023-07-28 15:45	2023-07-28 15:45	2023-07-28 15:46	1066.0	4.0	0.0	YES	3.0
6656.0	ADMIN	BRANCH	July	1690535218954	WO23184273	SUMI GITA JAYA PT	-	-	VCE	EC210D	231929	499	WARRANTY	RUNNING	-	DURI	PEKANBARU	Service 500 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	HARIANTO OK	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-07-28 16:06	2023-07-28 16:07	2023-07-29 08:49	2023-07-29 11:03	2023-07-29 08:49	2023-07-29 11:03	2023-07-30 13:32	2023-07-30 16:55	2023-08-02 10:47	1066.0	1137.0	45.0	YES	0.0
6657.0	ADMIN	BRANCH	July	1690535630502	WOCE184283	SUMI GITA JAYA PT	-	-	VCE	EC210D	252902	1029	WARRANTY	BREAKDOWN	-	DURI	PEKANBARU	Waterpump leak	ENGINE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	TRISKI ADRIAN	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-07-28 16:13	2023-07-28 16:14	2023-07-29 08:53	2023-07-29 10:54	2023-07-29 08:53	2023-07-29 10:54	2023-07-30 16:28	2023-08-02 11:26	2023-08-02 11:48	1066.0	1120.0	48.0	YES	0.0
6658.0	BRANCH	BRANCH	July	1690601728332	WO23184302	PERDASA, PT	-	-	VCE	EC210B	76577	0	NON WARRANTY	BREAKDOWN	2023-07-29 00:00:00.0000000	Lenggok	BERAU	Repair Engine	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	unit ready job done	Ferdy	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-07-29 10:35	2023-07-29 10:35	2023-07-29 10:37	2023-07-29 20:59	2023-08-17 12:57	2023-08-17 12:59	2023-08-17 17:43	2023-08-17 18:32	2023-08-17 18:33	1065.0	624.0	10.0	YES	0.0
6659.0	BRANCH	BRANCH	July	1690675877202	‪‪‪WOCE184305	SUMBER MITRA JAYA, PT	-	-	VCE	A40G	324231	5146	WARRANTY	STANDBY	2023-07-30 00:00:00.0000000	badiwata	BERAU	coolant pump leaking	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job closed	Darmansyah	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-07-30 07:11	2023-07-30 07:11	2023-07-30 07:13	2023-07-30 07:51	2023-07-30 07:13	2023-07-30 07:51	2023-07-30 15:20	2023-07-30 17:05	2023-07-31 11:08	1065.0	40.0	8.0	YES	0.0