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
6837.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	1078.0	1.0	67.0	YES	0.0
6838.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	1078.0	1.0	67.0	YES	0.0
6839.0	MECHANIC	BRANCH	August	1690926121653	909563	HASNUR RIUNG SINERGI, PT.	-	-	VCE	EC480DL	sesuai unit	-	NON WARRANTY	RUNNING	2023-08-02 00:00:00.0000000	AGM- Rantau	BANJARMASIN	Back Up site	ENGINE	OTHER	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	RFU	Ramadani	Ramadani	085348478885	ramadani120393@gmail.com	2023-08-02 04:42	2023-08-02 04:42	2023-08-02 04:42	2023-08-02 05:37	2023-08-02 04:42	2023-08-02 05:37	2023-08-02 16:31	2023-08-02 18:44	2023-08-02 18:44	1077.0	56.0	11.0	YES	0.0
6840.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	1077.0	87.0	4.0	YES	1.0
6841.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	1077.0	166.0	5.0	YES	1.0
6842.0	MECHANIC	MECHANIC	August	1690938426493	-	BINTANG ALAM REJEKI, PT.	-	-	VCE	A40G	324760	1743	WARRANTY	BREAKDOWN	2023-08-02 00:00:00.0000000	bentuas	SAMARINDA	problem T/M	TRANSMISSION	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Ready for use	Heru Priyoga	Diky Maulana Tarmiji	081356619526	iamdiky15@gmail.com	2023-08-02 08:07	2023-08-02 08:07	2023-08-02 08:07	2023-08-02 16:45	2023-08-16 10:55	2023-08-16 11:58	2023-08-16 17:43	2023-08-16 18:38	2023-08-16 19:32	1077.0	518.0	10.0	YES	0.0
6843.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	1077.0	8.0	217.0	YES	0.0
6844.0	ADMIN	BRANCH	August	1690941428693	WO23184671	UTAMA KARYA NIAGA, PT.	-	-	SDLG	L958F	620075	11250	NON WARRANTY	STANDBY	2023-08-02 00:00:00.0000000	Ciwandan	CILEGON	Maintenance servis Every 250 H	ETC	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Completed	Pujiyanto	Cilegon Admin	85219742046	cilegon.sbs@indotruck-utama.co.id	2023-08-02 08:57	2023-08-02 08:57	2023-08-02 10:33	2023-08-02 11:04	2023-08-02 10:33	2023-08-02 11:04	2023-08-02 14:47	2023-08-02 14:56	2023-08-03 08:18	1077.0	127.0	5.0	YES	0.0
6845.0	MECHANIC	MECHANIC	August	1690942095373	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 2024	ENGINE	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	arrived	Ramadhan Setiawan Argi	Ramadhan Setiawan Argi	082119528541	ramadhan.argi@gmail.com	2023-08-02 09:08	2023-08-02 09:08	2023-08-02 09:08	2023-08-02 09:09	2023-08-02 09:08	2023-08-02 09:09	2023-08-12 08:18	2023-08-12 08:19	2023-08-24 10:43	1077.0	1.0	239.0	YES	0.0
6846.0	ADMIN	BRANCH	August	1690942228822	WO23184673	BERKAT ANUGERAH AGUNG, PT	-	-	SDLG	L956F	624726	1750	WARRANTY	STANDBY	2023-08-02 00:00:00.0000000	Surabaya	SURABAYA	Service 1750 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Ajik Pramusinta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-08-02 09:10	2023-08-02 09:10	2023-08-02 09:36	2023-08-02 11:02	2023-08-02 09:36	2023-08-02 11:02	2023-08-02 16:00	2023-08-03 08:58	2023-08-03 08:58	1077.0	112.0	6.0	YES	0.0