Rev Starting Balance

Facts

Definitions

Column	Description
date	Date in YYYY-MM-DD format, reference to Dates.
value_type_id	Type of value measured (links to Value Types, e.g., actuals, budget).
nr_of_customers	Volume variable with number of customers contributing to this revenue change.
mrr_per_customer	Pricing variable, monthly recurring revenue.
total_mrr	Total Monthly Recurring Revenue as defined as volume (nr_of_customers) x price (value_per_customer)

Sample & Implementation

Revenue Starting Balance
date	value_type_id	nr_of_customers	mrr_per_customer	total_mrr
2024-12-31	2	3000	5000.00

CREATE TABLE IF NOT EXISTS revenue_starting_balance (
    date DATE NOT NULL,
    value_type_id INTEGER NOT NULL,
    nr_of_customers INTEGER NOT NULL,
    mrr_per_customer DOUBLE NOT NULL,
    total_mrr DOUBLE,
    FOREIGN KEY (date) REFERENCES dates(date),
    FOREIGN KEY (value_type_id) REFERENCES value_types(id),
    PRIMARY KEY (date, value_type_id)
)

Data Format

Field

Type

The primary key is formed by constrainst on dates, revenue types, and value types:
PRIMARY KEY (date, value_type_id)

Dependencies

Dates
Value Types

Rev Starting Balance

Facts

Definitions

Sample & Implementation

Data Format

Dependencies

On this page