Invoices

Invoices generated from Quotes for billing renovation work. Track payment status, line items, and funding allocations. Invoices reference vendor Contacts and belong to Projects/Buildings.

Source Files

Layer	Path
Schema	backend/src/db/schema.ts (line ~1864)
Routes	backend/src/routes/invoices.ts
Service	backend/src/services/invoice-service.ts
Components	frontend/src/components/invoices/ (15 files)
Queries	frontend/src/lib/queries/invoiceQueries.ts

Database Tables

Table	Purpose
invoices	Main entity — project, contact, amounts, payment status, dates
invoice_line_items	Individual billed items with description, quantity, price, component type
invoice_line_item_funding_measures	Links line items to Funding Applications measures
invoice_line_item_funding_loans	Links line items to funding loans
component_invoice_links	Links Building Components to invoices
funding_invoice_allocations	Distributes funding across invoices

Key Fields

Field	Type	Notes
projectId	uuid FK	Parent project (cascade delete)
contactId	uuid FK	Vendor contact (required)
quoteId	uuid FK	Source quote (optional, set null on delete)
invoiceNumber	varchar	Unique invoice identifier
totalAmount / netAmount / taxAmount	decimal	Financial totals (precision 12,2)
taxRate	decimal	Default 19% (German VAT)
paymentStatus	enum	unpaid, pending, partially_paid, paid, overdue, cancelled
paidAmount / outstandingAmount	decimal	Payment tracking
discountPercentage, skontoPercentage	decimal	Discount and early-payment terms
customerPaymentConfirmation	boolean	Whether customer confirmed payment

Relationships

Invoice *──1 Project
Invoice *──1 Contact (vendor)
Invoice *──1 Quote (source, optional)
Invoice 1──* Invoice Line Items
Invoice *──* Building Components (via component_invoice_links)
Invoice *──* Funding Applications (via funding_invoice_allocations)

Frontend Components

Component	Purpose
InvoiceForm	Create/edit invoice with financial details
InvoiceLineItemsTable	Manage individual line items
InvoicesList	List view with filtering and sorting
BuildingInvoicesList	Invoices scoped to a building
InlineInvoicesTable / InlineInvoiceRow / InlineInvoiceExpandedRow	Compact inline display
LinkFundingApplicationsDialog	Link invoices to Funding Applications
CreateInvoiceWithProjectDialog	Quick-create with project selection
InvoiceFileManager / InvoiceFileDropzone / InvoiceFileUpload	Attach Files to invoices
InvoiceAssociatedFilesActions	Manage associated Files
InvoiceAuditLogDialog	View Audit Logs for an invoice
ProjectCombobox	Project picker for invoice creation

Features

• Derived from quotes — optionally links back to the source quote
• Payment tracking with status lifecycle (unpaid → partially_paid → paid)
• Funding allocation linking line items to Funding Applications measures and loans
• Component linking connecting invoices to Building Components
• File management with drag-and-drop upload for invoice documents
• Audit trail via Audit Logs dialog for tracking changes
• Skonto/discount terms with deadlines (German early-payment convention)
• Financial overview aggregated on Buildings detail page

Related Pages

Quotes | Projects | Buildings | Funding Applications | Building Components | Products | Contacts | Files | Financial Calculations | Audit Logs | Database Architecture