iadc_product_specs #27288

id
INTEGER
27288
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
651750
value
TEXT
CAPSCREW, HEX HEAD 3/8 IN 16 X 4 GRADE 8 ZINC PLATED 3/8" 4" YELLOW FINISH CAP | MFR: LAW | P/N: 651750 | MFG#: A644
key_normalized
VARCHAR
651750
value_normalized
VARCHAR
capscrew, hex head 3/8 in 16 x 4 grade 8 zinc plated 3/8" 4" yellow finish cap | mfr: law | p/n: 651750 | mfg#: a644
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.424559
source_page
INTEGER
null
source_context
TEXT
part_number: 651750 | description: CAPSCREW, HEX HEAD 3/8 IN 16 X 4 GRADE 8 ZINC PLATED 3/8" 4" YELLOW FINISH CAP | manufacturer: LAW | mfg_part_number: A644 | qty_on_hand: 0 | uom: EA