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
5250.0	MECHANIC	MECHANIC	June	1686628857642	cc23181109	BUKIT ASAM ( Persero ) TBK., PT	-	-	VCE	EC480DL	275437	22044.5	NON WARRANTY	STANDBY	2023-06-13 00:00:00.0000000	CSA PIT 2	MUARA ENIM	PM 22.000 HM EC480 D exca 08	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	Service 22000 hm	Aris Setiawan	Aris Setiawan	081373856720	arissetya748@gmail.com	2023-06-13 11:00	-	-	-	-	-	-	-	2023-06-13 20:10	1111.0	-	-	YES	-
5251.0	ADMIN	BRANCH	June	1686629775973	WO23181873	ANGKASA SAKTI, PT.	-	-	SDLG	L958F	625342	4.8	Stock	RUNNING	-	BANTUAS	SAMARINDA	COMMISIONING UNIT BARU	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Amanda Prestyandi	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-06-13 11:16	2023-06-13 11:17	2023-06-13 11:17	2023-06-13 12:46	2023-06-13 11:17	2023-06-13 12:46	2023-06-13 19:16	2023-06-14 02:16	2023-06-14 02:23	1111.0	90.0	8.0	YES	0.0
5252.0	ADMIN	BRANCH	June	1686635319974	WO23182317	KALIMANTAN INTI MAJU, PT	-	-	SDLG	G9138	600503	3280	NON WARRANTY	BREAKDOWN	-	KARANGAN	SANGATTA	INSPECTION UNIT G9138 SN.600503	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Sangatta Admin	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-06-13 12:48	2023-06-13 12:48	2023-06-21 10:39	2023-06-24 10:28	2023-06-21 10:39	2023-06-24 10:28	2023-06-26 11:21	2023-06-27 07:09	2023-06-28 17:49	1111.0	15700.0	310.0	YES	0.0
5253.0	ADMIN	BRANCH	June	1686636727081	WO23180892	CAKRAWALA KENCANA INDONESIA, PT	-	-	VCE	R100E	111080	1	WARRANTY	RUNNING	2023-06-13 00:00:00.0000000	BINUANG	BANJARMASIN	COMMISSIONING UNIT	ENGINE	INSPECTION	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	unit RFU	Gondo	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-06-13 13:12	2023-06-13 13:12	2023-06-14 06:06	2023-06-14 06:06	2023-06-14 06:06	2023-06-14 06:06	2023-06-15 09:52	2023-06-15 09:52	2023-06-15 09:53	1111.0	1015.0	44.0	YES	0.0
5254.0	ADMIN	BRANCH	June	1686637497907	WO23181252	INDOTRUCK UTAMA, PT.	-	-	VCE	EC200D	281345	11	WARRANTY	RUNNING	2023-06-13 00:00:00.0000000	Makassar	MAKASSAR	Maintenance Stock Unit	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Davit Witanto	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-06-13 13:24	2023-06-13 13:25	2023-06-13 13:27	2023-06-13 13:27	2023-06-13 13:27	2023-06-13 13:27	2023-06-13 16:05	2023-06-13 16:06	2023-06-14 09:15	1111.0	3.0	2.0	YES	0.0
5255.0	ADMIN	BRANCH	June	1686649979157	WO23181278	PANCARAN DARAT TRANSPORT, PT	-	-	VT	FM44084R	YV2XS02G0PA319167	250	WARRANTY	RUNNING	-	MARUNDA	JAKARTA	Campaign S2896 BBM, install YV2XS02G0PA319167	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Mochamad Aniqun Umar Farauq	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-06-13 16:52	2023-06-13 16:53	2023-06-14 07:22	2023-06-14 07:23	2023-06-14 07:22	2023-06-14 07:23	2023-06-14 07:23	2023-06-14 07:23	2023-06-15 08:53	1111.0	870.0	14.0	YES	0.0
5256.0	ADMIN	BRANCH	June	1686704221058	WO23181292	ALIRAN KETAHUN PERDANA, CV	-	-	SDLG	L956F	625014	755	WARRANTY	RUNNING	2023-06-14 00:00:00.0000000	Pelabuhan	BENGKULU	service 750	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Agus Nugroho	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-06-14 07:57	2023-06-14 07:57	2023-06-14 12:08	2023-06-14 13:07	2023-06-14 12:08	2023-06-14 13:07	2023-06-14 14:29	2023-06-14 20:32	2023-06-14 20:33	1111.0	310.0	6.0	YES	0.0
5257.0	ADMIN	BRANCH	June	1686706307477	WO23181259	PETROLINDO ENERGI PERKASA, PT	-	-	VCE	SD110	59403	7	WARRANTY	RUNNING	-	MEDAN	MEDAN	Mandatory Service 500 Hours SD110NE SN 59403	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	finish	Ferdian Dinata	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-06-14 08:31	2023-06-14 08:32	2023-06-14 13:09	2023-06-14 13:52	2023-06-14 13:09	2023-06-14 13:52	2023-06-14 17:06	2023-06-15 08:01	2023-06-15 08:02	1111.0	320.0	8.0	YES	0.0
5258.0	ADMIN	BRANCH	June	1686709666765	WO23181296	MUHTOMAS, PT.	-	-	SDLG	L933L	604226	2000	OTHERS	RUNNING	-	CIKARANG - JAWA BARAT	JAKARTA	PM 2000 HRS	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	DONE	Septian Dwi Handarian	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-06-14 09:27	2023-06-14 09:28	2023-06-14 09:29	2023-06-14 11:13	2023-06-14 09:29	2023-06-14 11:13	2023-06-14 17:00	2023-06-14 18:31	2023-06-15 08:51	1110.0	105.0	7.0	YES	0.0
5259.0	ADMIN	BRANCH	June	1686710117645	WO23180858	SANTOSA UTAMA LESTARI, PT.	-	-	SDLG	LG936L	606994	0	NON WARRANTY	STANDBY	2023-06-14 00:00:00.0000000	Sumbawa	SURABAYA	Replace Water Pump, Flushing Radiator, Service 500 Hours	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Ajik Pramusinta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-06-14 09:35	2023-06-14 09:35	2023-06-14 10:07	2023-06-14 21:52	2023-06-14 10:07	2023-06-14 21:52	2023-06-19 18:34	2023-06-21 09:08	2023-06-21 09:08	1110.0	738.0	128.0	YES	0.0