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
3430.0	ADMIN	BRANCH	April	1681356890854	WO23177019	WAHANA INDO TRADA MOBILINDO,PT.	-	-	VB	B11R-430 6X2	202141	155737	NON WARRANTY	STANDBY	-	POOL INDORENT - CIBINONG	JAKARTA	Basic service II B 7670 TGD 202141 at pool Indorent - Cibinong	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Dimas Yuangga Ariyanto	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-04-13 10:34	2023-04-13 10:35	2023-04-13 18:10	2023-04-13 18:10	2023-04-13 18:10	2023-04-13 18:10	2023-04-13 18:12	2023-04-13 18:12	2023-04-13 18:12	1172.0	456.0	7.0	NO	0.0
3431.0	ADMIN	BRANCH	April	1681360483105	WO23176994	KARTINI	-	-	VCE	EC300DL	272430	2610	NON WARRANTY	STANDBY	-	MOROWALI	PALU	TROUBLEHOOTING ECU	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Tiba di kantor Palu	Eko Novianto	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2023-04-13 11:34	2023-04-13 11:35	2023-04-14 08:06	2023-04-14 08:07	2023-04-14 08:06	2023-04-14 08:07	2023-04-17 13:17	2023-04-18 09:52	2023-04-18 09:53	1172.0	1232.0	97.0	YES	0.0
3432.0	ADMIN	BRANCH	April	1681360603790	WO23177055	DAYA SEMESTA AGRO PERSADA, PT	-	-	SDLG	LG936L	606725	2350	NON WARRANTY	RUNNING	-	LUBUK LINGGAU	PALEMBANG	Replace compressor AC	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	otw	Binharun Sipahutar	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2023-04-13 11:36	2023-04-13 11:38	2023-04-13 11:38	2023-04-13 13:07	2023-04-13 11:38	2023-04-13 13:07	2023-04-14 11:23	2023-04-14 14:13	2023-04-14 14:14	1172.0	91.0	23.0	YES	1.0
3433.0	ADMIN	BRANCH	April	1681362168728	WO23177064	MUDA BERJAYA BEUTARI, CV	-	-	SDLG	E6210F	609596	257	WARRANTY	RUNNING	-	NAGAN RAYA	MEDAN	MANDATORY SERVICE	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	in office	Joko Firman Nababan	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-04-13 12:02	-	2023-04-13 12:21	2023-04-18 10:47	2023-04-13 12:21	2023-04-18 10:47	2023-04-18 14:36	-	2023-04-19 07:13	1172.0	7125.0	122.0	YES	-
3434.0	ADMIN	BRANCH	April	1681369052130	WOCE176885	MANDIRI INTI PERKASA, PT	-	-	VCE	L350F	3104	1022	WARRANTY	RUNNING	2023-04-13 00:00:00.0000000	SESAYAP	TARAKAN	CAMPAIGN OIL DIPSTICK	ETC	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Finish	Ilham Rave Lito	Tarakan Admin	89538317607	tarakan.sbs@indotruck-utama.co.id	2023-04-13 13:57	2023-04-13 13:57	2023-04-13 14:00	2023-04-13 14:10	2023-04-13 14:00	2023-04-13 14:12	2023-04-13 14:26	2023-04-13 14:44	2023-04-13 14:48	1172.0	13.0	0.0	YES	0.0
3435.0	ADMIN	BRANCH	April	1681376475443	WO23177095	BONGKOTAN JATI UTAMA, PT.	-	-	VB	B11R	YV3T2T423LA199260	125	NON WARRANTY	RUNNING	-	JEPARA	SEMARANG	YV3T2T423LA199260 WO23177095 SUPPLY PARTS VB B11R VB BONGKOTAN JATI UTAMA, PT. 2696 ITU-000009726 SRWE Created Triyono Smg 1/31/2023 15.00	ENGINE	OTHER	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Andri Kurniawan	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-04-13 16:01	2023-04-13 16:01	2023-04-13 16:01	2023-04-13 16:01	2023-04-13 16:01	2023-04-13 16:01	2023-04-14 15:37	2023-04-14 15:37	2023-04-14 15:37	1172.0	1.0	23.0	YES	0.0
3436.0	ADMIN	BRANCH	April	1681433686980	WOCE176865	RAKA NAVARA, PT	-	-	VCE	EC210D	252808	1100	WARRANTY	BREAKDOWN	-	KOLAKA UTARA	KENDARI	Replace Water Pump Licking EC210D SN 252808, BREAKDOWN	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive on office	Arfandi yahya	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2023-04-14 07:54	2023-04-14 07:56	2023-04-14 07:58	2023-04-14 07:58	2023-04-14 07:58	2023-04-14 07:58	2023-04-17 09:06	2023-04-17 09:06	2023-04-17 10:20	1172.0	4.0	73.0	YES	1.0
3437.0	ADMIN	BRANCH	April	1681436562842	WO23177136	KALINYAMAT PERKASA, PT	-	-	SDLG	LG936L	VLG0936LAN0607319	2	WARRANTY	RUNNING	-	JEPARA	SEMARANG	VLG0936LAN0607319 WO23177136 COMMISSIONING UNIT LG936L SDLG 0594 ITU-000017358 SRWI-SVC Created Triyono Smg 4/14/2023 10.00	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Andri Kurniawan	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-04-14 08:42	2023-04-14 08:42	2023-04-14 08:43	2023-04-14 08:43	2023-04-14 08:43	2023-04-14 08:43	2023-04-14 15:36	2023-04-14 15:36	2023-04-14 15:36	1172.0	1.0	6.0	YES	0.0
3438.0	MECHANIC	BRANCH	April	1681436835505	WO23177541 & WO23184222	JAVA TAIKO MINERALINDO, PT	-	-	SDLG	LG938	9005035	6286	NON WARRANTY	BREAKDOWN	2023-04-14 00:00:00.0000000	Bojonegara	CILEGON	OH Engine	ENGINE	OVERHAUL	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	Job Completed	M.Zaenal Ma'Arif	M.Zaenal Ma'Arif	089646576197	mzmarif60@gmail.com	2023-04-14 08:47	2023-04-14 08:47	2023-04-14 08:55	2023-04-14 09:33	2023-07-03 09:27	2023-07-03 10:03	2023-07-03 16:28	2023-07-03 17:02	2023-07-20 09:40	1172.0	46.0	2.0	NO	0.0
3439.0	MECHANIC	MECHANIC	April	1681452460828	WOCE177620	SENTOSA LAJU SEJAHTERA, PT.	-	-	VCE	A40G	324545	-	WARRANTY	BREAKDOWN	2023-04-14 00:00:00.0000000	melak	SAMARINDA	replace diffrential front	ETC	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	replace front diff	ilham	ilham	082350786118	ilhamscreenscreen@gmail.com	2023-04-14 13:07	2023-04-14 13:08	2023-04-14 13:09	-	2023-04-14 13:09	-	2023-04-25 13:38	2023-04-28 10:21	2023-04-28 10:22	1171.0	-	264.0	YES	0.0