materials #28617

id INTEGER	28617
category_id INTEGER	22 → material_categories
location_text VARCHAR	null
part_name VARCHAR	SITRANS PROBE LU
part_type VARCHAR	DRILER'S CONSOLE MONITORING S
description TEXT	PROBE, SITRANS LU ULTRASONIC, 24 VDC, 4-20 MA, 2" NPT THREAT, 0 TO 12 METERS, FOR MUD PITS, LEVEL SENSOR, P/N: ML5221-1DA18 HAS 2 X M20 ENTRYS Model No: DRILER'S CONSOLE MONITORING S \| Part No: 7ML5221-1DA18 \| Serial No: SPBD M1240084
image_path VARCHAR	null
is_active BOOLEAN	Active
created_at TIMESTAMP	2026-07-15T11:40:19.125028
updated_at TIMESTAMP	2026-07-15T11:40:19.160706
brand VARCHAR	Siemens
iadc_discovered_material_id INTEGER	null
source_vessel_id INTEGER	null
pipeline_status ENUM	PUBLISHED
ready_for_sale BOOLEAN	False
is_published BOOLEAN	True
is_sold BOOLEAN	False
published_at TIMESTAMP	2026-07-15T11:40:19.129388
sold_at TIMESTAMP	null
estimated_value NUMERIC	null
asking_price NUMERIC	null
sold_price NUMERIC	null
currency VARCHAR	USD
condition_grade VARCHAR	null
condition_notes TEXT	null
warehouse_id INTEGER	null
shelf_id INTEGER	null
rack_id INTEGER	null
basket_id INTEGER	null
quantity INTEGER	1
unit VARCHAR	null
is_iadc_sourced BOOLEAN	False
iadc_section_id VARCHAR	null
iadc_subcategory VARCHAR	null
storefront_enabled BOOLEAN	False
is_iadc BOOLEAN	False
iadc_category VARCHAR	null
make VARCHAR	null
model VARCHAR	null
publish_flag VARCHAR	PUBLISH
attributes JSON	{"model_number": "DRILER'S CONSOLE MONITORING S", "part_number": "7ML5221-1DA18", "serial_number": "SPBD M1240084", "source": "yard"}
cross_reference_id VARCHAR	DE-28617
source_type VARCHAR	yard_nameplate
ai_status VARCHAR	null
ai_result_json JSONB	null
label_image_path VARCHAR	null
bin_id INTEGER	null
documents JSON	null
parent_material_id INTEGER	null
sub_category_id INTEGER	null
segment_id INTEGER	null
availability_override VARCHAR	null
brand_label VARCHAR	null
condition VARCHAR	New
sale_grade VARCHAR	Excellent