dim_revenue_group


Description

A hierarchical categorization of revenues into a broad main_group and a finer grained sub_group.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
revenue_group_id int8 19 null
fct_revenue.revenue_group_id fct_revenue_revenue_group_id_fkey R
fct_revenue_cash_based.revenue_group_id fct_revenue_cash_based_revenue_group_id_fkey R

The primary key of this table.
main_group varchar 256 null

Categorizing income into 3 broad types

  • CHARGES_SALES: positive income of any contracts or services
  • DEDUCTION: mostly negative income reducing amounts made from CHARGES_SALES
  • FEES: mostly positive income made from penalties

Additionally UNCATEGORIZED might temporarily appear, while new transaction types are being mapped.
sub_group varchar 256 null

Categorizing the main_group in finer details

CHARGES_SALES
  • ADDITIONAL_CHARGE: Additional income related to contracts
  • ADDITIONAL_MODULE: Income of customers booking more modules to their main contract
  • DEPOSIT: Income of deposits (eg bottles)
  • FLAT_FEE: Income of fees, customers have to pay additionally to their main contract
  • MEMBERSHIP_FEE: Income of main contracts
  • REST_PERIOD_CONTRIBUTION: Income of charges made of customers putting their contract into an inactive “idle period”
  • SALE_OF_GOODS_AND_SERVICES: Income of selling a product (see product_name) or service (eg Shower 1x) with no product explicitely set up
  • STARTER_PACKAGE: Income of the initial/setup fee of a contract
DEDUCTION
  • CREDIT: Amount granted to someone, most often because of an illness
  • DEBT_CLAIM_REDUCTION: Amount discounting previous charges
  • DEBT_CLAIM_REVERSAL: Amount cancelling previous charges
  • DERECOGNITION: Loss of previous charges. Eg a customer did not pay and the charge is no longer followed up on.
  • REFUND_OF_DEPOSIT: Loss of a deposit (eg bottles) being returned
  • VOUCHER_EXPIRATION: Income of a multi-purpose voucher being expired.
FEES
  • BANKING_FEE: Income/Cost of fees related to payments
  • DUNNING_PENALTY_FEE: Income of charges made to a customers not paying on time
  • OTHER_FEE: Income of charges like address-requests or compensations in case of damages
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags behind source system).

Relationships

Close relationships within degrees of separation