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
3160.0	ADMIN	MECHANIC	April	1680573074356	WO23176113	PUTRA ARYA SATYA, PT	-	-	SDLG	LG953	622059	251	WARRANTY	STANDBY	2023-04-04 00:00:00.0000000	Bali	SURABAYA	Service 250 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job done	Ajik Pramusinta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-04-04 08:51	2023-04-04 08:52	2023-04-05 13:51	2023-04-06 18:39	2023-04-05 13:51	2023-04-06 18:39	2023-04-10 08:38	2023-04-18 08:46	2023-04-18 08:46	1182.0	3468.0	143.0	YES	1.0
3161.0	ADMIN	BRANCH	March	1680165480450	WO23175731	BARA REZEKI HAMIZAN, PT	-	-	SDLG	G9220	600594	241	WARRANTY	RUNNING	2023-03-30 00:00:00.0000000	BINUANG	BANJARMASIN	COMMISSIONING UNIT	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Unit ready for use	Zainur Yahya	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-03-30 15:38	2023-03-30 15:38	2023-03-31 15:40	2023-03-31 15:41	2023-03-31 15:40	2023-03-31 15:41	-	-	2023-03-31 15:46	1186.0	1443.0	-	YES	0.0
3162.0	ADMIN	BRANCH	March	1680165644581	WO23175867	BUMI BARITO MINERAL, PT	-	-	SDLG	E6210F	609628	1	WARRANTY	RUNNING	2023-03-30 00:00:00.0000000	.	BANJARMASIN	COMMISSIONING UNIT	ENGINE	INSPECTION	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Unit ready for use WO Number Update: WO23175867	Piter Setiawan	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2023-03-30 15:40	2023-03-30 15:40	2023-04-09 20:44	2023-04-09 20:44	2023-04-09 20:44	2023-04-09 20:44	-	2023-04-09 20:48	2023-04-09 20:49	1186.0	14704.0	-	YES	0.0
3163.0	MECHANIC	MECHANIC	March	1680176709398	WO23175453	BARA KUMALA PT	-	-	VCE	A40G	324102	7507	WARRANTY	RUNNING	2023-03-30 00:00:00.0000000	KUTAI LAMA	SAMARINDA	bk302 ps500h	ETC	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	DONE	Fatur Rahman	Fatur Rahman	082253041112	ftrrhmn.23@gmail.com	2023-03-30 18:45	2023-03-30 18:45	2023-03-30 18:45	2023-03-30 20:02	2023-03-30 18:45	2023-03-30 20:02	2023-03-30 20:27	2023-03-30 20:47	2023-03-30 20:47	1186.0	77.0	1.0	YES	0.0
3164.0	ADMIN	BRANCH	March	1680229390899	-	RIMBA PERKASA UTAMA, PT	-	-	SDLG	L968F	620595	6.8	WARRANTY	RUNNING	-	BATUAH	SAMARINDA	COMMISIONING UNIT	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	ready	Heru Priyoga	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-03-31 09:23	2023-03-31 09:25	2023-03-31 09:25	2023-03-31 12:27	2023-03-31 09:25	2023-03-31 12:27	2023-03-31 16:03	2023-03-31 18:38	2023-03-31 18:58	1185.0	185.0	6.0	YES	1.0
3165.0	BRANCH	BRANCH	March	1680229896859	WOCE176025	PRIMA SARANA MUSTIKA, PT	-	-	VCE	SD110	59176	1406	WARRANTY	RUNNING	-	PATIWARE II	PONTIANAK	CAMPAIGN JOB RMP61	ELECTRICAL	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job completed	catur muhamad rahmadhan	Ferlya Juliza Admin Pontianak	081545464290	ferlyajulizaa@gmail.com	2023-03-31 09:31	2023-03-31 09:31	2023-03-31 09:32	2023-03-31 20:37	2023-03-31 09:32	2023-03-31 20:37	2023-04-01 07:37	2023-04-05 16:02	2023-04-05 16:02	1185.0	666.0	22.0	YES	0.0
3166.0	MECHANIC	MECHANIC	March	1680233429113	176031	ASTON PRIMA RAYA, PT	-	-	VCE	DD100	50947	180	WARRANTY	RUNNING	2023-03-31 00:00:00.0000000	Karawang	JAKARTA	check parking brake switch burn in	BRAKE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	complate 17.30 ³¹/³/²³	Ismail Fauzi	Ismail Fauzi	082213141199	fauziismail26@gmail.com	2023-03-31 10:30	2023-03-31 10:30	2023-03-31 10:30	2023-04-03 18:05	2023-03-31 10:30	2023-04-03 18:05	2023-04-03 18:07	2023-04-03 18:07	2023-04-03 18:08	1185.0	4775.0	79.0	NO	0.0
3167.0	ADMIN	BRANCH	March	1680241034105	WO23176059	WAWAN KURNIAWAN	-	-	VCE	EC210D	252805	2006	NON WARRANTY	STANDBY	-	KOLONODALE-MOROWALI	PALU	INSTALLATION&REPAIR EC210D SN.252805	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	telah tiba di office	Eko Novianto	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-03-31 12:37	2023-03-31 12:37	2023-03-31 12:38	2023-04-06 08:06	2023-03-31 12:38	2023-04-06 08:06	2023-04-06 08:11	2023-04-06 08:12	2023-04-06 08:23	1185.0	8369.0	139.0	YES	0.0
3168.0	ADMIN	BRANCH	March	1680244121225	WO23175855	BALIKPAPAN READYMIX, PT	-	-	VCE	EC210D	253389	21	WARRANTY	RUNNING	-	BULURI-PALU	PALU	COMMISIONING EC210D SN.253389	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Ahmad Jafar M	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-03-31 13:28	2023-03-31 13:29	2023-03-31 13:29	2023-03-31 13:32	2023-03-31 13:29	2023-03-31 13:32	2023-03-31 17:29	-	2023-04-03 08:14	1185.0	3.0	4.0	YES	0.0
3169.0	ADMIN	BRANCH	April	1680306455705	WO23176134	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324509	2800	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 2800 jam AD70 SN324509 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai di kantor.	Agung Dwi Bimatara	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-01 06:47	2023-04-01 06:48	2023-04-01 09:02	2023-04-01 10:32	2023-04-01 09:02	2023-04-01 10:32	2023-04-01 18:57	2023-04-01 19:03	2023-04-03 10:27	1185.0	201.0	11.0	YES	0.0