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
3530.0	ADMIN	BRANCH	April	1681725978790	WO23177490	ULIMA NITRA, PT	-	-	VCE	EC480DL	284419	1750	WARRANTY	RUNNING	-	CBR	MUARA ENIM	PM service 1750 jam AB278 SN284419 UN CBR	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai jam 17.00	Agus Prabowo	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-17 17:06	2023-04-17 17:08	2023-04-18 09:26	2023-04-18 12:29	2023-04-18 10:41	2023-04-18 12:29	2023-04-18 18:45	2023-04-18 21:29	2023-04-18 21:29	1168.0	189.0	9.0	YES	2.0
3531.0	ADMIN	BRANCH	April	1681726055827	WO23177492	ULIMA NITRA, PT	-	-	VCE	EC480DL	284803	750	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 750 jam AB290 SN 284803 UN BGG	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive in branch office	Muhammad Zohran	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-17 17:07	2023-04-17 17:08	2023-04-19 09:00	2023-04-19 10:21	2023-04-19 09:00	2023-04-19 10:21	2023-04-19 21:44	2023-04-19 22:07	2023-04-21 14:15	1168.0	105.0	13.0	YES	1.0
3532.0	MECHANIC	MECHANIC	April	1681776989129	WO23176895	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	889000	7250	NON WARRANTY	RUNNING	2023-04-18 00:00:00.0000000	sanga-sanga	SAMARINDA	VT55 PS250H	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-04-18 07:16	2023-04-18 07:19	2023-04-18 07:19	2023-04-18 12:24	2023-04-18 07:19	2023-04-18 12:24	2023-04-18 17:24	2023-04-18 19:41	2023-04-18 19:41	1168.0	308.0	10.0	YES	3.0
3533.0	MECHANIC	MECHANIC	April	1681779215680	CC23177112	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	AA315675	773	WARRANTY	RUNNING	2023-04-18 00:00:00.0000000	Msf Bangko barat muara enim	MUARA ENIM	Schedule service pm400 hours DT3010-13	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	complete and Ready	M. Riski Ibrahim	M. Riski Ibrahim	0895610719859	mriskiibrahim999@gmail.com	2023-04-18 07:53	2023-04-18 07:54	2023-04-18 07:57	2023-04-18 08:11	2023-04-18 07:57	2023-04-18 08:11	2023-04-18 11:26	2023-04-18 14:05	2023-04-18 14:09	1168.0	18.0	3.0	YES	0.0
3534.0	ADMIN	BRANCH	April	1681782384424	WO23176882	HILLCONJAYA SAKTI, PT	-	-	VCE	EC210D	231901	3	WARRANTY	RUNNING	2023-04-18 00:00:00.0000000	.	BANJARMASIN	COMMISSIONING UNIT	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Unit ready for use	Zainur Yahya	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-04-18 08:46	2023-04-18 08:46	2023-04-27 07:36	2023-04-27 07:36	2023-04-27 07:36	2023-04-27 07:36	-	-	2023-04-27 07:38	1168.0	12890.0	-	NO	0.0
3535.0	ADMIN	BRANCH	April	1681783214327	WO23176940	FAHLIPI PUTRA SEJAHTERA, PT.	-	-	SDLG	E6210F	609315	1000	WARRANTY	RUNNING	2023-04-18 00:00:00.0000000	BUKIT TUNGGAL	BANJARMASIN	SERVICE 1000HM	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	after service unit rfu	Junaidi Arsyandi	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-04-18 09:00	2023-04-18 09:00	2023-04-18 13:09	2023-04-24 11:36	2023-04-18 13:09	2023-04-24 11:36	2023-04-24 11:36	2023-04-24 11:37	2023-04-24 11:37	1168.0	8796.0	146.0	YES	0.0
3536.0	ADMIN	BRANCH	April	1681790204464	WO23178407	PIONIRBETON INDUSTRI, PT	-	-	SDLG	L958F	VLGL958FHJ0620097	14152	NON WARRANTY	RUNNING	-	SERPONG	JAKARTA	PM 2000 WL7A	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive on office	Yusuf Rhama Dhani	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-04-18 10:56	2023-04-18 10:57	2023-04-18 11:00	2023-04-18 12:30	2023-04-18 11:00	2023-04-18 12:30	2023-04-18 18:01	2023-04-18 19:06	2023-05-04 15:57	1167.0	94.0	7.0	YES	0.0
3537.0	ADMIN	BRANCH	April	1681790392840	WO23177512	ROSALIA INDAH TRANSPORT, PT.	-	-	VB	B11R	YV3T2T429LA200573	-	NON WARRANTY	RUNNING	-	PALUR	SEMARANG	YV3T2T429LA200573 WO23177512 T/S TRANSMISSION SYSTEM INCLUDE CALIBRATION SDD 162 VB ROSALIA INDAH TRANSPORT, PT. 2597 ITU-000010078 SRWE Invoiced Triyono Smg 4/18/2023 9.00	TRANSMISSION	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-04-18 10:59	2023-04-18 11:00	2023-04-18 11:00	2023-04-18 11:00	2023-04-18 11:00	2023-04-18 11:00	2023-04-18 18:47	2023-04-18 18:47	2023-04-18 18:47	1167.0	1.0	7.0	YES	0.0
3538.0	ADMIN	BRANCH	April	1681790507601	WO23177513	ROSALIA INDAH TRANSPORT, PT.	-	-	VB	B11R	YV3T2T421LA200535	-	NON WARRANTY	RUNNING	-	PALUR	SEMARANG	YV3T2T421LA200535 WO23177513 T/S TRANSMISSION SYSTEM INCLUDE CALIBRATION SDD 164 VB ROSALIA INDAH TRANSPORT, PT. 2597 ITU-000010077 SRWE Invoiced Triyono Smg 4/18/2023 1.00	TRANSMISSION	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-04-18 11:01	2023-04-18 11:02	2023-04-18 11:02	2023-04-18 11:02	2023-04-18 11:02	2023-04-18 11:02	2023-04-18 18:46	2023-04-18 18:46	2023-04-18 18:46	1167.0	1.0	7.0	YES	0.0
3539.0	ADMIN	BRANCH	April	1681790784589	WO23177502	ADAMAS NAROTAMA TEKNIKA, PT	-	-	VCE	SD100D	-	-	NON WARRANTY	RUNNING	-	JEPARA	SEMARANG	WO23177502 GENERAL INSPECTION SD100 OTH 4017 ITU-000008861 SRWE Invoiced Triyono Smg 4/18/2023 10.00	TRANSMISSION	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-04-18 11:06	2023-04-18 11:06	2023-04-18 11:06	2023-04-18 11:06	2023-04-18 11:06	2023-04-18 11:06	2023-04-18 18:45	2023-04-18 18:45	2023-04-18 18:46	1167.0	1.0	7.0	YES	0.0