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
2471.0	ADMIN	BRANCH	March	1678688272260	WO23175228	NUSANTARA INTI PRATAMA, PT	-	-	VCE	EC350D	271240	1829	WARRANTY	RUNNING	-	SANGKULIRANG, KAB KUTAI TIMUR	SANGATTA	DOWNLOAD MATRIS UNIT VOLVO EC350D SN.271240	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Soedarto Mesak Palallo	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-03-13 13:17	2023-03-13 13:18	2023-03-13 13:31	2023-03-13 14:01	2023-03-13 13:31	2023-03-13 14:01	2023-03-13 16:22	2023-03-14 12:46	2023-03-20 14:19	1186.0	44.0	3.0	YES	0.0
2472.0	ADMIN	BRANCH	March	1678694341925	WO23174038	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324305	4400	WARRANTY	STANDBY	-	MUARA LAWAI	MUARA ENIM	PM S 4400 jam A40G AD60 SN 324305 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampe office	Gabby Hade Octafiando	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-03-13 14:59	2023-03-13 14:59	2023-03-28 08:27	2023-03-28 08:56	2023-03-28 10:11	2023-03-28 08:56	2023-03-28 10:12	2023-03-28 11:25	2023-03-28 11:37	1186.0	58.0	2.0	YES	0.0
2473.0	ADMIN	BRANCH	March	1678694543688	WO23174647	WAHANA INDO TRADA MOBILINDO,PT.	-	-	VB	B11R	202144	100320	NON WARRANTY	RUNNING	-	CIBINONG	JAKARTA	Basic service I, B11R, CHID. 202144 B 7681 TGD	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	DONE	Eko Suharyanto	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-03-13 15:02	2023-03-13 15:02	2023-03-14 00:40	2023-03-14 00:41	2023-03-14 00:40	2023-03-14 00:41	2023-03-14 00:41	2023-03-14 00:42	2023-03-14 00:42	1186.0	579.0	9.0	YES	0.0
2474.0	ADMIN	BRANCH	March	1678694701951	WO23174039	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324509	2400	WARRANTY	STANDBY	-	MUARA LAWAI	MUARA ENIM	PM S 2400 jam A40G AD70 SN 324509 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampe kantor	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-03-13 15:05	2023-03-13 15:06	2023-03-31 08:19	2023-03-31 09:08	2023-03-31 08:19	2023-03-31 09:08	2023-03-31 10:07	2023-03-31 10:45	2023-03-31 10:49	1186.0	54.0	1.0	YES	1.0
2475.0	ADMIN	BRANCH	March	1678695257960	WO23174040	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	323788	9200	NON WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM S 9200 jam A40G AD 56 SN 323788 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampe office	Agus Hadi Hariyono	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-03-13 15:14	2023-03-13 15:17	2023-03-31 08:25	2023-03-31 09:10	2023-03-31 08:25	2023-03-31 09:10	2023-03-31 10:10	2023-03-31 10:46	2023-03-31 10:49	1186.0	50.0	1.0	YES	2.0
2476.0	ADMIN	BRANCH	March	1678695399507	WOSD174648	TASIRAYA MUDA PRATAMA, CV	-	-	SDLG	E660FL	625753	700	WARRANTY	BREAKDOWN	-	LAYANA-PALU	PALU	Engine can not cranking alternator I E660FL SN625753	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di office	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-03-13 15:16	2023-03-13 15:17	2023-03-13 15:22	2023-03-13 16:15	2023-03-13 15:22	2023-03-13 16:15	2023-03-13 17:38	2023-03-14 07:43	2023-03-14 11:05	1186.0	59.0	2.0	YES	0.0
2477.0	ADMIN	BRANCH	March	1678697431020	WO23174041	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	323790	8800	WARRANTY	STANDBY	-	MUARA LAWAI	MUARA ENIM	PM S 8800 jam A40G AD 57 SN 323790 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	Dimas Bayu Adji	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-03-13 15:50	2023-03-13 15:51	2023-03-31 09:11	2023-03-31 09:46	2023-03-31 09:11	2023-03-31 09:46	2023-03-31 10:11	2023-03-31 10:47	2023-03-31 10:50	1186.0	81.0	1.0	YES	0.0
2478.0	MECHANIC	MECHANIC	March	1678698501407	23174627	SARANA PRIMA MULTI NIAGA, PT	-	-	SDLG	L933L	606440	240	WARRANTY	RUNNING	2023-03-13 00:00:00.0000000	Cempaga bukit batu parenggean	BANJARMASIN	Inspection -take date -fhoto tyre ban depan kanan kiri -fhoto tyre ban belakang kanan kiri - location Job Mill PT.SPMN - kondition jalan unit -	ETC	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Redy	Muksim Triharyadi	Muksim Triharyadi	085246182601	muksimtrharyadi@gmail.com	2023-03-13 16:08	2023-03-13 16:08	2023-03-13 16:09	2023-03-14 10:17	2023-03-13 16:09	2023-03-14 10:17	2023-03-22 23:10	2023-03-22 23:11	2023-03-22 23:11	1186.0	1089.0	223.0	YES	0.0
2479.0	ADMIN	BRANCH	March	1678698993080	23175078	BUKIT BARISAN INDAH PRIMA, PT	-	-	SDLG	G9138	600438	1000	NON WARRANTY	RUNNING	-	SENGETI	JAMBI	TROUBLE SHOOTING BRAKE &PANEL OFF	BRAKE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job competed jam 21.30 tgl 15-03-2023 note, di lokasi tidak ada jaringan	Teten Kurniyawan	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-03-13 16:16	2023-03-13 16:16	2023-03-14 10:08	2023-03-14 21:53	2023-03-15 08:44	2023-03-16 08:02	2023-03-16 08:04	2023-03-16 08:04	2023-03-16 08:05	1186.0	1777.0	29.0	YES	0.0
2480.0	BRANCH	BRANCH	March	1678701152174	WO23175261	PEC TECH SERVICES INDONESIA, PT.	-	-	VT	FH16 64T	A313883	-	STOCK	STANDBY	-	ARKHA - CIBINONG	JAKARTA	PTSI Arkha : Prepare and PDI unit A313883	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	13-03-23 17.15 wib tiba di workshop PDI lanjut besok atau menunggu plotingan selanjutnya	Mochamad Aniqun Umar Farauq	Rahman Dendi	081388101230	rahman_dendi@yahoo.com	2023-03-13 16:52	2023-03-13 16:52	2023-03-14 08:02	2023-03-14 08:03	2023-03-14 08:02	2023-03-14 08:03	2023-03-14 08:05	2023-03-14 08:06	2023-03-21 10:40	1186.0	911.0	15.0	YES	0.0