Invoice database reference

This reference is generated from the Doctrine ORM metadata.

Entities

`invoice`

Doctrine entity: Invoice\Entity\Invoice

Column	Doctrine type	Key
`invoice_id`	`integer`
`branch`	`string`
`omitcontact`	`smallint`
`has_open_item_statement`	`smallint`
`date_created`	`datetime`
`date_invoice`	`datetime`
`date_sent`	`date`
`date_paid`	`date`
`amount_open`	`decimal`
`amount_total`	`decimal`
`amount_paid`	`decimal`
`invoice_nr`	`string`
`purchase_order`	`string`
`daybooknumber`	`string`
`accounting_adapter`	`smallint`
`tw_date`	`date`
`tw_open`	`decimal`
`type_id`	`FK`	FK
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`accountingAdapter_id`	`FK`	FK
`paymentProvider_id`	`FK`	FK
`invoiceProvider_id`	`FK`	FK

`invoice_credit`

Doctrine entity: Invoice\Entity\Credit

Column	Doctrine type	Key
`credit_id`	`integer`
`invoice_nr`	`string`
`credit_nr`	`string`
`credit_invoice_id`	`FK`	FK
`orginal_invoice_id`	`FK`	FK

`invoice_journal`

Doctrine entity: Invoice\Entity\Journal

Column	Doctrine type	Key
`journal_id`	`integer`
`journal`	`text`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK
`organisation_contact_id`	`FK`	FK

`invoice_journal_entry`

Doctrine entity: Invoice\Entity\Journal\Entry

Column	Doctrine type	Key
`entry_id`	`integer`
`entry`	`string`
`date_created`	`datetime`
`contact_id`	`FK`	FK
`journal_id`	`FK`	FK

`invoice_log`

Doctrine entity: Invoice\Entity\Log

Column	Doctrine type	Key
`log_id`	`integer`
`log`	`string`
`date_created`	`datetime`
`date_followup`	`datetime`
`mark`	`boolean`
`contact_id`	`FK`	FK
`invoice_id`	`FK`	FK

`invoice_mailing_recipient`

Doctrine entity: Invoice\Entity\Invoice\Mailing\Recipient

Column	Doctrine type	Key
`id`	`integer`
`type`	`string`
`title`	`string`
`description`	`string`

`invoice_message`

Doctrine entity: Invoice\Entity\Message

Column	Doctrine type	Key
`message_id`	`integer`
`message`	`string`
`invoice_id`	`FK`	FK

`invoice_method`

Doctrine entity: Invoice\Entity\Method

Column	Doctrine type	Key
`method_id`	`integer`
`method`	`string`

`invoice_payment`

Doctrine entity: Invoice\Entity\Payment

Column	Doctrine type	Key
`payment_id`	`integer`
`date_created`	`datetime`
`amount`	`decimal`
`invoice_id`	`FK`	FK

`invoice_pdf`

Doctrine entity: Invoice\Entity\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`pdf`	`blob`
`date_created`	`datetime`
`date_end`	`datetime`
`invoice_id`	`FK`	FK

`invoice_row`

Doctrine entity: Invoice\Entity\Row

Column	Doctrine type	Key
`row_id`	`integer`
`row`	`string`
`quantity`	`decimal`
`amount`	`decimal`
`sequence`	`integer`
`code`	`string`
`dimension`	`integer`
`invoice_id`	`FK`	FK
`vat_id`	`FK`	FK

`invoice_sync`

Doctrine entity: Invoice\Entity\Sync

Column	Doctrine type	Key
`sync_id`	`integer`
`date_sync`	`datetime`
`sync`	`text`

`invoice_word`

Doctrine entity: Invoice\Entity\Word

Column	Doctrine type	Key
`word_id`	`integer`
`word`	`blob`
`date_created`	`datetime`
`date_end`	`datetime`
`invoice_id`	`FK`	FK

`reminder`

Doctrine entity: Invoice\Entity\Reminder

Column	Doctrine type	Key
`reminder_id`	`integer`
`date_reminded`	`datetime`
`date_created`	`datetime`
`description`	`text`
`size`	`integer`
`date_updated`	`datetime`
`branch`	`string`
`journal_id`	`FK`	FK
`type_id`	`FK`	FK
`contenttype_id`	`FK`	FK
`contact_id`	`FK`	FK
`organisation_id`	`FK`	FK

`reminder_pdf`

Doctrine entity: Invoice\Entity\Reminder\Pdf

Column	Doctrine type	Key
`pdf_id`	`integer`
`object`	`blob`
`reminder_id`	`FK`	FK
`invoice_id`	`FK`	FK

`reminder_type`

Doctrine entity: Invoice\Entity\Reminder\Type

Column	Doctrine type	Key
`type_id`	`integer`
`type`	`string`

`vat_dimension`

Doctrine entity: Invoice\Entity\Vat\Dimension

Column	Doctrine type	Key
`vat_dimension_id`	`integer`
`dimension`	`string`
`ledger`	`string`
`vat_id`	`FK`	FK
`vat_type_id`	`FK`	FK

Relationships

Source table	Association	Type	Source cardinality	Target cardinality	Target table	YuML
`invoice`	`accountingAdapter`	Many-to-one	`0..*`	`0..1`	`accounting_adapter`	`[invoice]0..*-accountingAdapter 0..1>[accounting_adapter]`
`invoice`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice]0..*-contact 1>[contact]`
`invoice`	`invoiceProvider`	Many-to-one	`0..*`	`0..1`	`accounting_invoice_provider`	`[invoice]0..*-invoiceProvider 0..1>[accounting_invoice_provider]`
`invoice`	`journal`	Many-to-many	`0..*`	`0..*`	`invoice_journal`	`[invoice]0..-journal 0..>[invoice_journal]`
`invoice`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[invoice]0..*-organisation 1>[organisation]`
`invoice`	`paymentProvider`	Many-to-one	`0..*`	`0..1`	`accounting_payment_provider`	`[invoice]0..*-paymentProvider 0..1>[accounting_payment_provider]`
`invoice`	`vatType`	Many-to-one	`0..*`	`1`	`vat_type`	`[invoice]0..*-vatType 1>[vat_type]`
`invoice_credit`	`creditInvoice`	One-to-one	`0..1`	`1`	`invoice`	`[invoice_credit]0..1-creditInvoice 1>[invoice]`
`invoice_credit`	`originalInvoice`	One-to-one	`0..1`	`1`	`invoice`	`[invoice_credit]0..1-originalInvoice 1>[invoice]`
`invoice_journal`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice_journal]0..*-contact 1>[contact]`
`invoice_journal`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[invoice_journal]0..*-organisation 1>[organisation]`
`invoice_journal`	`organisationContact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice_journal]0..*-organisationContact 1>[contact]`
`invoice_journal_entry`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice_journal_entry]0..*-contact 1>[contact]`
`invoice_journal_entry`	`journal`	Many-to-one	`0..*`	`1`	`invoice_journal`	`[invoice_journal_entry]0..*-journal 1>[invoice_journal]`
`invoice_log`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[invoice_log]0..*-contact 1>[contact]`
`invoice_log`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_log]0..*-invoice 1>[invoice]`
`invoice_message`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_message]0..*-invoice 1>[invoice]`
`invoice_payment`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_payment]0..*-invoice 1>[invoice]`
`invoice_pdf`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_pdf]0..*-invoice 1>[invoice]`
`invoice_row`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_row]0..*-invoice 1>[invoice]`
`invoice_row`	`vat`	Many-to-one	`0..*`	`1`	`vat`	`[invoice_row]0..*-vat 1>[vat]`
`invoice_word`	`invoice`	Many-to-one	`0..*`	`1`	`invoice`	`[invoice_word]0..*-invoice 1>[invoice]`
`reminder`	`contact`	Many-to-one	`0..*`	`1`	`contact`	`[reminder]0..*-contact 1>[contact]`
`reminder`	`contentType`	Many-to-one	`0..*`	`1`	`contenttype`	`[reminder]0..*-contentType 1>[contenttype]`
`reminder`	`invoice`	Many-to-many	`0..*`	`0..*`	`invoice`	`[reminder]0..-invoice 0..>[invoice]`
`reminder`	`journal`	Many-to-one	`0..*`	`0..1`	`invoice_journal`	`[reminder]0..*-journal 0..1>[invoice_journal]`
`reminder`	`organisation`	Many-to-one	`0..*`	`1`	`organisation`	`[reminder]0..*-organisation 1>[organisation]`
`reminder`	`type`	Many-to-one	`0..*`	`1`	`reminder_type`	`[reminder]0..*-type 1>[reminder_type]`
`reminder_pdf`	`invoice`	Many-to-one	`0..*`	`0..1`	`invoice`	`[reminder_pdf]0..*-invoice 0..1>[invoice]`
`reminder_pdf`	`reminder`	Many-to-one	`0..*`	`1`	`reminder`	`[reminder_pdf]0..*-reminder 1>[reminder]`
`vat_dimension`	`vat`	Many-to-one	`0..*`	`1`	`vat`	`[vat_dimension]0..*-vat 1>[vat]`
`vat_dimension`	`vatType`	Many-to-one	`0..*`	`1`	`vat_type`	`[vat_dimension]0..*-vatType 1>[vat_type]`

02 November 2026