iadc_product_specs #31828

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