dim_payment_run_property


Description

A set of basic payment run booking properties

Columns

Column Type Size Nulls Auto Default Children Parents Comments
payment_run_property_id int8 19 null
fct_payment_run.payment_run_property_id fct_payment_run_payment_run_property_id_fkey R

The primary key of this table.
provider varchar 256 null

The payment run provider, for example SEPA_XML
status varchar 256 null

The status of the payment run to which a booking belongs
booking_status varchar 256 √ null

The status of the individual booking itself
reason varchar 256 √ null

The reason why a payment run booking is excluded or failed
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