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
4160.0	ADMIN	BRANCH	May	1683794556721	WO23178787	SRIKANDI UTAMA MAKMUR, PT	-	-	VT	FMX44084R-I SHIFT	A319158	10	STOCK	RUNNING	-	HASEMA	JAKARTA	Prepare And Delivery Unit CHID A319158	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	.	Ihwan Dwi	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-11 15:42	2023-05-11 15:42	2023-05-11 19:13	2023-05-11 19:13	2023-05-11 19:13	2023-05-11 19:13	2023-05-12 00:07	2023-05-12 00:07	2023-05-12 08:39	1144.0	211.0	8.0	YES	0.0
4161.0	ADMIN	BRANCH	May	1683796355742	WO23178789	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	323788	10000	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM Service 10000 jam AD56 SN 323788 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	18:30 WIB	Aditya Ryan Saputra	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-05-11 16:12	2023-05-11 16:13	2023-05-13 09:59	2023-05-13 16:13	2023-05-13 09:59	2023-05-13 16:13	2023-05-13 21:52	-	2023-05-17 08:07	1144.0	379.0	11.0	YES	1.0
4162.0	ADMIN	BRANCH	May	1683797516150	WO23178734	PANCARAN ENERGI TRANSPORTASI, PT.	-	-	VT	FMX44066R	A899747	1	WARRANTY	RUNNING	2023-05-11 00:00:00.0000000	Muara Badak	BALIKPAPAN	Service First Volvo FMX 440HP A899747 PT PET	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	.	Fiqri Hamdani	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-05-11 16:31	2023-05-11 16:32	2023-05-11 17:43	2023-05-12 07:38	2023-05-11 17:43	2023-05-12 07:38	2023-05-12 11:40	2023-05-13 13:52	2023-05-13 13:52	1144.0	907.0	19.0	YES	0.0
4163.0	ADMIN	BRANCH	May	1683855112817	WO23178876	WIN WAHANA CIPTA MARGA, PT	-	-	VCE	ABG5820	701926	1055	NON WARRANTY	RUNNING	-	PANTOLOAN	PALU	Installation & Repair Cable Paver ABG5820 SN701926	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive in branch office	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-05-12 08:31	2023-05-12 08:32	2023-05-12 08:35	2023-05-12 09:29	2023-05-12 08:35	2023-05-12 09:29	2023-05-12 15:31	2023-05-13 10:17	2023-05-15 08:29	1144.0	57.0	7.0	YES	0.0
4164.0	ADMIN	BRANCH	May	1683857072393	WO23178777	BUKIT ASAM ( PERSERO ) TBK., PT	-	-	VCE	L120F	27026	23547	NON WARRANTY	RUNNING	-	PALEMBANG	PALEMBANG	Engine overheat	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Ready job	Binharun Sipahutar	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-05-12 09:04	2023-05-12 09:04	2023-05-12 09:06	2023-05-12 12:39	2023-05-12 09:06	2023-05-12 12:39	2023-05-14 20:28	2023-05-14 20:28	2023-05-14 20:29	1143.0	214.0	59.0	YES	0.0
4165.0	ADMIN	BRANCH	May	1683857582807	‪‪‪WO23178818	MENGGALA VICTORY JAYA, PT.	-	-	SDLG	E6210F	609627	7	WARRANTY	STANDBY	-	SORONG	SORONG	Commissioning Unit	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Rheno Bayu Saputro	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2023-05-12 09:13	2023-05-12 09:13	2023-05-12 09:31	2023-05-12 12:57	2023-05-12 09:31	2023-05-12 12:57	2023-05-12 13:14	2023-05-12 14:37	2023-05-15 11:04	1143.0	224.0	4.0	YES	0.0
4166.0	ADMIN	BRANCH	May	1683858056151	WO23178812	WAHYU ANGGI SELARAS, PT	-	-	VCE	EC210D	253383	26	WARRANTY	STANDBY	-	KENDARI	KENDARI	Inspection unit can't running EC210D DN253383	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrival in branch	Arfandi yahya	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-05-12 09:20	2023-05-12 09:21	2023-05-12 09:54	2023-05-12 09:55	2023-05-12 09:54	2023-05-12 09:55	2023-05-12 09:56	2023-05-12 13:01	2023-05-12 14:18	1143.0	34.0	0.0	YES	0.0
4167.0	ADMIN	BRANCH	May	1683858751478	WO23178830	INDOTRUCK UTAMA, PT.	-	-	SDLG	E6210F	609630	4.9	STOCK	STANDBY	-	PALEMBANG	PALEMBANG	Arrival inspection	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job start	Dimas Adi Nugroho	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-05-12 09:32	2023-05-12 09:32	2023-05-12 09:33	2023-05-12 09:33	2023-05-12 09:33	2023-05-12 09:33	2023-05-12 11:21	2023-05-12 11:21	2023-05-12 11:22	1143.0	1.0	1.0	YES	0.0
4168.0	ADMIN	BRANCH	May	1683859849935	WO23178775	TAPALOSA CIPTA SARANA, PT	-	-	SDLG	LG933L	606309	295	WARRANTY	RUNNING	-	PUWATU	KENDARI	Mandatory Service 250HM SDLG LG933L SN606309	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrival in branch	Arfandi yahya	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-05-12 09:50	2023-05-12 09:51	2023-05-12 09:52	-	2023-05-12 09:52	-	2023-05-12 09:54	2023-05-12 13:00	2023-05-12 14:18	1143.0	-	0.0	YES	0.0
4169.0	ADMIN	BRANCH	May	1683690552585	WO23177113	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	894956	3000	NON WARRANTY	RUNNING	-	PENDINGIN	SAMARINDA	SERVICE 1000 HRS VT076	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	do e	Arman Maulana Saputra	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-10 10:49	2023-05-10 10:49	2023-05-10 10:50	2023-05-10 13:18	2023-05-10 10:50	2023-05-10 13:18	2023-05-11 06:45	2023-05-11 08:56	2023-05-11 08:56	1145.0	149.0	19.0	YES	0.0