Skip to content

Entity Relationship Overview

erDiagram
    Quote ||--o{ QuoteItem : "has"
    Quote ||--o{ SalesOrder : "generates"
    Quote ||--o{ Invoice : "generates"
    Quote ||--o{ PurchaseOrder : "generates"

    SalesOrder ||--o{ SalesOrderItem : "has"
    SalesOrder ||--o{ Invoice : "generates"

    Invoice ||--o{ InvoiceItem : "has"
    Invoice ||--o{ Payment : "has"
    Invoice ||--o{ CreditNote : "has"

    ProformaInvoice ||--o{ ProformaInvoiceItem : "has"
    ProformaInvoice ||--o{ Payment : "has"
    ProformaInvoice }o--|| Invoice : "deduction"

    CreditNote ||--o{ CreditNoteItem : "has"
    CreditNote }o--o{ Invoice : "refunds"

    PurchaseOrder ||--o{ PurchaseOrderItem : "has"
    PurchaseOrder ||--o{ SupplierInvoice : "generates"

    SupplierInvoice ||--o{ SupplierInvoiceItem : "has"
    SupplierInvoice ||--o{ OutgoingPayment : "has"

    AutomaticInvoice ||--o{ AutomaticInvoiceItem : "has"
    AutomaticInvoice ||--o{ Invoice : "generates"

    Account ||--o{ Invoice : "customer"
    Account ||--o{ Quote : "customer"
    Account ||--o{ SalesOrder : "customer"
    Account ||--o{ PurchaseOrder : "supplier"
    Account ||--o{ SupplierInvoice : "supplier"