Dashboard/ materials/ #69906

materials #69906

id
INTEGER
69906
category_id
INTEGER
39 → material_categories
location_text
VARCHAR
null
part_name
VARCHAR
PRESSOSTATO
part_type
VARCHAR
NARDI PACIFIC210
description
TEXT
PRESSOSTATO 330BAR COMPRESSOR AR NARDI PACIFIC 210. PRESSOSTATO ESCALA 330BAR APLICACAO COMPRESSOR AR MODELO NARDI PACIFIC210 PRESSURE SWITCH 330BAR APPLICATION CHUCK BLOCK AIR COMPRESSOR MODEL P, 210 RESPIRE/EL NG. Aplicação: COMPRESSOR DE AR RESPIRAVEL.
Model No: NARDI PACIFIC210 | Part No: PA116-001-330
image_path
VARCHAR
null
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-09-01T08:42:55.094680
updated_at
TIMESTAMP
2026-09-01T08:42:55.248965
brand
VARCHAR
null
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-09-01T08:42:55.184983
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
1 → warehouses
shelf_id
INTEGER
180 → shelves
rack_id
INTEGER
44 → racks
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": "NARDI PACIFIC210", "part_number": "PA116-001-330", "source": "yard"}
cross_reference_id
VARCHAR
DE-69906
source_type
VARCHAR
yard_nameplate
ai_status
VARCHAR
null
ai_result_json
JSONB
null
label_image_path
VARCHAR
null
bin_id
INTEGER
355 → bins
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
sub_segment_id
INTEGER
null
section_id
INTEGER
null
instance_label
VARCHAR
null
needs_review
BOOLEAN
False
review_reason
VARCHAR
null
spare_part_number
VARCHAR
null
mfg_part_number
VARCHAR
null
original_location
VARCHAR
null