View Extension
Back to Knowledge Base
Download PDF
Current page This article as PDF Complete manual All pages in this extension manual

Database Reference

B2B Quote stores quote workflow data in dedicated extension tables and extends selected Magento sales tables for quote-origin metadata.

Core Quote Tables

Table Purpose
b2b_quote Quote header, status, customer, store, totals, project, agreement reference
b2b_quote_item Quote item rows, quantities, prices, agreement item reference
b2b_quote_address Billing and shipping address data for quotes
b2b_quote_message Customer and admin quote conversation
b2b_quote_attachment Files attached to quote messages or quote records

Agreement Tables

Table Purpose
b2b_quote_agreement Purchasing agreement header
b2b_quote_agreement_item Agreement item quantity, consumed quantity, and agreed price

Organization Tables

Table Purpose
b2b_quote_project Customer projects used to group quotes
b2b_quote_category Admin-defined quote categories
b2b_quote_to_category Quote to category relation
b2b_quote_tag Admin-defined quote tags
b2b_quote_to_tag Quote to tag relation

Workflow Tables

Table Purpose
b2b_quote_status Configurable quote statuses
b2b_quote_status_transition Allowed status transitions
b2b_quote_pricing_rule Automated price rule definitions
b2b_quote_workflow_rule Event-driven workflow automation

Revision and Fee Tables

Table Purpose
b2b_quote_fee Additional quote fee definitions
b2b_quote_revision Quote revision history
b2b_quote_revision_item Item-level revision snapshots

Sales Table Extensions

The extension also adds quote-related metadata to Magento sales entities:

Entity Purpose
sales_order Stores quote-origin data for created orders
sales_order_grid Exposes quote-origin data in the order grid
sales_invoice Keeps invoice relation to quote-origin data
sales_creditmemo Keeps credit memo relation to quote-origin data

Common Relations

Important relations:

  • b2b_quote.customer_id links quotes to Magento customers
  • b2b_quote.project_id groups quotes into customer projects
  • b2b_quote.agreement_id links call-off quotes to agreements
  • b2b_quote_item.quote_id links items to quote headers
  • b2b_quote_item.agreement_item_id links call-off items to agreement items
  • b2b_quote_message.quote_id stores conversation per quote
  • b2b_quote_attachment.quote_id stores quote file attachments
Configuration Fields Common Issues