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
1720.0	MECHANIC	MECHANIC	February	1676463447705	0	HILLCONJAYA SAKTI, PT	-	-	VCE	A60H	320353	8311	WARRANTY	RUNNING	2023-02-15 00:00:00.0000000	HJS kota baru	BANJARMASIN	engine low power	ENGINE	INSPECTION	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	waiting part	Agus Riyanto	Agus Riyanto	081350801799	fakeagoes5@gmail.com	2023-02-15 19:17	2023-02-15 19:17	2023-02-15 19:18	2023-02-15 19:18	2023-02-15 19:18	2023-02-15 19:18	2023-02-15 19:19	2023-02-15 19:19	2023-02-15 19:20	1229.0	1.0	0.0	YES	0.0
1721.0	BRANCH	BRANCH	February	1676472440624	WO23176596	KENCANA INDAH INTI SEJAHTERA, PT.	-	-	VCE	SD110B	552161	0	NON WARRANTY	BREAKDOWN	2023-02-15 00:00:00.0000000	nangamau	PONTIANAK	install sparepart	ENGINE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrived ITU office	catur muhamad rahmadhan	Ferlya Juliza Admin Pontianak	081545464290	ferlyajulizaa@gmail.com	2023-02-15 21:47	2023-02-15 21:49	2023-02-15 21:49	2023-02-17 02:29	2023-02-16 08:19	2023-02-17 02:29	2023-02-17 13:12	2023-02-20 08:48	2023-02-20 14:00	1229.0	1722.0	39.0	YES	1.0
1722.0	ADMIN	BRANCH	February	1676509515409	23172911	SEMOGA JAYA LOEMINTOE INDONESIA, PT	-	-	SDLG	G9138	600582	99	WARRANTY	RUNNING	-	SANGKULIRANG, KAB KUTAI TIMUR	SANGATTA	SERVICE 100 HOUR SDLG G9138F SN.600582 HM.99	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Sofian Ghazali Rakhman	Christina	082354650329	svcadm.sangata@indotruck-utama.co.id	2023-02-16 08:05	2023-02-16 08:05	2023-02-16 08:16	2023-02-16 13:45	2023-02-16 08:16	2023-02-16 13:45	2023-02-17 08:03	2023-02-20 08:49	2023-02-20 08:49	1229.0	340.0	23.0	YES	0.0
1723.0	ADMIN	BRANCH	February	1676513039793	23173469	KALIMANTAN INTI MAJU, PT	-	-	SDLG	G9138	600516	2968	NON WARRANTY	RUNNING	-	BATU AMPAR, KAB KUTAI TIMUR	SANGATTA	INSPECTION AND CONTINUE JOB BLADE ABNORMAL SDLG G9138 SN.600516 HM.2968, PO NUMBER 42299	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Christina	Christina	082354650329	svcadm.sangata@indotruck-utama.co.id	2023-02-16 09:03	2023-02-16 09:04	2023-02-16 09:39	2023-02-16 15:37	2023-02-16 09:39	2023-02-16 15:37	2023-02-17 08:03	2023-02-22 15:14	2023-02-22 15:15	1228.0	393.0	23.0	YES	0.0
1724.0	ADMIN	BRANCH	February	1676516993352	WO23172922	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG936L	607244	5.8	STOCK	STANDBY	-	W/S PEKANBARU	PEKANBARU	Storage Maintenance	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	kembali	INDRA MAHDI	Amrizon PEKANBARU ADMIN	08127600946	kalman-admpku@indotruck-utama.co.id	2023-02-16 10:09	2023-02-16 10:10	2023-02-16 11:18	2023-02-16 11:19	2023-02-16 11:18	2023-02-16 11:19	2023-02-16 14:15	2023-02-16 14:40	2023-02-21 15:40	1228.0	69.0	4.0	YES	0.0
1725.0	BRANCH	BRANCH	February	1676519200259	WO23172846	AIR PRODUCTS INDONESIA, PT	-	-	VT	FM37064T	861278	89109	NON WARRANTY	RUNNING	-	CIKARANG	JAKARTA	Air product, Basic service III- B 9069 FEA	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Eko Suharyanto	Arief Wiratman JKT ADMIN	081316041299	arief.wiratman@indotruck-utama.co.id	2023-02-16 10:46	2023-02-16 10:46	2023-02-16 11:16	2023-02-16 12:20	2023-02-16 11:16	2023-02-16 12:20	2023-02-17 08:56	-	2023-02-17 08:56	1228.0	94.0	22.0	YES	0.0
1726.0	MECHANIC	BRANCH	February	1676525834168	WO23172951	USAHA MANDIRI TEHNIK, PT	-	-	VCE	EC210D	283568	1539	NON WARRANTY	RUNNING	2023-02-16 00:00:00.0000000	Serpong	CILEGON	Generall check and clean up injector gasket include test	ETC	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job Complete	Pujiyanto	Pujiyanto	087883728024	pujiyanto1257@yahoo.com	2023-02-16 12:37	2023-02-16 12:37	2023-02-16 13:02	2023-02-16 14:33	2023-02-20 08:39	2023-02-20 13:17	2023-02-20 17:12	2023-02-21 08:19	2023-02-21 13:37	1228.0	116.0	4.0	YES	0.0
1727.0	BRANCH	BRANCH	February	1676529850723	WO23172925	KITA BERSAUDARA, CV	-	-	SDLG	LG936L	607154	35	WARRANTY	RUNNING	-	SIMPANG ATEL	PONTIANAK	COMMISIONING UNIT	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	commisionning unit	Doni Ardiansyah	Ferlya Juliza Admin Pontianak	081545464290	ferlyajulizaa@gmail.com	2023-02-16 13:44	2023-02-16 13:44	2023-02-16 13:44	2023-02-16 17:06	2023-02-16 13:44	2023-02-16 17:06	2023-02-17 09:09	2023-02-17 16:29	2023-02-17 16:30	1228.0	203.0	19.0	YES	0.0
1728.0	BRANCH	BRANCH	February	1676537626955	WO23173020	INDOTRUCK UTAMA, PT.	-	-	VCE	EC210D	231859	16	STOCK	STANDBY	-	BRANCH MANADO	MANADO	Pre delivery inspection	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job is completed	jeanet.kauwo	jeanet.kauwo	081527884719	jeanet.kauwo@indotruck-utama.co.id	2023-02-16 15:53	2023-02-16 15:54	2023-02-22 09:11	2023-02-22 09:11	2023-02-22 09:11	2023-02-22 09:11	2023-03-06 10:06	2023-03-06 10:06	2023-03-06 10:06	1228.0	8238.0	426.0	YES	0.0
1729.0	MECHANIC	MECHANIC	February	1676546182922	23172822	WAHYU MURTI GARUDA KENCANA, PT	-	-	SDLG	L968L	620539	250	WARRANTY	RUNNING	2023-02-16 00:00:00.0000000	parenggean	BANJARMASIN	Service Hm 250 ,and inspection Unit lowe power	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Reddy	Muksim Triharyadi	Muksim Triharyadi	085246182601	muksimtrharyadi@gmail.com	2023-02-16 18:16	2023-02-16 18:16	2023-02-16 18:16	2023-02-16 18:17	2023-02-16 18:16	2023-02-16 18:17	2023-02-16 18:17	2023-02-16 18:17	2023-02-16 18:17	1228.0	1.0	0.0	YES	0.0