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
4240.0	ADMIN	BRANCH	May	1683880509098	23178872	PERSADA ALAM JAYA, PT.	-	-	SDLG	LG936L	606130	9775	NON WARRANTY	RUNNING	-	TANJABBAR	JAMBI	INSPACTION ENGINE LEAK	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sanpai dengan selamat 🙏	Ardiansyahnur	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-05-12 15:35	2023-05-12 15:35	2023-05-13 08:22	2023-05-13 18:35	2023-05-13 08:22	2023-05-13 18:35	2023-05-14 18:29	2023-05-14 18:29	2023-05-14 18:30	1143.0	1621.0	27.0	YES	0.0
4241.0	ADMIN	BRANCH	May	1683881026106	WO23178881	INDOTRUCK UTAMA, PT.	-	-	VCE	EC200D	250347	12.8	STOCK	STANDBY	-	PALEMBANG	PALEMBANG	Check unit maintenance storage Mei 2023	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	start job	Krisna Damas Prasetya	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-05-12 15:43	2023-05-12 15:44	2023-05-12 15:44	2023-05-12 15:44	2023-05-12 15:44	2023-05-12 15:44	2023-05-12 15:54	2023-05-12 15:55	2023-05-12 15:56	1143.0	1.0	0.0	YES	0.0
4242.0	ADMIN	BRANCH	May	1683883436556	WO23178865	SUMI GITA JAYA PT	-	-	VCE	EC210D	252902	794	WARRANTY	RUNNING	-	DURI	PEKANBARU	Engine low power	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back to pku	INDRA MAHDI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-05-12 16:23	2023-05-12 16:24	2023-05-13 15:17	2023-05-13 16:15	2023-05-13 15:17	2023-05-13 16:15	2023-05-15 11:05	2023-05-16 12:45	2023-05-17 08:58	1143.0	1431.0	66.0	YES	0.0
4243.0	ADMIN	BRANCH	May	1683945843082	WO23178902	UTAMA TRAKTOR,CV.	-	-	SDLG	L968F	620574	1000	WARRANTY	RUNNING	-	KM 106 SLR	MUARA ENIM	PM service 1000 jam L968F L-08 SN 620574 UT	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-05-13 09:44	2023-05-13 09:44	2023-05-17 08:10	2023-05-17 08:34	2023-05-17 08:10	2023-05-17 08:34	2023-05-17 11:18	2023-05-17 12:29	2023-05-17 12:43	1142.0	26.0	3.0	YES	0.0
4244.0	MECHANIC	MECHANIC	May	1683946085846	-	BINTANG ALAM REJEKI, PT.	-	-	VCE	A40G	-	709	WARRANTY	RUNNING	2023-05-13 00:00:00.0000000	Batuah	SAMARINDA	Warranty Rotary Lamp	ETC	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	completed pemasangan warranty part rotary lamp	Diky Maulana Tarmiji	Diky Maulana Tarmiji	081356619526	iamdiky15@gmail.com	2023-05-13 09:48	2023-05-13 09:48	2023-05-13 09:48	2023-05-13 12:10	2023-05-13 09:48	2023-05-13 12:10	2023-05-13 18:12	2023-05-13 22:25	2023-05-13 22:26	1142.0	142.0	8.0	NO	0.0
4245.0	MECHANIC	MECHANIC	May	1684113474263	000377	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	302342	2796	WARRANTY	RUNNING	2023-05-15 00:00:00.0000000	MSF Bangko Barat	MUARA ENIM	Pm 400 hours DT3010-04	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Redy pm 400 h DT 3010-04 start 08.30 finish 12.00	Deka Ali Septia J	Deka Ali Septia J	081272820949	dekajaya81893@gmail.com	2023-05-15 08:17	2023-05-15 08:18	2023-05-15 08:19	2023-05-15 08:42	2023-05-15 08:19	2023-05-15 08:42	2023-05-15 13:25	2023-05-15 13:32	2023-05-15 13:34	1141.0	24.0	5.0	YES	0.0
4246.0	ADMIN	BRANCH	May	1684117738617	-	RIMBA PERKASA UTAMA, PT	-	-	VCE	A40G	-	-	WARRANTY	RUNNING	-	PENDINGIN	SAMARINDA	EROR DISPLAY	BRAKE	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	complete error parking brake	Diky Maulana Tarmiji	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-15 09:28	2023-05-15 09:30	2023-05-15 09:32	2023-05-15 09:58	2023-05-15 09:32	2023-05-16 07:43	2023-05-15 13:57	-	2023-05-16 10:10	1140.0	29.0	4.0	NO	1.0
4247.0	ADMIN	BRANCH	May	1684122968649	WO23178863	PASIR PUTIH, CV	-	-	SDLG	G9138	600605	500	WARRANTY	RUNNING	-	PORSEA	MEDAN	Mandatory Service 500 Hours G9138 F SN 600605	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive on site telat dikarenakan kesusahan mencari unit di job sebelumnya. job is finished	Joys Alfedro Siregar	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-05-15 10:56	2023-05-15 10:58	2023-05-16 15:19	2023-06-01 14:10	2023-05-29 11:45	2023-06-01 14:10	2023-06-01 20:08	2023-06-01 21:04	2023-06-01 21:06	1140.0	24674.0	417.0	YES	2.0
4248.0	MECHANIC	MECHANIC	May	1684132728009	000377	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R-IShift	407150	1210	WARRANTY	RUNNING	2023-05-15 00:00:00.0000000	MSF bangko barat	MUARA ENIM	PM 400 h DT 3010-10	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Redy pm 400 h Dt3010-10 start 13.00 s/d 17.00	Deka Ali Septia J	Deka Ali Septia J	081272820949	dekajaya81893@gmail.com	2023-05-15 13:38	2023-05-15 13:40	2023-05-15 13:43	2023-05-15 14:23	2023-05-15 13:43	2023-05-15 14:23	2023-05-15 16:45	2023-05-15 17:30	2023-05-15 17:31	1140.0	45.0	3.0	YES	1.0
4249.0	MECHANIC	BRANCH	May	1684199982952	.	HARMONI PANCA UTAMA, PT	-	-	VCE	A40F	52514	20852	NON WARRANTY	BREAKDOWN	2023-05-14 00:00:00.0000000	Muara Teweh	BANJARMASIN	Cylinder steering RH/LH Leak	ETC	OVERHAUL	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Unit ready for use	Zainur Yahya	Zainur Yahya Imran	85900091285	zainur.yahya222@gmail.com	2023-05-16 08:19	2023-05-16 09:44	2023-05-17 09:43	2023-05-17 09:44	2023-05-17 09:43	2023-05-17 09:44	2023-05-17 09:47	2023-05-17 09:48	2023-05-21 04:21	1140.0	1525.0	25.0	YES	84.0