🧭✨Future Charge Pricing Breakdown Specifications (NEW)

✨ NEW TABLE - November 2025

🛠️ Partner API Alignment Migration

🧭 This table represents the post-migration state for charge_pricing_breakdow_specifications.

1️⃣ Migrate to this table by April 2026

2️⃣ Between April 2026 and July 2026, remove FUTURE__ prefix

Contains pricing breakdown specifications for partner charges. A charge pricing breakdown specification is included if the charge_pricing_breakdown_id refers to one of your charge pricing breakdowns

SQL: FUTURE__charge_pricing_breakdown_specificationss

Schema

Column Name	Data Type	Description
Primary ID
id	INTEGER	Primary key
Other IDs
charge_pricing_breakdown_id	INTEGER	References the parent charge pricing breakdown record this specification belongs to
currency_id	INTEGER	Identifier for the currency used in the pricing specification
Timestamps
created_at	TIMESTAMP_NTZ	Timestamp when the specification record was first created
updated_at	TIMESTAMP_NTZ	Timestamp when the specification record was last modified
Attributes
type	VARCHAR	Categorizes the type of pricing specification (e.g., base rate, time-based charge, energy charge)
precision	INTEGER	Defines the number of decimal places used for price calculations and display. Controls rounding behavior for pricing values.
price	NUMBER	Monetary value associated with this pricing specification component. Represents the actual charge amount in the specified currency.

Changes from Last Version

No changes to schema or data types; existing fields remain unchanged.
This table is downstream of FUTURE__charge_pricing_breakdowns which is downstream of models with relaxed inclusion criteria.

Data inclusion criteria

This table works with FUTURE__charge_pricing_breakdowns table, requiring that charge_pricing_breakdown_id is among in that table

Data flow

Upstream tables	Upstream tables
`FUTURE__charge_pricing_breakdowns`	none

Alignment

The `charge_pricing_breakdown_specifications` table

this table (just like the one it replaces) depends in charge_pricing_breakdowns which depends on charges which further depends on charge_points and teams.
FUTURE__charge_points, FUTURE__teams and FUTURE__charges all have relaxed inclusion criteria.
one aligns this table by alinigning FUTURE__charges first, and then recreating inclusion criteria for FUTURE__charge_pricing_breakdowns and then for this table.