Fields that are included when viewing a bid on the supplier side in BidCQ, and their definitions.
For more details on each of these fields, refer to the BidCQ Field Definition Sheet that includes further info such as where each field is located within the CQ, character count/field limitations, and other misc. information pertaining to these fields. (We recommend using the ctrl + F, or cmmd + F for the mac users out there, to keyword search this spreadsheet!)
Make sure you are on the "BidCQ Fields" Tab on the bottom left.
Basic Line Information
- Line
Definition: The unique line number corresponding to a specific MPN (Manufacturer Part Number) entry on the Bill of Materials (BOM).
Purpose: Helps maintain the original order of BOM components and supports tracking when referencing or exporting.
- Documents
Definition: Field for uploading important BOM-related files (e.g., datasheets, specifications, test reports).
Purpose: Allows teams to provide suppliers with all the necessary documents directly within the bid sheet, reducing back-and-forth.
- Description
Definition: A textual description of the part, typically imported from the BOM via QuoteCQ.
Purpose: Provides a human-readable understanding of the part’s purpose or function.
- Part # Notes
Definition: A free-text note field associated with the part, editable across multiple views (BOM tab, Material Costing tab, and BidCQ).
Purpose: Used for internal notes, special instructions, or context about a part or sourcing decision.
Classification & Identification
- Part Class
Definition: Categorizes the part by type or commodity (e.g., resistor, capacitor, IC).
Purpose: Enables logic-based rule automation for attrition, lead time, or labor; supports filtering and reporting.
- Mfgr (Manufacturer)
Definition: The official name of the company that manufactures the part.
Purpose: Crucial for quality assurance, warranty, and sourcing accuracy.
- MPN (Manufacturer Part Number)
Definition: The exact part number assigned by the manufacturer.
Purpose: Serves as the primary identifier for quoting and sourcing.
- Customer Part # (CPN)
Definition: The part number used by the end customer/supplier (if different from the MPN).
Purpose: Useful in contract manufacturing scenarios or when customer-specific part numbers must be referenced.
- Internal Part # (IPN)
Definition: The part number used internally by the EMS/OEM quoting in CalcuQuote.
Purpose: Ensures consistency across quoting, ERP, and inventory systems.
Site & Supplier-Related Fields
- Site
Definition: The facility or location within the organization where the part demand is being generated.
Purpose: Allows consolidation and segregation of demand by site for more strategic sourcing.
- Supplier Quote No
Definition: The reference number assigned by the supplier to their formal quote.
Purpose: Useful for tracking and validating pricing during purchase order or audit processes.
- Quote Expiry Date
Definition: The expiration date for a supplier’s pricing offer on a line item.
Purpose: Indicates how long the quoted pricing is valid before requiring revalidation.
Part Alternatives & Statuses
- Cross Match MPN
Definition: A manufacturer part number that is functionally equivalent but may be from a different MFG (e.g., TI vs Texas Instruments).
Purpose: Useful for sourcing flexibility or part substitutions.
- Part Submit Status
Definition: Indicates the status of a part’s submission in the bid process:
- Submitted Part: Sent to the supplier for quoting.
- No Bid: Supplier has declined to quote this part.
- Pending: Part not yet submitted or awaiting additional information.
Purpose: Helps manage quote completeness and track progress.
- NoBid Reason
Definition: The reason a supplier gives for declining to quote a part (e.g., EOL, MOQ too high, non-stocked).
Purpose: Provides insight into sourcing challenges and potential roadblocks.
Quantity & Pricing Fields
- Order Qty
Definition: The quantity of parts needed for the job (QTY per assembly × total assemblies).
Purpose: Used as the basis for supplier quoting.
- Target Price
Definition: Desired or budgeted unit price for the part.
Purpose: Shared with suppliers to guide competitive quoting.
- Unit Price
Definition: Final quoted price per BOM UOM (e.g., per inch, per foot, each), including any necessary unit conversions.
Purpose: Used for final costing and supplier selection.
- Total Demand
Definition: Aggregated demand across multiple sites or builds.
Purpose: Suppliers may offer volume discounts based on total consolidated quantity.
- Min (Minimum Order Quantity)
Definition: The smallest quantity a supplier will quote at the listed price.
Purpose: Helps avoid rejections due to MOQ issues.
- Mult (Multiples)
Definition: Required order multiples (e.g., must order in packs of 5 or 25).
Purpose: Supports order rounding logic during purchasing.
Inventory & Packaging
- Stock
Definition: Supplier’s current available inventory for the part.
Purpose: Indicates availability and helps guide urgent purchases.
- Per Package Count
Definition: Number of individual items included per package (e.g., 10 screws per box).
Purpose: Clarifies unit pricing and ensures correct order conversion.
- Mfg Lead Time
Definition: Manufacturer's estimated time to produce and ship the part.
Purpose: Used for lead time planning and risk assessment.
- Lead Time UOM
Definition: Unit of measurement for lead time (e.g., Days, Weeks).
Purpose: Normalizes delivery expectations across suppliers.
- Lead Time to Cancel
Definition: The time window before shipment in which the order can be canceled.
Purpose: Reduces risk of NCNR exposure.
- On Order ETA
Definition: Estimated arrival time for parts already on order with a supplier.
Purpose: Helps in planning if inventory is not immediately available.
- On Order Qty
Definition: Quantity of the part already on the supplier’s incoming orders.
Purpose: Shows upcoming availability.
- Package
Definition: Type of packaging (e.g., Reel, Tray, Cut Tape).
Purpose: Impacts handling, machine setup, and cost.
Logistics, Compliance, and Legal
- Region
Definition: Geographic location of the inventory (e.g., North America, Asia).
Purpose: Important for lead times, tariffs, and shipping.
- RoHS
Definition: Indicates if the part is compliant with RoHS (Restriction of Hazardous Substances) regulations.
Purpose: Ensures environmental and regulatory compliance.
- NCNR (Non-Cancelable, Non-Returnable)
Definition: Flags whether the part can be canceled or returned after ordering.
Purpose: Critical for understanding financial liability.
- Is Custom Reel
Definition: Indicates if the quoted price assumes a custom reel configuration.
Purpose: Affects pricing and machine compatibility.
- Country of Origin
Definition: Country where the part was manufactured.
Purpose: Used for customs, tariffs, and compliance reporting.
- Delivery Terms
Definition: Terms of delivery specified by the supplier (e.g., FOB, EXW).
Purpose: Defines ownership and shipping responsibility.
- Authorized (Auth) Reseller
Definition: Indicates whether the supplier is an authorized distributor for the part’s manufacturer.
Purpose: Affects warranty and authenticity.
Supplier-Specific Fields
- Supplier SKU
Definition: Supplier’s internal part number (used in APIs or system integrations).
Purpose: Ensures exact part matching and avoids misorders.
- Supplier Description
Definition: Supplier’s version of the part description.
Purpose: May include additional or differing details not present in the original BOM.
- Note
Definition: A field for suppliers to provide comments or clarifications at the line item level.
Purpose: Helps clarify quotes, substitutions, or issues.