On this page
  1. Quote and sales context
  2. Communication and revision history
  3. Agreements and workflow
  4. Add-on records

Database Reference

B2B Quote keeps commercial discussions, revisions and agreements connected to standard Magento customers, products and orders. The tables below cover the relationships that matter for integrations and data ownership without reproducing the complete schema.

Quote and sales context

Relationship Why it matters
b2b_quote optionally belongs to one customer_entity Associates a quote with the customer who requested or receives it.
b2b_quote belongs to one store Preserves the Store View and commercial context in which the quote was created.
b2b_quote can create one sales_order Links an accepted quote to the resulting Magento order.
b2b_quote belongs to one b2b_quote_status Places the quote in the configured business workflow.
b2b_quote_item belongs to one b2b_quote Stores the commercial lines negotiated in the quote.
b2b_quote_item optionally refers to one catalog_product_entity Keeps a quote line connected to its Magento product when that product still exists.
b2b_quote_address belongs to one b2b_quote Stores the billing or shipping snapshot used for the quote.

Communication and revision history

Relationship Why it matters
b2b_quote_message belongs to one b2b_quote Keeps customer and administrator communication with the commercial record.
b2b_quote_message can identify one customer_entity or admin_user Records which side of the negotiation sent a message.
b2b_quote_attachment belongs to one b2b_quote and optionally one b2b_quote_message Keeps files attached to the correct discussion.
b2b_quote_revision belongs to one b2b_quote Preserves the negotiation history instead of overwriting earlier terms.
b2b_quote_revision can follow one earlier b2b_quote_revision Maintains the revision sequence.
b2b_quote_revision_item belongs to one b2b_quote_revision Captures the line state for a specific revision.

Agreements and workflow

Relationship Why it matters
b2b_quote_project belongs to one customer_entity Groups related quotes and agreements for the same customer project.
b2b_quote_agreement belongs to one customer_entity and optionally one b2b_quote_project Stores the negotiated agreement used for later call-offs.
b2b_quote_agreement_item belongs to one b2b_quote_agreement Defines the products and commercial terms covered by the agreement.
b2b_quote_status_transition connects two b2b_quote_status Defines which status changes are allowed in a Store View.
Quote category and tag assignments belong to one b2b_quote Support internal classification, filtering and reporting.

Add-on records

Relationship Why it matters
b2b_quote_signature_request belongs to one b2b_quote Keeps OpenSign requests and their progress with the quote being signed.
b2b_quote_pdf_layout belongs to one store Allows the PDF Designer layout to vary by Store View.

Use the module repositories, service contracts or Admin screens for changes. Direct database writes bypass quote validation, totals, workflow rules and revision handling.