fct_revenue


Description

The event of an accrued income (positive/negative) of contracts, sales and everything else. Nightly updated with entries of the past day. NOTE: multi-purpose vouchers (de: ‘Wertgutscheine’) are only considered once they are used or expired.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
revenue_id int8 19 null

Primary key for revenue
accounting_date_id int4 10 √ null
dim_date.date_id Implied Constraint R

Foreign key to accounting date
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id Implied Constraint R

Foreign key to organization unit
revenue_group_id int8 19 √ null
dim_revenue_group.revenue_group_id Implied Constraint R

Foreign key to revenue group
amount numeric 19,2 √ null

Revenue amount
net_amount numeric 19,2 √ null

Net revenue amount
currency_id varchar 256 √ null
dim_currency.currency_id Implied Constraint R

Foreign key to currency
contract_id int8 19 √ null
fct_contract.contract_id Implied Constraint R

The contract generating an income. Null if this revenue entry is not about a specific contract (eg a product was sold).
customer_id int8 19 √ null
dim_customer.customer_id Implied Constraint R

Foreign key to customer
rate_id int8 19 √ null
dim_rate.rate_id Implied Constraint R

The tariff of the contract generating an income. Null if this revenue entry is not about a specific contract (eg a product was sold).
product_id varchar 256 √ null
dim_product.product_id Implied Constraint R

Foreign key to product
service_period_start_date date 13 √ null

The start date of the service period associated with this revenue entry, such as the beginning of a billing cycle (eg. start of month) for a customers main contract. Or null if not associated with a service period (eg. sale of a product).
service_period_end_date date 13 √ null

The end date of the service period associated with this revenue entry, such as the beginning of a billing cycle (eg. end of month) for a customers main contract. Or null if not associated with a service period (eg. sale of a product).
description varchar 65535 √ null

Description of revenue
adjustment_type varchar 256 √ null
Adjustment type that changes value of price:
  • IDLE_PERIOD – Adjustment due to period when contract is inactive
  • CONTRACT_CANCELLATION– Adjustment due to cancelation of contract
  • CONTRACT_REVERSAL – Adjustment due to reversal of contract
  • CONTRACT_ADJUSTMENT – Adjustment due to adjustment to contract
  • CONTRACT_ADJUSTMENT_CANCELLATION – Overall reductions
  • CONTRACT_REST_MATURITY – Used for all locked charges when contract gets rest maturity
  • BOOKING_ENTRY_REVERSAL– Reversal of charge that is locked
  • BOOKING_ENTRY_REDUCTION – Reduction of the original charge
  • CUSTOM – Custom adjustment
  • CUSTOM_SINGLE_BOOKING_ENTRY – Discount for single booking entry
  • CONSUMPTION_CREDIT_CONVERSION – Adjustment due to normal credit conversion
  • CONSUMPTION_CREDIT_BONUS_CONVERSION –Adjustment due to bonus credit conversion
  • CHECKIN_DISCOUNT – Discount for reaching a certain hours of check-ins for the month
  • CHARGED_BACK – Return of payment
  • Null – No Adjustment
last_updated timestamptz 35 √ null

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

Relationships

Close relationships within degrees of separation