Article Schema

Internal sequenced article number (e.g. A-2026-00042)

Article name

Quick search code / abbreviation

Article description (plain text). Used as legacy fallback when no linked product description exists. New marketing copy belongs on the linked product. See ADR 0094c.

DEPRECATED — long marketing descriptions are sourced from product.descriptionHtml in the customer-portal shop. Kept as a legacy fallback for articles without a linked product; will be removed in a future release. See ADR 0094c.

DEPRECATED — long marketing descriptions are sourced from product.descriptionHtml in the customer-portal shop. Kept as a legacy fallback; will be removed in a future release. See ADR 0094c.

Short description for list views and shop cards

Secondary short description line

External article number / EAN (legacy field)

EAN/GTIN barcode

Generic barcode payload (Code128, QR, …)

Manufacturer part number (Herstellernummer)

Article type. STOCK_TRACKED = Bestandsführend (warehouse stock managed), BASIC = Basisartikel (no stock tracking), SERVICE = Dienstleistung, SHIPPING_COST = Versandkosten, SALES_BILL_OF_MATERIAL = Verkaufsstückliste

Article category UUID

weclapp's own article-category id, copied verbatim from the source article. Deliberately NOT stored in `articleCategoryId`: that field holds a local `article_categories` UUID, and a weclapp id (e.g. "7035") fails its UUID pattern. Order-intake rules (ADR 0285) match against this field for weclapp-sourced articles.

Human-readable name of the source system's article category (weclapp `articleCategory.name`, max 120 there). Denormalized for display and so a category stays identifiable if the source id is ever re-keyed.

Product UUID (links article to a product in the portfolio)

Lifecycle status of the article

Tags for categorization

Manufacturer / brand (free text). Optional override for OEM cases — when empty, the linked product.manufacturer is used. See ADR 0094a.

Optional FK to manufacturer party (vendor)

VAT category — maps to current rate via tax-config

Reference to units collection (Stück, h, kg, …)

Unit label (e.g. "pro Benutzer", "pro Gerät") — fallback for unitId

Minimum sales order quantity

Maximum sales order quantity (null = unlimited)

Order quantity step (e.g. 5-packs)

Minimum purchase order quantity

Fixed purchase quantity — orders must be exactly this value

Quantity per packaging unit (VPE)

Unit conversions (e.g. 1 carton = 12 pcs)

Article prices with optional customer/tier/date specificity

Calculation prices (Kalkulationspreise + UVP) over time

Purchase / cost price (EK-Preis, internal only)

Recommended retail price (UVP) — quick top-level value

When true, the customer-portal shop hides the resolved price and shows "Preis auf Anfrage" with a "Angebot anfragen" CTA, regardless of articlePrices/recommendedRetailPrice. Use this for high-touch B2B SKUs where pricing is negotiated per customer.

Which price source is used as the default in offers

Cost basis for margin calculation

Commission rate in percent

Whether cash discount (Skonto) applies

Default billing interval (for recurring services)

Whether sales of this article should be reflected in the customer portfolio (party_product). null = inferred at runtime (true when billingInterval is set and not ONE_TIME, or articleType=SERVICE; false otherwise). Explicit true/false overrides the heuristic. See portfolio reconcile worker.

One-time setup fee

EFFORT = invoice by effort, FIXED_PRICE = fixed quote

Whether article is active

Available in portal / sales

Restrict to specific customers (null = all)

Order requires MSP approval

Estimated delivery time in days

Free-form sales channel codes the article is available in

Whether `salesChannels` should be enforced

Whether the article appears on the delivery note

Document item group (Belegpositionsgruppe, e.g. "Hardware", "Service")

Whether the article uses individual task templates

Minimum stock level (Mindestbestand)

Target stock level (Sollbestand)

Safety stock in days of consumption

Procurement lead time in days (Wiederbeschaffungszeit)

Average delivery time in days

Whether serial numbers are mandatory for this article

Whether batch/lot numbers are mandatory

Per-warehouse stock thresholds

Default storage places (Lagerplätze) for replenishment

Supply sources (Bezugsquellen)

FK to the primary supplySource entry

Purchase cost center label

Sales bill of material items (bundle components)

true: bundle price = sum of item prices, false: own price from articlePrices

true: bundle purchase price = sum of subitem purchase prices, false: own purchasePrice. Mirrors weclapp `useSalesBillOfMaterialItemPricesForPurchase` — applies to procurement (EK), independent of the sales-side flag above.

true: include subitem costs (margin calculation, costing) when computing this bundle’s cost basis. Mirrors weclapp `useSalesBillOfMaterialSubitemCosts`. When false, the bundle’s own purchasePrice / calculation price is used as cost basis.

Production bill of material items

Whether the article is produced in-house

How BOM components are configured at order time

BOM nesting depth (computed, read-only)

Planned working time per produced unit (minutes)

Producer type / classification

Net weight

Gross weight

Weight unit

Length / width / height unit

ISO 3166-1 alpha-2 country code

Customs tariff number (Zolltarifnummer)

Customs description

Revenue account code for DATEV (Erlöskonto, e.g. "8400")

Expense account code for DATEV (Aufwandskonto, e.g. "4900")

Accounting code / Buchungskreis

Sales cost center label

Launch date / market introduction (YYYY-MM-DD)

Available for sale from this date

Available for sale until this date

Support / maintenance end date (relevant for licenses & hardware)

Shelf life in days from procurement

DEPRECATED — primary product image S3 key (legacy single-image field). Use imageFileIds; will be removed in a future release.

Variant-specific image file IDs (resolved via /api/v1/files/{fileId}/download-url). When non-empty, these override the linked product.imageFileIds in the customer-portal gallery. Leave empty to inherit the product gallery. See ADR 0094a.

Variant-specific non-image attachments. Cluster-wide datasheets, manuals and certificates belong on product.documents (richer metadata) or product.attachmentFileIds. In the customer-portal Downloads tab these are rendered as a separate "variant-specific" section. See ADR 0094a.

Flexible variant-specific key-value attributes (e.g. RAM, display size). Cluster-wide grouped specs belong on product.technicalSpecs. See ADR 0094a.

Customer-specific article numbers (B2B)

Internal note (not visible in portal)

Display sort order