Centurio System and module documentation
๐Ÿ›๏ธ Platform architecture ๐Ÿ”‘ Login
๐Ÿ  All modules / sales_billing / Expenditure
๐Ÿ“˜

Expenditure

expenses sales_billing ๐Ÿ›ก๏ธ RLS Protected

Expenditure and expenditure <unk> process and API documentation derived from code.

Fachliche Bestimmung: Expenditure and expenses <unk> process and API documentation derived from code.

โšก Workflows and life cycles

The following is the list of the following items: plan:command_expense_agent

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

1. expense_agent
expense_agent
The following is the list of the products:
Aktionen: expense_agent

User order: general agent plan:command_expense_general_agent

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

1. expense_general_agent
expense_general_agent
The following is the list of the products:
Aktionen: expense_general_agent

The following information shall be provided: plan:command_receipt_agent

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

1. receipt_agent
receipt_agent
The following is the list of the products:
Aktionen: receipt_agent

User order: supplier invoice agent plan:command_supplier_invoice_agent

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

1. supplier_invoice_agent
supplier_invoice_agent
The following is the list of the products:
Aktionen: supplier_invoice_agent

The following is the list of the following: status:expense

The following information is provided by the Commission on the basis of the information provided by the Member States:

1. detected
detected
The status of the state machine
2. needs_review
needs_review
Status <unk>needs_review<unk> of the state machine output.
3. approved
approved
Status <unk>approved <unk> of the condition machine output.
4. exported
Exported
State <unk>exported<unk> of the state machine output.

๐Ÿ—„๏ธ Data models and fields

ExpenseItems expense_items RLS Aktiv
20 Fields and columns

Tabelle expense_items

Feldname Type of data The Commission Schlรผssel The technical significance
expense_id UUID Ja * FK โž” expenses.id Feld expense_id
position INTEGER Ja * - Feld position
description TEXT Ja * - Feld description
product_id UUID Nein FK โž” products.id Feld product_id
quantity NUMERIC(14, 4) Nein - Feld quantity
unit VARCHAR(16) Nein - Feld unit
unit_price NUMERIC(14, 2) Nein - Feld unit_price
net_amount NUMERIC(14, 2) Ja * - Feld net_amount
tax_rate NUMERIC(6, 4) Ja * - Feld tax_rate
tax_amount NUMERIC(14, 2) Ja * - Feld tax_amount
gross_amount NUMERIC(14, 2) Ja * - Feld gross_amount
project_id UUID Nein FK โž” projects.id Feld project_id
material_action VARCHAR(48) Ja * - Feld material_action
inventory_action VARCHAR(48) Ja * - Feld inventory_action
confidence NUMERIC(4, 3) Nein - Feld confidence
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
Expenses expenses RLS Aktiv
31 Fields and columns

Tabelle expenses

Feldname Type of data The Commission Schlรผssel The technical significance
supplier_id UUID Nein FK โž” suppliers.id Feld supplier_id
project_id UUID Nein FK โž” projects.id Feld project_id
work_order_id UUID Nein FK โž” work_orders.id Feld work_order_id
purchase_id UUID Nein FK โž” purchases.id Feld purchase_id
goods_receipt_id UUID Nein FK โž” goods_receipts.id Feld goods_receipt_id
document_id UUID Nein FK โž” documents.id Feld document_id
expense_date DATE Ja * - Feld expense_date
receipt_number VARCHAR(64) Nein - Feld receipt_number
currency VARCHAR(3) Ja * - Feld currency
net_amount NUMERIC(14, 2) Ja * - Feld net_amount
tax_amount NUMERIC(14, 2) Ja * - Feld tax_amount
gross_amount NUMERIC(14, 2) Ja * - Feld gross_amount
payment_method VARCHAR(32) Nein - Feld payment_method
category VARCHAR(64) Nein - Feld category
cost_type_id UUID Nein FK โž” cost_types.id Feld cost_type_id
cost_center_id UUID Nein FK โž” cost_centers.id Feld cost_center_id
internal_order_id UUID Nein FK โž” controlling_internal_orders.id Feld internal_order_id
status VARCHAR(48) Ja * - Feld status
confidence NUMERIC(4, 3) Nein - Feld confidence
totals_consistent BOOLEAN Nein - Feld totals_consistent
external_accounting_id VARCHAR(128) Nein - Feld external_accounting_id
idempotency_key VARCHAR(128) Nein - Feld idempotency_key
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/expenses/{expense_id}
delete_expense
Semantic binding: not_evaluated; mutation=True
expenses
โšก REST API GET /api/v1/expenses
list_expenses
Semantic binding: not_evaluated; mutation=False
expenses
โšก REST API GET /api/v1/expenses/{expense_id}
get_expense
Semantic binding: not_evaluated; mutation=False
expenses
โšก REST API GET /api/v1/expenses/{expense_id}/3way-match
verify_3way_matching
Semantic binding: not_evaluated; mutation=False
expenses
โšก REST API GET /expenses
expenses_page
Semantic binding: not_evaluated; mutation=False
expenses
โšก REST API GET /expenses/new
expense_create_page
Semantic binding: not_evaluated; mutation=False
expenses
โšก REST API GET /expenses/{expense_id}
expense_detail_page
Semantic binding: not_evaluated; mutation=False
expenses
โšก REST API PATCH /api/v1/expenses/{expense_id}
update_expense
Semantic binding: not_evaluated; mutation=True
expenses
โšก REST API POST /api/v1/expenses
create_expense
Semantic binding: not_evaluated; mutation=True
expenses
โšก REST API POST /api/v1/expenses/batch-approve
batch_approve_expenses
Semantic binding: not_evaluated; mutation=True
expenses
โšก REST API POST /api/v1/expenses/upload
upload_receipt
Semantic binding: not_evaluated; mutation=True
expenses
โšก REST API POST /api/v1/expenses/{expense_id}/approve
approve_expense
Semantic binding: not_evaluated; mutation=True
expenses
โšก REST API POST /api/v1/expenses/{expense_id}/assign-project
assign_project
Semantic binding: not_evaluated; mutation=True
expenses
โšก REST API POST /api/v1/expenses/{expense_id}/items
add_expense_item
Semantic binding: not_evaluated; mutation=True
expenses

๐Ÿ›ก๏ธ Regulatory and compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

  • The Commission shall adopt the following implementing acts:
  • The following information shall be provided: