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
4950.0	ADMIN	BRANCH	June	1685764928512	WO23180418	INTERTRANS SEJAHTERA, PT.	-	-	VCE	EC200D	250347	1	WARRANTY	RUNNING	-	PALEMBANG	PALEMBANG	Commisioning new machine	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive office palembang	Edy Nugroho	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-03 11:02	2023-06-03 11:02	2023-06-03 11:03	2023-06-03 11:42	2023-06-03 11:03	2023-06-03 11:42	2023-06-03 21:29	-	2023-06-05 08:49	1121.0	41.0	10.0	YES	0.0
4951.0	ADMIN	BRANCH	June	1685937677519	WO23180610	I MADE SUDARSANA	-	-	SDLG	L956F	625016	1000	WARRANTY	STANDBY	2023-06-05 00:00:00.0000000	Bali	SURABAYA	Service 1000 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Andi Sunaryo	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-06-05 11:01	2023-06-05 11:01	2023-06-05 12:01	2023-06-05 12:02	2023-06-05 12:01	2023-06-05 12:02	2023-06-05 15:42	2023-06-05 18:01	2023-06-06 16:42	1119.0	61.0	4.0	YES	0.0
4952.0	ADMIN	BRANCH	June	1685941103981	WO23179777	PRIMA SARANA MUSTIKA, PT	-	-	SDLG	E6138F	606450	1	WARRANTY	RUNNING	-	MUARA MERANG	PALEMBANG	COMMISIONING NEW MACHINE	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	finis job	Edy Nugroho	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-06-05 11:58	2023-06-05 12:00	2023-06-05 12:03	2023-06-07 15:50	2023-06-05 12:03	2023-06-07 15:50	2023-06-07 22:18	2023-06-07 22:19	2023-06-07 22:19	1119.0	3113.0	58.0	YES	1.0
4953.0	ADMIN	BRANCH	June	1685952577411	WO23179939	TERMINAL PETIKEMAS SURABAYA, PT	-	-	VT	FM44064R	A889803	6239	WARRANTY	STANDBY	2023-06-05 00:00:00.0000000	Surabaya	SURABAYA	Warranty Selenoid Valve	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Nur Riyanto	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-06-05 15:09	2023-06-05 15:33	2023-06-05 15:38	2023-06-05 16:33	2023-06-05 15:38	2023-06-05 16:33	2023-06-06 09:40	2023-06-06 15:02	2023-06-07 08:34	1119.0	84.0	18.0	YES	23.0
4954.0	ADMIN	BRANCH	June	1685953177025	WO23180656	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606645	5.7	STOCK	RUNNING	-	W/S PEKANBARU	PEKANBARU	PDI unit	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	back to shop	INDRA MAHDI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-06-05 15:19	2023-06-05 15:21	2023-06-05 15:28	2023-06-05 15:30	2023-06-05 15:28	2023-06-05 15:30	2023-06-05 15:57	2023-06-05 16:00	2023-06-05 16:05	1119.0	11.0	0.0	YES	1.0
4955.0	MECHANIC	MECHANIC	June	1686007746301	-	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	899295	5000	WARRANTY	RUNNING	2023-06-06 00:00:00.0000000	batuah	SAMARINDA	VT70 ps1000h	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-06-06 06:29	2023-06-06 06:30	2023-06-06 06:30	2023-06-06 08:54	2023-06-06 06:30	2023-06-06 08:54	2023-06-06 18:30	2023-06-06 19:28	2023-06-06 19:28	1119.0	146.0	12.0	YES	1.0
4956.0	ADMIN	BRANCH	June	1686015900193	WO23180659	ASRI PANCAWARNA, PT	-	-	SDLG	LG936L	605628	12253.3	NON WARRANTY	RUNNING	-	DAWUAN	JAKARTA	PM 8250	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	DONE	Septian Dwi Handarian	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-06-06 08:45	2023-06-06 08:45	2023-06-06 09:43	2023-06-06 11:54	2023-06-06 09:43	2023-06-06 11:54	2023-06-06 14:34	2023-06-06 16:38	2023-06-06 17:05	1119.0	189.0	5.0	YES	0.0
4957.0	ADMIN	BRANCH	June	1686016063438	WO23180672	BERKAT ANUGERAH AGUNG, PT	-	-	SDLG	L956F	624725	2000	WARRANTY	RUNNING	2023-06-06 00:00:00.0000000	Gresik	SURABAYA	Service 2000 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Wahyudiono	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-06-06 08:47	2023-06-06 08:47	2023-06-06 08:50	2023-06-06 13:14	2023-06-06 08:50	2023-06-06 13:14	2023-06-06 21:32	-	2023-06-06 21:33	1119.0	267.0	11.0	YES	0.0
4958.0	MECHANIC	MECHANIC	June	1686017155135	WO23180676	JAPFA COMFEED INDONESIA TBK, PT	-	-	SDLG	L956F	601662	8891	NON WARRANTY	BREAKDOWN	2023-06-06 00:00:00.0000000	tanjung bintang	LAMPUNG	MIP unit	ETC	INSPECTION	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Pekerjaan selesai	Heri Sucipto	Heri Sucipto	081373645025	herisucipto135@gmail.com	2023-06-06 09:05	2023-06-06 09:06	2023-06-06 09:06	2023-06-06 10:46	2023-06-06 09:06	2023-06-06 10:46	2023-06-06 14:36	2023-06-07 08:49	2023-06-30 09:37	1118.0	101.0	5.0	YES	0.0
4959.0	MECHANIC	MECHANIC	June	1686017336430	23180566	BUKIT ASAM ( Persero ) TBK., PT	-	-	VCE	EC480DL	275473	22085.7	NON WARRANTY	RUNNING	2023-06-06 00:00:00.0000000	pit 2 PT BA	MUARA ENIM	pm service 22.000 hours	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Ready	Muhammad Akhyar Alfarizi	Muhammad Akhyar Alfarizi	085878305740	akhyaralfarizi12@gmail.com	2023-06-06 09:08	-	2023-06-06 09:09	2023-06-06 09:43	2023-06-06 09:09	2023-06-06 09:43	2023-06-06 17:59	2023-06-06 17:59	2023-06-06 18:00	1118.0	34.0	8.0	YES	-