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
44696.0	ADMIN	BRANCH	June	1781517486749	WO26263654	Cahya Vidi Abadi, PT	085355344648	Pak Ariyanto	VCE	SD110	59599	250	WARRANTY	RUNNING	2026-06-15 00:00:00.0000000	PULAU RIMAU BANYUASIN	PALEMBANG	Service maintenance 250 hours	MACHINE COMPLETE	INTERNAL SERVICE	INTERNAL	PM1 - 250h	Interval Service Maintenance	Performing routine periodic service	LEADER	PENDING	OTHERS	-	Binharun Sipahutar	Palembang Admin	81271778108	palembang.sbs@indotruck-utama.co.id	2026-06-15 16:58	2026-06-15 16:58	-	-	-	-	-	-	-	1.0	4.0	-	-	0.0
44697.0	ADMIN	BRANCH	June	1781518468497	WO26263655	BORLINDO MANDIRI JAYA, PT.	+62 811-4140-1610	Admin Borlindo	VB	B8R	215253	243407	WARRANTY	RUNNING	2026-06-15 00:00:00.0000000	PALU	PALU	Calibration air suspension BMJ52 SN215253 B8R	BRAKE	INSPECTION	INTERNAL	RPR1	Repair, minor	Repairing small components. Alternator, Compressor, etc.	LEADER	PENDING	-	-	Abi Hurairah Maladi	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2026-06-15 17:14	2026-06-15 17:14	2026-06-15 17:21	2026-06-15 18:08	2026-06-15 17:21	2026-06-15 18:08	2026-06-15 19:11	2026-06-15 19:50	-	1.0	54.0	1.0	-	0.0
44698.0	ADMIN	BRANCH	June	1781518468505	WO26263655	BORLINDO MANDIRI JAYA, PT.	+62 811-4140-1610	Admin Borlindo	VB	B8R	215253	243407	WARRANTY	RUNNING	2026-06-15 00:00:00.0000000	PALU	PALU	Calibration air suspension BMJ52 SN215253 B8R	BRAKE	INSPECTION	INTERNAL	RPR1	Repair, minor	Repairing small components. Alternator, Compressor, etc.	NON LEADER	PENDING	-	-	Angga Maulana	Palu Admin	81271778109	palu.sbs@indotruck-utama.co.id	2026-06-15 17:14	2026-06-15 17:15	2026-06-15 17:15	2026-06-15 18:06	2026-06-15 17:21	2026-06-15 18:12	2026-06-15 23:40	-	-	1.0	52.0	6.0	-	0.0
44699.0	ADMIN	BRANCH	June	1781535188187	-	AL HIJRAH AULIA RAHMAH, PT	-	-	VB	B11R	7022	-	NON WARRANTY	RUNNING	2026-06-15 00:00:00.0000000	WS ITU	JAKARTA	Basic Service I, BA 7022 WBU	ENGINE	INTERNAL SERVICE	FIELD CALL/EXTERNAL	OTH	Other	Performing tasks not listed above	NON LEADER	PENDING	-	-	zulaika sulthonia	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2026-06-15 21:53	2026-06-15 21:53	2026-06-16 10:36	2026-06-16 10:36	2026-06-16 10:36	2026-06-16 10:36	2026-06-16 20:55	2026-06-16 20:55	-	1.0	764.0	23.0	-	0.0
44700.0	ADMIN	BRANCH	June	1781569312924	0	BERAU BATU BARA TERMINAL, PT	0	0	VCE	A40J	0	0	WARRANTY	RUNNING	2026-06-16 00:00:00.0000000	SUKAN	BERAU	Service 1000 hrs	MACHINE COMPLETE	INTERNAL SERVICE	INTERNAL	PM3 - 1000h	Interval Service Maintenance	Performing routine periodic service	LEADER	PENDING	-	-	Syahrul	Berau Admin	85228555523	berau.sbs@indotruck-utama.co.id	2026-06-16 07:21	2026-06-16 07:23	2026-06-16 07:50	2026-06-16 19:06	2026-06-16 07:50	2026-06-16 19:06	2026-06-16 19:09	2026-06-16 19:09	-	1.0	705.0	11.0	-	1.0
44701.0	ADMIN	BRANCH	June	1781569313056	0	BERAU BATU BARA TERMINAL, PT	0	0	VCE	A40J	0	0	WARRANTY	RUNNING	2026-06-16 00:00:00.0000000	SUKAN	BERAU	Service 1000 hrs	MACHINE COMPLETE	INTERNAL SERVICE	INTERNAL	PM3 - 1000h	Interval Service Maintenance	Performing routine periodic service	NON LEADER	PENDING	-	-	Ongki Glendika	Berau Admin	85228555523	berau.sbs@indotruck-utama.co.id	2026-06-16 07:21	2026-06-16 07:22	2026-06-16 19:21	2026-06-16 19:22	2026-06-16 19:21	2026-06-16 19:22	2026-06-16 19:23	2026-06-16 19:23	-	1.0	720.0	12.0	-	0.0
44702.0	ADMIN	BRANCH	June	1781572551054	‪‪‪WO26263713	AEROBUS TRANSPORT MANUNGGAL, PT	081371850825	Pak Adit	VB	B11R	B11R215357	12101.6	NON WARRANTY	RUNNING	2026-06-16 00:00:00.0000000	PEKANBARU	PEKANBARU	Replace front air bellow	FRAME CHASIS	REPAIR	REPAIR/OVERHAUL	RPR1	Repair, minor	Repairing small components. Alternator, Compressor, etc.	LEADER	COMPLETED	OTHERS	-	Firman	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2026-06-16 08:15	2026-06-16 08:17	2026-06-16 13:38	2026-06-16 15:11	2026-06-16 13:38	2026-06-16 15:11	2026-06-16 16:58	2026-06-16 18:59	2026-06-17 08:26	1.0	114.0	3.0	YES	2.0
44703.0	ADMIN	BRANCH	June	1781572551059	‪‪‪WO26263713	AEROBUS TRANSPORT MANUNGGAL, PT	081371850825	Pak Adit	VB	B11R	B11R215357	12101.6	NON WARRANTY	RUNNING	2026-06-16 00:00:00.0000000	PEKANBARU	PEKANBARU	Replace front air bellow	FRAME CHASIS	REPAIR	REPAIR/OVERHAUL	RPR1	Repair, minor	Repairing small components. Alternator, Compressor, etc.	NON LEADER	COMPLETED	OTHERS	-	Dzaki Arafiadi	Pekanbaru Admin	8127600946	pekanbaru.sbs@indotruck-utama.co.id	2026-06-16 08:15	2026-06-16 08:16	2026-06-16 13:46	2026-06-16 16:08	2026-06-16 13:46	2026-06-16 16:08	2026-06-16 17:02	2026-06-16 19:40	2026-06-17 08:27	1.0	163.0	3.0	YES	0.0
44704.0	ADMIN	BRANCH	June	1781574328678	-	WAHYU PUTRA RAMADHAN, PT.	-	-	VCE	JL25	1321132	454	WARRANTY	STANDBY	2026-06-16 00:00:00.0000000	ASAM-ASAM	BANJARMASIN	COMMISSIONING MACHINE NEW ARRIVAL L25H SN1321132	ENGINE	INSPECTION	INTERNAL	DI/COM	Delivery Instruction / Commissioning	Conducting commissioning and field guidance for received units	LEADER	PENDING	-	-	Zainur Yahya Imran	Banjarmasin Admin	81331838431	banjarmasin.sbs@indotruck-utama.co.id	2026-06-16 08:45	2026-06-16 08:45	2026-06-16 09:01	-	2026-06-17 05:34	-	-	-	-	1.0	-	-	-	0.0
44705.0	ADMIN	BRANCH	June	1781574470211	-	AL HIJRAH AULIA RAHMAH, PT	-	-	VB	B11R	7043	-	WARRANTY	RUNNING	2026-06-16 00:00:00.0000000	Ws itu	JAKARTA	Basic Service IV. BA 7043 WU	ENGINE	INTERNAL SERVICE	INTERNAL	OTH	Other	Performing tasks not listed above	LEADER	PENDING	-	-	Anwar Septian Pratama	Jakarta Admin	85219742048	jakarta.sbs@indotruck-utama.co.id	2026-06-16 08:47	2026-06-16 08:48	2026-06-16 10:21	2026-06-16 10:21	2026-06-16 10:21	2026-06-16 10:21	2026-06-16 10:22	2026-06-16 10:22	-	1.0	94.0	1.0	-	0.0