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
3790.0	ADMIN	BRANCH	April	1682669984681	WO23177938	PRASADHA PAMUNAH LIMBAH INDUSTRI, PT	-	-	VT	FMX40064R	643368	1.61065e+006	NON WARRANTY	STANDBY	-	NAROGONG	JAKARTA	Replace cover bracket release fork include install gearbox unit 7006	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job done replace release fork and housing reseal servo clutch	Eko Suharyanto	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-04-28 15:19	2023-04-28 15:20	2023-04-28 15:20	2023-04-28 15:20	2023-04-29 11:32	2023-04-29 12:45	2023-04-29 15:50	2023-04-29 17:26	2023-05-02 09:02	1157.0	1.0	0.0	NO	0.0
3791.0	ADMIN	BRANCH	April	1682671957966	WO23176563	GUNUNG HARTA TRANSPORT SOLUTIONS, PT.	-	-	VB	B11R	209683	-	NON WARRANTY	STANDBY	2023-04-28 00:00:00.0000000	Malang	SURABAYA	Install Hydraulic Jack 10 Ton	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	closed	Faisal Abdul Rosid	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-04-28 15:52	2023-04-28 15:52	2023-05-02 08:39	2023-05-02 14:24	2023-05-02 08:39	2023-05-02 14:24	2023-05-02 15:01	2023-05-02 17:03	2023-05-03 08:19	1157.0	5671.0	95.0	YES	0.0
3792.0	MECHANIC	MECHANIC	April	1682740728292	2317791	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R	DT 04 - AA302342	2555	WARRANTY	BREAKDOWN	2023-04-29 00:00:00.0000000	msf appt1	MUARA ENIM	error transmisi	TRANSMISSION	REPAIR	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	continue next day	Budi Nur Andika	Budi Nur Andika	081354014449	budinurandika@gmail.com	2023-04-29 10:58	2023-04-29 10:59	-	-	-	-	-	-	2023-04-29 17:57	1156.0	-	-	NO	0.0
3793.0	MECHANIC	MECHANIC	April	1682752483586	WO23178457	SAMUDERA MULIA ABADI, PT	-	-	VCE	A60H	320511	2388	WARRANTY	BREAKDOWN	2023-04-29 00:00:00.0000000	Bakan	MANADO	Inspection Engine Oil Mixed Fuel	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive in Branch	Herdiyansyah	Herdiyansyah	081315175335	herdiyansyahhetik@gmail.com	2023-04-29 14:14	2023-04-29 14:17	2023-04-29 14:17	2023-04-29 14:17	2023-04-29 14:17	2023-04-29 14:17	2023-04-29 18:14	2023-04-29 18:14	2023-05-05 15:30	1156.0	3.0	4.0	YES	2.0
3794.0	ADMIN	BRANCH	April	1682769191990	WOCE177768	UNGGUL DINAMIKA UTAMA, PT	-	-	VCE	R100E	111055	1915	WARRANTY	RUNNING	2023-04-29 00:00:00.0000000	Kaliorang	SANGATTA	Campaign unit R100E	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	frt	Soedarto Mesak Palallo	Sangatta Admin	82354650329	sangatta.sbs@indotruck-utama.co.id	2023-04-29 18:53	2023-04-29 18:54	2023-05-24 07:25	2023-05-24 15:49	2023-05-24 07:25	2023-05-24 15:49	2023-05-25 13:32	2023-05-31 08:09	2023-05-31 08:13	1156.0	35816.0	618.0	YES	1.0
3795.0	ADMIN	BRANCH	April	1682770730095	WO23177886	ULIMA NITRA, PT	-	-	VCE	EC480DL	279268	23500	NON WARRANTY	STANDBY	-	BANKO	MUARA ENIM	S 23500 HM AB 146	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	Gabby Hade Octafiando	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-29 19:18	2023-04-29 19:19	2023-05-02 11:50	2023-05-02 13:25	2023-05-02 11:50	2023-05-02 13:25	2023-05-02 16:10	2023-05-02 16:10	2023-05-02 16:13	1156.0	107.0	4.0	YES	0.0
3796.0	ADMIN	BRANCH	April	1682771234928	WO23177933	WAHANA BANDHAWA KENCANA, PT	-	-	VCE	A60H	320070	1	NON WARRANTY	STANDBY	-	LAHAT	MUARA ENIM	Engine WAT 03	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	maaf lambat update,sinyal susah	Gabby Hade Octafiando	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-29 19:27	2023-04-29 19:27	2023-05-02 16:32	2023-05-03 16:16	2023-05-02 16:32	2023-05-03 16:16	2023-05-03 16:17	2023-05-03 16:17	2023-05-03 16:19	1156.0	1435.0	23.0	YES	0.0
3797.0	ADMIN	BRANCH	April	1682567497088	WO23176985	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	895868	3500	NON WARRANTY	RUNNING	-	BATUAH	SAMARINDA	SERVICE 500 HRS VT 075	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	done	Muhammad Ishak	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-04-27 10:51	2023-04-27 10:52	2023-04-27 10:52	2023-04-27 13:21	2023-04-27 10:52	2023-04-27 13:21	2023-04-27 17:15	2023-04-27 20:29	2023-04-27 20:29	1158.0	149.0	6.0	YES	0.0
3798.0	MECHANIC	MECHANIC	April	1682575204071	0	GEOPERSADA MULIA ABADI, PT.	-	-	VCE	A40G	323814	10890	NON WARRANTY	BREAKDOWN	2023-04-27 00:00:00.0000000	site tokatindung	MANADO	performance test unit	TRANSMISSION	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	back	Hari Manaf Pongoliu	Hari Manaf Pongoliu	081241576651	irahanafiah23@gmail.com	2023-04-27 13:00	2023-04-27 13:00	2023-04-27 13:00	2023-04-27 13:01	2023-05-03 04:49	2023-05-03 06:39	2023-05-04 09:50	2023-05-05 13:32	2023-05-31 11:34	1158.0	1.0	164.0	YES	0.0
3799.0	ADMIN	BRANCH	April	1682575389347	WOSD177907	REA KALTIM PLANTATIONS	-	-	SDLG	LG936L	607243	1333	WARRANTY	RUNNING	2023-04-27 00:00:00.0000000	Kembang Janggut	BALIKPAPAN	Inspection Engine Low pressure LG936L SN607243 PT REA	ENGINE	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	ok	Muklis	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-04-27 13:03	2023-04-27 13:03	2023-04-27 13:28	2023-04-27 23:49	2023-04-27 13:28	2023-04-27 23:49	2023-05-01 06:04	2023-05-01 19:51	2023-05-02 12:37	1158.0	647.0	89.0	YES	0.0