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
5680.0	ADMIN	BRANCH	June	1687837724617	WOCE181671	CAKRAWALA KENCANA INDONESIA, PT	-	-	VCE	R100E	111078	44	WARRANTY	RUNNING	2023-06-27 00:00:00.0000000	SEBAMBAN	BANJARMASIN	DUMP UPPER SENSOR PROXIMITY DAMAGE	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	RFU	Ahmad Adji Ardianto	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-06-27 10:48	2023-06-27 10:48	-	2023-06-27 11:11	-	2023-06-27 11:11	-	-	2023-06-27 14:18	1097.0	23.0	-	YES	0.0
5681.0	ADMIN	BRANCH	June	1687745409844	WOCE182049	RAKA NAVARA, PT	-	-	VCE	EC210D	252896	1491	WARRANTY	RUNNING	-	KOLAKA UTARA	KENDARI	Install Coolantpump EC210D SN252896	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch ITU Kendari	Arfandi yahya	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-06-26 09:10	2023-06-26 09:11	2023-06-26 09:37	2023-06-26 18:17	2023-06-26 09:37	2023-06-26 18:17	2023-06-29 12:08	2023-06-30 07:45	2023-06-30 09:31	1098.0	548.0	74.0	YES	0.0
5682.0	ADMIN	BRANCH	June	1687746667821	WO23182117	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324716	400	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 400 jam AD74 SN 324716 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di kantor	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-06-26 09:31	2023-06-26 09:31	2023-06-26 10:31	2023-06-26 19:46	2023-06-26 10:31	2023-06-26 19:46	2023-06-27 07:35	2023-06-27 07:55	2023-06-27 08:41	1098.0	615.0	22.0	YES	0.0
5683.0	ADMIN	BRANCH	June	1687749311192	WO23182130	MANDIRI HERINDO ADIPERKASA, PT	-	-	VCE	EC750DL	280947	12	WARRANTY	STANDBY	-	BENGALON SITE KPC	SANGATTA	COMMISIONING UNIT VOLVO EC750DL SN.280947	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Muhammad Ansar	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-06-26 10:15	2023-06-26 10:15	2023-06-26 11:17	2023-06-26 13:03	2023-06-26 11:17	2023-06-26 13:03	2023-06-26 16:11	2023-06-27 07:05	2023-06-27 07:06	1098.0	168.0	5.0	YES	0.0
5684.0	ADMIN	BRANCH	June	1687750928285	-	ANGKASA SAKTI, PT.	-	-	SDLG	L956F	625341	103	WARRANTY	RUNNING	-	BANTUAS	SAMARINDA	E5202497 SERVICE 100 HOURS	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-06-26 10:42	2023-06-26 10:47	2023-06-26 10:48	2023-06-26 11:16	2023-06-26 10:48	2023-06-26 11:16	2023-06-26 17:58	2023-06-26 21:17	2023-06-26 21:18	1098.0	34.0	7.0	YES	5.0
5685.0	ADMIN	BRANCH	June	1687755448212	WO23182137	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG936L	607277	5.5	STOCK	STANDBY	-	W/S PEKANBARU	PEKANBARU	Storage Maintenance	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back to shop	INDRA MAHDI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-06-26 11:57	2023-06-26 11:57	2023-06-26 13:30	2023-06-26 13:37	2023-06-26 13:30	2023-06-26 13:37	2023-06-26 14:05	2023-06-26 15:04	2023-06-26 16:46	1098.0	100.0	2.0	YES	0.0
5686.0	ADMIN	BRANCH	June	1687759728338	WO23182145	PAMA PERSADA NUSANTARA, PT	-	-	VCE	A40G	324895	5	WARRANTY	STANDBY	-	SITE KPCS	SANGATTA	COMMISIONING UNIT VOLVO A40G SN.324895	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Muhammad Ansar	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-06-26 13:08	2023-06-26 15:17	2023-06-26 16:10	-	2023-06-26 16:10	-	2023-06-28 08:32	2023-06-28 15:35	2023-06-28 15:35	1098.0	-	43.0	YES	128.0
5687.0	ADMIN	BRANCH	June	1687760831601	WO23182147	INDOTRUCK UTAMA, PT.	-	-	SDLG	E660FL	625866	6	STOCK	RUNNING	-	YARD PALU	PALU	ARIVAL INSPECTION E660FL SN625866	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-06-26 13:27	2023-06-26 13:28	2023-06-26 13:36	2023-06-26 14:15	2023-06-26 13:36	2023-06-26 14:15	2023-06-26 14:52	2023-06-26 14:53	2023-06-27 07:36	1098.0	48.0	1.0	YES	1.0
5688.0	ADMIN	BRANCH	June	1687764575256	WO23182168	AINUN	-	-	SDLG	E690F	600948	1797	WARRANTY	RUNNING	-	TIPO	PALU	INSPECTION OVERHEAT ENGINE E690F SN600948	ENGINE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-06-26 14:29	2023-06-26 14:29	2023-06-26 14:30	2023-06-26 14:53	2023-06-26 14:30	2023-06-26 14:53	2023-06-26 18:45	2023-06-27 06:51	2023-06-27 07:35	1098.0	24.0	4.0	YES	0.0
5689.0	ADMIN	BRANCH	June	1687764623418	WO23182154	HUTAMA KARYA INFRASTRUKTUR PT	-	-	VCE	EC210D	VCEC210DL00282777	5500	NON WARRANTY	RUNNING	-	BANYUMAS	SEMARANG	VCEC210DL00282777 WO23182154 PREVENTIVE MAINTENANCE 500 H VCE Hutama Karya Infrastruktur. PT 1601 ITU-000009896 SRWE Created Triyono Smg 6/27/2023 20.00	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-06-26 14:30	2023-06-26 14:30	2023-06-26 14:30	2023-06-26 14:30	2023-06-26 14:30	2023-06-26 14:30	2023-06-27 08:37	2023-06-27 08:37	2023-06-27 08:38	1098.0	0.0	18.0	YES	0.0