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
4310.0	ADMIN	BRANCH	May	1684201840288	WO23179067	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324521	4000	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 4000 jam AD68 SN 324521 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di kantor	Agus Hadi Hariyono	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-05-16 08:50	2023-05-16 08:54	2023-05-19 08:51	2023-05-19 09:17	2023-05-19 11:33	2023-05-19 12:10	2023-05-19 19:54	2023-05-19 21:21	2023-05-22 07:59	1140.0	32.0	7.0	YES	3.0
4311.0	ADMIN	BRANCH	May	1684205267222	WO23180797	KHARISMA CITATUNGGAL, PT	-	-	VT	FM44066R	-	368100	NON WARRANTY	BREAKDOWN	-	WORKSHOP ITU JAKARTA	JAKARTA	KCT B 9012 TEI : Check and repair engine overheat	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	check air system problem	Ihwan Dwi	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-16 09:47	2023-05-16 09:48	2023-05-16 10:01	2023-05-16 10:02	2023-05-16 10:01	2023-05-16 10:02	2023-05-17 08:58	2023-05-17 08:59	2023-06-09 15:16	1139.0	14.0	23.0	YES	0.0
4312.0	ADMIN	BRANCH	May	1684207762647	WO23179072	ALIRAN KETAHUN PERDANA, CV	-	-	SDLG	LG956F	624734	1279	NON WARRANTY	RUNNING	2023-05-16 00:00:00.0000000	Pelabuhan	BENGKULU	service 1250	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Agus Nugroho	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-05-16 10:29	2023-05-16 10:29	2023-05-16 10:30	2023-05-16 11:23	2023-05-16 10:30	2023-05-16 11:23	2023-05-16 13:39	2023-05-16 15:26	2023-05-16 15:26	1139.0	54.0	3.0	YES	0.0
4313.0	ADMIN	BRANCH	May	1684212710495	WO23179068	SADULUR BERKAH MAKMUR, PT	-	-	SDLG	LG933L	606553	3	WARRANTY	RUNNING	2023-05-16 00:00:00.0000000	Cilegon	CILEGON	Commissiong Unit LG933L	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Completed	Rizqin Aminullah	Cilegon Admin	85219742046	cilegon.sbs@indotruck-utama.co.id	2023-05-16 11:51	2023-05-16 11:52	2023-05-16 11:54	2023-05-16 13:10	2023-05-16 11:54	2023-05-16 13:10	2023-05-16 16:35	2023-05-16 17:10	2023-05-16 17:24	1139.0	78.0	4.0	YES	0.0
4314.0	ADMIN	BRANCH	May	1684218074207	WO23179078	USTON PRATAMA, CV	-	-	VCE	EC200D	280536	4307	NON WARRANTY	STANDBY	-	WATUSAMPU	PALU	INSPECTION UNIT MATI EC200D SN280536	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	ARRIVE IN BRANCH OFFICE	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-05-16 13:21	2023-05-16 13:21	2023-05-16 13:23	2023-05-16 14:25	2023-05-16 13:23	2023-05-16 14:25	2023-05-24 15:06	2023-05-25 08:03	2023-05-25 08:19	1139.0	64.0	190.0	YES	0.0
4315.0	ADMIN	BRANCH	May	1684221587648	WOCE179110	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324766	935	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	Warranty seal input middle diff AD71 SN 324766 LDA	ECT	REPAIR	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	AD 71 Ready	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-05-16 14:19	2023-05-16 14:20	2023-06-02 18:24	2023-06-02 18:54	2023-06-02 18:24	2023-06-02 18:54	2023-06-02 19:44	2023-06-02 22:32	2023-06-02 22:32	1139.0	688.0	12.0	YES	0.0
4316.0	MECHANIC	MECHANIC	May	1684223154548	CC23178819	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	AA302126	2822	WARRANTY	RUNNING	2023-05-16 00:00:00.0000000	Bangko Barat, Muara Enim	MUARA ENIM	Schedule service 400 hours DT 3010-01	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	RFU	Muhammad Zohran	Muhammad Zohran	082307126013	muhzohran@gmail.com	2023-05-16 14:45	2023-05-16 14:46	2023-05-16 15:17	2023-05-16 15:28	2023-05-16 15:17	2023-05-16 15:28	2023-05-16 16:44	2023-05-16 19:15	2023-05-17 07:32	1139.0	42.0	1.0	YES	0.0
4317.0	ADMIN	BRANCH	May	1684225882552	WO23179059	HARKAT SEJAHTERA, PT	-	-	VCE	EC210B	082910	8000	NON WARRANTY	RUNNING	-	DESA NAGORI	MEDAN	Maintenance Service 8000 Hours, resealing cylinder Unit EC210 B SN 82910	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	part baru datang	Ferdian Dinata	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-05-16 15:31	2023-05-16 15:31	2023-05-17 08:19	2023-05-17 11:16	2023-07-11 09:18	2023-07-11 11:17	2023-07-11 17:08	2023-07-12 08:33	2023-07-12 08:35	1139.0	1186.0	1345.0	YES	0.0
4318.0	ADMIN	BRANCH	May	1684227852269	WO23179139	SUMI GITA JAYA PT	-	-	VCE	EC210D	252904	708	WARRANTY	RUNNING	-	DURI	PEKANBARU	Service 750 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back to shop	INDRA MAHDI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-16 16:04	2023-05-16 16:04	2023-05-17 09:54	2023-05-17 11:44	2023-05-17 09:54	2023-05-17 11:44	2023-05-17 16:09	2023-05-25 15:04	2023-05-26 15:33	1139.0	1180.0	24.0	YES	0.0
4319.0	ADMIN	BRANCH	May	1684231418490	WO23179058	SRIKANDI UTAMA MAKMUR, PT	-	-	VT	FMX44084R	A317600	-	WARRANTY	RUNNING	-	SUM SANGKULIRANG	JAKARTA	Campaign S2753 Air horn	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Dimas Yuangga Ariyanto	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-16 17:03	2023-05-16 17:10	2023-05-20 12:30	2023-05-20 12:30	2023-05-20 12:30	2023-05-20 12:30	-	-	2023-05-20 12:31	1139.0	5487.0	-	NO	6.0