Give every physical item a stable line ID
Use one inventory row for each reel, box, coil, or continuous piece. Assign a stable line ID and repeat it in the photo filenames, documents, and storage notes. A grand total may be useful as a summary, but it cannot replace the item-level record needed to verify product, footage, condition, and location.
If a reel has no formal tag, create a neutral internal reference and photograph it beside the reel. Do not reuse a line ID for different sites or different physical objects. The purpose is to make every submitted fact traceable to one inventory item.
- Line ID and reel ID.
- Matching photo filename.
- Record reference.
- One physical object or continuous piece per line.
Keep product and quantity facts at reel level
For each line, record manufacturer, part number, designation, metal, size and count, marked voltage, per-reel footage, and the quantity basis. State whether the footage is measured, documented, or estimated. When fields differ between reels, keep them different even if the products are ultimately discussed as one group.
Do not replace several lengths with a single total continuous length. A 500 ft documented reel and a 90 ft estimated reel can share a product description but are still different inventory records. This distinction is the buyer’s practical problem: a total hides which location and condition belongs to which cable.
- Manufacturer, part number, and designation.
- Metal, size and count, and marked voltage.
- Per-reel footage with its basis.
- Condition differences retained by line.
Map each line to its actual storage and release path
Add the storage location, site contact, release-authority role, access limits, and available loading equipment to every line. Keep those facts separate when matching reels are stored at different sites. A site contact may be able to show inventory without having authority to release it, so both roles should be recorded when known.
If a site field is unknown, leave it unknown and note the source that may resolve it, such as a property manager or asset-disposition contact. Do not use a single warehouse statement for multi-site inventory or imply that a loading method has been agreed.
- Storage location.
- Site contact.
- Release authority.
- Access limits and available loading equipment.
Define the grouping without losing the item detail
State whether the material is offered as one lot or in defined groups, but retain the individual line IDs inside every group. Add dimensions, weight basis, and handling restrictions to the line or group they actually describe. This makes a group usable without hiding the reels that create it.
The Mill Creek URA funds roads, utilities and traffic signals and lists completed public water, sewer, street improvements and utility construction. That public-project description does not identify a bulk cable lot or promise access; it simply makes seller-provided site and handling facts relevant to an itemized Salem inventory.
- Lot grouping.
- Dimensions and stated weight basis.
- Handling restrictions.
- No assumed access or transport arrangement.
Correct a grand total with a two-line example
An illustrative fictional record can keep two matching products distinct: BL-SALEM-A, one reel, 500 ft documented, Site A; and BL-SALEM-B, one reel, 90 ft estimated, Site B. Photo filenames match line IDs and release authority is recorded separately by site. This is not a purchased lot.
If an initial inquiry contains only a total, rebuild it one row at a time. That corrective task is different from the project-overrun page, which reconciles historical project records; here the core issue is preserving identity and access differences across multiple reels or storage sites.
- Per-reel line IDs.
- Per-reel footage and basis.
- Site-specific photo and release records.
