Revenue Types

Semantic Contract

Definitions

Column	Description
id	Unique identifier.
name	Revenue type name. Allowed values are New Booking, Upsell, Downsell, and Churn.

Revenue Type	Description
New Booking	Revenue from a brand-new customer.
Upsell	Revenue increase from an existing customer.
Downsell	Revenue decrease from an existing customer.
Churn	Revenue lost due to customers leaving or canceling contracts.

Sample & Implementation

A list of Revenue Types
id	name
1	new_booking
2	upsell
3	downsell
4	churn

CREATE TABLE IF NOT EXISTS revenue_types (
    id INTEGER PRIMARY KEY,
    name VARCHAR NOT NULL UNIQUE CHECK (name IN ('new_booking', 'upsell', 'downsell', 'churn'))
)

Data Format

Field

Type

Dependencies

None.

Semantic Contract

Definitions

Sample & Implementation

Data Format

Dependencies

On this page