iadc_product_specs #31826

id
INTEGER
31826
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
651797
value
TEXT
CAPSCREW, HEX HEAD 9/16 IN X 1 NC GRADE 8 YELLOW ZINC PLATED 9/16" 12 1" FINISH | MFR: TFC | P/N: 651797 | MFG#: 63308
key_normalized
VARCHAR
651797
value_normalized
VARCHAR
capscrew, hex head 9/16 in x 1 nc grade 8 yellow zinc plated 9/16" 12 1" finish | mfr: tfc | p/n: 651797 | mfg#: 63308
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.429318
source_page
INTEGER
null
source_context
TEXT
part_number: 651797 | description: CAPSCREW, HEX HEAD 9/16 IN X 1 NC GRADE 8 YELLOW ZINC PLATED 9/16" 12 1" FINISH | manufacturer: TFC | mfg_part_number: 63308 | qty_on_hand: 0 | uom: EA