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
17105.0	ADMIN	BRANCH	May	1716356714834	WO24211245	PUTRA RIMBA NUSANTARA, PT	-	-	SDLG	G9138	600615	750	WARRANTY	RUNNING	-	MUARA LAWA	SAMARINDA	SERVICE 750HRS	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	OTW TO SITE	-	Marsono	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2024-05-22 12:45	2024-05-22 12:45	2024-05-22 12:46	-	2024-05-22 12:46	-	2024-05-26 11:41	2024-05-26 19:56	2024-05-26 19:58	767.0	-	94.0	-
17106.0	MECHANIC	MECHANIC	May	1716365122375	0000	HARMONI PANCA UTAMA, PT	-	-	VCE	EC480DL	285356	2804.1	NON WARRANTY	RUNNING	2024-05-22 00:00:00.0000000	Tuhup	MUARA TEWEH	PM1 (250H)	ETC	OTHER	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	unit RFU HM2804.1	Alfan Fauzin	Alfan Fauzin	081333953033	alfanfauzin26@gmail.com	2024-05-22 15:05	2024-05-22 15:05	-	-	-	-	-	-	2024-05-22 15:07	767.0	-	-	YES
17107.0	ADMIN	BRANCH	May	1716423584591	WO24211419	JAGAAMAN SARANA, PT	-	-	VCE	EC350D	271113	5510	NON WARRANTY	STANDBY	2024-05-23 00:00:00.0000000	BOEDINGI, KONAWE UTARA	KENDARI	Resoft ware W-ECU EC350D	ELECTRICAL	OTHER	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	first response time	Dirga Dwi Julianto Sahputra	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2024-05-23 07:19	2024-05-23 07:20	2024-05-23 08:02	2024-05-24 09:21	2024-05-23 08:02	2024-05-24 09:21	2024-05-25 12:59	2024-05-28 22:14	2024-05-29 07:22	767.0	1562.0	53.0	YES
17108.0	ADMIN	BRANCH	May	1716446351177	WOCE211144	PRIMA SARANA GEMILANG, PT	-	-	VCE	EC950E	370131	0	NON WARRANTY	STANDBY	2024-05-23 00:00:00.0000000	SAMBARATA	BERAU	campaign EMP55	ENGINE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	ARRIVE IN BRANCH OFFICE	ARRIVE IN BRANCH OFFICE	Denni andika	Berau Admin	85228555523	berau.sbs@indotruck-utama.co.id	2024-05-23 13:39	2024-05-23 13:40	2024-05-23 13:44	2024-05-23 13:49	2024-05-23 13:44	2024-05-23 13:49	2024-05-23 19:06	2024-05-23 21:25	2024-05-24 08:46	766.0	10.0	5.0	-
17109.0	ADMIN	BRANCH	May	1716506778483	WOSD211186	BINTANG BERCAHAYA CEMERLANG, PT	-	-	SDLG	E6210F	SN609177	-	WARRANTY	STANDBY	2024-05-24 00:00:00.0000000	Sorong Kabupaten	SORONG	Wire Harness Remove Of Pre-Heating Relay SN6009177	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	-	-	Service koordinator (Sorong - Nusa tenggara)	Sorong Admin	81240668088	sorong.sbs@indotruck-utama.co.id	2024-05-24 06:26	2024-05-24 06:26	2024-05-27 06:40	2024-05-27 10:29	2024-05-27 06:40	2024-05-27 10:29	2024-05-27 10:30	2024-05-27 15:07	2024-05-27 15:08	766.0	4563.0	76.0	-
17110.0	ADMIN	BRANCH	May	1716510149602	WO24211150	MARYONO	-	-	SDLG	L968F	620525	1	NON WARRANTY	STANDBY	2024-05-24 00:00:00.0000000	BINUANG	BANJARMASIN	REMOVE,REPAIR,INSTALL TRANSMISSION	TRANSMISSION	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Ridwan Wahyu	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2024-05-24 07:22	2024-05-24 07:22	2024-05-24 07:30	-	2024-05-24 07:30	-	2024-05-24 07:31	2024-05-24 07:31	2024-05-24 07:31	766.0	-	0.0	YES
17111.0	ADMIN	BRANCH	May	1716512131283	WOCE211142	HASNUR RIUNG SINERGI, PT.	-	-	VCE	EC950E	370144	8720	WARRANTY	STANDBY	2024-05-24 00:00:00.0000000	RANTAU	BANJARMASIN	TREVEL GEARBOX NOISE	ETC	OVERHAUL	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	ARRIVE ON SITE	.	Ramadani	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2024-05-24 07:55	2024-05-24 07:55	2024-05-24 07:56	2024-05-24 07:56	2024-05-24 07:56	2024-05-24 07:56	2024-08-07 04:34	2024-08-07 04:36	2024-08-07 04:38	766.0	1.0	1796.0	-
17112.0	ADMIN	BRANCH	May	1716515673694	WO24211276	SINAR NUSA SEJAHTERA, PT	-	-	SDLG	LG933L	606652	500	NON WARRANTY	RUNNING	-	BELAWAN	MEDAN	Mandatory Service 500 Hours Unit LG933L SN 606652	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Edward Purba	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2024-05-24 08:54	2024-05-24 08:54	2024-05-24 11:21	2024-05-24 11:21	2024-05-24 11:21	2024-05-24 11:21	2024-05-24 15:50	2024-05-24 15:51	2024-05-24 15:51	766.0	147.0	6.0	YES
17113.0	ADMIN	BRANCH	May	1716516817311	WO24211282	TUTI MULIA SARIANTI	-	-	VCE	EC210D	252815	2600	NON WARRANTY	RUNNING	-	MEULABOH	MEDAN	Repair TroubleShooting Fueling System Unit EC210D SN 252815	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	finish	Ferdian Dinata	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2024-05-24 09:13	2024-05-24 09:13	2024-05-28 09:56	2024-05-28 09:56	2024-05-28 09:56	2024-05-28 09:56	2024-05-29 00:06	2024-05-29 08:16	2024-05-29 08:17	765.0	5803.0	110.0	YES
17114.0	ADMIN	BRANCH	May	1716519196058	WO24211287	TRANS SAFELAND UTAMA, PT	-	-	VT	FM37064T	A720600	1	NON WARRANTY	RUNNING	-	CAKUNG	JAKARTA	Replace engine ECU B 9257 TEH , Chasis No. A720600	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Noval Qomaruzzaman Rasyid	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2024-05-24 09:53	2024-05-24 09:53	2024-05-24 09:54	2024-05-24 11:02	2024-05-24 09:54	2024-05-24 11:02	2024-05-24 17:26	2024-05-24 17:26	2024-05-27 08:51	765.0	69.0	7.0	YES