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
5320.0	ADMIN	BRANCH	June	1686715072105	WO23181316	CAHAYA INDAH SANGSURYA, PT	-	-	SDLG	G9138	600617	8	WARRANTY	RUNNING	2023-06-04 00:00:00.0000000	SEMBAKUNG	TARAKAN	COMMISIONING UNIT	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Complete	Christian Oktavianto	Tarakan Admin	89538317607	tarakan.sbs@indotruck-utama.co.id	2023-06-14 10:57	2023-06-14 10:58	2023-06-14 11:20	2023-06-14 13:37	2023-06-14 11:20	2023-06-14 13:37	2023-06-14 18:16	2023-06-15 06:58	2023-06-15 07:36	1110.0	160.0	7.0	YES	0.0
5321.0	ADMIN	BRANCH	June	1686715122679	WO23181666	MULTIGUNA LESTARI ABADI, PT	-	-	SDLG	E6210F	609291	1597.5	NON WARRANTY	RUNNING	-	SLENSEN	PEKANBARU	Service 1500 hours	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	HARIANTO OK	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-06-14 10:58	2023-06-14 10:58	2023-06-19 19:20	2023-06-20 09:08	2023-06-19 19:20	2023-06-20 09:08	-	2023-06-22 17:31	2023-06-23 14:40	1110.0	1384.0	-	YES	0.0
5322.0	ADMIN	BRANCH	June	1686726235987	WO23181339	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606443	-	WARRANTY	RUNNING	2023-06-14 00:00:00.0000000	Makassar	MAKASSAR	Stock Maintenance Program	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Davit Witanto	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-06-14 14:03	2023-06-14 14:04	2023-06-14 14:05	2023-06-14 14:05	2023-06-14 14:05	2023-06-14 14:05	2023-06-14 18:53	2023-06-14 18:54	2023-06-15 07:26	1110.0	2.0	4.0	YES	0.0
5323.0	ADMIN	BRANCH	June	1686727846156	WO23181330	PIONIRBETON INDUSTRI, PT	-	-	SDLG	LG958L	9018644	8729	NON WARRANTY	RUNNING	-	CIKARANG	JAKARTA	Install part recomendation after inspection articualtion bearing worn out LG 958L SN. 9018644 Lokasi Cikarang	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	DONE	Septian Dwi Handarian	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-06-14 14:30	2023-06-14 14:30	2023-07-20 10:02	2023-07-20 11:32	2023-07-22 08:41	2023-07-22 09:26	2023-07-22 18:03	2023-07-22 19:39	2023-07-24 08:14	1110.0	51662.0	867.0	NO	0.0
5324.0	MECHANIC	MECHANIC	June	1686732396970	WO23181277	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898749	5750	WARRANTY	RUNNING	2023-06-14 00:00:00.0000000	batuah	SAMARINDA	vt64 ps250h	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Done	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-06-14 15:46	2023-06-14 15:53	2023-06-14 15:53	2023-06-14 15:54	2023-06-14 15:53	2023-06-14 15:54	2023-06-14 15:55	2023-06-14 16:31	2023-06-14 16:31	1110.0	8.0	0.0	YES	7.0
5325.0	ADMIN	BRANCH	June	1686735191563	WO23181243	HUTAMA KARYA INFRASTRUKTUR PT	-	-	SDLG	E690F	600661	5930	NON WARRANTY	RUNNING	-	PRABUMULIH	PALEMBANG	SERVICE PM 2000 HOURS	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Ready	Binharun Sipahutar	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-14 16:33	2023-06-14 16:33	2023-06-16 08:29	2023-06-17 10:23	2023-06-16 08:29	2023-06-17 10:23	2023-06-19 12:10	2023-06-19 12:10	2023-06-19 12:13	1110.0	1555.0	75.0	YES	0.0
5326.0	ADMIN	BRANCH	June	1686793015826	WO23181368	MUDA BERJAYA BEUTARI, CV	-	-	SDLG	E6210F	609596	750	WARRANTY	RUNNING	-	MEULABOH	MEDAN	Mandatory Service 750 Hours SN 609596	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	traveling	Joko Firman Nababan	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-06-15 08:36	2023-06-15 08:37	2023-06-15 08:46	2023-06-15 14:19	2023-06-15 08:46	2023-06-15 14:19	2023-06-16 15:45	2023-06-17 08:27	2023-06-17 08:28	1110.0	343.0	31.0	YES	0.0
5327.0	ADMIN	BRANCH	June	1686793152727	WOCE181363	INDOTRUCK UTAMA, PT.	-	-	VCE	R100E	111017	4000	STOK	STANDBY	2023-06-15 00:00:00.0000000	bALIKPAPAN	BALIKPAPAN	Campaign MRP02 R100E SN111017	ETC	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Complete	victor julius	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-06-15 08:39	2023-06-15 08:39	2023-06-15 11:06	2023-06-15 11:06	2023-06-15 11:06	2023-06-15 11:06	2023-06-15 16:11	2023-06-15 16:11	2023-06-15 16:12	1110.0	147.0	7.0	YES	0.0
5328.0	ADMIN	BRANCH	June	1686794296310	WO23181369	KOSTEC PRIMA BAJA, PT	-	-	VT	FH1655064T	751958	40355	NON WARRANTY	BREAKDOWN	2023-06-15 00:00:00.0000000	Cilegon	CILEGON	Troubleshooting Engine Off	ETC	INSPECTION	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job Completed at 15 Juni 2023	Pujiyanto	Cilegon Admin	85219742046	cilegon.sbs@indotruck-utama.co.id	2023-06-15 08:58	2023-06-15 08:58	2023-06-15 09:03	2023-06-15 10:00	2023-06-15 09:03	2023-06-15 10:00	2023-06-15 18:11	2023-06-15 18:12	2023-06-16 08:17	1110.0	62.0	9.0	YES	0.0
5329.0	MECHANIC	MECHANIC	June	1686795975318	0	JHONLIN BARATAMA, PT	-	-	VCE	EC750DL	280815	6009.2	WARRANTY	RUNNING	2023-06-15 00:00:00.0000000	Serongga	BANJARMASIN	PS-2000h	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	rfu	Ridwan Wahyu	Ridwan Wahyu	082256295575	wahyuridwan150@gmail.com	2023-06-15 09:26	2023-06-15 09:34	2023-06-15 09:34	2023-06-15 09:34	2023-06-15 09:34	2023-06-15 09:34	2023-06-21 16:01	2023-06-21 16:02	2023-06-21 16:02	1109.0	9.0	150.0	YES	8.0