BFPL Truck Service Management

truck_part_id	part_name	service_type	part_number	model_id	stock_quantity	model	brand
102	Oil Filter 1	Engine Oil Change	21707134	7	500	Pulling	Volvo
103	Oil filter 2-Bypass	Engine Oil Change	21707132	7	0	Pulling	Volvo
104	Diesel Filter	Engine Oil Change	22480372	7	0	Pulling	Volvo
105	Water seperator	Engine Oil Change	21380488	7	0	Pulling	Volvo
106	Gear box oil filter	Transmission Oil Change	20779040	7	0	Pulling	Volvo
107	Air drier 1	Air Cleaner Element Change	21620181	7	0	Pulling	Volvo
108	Air cleaner 1	Air Cleaner Element Change	21834199	7	36	Pulling	Volvo
109	Air cleaner 2	Engine Oil Change	23429018	7	100	Pulling	Volvo
110	Steering power filter		21392404	7	0	Pulling	Volvo
111	Ac filter		20409908	7	0	Pulling	Volvo
112	Oil Filter 1		21707134	6	0	Semi	Volvo
113	Oil filter 2-Bypass		21707132	6	0	Semi	Volvo
114	Diesel Filter	Engine Oil Change	22480372	6	75	Semi	Volvo
115	Water seperator		21380488	6	0	Semi	Volvo
116	Gear box oil filter		20779040	6	0	Semi	Volvo
117	Air drier 1		23690622	6	0	Semi	Volvo
118	Air cleaner 1		21834199	6	0	Semi	Volvo
119	Air cleaner 2		23429018	6	0	Semi	Volvo
120	Steering power filter		21392404	6	0	Semi	Volvo
121	Ac filter		20409908	6	0	Semi	Volvo

Spare Parts