Demiton · Schema

profit_and_loss contract v3

Profit and loss for a period.

CompanyConstructionCivil EngineeringProject ManagementComplianceMCPArtificial IntelligenceOpen Contracting

Properties

Name Type Description
job_no string the Business Central job number the fact was read for; the join key between the fact and the project spine
summary string the one-line human-readable financial position, for citation/search
currency currency the currency the amounts are in, an ISO 4217 alpha-3 code as the source states it. A row with no currency has no usable amounts.
project_id string the project (BC job) the snapshot belongs to; the fact's subject anchor
actual_amount number actual cost to date (BC `Total_Cost`)
budget_amount number the project budget at the snapshot (BC `Total_Budget`)
variance_amount number `budget_amount - (actual_amount + commitments_amount)`
financial_period string the accounting period the snapshot covers
gross_margin_pct number `gross_margin_amount / revenue * 100`
commitments_amount number open purchase-commitment value (BC `Total_Commitments`)
gross_margin_amount number revenue less actual cost (`Total_Revenue(abs) - Total_Cost`)
contract_value_amount number the contracted value of the job (BC `Total_Contract_Value`)
claimed_to_date_amount number value invoiced to date (BC `Total_Invoiced`)
View JSON Schema on GitHub

JSON Schema

demiton-io-profit_and_loss-v3-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://docs.demiton.io/registers/profit_and_loss/v3.json",
  "title": "profit_and_loss contract v3",
  "type": "object",
  "required": [
    "actual_amount",
    "budget_amount",
    "financial_period",
    "project_id"
  ],
  "properties": {
    "job_no": {
      "type": "string",
      "description": "the Business Central job number the fact was read for; the join key between the fact and the project spine",
      "x-demiton-requiredness": "optional"
    },
    "summary": {
      "type": "string",
      "description": "the one-line human-readable financial position, for citation/search",
      "x-demiton-requiredness": "optional"
    },
    "currency": {
      "type": "currency",
      "description": "the currency the amounts are in, an ISO 4217 alpha-3 code as the source states it. A row with no currency has no usable amounts.",
      "x-demiton-requiredness": "optional"
    },
    "project_id": {
      "type": "string",
      "description": "the project (BC job) the snapshot belongs to; the fact's subject anchor",
      "x-demiton-requiredness": "required",
      "x-demiton-reference": true
    },
    "actual_amount": {
      "type": "number",
      "description": "actual cost to date (BC `Total_Cost`)",
      "x-demiton-requiredness": "required",
      "x-demiton-type": "decimal"
    },
    "budget_amount": {
      "type": "number",
      "description": "the project budget at the snapshot (BC `Total_Budget`)",
      "x-demiton-requiredness": "required",
      "x-demiton-type": "decimal"
    },
    "variance_amount": {
      "type": "number",
      "description": "`budget_amount - (actual_amount + commitments_amount)`",
      "x-demiton-requiredness": "optional",
      "x-demiton-type": "decimal"
    },
    "financial_period": {
      "type": "string",
      "description": "the accounting period the snapshot covers",
      "x-demiton-requiredness": "required"
    },
    "gross_margin_pct": {
      "type": "number",
      "description": "`gross_margin_amount / revenue * 100`",
      "x-demiton-requiredness": "optional",
      "x-demiton-unit": "percent (%)",
      "x-demiton-type": "decimal"
    },
    "commitments_amount": {
      "type": "number",
      "description": "open purchase-commitment value (BC `Total_Commitments`)",
      "x-demiton-requiredness": "optional",
      "x-demiton-type": "decimal"
    },
    "gross_margin_amount": {
      "type": "number",
      "description": "revenue less actual cost (`Total_Revenue(abs) - Total_Cost`)",
      "x-demiton-requiredness": "optional",
      "x-demiton-type": "decimal"
    },
    "contract_value_amount": {
      "type": "number",
      "description": "the contracted value of the job (BC `Total_Contract_Value`)",
      "x-demiton-requiredness": "optional",
      "x-demiton-type": "decimal"
    },
    "claimed_to_date_amount": {
      "type": "number",
      "description": "value invoiced to date (BC `Total_Invoiced`)",
      "x-demiton-requiredness": "optional",
      "x-demiton-type": "decimal"
    }
  },
  "x-demiton-register-type": "profit_and_loss",
  "x-demiton-contract-version": "3.0.1",
  "x-demiton-store": "tenant",
  "x-demiton-axes": [
    {
      "axis": "currency",
      "requirement": "optional",
      "role": "context"
    },
    {
      "axis": "financial_period",
      "requirement": "optional",
      "role": "context"
    },
    {
      "axis": "legal_entity",
      "requirement": "optional",
      "role": "context"
    }
  ],
  "x-demiton-measures": [],
  "x-demiton-provenance": {
    "standards": [
      {
        "code": "AS 4000:2025",
        "title": "AS 4000:2025 General Conditions of Contract",
        "access": "paywalled_secondary",
        "clause": "cl 37.2 (per commentary)",
        "region": "Australia",
        "edition": "2025",
        "checked_on": "2026-09-14"
      },
      {
        "code": "GST Act 1999 (Cth)",
        "title": "A New Tax System (Goods and Services Tax) Act 1999 (Cth)",
        "access": "public_summary",
        "clause": "s 29-70 (tax invoices); ATO tax invoice guidance",
        "region": "Australia",
        "edition": "current (ATO guidance updated 25 Aug 2025)",
        "checked_on": "2026-09-14"
      },
      {
        "code": "SA SOP Act 2009",
        "title": "Building and Construction Industry Security of Payment Act 2009 (SA)",
        "access": "public_summary",
        "clause": "claimed amount states GST treatment",
        "region": "Australia",
        "edition": "current",
        "checked_on": "2026-09-14"
      },
      {
        "code": "Tas SOP Act 2009",
        "title": "Building and Construction Industry Security of Payment Act 2009 (Tas)",
        "access": "full_text_verified",
        "clause": "ss 17-19",
        "region": "Australia",
        "edition": "in force 2025-10-11",
        "checked_on": "2026-09-14"
      },
      {
        "code": "WA SOP Act 2021",
        "title": "Building and Construction Industry (Security of Payment) Act 2021 (WA)",
        "access": "full_text_verified",
        "clause": "ss 24-25",
        "region": "Australia",
        "edition": "current",
        "checked_on": "2026-09-14"
      },
      {
        "code": "Construction Contracts Act 2002 (NZ)",
        "title": "Construction Contracts Act 2002 (NZ), 2002 No 46",
        "access": "full_text_verified",
        "clause": "ss 20, 21, 18J-18K",
        "region": "New Zealand",
        "edition": "as at 5 Oct 2023 (incl. Retention Money Amendment Act 2023)",
        "checked_on": "2026-09-14"
      },
      {
        "code": "HGCRA 1996 Part II",
        "title": "Housing Grants, Construction and Regeneration Act 1996 (UK), Part II",
        "access": "full_text_verified",
        "clause": "ss 110, 110A, 111, 113",
        "region": "United Kingdom",
        "edition": "current",
        "checked_on": "2026-09-14"
      },
      {
        "code": "AIA G702/G703",
        "title": "AIA G702-1992 / G703-1992",
        "access": "public_summary",
        "region": "United States",
        "edition": "1992 base editions",
        "checked_on": "2026-09-14"
      }
    ]
  },
  "description": "Profit and loss for a period.",
  "x-demiton-contract-url": "https://docs.demiton.io/registers/profit_and_loss/",
  "x-demiton-register-catalog": "https://docs.demiton.io/concepts/register-catalog"
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/demiton-io-profit_and_loss-v3"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.