🚚

Negozju tal-linja (dropshipping)

dropship sales_billing 🛡️ RLS Protected

Il-provvista diretta mill-fornitur lill-klijenti finali, il-ġenerazzjoni tal-PO tal-fornitur u l-barriera tal-ħruġ tal-fattura.

Fachliche Bestimmung: Il-bejgħ u l-bejgħ ta' negozji tat-trinġal u tat-triq reali jiġu ssostitwiti mingħajr xkiel. Meta tiġi aċċettata offerta b'pożizzjonijiet tat-triq, jiġi ġġenerat awtomatikament ordni ta' xiri lill-fornitur bl-indirizz tal-provvista tal-klijent.

⚡ Flussi ta' xogħol u ċikli ta' ħajja (2) 🗄️ Modelli tad-dejta & Felder (2) 🔌 Punti ta' Bidu (UI & API) (24) 🛡️ Regolatorji u konformità

⚡ Flussi ta' xogħol u ċikli ta' ħajja

Ċiklu ta' ħajja ta' trażmissjoni u t-tneħħija tal-fattura `dropship_lifecycle`

Il-Kummissjoni għandha tikkunsidra li l-miżuri li ġejjin għandhom jiġu implimentati:

sequenceDiagram Customer->>ERP: Bestellt Artikel (Route: Dropship) ERP->>Supplier: PO (Lieferadresse: Kunde, Typ: dropship) Note over ERP: billing_released = False (Fakturasperre) Supplier->>Customer: Liefert Ware direkt aus Supplier-->>ERP: Sendungsnummer / Zustellnachweis ERP->>ERP: Status = delivered & billing_released = True ERP->>Customer: Ausgangsrechnung wird generiert

1. ROUTE_DETECTION

L-identifikazzjoni tar-rotta

resolve_route ermittelt Streckengeschäft anhand von Produktkategorie oder Positions-Override.

Aktionen: Il-kapaċità tal-ħażna

2. PURCHASE_ORDER

Ġenerazzjoni tal-ordnijiet

DropshipService jgħaqqad il-pożizzjonijiet skont fornitur u joħloq PO b'procurement_type='dropship'.

Aktionen: Id-destinatarju tal-provvista = indirizz tal-klijent

3. TRACKING

Sistemi ta' kontroll tal-merkanzija

fornitur jirrapporta numru tat-traċċar u s-servizz tal-kunsinna.

Aktionen: Stat 'in_transit'

4. DELIVERY_CONFIRM

Is-sussidju

Konfirmazzjoni tal-kunsinna lill-klijent (POD).

Aktionen: Statut "destinat"

5. BILLING_RELEASE

L-ammont ta' fatturi

billing_released jiġi stabbilit għal True; l-kontijiet tal-klijent jiġu liberati.

Aktionen: fattura ħierga jista' jiġi stabbilit

Benutzerbefehl: sales order agent `plan:command_sales_order_agent`

Geprüfter Durable-Plan (durable_plan), Start: manual_command.

1. sales_order_agent

sales_order_agent

{"key": "execute_command", "label": "Befehl prüfen, ausführen oder zur Freigabe vorlegen", "adapter": "agent.execute", "agent": "sales_order_agent", "condition_fact": null}

Aktionen: sales_order_agent

🗄️ Modelli tad-dejta & Felder

DropshipLines dropship_lines RLS Aktiv

37 Il-kamps / il-kolla

Tabelle dropship_lines

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`item_type`	`VARCHAR(24)`	Ja *	-	Feld item_type
`item_id`	`UUID`	Ja *	-	Feld item_id
`quote_id`	`UUID`	Nein	FK ➔ quotes.id	Feld quote_id
`work_order_id`	`UUID`	Nein	FK ➔ work_orders.id	Feld work_order_id
`project_id`	`UUID`	Nein	FK ➔ projects.id	Feld project_id
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`product_id`	`UUID`	Nein	FK ➔ products.id	Feld product_id
`description`	`VARCHAR(255)`	Ja *	-	Feld description
`quantity`	`NUMERIC(14, 4)`	Ja *	-	Feld quantity
`unit`	`VARCHAR(16)`	Ja *	-	Feld unit
`sales_net`	`NUMERIC(14, 2)`	Ja *	-	Feld sales_net
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`purchase_id`	`UUID`	Nein	FK ➔ purchases.id	Feld purchase_id
`purchase_item_id`	`UUID`	Nein	FK ➔ purchase_items.id	Feld purchase_item_id
`cost_net`	`NUMERIC(14, 2)`	Nein	-	Feld cost_net
`ship_to`	`TEXT`	Nein	-	Feld ship_to
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`carrier`	`VARCHAR(120)`	Nein	-	Feld carrier
`tracking_number`	`VARCHAR(120)`	Nein	-	Feld tracking_number
`tracking_url`	`VARCHAR(512)`	Nein	-	Feld tracking_url
`expected_delivery_date`	`DATE`	Nein	-	Feld expected_delivery_date
`shipped_at`	`DATETIME`	Nein	-	Feld shipped_at
`delivered_at`	`DATETIME`	Nein	-	Feld delivered_at
`proof_document_id`	`UUID`	Nein	FK ➔ documents.id	Feld proof_document_id
`billing_released`	`BOOLEAN`	Ja *	-	Feld billing_released
`release_reason`	`VARCHAR(255)`	Nein	-	Feld release_reason
`chain_review`	`BOOLEAN`	Ja *	-	Feld chain_review
`issue_note`	`VARCHAR(500)`	Nein	-	Feld issue_note
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

SalesAgents sales_agents RLS Aktiv

18 Il-kamps / il-kolla

Tabelle sales_agents

Feldname	Tip ta' data	Obbligu	Schlüssel	L-importanza professjonali
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`email`	`VARCHAR(320)`	Nein	-	Feld email
`phone`	`VARCHAR(64)`	Nein	-	Feld phone
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`default_commission_percent`	`NUMERIC(5, 2)`	Nein	-	Feld default_commission_percent
`default_markup_percent`	`NUMERIC(5, 2)`	Nein	-	Feld default_markup_percent
`notes`	`TEXT`	Nein	-	Feld notes
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

🔌 Punti ta' Bidu (UI & API)

Art	Il-metodu	Punti ta ' tmiem / pjaċċ	Titel & Zweck	L-eżenzjoni
⚡ REST API	DELETE	`/api/v1/sales/orders/{order_id}/items/{item_id}`	delete_item Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	GET	`/api/v1/sales/orders`	list_sales_orders Semantic binding: inventory_only; mutation=False	`sales`
⚡ REST API	GET	`/api/v1/sales/orders/{order_id}`	get_sales_order Semantic binding: inventory_only; mutation=False	`sales`
⚡ REST API	GET	`/api/v1/sales/summary`	sales_summary Semantic binding: inventory_only; mutation=False	`sales`
⚡ REST API	GET	`/portal/{slug}/bestellung`	order_form Semantic binding: inventory_only; mutation=False	`sales`
⚡ REST API	GET	`/verkauf`	sales_page Semantic binding: inventory_only; mutation=False	`sales`
⚡ REST API	GET	`/verkauf/{order_id}`	sales_order_page Semantic binding: inventory_only; mutation=False	`sales`
⚡ REST API	PATCH	`/api/v1/sales/orders/{order_id}`	update_sales_order Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	PATCH	`/api/v1/sales/orders/{order_id}/items/{item_id}`	update_item Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	POST	`/api/v1/sales/orders`	create_sales_order Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	POST	`/api/v1/sales/orders/from-quote/{quote_id}`	create_from_quote Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	POST	`/api/v1/sales/orders/{order_id}/cancel`	cancel_sales_order Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	POST	`/api/v1/sales/orders/{order_id}/confirm`	confirm_sales_order Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	POST	`/api/v1/sales/orders/{order_id}/invoice`	invoice_sales_order Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	POST	`/api/v1/sales/orders/{order_id}/items`	add_item Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	POST	`/api/v1/sales/orders/{order_id}/mark-delivered`	mark_delivered Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	POST	`/api/v1/sales/orders/{order_id}/start-delivery`	start_delivery Semantic binding: operator_surface; mutation=True	`sales`
⚡ REST API	POST	`/portal/{slug}/bestellung`	order_submit Semantic binding: operator_surface; mutation=True	`sales`
🖥️ WEB-UI	GET	`/quotes?status=dropship`	Oferta ta' filtru tat-trażmissjoni Filtrata offerti b'pożizzjonijiet ta' negozju fuq rotot	`quotes:read`
🖥️ WEB-UI	GET	`/purchasing#dropship`	Xogħol f'negozju L-Ikel tal-Kumpaniji	`purchasing:read`
⚡ REST API	GET	`/api/v1/dropshipping`	L-Iskeda tal-Iskeda L-ammont ta' dħul minn operazzjonijiet ta' servizz pubbliku	`quotes:read`
⚡ REST API	POST	`/api/v1/dropshipping/{id}/assign-supplier`	Tagħrif tal-GT9_0__ Jgħid fornitur u joħloq ordnijiet ta' xiri	`purchasing:write`
⚡ REST API	POST	`/api/v1/dropshipping/{id}/tracking`	Tfakkar it-traċċar Jdaħħal numru ta ' traċċar u jdaħħal status fuq in_transit	`purchasing:write`
⚡ REST API	POST	`/api/v1/dropshipping/{id}/delivered`	Ikkonferma t-twassil Jissaħħaħ l-istatus tal-kontabilità	`purchasing:write`

🛡️ Regolatorji u konformità

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

UStG §25b (Trasport triangolu intern Komunitarju)
L-ammont tal-ispejjeż tal-assigurazzjoni u l-ispejjeż tal-assigurazzjoni

Moduli marbuta:

➔ finance ➔ purchasing ➔ catalog ➔ customers ➔ suppliers