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
6850.0	ADMIN	BRANCH	August	1690884664116	WO23184581	PLN (PERSERO) PEMBANGKITAN TANJUNG JATI B, PT	-	-	VCE	EC480DL	16066	4050	NON WARRANTY	RUNNING	-	JEPARA	SEMARANG	16066 WO23184581 REPLACE DRIVE KIT TRACK CHAIN GROUP EC 460 B VCE PLN (PERSERO) UIK TJB 1498 ITU-000003162 SRWE Created Triyono Smg 8/1/2023 1.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-08-01 17:11	2023-08-01 17:11	2023-08-01 17:11	2023-08-01 17:11	2023-08-01 17:11	2023-08-01 17:11	2023-08-04 12:57	2023-08-04 12:58	2023-08-04 12:58	1062.0	1.0	67.0	YES	0.0
6851.0	ADMIN	BRANCH	August	1690884893416	WO23184582	PLN (PERSERO) PEMBANGKITAN TANJUNG JATI B, PT	-	-	VCE	A35E	13051	8000	NON WARRANTY	RUNNING	-	JEPARA	SEMARANG	13051 WO23184582 HEAVY EQUIPMENT SERVICES FOR WASTE HANDLING 17564 D VCE PLN PERSERO UIK TJB 1498 ITU-000003923 SRWE Created Triyono Smg 8/1/2023 408.48	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-08-01 17:14	2023-08-01 17:15	2023-08-01 17:15	2023-08-01 17:15	2023-08-01 17:15	2023-08-01 17:15	2023-08-04 12:56	2023-08-04 12:56	2023-08-04 12:56	1062.0	1.0	67.0	YES	0.0
6852.0	ADMIN	BRANCH	August	1690937299870	WO23184420	SIRTU KARYA UTAMA, PT	-	-	SDLG	L956F	621938	3808	NON WARRANTY	RUNNING	-	BULURI	PALU	Inspection & replace oil coolant L956F SN 621938	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	tiba di kantor	Marcel Kelvin	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-08-02 07:48	2023-08-02 07:49	2023-08-02 07:50	2023-08-02 09:15	2023-08-02 07:50	2023-08-02 09:15	2023-08-02 12:02	2023-08-02 14:01	2023-08-02 14:19	1062.0	87.0	4.0	YES	1.0
6853.0	MECHANIC	MECHANIC	August	1690938338543	-	ANGKASA SAKTI, PT.	-	-	SDLG	L956F	625342	-	WARRANTY	RUNNING	2023-08-02 00:00:00.0000000	Bentuas	SAMARINDA	Service PS500	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	job done	Diky Maulana Tarmiji	Diky Maulana Tarmiji	081356619526	iamdiky15@gmail.com	2023-08-02 08:05	2023-08-02 08:07	2023-08-02 08:07	2023-08-02 10:51	2023-08-02 08:07	2023-08-02 10:51	2023-08-02 13:41	2023-08-02 17:59	2023-08-02 17:59	1062.0	166.0	5.0	YES	1.0
6854.0	ADMIN	BRANCH	August	1690939074206	pending wo karna AR & SMA akan di open stiap akhir bulan	SAMUDERA MULIA ABADI, PT	-	-	VCE	A40F	320473	-	NON WARRANTY	BREAKDOWN	2023-08-02 00:00:00.0000000	Bakan	MANADO	Replace Engine AD SMA 2 024	ENGINE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Arrive	Herdiyansyah	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2023-08-02 08:17	2023-08-02 08:18	2023-08-02 08:25	2023-08-02 08:25	2023-08-02 08:25	2023-08-02 08:25	2023-08-11 09:52	2023-08-11 09:53	2023-08-14 13:49	1062.0	8.0	217.0	YES	0.0
6855.0	ADMIN	BRANCH	August	1690942447566	WO23184672	AUTHAR PRATAMA, CV.	-	-	VCE	EC210D	282287	8664	NON WARRANTY	RUNNING	-	TOROBULU	KENDARI	Replace install switch battery EC210D SN282287	ECT	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrival in branch	Arfandi yahya	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-08-02 09:14	2023-08-02 09:14	2023-08-02 09:16	2023-08-02 13:40	2023-08-02 09:16	2023-08-02 13:40	2023-08-02 14:31	2023-08-03 06:55	2023-08-03 07:06	1061.0	267.0	5.0	YES	0.0
6856.0	ADMIN	BRANCH	August	1690943209826	WO23184646	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	EC480DL	276529	10000	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 10000 jam EX33 SN 276529 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sukses	Raden Ferdiansyah	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-08-02 09:26	2023-08-02 09:33	2023-08-15 10:13	2023-08-15 10:16	2023-08-15 10:14	2023-08-15 10:16	2023-08-15 16:56	2023-08-15 17:56	2023-08-15 17:56	1061.0	11.0	6.0	YES	6.0
6857.0	ADMIN	BRANCH	August	1690943407551	WO23184661	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324509	4400	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 4400 jam AD 70 SN 324509 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sukses	Raden Ferdiansyah	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-08-02 09:30	2023-08-02 09:33	2023-08-15 10:13	2023-08-15 10:16	2023-08-15 10:13	2023-08-15 10:16	2023-08-15 16:56	2023-08-15 17:55	2023-08-15 17:56	1061.0	9.0	6.0	YES	3.0
6858.0	ADMIN	BRANCH	August	1690953759692	WO23184608	JAVAS ANUGERAH PERKASA, PT	-	-	SDLG	E680F	607247	756	WARRANTY	RUNNING	2023-08-02 00:00:00.0000000	muko muko	BENGKULU	service 750	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Bengkulu Admin	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-08-02 12:22	2023-08-02 12:22	2023-08-02 12:25	2023-08-02 15:50	2023-08-02 12:25	2023-08-02 15:50	2023-08-02 16:42	2023-08-02 22:40	2023-08-02 22:40	1061.0	208.0	4.0	YES	0.0
6859.0	ADMIN	BRANCH	August	1690958307871	WO23184692	INDOTRUCK UTAMA, PT.	-	-	SDLG	LG933L	606650	4	STOK	STANDBY	2023-08-02 00:00:00.0000000	Balikpapan	BALIKPAPAN	Arrival Inspect LG933L SN606650	ETC	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	p	Nova Ardianto	Balikpapan Admin	81331838430	balikpapan.sbs@indotruck-utama.co.id	2023-08-02 13:38	2023-08-02 13:38	2023-08-02 13:39	2023-08-02 13:39	2023-08-02 13:40	2023-08-02 13:41	2023-08-02 16:54	2023-08-02 16:54	2023-08-02 16:54	1061.0	1.0	3.0	YES	0.0