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
1880.0	ADMIN	BRANCH	February	1676971577576	23173039	BARA PRIMA PRATAMA, PT	-	-	VT	FMX44084R-I SHIFT	B374616	22425	WARRANTY	RUNNING	-	BATU AMPAR	JAMBI	CAMPAIGN S2754	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Bagas Kurniansah	Karlina Aulia Fitri JMB ADMIN	081366256191	serviceadmin.jambi@indotruck-utama.co.id	2023-02-21 16:26	2023-02-21 16:26	2023-02-21 16:28	2023-02-21 16:30	2023-02-21 16:28	2023-02-21 16:30	2023-02-22 08:19	2023-02-22 08:23	2023-02-22 08:26	1223.0	5.0	15.0	YES
1881.0	BRANCH	BRANCH	February	1677031733975	WO23173626	PRIMA SARANA GEMILANG, PT	-	-	VCE	EC480DL	284851	613	WARRANTY	STANDBY	2023-02-22 00:00:00.0000000	sambarata	BERAU	service 500 hrs	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	RFU sinyal bad	Syahrul	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-02-22 09:08	2023-02-22 09:09	2023-02-22 09:10	2023-02-22 09:10	2023-02-22 09:10	2023-02-22 09:10	2023-02-22 22:42	2023-02-22 22:42	2023-02-22 22:42	1222.0	2.0	13.0	YES
1882.0	BRANCH	BRANCH	February	1677034675360	WO23173433	GUNUNG HARTA TRANSPORT SOLUTIONS, PT.	-	-	VB	B11R-430 6X2	203575	-	NON WARRANTY	BREAKDOWN	-	TERMINAL PORIS	JAKARTA	Replace steering hose trailing axle, incl. bleeding steering fluid	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Joko Wijayanto	Rahman Dendi	081388101230	rahman_dendi@yahoo.com	2023-02-22 09:57	2023-02-22 09:58	2023-02-22 10:03	2023-02-22 12:32	2023-02-22 10:03	2023-02-22 12:32	2023-02-22 14:13	2023-02-22 16:25	2023-02-22 16:25	1222.0	154.0	4.0	NO
1883.0	MECHANIC	MECHANIC	February	1677038199817	WOSD173368	BUANA PRIMA MULIA, PT	-	-	SDLG	LG953L	621935	1158	WARRANTY	RUNNING	2023-02-22 00:00:00.0000000	Pelabuhan Dagang	JAMBI	Replace Water Separator	ETC	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	done	Ardiansyahnur	Ardiansyahnur	082353107865	ardiansyahnur2002@gmail.com	2023-02-22 10:56	2023-02-22 10:56	2023-02-22 10:57	2023-02-22 15:14	2023-02-22 10:57	2023-02-22 15:14	2023-02-22 15:18	2023-02-23 08:14	2023-02-23 08:14	1222.0	258.0	4.0	YES
1884.0	ADMIN	BRANCH	February	1677049689487	WO23173203	SHA SOLO, PT	-	-	VT	FMX44066T	YV2XS02C5KA846420 WO23173203	56	WARRANTY	RUNNING	2023-02-22 00:00:00.0000000	Solo	SEMARANG	YV2XS02C5KA846420 WO23173203 T/S ENGINE LOW POWER VT SHA SOLO, PT. 4330 ITU-000009403 SRWI-SVC Created Triyono Smg 2/20/2023 10.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	9	Andri Kurniawan	Muchammad Rivkhi Indiarta	083838871090	rivkhi.indiarta@indotruck-utama.co.id	2023-02-22 14:08	2023-02-22 14:08	2023-02-22 14:08	2023-02-22 14:08	2023-02-22 14:08	2023-02-22 14:08	2023-02-28 15:45	2023-02-28 15:45	2023-02-28 15:45	1222.0	1.0	145.0	YES
1885.0	BRANCH	BRANCH	February	1677050454591	173463	HASNUR RIUNG SINERGI, PT.	-	-	VCE	R100E	111054	4564	NON WARRANTY	STANDBY	2023-02-22 00:00:00.0000000	WS BJM	BANJARMASIN	STEERING CYLINDER RH & LH LEAK R100E SN111054	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	RFU	Taqii Mutadayyin	Erikson Simanungkalit	08115171117	erikson.simanungkali@indotruck-utama.co.id	2023-02-22 14:20	2023-02-22 14:21	2023-03-11 23:05	2023-03-11 23:22	2023-03-11 23:05	2023-03-11 23:22	2023-03-11 23:25	2023-03-11 23:25	2023-03-11 23:26	1222.0	25022.0	417.0	YES
1886.0	ADMIN	BRANCH	February	1677050817473	VLGE606FCN0625851 WO23173429	GARUDAFOOD PUTRA PUTRI JAYA TBK, PT	-	-	SDLG	E660FL	VLGE606FCN0625851 WO23173429	3	WARRANTY	RUNNING	2023-02-22 00:00:00.0000000	Semarang	SEMARANG	VLGE606FCN0625851 WO23173429 COMMISSIONING UNIT E660FL SDLG 4741 ITU-000018465 SRWI-SVC Created Triyono Smg 2/22/2023 2.00	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	9	Ahmad Saimin	Muchammad Rivkhi Indiarta	083838871090	rivkhi.indiarta@indotruck-utama.co.id	2023-02-22 14:26	2023-02-22 14:27	2023-02-22 14:27	2023-02-22 14:27	2023-02-22 14:27	2023-02-22 14:27	2023-02-28 15:48	2023-02-28 15:48	2023-02-28 15:48	1222.0	0.0	145.0	YES
1887.0	ADMIN	BRANCH	February	1677063868502	WO23173481	ARIS WIDODO	-	-	VCE	EC210D	11	5897	NON WARRANTY	RUNNING	2023-02-22 00:00:00.0000000	JOGJAKARTA	SEMARANG	WO23173481 T/S FUEL SYSTEM EC 210 D 4622 ITU-000016352 SRWE Created Triyono Smg 2/22/2023 15.00 ARIS WIDODO	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	9	Ahmad Saimin	Muchammad Rivkhi Indiarta	083838871090	rivkhi.indiarta@indotruck-utama.co.id	2023-02-22 18:04	2023-02-22 18:04	2023-02-22 18:04	2023-02-22 18:04	2023-02-22 18:04	2023-02-22 18:04	2023-02-28 15:49	2023-02-28 15:49	2023-02-28 15:49	1222.0	0.0	141.0	YES
1888.0	BRANCH	BRANCH	February	1677117875028	WO23173348	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	888883	6750	NON WARRANTY	RUNNING	2023-02-23 00:00:00.0000000	workshop sanga-sanga	SAMARINDA	service 250hrs VT048	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Erni Wati	082353253757	admin.service.smd@indotruck-utama.co.id	2023-02-23 09:04	2023-02-23 09:04	2023-02-23 09:05	2023-02-23 12:42	2023-02-23 09:05	2023-02-23 12:42	2023-02-24 11:43	2023-02-24 18:13	2023-02-24 18:14	1221.0	218.0	26.0	YES
1889.0	BRANCH	BRANCH	February	1677122666423	WO23173450	HUTAMA KARYA INFRASTRUKTUR PT	-	-	VCE	SD110	58957	1	NON WARRANTY	RUNNING	-	PRABUMULIH	PALEMBANG	Service PM 1000 hours	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	start job	Indry Sasmitha	Indry Sasmitha	081271778108	adminsvc.palembang@indotruck-utama.co.id	2023-02-23 10:24	2023-02-23 10:25	2023-03-06 09:00	2023-03-06 09:53	2023-03-06 09:00	2023-03-06 09:53	2023-03-06 14:28	2023-03-07 09:38	2023-03-07 09:38	1221.0	55.0	5.0	YES