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
17065.0	ADMIN	BRANCH	May	1716176014768	WO24213456	JAGA AMAN SEJAHTERA, PT	-	-	VCE	A40G	325469	11	WARRANTY	RUNNING	-	LELILEF	MANADO	commissioning unit	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Riandy Hamzah	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2024-05-20 10:33	2024-05-20 10:33	2024-05-30 10:06	2024-05-30 10:06	2024-05-30 10:06	2024-05-30 10:06	2024-05-30 10:06	2024-05-30 10:07	2024-10-10 12:15	769.0	14373.0	239.0	YES
17066.0	ADMIN	BRANCH	May	1716177887246	WOCE211087	NUSANTARA INTI PRATAMA, PT	-	-	VCE	EC480DL	284951	16230	WARRANTY	STANDBY	2024-05-20 00:00:00.0000000	Patas KM 30, Kalimantan Tengah	MUARA TEWEH	Leaking Pipe C/V to Boom and Swing	ETC	OTHER	ON CALL	-	-	-	LEADER	REJECTED	WAITING PARTS	Part akan dikirim dari Banjarmasin ke Muara Teweh pada hari Senin, 20 May 2024	Vicky Prasetyo	Muara Teweh Admin	81366256198	muarateweh.sbs@indotruck-utama.co.id	2024-05-20 11:04	2024-05-20 11:05	-	-	-	-	-	-	-	769.0	-	-	-
17067.0	ADMIN	BRANCH	May	1716185368891	WO24211096	GAUNG ANGKASA SEJAHETRA, CV	-	-	VCE	EC210B	75714	10600	NON WARRANTY	STANDBY	-	RANOMEETO	KENDARI	Inspection and install relay EC210B SN75714	ECT	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	-	Dirga Dwi Julianto Sahputra	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2024-05-20 13:09	2024-05-20 13:09	2024-05-20 14:38	2024-05-20 14:38	2024-05-20 14:38	2024-05-20 14:38	2024-05-20 15:18	2024-05-20 15:59	2024-05-21 07:15	769.0	89.0	2.0	YES
17068.0	ADMIN	BRANCH	May	1716188749692	WO24211479	MERDEKA MINING INDONESIA, PT	-	-	VCE	A60H	320747	8	WARRANTY	STANDBY	-	SITE PANI GOLD GORONTALO	MANADO	commissioning unit	ECT	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	back	Hari Manaf Pongoliu	Manado Admin	81366256196	manado.sbs@indotruck-utama.co.id	2024-05-20 14:05	2024-05-20 14:06	2024-05-20 15:00	2024-05-20 15:02	2024-05-20 15:00	2024-05-20 15:02	2024-05-30 12:44	2024-05-30 12:43	2024-06-10 10:40	769.0	56.0	238.0	YES
17069.0	ADMIN	BRANCH	May	1716189790014	WO24211097	AKR TRANSPORTASI INDONESIA, PT	-	-	VT	FM37064T	YV2XM30D0GB776768	-	NON WARRANTY	RUNNING	-	SEMARANG	SEMARANG	YV2XM30D0GB776768 WO24211097 T/S Transmission System, Replace Master Cylinder VT AKR TRANSPORTASI INDONESIA, PT 0038 ITU-000005910 SRWE Created Triyono Smg 5/20/2024 3.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2024-05-20 14:23	2024-05-20 14:23	2024-05-20 14:23	2024-05-20 14:23	2024-05-20 14:23	2024-05-20 14:23	2024-05-28 08:42	2024-05-28 08:43	2024-05-28 08:43	769.0	1.0	186.0	YES
17070.0	ADMIN	BRANCH	May	1716192140825	WO24211106	AKR TRANSPORTASI INDONESIA, PT	-	-	VT	FM37064T	YV2XM30D2GB777548	-	NON WARRANTY	RUNNING	-	SEMARANG	SEMARANG	YV2XM30D2GB777548 WO24211106 REPLACE CONTROL VALVE VT AKR TRANSPORTASI INDONESIA, PT 0038 ITU-000005928 SRWE Created Triyono Smg 5/20/2024 3.00	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2024-05-20 15:02	2024-05-20 15:02	2024-05-20 15:02	2024-05-20 15:02	2024-05-20 15:02	2024-05-20 15:02	2024-05-28 08:43	2024-05-28 08:43	2024-05-28 08:44	769.0	1.0	185.0	YES
17071.0	ADMIN	BRANCH	May	1716197981593	WO24211115	SAMUDERA SAWIT SUBUR, PT	-	-	SDLG	L956F	624723	3750	NON WARRANTY	RUNNING	-	KIM - MABAR	MEDAN	Maintenance Service 3750 Hours Unit L956F SN 624723	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Edward Purba	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2024-05-20 16:39	2024-05-20 16:40	-	2024-05-21 10:55	-	2024-05-21 10:55	2024-05-21 12:45	2024-05-21 14:49	2024-05-21 14:49	769.0	153.0	4.0	YES
17072.0	ADMIN	BRANCH	May	1716253250584	WO24211127	SURYAKIN	-	-	SDLG	E660FL	625791	1000	WARRANTY	RUNNING	2024-05-21 00:00:00.0000000	KARANG ANYAR	TARAKAN	SERVICE 1000 HRS	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	-	-	AMIRUDDIN	Tarakan Admin	89538317607	tarakan.sbs@indotruck-utama.co.id	2024-05-21 08:00	2024-05-21 08:01	2024-05-21 09:54	2024-05-21 10:32	2024-05-21 09:54	2024-05-21 10:32	2024-05-21 15:58	2024-05-21 17:31	2024-05-22 07:20	769.0	152.0	7.0	-
17073.0	ADMIN	BRANCH	May	1716253396267	WOCE211085	HILLCONJAYA SAKTI, PT	-	-	VCE	A60H	320501	9014	WARRANTY	STANDBY	2024-05-21 00:00:00.0000000	KORABARU	BANJARMASIN	FRONT PROPELLER SHAFT DB TO FB FAILURE - ADT 034	ETC	OTHER	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	unit RFU	Wardani	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2024-05-21 08:03	2024-05-21 08:03	2024-05-21 08:03	2024-05-21 08:03	2024-05-21 08:03	2024-05-21 08:03	-	-	2024-05-21 08:15	769.0	1.0	-	YES
17074.0	ADMIN	BRANCH	May	1716253516340	WOSD209961	INTERNUSA PAPUA RAYA, PT	-	-	SDLG	E6210F	SN609591	-	WARRANTY	STANDBY	2024-05-21 00:00:00.0000000	Bintuni	SORONG	Wire Harness Remove Of Pre-Heating Relay	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	-	-	Afrizal Fawzi	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2024-05-21 08:05	2024-05-21 08:06	2024-05-24 16:05	2024-05-24 16:37	2024-05-24 16:05	2024-05-24 16:37	2024-05-25 17:01	2024-05-25 17:01	2024-05-25 17:02	769.0	4832.0	104.0	-