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
4780.0	ADMIN	BRANCH	May	1685436785887	WO23180035	TIBER JAYA MANDIRI, PT	-	-	SDLG	E6210F	609694	-	WARRANTY	RUNNING	2023-05-03 00:00:00.0000000	JUATA	TARAKAN	SERVICE 250 HRS	ETC	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	Job Finish	Taufik Bahtiar	Tarakan Admin	89538317607	tarakan.sbs@indotruck-utama.co.id	2023-05-30 15:53	2023-05-30 15:53	2023-05-30 15:57	2023-05-30 16:13	2023-05-30 15:57	2023-05-30 16:13	2023-05-30 16:45	2023-05-30 16:55	2023-05-30 16:56	1125.0	20.0	0.0	YES	0.0
4781.0	ADMIN	BRANCH	May	1685440387883	WO23180038	DERMAGA SUKSES MANDIRI, PT.	-	-	SDLG	LG936L	605078	14500	NON WARRANTY	RUNNING	-	MEDAN	MEDAN	Maintenance Service 14.500 Hours LG936 L SN 605078	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	finish	Ferdian Dinata	Medan Admin	81366256197	medan.sbs@indotruck-utama.co.id	2023-05-30 16:53	2023-05-30 16:53	2023-05-30 17:54	2023-05-30 17:54	2023-05-30 17:54	2023-05-30 17:54	2023-05-30 21:22	2023-05-31 08:03	2023-05-31 08:03	1125.0	62.0	4.0	YES	0.0
4782.0	ADMIN	BRANCH	May	1685441303741	WO23180045	HUTAMA KARYA INFRASTRUKTUR PT	-	-	SDLG	E690F	VLGE609FEK0600633	6001	NON WARRANTY	RUNNING	-	PURWOKERTO	SEMARANG	VLGE609FEK0600633 WO23180045 T/S HYDRAULIC SYSTEM SDLG Hutama Karya Infrastruktur. PT 1601 ITU-000009354 SRWE Invoiced Triyono Smg 5/30/2023 12.00	ELECTRICAL	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	-	Semarang Admin	Semarang Admin	82354650320	semarang.sbs@indotruck-utama.co.id	2023-05-30 17:08	2023-05-30 17:08	2023-05-30 17:08	2023-05-30 17:08	2023-05-30 17:08	2023-05-30 17:08	2023-05-31 14:31	2023-05-31 14:31	2023-05-31 14:31	1125.0	0.0	21.0	YES	0.0
4783.0	ADMIN	BRANCH	May	1685503042292	WO23180031	GUNUNGMAS SUKSES MAKMUR, PT	-	-	VT	FMX40064R	888871	8299	NON WARRANTY	RUNNING	-	SANGA-SANGA	SAMARINDA	SERVICE 250 HRS VT 47	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Ready for use	Heru Priyoga	Samarinda Admin	82353253757	samarinda.sbs@indotruck-utama.co.id	2023-05-31 10:17	2023-05-31 10:17	2023-05-31 10:18	2023-05-31 11:58	2023-05-31 10:18	2023-05-31 11:58	2023-05-31 16:05	2023-05-31 17:02	2023-05-31 17:13	1124.0	101.0	5.0	YES	0.0
4784.0	ADMIN	BRANCH	May	1685331069449	WO23179933	SUPRIADI	-	-	VCE	EC200D	281339	250	WARRANTY	RUNNING	2023-05-29 00:00:00.0000000	Malili	MAKASSAR	Service Mandatory 250H	ENGINE	INTERNAL SERVICE	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	completed	wahyu sugiono	Makasar Admin	81997982056	makasar.sbs@indotruck-utama.co.id	2023-05-29 10:31	2023-05-29 10:31	2023-05-29 10:35	2023-05-30 06:05	2023-05-29 10:35	2023-05-30 06:05	2023-05-31 07:09	2023-06-01 07:33	2023-06-02 04:36	1126.0	1174.0	44.0	YES	0.0
4785.0	ADMIN	BRANCH	May	1685336004497	WOCE179912	ULIMA NITRA, PT	-	-	VCE	EC480DL	-	15458	WARRANTY	RUNNING	-	BGG	MUARA ENIM	Replace Hose High AC AB185 EC480DL VCRM PT UN	ECT	REPAIR	ON CALL	-	-	-	LEADER	COMPLETED	COMPLETED	pulang ke office ITU	M. Bimo Tegar Setiawan	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-05-29 11:53	2023-05-29 14:16	2023-05-31 12:18	2023-05-31 15:39	2023-05-31 12:18	2023-05-31 15:39	2023-05-31 17:07	-	2023-06-01 07:23	1126.0	3106.0	51.0	YES	142.0
4786.0	ADMIN	BRANCH	May	1685336564380	WO23179901	LANGGENG DAYA AGRINDO, PT.	-	-	VCE	A40G	324475	4400	WARRANTY	RUNNING	-	BGG	MUARA ENIM	PM 4400 H AD67 PT LDA	ENGINE	INTERNAL SERVICE	CSA/SERVICE CONTRACT	-	-	-	LEADER	COMPLETED	COMPLETED	Sampai di PT ITU ENIM	Aditya Ryan Saputra	Muara Enim Admin	81366256198	muaraenim.sbs@indotruck-utama.co.id	2023-05-29 12:02	2023-05-29 14:13	2023-05-31 08:22	2023-05-31 21:26	2023-05-31 08:22	2023-05-31 21:26	2023-06-01 06:24	2023-06-01 07:22	2023-06-01 07:24	1126.0	926.0	24.0	YES	131.0
4787.0	MECHANIC	MECHANIC	May	1685342115148	0	FONTANA RESOURCES INDONESIA, PT	-	-	VCE	A40F	52954	30286	NON WARRANTY	RUNNING	2023-05-29 00:00:00.0000000	Muara Teweh	BANJARMASIN	Actived caretrack	ELECTRICAL	OTHER	CSA/SERVICE CONTRACT	-	-	-	NON LEADER	COMPLETED	COMPLETED	READY	Ihza Assajadin. A	Ihza Assajadin. A	081254972796	assazadinizha@gmail.com	2023-05-29 13:35	2023-05-29 13:36	2023-05-29 13:37	2023-05-29 13:37	2023-05-29 13:37	2023-05-29 13:37	2023-05-29 13:45	2023-05-29 13:46	2023-05-29 13:46	1126.0	3.0	0.0	YES	0.0
4788.0	ADMIN	BRANCH	May	1685359485055	WO23179918	SARANA SUKSES SEJAHTERA, PT	-	-	VT	FMX40064R	B408443	169	STOCK	STANDBY	-	AMGA - CIKARANG	JAKARTA	Prepare and PDI unit at AMGA - Cikarang	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Ihwan Dwi	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-29 18:24	2023-05-29 18:25	2023-05-30 10:39	2023-05-30 13:58	2023-05-30 10:39	2023-05-30 13:58	2023-05-30 20:02	2023-05-30 20:03	2023-06-02 14:29	1126.0	1174.0	25.0	YES	0.0
4789.0	ADMIN	BRANCH	May	1685359901566	WO23179921	SARANA SUKSES SEJAHTERA, PT	-	-	VT	FMX40064R	A314753	-	STOCK	STANDBY	-	AMGA - CIKARANG	JAKARTA	Prepare and PDI unit at AMGA - Cikarang	ECT	INSPECTION	INTERNAL	-	-	-	LEADER	COMPLETED	COMPLETED	done	Mochamad Aniqun Umar Farauq	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2023-05-29 18:31	2023-05-29 18:31	2023-05-31 18:00	2023-05-31 18:01	2023-05-31 18:00	2023-05-31 18:01	2023-05-31 18:01	2023-05-31 18:02	2023-05-31 18:02	1126.0	2849.0	47.0	YES	0.0