Détail des colonnes de la nomenclature

Vous n'avez pas besoin de cette page pour commander. Nous lisons la nomenclature exportée par votre logiciel de CAO ; il n'y a rien à adapter. Cette page est pour qui veut savoir à quoi ressemble notre mise en page standardisée et ce que nous lisons dans chaque colonne. Retour à la Nomenclature (BOM).

Le guide ci-dessous vient directement des définitions avec lesquelles travaille notre outil d'import. Changez un nom de colonne, une description ou une règle de notation dans l'outil, et cette page change avec.

Le guide des colonnes est en anglais : c'est exactement le texte utilisé par notre outil d'import et par nos ingénieurs.

Line

Facultatif

The line number from the source file. Reference only.

Comment remplir la colonne: A running number for human reference only. Better not use '#' as the header.
Également reconnu comme: Line #, Line no., Row, Regel

Designator

Obligatoire

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.

Comment remplir la colonne: 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.
Également reconnu comme: Des., Ref. Des., RefDes, Reference

Qty (Quantity)

Facultatif

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

Comment remplir la colonne: The number of designators on the line. Our software counts the designators itself and only uses this column as a cross-check.
Également reconnu comme: Quantity, Aantal, Amount

Do-not-place (DNP)

Recommandé

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.

Comment remplir la colonne: 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.
Également reconnu comme: Do Not Place, DNA, Do Not Assemble, NP, No Place, Niet plaatsen
Comment les valeurs sont lues: 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.

Colonnes associées

Ne Pas Placer (Désignateur): Which designators OF THIS ROW are not placed, when a row covers several designators and only some of them are unplaced. A row with designators R1,R2,R3,R4 and "R2,R4" in this column keeps R1 and R3 placed. Use this rather than DO_NOT_PLACE whenever the column holds designators instead of a yes/no-style flag.The cell lists designators, not a flag. Tokens may be separated by comma, semicolon or whitespace and are matched case-insensitively against the designators of the SAME row; every designator named is marked not-placed and the rest of the row stays placed. An empty cell means the whole row is placed. A token that names no designator on the row changes nothing and is reported as an import error, so a mis-mapped column shows up instead of silently doing nothing.

KLA-CC (Klant Levert Aan / Consigned by Customer)

Recommandé

Flag marking that the customer supplies this component themselves.

Comment remplir la colonne: 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.
Également reconnu comme: KLA, CC, Consigned by Customer, Customer supplied, Klant levert aan
Comment les valeurs sont lues: 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'.

Description

Recommandé

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.

Comment remplir la colonne: 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.
Également reconnu comme: Omschrijving

Value and Package

Recommandéevery line needs a Value, a Description or an MPN we can order from

Comment remplir la colonne: 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.
Également reconnu comme: Val, Waarde
Comment remplir la colonne: The component size in inches, IPC notation: 0603, 0805, 1206. The metric code may follow between brackets: 0603 (1608).
Également reconnu comme: Footprint, Case, Case/Package, Housing, Shape

Manufacturer

Facultatif

Manufacturer name of the preferred part.

Comment remplir la colonne: Not needed when the MPN is given: an MPN is (almost) always unique on its own.
Également reconnu comme: Man., Mfr, Mfg, Fabrikant, Hersteller

Colonnes associées

Fabricant 2: Manufacturer name of the first alternative.
Fabricant 3: Manufacturer name of the second alternative.
Fabricant 4: Manufacturer name of the third alternative.
Fabricant 5: Manufacturer name of the fourth alternative.
Fabricants: Several manufacturer names in one column, one per line. Pairs with MPNS in the same order.

MPN (Manufacturer Part Number)

Recommandéthe surest way to identify a part; a complete Value is the alternative

Manufacturer part number of the preferred part.

Comment remplir la colonne: 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.
Également reconnu comme: Manufacturer Part Number, Man Part Number, Part Number, Mfr Part No, Part no.

Colonnes associées

MPN 2: Manufacturer part number of the first alternative.
MPN 3: Manufacturer part number of the second alternative.
MPN 4: Manufacturer part number of the third alternative.
MPN 5: Manufacturer part number of the fourth alternative.
MPNs: Several manufacturer part numbers in one column, one per line. Pairs with MANUFACTURERS.

Supplier

Recommandé

Distributor name of the preferred supplier part.

Comment remplir la colonne: 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.
Également reconnu comme: Sup., Sup1, Distributor, Leverancier

Colonnes associées

Fournisseur 2: Distributor name of the first alternative supplier part.
Fournisseur 3: Distributor name of the second alternative supplier part.
Fournisseur 4: Distributor name of the third alternative supplier part.
Fournisseurs: Several distributor names in one column, one per line. Pairs with SUPPLIERS_SKU.

SKU (Stock Keeping Unit)

Recommandé

Order number at the distributor named in SUPPLIER_1.

Comment remplir la colonne: 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.
Également reconnu comme: Supplier part number, Order number, Order code, Distributor code, Bestelnummer

Colonnes associées

Fournisseur 2 SKU: Order number at the distributor named in SUPPLIER_2.
Fournisseur 3 SKU: Order number at the distributor named in SUPPLIER_3.
Fournisseur 4 SKU: Order number at the distributor named in SUPPLIER_4.
Fournisseurs SKU: Several distributor order numbers in one column, one per line. Pairs with SUPPLIERS.
Arrow SKUpeut apparaître plusieurs fois: Order number at Arrow Electronics.
DigiKey SKUpeut apparaître plusieurs fois: Order number at DigiKey.
Distrelec SKUpeut apparaître plusieurs fois: Order number at Distrelec.
Farnell SKUpeut apparaître plusieurs fois: Order number at Farnell.
LCSC SKUpeut apparaître plusieurs fois: Order number at LCSC.
Mouser SKUpeut apparaître plusieurs fois: Order number at Mouser Electronics.
RS Components SKUpeut apparaître plusieurs fois: Order number at RS Components.
TME SKUpeut apparaître plusieurs fois: Order number at TME.
Würth SKUpeut apparaître plusieurs fois: Order number at Würth Elektronik.

CPN (Customer Part Number)

Facultatif

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

Comment remplir la colonne: Your own internal article number. We keep it with the line for reference.
Également reconnu comme: Customer part number, Company part number, Internal part number, Art. no.

Remark

Facultatif

A remark or instruction from the customer about this component.

Comment remplir la colonne: 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.
Également reconnu comme: Remarks, Note, Notes, Opmerking

Allow alternatives

Facultatif

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

Comment remplir la colonne: 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.
Également reconnu comme: Alternative allowed, Alternatives allowed, Alternative, Alt. allowed
Comment les valeurs sont lues: 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.