{"format_version": 1, "encoding": "UTF-8", "dates": "ISO 8601", "money": "decimal strings", "files": "Originale/; references and SHA-256 in records", "datasets": {"workshops.workshop": {"description": "Betriebsprofil", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "document_logo": {"type": "FileField", "description": "Logo für PDF-Dokumente"}, "name": {"type": "CharField", "description": "name"}, "legal_name": {"type": "CharField", "description": "Vollständiger rechtlicher Name / Firma"}, "legal_form": {"type": "CharField", "description": "Rechtsform"}, "representatives": {"type": "CharField", "description": "Vertretungsberechtigte Personen"}, "register_court": {"type": "CharField", "description": "Registergericht"}, "register_number": {"type": "CharField", "description": "Registernummer"}, "registered_office": {"type": "CharField", "description": "Sitz laut Register"}, "supervisory_chair": {"type": "CharField", "description": "Aufsichtsratsvorsitz, falls vorhanden"}, "street": {"type": "CharField", "description": "street"}, "postal_code": {"type": "CharField", "description": "postal code"}, "city": {"type": "CharField", "description": "city"}, "phone": {"type": "CharField", "description": "phone"}, "email": {"type": "CharField", "description": "email"}, "tax_number": {"type": "CharField", "description": "tax number"}, "vat_id": {"type": "CharField", "description": "vat id"}, "owner": {"type": "CharField", "description": "owner"}, "bank_account_holder": {"type": "CharField", "description": "Kontoinhaber"}, "iban": {"type": "CharField", "description": "iban"}, "greeting_text": {"type": "CharField", "description": "greeting text"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "accounts.user": {"description": "Benutzerkonten", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "username": {"type": "CharField", "description": "Benutzername"}, "first_name": {"type": "CharField", "description": "Vorname"}, "last_name": {"type": "CharField", "description": "Nachname"}, "email": {"type": "CharField", "description": "E-Mail-Adresse"}, "is_active": {"type": "BooleanField", "description": "Aktiv"}, "date_joined": {"type": "DateTimeField", "description": "Mitglied seit"}, "is_business_owner": {"type": "BooleanField", "description": "Verträge und vollständige Betriebsdaten verwalten"}, "is_employee": {"type": "BooleanField", "description": "Mitarbeiterzugang"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "expires_at": {"type": "DateField", "description": "expires at"}}}, "teamwork.task": {"description": "Aufgaben", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "source_appointment_id": {"type": "OneToOneField", "description": "Ausgangstermin", "relation": "appointments.appointment"}, "submission_key": {"type": "UUIDField", "description": "submission key"}, "work_area": {"type": "CharField", "description": "Arbeitsbereich"}, "title": {"type": "CharField", "description": "Aufgabe"}, "description": {"type": "TextField", "description": "Beschreibung"}, "assignee_id": {"type": "ForeignKey", "description": "Zuständig", "relation": "accounts.user"}, "customer_id": {"type": "ForeignKey", "description": "Kunde", "relation": "customers.customer"}, "vehicle_id": {"type": "ForeignKey", "description": "Fahrzeug", "relation": "vehicles.vehicle"}, "quote_id": {"type": "ForeignKey", "description": "Kostenvoranschlag", "relation": "quotes.quote"}, "invoice_id": {"type": "ForeignKey", "description": "Rechnung", "relation": "invoices.invoice"}, "tire_set_id": {"type": "ForeignKey", "description": "Reifensatz", "relation": "storage.tireset"}, "due_date": {"type": "DateField", "description": "Erledigen bis"}, "status": {"type": "CharField", "description": "Status"}, "priority": {"type": "CharField", "description": "Priorität"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}, "completed_at": {"type": "DateTimeField", "description": "completed at"}}}, "teamwork.taskchecklistitem": {"description": "Auftragschecklisten", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "task_id": {"type": "ForeignKey", "description": "task", "relation": "teamwork.task"}, "title": {"type": "CharField", "description": "Arbeitsschritt"}, "position": {"type": "PositiveIntegerField", "description": "position"}, "is_done": {"type": "BooleanField", "description": "is done"}, "completed_at": {"type": "DateTimeField", "description": "completed at"}, "completed_by_id": {"type": "ForeignKey", "description": "completed by", "relation": "accounts.user"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}, "submission_key": {"type": "UUIDField", "description": "submission key"}}}, "teamwork.taskcomment": {"description": "Aufgaben-Rückmeldungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "submission_key": {"type": "UUIDField", "description": "submission key"}, "task_id": {"type": "ForeignKey", "description": "task", "relation": "teamwork.task"}, "author_id": {"type": "ForeignKey", "description": "author", "relation": "accounts.user"}, "content": {"type": "TextField", "description": "Rückmeldung"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "teamwork.task_labels": {"description": "Aufgaben-Labels", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "task_id": {"type": "ForeignKey", "description": "task", "relation": "teamwork.task"}, "workspacelabel_id": {"type": "ForeignKey", "description": "workspacelabel", "relation": "customers.workspacelabel"}}}, "teamwork.announcementreceipt": {"description": "Benachrichtigungsstatus", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "announcement_id": {"type": "ForeignKey", "description": "announcement", "relation": "teamwork.announcement"}, "user_id": {"type": "ForeignKey", "description": "user", "relation": "accounts.user"}, "read_at": {"type": "DateTimeField", "description": "read at"}}}, "core.dashboardnote": {"description": "Persönliche Notizen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "user_id": {"type": "OneToOneField", "description": "user", "relation": "accounts.user"}, "content": {"type": "TextField", "description": "content"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "customers.customer": {"description": "Kunden", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "salutation": {"type": "CharField", "description": "Anrede"}, "data_origin": {"type": "CharField", "description": "Herkunft der Kundendaten"}, "data_source": {"type": "CharField", "description": "Konkrete Datenquelle"}, "privacy_notified_on": {"type": "DateField", "description": "Datenschutzhinweise tatsächlich ausgehändigt am"}, "customer_number": {"type": "CharField", "description": "customer number"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "first_name": {"type": "CharField", "description": "first name"}, "last_name": {"type": "CharField", "description": "last name"}, "company": {"type": "CharField", "description": "Firma / Rechnungsempfänger"}, "debtor_account": {"type": "PositiveIntegerField", "description": "Individuelles Debitorenkonto"}, "phone": {"type": "CharField", "description": "phone"}, "email": {"type": "CharField", "description": "email"}, "street": {"type": "CharField", "description": "street"}, "postal_code": {"type": "CharField", "description": "postal code"}, "city": {"type": "CharField", "description": "city"}, "notes": {"type": "TextField", "description": "notes"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "customers.workspacelabel": {"description": "Labels", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "name": {"type": "CharField", "description": "Bezeichnung"}, "color": {"type": "CharField", "description": "Farbe"}}}, "customers.customer_labels": {"description": "Kunden-Labels", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "customer_id": {"type": "ForeignKey", "description": "customer", "relation": "customers.customer"}, "workspacelabel_id": {"type": "ForeignKey", "description": "workspacelabel", "relation": "customers.workspacelabel"}}}, "customers.customerprivacyprofile": {"description": "Datenschutzangaben für Kunden", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "OneToOneField", "description": "workshop", "relation": "workshops.workshop"}, "controller_name": {"type": "CharField", "description": "Verantwortlicher / rechtlicher Betriebsname"}, "privacy_email": {"type": "CharField", "description": "Kontakt für Datenschutzanfragen"}, "dpo_contact": {"type": "TextField", "description": "Kontakt des Datenschutzbeauftragten"}, "additional_recipients": {"type": "TextField", "description": "Weitere Empfänger und deren Aufgaben"}, "transfers": {"type": "CharField", "description": "Verarbeitung außerhalb der EU / des EWR"}, "transfer_details": {"type": "TextField", "description": "Drittländer und Schutzmaßnahmen"}, "automated_decisions": {"type": "CharField", "description": "Automatisierte Entscheidungen mit erheblicher Wirkung"}, "automated_details": {"type": "TextField", "description": "Verfahren, Auswirkungen und Rechte"}, "additional_processing": {"type": "TextField", "description": "Ergänzende Verarbeitungshinweise"}, "service_reminders": {"type": "BooleanField", "description": "Freiwillige Einwilligung für Serviceerinnerungen anbieten"}, "confirmed_at": {"type": "DateTimeField", "description": "confirmed at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "vehicles.vehicle": {"description": "Fahrzeuge", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "ownership": {"type": "CharField", "description": "Zuordnung"}, "stock_status": {"type": "CharField", "description": "Bestandsstatus"}, "rental_enabled": {"type": "BooleanField", "description": "Für Vermietung verfügbar"}, "rental_daily_price": {"type": "DecimalField", "description": "Mietpreis je 24 Stunden (€ brutto)"}, "rental_deposit": {"type": "DecimalField", "description": "Kaution (€)"}, "rental_included_km": {"type": "PositiveIntegerField", "description": "Inklusivkilometer je Mietvereinbarung"}, "rental_extra_km_price": {"type": "DecimalField", "description": "Mehrkilometer (€ brutto)"}, "rental_tax_mode": {"type": "CharField", "description": "Besteuerung der Miete"}, "notes": {"type": "TextField", "description": "Notizen / Bemerkungen"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "customer_id": {"type": "ForeignKey", "description": "customer", "relation": "customers.customer"}, "brand": {"type": "CharField", "description": "brand"}, "model": {"type": "CharField", "description": "model"}, "license_plate": {"type": "CharField", "description": "license plate"}, "vin": {"type": "CharField", "description": "Fahrgestellnummer (FIN)"}, "first_registration": {"type": "DateField", "description": "Erstzulassung"}, "last_registration": {"type": "DateField", "description": "Letzte Zulassung"}, "hu_due_month": {"type": "CharField", "description": "Nächste HU"}, "hsn": {"type": "CharField", "description": "HSN"}, "tsn": {"type": "CharField", "description": "Typenschlüssel (Feld 2.2)"}, "fuel": {"type": "CharField", "description": "Kraftstoff / Antrieb"}, "displacement": {"type": "PositiveIntegerField", "description": "Hubraum (cm³)"}, "power_kw": {"type": "DecimalField", "description": "Leistung (kW)"}, "engine_rpm": {"type": "CharField", "description": "Nenndrehzahl (U/min) (P.4)"}, "emission_class": {"type": "CharField", "description": "Schadstoffklasse / Euro-Norm (14)"}, "emission_key": {"type": "CharField", "description": "Emissionsschlüsselnummer (14.1)"}, "ec_emission_class": {"type": "CharField", "description": "EG-Schadstoffklasse (V.9)"}, "fuel_code": {"type": "CharField", "description": "Kraftstoffcode (10)"}, "co2_emissions": {"type": "DecimalField", "description": "CO₂-Ausstoß (g/km) (V.7)"}, "max_speed": {"type": "PositiveIntegerField", "description": "Höchstgeschwindigkeit (km/h) (T)"}, "tire_front": {"type": "CharField", "description": "Reifengröße Vorderachse (15.1)"}, "tire_rear": {"type": "CharField", "description": "Reifengröße Hinterachse (15.2)"}, "tire_third": {"type": "CharField", "description": "Reifengröße dritte Achse (15.3)"}, "technical_max_mass": {"type": "PositiveIntegerField", "description": "Technisch zulässige Gesamtmasse (kg) (F.1)"}, "permissible_max_mass": {"type": "PositiveIntegerField", "description": "Zulässige Gesamtmasse (kg) (F.2)"}, "unladen_mass": {"type": "PositiveIntegerField", "description": "Leermasse (kg) (G)"}, "towing_braked": {"type": "PositiveIntegerField", "description": "Anhängelast gebremst (kg) (O.1)"}, "towing_unbraked": {"type": "PositiveIntegerField", "description": "Anhängelast ungebremst (kg) (O.2)"}, "nose_weight": {"type": "PositiveIntegerField", "description": "Stützlast (kg) (13)"}, "axle_mass_technical_1": {"type": "PositiveIntegerField", "description": "Technische Achslast Achse 1 (kg) (7.1)"}, "axle_mass_technical_2": {"type": "PositiveIntegerField", "description": "Technische Achslast Achse 2 (kg) (7.2)"}, "axle_mass_technical_3": {"type": "PositiveIntegerField", "description": "Technische Achslast Achse 3 (kg) (7.3)"}, "axle_mass_permissible_1": {"type": "PositiveIntegerField", "description": "Zulässige Achslast Achse 1 (kg) (8.1)"}, "axle_mass_permissible_2": {"type": "PositiveIntegerField", "description": "Zulässige Achslast Achse 2 (kg) (8.2)"}, "axle_mass_permissible_3": {"type": "PositiveIntegerField", "description": "Zulässige Achslast Achse 3 (kg) (8.3)"}, "axle_count": {"type": "PositiveIntegerField", "description": "Anzahl der Achsen (L)"}, "drive_axle_count": {"type": "PositiveIntegerField", "description": "Anzahl der Antriebsachsen (9)"}, "length_mm": {"type": "PositiveIntegerField", "description": "Fahrzeuglänge (mm) (18)"}, "width_mm": {"type": "PositiveIntegerField", "description": "Fahrzeugbreite (mm) (19)"}, "height_mm": {"type": "PositiveIntegerField", "description": "Fahrzeughöhe (mm) (20)"}, "seats": {"type": "PositiveIntegerField", "description": "Sitzplätze (S.1)"}, "standing_places": {"type": "PositiveIntegerField", "description": "Stehplätze (S.2)"}, "stationary_noise": {"type": "DecimalField", "description": "Standgeräusch (dB) (U.1)"}, "stationary_noise_rpm": {"type": "PositiveIntegerField", "description": "Drehzahl bei Standgeräusch (U.2)"}, "drive_noise": {"type": "DecimalField", "description": "Fahrgeräusch (dB) (U.3)"}, "registration_remarks": {"type": "TextField", "description": "Bemerkungen und Ausnahmen (22)"}, "fahrzeugschein": {"type": "FileField", "description": "fahrzeugschein"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "vehicles.vehicle_labels": {"description": "Fahrzeug-Labels", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "vehicle_id": {"type": "ForeignKey", "description": "vehicle", "relation": "vehicles.vehicle"}, "workspacelabel_id": {"type": "ForeignKey", "description": "workspacelabel", "relation": "customers.workspacelabel"}}}, "vehicles.vehiclephoto": {"description": "Fahrzeugfotos", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "vehicle_id": {"type": "ForeignKey", "description": "vehicle", "relation": "vehicles.vehicle"}, "image": {"type": "FileField", "description": "image"}, "caption": {"type": "CharField", "description": "Bildbeschreibung"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "appointments.appointment": {"description": "Termine", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "quote_id": {"type": "ForeignKey", "description": "Kostenvoranschlag", "relation": "quotes.quote"}, "invoice_id": {"type": "ForeignKey", "description": "Rechnung", "relation": "invoices.invoice"}, "tire_set_id": {"type": "ForeignKey", "description": "Reifensatz", "relation": "storage.tireset"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "customer_id": {"type": "ForeignKey", "description": "customer", "relation": "customers.customer"}, "vehicle_id": {"type": "ForeignKey", "description": "vehicle", "relation": "vehicles.vehicle"}, "title": {"type": "CharField", "description": "title"}, "appointment_date": {"type": "DateField", "description": "appointment date"}, "appointment_time": {"type": "TimeField", "description": "appointment time"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "appointments.appointment_labels": {"description": "Termin-Labels", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "appointment_id": {"type": "ForeignKey", "description": "appointment", "relation": "appointments.appointment"}, "workspacelabel_id": {"type": "ForeignKey", "description": "workspacelabel", "relation": "customers.workspacelabel"}}}, "communications.preparedmessage": {"description": "Vorbereitete Nachrichten mit PDF", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "customer_id": {"type": "ForeignKey", "description": "customer", "relation": "customers.customer"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "invoices.invoice"}, "source_pk": {"type": "PositiveBigIntegerField", "description": "source pk"}, "kind": {"type": "CharField", "description": "kind"}, "subject": {"type": "CharField", "description": "subject"}, "body": {"type": "TextField", "description": "body"}, "email": {"type": "CharField", "description": "email"}, "phone": {"type": "CharField", "description": "phone"}, "recipient": {"type": "CharField", "description": "recipient"}, "pdf": {"type": "BinaryField", "description": "pdf"}, "sha256": {"type": "CharField", "description": "sha256"}, "filename": {"type": "CharField", "description": "filename"}, "amount": {"type": "DecimalField", "description": "amount"}, "deadline": {"type": "DateField", "description": "deadline"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "expires_at": {"type": "DateTimeField", "description": "expires at"}, "revoked_at": {"type": "DateTimeField", "description": "revoked at"}, "sent_on": {"type": "DateField", "description": "sent on"}, "sent_channel": {"type": "CharField", "description": "sent channel"}, "confirmed_by_id": {"type": "ForeignKey", "description": "confirmed by", "relation": "accounts.user"}, "confirmation_note": {"type": "CharField", "description": "confirmation note"}}}, "communications.messagetemplate": {"description": "Nachrichtenvorlagen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "name": {"type": "CharField", "description": "Name"}, "kind": {"type": "CharField", "description": "Dokument"}, "subject": {"type": "CharField", "description": "Betreff"}, "body": {"type": "TextField", "description": "Nachricht"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "communications.dunningcase": {"description": "Mahnvorgänge", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "OneToOneField", "description": "invoice", "relation": "invoices.invoice"}, "paused": {"type": "BooleanField", "description": "paused"}, "resume_on": {"type": "DateField", "description": "resume on"}, "note": {"type": "TextField", "description": "note"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}, "updated_by_id": {"type": "ForeignKey", "description": "updated by", "relation": "accounts.user"}}}, "quotes.quote": {"description": "Kostenvoranschläge", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "recipient_name": {"type": "CharField", "description": "Empfängername"}, "recipient_street": {"type": "CharField", "description": "Straße und Hausnummer"}, "recipient_postal_code": {"type": "CharField", "description": "Postleitzahl"}, "recipient_city": {"type": "CharField", "description": "Ort"}, "recipient_email": {"type": "CharField", "description": "E-Mail"}, "recipient_phone": {"type": "CharField", "description": "Telefon"}, "purpose": {"type": "CharField", "description": "Dokumentart"}, "cover_letter": {"type": "TextField", "description": "Anschreiben"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "customer_id": {"type": "ForeignKey", "description": "customer", "relation": "customers.customer"}, "vehicle_id": {"type": "ForeignKey", "description": "vehicle", "relation": "vehicles.vehicle"}, "converted_invoice_id": {"type": "OneToOneField", "description": "converted invoice", "relation": "invoices.invoice"}, "quote_number": {"type": "CharField", "description": "quote number"}, "additional_text": {"type": "TextField", "description": "additional text"}, "total_discount_percent": {"type": "DecimalField", "description": "Gesamtrabatt (%)"}, "total_discount_fixed": {"type": "DecimalField", "description": "Gesamtrabatt netto (€)"}, "mileage": {"type": "PositiveIntegerField", "description": "mileage"}, "public_link_enabled": {"type": "BooleanField", "description": "public link enabled"}, "public_link_created_at": {"type": "DateTimeField", "description": "public link created at"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "quotes.quote_labels": {"description": "KV-Labels", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "quote_id": {"type": "ForeignKey", "description": "quote", "relation": "quotes.quote"}, "workspacelabel_id": {"type": "ForeignKey", "description": "workspacelabel", "relation": "customers.workspacelabel"}}}, "quotes.quoteitem": {"description": "KV-Positionen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "quote_id": {"type": "ForeignKey", "description": "quote", "relation": "quotes.quote"}, "stock_item_id": {"type": "ForeignKey", "description": "Lagerartikel", "relation": "storage.stockitem"}, "description": {"type": "CharField", "description": "description"}, "quantity": {"type": "DecimalField", "description": "quantity"}, "unit": {"type": "CharField", "description": "unit"}, "unit_price": {"type": "DecimalField", "description": "unit price"}, "vat_rate": {"type": "DecimalField", "description": "vat rate"}, "discount_percent": {"type": "DecimalField", "description": "discount percent"}, "discount_fixed": {"type": "DecimalField", "description": "Positionsrabatt netto (€)"}, "sort_order": {"type": "PositiveIntegerField", "description": "sort order"}}}, "invoices.invoice": {"description": "Rechnungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "recipient_name": {"type": "CharField", "description": "Empfängername"}, "recipient_street": {"type": "CharField", "description": "Straße und Hausnummer"}, "recipient_postal_code": {"type": "CharField", "description": "Postleitzahl"}, "recipient_city": {"type": "CharField", "description": "Ort"}, "recipient_email": {"type": "CharField", "description": "E-Mail"}, "recipient_phone": {"type": "CharField", "description": "Telefon"}, "purpose": {"type": "CharField", "description": "Dokumentart"}, "cover_letter": {"type": "TextField", "description": "Anschreiben"}, "state": {"type": "CharField", "description": "state"}, "buyer_reference": {"type": "CharField", "description": "Bestellreferenz / Leitweg-ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "customer_id": {"type": "ForeignKey", "description": "customer", "relation": "customers.customer"}, "vehicle_id": {"type": "ForeignKey", "description": "vehicle", "relation": "vehicles.vehicle"}, "invoice_number": {"type": "CharField", "description": "invoice number"}, "additional_text": {"type": "TextField", "description": "additional text"}, "total_discount_percent": {"type": "DecimalField", "description": "Gesamtrabatt (%)"}, "total_discount_fixed": {"type": "DecimalField", "description": "Gesamtrabatt netto (€)"}, "mileage": {"type": "PositiveIntegerField", "description": "mileage"}, "is_paid": {"type": "BooleanField", "description": "is paid"}, "invoice_date": {"type": "DateField", "description": "invoice date"}, "service_date": {"type": "DateField", "description": "Leistungsdatum"}, "due_date": {"type": "DateField", "description": "Zahlbar bis"}, "tax_note": {"type": "CharField", "description": "Hinweis zur Steuerbefreiung"}, "public_xml_enabled": {"type": "BooleanField", "description": "XML über den Dokumentlink freigeben"}, "public_link_enabled": {"type": "BooleanField", "description": "public link enabled"}, "public_link_created_at": {"type": "DateTimeField", "description": "public link created at"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "invoices.invoice_labels": {"description": "Rechnungs-Labels", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "invoices.invoice"}, "workspacelabel_id": {"type": "ForeignKey", "description": "workspacelabel", "relation": "customers.workspacelabel"}}}, "invoices.invoiceitem": {"description": "Rechnungspositionen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "invoices.invoice"}, "stock_item_id": {"type": "ForeignKey", "description": "Lagerartikel", "relation": "storage.stockitem"}, "description": {"type": "CharField", "description": "description"}, "quantity": {"type": "DecimalField", "description": "quantity"}, "unit": {"type": "CharField", "description": "unit"}, "unit_price": {"type": "DecimalField", "description": "unit price"}, "gross_price": {"type": "DecimalField", "description": "Vereinbarter Bruttopreis"}, "vat_rate": {"type": "DecimalField", "description": "vat rate"}, "discount_percent": {"type": "DecimalField", "description": "discount percent"}, "discount_fixed": {"type": "DecimalField", "description": "Positionsrabatt netto (€)"}, "sort_order": {"type": "PositiveIntegerField", "description": "sort order"}}}, "purchases.purchaseinvoice": {"description": "Eingangsrechnungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "supplier_name": {"type": "CharField", "description": "supplier name"}, "invoice_number": {"type": "CharField", "description": "invoice number"}, "document_type": {"type": "CharField", "description": "document type"}, "invoice_date": {"type": "DateField", "description": "invoice date"}, "received_date": {"type": "DateField", "description": "received date"}, "service_date": {"type": "DateField", "description": "service date"}, "due_date": {"type": "DateField", "description": "due date"}, "description": {"type": "CharField", "description": "description"}, "notes": {"type": "TextField", "description": "notes"}, "tax_treatment": {"type": "CharField", "description": "tax treatment"}, "tax_note": {"type": "CharField", "description": "tax note"}, "creditor_account": {"type": "PositiveIntegerField", "description": "creditor account"}, "declared_gross": {"type": "DecimalField", "description": "declared gross"}, "state": {"type": "CharField", "description": "state"}, "revision": {"type": "PositiveIntegerField", "description": "revision"}, "exported_batch_id": {"type": "ForeignKey", "description": "exported batch", "relation": "accounting.exportbatch"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}, "reviewed_at": {"type": "DateTimeField", "description": "reviewed at"}}}, "purchases.purchasetaxline": {"description": "Steueraufteilung der Eingangsrechnungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "purchases.purchaseinvoice"}, "net_amount": {"type": "DecimalField", "description": "net amount"}, "vat_amount": {"type": "DecimalField", "description": "vat amount"}, "vat_rate": {"type": "DecimalField", "description": "vat rate"}, "expense_account": {"type": "PositiveIntegerField", "description": "expense account"}, "description": {"type": "CharField", "description": "description"}, "sort_order": {"type": "PositiveSmallIntegerField", "description": "sort order"}}}, "purchases.purchaseattachment": {"description": "Originalbelege der Eingangsrechnungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "purchases.purchaseinvoice"}, "filename": {"type": "CharField", "description": "filename"}, "mime_type": {"type": "CharField", "description": "mime type"}, "size": {"type": "PositiveIntegerField", "description": "size"}, "sha256": {"type": "CharField", "description": "sha256"}, "content": {"type": "BinaryField", "description": "content"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "purchases.purchasepayment": {"description": "Zahlungen zu Eingangsrechnungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "purchases.purchaseinvoice"}, "amount": {"type": "DecimalField", "description": "amount"}, "payment_date": {"type": "DateField", "description": "payment date"}, "method": {"type": "CharField", "description": "method"}, "reference": {"type": "CharField", "description": "reference"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "reversed_at": {"type": "DateTimeField", "description": "reversed at"}, "reversed_by_id": {"type": "ForeignKey", "description": "reversed by", "relation": "accounts.user"}, "reversal_reason": {"type": "CharField", "description": "reversal reason"}}}, "purchases.purchaseevent": {"description": "Änderungsverlauf der Eingangsrechnungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "purchases.purchaseinvoice"}, "actor_id": {"type": "ForeignKey", "description": "actor", "relation": "accounts.user"}, "action": {"type": "CharField", "description": "action"}, "snapshot": {"type": "JSONField", "description": "snapshot"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "invoices.invoicerecord": {"description": "Gesicherte Rechnungsfassungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "OneToOneField", "description": "invoice", "relation": "invoices.invoice"}, "snapshot": {"type": "JSONField", "description": "snapshot"}, "pdf": {"type": "BinaryField", "description": "pdf"}, "xml": {"type": "BinaryField", "description": "xml"}, "sha256": {"type": "CharField", "description": "sha256"}, "xml_validation": {"type": "JSONField", "description": "xml validation"}, "xml_sha256": {"type": "CharField", "description": "xml sha256"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "issued_by_id": {"type": "ForeignKey", "description": "issued by", "relation": "accounts.user"}, "source": {"type": "CharField", "description": "source"}}}, "invoices.invoicepayment": {"description": "Zahlungen und Zahlungskorrekturen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "invoices.invoice"}, "amount": {"type": "DecimalField", "description": "amount"}, "payment_date": {"type": "DateField", "description": "payment date"}, "date_recorded_at": {"type": "DateTimeField", "description": "date recorded at"}, "date_recorded_by_id": {"type": "ForeignKey", "description": "date recorded by", "relation": "accounts.user"}, "date_evidence": {"type": "CharField", "description": "date evidence"}, "method": {"type": "CharField", "description": "method"}, "reference": {"type": "CharField", "description": "reference"}, "request_id": {"type": "UUIDField", "description": "request id"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "reversed_at": {"type": "DateTimeField", "description": "reversed at"}, "reversed_by_id": {"type": "ForeignKey", "description": "reversed by", "relation": "accounts.user"}, "reversal_reason": {"type": "CharField", "description": "reversal reason"}}}, "storage.tireset": {"description": "Reifensätze", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "customer_id": {"type": "ForeignKey", "description": "customer", "relation": "customers.customer"}, "vehicle_id": {"type": "ForeignKey", "description": "vehicle", "relation": "vehicles.vehicle"}, "number": {"type": "CharField", "description": "number"}, "location": {"type": "CharField", "description": "Lagerplatz"}, "season": {"type": "CharField", "description": "Bereifung"}, "quantity": {"type": "PositiveSmallIntegerField", "description": "Anzahl"}, "brand": {"type": "CharField", "description": "Hersteller / Modell"}, "size_front": {"type": "CharField", "description": "Reifengröße vorne"}, "size_rear": {"type": "CharField", "description": "Reifengröße hinten"}, "rims": {"type": "CharField", "description": "Felgen"}, "dot": {"type": "CharField", "description": "DOT (Woche/Jahr)"}, "tread_fl": {"type": "DecimalField", "description": "Vorne links (mm)"}, "tread_fr": {"type": "DecimalField", "description": "Vorne rechts (mm)"}, "tread_rl": {"type": "DecimalField", "description": "Hinten links (mm)"}, "tread_rr": {"type": "DecimalField", "description": "Hinten rechts (mm)"}, "notes": {"type": "TextField", "description": "Zustand / Hinweise"}, "stored_on": {"type": "DateField", "description": "Eingelagert am"}, "returned_on": {"type": "DateField", "description": "Ausgegeben am"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "storage.tireset_labels": {"description": "Reifen-Labels", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "tireset_id": {"type": "ForeignKey", "description": "tireset", "relation": "storage.tireset"}, "workspacelabel_id": {"type": "ForeignKey", "description": "workspacelabel", "relation": "customers.workspacelabel"}}}, "storage.tireevent": {"description": "Reifenverlauf", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "tire_set_id": {"type": "ForeignKey", "description": "tire set", "relation": "storage.tireset"}, "kind": {"type": "CharField", "description": "kind"}, "note": {"type": "CharField", "description": "note"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}}}, "storage.stockitem": {"description": "Lagerartikel", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "name": {"type": "CharField", "description": "Artikel"}, "sku": {"type": "CharField", "description": "Artikelnummer"}, "category": {"type": "CharField", "description": "Kategorie"}, "location": {"type": "CharField", "description": "Lagerplatz"}, "unit": {"type": "CharField", "description": "Einheit"}, "quantity": {"type": "DecimalField", "description": "Bestand"}, "minimum": {"type": "DecimalField", "description": "Mindestbestand"}, "purchase_price": {"type": "DecimalField", "description": "Einkaufspreis netto (€)"}, "selling_price": {"type": "DecimalField", "description": "Verkaufspreis netto (€)"}, "supplier": {"type": "CharField", "description": "Lieferant"}, "notes": {"type": "TextField", "description": "Notizen"}, "archived": {"type": "BooleanField", "description": "archived"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "storage.stockitem_labels": {"description": "Lagerartikel-Labels", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "stockitem_id": {"type": "ForeignKey", "description": "stockitem", "relation": "storage.stockitem"}, "workspacelabel_id": {"type": "ForeignKey", "description": "workspacelabel", "relation": "customers.workspacelabel"}}}, "storage.stockmovement": {"description": "Bestandsbewegungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "invoices.invoice"}, "document_action": {"type": "CharField", "description": "document action"}, "item_id": {"type": "ForeignKey", "description": "item", "relation": "storage.stockitem"}, "delta": {"type": "DecimalField", "description": "delta"}, "balance": {"type": "DecimalField", "description": "balance"}, "reason": {"type": "CharField", "description": "reason"}, "request_id": {"type": "UUIDField", "description": "request id"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}}}, "accounting.exportbatch": {"description": "DATEV-Übergaben mit Archivdateien", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "start": {"type": "DateField", "description": "start"}, "end": {"type": "DateField", "description": "end"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "invoice_count": {"type": "PositiveIntegerField", "description": "invoice count"}, "gross_total": {"type": "DecimalField", "description": "gross total"}, "sha256": {"type": "CharField", "description": "sha256"}, "manifest": {"type": "JSONField", "description": "manifest"}, "archive": {"type": "BinaryField", "description": "archive"}}}, "accounting.invoicearchive": {"description": "Archivierte Rechnungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "OneToOneField", "description": "invoice", "relation": "invoices.invoice"}, "batch_id": {"type": "ForeignKey", "description": "batch", "relation": "accounting.exportbatch"}, "snapshot": {"type": "JSONField", "description": "snapshot"}, "pdf": {"type": "BinaryField", "description": "pdf"}, "sha256": {"type": "CharField", "description": "sha256"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "accounting.invoicecancellation": {"description": "Stornobelege", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "xml": {"type": "BinaryField", "description": "xml"}, "xml_sha256": {"type": "CharField", "description": "xml sha256"}, "xml_validation": {"type": "JSONField", "description": "xml validation"}, "invoice_id": {"type": "OneToOneField", "description": "invoice", "relation": "invoices.invoice"}, "number": {"type": "CharField", "description": "number"}, "date": {"type": "DateField", "description": "date"}, "reason": {"type": "CharField", "description": "reason"}, "pdf": {"type": "BinaryField", "description": "pdf"}, "sha256": {"type": "CharField", "description": "sha256"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "batch_id": {"type": "ForeignKey", "description": "batch", "relation": "accounting.exportbatch"}}}, "accounting.accountingprofile": {"description": "Buchhaltungseinstellungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "OneToOneField", "description": "workshop", "relation": "workshops.workshop"}, "consultant_number": {"type": "PositiveIntegerField", "description": "Beraternummer"}, "client_number": {"type": "PositiveIntegerField", "description": "Mandantennummer"}, "chart": {"type": "CharField", "description": "Kontenrahmen"}, "debtor_account": {"type": "PositiveIntegerField", "description": "Sammeldebitor"}, "revenue_19": {"type": "PositiveIntegerField", "description": "Erlöskonto 19 % (Automatikkonto)"}, "revenue_7": {"type": "PositiveIntegerField", "description": "Erlöskonto 7 % (Automatikkonto)"}, "revenue_0": {"type": "PositiveIntegerField", "description": "Erlöskonto steuerfrei (ohne Automatik)"}, "confirmed": {"type": "BooleanField", "description": "Kontenzuordnung und Verfahren mit der Kanzlei abgestimmt"}, "creditor_account": {"type": "PositiveIntegerField", "description": "Gemeinsames Lieferantenkonto"}, "purchase_accounts_confirmed": {"type": "BooleanField", "description": "Eingangsrechnungen: Konten ohne Steuerautomatik und Vorsteuerverfahren mit der Kanzlei abgestimmt"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "invoices.invoicenumbercounter": {"description": "Rechnungsnummernzähler", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "year": {"type": "PositiveSmallIntegerField", "description": "year"}, "last_number": {"type": "PositiveBigIntegerField", "description": "last number"}}}, "quotes.quotenumbercounter": {"description": "Kostenvoranschlagsnummernzähler", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "year": {"type": "PositiveSmallIntegerField", "description": "year"}, "last_number": {"type": "PositiveBigIntegerField", "description": "last number"}}}, "vehicles.scanimport": {"description": "Scanner-Importnachweise", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "user_id": {"type": "ForeignKey", "description": "user", "relation": "accounts.user"}, "vehicle_id": {"type": "ForeignKey", "description": "vehicle", "relation": "vehicles.vehicle"}, "customer_id": {"type": "ForeignKey", "description": "customer", "relation": "customers.customer"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "billing.subscriptionrequest": {"description": "Abo-Anfragen und Antworten", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "cycle": {"type": "CharField", "description": "Gewünschte Laufzeit"}, "note": {"type": "TextField", "description": "Nachricht (optional)"}, "status": {"type": "CharField", "description": "status"}, "response": {"type": "TextField", "description": "Antwort an den Betrieb"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "timetracking.timeentry": {"description": "Arbeitszeiten", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "user_id": {"type": "ForeignKey", "description": "user", "relation": "accounts.user"}, "user_reference": {"type": "PositiveBigIntegerField", "description": "user reference"}, "employee_name": {"type": "CharField", "description": "employee name"}, "task_id": {"type": "ForeignKey", "description": "task", "relation": "teamwork.task"}, "task_title": {"type": "CharField", "description": "task title"}, "started_at": {"type": "DateTimeField", "description": "Beginn"}, "ended_at": {"type": "DateTimeField", "description": "Ende"}, "note": {"type": "CharField", "description": "Notiz"}, "source": {"type": "CharField", "description": "source"}, "submission_key": {"type": "UUIDField", "description": "submission key"}, "revision": {"type": "UUIDField", "description": "revision"}, "needs_review": {"type": "BooleanField", "description": "needs review"}, "voided_at": {"type": "DateTimeField", "description": "voided at"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "timetracking.timeentrychange": {"description": "Änderungsverlauf der Arbeitszeiten", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "entry_id": {"type": "ForeignKey", "description": "entry", "relation": "timetracking.timeentry"}, "actor_id": {"type": "ForeignKey", "description": "actor", "relation": "accounts.user"}, "actor_name": {"type": "CharField", "description": "actor name"}, "action": {"type": "CharField", "description": "action"}, "reason": {"type": "CharField", "description": "reason"}, "before": {"type": "JSONField", "description": "before"}, "after": {"type": "JSONField", "description": "after"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "sales.salecontract": {"description": "Fahrzeugkaufverträge mit Druckfassungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "customer_id": {"type": "ForeignKey", "description": "Käufer aus Kunden übernehmen", "relation": "customers.customer"}, "vehicle_id": {"type": "ForeignKey", "description": "Fahrzeug aus Bestand übernehmen", "relation": "vehicles.vehicle"}, "invoice_id": {"type": "OneToOneField", "description": "invoice", "relation": "invoices.invoice"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "submission_key": {"type": "UUIDField", "description": "submission key"}, "number": {"type": "CharField", "description": "number"}, "status": {"type": "CharField", "description": "status"}, "contract_date": {"type": "DateField", "description": "Vorgesehenes Vertragsdatum"}, "buyer_type": {"type": "CharField", "description": "Käufer handelt als"}, "buyer_name": {"type": "CharField", "description": "Vollständiger Name / rechtlicher Firmenname"}, "buyer_representative": {"type": "CharField", "description": "Vertreten durch"}, "buyer_street": {"type": "CharField", "description": "Straße und Hausnummer"}, "buyer_postal_code": {"type": "CharField", "description": "PLZ"}, "buyer_city": {"type": "CharField", "description": "Ort"}, "buyer_email": {"type": "CharField", "description": "E-Mail"}, "buyer_phone": {"type": "CharField", "description": "Telefon"}, "vehicle_title": {"type": "CharField", "description": "Marke und Modell"}, "vin": {"type": "CharField", "description": "Fahrzeug-Identifizierungsnummer (FIN)"}, "license_plate": {"type": "CharField", "description": "Kennzeichen"}, "condition": {"type": "CharField", "description": "Fahrzeugart"}, "first_registration": {"type": "DateField", "description": "Erstzulassung"}, "mileage": {"type": "PositiveIntegerField", "description": "Abgelesener Kilometerstand (km)"}, "total_mileage": {"type": "CharField", "description": "Gesamtlaufleistung / Angaben dazu"}, "previous_owners": {"type": "PositiveSmallIntegerField", "description": "Anzahl Vorhalter"}, "hu_valid_until": {"type": "DateField", "description": "Nächste HU (Monatsende)"}, "accident_history": {"type": "TextField", "description": "Unfallschäden / Vorschäden"}, "known_defects": {"type": "TextField", "description": "Bekannte Mängel und Zustand"}, "equipment": {"type": "TextField", "description": "Ausstattung und Zubehör"}, "documents": {"type": "TextField", "description": "Mitzugebende Unterlagen"}, "keys": {"type": "PositiveSmallIntegerField", "description": "Anzahl Schlüssel"}, "total_price": {"type": "DecimalField", "description": "Vereinbarter Gesamtpreis (€)"}, "tax_mode": {"type": "CharField", "description": "Steuerliche Behandlung"}, "vat_rate": {"type": "DecimalField", "description": "Enthaltener Umsatzsteuersatz (%)"}, "payment_terms": {"type": "TextField", "description": "Zahlungsvereinbarung"}, "delivery_terms": {"type": "TextField", "description": "Übergabe und Abholung"}, "additional_terms": {"type": "TextField", "description": "Weitere individuelle Vereinbarungen"}, "snapshot": {"type": "JSONField", "description": "snapshot"}, "pdf": {"type": "BinaryField", "description": "pdf"}, "pdf_sha256": {"type": "CharField", "description": "pdf sha256"}, "finalized_at": {"type": "DateTimeField", "description": "finalized at"}, "cancelled_at": {"type": "DateTimeField", "description": "cancelled at"}, "cancellation_reason": {"type": "CharField", "description": "cancellation reason"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "sales.salesequence": {"description": "Kaufvertragsnummernzähler", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "year": {"type": "PositiveSmallIntegerField", "description": "year"}, "value": {"type": "PositiveIntegerField", "description": "value"}}}, "rentals.rental": {"description": "Fahrzeugvermietungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "customer_id": {"type": "ForeignKey", "description": "Mieter", "relation": "customers.customer"}, "vehicle_id": {"type": "ForeignKey", "description": "Mietfahrzeug", "relation": "vehicles.vehicle"}, "invoice_id": {"type": "OneToOneField", "description": "invoice", "relation": "invoices.invoice"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "submission_key": {"type": "UUIDField", "description": "submission key"}, "number": {"type": "CharField", "description": "number"}, "status": {"type": "CharField", "description": "status"}, "planned_start": {"type": "DateTimeField", "description": "Geplante Übergabe"}, "planned_end": {"type": "DateTimeField", "description": "Vereinbarte Rückgabe"}, "daily_price": {"type": "DecimalField", "description": "Preis je angefangene 24 Stunden (€ brutto)"}, "tax_mode": {"type": "CharField", "description": "Steuerliche Behandlung"}, "included_km": {"type": "PositiveIntegerField", "description": "Inklusivkilometer für die gesamte Miete"}, "extra_km_price": {"type": "DecimalField", "description": "Preis je Mehrkilometer (€ brutto)"}, "deposit_amount": {"type": "DecimalField", "description": "Vereinbarte Kaution (€)"}, "driver_name": {"type": "CharField", "description": "Fahrer / zugelassene Fahrer"}, "insurance_terms": {"type": "TextField", "description": "Versicherung und Selbstbeteiligung"}, "individual_terms": {"type": "TextField", "description": "Individuelle Vereinbarungen"}, "pickup_location": {"type": "CharField", "description": "Übergabeort"}, "return_location": {"type": "CharField", "description": "Rückgabeort"}, "snapshot": {"type": "JSONField", "description": "snapshot"}, "settlement_snapshot": {"type": "JSONField", "description": "settlement snapshot"}, "started_at": {"type": "DateTimeField", "description": "started at"}, "returned_at": {"type": "DateTimeField", "description": "returned at"}, "cancelled_at": {"type": "DateTimeField", "description": "cancelled at"}, "cancellation_reason": {"type": "CharField", "description": "cancellation reason"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "rentals.rentaldocument": {"description": "Mietunterlagen und Übergabeprotokolle", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "rental_id": {"type": "ForeignKey", "description": "rental", "relation": "rentals.rental"}, "kind": {"type": "CharField", "description": "kind"}, "version": {"type": "PositiveIntegerField", "description": "version"}, "snapshot": {"type": "JSONField", "description": "snapshot"}, "pdf": {"type": "BinaryField", "description": "pdf"}, "pdf_sha256": {"type": "CharField", "description": "pdf sha256"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "rentals.rentaldepositentry": {"description": "Kautionseingänge und Rückzahlungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "rental_id": {"type": "ForeignKey", "description": "rental", "relation": "rentals.rental"}, "kind": {"type": "CharField", "description": "kind"}, "amount": {"type": "DecimalField", "description": "Betrag (€)"}, "date": {"type": "DateField", "description": "Datum"}, "method": {"type": "CharField", "description": "Zahlungsart"}, "reference": {"type": "CharField", "description": "Beleg / Verwendungszweck"}, "submission_key": {"type": "UUIDField", "description": "submission key"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "rentals.rentalsequence": {"description": "Mietvorgangsnummernzähler", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "year": {"type": "PositiveSmallIntegerField", "description": "year"}, "value": {"type": "PositiveIntegerField", "description": "value"}}}, "compliance.legalacceptance": {"description": "Vertragsannahmen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "release_id": {"type": "ForeignKey", "description": "release", "relation": "compliance.legalrelease"}, "accepted_by_id": {"type": "ForeignKey", "description": "accepted by", "relation": "accounts.user"}, "representative": {"type": "CharField", "description": "representative"}, "business": {"type": "JSONField", "description": "business"}, "sha256": {"type": "CharField", "description": "sha256"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "compliance.subscriptionoffer": {"description": "Abo-Angebote", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "release_id": {"type": "ForeignKey", "description": "release", "relation": "compliance.legalrelease"}, "cycle": {"type": "CharField", "description": "Zahlungsweise"}, "price_net": {"type": "DecimalField", "description": "Preis netto je Zeitraum (€)"}, "vat_rate": {"type": "DecimalField", "description": "Umsatzsteuer (%)"}, "starts_on": {"type": "DateField", "description": "Beginn des Zugangs / der Testphase"}, "trial_days": {"type": "PositiveSmallIntegerField", "description": "Kostenlose Testtage"}, "valid_until": {"type": "DateField", "description": "Angebot annehmbar bis einschließlich"}, "business": {"type": "JSONField", "description": "business"}, "body": {"type": "JSONField", "description": "body"}, "sha256": {"type": "CharField", "description": "sha256"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "withdrawn_at": {"type": "DateTimeField", "description": "withdrawn at"}}}, "compliance.subscription": {"description": "Abonnements", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "end_reason": {"type": "TextField", "description": "end reason"}, "end_history": {"type": "JSONField", "description": "end history"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "offer_id": {"type": "OneToOneField", "description": "offer", "relation": "compliance.subscriptionoffer"}, "representative": {"type": "CharField", "description": "representative"}, "accepted_by_id": {"type": "ForeignKey", "description": "accepted by", "relation": "accounts.user"}, "accepted_at": {"type": "DateTimeField", "description": "accepted at"}, "cancelled_at": {"type": "DateTimeField", "description": "cancelled at"}, "ends_on": {"type": "DateField", "description": "ends on"}, "cancellation_reference": {"type": "UUIDField", "description": "cancellation reference"}}}, "compliance.privacyrequest": {"description": "Datenschutzanfragen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "workshop_id": {"type": "ForeignKey", "description": "workshop", "relation": "workshops.workshop"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}, "kind": {"type": "CharField", "description": "Anliegen"}, "message": {"type": "TextField", "description": "Beschreibung"}, "status": {"type": "CharField", "description": "Bearbeitung"}, "response": {"type": "TextField", "description": "Antwort an den Betrieb"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "due_at": {"type": "DateTimeField", "description": "due at"}, "updated_at": {"type": "DateTimeField", "description": "updated at"}}}, "compliance.legalrelease": {"description": "Vereinbarte Unterlagen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "version": {"type": "CharField", "description": "version"}, "provider": {"type": "JSONField", "description": "provider"}, "documents": {"type": "JSONField", "description": "documents"}, "sha256": {"type": "CharField", "description": "sha256"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "created_by_id": {"type": "ForeignKey", "description": "created by", "relation": "accounts.user"}}}, "teamwork.announcement": {"description": "Empfangene Neuigkeiten", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "submission_key": {"type": "UUIDField", "description": "submission key"}, "event_key": {"type": "CharField", "description": "event key"}, "action_route": {"type": "CharField", "description": "action route"}, "action_id": {"type": "UUIDField", "description": "action id"}, "title": {"type": "CharField", "description": "Betreff"}, "body": {"type": "TextField", "description": "Nachricht"}, "kind": {"type": "CharField", "description": "Art"}, "author_id": {"type": "ForeignKey", "description": "author", "relation": "accounts.user"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "withdrawn_at": {"type": "DateTimeField", "description": "withdrawn at"}, "audience": {"type": "CharField", "description": "audience"}}}, "billing.membership": {"description": "Online-Abo", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "workshop_id": {"type": "OneToOneField", "description": "workshop", "relation": "workshops.workshop"}, "owner_id": {"type": "OneToOneField", "description": "owner", "relation": "accounts.user"}, "email": {"type": "CharField", "description": "email"}, "cycle": {"type": "CharField", "description": "cycle"}, "price_net": {"type": "DecimalField", "description": "price net"}, "vat_rate": {"type": "DecimalField", "description": "vat rate"}, "demo": {"type": "BooleanField", "description": "demo"}, "agreement": {"type": "JSONField", "description": "agreement"}, "agreement_sha256": {"type": "CharField", "description": "agreement sha256"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "activated_on": {"type": "DateField", "description": "activated on"}, "paid_until": {"type": "DateField", "description": "paid until"}, "billing_anchor": {"type": "DateField", "description": "billing anchor"}, "preexisting_unlimited_access": {"type": "BooleanField", "description": "preexisting unlimited access"}, "closed_at": {"type": "DateTimeField", "description": "closed at"}}}, "billing.membershipagreement": {"description": "Abo-Vertragsfassungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "membership_id": {"type": "ForeignKey", "description": "membership", "relation": "billing.membership"}, "request_id": {"type": "UUIDField", "description": "request id"}, "snapshot": {"type": "JSONField", "description": "snapshot"}, "sha256": {"type": "CharField", "description": "sha256"}, "previous": {"type": "JSONField", "description": "previous"}, "invoice_id": {"type": "OneToOneField", "description": "invoice", "relation": "billing.aboinvoice"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "billing.aboinvoice": {"description": "Abo-Rechnungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "UUIDField", "description": "id"}, "membership_id": {"type": "ForeignKey", "description": "membership", "relation": "billing.membership"}, "number": {"type": "CharField", "description": "number"}, "payment_reference": {"type": "CharField", "description": "payment reference"}, "kind": {"type": "CharField", "description": "kind"}, "original_id": {"type": "OneToOneField", "description": "original", "relation": "billing.aboinvoice"}, "snapshot": {"type": "JSONField", "description": "snapshot"}, "sha256": {"type": "CharField", "description": "sha256"}, "pdf": {"type": "BinaryField", "description": "pdf"}, "xml": {"type": "BinaryField", "description": "xml"}, "xml_sha256": {"type": "CharField", "description": "xml sha256"}, "created_at": {"type": "DateTimeField", "description": "created at"}, "settled_at": {"type": "DateTimeField", "description": "settled at"}}}, "billing.abopayment": {"description": "Abo-Zahlungen", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "ForeignKey", "description": "invoice", "relation": "billing.aboinvoice"}, "amount": {"type": "DecimalField", "description": "amount"}, "received_on": {"type": "DateField", "description": "received on"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}, "billing.accessperiod": {"description": "Bezahlte Nutzungszeiträume", "format": "JSON Lines / UTF-8", "fields": {"id": {"type": "BigAutoField", "description": "ID"}, "invoice_id": {"type": "OneToOneField", "description": "invoice", "relation": "billing.aboinvoice"}, "starts_on": {"type": "DateField", "description": "starts on"}, "ends_on": {"type": "DateField", "description": "ends on"}, "pdf": {"type": "BinaryField", "description": "pdf"}, "sha256": {"type": "CharField", "description": "sha256"}, "created_at": {"type": "DateTimeField", "description": "created at"}}}}, "excluded": ["passwords", "reusable access credentials", "other tenants", "internal support notes"]}