Key tables & views

The database has 603 dbo tables on Test (2026-06-02 snapshot); this page lists the ~80 you’ll actually use day-to-day.

Organization

Table	Purpose
Company	Legal entity / QB-BC company.
Division	Operating region.
Area	Market area inside a division.
Community	Neighborhood.
Project	Book of construction inside a community.
Building, vwLookupBuilding	Physical structure on a lot.
Lot	A buildable home (Project + Building + Unit).
LotStatus	Lookup of lot statuses (s, f, p, c, …).
Employee, vwEmployee	Internal users.

CRM

Table	Purpose
Contact	Master CRM record.
vwContacts	Flat reporting view.
ContactPhone, ContactEmail, ContactAddress	Methods.
ContactRank	Sales pipeline ranking.
ContactTraffic	Each visit / interaction.
TrafficSource	”How did you hear about us?”
ContactProductFeature, vwContactHasProductFeature	What features they want.
Journal, vwJournal*	Notes attached to a contact.
BPMActionItem, BPMActionItemOrder	Action items.
vwContactRequiredFields	Validation gate before contracting.

Sales

Table	Purpose
Contract	The sales contract.
ContractStatus	Status lookup.
ContractCoBuyer	Additional buyers.
ContractContingency	Open conditions.
ContractDeposit	Earnest money + progress deposits.
ContractDocument + vwContractDocument*	Document packets.
ContractLog	Audit.
ContractFinancialCalculation	Pre-computed totals.
ContractPriceAdj	Discounts/incentives.
vwContractManagement	Sales-management dashboard view.
Commission, CommissionIncentive, CommissionSalesAgent, CommissionTransLog	Sales-rep payment.
LoanPackage, LoanWorksheet, LoanPkgProjLimit	Financing.

Selections / Plans

Table	Purpose
Plans	Sellable plans.
PlansBath, PlansBed, PlansMasonryData	Plan attributes.
PlanStyle, PlanType, PlanCategory	Marketing classification.
PlansCADVersion	CAD revision.
Selection	Buyer-facing selection categories.
Option	Specific option offerings.
ChosenOption	What the buyer picked on a contract.
vwChosenOption*	Reporting flavors.

Build / production

Table	Purpose
Activity, ActivityType, ActivityFriendlyName	Schedule activities.
LotSelectionActivity, EstimateActivity, EstimateCriticalActivity	The lot’s actual schedule and estimate.
StdPlanActivity, StdPlanCriticalActivity	Std-plan templates.
StdBookActivity, StdBookOptions, StdBookResource, StdBookPlanOption	Cost-book templates.
Resource	Material / labor SKUs.
CostBook, PriceBook	Pricing tables.
DelayBatch, DelayBatchSeq, DelayType, AreaDelayMessage	Delay management.

Vendors / POs

Table	Purpose
Vendor, vwLookupVendor*	Master vendor list.
VendorBid, VendorBidResource	Active vendor pricing.
VendorBidChangeRequest, VendorBidChangeRequestStatus	Mid-contract pricing changes.
PurchaseOrder	The PO master (~2.43M rows on Test).
UnpaidPurchaseOrder	Snapshot of open POs.
BuilderPortalWorkOrderApprovalLog	Builder Portal work-approval audit (~1.77M rows on Test).
Variance, VarianceDetail, VarianceEntry, VarianceEntryResource	PO variances.
ChangeOrder, vwChangeOrder	Buyer-driven change orders.
VendorActivityLienWaverReq, VendorActivityLienWaverTrans	Lien-waiver workflow.

Service / warranty

Table	Purpose
ServiceRequest	Header.
ServiceRequestLine	One issue.
ServiceRequestLineNote	Comments.
ServiceRequestFile	Attached photos.
ServiceRequestLineStatus	Status lookup.
RequestType	Warranty category.
RequestSource	How it came in.
ServiceOrder	A dispatched, paid order.
ServiceOrderServiceRequestLine	Many-to-one bridge.
vwServiceOrder*, vwServiceRequest*, vwLotServiceRequests	Dashboards.

Transmissions (outbound to BC)

Table	Purpose
TransmissionMaster	Queue header (Status, TransType, Mode, errors).
TransmissionMasterErrorLog, TransmissionError, TransmissionMasterErrorCheck	Operator / retry diagnostics.
TransmissionStatus, TransmissionType	Lookups for status codes and message kinds.
TransmissionPaymentStatus	Payment status rows pulled from BC (TransType = pays).
Child Transmission* tables	Payload per message type — 14 tables in use by the BC worker; see Transmissions.

BC ledger (inbound from BC): BCJobLedger, BCGeneralLedger, BCProjects.

Land

Table	Purpose
LandAcq*	Land acquisition pipeline.
LandDevInvoice	Land-development invoices.

Audit / system

Table	Purpose
ContactTransLog, ContractLog, ServiceRequestTransLog, CommissionTransLog, vwLimitPlanChangeLog	Audit logs.
TransmissionMasterErrorLog, TransmissionError	Outbound error queues.
vwLookupHoliday	Calendar of holidays for schedule math.