BOM-Spaltendetails

The line number from the source file. Reference only.

So wird die Spalte ausgefüllt

A running number for human reference only. Better not use '#' as the header.

Auch erkannt als

Line #, Line no., Row, Regel

Reference designators of the component on the PCB (R1, C2, U3). A row may list several, separated by comma, semicolon or space; the quantity of the line is the number of designators.

So wird die Spalte ausgefüllt

The unique name of the component in the design, according to IPC. Separate several designators with a comma: C1, C2, C3, C4, C5. Do not contract ranges (C1-C5 or C1…C5); they are easily misread. Sorting the designators alphabetically helps readability.

Auch erkannt als

Des., Ref. Des., RefDes, Reference

Quantity per board. Only cross-checked against the number of designators — the designators are what actually determines the quantity.

So wird die Spalte ausgefüllt

The number of designators on the line. Our software counts the designators itself and only uses this column as a cross-check.

Auch erkannt als

Quantity, Aantal, Amount

Placement flag: whether this component is placed on the board. Also use it for a 'Fitted'/'Populate' column — the column does not need a particular wording, because each value is resolved separately.

So wird die Spalte ausgefüllt

DNP: none of the designators on the line is placed. A designator (C3): only that designator of the line is not placed. This column matters for correct purchasing and assembly and usually has to be added by hand.

Auch erkannt als

Do Not Place, DNA, Do Not Assemble, NP, No Place, Niet plaatsen

So werden die Werte gelesen

Each distinct value in the column resolves to PLACE, DO_NOT_PLACE or IGNORE (skip the row entirely). Resolution order: (1) an explicit per-value mapping for this import, if one is set; (2) self-describing words — DO_NOT_PLACE for dnp, dna, dni, np, do not place/populate/fit/load, not fitted, unfitted, not populated, unpopulated, not placed, not mounted, no load, no stuff; PLACE for fitted, fit, place, placed, populate, populated, load, loaded, assemble, assembled, mount, mounted, stuff, stuffed (case-insensitive); (3) for anything left over, an empty cell means PLACE, and if the column has no self-describing word at all (yes/no, 1/0, x/blank) the MOST COMMON value is assumed to be PLACE and every other value DO_NOT_PLACE — because most parts on a board are placed. A column holding reference designators rather than a flag, or more than 4 distinct values, is not mapped at all: it falls back to reading a comma-separated list as the designators NOT to place, and any other text as 'this whole line is do-not-place'. If the column ALWAYS names designators, map it to DO_NOT_PLACE_DESIGNATOR instead of relying on that guess. Check the resolved mapping before importing; the frequency rule is a guess and it is wrong for a board where most parts are unplaced.

Flag marking that the customer supplies this component themselves.

So wird die Spalte ausgefüllt

CC (Consigned by Customer) or KLA (Klant Levert Aan): you supply this component yourself. Any value in this column marks the line as customer-supplied, so leave it empty for parts we purchase. Usually added by hand.

Auch erkannt als

KLA, CC, Consigned by Customer, Customer supplied, Klant levert aan

So werden die Werte gelesen

Presence-only: ANY non-empty value marks the line as customer-supplied, including 'no', 'n' and 'false'. There is no per-value mapping, so a column that spells out both answers must not be mapped here — only map a column where a filled cell genuinely means 'the customer supplies this part'.

Free text describing the component: value, tolerance, voltage and power rating, footprint/package, dielectric, temperature coefficient. A BOM may spread this over several columns (Value, Tolerance, Footprint, Package): every column carrying such text is read as DESCRIPTION and they are joined into one description in column order. This is the text the component specification is parsed from, so more detail here means better matching. Part numbers and manufacturer names do not belong here.

So wird die Spalte ausgefüllt

Free text describing the component. Our software analyses it to derive the value, and it is shown in the BOM Search Tool when a part has to be selected by hand.

Auch erkannt als

Omschrijving

Free text describing the component: value, tolerance, voltage and power rating, footprint/package, dielectric, temperature coefficient. A BOM may spread this over several columns (Value, Tolerance, Footprint, Package): every column carrying such text is read as DESCRIPTION and they are joined into one description in column order. This is the text the component specification is parsed from, so more detail here means better matching. Part numbers and manufacturer names do not belong here.

Value

So wird die Spalte ausgefüllt

Capacitors, in this order: capacitance, tolerance, voltage, dielectric and optionally the package: 100nF 10% 25V X7R 0603. Resistors: resistance, tolerance, power and optionally the package: 100k 10% 100mW 0603. Separate the variables with a space (100nF-10%-25V-X7R and 100nF/10%/25V/X7R are read as well). Units: fF pF nF uF mF F and mR R k M (R may be written E, Ω or Ohm); keep the number between 1 and 999, so 10nF rather than 10.000pF or 0.01uF. A part given by value only may be replaced by an equivalent part with the same value. An MPN may also be put here.

Auch erkannt als

Val, Waarde

PackageEmpfohlenmay be left out when the package is already part of the Value

So wird die Spalte ausgefüllt

The component size in inches, IPC notation: 0603, 0805, 1206. The metric code may follow between brackets: 0603 (1608).

Auch erkannt als

Footprint, Case, Case/Package, Housing, Shape

Manufacturer name of the preferred part.

So wird die Spalte ausgefüllt

Not needed when the MPN is given: an MPN is (almost) always unique on its own.

Auch erkannt als

Man., Mfr, Mfg, Fabrikant, Hersteller

Manufacturer part number of the preferred part.

So wird die Spalte ausgefüllt

The part number exactly as the manufacturer writes it in the datasheet. Alternative parts go in their own columns (MPN 2, MPN 3, …) rather than in the same cell.

Auch erkannt als

Manufacturer Part Number, Man Part Number, Part Number, Mfr Part No, Part no.

Distributor name of the preferred supplier part.

So wird die Spalte ausgefüllt

The supplier the part can be bought from. We purchase from Arrow, Digi-Key, Farnell, LCSC, Mouser, RS and TME; a part that none of them stocks we ask you to supply. Supplier plus SKU removes any doubt about which part is meant.

Auch erkannt als

Sup., Sup1, Distributor, Leverancier

Order number at the distributor named in SUPPLIER_1.

So wird die Spalte ausgefüllt

The supplier's order number of the exact part. It also pins down the packaging (cut tape, reel) and shipping variant, which an MPN alone does not.

Auch erkannt als

Supplier part number, Order number, Order code, Distributor code, Bestelnummer

Customer part number — the customer's own internal reference for this component.

So wird die Spalte ausgefüllt

Your own internal article number. We keep it with the line for reference.

Auch erkannt als

Customer part number, Company part number, Internal part number, Art. no.

A remark or instruction from the customer about this component.

So wird die Spalte ausgefüllt

Extra information for our engineers, in plain text. Use it sparingly: it is read by people, not by the import, so an instruction here can be missed.

Auch erkannt als

Remarks, Note, Notes, Opmerking

Whether an equivalent part may be substituted when the specified one is unavailable.

So wird die Spalte ausgefüllt

Yes when an equivalent part may be substituted if the specified one is unavailable, no when only the exact part will do. Leave the cell empty to keep our default for the line.

Auch erkannt als

Alternative allowed, Alternatives allowed, Alternative, Alt. allowed

So werden die Werte gelesen

Each distinct value resolves to YES, NO or IGNORE (skip the row). Resolution order: (1) an explicit per-value mapping for this import; (2) YES for y, yes, ja, j, true, t, 1, allow, allowed, allow alternatives, alternatives allowed, on, x, v, ✓ and NO for n, no, nee, niet, non, false, f, 0, not allowed, disallow, disallowed, off, -, ✗ (case-insensitive). A value matching neither leaves the line's setting untouched rather than guessing.