fct_payment_run


Columns

Column Type Size Nulls Auto Default Children Parents Comments
payment_run_id varchar 256 √ null
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id Implied Constraint R
effective_collection_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
number varchar 256 √ null
payment_run_property_id varchar 256 √ null
dim_payment_run_property.payment_run_property_id Implied Constraint R
booking_type varchar 256 √ null
booking_number varchar 256 √ null
customer_id int8 19 √ null
dim_customer.customer_id Implied Constraint R
amount numeric 19,2 √ null
currency_id varchar 256 √ null
dim_currency.currency_id Implied Constraint R
archived bool 1 √ null
last_updated timestamptz 35 √ null

Relationships

Close relationships within degrees of separation