Dashboard/ materials/ #70048

materials #70048

id
INTEGER
70048
category_id
INTEGER
39 → material_categories
location_text
VARCHAR
null
part_name
VARCHAR
SENSOR FLUXO LIQUIDO/GAS DETEC
part_type
VARCHAR
SI-5000
description
TEXT
Detalhes: SENSOR FLUXO LIQUIDO/GAS DETEC HAST MAGN ALIM 19-36V PROC M18X1,50 CON ELETR C/CONECT M12 4PINOS PROGR IP6. Descrição Detalhada: SENSOR FLUXO LIQUIDO/GAS DETEC HAST MAGN PROCESSO M18X1,50 CONEXAO ELETRIC SAIDA PNI/NPI AISI 316S12 SENSOR, LIQUID/GAS FLOW BEGIN MAGNETONNE M18X1,50 ELECTRIC CONNECTIROGR EXIT SIGNAL. Aplicação: SENSOR MAGNETIC - ANCHOR WINCH HEA EXCHANGER # SC PRIORITY 1.
Model No: SI-5000 | Part No: SI-5000 , SID10ABBPKG/US
image_path
VARCHAR
null
is_active
BOOLEAN
Active
created_at
TIMESTAMP
2026-09-02T07:01:55.723381
updated_at
TIMESTAMP
2026-09-02T07:01:55.812166
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-02T07:01:55.775016
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
181 → 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": "SI-5000", "part_number": "SI-5000 , SID10ABBPKG/US", "tag_number": "30149370", "source": "yard"}
cross_reference_id
VARCHAR
DE-70048
source_type
VARCHAR
yard_nameplate
ai_status
VARCHAR
null
ai_result_json
JSONB
null
label_image_path
VARCHAR
null
bin_id
INTEGER
360 → 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