dim_currency


Description

All available currencies

Columns

Column Type Size Nulls Auto Default Children Parents Comments
currency_id varchar 256 null
fct_contract_cancellation.currency_id erp_v2_fct_contract_cancellation_currency_id__erp_v2_dim_currency_currency_id_fkey_f92da2de7845 R
fct_idle_period.currency_id erp_v2_fct_idle_period_currency_id__erp_v2_dim_currency_currency_id_fkey_331a01d0c42d R
fct_invoice.currency_id erp_v2_fct_invoice_currency_id__erp_v2_dim_currency_currency_id_fkey_572bc6bb4efa R
fct_payment.currency_id erp_v2_fct_payment_currency_id__erp_v2_dim_currency_currency_id_fkey_a06f02bdffbe R
fct_payment_run.currency_id erp_v2_fct_payment_run_currency_id__erp_v2_dim_currency_currency_id_fkey_3e612dd303a5 R
fct_revenue.currency_id erp_v2_fct_revenue_currency_id__erp_v2_dim_currency_currency_id_fkey_61503c820a1c R
fct_revenue_cash_based.currency_id erp_v2_fct_revenue_cash_based_currency_id__erp_v2_dim_currency_currency_id_fkey_2b0e240e4321 R
fct_revenue_invoice_based.currency_id erp_v2_fct_revenue_invoice_based_currency_id__erp_v2_dim_currency_currency_id_fkey_946272c93489 R

Primary key of this table.
name varchar 256 √ null

Human readable name of the currency
code varchar 256 √ null

ISO 4217 currency code
numeric_code int8 19 √ null

ISO 4217 numeric code
last_updated timestamptz 35 √ null

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

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation