iadc_product_specs #31827

id
INTEGER
31827
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
651800
value
TEXT
CAPSCREW, 1/4 IN X 3 NC GRADE 8 HEX H EAD. 1/4" 20 3" YELLOW ZINC FINISH CAP | MFR: TFC | P/N: 651800 | MFG#: 63024
key_normalized
VARCHAR
651800
value_normalized
VARCHAR
capscrew, 1/4 in x 3 nc grade 8 hex h ead. 1/4" 20 3" yellow zinc finish cap | mfr: tfc | p/n: 651800 | mfg#: 63024
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: 651800 | description: CAPSCREW, 1/4 IN X 3 NC GRADE 8 HEX H EAD. 1/4" 20 3" YELLOW ZINC FINISH CAP | manufacturer: TFC | mfg_part_number: 63024 | qty_on_hand: 0 | uom: EA