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
2030.0	BRANCH	BRANCH	February	1677481077670	23172375	MUH. THAMRIN. H. R	-	-	VCE	EC210D	253395	-	WARRANTY	RUNNING	2023-02-27 00:00:00.0000000	Jayapura	SORONG	Mandatory Service 250 Hours for unit EC210D (253395) an. Muh. H. Thamrin	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	Service koordinator (Sorong - Nusa tenggara)	Trifenia Soukotta	081240668088	admin.sorong@indotruck-utama.co.id	2023-02-27 13:57	2023-02-27 13:58	2023-02-27 14:03	2023-02-27 14:04	2023-02-27 14:03	2023-02-27 14:04	2023-02-27 14:12	2023-02-27 14:13	2023-02-28 08:18	1217.0	6.0	0.0	YES	0.0
2031.0	BRANCH	BRANCH	February	1677481107158	WOCE173715	LEO JULIEN ST	-	-	VCE	EC210B	283695	0	WARRANTY	BREAKDOWN	2023-02-27 00:00:00.0000000	site bju	BERAU	replce fuel regulator	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	JOB COMPLETED	Socheb Sukmawan	Andry saputra	081350000494	andrysaputralp3i@gmail.com	2023-02-27 13:58	2023-02-27 13:58	2023-02-27 14:47	2023-02-27 16:36	2023-02-27 14:47	2023-02-27 16:36	2023-02-27 17:58	2023-02-27 18:31	2023-02-27 20:22	1217.0	158.0	4.0	NO	0.0
2032.0	BRANCH	BRANCH	February	1677485246409	WO23176486	KALIMANTAN AGRO PUSAKA, PT.	-	-	SDLG	LG933L	604217	4906	NON WARRANTY	RUNNING	-	KETAPANG	PONTIANAK	troubleshooting	ELECTRICAL	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	catur muhamad rahmadhan	Ferlya Juliza Admin Pontianak	081545464290	ferlyajulizaa@gmail.com	2023-02-27 15:07	2023-02-27 15:07	2023-02-27 15:07	2023-02-28 15:55	2023-02-28 08:37	2023-02-28 15:55	2023-03-02 12:42	2023-03-03 17:59	2023-03-06 07:21	1217.0	1488.0	69.0	YES	0.0
2033.0	ADMIN	BRANCH	February	1677491009567	WO23172676	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324219	6000	WARRANTY	STANDBY	-	MUARA LAWAI	MUARA ENIM	PM S 6000 jam AD58 SN 324219 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Finished	Aditya Ryan Saputra	Berry David Admin Muara Enim	085265537075	beictus@gmail.com	2023-02-27 16:43	2023-02-27 16:45	2023-02-28 18:25	2023-02-28 19:07	2023-02-28 18:25	2023-02-28 19:07	2023-02-28 22:05	2023-02-28 22:19	2023-02-28 22:24	1217.0	1584.0	29.0	YES	2.0
2034.0	ADMIN	BRANCH	February	1677497501059	WO23172840	ALFERO MINERAL SEJAHTERA, PT	-	-	VCE	EC210D	282239	1	NON WARRANTY	RUNNING	-	LAHAT	MUARA ENIM	Inspection & Troubleshooting Fuel sys EC210D SN 282239 AMS	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Finished	Gabby Hade Octafiando	Berry David Admin Muara Enim	085265537075	beictus@gmail.com	2023-02-27 18:31	2023-02-27 18:32	2023-02-28 18:36	2023-02-28 18:52	2023-02-28 18:36	2023-02-28 18:52	2023-02-28 21:34	2023-02-28 21:48	2023-02-28 22:43	1217.0	1461.0	27.0	YES	0.0
2035.0	ADMIN	BRANCH	February	1677547779047	WO23173419	INDOTRUCK UTAMA, PT.	-	-	VCE	EC210D	283662	13	WARRANTY	STANDBY	-	ITU PALU	PALU	Maintenance Unit Stock	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive in branch office	Ahmad Jafar M	Lucky Yotari Admin Palu	081298128289	lucky.yotari@indotruck-utama.co.id	2023-02-28 08:29	2023-02-28 08:30	2023-02-28 08:31	2023-02-28 08:34	2023-02-28 08:31	2023-02-28 08:34	2023-02-28 08:45	2023-02-28 08:46	2023-02-28 12:49	1217.0	5.0	0.0	YES	0.0
2036.0	BRANCH	BRANCH	February	1677548078601	23173694	INTERNUSA PAPUA RAYA, PT	-	-	SDLG	G9138	600606	7	WARRANTY	RUNNING	2023-02-28 00:00:00.0000000	Bintuni	SORONG	Commissioning unit G9138F (600606) - PT. Internusa Papua Raya	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	Rheno Bayu Saputro	Trifenia Soukotta	081240668088	admin.sorong@indotruck-utama.co.id	2023-02-28 08:34	2023-02-28 08:37	2023-02-28 08:42	2023-03-03 07:19	2023-02-28 08:42	2023-03-03 07:19	2023-03-07 07:16	2023-03-08 07:26	2023-03-09 09:34	1217.0	4245.0	166.0	YES	2.0
2037.0	BRANCH	MECHANIC	February	1677548641523	23173695	INTERNUSA PAPUA RAYA, PT	-	-	SDLG	E6210F	609297	-	WARRANTY	RUNNING	2023-02-28 00:00:00.0000000	Bintuni	SORONG	Mandatory Service 500 Hours for unit E6210F (609297) - PT. Internusa Papua Raya.	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	selesai	Rheno Bayu Saputro	Trifenia Soukotta	081240668088	admin.sorong@indotruck-utama.co.id	2023-02-28 08:44	2023-02-28 08:45	2023-02-28 15:35	2023-03-02 09:31	2023-02-28 15:35	2023-03-02 09:31	2023-03-03 07:18	2023-03-08 07:24	2023-03-09 09:35	1217.0	2928.0	70.0	YES	1.0
2038.0	ADMIN	BRANCH	February	1677549332062	WO23174083	SAMARA PROPERTI INDONESIA, PT	-	-	SDLG	E680F	607245	249	WARRANTY	RUNNING	-	MOROWALI	PALU	Service 250 HM	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	ARRIVE to office	Ahmad Jafar M	Lucky Yotari Admin Palu	081298128289	lucky.yotari@indotruck-utama.co.id	2023-02-28 08:55	2023-02-28 08:55	2023-02-28 09:10	2023-03-01 08:25	2023-02-28 09:10	2023-03-01 08:25	2023-03-02 07:10	2023-03-02 18:01	2023-03-03 13:16	1217.0	1410.0	46.0	YES	0.0
2039.0	ADMIN	BRANCH	February	1677549575857	WO23174286	INTERNATIONAL GREEN ENERGY PT	-	-	VCE	EC200D	280447	4785	NON WARRANTY	BREAKDOWN	-	BUTON	PEKANBARU	Fuel system problem	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	DARMO SUWITO	Amrizon PEKANBARU ADMIN	08127600946	kalman-admpku@indotruck-utama.co.id	2023-02-28 08:59	2023-02-28 08:59	2023-03-07 09:47	2023-03-07 13:25	2023-03-07 09:47	2023-03-07 13:25	2023-03-08 11:55	2023-03-08 16:39	2023-03-10 11:30	1217.0	273.0	27.0	YES	0.0