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
16829.0	ADMIN	BRANCH	May	1715567756739	WO24210455	BUKIT ASAM ( Persero ) TBK., PT	-	-	VT	FMX40064R	314573	6493	WARRANTY	BREAKDOWN	2024-05-13 00:00:00.0000000	Tanjung Enim, South Sumatra	MUARA ENIM	Coolant Pump Leaks DT3010-12	ENGINE	OTHER	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	COMPLETED job Warranty Replace Coolant Pump FMX400 DT3010-12 SN AA314573 PTBA	Aldi Subkhi	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2024-05-13 09:35	2024-05-13 09:36	-	2024-05-13 13:44	-	2024-05-13 13:44	2024-05-13 13:49	2024-05-13 13:50	2024-05-13 12:42	776.0	248.0	4.0	YES
16830.0	ADMIN	BRANCH	May	1715569607910	WO24210181	IMAM SUYATNO	-	-	SDLG	LG933L	606439	1014	WARRANTY	RUNNING	2024-05-13 00:00:00.0000000	Mesuji	LAMPUNG	Ms service 1000h	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	pekerjaan selesai	Rheno Bayu Saputro	Lampung Admin	81366256194	lampung.sbs@indotruck-utama.co.id	2024-05-13 10:06	2024-05-13 10:06	2024-05-13 10:09	2024-05-14 01:34	2024-05-13 10:09	2024-05-14 01:34	2024-05-14 02:04	2024-05-14 02:33	2024-05-14 04:03	776.0	928.0	15.0	YES
16831.0	ADMIN	BRANCH	May	1715573154726	WO24210269	BINTANG JAYA PRATAMA INDONESIA, PT	-	-	SDLG	LG933L	SN602967	1499	NON WARRANTY	STANDBY	-	KARAWANG	JAKARTA	T/s Inspecting unit can't brake optimal, LG 933 SN602967	ENGINE	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	-	Bian Saefani	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2024-05-13 11:05	2024-05-13 11:06	2024-05-13 11:06	2024-05-13 11:06	2024-05-13 11:06	2024-05-13 11:06	2024-05-13 15:43	2024-05-13 16:15	2024-05-13 16:15	776.0	1.0	4.0	YES
16832.0	ADMIN	BRANCH	May	1715573947721	WO24210490	INDOTRUCK UTAMA, PT.	-	-	VT	FMX42064R	B419927	145	NON WARRANTY	STANDBY	-	YARD	JAKARTA	Install PTO Engine, Pre Delivery Inspection FMXB364R B419927	ENGINE	REPAIR	ON CALL	-	-	-	NON LEADER	COMPLETED	COMPLETED	-	FAHJAR NUR IRVANSYAH	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2024-05-13 11:19	2024-05-13 11:19	2024-05-13 11:19	2024-05-13 12:47	2024-05-13 11:19	2024-05-13 12:47	2024-05-13 15:39	2024-05-13 16:16	2024-05-13 16:16	776.0	88.0	4.0	YES
16833.0	ADMIN	BRANCH	May	1715575453385	WO24210502	SAWIT TRUMON SEJATI	-	-	SDLG	L936H	620327	750	NON WARRANTY	RUNNING	-	TRUMON	MEDAN	Mandatory Service 750 Hours Unit L936H SN 620327	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	mandatory service 750hm	Joys Alfedro Siregar	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2024-05-13 11:44	2024-05-13 11:44	2024-05-15 13:05	2024-05-16 08:09	2024-05-15 13:05	2024-05-16 15:30	2024-05-16 16:41	2024-05-16 16:42	2024-05-16 16:46	776.0	1855.0	39.0	YES
16834.0	ADMIN	BRANCH	May	1715580468238	WO24210525	MITRA TEHNIK, CV	-	-	SDLG	LG936L	607202	1802	NON WARRANTY	RUNNING	-	TANGERANG	JAKARTA	Labor PM 1750 SN.607202 LG 936 L	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Yusuf Rhama Dhani	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2024-05-13 13:07	2024-05-13 13:07	2024-05-15 09:35	2024-05-15 13:05	2024-05-15 09:35	2024-05-15 13:05	2024-05-15 14:59	2024-05-15 16:53	2024-05-15 16:54	776.0	212.0	5.0	YES
16835.0	ADMIN	BRANCH	May	1715581317197	WO24210528	MUNAWIR ST	-	-	SDLG	E660FL	626056	9.6	WARRANTY	-	-	KENDARI	KENDARI	Commissioning unit SDLG E660FL SN626056	ECT	INTERNAL SERVICE	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	arrive	Dirga Dwi Julianto Sahputra	Kendari Admin	81366256192	kendari.sbs@indotruck-utama.co.id	2024-05-13 13:21	2024-05-13 13:22	2024-05-13 13:51	2024-05-13 16:01	2024-05-13 13:51	2024-05-13 16:01	2024-05-13 13:52	2024-05-13 17:19	2024-05-14 03:56	776.0	159.0	0.0	YES
16839.0	ADMIN	BRANCH	May	1715300980754	WOCE209997	CAKRAWALA KENCANA INDONESIA, PT	-	-	VCE	R60D	111097	2382	WARRANTY	STANDBY	2024-05-10 00:00:00.0000000	AKBP SEBAMBAN	BANJARMASIN	BATTERY NOT SAVE VOLTAGE	ELECTRICAL	OTHER	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Machine Redy For Use after replace Battrey	Agus Riyanto	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2024-05-10 07:29	2024-05-10 07:29	2024-05-10 07:30	2024-05-10 07:30	2024-05-10 07:30	2024-05-10 07:30	2024-05-11 20:35	2024-05-11 20:36	2024-05-11 20:40	780.0	1.0	37.0	YES
16840.0	ADMIN	BRANCH	May	1715308441700	WOCE210213	INDOTRUCK UTAMA, PT.	-	-	VCE	ECR88	10486	24	NON WARRANTY	RUNNING	-	WS JKT	JAKARTA	Warranty Claim Battery Management Unit - Chapter 2	ENGINE	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	July	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2024-05-10 09:34	2024-05-10 09:34	2024-05-10 09:35	2024-05-10 09:35	2024-05-10 09:35	2024-05-10 09:35	2024-05-10 15:58	2024-05-10 15:58	2024-05-10 15:58	779.0	2.0	6.0	YES
16841.0	ADMIN	BRANCH	May	1715308654406	WO24210320	DERMAGA SUKSES MANDIRI, PT.	-	-	SDLG	E6138F	606455	1100	NON WARRANTY	RUNNING	-	MANDAILING NATAL	MEDAN	Re-Ins Radiator, Incl Flushing Fuel Tank Unit E6138F SN 606455	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	unit RFU, Back to office	ALIF OKTAVIRA	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2024-05-10 09:37	2024-05-10 09:37	2024-05-10 09:46	2024-05-12 09:41	2024-05-10 09:46	2024-05-12 09:41	2024-05-13 10:56	2024-05-13 11:46	2024-05-13 11:47	779.0	2884.0	73.0	YES