Create a specification record for each reel
Use one inventory row for each physically distinct reel. Transcribe manufacturer, full part number, conductor count and size, metal, marked voltage, shield or armor, and jacket designation from the reel or an actual matching product sheet. A facility label, machine name, or storage area may provide context, but it is not a cable specification.
Photograph the readable tag and jacket legend and use the reel ID in each filename. If printing is incomplete, retain the readable fragment and mark the unresolved field unknown. This approach lets the inventory describe what is evidenced rather than filling gaps with a similar product or equipment reference.
- Record reel ID, manufacturer or part number, conductor count and size, metal, voltage, shield or armor, and jacket designation.
- Tie tag and jacket photographs to the reel ID.
- Keep an unknown construction field explicit until a matching record resolves it.
Separate stock status from product construction
Give each reel a status: uninstalled maintenance stock, project-change stock, removed cable, or unknown. Add known service history, fitted ends, visible jacket damage, and storage exposure. A reel can have a clearly documented construction while its service history remains incomplete, so those fields should not be combined.
The City describes El Paso’s 21st-century economy as encompassing a major trade corridor with Mexico, advanced logistics, aerospace and defense, and a growing life-sciences education and services sector. That broad context supports separating plant and project-origin lines in a seller record; it does not identify a particular facility, cable lot, buyer, or demand.
- Record status, service history, fitted ends, jacket damage, and storage exposure.
- Keep an equipment tag in a context field rather than the cable-specification field.
- State unknown history rather than describing it as unused or removed without support.
Replace original quantities with current balances
Match the physical reel to an inventory export or product record and record the current continuous length. Label the number measured, documented, or estimated, and identify the reel as full or partial. The original purchase total may be useful background, but it is not proof that the same amount remains available.
When a record cannot be matched to the reel, keep the discrepancy visible. Do not average lengths across dissimilar reels or turn several partials into one continuous length. A candid current balance makes the inventory easier to review than a precise-looking total with no reel-level basis.
- Record current length, quantity basis, matching document or reel ID, and full or partial status.
- Keep a discrepancy note where the physical reel and old record do not align.
- Do not carry a historical order amount into the current-balance field.
Document release and access as separate facts
Add the storage location, practical access limits, available loading resources, and business authority that can release the material. A person who can show the inventory may not have authority to transfer it, so the authority field should be explicit. If the answer is pending, list it as pending rather than guessing.
These are seller-side facts for a lot-specific discussion. They do not promise removal, freight, payment, timing, or acceptance. Keeping them alongside the material record helps avoid treating a technical identification question as a logistics commitment.
- Record storage location, release authority, access limits, and loading resources.
- State pending or unknown authority clearly.
- Keep loading information descriptive rather than a promise of a moving arrangement.
Test the list with a fictional plant reel
Illustrative example only—not a purchased lot: IC-EP-01 has a recorded manufacturer part number, four conductors at 6 AWG, shield status unknown, and 420 feet documented. The condition field says uninstalled maintenance stock, while release authority is unknown. The example shows that a mostly complete specification can coexist with an honest release gap.
The recurring error is using a plant-equipment name as the product description and an old order quantity as present stock. Correct it by copying actual jacket or product-sheet data, retaining unknown details, and entering a reel-level current balance. That is the actionable seller task for this material.
- Example label: Illustrative example only—not a purchased lot.
- Use product facts, status facts, quantity facts, and release facts in separate fields.
