Centurio Sistem ve modül belgesi
🔍
🏛️ Platform mimarisi
🇩🇪 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
🏠 Tüm modüller / sales_billing / Sözleşme yönetimi
📑

Sözleşme yönetimi

contracts sales_billing 🛡️ RLS Protected

Çerçeve sözleşmeleri, sözleşmeler, kontantlar, çizgi faktürleme ve otomatik alım.

Fachliche Bestimmung: Müşteri ve tedarikçi sözleşmeleri, çerçeve anlaşmaları ve hizmet düzeyi anlaşmaları (SLA) yönetilir.
⚡ İş akışları ve yaşam döngüleri (6) 🗄️ Verim modelleri & alanlar (22) 🔌 Giriş noktaları (UI & API) (102) 🛡️ Yönetim ve Uyum

⚡ İş akışları ve yaşam döngüleri

Sözleşme yaşam döngüsü cascade:business.contract.lifecycle

Kaskade (review_gated).

1. contract
_GT12_0__
Sözleşmeler
Aktionen: contract.create
2. task
Zamanlaması / İptal Denetimleri
Görevler
Aktionen: create_task

_GT12_0__ cascade_target:business.contract.apply

Kaskade (review_gated).

1. cascade
_GT12_0__

Kullanıcı emri: Sözleşme temsilcisi plan:command_contract_agent

Kontrol edilmiş Durable plan (durable_plan), başlangıç: manual_command.

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

Kullanıcı talimatı: sözleşme malzemesi plan:command_contract_crud_subagent

Kontrol edilmiş Durable plan (durable_plan), başlangıç: manual_command.

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

Benutzerbefehl: contract drafting agent plan:command_contract_drafting_agent

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

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

sözleşme status:contract

Bu durumda, bu işlemlerin zorunlu olmadığı için, servis onayına bakın.

1. draft
Hazırlık
Durum <unk>Yöntem <unk>Düzeltme makinesi sözleşme.
2. pending
Bekleyen
Durum <unk>pending<unk> durum makinesi sözleşme.
3. active
aktif
Durum: <unk>active<unk> state machine sözleşme.
4. expired
Geçmiş
Durum <unk>expired<unk> durum makinesi sözleşme.
5. terminated
Sonlandırılmış
Durum <unk>terminated<unk> durum makinesi sözleşme.
6. renewed
Yeniden
Durum <unk>renewed<unk> durum makinesi sözleşme.

🗄️ Verim modelleri & alanlar

ContractAmendments contract_amendments RLS Aktiv
10 Alanlar / Sütunlar

Tabelle contract_amendments

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
title VARCHAR(255) Ja * - Feld title
effective_date DATE Nein - Feld effective_date
description TEXT Nein - Feld description
document_id UUID Nein - Feld document_id
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
metadata JSONB Ja * - Feld metadata
ContractBillingRuns contract_billing_runs RLS Aktiv
11 Alanlar / Sütunlar

Tabelle contract_billing_runs

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
period_start DATE Ja * - Feld period_start
period_end DATE Ja * - Feld period_end
invoice_id UUID Nein - Feld invoice_id
net_amount NUMERIC(14, 2) Ja * - Feld net_amount
recipient_id UUID Nein - Feld recipient_id
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
metadata JSONB Ja * - Feld metadata
ContractClauses contract_clauses RLS Aktiv
13 Alanlar / Sütunlar

Tabelle contract_clauses

Feldname Verim tipi İade Schlüssel Mesleki anlam
title VARCHAR(255) Ja * - Feld title
category VARCHAR(64) Nein - Feld category
body TEXT Ja * - Feld body
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
ContractCommissions contract_commissions RLS Aktiv
14 Alanlar / Sütunlar

Tabelle contract_commissions

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
agent_id UUID Ja * FK ➔ sales_agents.id Feld agent_id
invoice_id UUID Nein - Feld invoice_id
period_start DATE Nein - Feld period_start
period_end DATE Nein - Feld period_end
base_amount NUMERIC(14, 2) Ja * - Feld base_amount
percent NUMERIC(5, 2) Ja * - Feld percent
amount NUMERIC(14, 2) Ja * - Feld amount
status VARCHAR(16) Ja * - Feld status
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
metadata JSONB Ja * - Feld metadata
ContractDocumentTemplates contract_document_templates RLS Aktiv
25 Alanlar / Sütunlar

Tabelle contract_document_templates

Feldname Verim tipi İade Schlüssel Mesleki anlam
tenant_id UUID Nein - Feld tenant_id
source_document_id UUID Nein FK ➔ documents.id Feld source_document_id
variant_group UUID Nein - Feld variant_group
doc_key VARCHAR(64) Ja * - Feld doc_key
country VARCHAR(2) Ja * - Feld country
language VARCHAR(8) Ja * - Feld language
industry VARCHAR(64) Nein - Feld industry
contract_type VARCHAR(32) Ja * - Feld contract_type
title VARCHAR(255) Ja * - Feld title
description TEXT Nein - Feld description
sections JSONB Ja * - Feld sections
variables JSONB Ja * - Feld variables
legal_basis VARCHAR(255) Nein - Feld legal_basis
source_kind VARCHAR(16) Ja * - Feld source_kind
source_url VARCHAR(512) Nein - Feld source_url
source_note VARCHAR(255) Nein - Feld source_note
legal_review_status VARCHAR(24) Ja * - Feld legal_review_status
checksum VARCHAR(64) Ja * - Feld checksum
version INTEGER Ja * - Feld version
sort_order INTEGER Ja * - Feld sort_order
active BOOLEAN Ja * - Feld active
id UUID Nein PK Feld id
created_at DATETIME Ja * - Feld created_at
updated_at DATETIME Ja * - Feld updated_at
metadata JSONB Ja * - Feld metadata
ContractDocuments contract_documents RLS Aktiv
8 Alanlar / Sütunlar

Tabelle contract_documents

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
document_id UUID Ja * - Feld document_id
relation_type VARCHAR(32) Ja * - Feld relation_type
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
metadata JSONB Ja * - Feld metadata
ContractLines contract_lines RLS Aktiv
26 Alanlar / Sütunlar

Tabelle contract_lines

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
position INTEGER Ja * - Feld position
line_type VARCHAR(24) Ja * - Feld line_type
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(32) Ja * - Feld unit
billing_method VARCHAR(24) Ja * - Feld billing_method
billing_unit_id UUID Nein FK ➔ units_of_measure.id Feld billing_unit_id
billing_interval VARCHAR(16) Nein - Feld billing_interval
unit_price NUMERIC(14, 2) Nein - Feld unit_price
discount_percent NUMERIC(5, 2) Ja * - Feld discount_percent
tax_rate NUMERIC(6, 3) Nein - Feld tax_rate
included_quantity NUMERIC(14, 4) Nein - Feld included_quantity
overage_unit_price NUMERIC(14, 2) Nein - Feld overage_unit_price
basis VARCHAR(24) Nein - Feld basis
subject_id UUID Nein - Feld subject_id
start_date DATE Nein - Feld start_date
end_date DATE Nein - Feld end_date
last_billed_at DATE Nein - Feld last_billed_at
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
metadata JSONB Ja * - Feld metadata
ContractMilestones contract_milestones RLS Aktiv
16 Alanlar / Sütunlar

Tabelle contract_milestones

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
kind VARCHAR(32) Ja * - Feld kind
title VARCHAR(255) Ja * - Feld title
due_date DATE Nein - Feld due_date
status VARCHAR(32) Ja * - Feld status
completed_at DATETIME Nein - Feld completed_at
work_order_id UUID Nein - Feld work_order_id
project_id UUID Nein - Feld project_id
service_plan_id UUID Nein - Feld service_plan_id
amount NUMERIC(14, 2) Nein - Feld amount
note TEXT Nein - Feld 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
metadata JSONB Ja * - Feld metadata
ContractObligations contract_obligations RLS Aktiv
13 Alanlar / Sütunlar

Tabelle contract_obligations

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
description TEXT Ja * - Feld description
due_date DATE Nein - Feld due_date
status VARCHAR(32) Ja * - Feld status
responsible_id UUID Nein - Feld responsible_id
reminder_days_before INTEGER Nein - Feld reminder_days_before
amount NUMERIC(14, 2) Nein - Feld amount
notes TEXT Nein - Feld notes
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
metadata JSONB Ja * - Feld metadata
ContractParties contract_parties RLS Aktiv
13 Alanlar / Sütunlar

Tabelle contract_parties

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
party_type VARCHAR(32) Ja * - Feld party_type
name VARCHAR(255) Ja * - Feld name
vat_id VARCHAR(32) Nein - Feld vat_id
contact_name VARCHAR(255) Nein - Feld contact_name
email VARCHAR(320) Nein - Feld email
phone VARCHAR(64) Nein - Feld phone
address_text TEXT Nein - Feld address_text
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
metadata JSONB Ja * - Feld metadata
ContractRebateSettlements contract_rebate_settlements RLS Aktiv
16 Alanlar / Sütunlar

Tabelle contract_rebate_settlements

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
period_start DATE Ja * - Feld period_start
period_end DATE Ja * - Feld period_end
revenue_net NUMERIC(14, 2) Ja * - Feld revenue_net
percent NUMERIC(5, 2) Ja * - Feld percent
amount NUMERIC(14, 2) Ja * - Feld amount
credit_note_id UUID Nein - Feld credit_note_id
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
ContractReminders contract_reminders RLS Aktiv
9 Alanlar / Sütunlar

Tabelle contract_reminders

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
reminder_date DATE Ja * - Feld reminder_date
reminder_type VARCHAR(32) Ja * - Feld reminder_type
sent_at DATETIME Nein - Feld sent_at
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
metadata JSONB Ja * - Feld metadata
ContractRenewals contract_renewals RLS Aktiv
10 Alanlar / Sütunlar

Tabelle contract_renewals

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
previous_end_date DATE Nein - Feld previous_end_date
new_end_date DATE Nein - Feld new_end_date
notice_sent_at DATETIME Nein - Feld notice_sent_at
renewed_at DATETIME Nein - Feld renewed_at
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
metadata JSONB Ja * - Feld metadata
ContractScopeItems contract_scope_items RLS Aktiv
16 Alanlar / Sütunlar

Tabelle contract_scope_items

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
item_type VARCHAR(16) Ja * - Feld item_type
product_id UUID Nein FK ➔ products.id Feld product_id
category_id UUID Nein FK ➔ product_categories.id Feld category_id
label VARCHAR(255) Nein - Feld label
mode VARCHAR(8) Ja * - Feld mode
note TEXT Nein - Feld 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
ContractServicePlans contract_service_plans RLS Aktiv
17 Alanlar / Sütunlar

Tabelle contract_service_plans

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
name VARCHAR(255) Ja * - Feld name
subject_id UUID Nein - Feld subject_id
interval_months INTEGER Ja * - Feld interval_months
lead_days INTEGER Ja * - Feld lead_days
next_due_date DATE Ja * - Feld next_due_date
last_generated_for DATE Nein - Feld last_generated_for
order_type VARCHAR(32) Ja * - Feld order_type
work_order_id UUID Nein - Feld work_order_id
billable BOOLEAN Ja * - Feld billable
estimated_hours NUMERIC(6, 2) Nein - Feld estimated_hours
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
metadata JSONB Ja * - Feld metadata
ContractStorageAreas contract_storage_areas RLS Aktiv
20 Alanlar / Sütunlar

Tabelle contract_storage_areas

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
location_id UUID Ja * FK ➔ locations.id Feld location_id
stock_owner VARCHAR(16) Ja * - Feld stock_owner
policy VARCHAR(16) Ja * - Feld policy
capacity_qty NUMERIC(14, 4) Nein - Feld capacity_qty
capacity_unit VARCHAR(16) Nein - Feld capacity_unit
valid_from DATE Nein - Feld valid_from
valid_until DATE Nein - Feld valid_until
in_route_id UUID Nein FK ➔ warehouse_routes.id Feld in_route_id
out_route_id UUID Nein FK ➔ warehouse_routes.id Feld out_route_id
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
ContractSubjects contract_subjects RLS Aktiv
19 Alanlar / Sütunlar

Tabelle contract_subjects

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
subject_type VARCHAR(16) Ja * - Feld subject_type
role VARCHAR(16) Ja * - Feld role
asset_id UUID Nein FK ➔ assets.id Feld asset_id
name VARCHAR(255) Ja * - Feld name
address TEXT Nein - Feld address
unit_no VARCHAR(64) Nein - Feld unit_no
area_sqm NUMERIC(10, 2) Nein - Feld area_sqm
rent_amount NUMERIC(14, 2) Nein - Feld rent_amount
service_charges NUMERIC(14, 2) Nein - Feld service_charges
deposit NUMERIC(14, 2) Nein - Feld deposit
tax_rate NUMERIC(6, 3) Nein - Feld tax_rate
attributes JSONB Ja * - Feld attributes
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
metadata JSONB Ja * - Feld metadata
ContractTemplateDrafts contract_template_drafts RLS Aktiv
22 Alanlar / Sütunlar

Tabelle contract_template_drafts

Feldname Verim tipi İade Schlüssel Mesleki anlam
template_id UUID Nein FK ➔ contract_document_templates.id Feld template_id
template_version INTEGER Ja * - Feld template_version
template_snapshot JSONB Ja * - Feld template_snapshot
values JSONB Ja * - Feld values
rendered_text TEXT Ja * - Feld rendered_text
checksum VARCHAR(64) Ja * - Feld checksum
sensitive BOOLEAN Ja * - Feld sensitive
status VARCHAR(16) Ja * - Feld status
customer_id UUID Nein FK ➔ customers.id Feld customer_id
employee_id UUID Nein FK ➔ organization_users.id Feld employee_id
document_id UUID Nein FK ➔ documents.id Feld document_id
contract_id UUID Nein FK ➔ contracts.id Feld contract_id
document_stale BOOLEAN Ja * - Feld document_stale
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
ContractTemplates contract_templates RLS Aktiv
15 Alanlar / Sütunlar

Tabelle contract_templates

Feldname Verim tipi İade Schlüssel Mesleki anlam
key VARCHAR(64) Ja * - Feld key
name VARCHAR(255) Ja * - Feld name
scope VARCHAR(32) Ja * - Feld scope
description TEXT Nein - Feld description
config JSONB Ja * - Feld config
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
ContractTerms contract_terms RLS Aktiv
21 Alanlar / Sütunlar

Tabelle contract_terms

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
term_type VARCHAR(24) Ja * - Feld term_type
product_id UUID Nein FK ➔ products.id Feld product_id
category_id UUID Nein FK ➔ product_categories.id Feld category_id
params JSONB Ja * - Feld params
valid_from DATE Nein - Feld valid_from
valid_until DATE Nein - Feld valid_until
active BOOLEAN Ja * - Feld active
note TEXT Nein - Feld note
source_clause_ref VARCHAR(64) Nein - Feld source_clause_ref
source_document_id UUID Nein - Feld source_document_id
source_workflow_run_id UUID Nein - Feld source_workflow_run_id
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
ContractUsageEntries contract_usage_entries RLS Aktiv
14 Alanlar / Sütunlar

Tabelle contract_usage_entries

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_id UUID Ja * FK ➔ contracts.id Feld contract_id
line_id UUID Nein - Feld line_id
product_id UUID Nein - Feld product_id
occurred_on DATE Ja * - Feld occurred_on
quantity NUMERIC(14, 4) Ja * - Feld quantity
description VARCHAR(255) Nein - Feld description
source_type VARCHAR(32) Ja * - Feld source_type
source_id UUID Nein - Feld source_id
billed_run_id UUID Nein - Feld billed_run_id
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
metadata JSONB Ja * - Feld metadata
Contracts contracts RLS Aktiv
65 Alanlar / Sütunlar

Tabelle contracts

Feldname Verim tipi İade Schlüssel Mesleki anlam
contract_number VARCHAR(64) Nein - Feld contract_number
title VARCHAR(255) Ja * - Feld title
status VARCHAR(48) Ja * - Feld status
contract_type VARCHAR(48) Ja * - Feld contract_type
currency VARCHAR(3) Ja * - Feld currency
total_value NUMERIC(14, 2) Nein - Feld total_value
start_date DATE Nein - Feld start_date
end_date DATE Nein - Feld end_date
renewal_type VARCHAR(48) Ja * - Feld renewal_type
renewal_notice_days INTEGER Nein - Feld renewal_notice_days
termination_notice_days INTEGER Nein - Feld termination_notice_days
minimum_term_months INTEGER Nein - Feld minimum_term_months
terms TEXT Nein - Feld terms
notes TEXT Nein - Feld notes
billing_interval VARCHAR(32) Nein - Feld billing_interval
billing_amount NUMERIC(14, 2) Nein - Feld billing_amount
next_billing_date DATE Nein - Feld next_billing_date
owner_id UUID Nein - Feld owner_id
customer_id UUID Nein FK ➔ customers.id Feld customer_id
supplier_id UUID Nein FK ➔ suppliers.id Feld supplier_id
counterparty_id UUID Nein - Feld counterparty_id
counterparty_role VARCHAR(32) Nein - Feld counterparty_role
document_id UUID Nein - Feld document_id
confidence NUMERIC(4, 3) Nein - Feld confidence
scope VARCHAR(32) Ja * - Feld scope
contract_subtype VARCHAR(24) Nein - Feld contract_subtype
template_key VARCHAR(64) Nein - Feld template_key
parent_contract_id UUID Nein FK ➔ contracts.id Feld parent_contract_id
pricelist_id UUID Nein FK ➔ pricelists.id Feld pricelist_id
billing_mode VARCHAR(16) Ja * - Feld billing_mode
agent_id UUID Nein FK ➔ sales_agents.id Feld agent_id
agent_commission_percent NUMERIC(5, 2) Nein - Feld agent_commission_percent
agent_markup_percent NUMERIC(5, 2) Nein - Feld agent_markup_percent
invoice_policy VARCHAR(16) Ja * - Feld invoice_policy
billing_anchor_day INTEGER Nein - Feld billing_anchor_day
renewal_term_months INTEGER Nein - Feld renewal_term_months
commitment_value NUMERIC(14, 2) Nein - Feld commitment_value
price_adjustment_percent NUMERIC(6, 3) Nein - Feld price_adjustment_percent
price_adjustment_interval_months INTEGER Nein - Feld price_adjustment_interval_months
next_price_adjustment_date DATE Nein - Feld next_price_adjustment_date
payment_terms VARCHAR(128) Nein - Feld payment_terms
payment_term_code VARCHAR(32) Nein - Feld payment_term_code
cost_center VARCHAR(64) Nein - Feld cost_center
project_id UUID Nein - Feld project_id
attributes JSONB Ja * - Feld attributes
auto_invoice_mode VARCHAR(16) Ja * - Feld auto_invoice_mode
invoice_lead_days INTEGER Ja * - Feld invoice_lead_days
payment_method VARCHAR(16) Ja * - Feld payment_method
mandate_reference VARCHAR(64) Nein - Feld mandate_reference
mandate_date DATE Nein - Feld mandate_date
paused_from DATE Nein - Feld paused_from
paused_until DATE Nein - Feld paused_until
pause_reason VARCHAR(32) Nein - Feld pause_reason
free_until DATE Nein - Feld free_until
auto_pause_dunning_level INTEGER Nein - Feld auto_pause_dunning_level
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
deleted_at DATETIME Nein - Feld deleted_at

🔌 Giriş noktaları (UI & API)

Art Metod Son nokta / yol Titel & Zweck Yasal
⚡ REST API DELETE /api/v1/contract-clauses/{clause_id}
delete_clause
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API DELETE /api/v1/contract-control/{contract_id}/scope/{item_id}
remove_scope
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API DELETE /api/v1/contract-control/{contract_id}/terms/{term_id}
delete_term
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API DELETE /api/v1/contracts/{contract_id}
delete_contract
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API DELETE /api/v1/contracts/{contract_id}/lines/{line_id}
delete_line
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API DELETE /api/v1/contracts/{contract_id}/obligations/{obligation_id}
delete_contract_obligation
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API DELETE /api/v1/contracts/{contract_id}/service-plans/{plan_id}
remove_plan
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API DELETE /api/v1/contracts/{contract_id}/storage/areas/{location_id}
release_area
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API DELETE /api/v1/contracts/{contract_id}/subjects/{subject_id}
remove_subject
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API GET /api/v1/contract-clauses
list_clauses
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contract-control/{contract_id}
Özet
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contract-control/{contract_id}/check
kontrol
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contract-control/{contract_id}/rebates
Arıza
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts
list_contracts
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/billing-options
billing_options
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/scenarios
Scenariyolar
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/storage/overview
storage_overview
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/tax-rates
tax_rates
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/warehouse-routes
warehouse_routes
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}
get_contract
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/amendments
list_contract_amendments
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/billing-preview
billing_preview
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/documents
list_contract_documents
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/invoices
get_contract_invoices
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/obligations
list_contract_obligations
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/renewals
list_contract_renewals
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/semantic-attributes
contract_semantic_attributes
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/storage/articles
storage_articles
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/storage/orders
storage_orders
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/storage/stock
storage_stock
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/contracts/{contract_id}/workspace
İş alanı
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /api/v1/sales-agents
list_agents
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /contracts
contracts_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /contracts/new
contract_create_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /contracts/storage
contract_storage_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /contracts/templates
contract_templates_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /contracts/wizard
contract_wizard_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /contracts/{contract_id}
contract_detail_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /contracts/{contract_id}/edit
contract_detail_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /contracts/{contract_id}/terms
contract_terms_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /contracts/{contract_id}/workspace
contract_workspace_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /portal/{slug}/vertraege
contracts_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /portal/{slug}/vertraege/{contract_id}/dokument
contract_document_download
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /sales-agents
sales_agents_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /sales-agents/new
sales_agents_new_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API GET /sales-agents/{agent_id}/edit
sales_agents_edit_page
Semantic binding: inventory_only; mutation=False
 contracts
⚡ REST API PATCH /api/v1/contracts/commissions/{commission_id}
commission_status
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API PATCH /api/v1/contracts/{contract_id}
update_contract
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API PATCH /api/v1/contracts/{contract_id}/commercial
update_commercial
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API PATCH /api/v1/contracts/{contract_id}/lines/{line_id}
patch_line
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API PATCH /api/v1/contracts/{contract_id}/obligations/{obligation_id}
update_contract_obligation
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API PATCH /api/v1/sales-agents/{agent_id}
update_agent
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-clauses
create_clause
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/agb-policies
propose_agb_policies_endpoint
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/policy-releases/{release_id}/activate
activate_policy_release
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/apply-clauses
apply_contract_clauses
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/gateways/billing
gateway_billing
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/gateways/call-off
gateway_call_off
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/gateways/return
gateway_return
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/gateways/service-orders
gateway_service_orders
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/gateways/warranty
gateway_warranty
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/policy-package
propose_policy_package
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/propose-workflow
propose_contract_workflow
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/rebates/settle
settle_rebate
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/scope
add_scope
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-control/{contract_id}/terms
add_term
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contract-templates
save_template
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts
create_contract
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/from-template
from_template
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/run-automation
run_automation
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/storage/orders/{order_id}/cancel
storage_order_cancel
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/storage/orders/{order_id}/post
storage_order_post
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/trigger-recurring-billing
trigger_recurring_billing
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/amendments
create_contract_amendment
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/bill-now
bill_now
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/call-off
call_off
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/conclude
conclude_contract
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/consignment/replenish
consignment_replenish
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/consignment/withdraw
consignment_withdraw
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/generate-invoice
generate_contract_invoice
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/lines
add_line
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/obligations
create_contract_obligation
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/price-adjustment/apply
apply_adjustment
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/promote-intake-attributes
promote_intake_attributes
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/renew
renew_contract
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/save-as-template
save_as_template
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/service-plans
add_plan
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/service-plans/{plan_id}/generate
generate_plan
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/settle-supplier
settle_supplier
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/storage/areas
assign_area
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/storage/articles
storage_article_create
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/storage/consume
storage_consume
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/storage/count
storage_count
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/storage/orders
storage_order_create
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/subjects
add_subject
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/terminate
terminate_contract
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/upload-document
upload_contract_document
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/contracts/{contract_id}/usage
add_usage
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /api/v1/sales-agents
create_agent
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API POST /portal/{slug}/vertraege/{contract_id}/kuendigen
contract_termination_request
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API PUT /api/v1/contract-control/{contract_id}/terms/{term_id}
update_term
Semantic binding: operator_surface; mutation=True
 contracts
⚡ REST API PUT /api/v1/contracts/{contract_id}/semantic-attributes/{field_key}
set_contract_semantic_attribute
Semantic binding: operator_surface; mutation=True
 contracts

🛡️ Yönetim ve Uyum

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • BGB Sözleşme Hakları
  • DSGVO 28 (AVV sınırları)
  • Depolama yükümlülükleri
Bağlantı modüller:
➔ finance ➔ customers ➔ suppliers