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
3180.0	BRANCH	BRANCH	April	1680493635138	WO23176485	INDOTRUCK UTAMA, PT.	-	-	VB	B11R-430 6X2	B11R 212417	-	STOCK	STANDBY	-	PURWAKARTA	JAKARTA	Arrival inspection at Yard Purwakarta	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	16:30	Dimas Yuangga Ariyanto	Rahman Dendi	081388101230	rahman_dendi@yahoo.com	2023-04-03 10:47	2023-04-03 10:47	2023-04-03 10:51	2023-04-03 10:51	2023-04-03 10:51	2023-04-03 10:51	2023-04-04 08:14	2023-04-04 08:14	2023-04-04 14:59	1182.0	4.0	21.0	YES	0.0
3181.0	ADMIN	BRANCH	April	1680495294958	WO23176385	INDOTRUCK UTAMA, PT.	-	-	VCE	EC210D	283699	17.6	STOCK	STANDBY	-	W/S PEKANBARU	PEKANBARU	Storage Maintenance	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	HARIANTO OK	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-04-03 11:14	2023-04-03 11:15	2023-04-03 13:38	2023-04-03 13:40	2023-04-03 13:38	2023-04-03 13:40	2023-04-03 16:15	2023-04-03 16:15	2023-04-04 09:30	1182.0	145.0	5.0	YES	0.0
3182.0	ADMIN	BRANCH	April	1680507734493	WO23176627	DEMPO MAJU CEMERLANG, PT	-	-	VCE	EC210D	282774	6322	NON WARRANTY	RUNNING	-	PAINAN	PEKANBARU	Service 250 hours	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	Selesao	MUHAMMAD FITRIO DEHEN	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-04-03 14:42	2023-04-03 14:42	2023-04-07 09:02	2023-04-08 07:52	2023-04-07 09:02	2023-04-08 07:52	2023-04-10 07:34	2023-04-11 16:04	2023-04-14 15:00	1182.0	1424.0	71.0	YES	0.0
3183.0	ADMIN	BRANCH	April	1680508573516	WO23176359	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324771	400	WARRANTY	RUNNING	-	MUARA LAWAI	MUARA ENIM	PM service 400 jam AD73 SN 324771 LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	sampai kantor	Ichsan Ali Rosidi	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-04-03 14:56	2023-04-03 14:56	2023-04-05 09:42	2023-04-05 10:07	2023-04-05 09:42	2023-04-05 10:07	2023-04-05 11:06	2023-04-05 11:30	2023-04-05 11:37	1182.0	27.0	1.0	YES	0.0
3184.0	ADMIN	BRANCH	April	1680509318073	WOSD176392	ALAM AKASIA LESTARI, PT	-	-	SDLG	G9138	600596	395	WARRANTY	RUNNING	-	TANJABBAR	JAMBI	REPLACE STARTER SWITCH	ECT	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	job competed jam 20.00 tgl 04-03-2023	Teten Kurniyawan	Jambi Admin	81366256191	jambi.sbs@indotruck-utama.co.id	2023-04-03 15:08	2023-04-03 15:08	2023-04-04 15:29	2023-04-04 15:29	2023-04-04 15:29	2023-04-04 15:29	2023-04-04 15:31	2023-04-05 08:01	2023-04-05 08:01	1182.0	1461.0	24.0	YES	0.0
3185.0	ADMIN	BRANCH	April	1680513590957	WO23176378	BANDANG REZEKI LESTARI, PT	-	-	SDLG	L956F	625017	875	WARRANTY	RUNNING	-	FUTONG	PEKANBARU	Service 750 hours	ECT	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	sampai	TRISKI ADRIAN	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2023-04-03 16:19	2023-04-03 16:20	2023-04-04 08:05	2023-04-04 15:50	2023-04-04 08:05	2023-04-04 15:50	2023-04-04 18:50	2023-04-05 08:07	2023-04-13 11:32	1182.0	1411.0	26.0	YES	0.0
3186.0	MECHANIC	MECHANIC	April	1680564544605	23176359	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324771	389	WARRANTY	RUNNING	2023-04-04 00:00:00.0000000	Muara lawai	MUARA ENIM	Service 400	ENGINE	INTERNAL SERVICE	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	fru	Ichsan Ali Rosidi	Ichsan Ali Rosidi	081315343354	xzanalirosidi313@gmail.com	2023-04-04 06:29	-	2023-04-04 06:29	2023-04-06 07:46	2023-04-04 06:29	2023-04-06 07:46	2023-04-06 12:08	-	2023-04-06 12:09	1182.0	2958.0	53.0	YES	-
3187.0	ADMIN	BRANCH	April	1680567609326	WO23176423	BUMI KARSA, PT	-	-	VCE	EC210D	253397	500	WARRANTY	RUNNING	2023-04-04 00:00:00.0000000	Majene	MAKASSAR	Servis Mandatory 500H	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	Marcel Kelvin	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-04-04 07:20	2023-04-04 07:22	2023-04-04 07:25	2023-04-05 14:47	2023-04-04 07:25	2023-04-05 14:47	2023-04-05 16:39	2023-04-06 07:06	2023-04-06 12:38	1182.0	1888.0	33.0	YES	1.0
3188.0	ADMIN	BRANCH	April	1680572347056	WO23176438	BERKAT ANUGERAH AGUNG, PT	-	-	SDLG	L956F	624726	798	WARRANTY	STANDBY	2023-04-04 00:00:00.0000000	Gresik	SURABAYA	Service 750 Hours	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job done	Muhammad Hatta	Surabaya Admin	89538317606	surabaya.sbs@indotruck-utama.co.id	2023-04-04 08:39	2023-04-04 08:39	2023-04-04 09:26	2023-04-04 11:06	2023-04-04 09:26	2023-04-04 11:06	2023-04-04 16:45	2023-04-04 16:45	2023-04-05 13:20	1182.0	147.0	6.0	YES	0.0
3189.0	ADMIN	BRANCH	April	1680574375152	WOSD176449	ALIRAN KETAHUN PERDANA, CV	-	-	SDLG	E6210F	609318	495	WARRANTY	RUNNING	2023-04-04 00:00:00.0000000	pelabuhan	BENGKULU	replace hose intake	ENGINE	REPAIR	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	close	Agus Nugroho	Bengkulu Admin	85228555522	bengkulu.sbs@indotruck-utama.co.id	2023-04-04 09:12	2023-04-04 09:13	2023-04-04 10:01	2023-04-04 10:41	2023-04-04 10:01	2023-04-04 10:41	2023-04-04 12:28	2023-04-04 15:09	2023-04-04 15:10	1181.0	89.0	3.0	YES	0.0