Land Acquisition & Land Development

Before there’s a Lot, there’s land. Two phases live in the database — Acquisition (buying the land) and Development (preparing it).

At a glance

Land Acquisition = pipeline / diligence tracking before we own the land. Lives in LandAcq* tables.
Land Development = costs of preparing the land (clearing, utilities, roads, amenities). Lives in LandDevInvoice (~17,400 rows).
Once dev is done, each Lot inherits land-derived columns: LotCost, LotPremium, LandDraw, DevelopedPadReady, AppraisedValue.
Two nightly jobs: LandDevBudgetNotifications_NEW (threshold emails) and LandDevDynamicsImports (push to BC).

1. Land Acquisition

Tracks deals to buy land. Mostly a pipeline / diligence tracker. Once a deal closes, the land becomes a Project and Lots are created.

LandAcq* tables

Tracks the costs of developing the land before homes are built — clearing, grading, utilities, roads, amenities.

LandDev tables and nightly jobs

LandDevInvoice (~17,400 rows) — invoices charged to the land budget.
SMART 2.0 (land-development/, accounting/) drives invoice approval and BC transmission for land-development costs.
Budget-threshold alert emails to land owners are sent by scheduled jobs on the SQL/job host (exact job names vary by environment).

Each Lot has cost balances inherited from land development.

The 5 land-derived columns on Lot

`Lot` column	What
`LotCost`	What the land cost us per lot
`LotPremium`	What we charge a buyer extra for a “premium” lot
`LandDraw`	Cash drawn from the construction loan against land
`DevelopedPadReady`	Date the lot pad is ready for vertical build
`AppraisedValue`	Bank’s appraisal value

SMART 2.0 → Land Acquisition — pipeline screens.
SMART 2.0 → Land Development — budget management, invoice approval.
SMART → Accounting — Lot Adjust / Proforma inserts.
The CSR support folder includes BackfillLotAdj.sql and LotAdjustProformaInserts for clean‑up.