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
2600.0	ADMIN	BRANCH	March	1678849342652	WO23174755	TIGER ENERGY SERVICES ROI, PT	-	-	VT	FM37064T	YV2XSG0DXHB829362	-	NON WARRANTY	RUNNING	-	DIENG, WONOSOBO	SEMARANG	YV2XSG0DXHB829362 WO23174755 T/S Transmission System. Abnormal air system VT NPS ENERGY INDONESIA, PT. 2564 ITU-000006748 SRWE Invoiced Triyono Smg 3/15/2023 18.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-03-15 10:02	2023-03-15 10:07	2023-03-15 10:07	2023-03-15 10:07	2023-03-15 10:07	2023-03-15 10:07	2023-03-17 13:49	2023-03-17 13:50	2023-03-17 13:50	1201.0	5.0	51.0	YES	5.0
2601.0	ADMIN	BRANCH	March	1678849545855	WO23174763	AKR TRANSPORTASI INDONESIA, PT	-	-	VT	FM37064T-AS	YV2XM30D8GB778493	-	NON WARRANTY	RUNNING	-	SEMARANG	SEMARANG	YV2XM30D8GB778493 WO23174763 REPLACE CYLINDER HEAD, INHIBITOR & HOSE B9739BEI VT AKR TRANSPORTASI INDONESIA, PT 0038 ITU-000005913 SRWE Created Triyono Smg 3/15/2023 11.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-03-15 10:05	2023-03-15 10:08	2023-03-15 10:08	2023-03-15 10:08	2023-03-15 10:08	2023-03-15 10:08	2023-03-17 14:02	2023-03-17 14:03	2023-03-17 14:03	1201.0	3.0	51.0	YES	2.0
2602.0	MECHANIC	MECHANIC	March	1678852975896	174762	ADHIMIX RMC INDONESIA, PT.	-	-	SDLG	LG956F	624028	1000	WARRANTY	RUNNING	2023-03-15 00:00:00.0000000	SENTUL	JAKARTA	INSTALL FAN CONDENSOR AND EXAUST MANIFOLD GASKET	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	done	Septian Dwi Handarian	Septian Dwi Handarian	081314420039	septiandwihandarian@gmail.com	2023-03-15 11:02	-	2023-03-15 11:03	2023-03-15 13:12	2023-03-15 11:03	2023-03-15 13:12	2023-03-15 14:52	2023-03-15 16:49	2023-03-15 16:49	1201.0	129.0	3.0	YES	-
2603.0	MECHANIC	MECHANIC	March	1678856071974	WO23174359	MANADO KARYA ANUGRAH, PT.	-	-	VCE	L120F	26697	11602	WARRANTY	BREAKDOWN	2023-03-15 00:00:00.0000000	site Tika tindung	MANADO	injector ubnormal	ENGINE	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	job completed	Hari Manaf Pongoliu	Hari Manaf Pongoliu	081241576651	irahanafiah23@gmail.com	2023-03-15 11:54	2023-03-15 11:54	2023-04-14 10:20	2023-04-14 10:20	2023-04-14 10:20	2023-04-14 10:20	2023-04-14 10:21	2023-04-14 10:21	2023-04-14 10:22	1201.0	43106.0	718.0	YES	0.0
2604.0	ADMIN	BRANCH	March	1678863498184	WO23174408	INDOTRUCK UTAMA, PT.	-	-	SDLG	E660FL	625852	4	STOK	RUNNING	2023-03-15 00:00:00.0000000	Workshop ITU Medan	MEDAN	PDI	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Completed	Joko Firman Nababan	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-03-15 13:58	2023-03-15 13:59	2023-03-15 19:56	2023-03-16 05:46	2023-03-15 19:56	2023-03-16 05:46	2023-03-16 16:36	2023-03-21 09:29	2023-03-21 09:30	1201.0	948.0	26.0	YES	1.0
2605.0	ADMIN	BRANCH	March	1678866602380	WO23175833	NILAM BASTEM MUSTADIR, CV	-	-	SDLG	E680F	607239	10	WARRANTY	RUNNING	2023-03-15 00:00:00.0000000	Luwu	MAKASSAR	Commissioning and field guidance	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Marcel Kelvin	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-03-15 14:50	2023-03-15 14:50	2023-04-02 07:35	2023-04-02 10:04	2023-04-02 07:35	2023-04-02 10:04	2023-04-02 11:43	2023-04-02 13:15	2023-04-02 13:46	1201.0	25635.0	428.0	YES	0.0
2606.0	ADMIN	BRANCH	March	1678867904436	WO23176791	ETEX BUILDING PERFORMANCE, INDONESIA, PT	-	-	VCE	L60F	7015	-	NON WARRANTY	RUNNING	2023-03-15 00:00:00.0000000	Gresik	SURABAYA	Replace Glass Cabin	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Andi Sunaryo	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-03-15 15:11	2023-03-15 15:12	2023-04-19 10:54	2023-04-19 12:58	2023-04-19 10:54	2023-04-19 12:58	2023-04-19 20:42	2023-04-19 20:43	2023-04-27 11:49	1201.0	351.0	13.0	YES	0.0
2607.0	ADMIN	BRANCH	March	1678871634560	WO23175362	KALIMANTAN INTI MAJU, PT	-	-	SDLG	G9138	600516	2972	WARRANTY	RUNNING	-	BATU AMPAR, KAB KUTAI TIMUR	SANGATTA	REPLACE SHAFT GEAR, PLATE WORN AND WEAR PLATE	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Sangatta Admin	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-03-15 16:13	2023-03-15 16:14	2023-03-15 16:21	2023-03-20 07:16	2023-03-15 16:21	2023-03-20 07:16	2023-03-22 10:14	2023-03-22 14:21	2023-03-22 14:22	1201.0	6663.0	162.0	YES	0.0
2608.0	MECHANIC	BRANCH	March	1678927339707	WO23174368	HILLCONJAYA SAKTI, PT	-	-	VCE	SD110	59397	5	WARRANTY	RUNNING	-	MOROWALI UTARA	KENDARI	Commissioning Unit	ECT	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	travell back to office	RAHMAN GUSTI YAKSA	RAHMAN GUSTI YAKSA	082297097655	gustiyaksaaa20@gmail.com	2023-03-16 07:42	2023-03-16 07:43	2023-03-16 07:53	2023-03-16 16:40	2023-03-16 07:53	2023-03-16 16:40	2023-03-17 16:54	2023-03-20 07:37	2023-03-20 07:38	1201.0	538.0	33.0	YES	0.0
2609.0	ADMIN	BRANCH	March	1678927524065	WO23174859	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606441	4	STOK	STANDBY	2023-03-16 00:00:00.0000000	Balikpapan	BALIKPAPAN	PDI LG933L SN606441 HM4	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	a	Muklis	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-03-16 07:45	2023-03-16 07:45	2023-03-16 07:46	2023-03-16 07:47	2023-03-16 09:44	2023-03-16 07:47	2023-03-16 09:55	2023-03-16 09:55	2023-03-16 09:55	1201.0	2.0	2.0	YES	0.0