Skip to content

Commissions

Sales people are paid out of the closing money. SMART tracks commissions in a small constellation of tables built around Commission.

At a glance

  • Two flavors: Internal (our own sales agents — IntComAmt/IntComPct on Contract) and External (the buyer’s outside agent or broker — ExtComAmt/ExtComPct).
  • Commissions are computed and posted at closing (spProcessContractClose), not at ratify.
  • Splits between original and ratified agents are tracked in CommissionSalesAgent; bonuses live in CommissionIncentive.
  • A cancellation may or may not count against the rep’s bonus pool — depends on RescissionReason.CountCancellation.
  • Internal commission — what we pay our own sales agents (IntComAmt, IntComPct on Contract). May involve splits between original and ratified agent.
  • External commission — what we pay the buyer’s outside agent / broker (ExtComAmt, ExtComPct).

The commission subsystem is Commission plus a few helpers for splits, incentives, and audit history.

Full commission table reference
TablePurpose
CommissionHeader for commission paid on a contract.
CommissionIncentive / vwCommissionIncentiveBonuses, builder bonuses, contests.
CommissionSalesAgent / vwCommissionSalesAgentSplits between agents on a contract.
CommissionTransLog / vwCommissionTransLogAudit log of every commission edit.

Helper utilities (SOURCECODE/CSR/):

  • Commission.sql, BuilderBonus.sql, BuyerAgentRanks.sql, UpdateCommissionContract.sql, UpdateCommissionsProjectAndContract.sql.
  • SMART → Sales → Commission Management for sales managers.
  • Trade Portal: not visible.
  • Home Owner Portal: not visible.
  • SMART 2.0 → web-reports/ for monthly close reports.