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
5910.0	ADMIN	BRANCH	July	1688461258816	WO23182727	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324716	381	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	Check engine noise AD74 SN 324716 LDA	ENGINE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	Gabby Hade Octafiando	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-07-04 16:00	2023-07-04 16:06	2023-07-05 08:55	2023-07-05 09:50	2023-07-05 08:55	2023-07-05 09:50	2023-07-05 11:17	2023-07-05 13:46	2023-07-05 14:01	1090.0	62.0	2.0	YES	5.0
5911.0	ADMIN	BRANCH	July	1688479138622	WOCE182730	MANDIRI BARA SUKSES, PT	-	-	VCE	EC210D	232107	500	WARRANTY	RUNNING	-	KOMERING OKU	MUARA ENIM	Warranty campaign EMQ52 EX07 SN 232107 MBS	ELECTRICAL	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	20:15	Agus Hadi Hariyono	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-07-04 20:58	2023-07-04 21:02	2023-07-05 10:21	2023-07-05 13:54	2023-07-05 10:21	2023-07-05 13:54	2023-07-05 21:11	2023-07-05 21:12	2023-07-11 08:16	1090.0	336.0	12.0	YES	3.0
5912.0	ADMIN	BRANCH	July	1688517022818	WO23182717	SIRTU KARYA UTAMA, PT	-	-	SDLG	L956F	621938	3808	NON WARRANTY	RUNNING	-	BULURI	PALU	UNIT KEBOCORAN OIL COOLER	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-07-05 07:30	2023-07-05 07:31	2023-07-05 07:32	2023-07-05 10:48	2023-07-05 07:32	2023-07-05 10:48	2023-07-05 18:27	2023-07-06 08:18	2023-07-06 13:15	1090.0	198.0	10.0	YES	0.0
5913.0	ADMIN	BRANCH	July	1688520287068	WO23181282	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	899434	5250	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 250 HRS VT 073	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-07-05 08:24	2023-07-05 08:25	2023-07-05 08:25	2023-07-05 12:55	2023-07-05 08:25	2023-07-05 12:55	2023-07-05 22:23	2023-07-06 08:28	2023-07-06 08:28	1090.0	271.0	13.0	YES	0.0
5914.0	ADMIN	BRANCH	July	1688521776303	WO23182739	SRI INDRAPURA SAWIT LESTARI, PT.	-	-	SDLG	LG936L	900433	8114	NON WARRANTY	BREAKDOWN	-	KERINCI	PEKANBARU	Repair unit	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai dikantor	GALIH PERMADI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-07-05 08:49	2023-07-05 08:49	2023-07-05 09:20	2023-07-05 12:49	2023-07-05 09:20	2023-07-05 12:49	2023-07-26 15:21	2023-07-26 17:07	2023-07-27 11:37	1090.0	240.0	510.0	NO	0.0
5915.0	ADMIN	BRANCH	July	1688522542326	WO23182550	SINAR PANDAWA, PT	-	-	SDLG	LG936L	607275	110	WARRANTY	RUNNING	2023-07-05 00:00:00.0000000	porsea	MEDAN	Mandatory Service 100 hours	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back to office	Alfi Syahru Siregar	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-07-05 09:02	2023-07-05 09:03	2023-07-05 13:02	2023-07-05 13:02	2023-07-05 13:02	2023-07-05 13:02	2023-07-05 13:03	2023-07-06 09:15	2023-07-06 09:15	1089.0	240.0	4.0	YES	0.0
5916.0	ADMIN	BRANCH	July	1688525008724	WOCE182743	MANDIRI SEJAHTERA SENTRA, PT	-	-	VCE	EC480DL	284797	1500	WARRANTY	RUNNING	-	PURWAKARTA	JAKARTA	Replace Arm cylinder hose to main control valve SN.284797	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	OTW TO SITE	Mochamad Alfan Nafas	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-07-05 09:43	2023-07-05 09:43	2023-07-05 10:56	2023-07-06 09:14	2023-07-05 10:56	2023-07-06 09:14	2023-07-06 09:16	2023-07-06 09:16	2023-07-06 09:17	1089.0	1411.0	23.0	YES	0.0
5917.0	ADMIN	BRANCH	July	1688526835992	WO23182640‬‬	ADHIMIX RMC INDONESIA, PT.	-	-	SDLG	L956F	625026	499	WARRANTY	RUNNING	2023-07-05 00:00:00.0000000	IKN, Sepaku	BALIKPAPAN	Service 500 HM L956F SN625026 HM499 PT Adhimix RMC	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	RFU	Fiqri Hamdani	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-07-05 10:13	2023-07-05 10:14	2023-07-05 10:14	2023-07-05 12:35	2023-07-05 10:14	2023-07-05 12:35	2023-07-05 16:47	2023-07-05 19:05	2023-07-05 19:05	1089.0	142.0	6.0	YES	0.0
5918.0	ADMIN	BRANCH	July	1688527372877	WO23182744	PANDAWA DELAPAN TUJUH, PT.	-	-	VB	B11R	YV3T2T425KA198108	50	NON WARRANTY	RUNNING	-	BOYOLALI	SEMARANG	YV3T2T425KA198108 WO23182744 T/S ENGINE MALFUNCTION & REPLACE CAMSHAFT VB PANDAWA DELAPAN TUJUH, PT. 2492 ITU-000009074 SRWE Created Triyono Smg 7/6/2023 20.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-07-05 10:22	2023-07-05 10:23	2023-07-05 10:23	2023-07-05 10:23	2023-07-05 10:23	2023-07-05 10:23	2023-07-06 08:29	2023-07-06 08:29	2023-07-06 08:30	1089.0	1.0	22.0	YES	0.0
5919.0	ADMIN	BRANCH	July	1688609546249	WO23182781	KARYA BETON SUDHIRA, PT	-	-	SDLG	LG958F	624510	100	NON WARRANTY	RUNNING	-	SUNTER	JAKARTA	PM 100	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Septian Dwi Handarian	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-07-06 09:12	2023-07-06 09:12	2023-07-06 09:35	2023-07-06 11:33	2023-07-06 09:35	2023-07-06 11:33	2023-07-06 15:05	2023-07-06 15:41	2023-07-07 18:38	1088.0	141.0	5.0	YES	0.0