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
3190.0	ADMIN	BRANCH	March	1680165912070	WO23175874	SARANA PRIMA MULTI NIAGA, PT	-	-	SDLG	LG933L	606440	750	WARRANTY	RUNNING	2023-03-30 00:00:00.0000000	.	BANJARMASIN	SERVICE 750	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Unit RFU	Adit Tia Pratama	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-03-30 15:45	2023-03-30 15:45	2023-04-24 11:04	2023-04-24 11:04	2023-04-24 11:04	2023-04-24 11:04	2023-04-24 11:05	2023-04-24 11:05	2023-04-24 11:06	1186.0	35720.0	595.0	YES	0.0
3191.0	BRANCH	BRANCH	March	1680166038678	WO23175975	GUNUNG MAS GROUP, PT	-	-	VT	FMX40064R-ISHIFT	A315261	-	STOCK	STANDBY	-	MMS - BEKASI	JAKARTA	Prepare and PDi unit, replace windscreen A315261 at MMS - Bekasi	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Remove windscreen	Rahman Dendi	Rahman Dendi	081388101230	rahman_dendi@yahoo.com	2023-03-30 15:47	2023-03-30 15:47	2023-04-02 09:17	2023-04-02 09:59	2023-04-02 09:17	2023-04-02 09:59	2023-04-02 14:11	2023-04-02 15:06	2023-04-02 15:07	1186.0	3972.0	70.0	YES	0.0
3192.0	ADMIN	BRANCH	March	1680166166481	WOCE175958	HILLCONJAYA SAKTI, PT	-	-	VCE	R100E	111018	4291	NON WARRANTY	RUNNING	2023-03-30 00:00:00.0000000	.	BANJARMASIN	PARKING BREAKE ABNORMAL R100E SN111018	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	6-04-23	eko supri	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-03-30 15:49	2023-03-30 15:49	2023-04-01 07:21	2023-04-01 07:21	2023-04-01 07:21	2023-04-01 07:21	2023-04-18 10:42	2023-04-18 10:42	2023-04-18 10:42	1186.0	2372.0	450.0	YES	0.0
3193.0	ADMIN	BRANCH	March	1680167147194	WO23175988	AGUNGGLORY CARGOTAMA, PT	-	-	VT	FMX44064R	A698148	21234	NON WARRANTY	RUNNING	-	TUGU	JAKARTA	Replace control unit B 9963 UIZ‬‬‬	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job dome	Eko Suharyanto	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-03-30 16:05	2023-03-30 16:06	2023-04-03 11:11	2023-04-03 13:41	2023-04-03 11:11	2023-04-03 13:41	2023-04-03 13:48	2023-04-03 13:52	2023-04-03 13:52	1186.0	5616.0	93.0	YES	0.0
3194.0	ADMIN	BRANCH	March	1680225169566	WO23176000	SURYABUMI AGRO LANGGENG, PT	-	-	SDLG	L936L	606388	-	NON WARRANTY	RUNNING	-	TALANG UBI	MUARA ENIM	Install part backlog L936L SN 606388 SA	BRAKE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai office	Janu Ramadhan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-03-31 08:12	2023-03-31 08:13	2023-03-31 08:39	2023-03-31 14:32	2023-04-03 11:55	2023-04-03 16:13	2023-04-03 18:34	2023-04-03 19:49	2023-04-05 09:57	1186.0	380.0	12.0	YES	0.0
3195.0	ADMIN	BRANCH	March	1680226945985	WO23176021	SUMI GITA JAYA PT	-	-	VCE	EC210D	252897	1087	WARRANTY	RUNNING	-	DURI	PEKANBARU	Service 1000 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	kembali	INDRA MAHDI	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-03-31 08:42	2023-03-31 08:42	2023-03-31 15:24	2023-03-31 18:56	2023-03-31 15:24	2023-03-31 18:56	2023-04-04 19:02	2023-04-05 13:09	2023-04-14 15:05	1186.0	614.0	106.0	YES	0.0
3196.0	ADMIN	BRANCH	March	1680230202703	WO23175464	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898876	-	NON WARRANTY	RUNNING	-	BATUAH SITE TMU	SAMARINDA	PERIODIC SERVICE 4000 HRS	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-03-31 09:36	2023-03-31 09:37	2023-03-31 09:38	2023-03-31 13:07	2023-03-31 09:38	2023-03-31 13:07	2023-03-31 18:09	2023-04-03 11:47	2023-04-03 11:47	1185.0	211.0	8.0	YES	0.0
3197.0	ADMIN	BRANCH	March	1680230867166	WOCE176031	ASTON PRIMA RAYA, PT	-	-	VCE	DD100	50947	180	WARRANTY	RUNNING	-	KARAWANG	JAKARTA	checking parking brake switch burn in	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Ibnu Nasir	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-03-31 09:47	2023-03-31 09:48	2023-03-31 10:17	2023-03-31 14:55	2023-03-31 10:17	2023-03-31 14:55	2023-03-31 17:16	2023-04-03 20:11	2023-04-03 20:11	1185.0	308.0	7.0	NO	0.0
3198.0	ADMIN	BRANCH	March	1680231135651	WO23174736	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	898731	4250	NON WARRANTY	RUNNING	-	BATUAH SITE TMU	SAMARINDA	PERIODIC SERVICE 250 HRS	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-03-31 09:52	2023-03-31 09:54	2023-03-31 09:55	2023-03-31 13:07	2023-03-31 09:55	2023-03-31 13:07	2023-03-31 18:09	-	2023-04-03 11:47	1185.0	195.0	8.0	YES	1.0
3199.0	BRANCH	BRANCH	March	1680237372418	WOCE174455	BAYU KARSA UTAMA, PT	-	-	VCE	SD110	59273	1365	WARRANTY	RUNNING	-	SANGGAU LEDO	PONTIANAK	campaign job RRP60	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	mechanic arrive office ITU pontianak	catur muhamad rahmadhan	Ferlya Juliza Admin Pontianak	081545464290	ferlyajulizaa@gmail.com	2023-03-31 11:36	2023-03-31 11:36	2023-03-31 11:36	2023-04-05 16:05	2023-03-31 11:36	2023-04-05 16:05	2023-04-06 18:54	2023-04-08 21:06	2023-04-10 10:49	1185.0	7469.0	151.0	YES	0.0