Project Position Schema

Owning project UUID.

Position number carried over from the sales order (display / ordering).

Manual sort order within the project (drag & drop).

Position title.

ADR 1018 — title materialise_order last generated from the order line. While `title` still equals it, nobody renamed the position and the title follows a renamed weclapp line; null on rows created before the field (the history CREATE entry is used instead).

Position description.

Position lifecycle status.

flat_rate = fixed price, bookings are a profitability metric only (never hard-blocked). time_and_material = billed by actual bookings; an optional cap lives on the task (limitMode).

Planned effort in minutes (Soll).

Planned / sold net amount in EUR (Soll), decimal string.

ISO 4217 currency for plannedAmount (default EUR when null).

Sold quantity carried over from the order item (decimal string).

Unit price carried over from the order item (decimal string).

Net amount carried over from the order item (decimal string).

Frozen copy of the sold order line, written ONCE when the position is created from a sales order (order intake / order import) and never refreshed. quantity/unitPrice/netAmount above follow the order on every intake run; this snapshot keeps the sold terms visible for the price check even after the line was edited or deleted in weclapp. Server-managed (protected).

Sum of loggedMinutes of the tasks under this position (cached rollup). ADR 0924: rounded working time.

ADR 0924: the same bookings as consumedMinutes summed as NET working time (cached rollup) — the "(real)" part of the display.

Sum of consumedAmount of the tasks under this position (cached rollup, EUR).

Optional linked article UUID.

Sales order this position was materialised from (order-import path).

ID of the orderItem inside the linked sales_order (matches salesOrder.orderItems[].id).

Origin of the linked sales-order item — internal or weclapp.

ADR 0634 — wie diese Position im weclapp-Auftrag abgerechnet wird. `position` (Default, auch bei null) = die Auftragsposition bleibt stehen und wird bebucht/fakturiert wie verkauft; `replace` = die Auftragsposition ist eine Nicht-DL-Platzhalterposition und wird beim Abrechnungsabschluss durch die gerenderten Buchungspositionen ERSETZT. Vorbelegt aus der Intake-Regel (`position.weclappBilling`), danach im Projektabrechnungs-Dialog änderbar; ein Re-Import überschreibt den Wert bewusst NICHT.

When this flat-rate position was put on a Leistungsnachweis (per-project billing run). Null = not billed yet.

Leistungsnachweis this position was billed on. Server-managed.

Invoice this position was billed on. Server-managed.