Centurio System and module documentation
๐Ÿ”
๐Ÿ›๏ธ Platform architecture
๐Ÿ‡ฉ๐Ÿ‡ช Deutsch ๐Ÿ‡ฌ๐Ÿ‡ง English ๐Ÿ‡ซ๐Ÿ‡ท Franรงais ๐Ÿ‡ช๐Ÿ‡ธ Espaรฑol ๐Ÿ‡ฎ๐Ÿ‡น Italiano ๐Ÿ‡ณ๐Ÿ‡ฑ Nederlands ๐Ÿ‡ต๐Ÿ‡ฑ Polski ๐Ÿ‡ต๐Ÿ‡น Portuguรชs ๐Ÿ‡จ๐Ÿ‡ฟ ฤŒeลกtina ๐Ÿ‡ธ๐Ÿ‡ฐ Slovenฤina ๐Ÿ‡ญ๐Ÿ‡บ Magyar ๐Ÿ‡ท๐Ÿ‡ด Romรขnฤƒ ๐Ÿ‡ง๐Ÿ‡ฌ ะ‘ัŠะปะณะฐั€ัะบะธ ๐Ÿ‡ฌ๐Ÿ‡ท ฮ•ฮปฮปฮทฮฝฮนฮบฮฌ ๐Ÿ‡ฉ๐Ÿ‡ฐ Dansk ๐Ÿ‡ซ๐Ÿ‡ฎ Suomi ๐Ÿ‡ธ๐Ÿ‡ช Svenska ๐Ÿ‡ฑ๐Ÿ‡น Lietuviลณ ๐Ÿ‡ฑ๐Ÿ‡ป Latvieลกu ๐Ÿ‡ช๐Ÿ‡ช Eesti ๐Ÿ‡ญ๐Ÿ‡ท Hrvatski ๐Ÿ‡ธ๐Ÿ‡ฎ Slovenลกฤina ๐Ÿ‡ฒ๐Ÿ‡น Malti ๐Ÿ‡ฎ๐Ÿ‡ช Gaeilge ๐Ÿ‡ท๐Ÿ‡บ ะ ัƒััะบะธะน ๐Ÿ‡บ๐Ÿ‡ฆ ะฃะบั€ะฐั—ะฝััŒะบะฐ ๐Ÿ‡น๐Ÿ‡ท Tรผrkรงe ๐Ÿ‡ณ๐Ÿ‡ด Norsk bokmรฅl ๐Ÿ‡ท๐Ÿ‡ธ ะกั€ะฟัะบะธ ๐Ÿ‡ฎ๐Ÿ‡ธ รslenska ๐Ÿ‡จ๐Ÿ‡ญ Schwiiz/Suisse
๐Ÿ”‘ Login
๐Ÿ  All modules / sales_billing / The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.
๐Ÿšš

The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

dropship sales_billing ๐Ÿ›ก๏ธ RLS Protected

Direct supply from the supplier to the final customer, supplier PO generation and invoicing disclosure restriction.

Fachliche Bestimmung: The Commission shall, in the event of a change in the terms of the agreement, provide a detailed description of the conditions for the purchase and sale of the goods and services in question.
โšก Workflows and life cycles (4) ๐Ÿ—„๏ธ Data models and fields (2) ๐Ÿ”Œ The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. (24) ๐Ÿ›ก๏ธ Regulatory and compliance

โšก Workflows and life cycles

The following is the list of the following: dropship_lifecycle

The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

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
Routing recognition
resolve_route determines routing business by product category or position override.
Aktionen: Overcoming storage needs
2. PURCHASE_ORDER
Production of orders
DropshipService aggregates positions according to supplier and generates PO with procurement_type='dropship'.
Aktionen: The following information shall be provided:
3. TRACKING
Monitoring of shipments
supplier reports tracking number and shipping service provider.
Aktionen: The following information shall be reported:
4. DELIVERY_CONFIRM
Delivery
Confirmation of delivery to the customer (POD).
Aktionen: Status of 'delivered'
5. BILLING_RELEASE
The following information shall be provided:
billing_released is set to True; customer invoice is unlocked.
Aktionen: Manufacture from materials of heading No 841

Kundenauftrag โ†’ Abwicklung cascade:business.customer_order.fulfill

The following information shall be provided:

1. order
Verkaufsauftrag anlegen / bestรคtigen
sales
Aktionen: sales.create
2. issue
Booking of the outcome of the goods as draft
Inventory
Aktionen: - I 'm not sure .
3. tour
The Commission shall adopt a decision on the following:
Logistics
Aktionen: create_tour
4. project
The Commission shall adopt the following measures:
Projects
Aktionen: link_project
5. task
Exercise / calculate
other tasks
Aktionen: create_task

Verkaufsauftrag anlegen / bestรคtigen cascade_target:business.sales_order.create

The following information shall be provided:

1. cascade
Verkaufsauftrag anlegen / bestรคtigen

Benutzerbefehl: sales order agent plan:command_sales_order_agent

The following is the list of the main functions of the system:

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

๐Ÿ—„๏ธ Data models and fields

DropshipLines dropship_lines RLS Aktiv
37 Fields and columns

Tabelle dropship_lines

Feldname Type of data The Commission Schlรผssel The technical significance
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 Fields and columns

Tabelle sales_agents

Feldname Type of data The Commission Schlรผssel The technical significance
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

๐Ÿ”Œ The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

Art The method Endpoint / path Titel & Zweck The Commission shall adopt the following:
โšก 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
The following table shows the following:
Filtered offers with routing business positions
 quotes:read
๐Ÿ–ฅ๏ธ WEB-UI GET /purchasing#dropship
The Commission shall adopt the following measures:
Dedicated shopping cart with identification numbers and tracking
 purchasing:read
โšก REST API GET /api/v1/dropshipping
The following table shows the following:
Supplier routing positions with supplier and proof data
 quotes:read
โšก REST API POST /api/v1/dropshipping/{id}/assign-supplier
allocation of _GT9_0__
In the case of the product concerned, the following conditions shall apply:
 purchasing:write
โšก REST API POST /api/v1/dropshipping/{id}/tracking
Tracking deposited
Enter tracking number and set status to in_transit
 purchasing:write
โšก REST API POST /api/v1/dropshipping/{id}/delivered
Confirm delivery
Set status to delivered and issue clearance of accounts
 purchasing:write

๐Ÿ›ก๏ธ Regulatory and compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • UStG ยง25b (Internal triangular transactions)
  • The following points are added:
Connected modules:
โž” finance โž” purchasing โž” catalog โž” customers โž” suppliers