dim_payment_run_property

The primary key of this table.

The payment run provider, for example SEPA_XML

The status of the payment run to which this booking belongs, grouped into a small set of business-relevant states. One of:

• PREPROCESSING — Items are being collected and previewed; not yet confirmed by the operator.
• PENDING_VERIFICATION — Preview is ready for operator review.
• PROCESSING — Items are collected and the run is queued for submission.
• READY — Confirmed and ready to be submitted to the payment processor.
• SUBMITTING — Active submission to the payment provider is in progress.
• RETRYING — A recoverable error occurred; the system is retrying.
• WAITING_FOR_CONFIRMATION — Awaiting bank or provider confirmation.
• SUBMITTED — All items have been submitted to the payment provider.
• FINALIZING — Manual check before marking complete.
• COMPLETE — Final. Successfully finished.
• ERROR — Final. The run failed (covers both a provider-rejected run and an internal processing error).
• CANCEL_PROCESSING — Cancellation is in progress.
• CANCELLED — Final. Cancelled by the user.
• REVERT_CANCEL_PROCESSING — A previously cancelled run is being reopened.
• REVERT_FROM_SUBMITTED_PROCESSING — A previously submitted/completed run is being reopened.

The status of the individual booking itself, grouped into a small set of business-relevant states. One of:

• EXCLUDED — The booking was excluded from this run before collection was attempted (see reason).
• CREATED — Booking created; not yet submitted for processing.
• PROCESSING — Booking entries created and the item is queued or being processed.
• SUBMITTING — Handed off to the payment provider; submission in progress.
• SUBMITTED — Submitted to the payment provider; awaiting confirmation.
• RETRYING — A recoverable error occurred; the system is retrying.
• PRELIMINARY_COMPLETE — Processed successfully but may still change (e.g. pending chargeback window).
• COMPLETE — Final. Successfully collected.
• ERROR — Final. The booking failed (rejected by the payment provider or an internal error).
• CANCELLED — Final. Cancelled before completion.

The reason a booking did not result in a plain, successful collection. null for regular successfully-collected bookings. The set of possible values depends on what happened to the booking:

Booking was excluded from the run before collection was attempted (52 values reachable — see mapping note below)

12 reasons are specific to this scenario: UNKNOWN, BANK_ACCOUNT, SEPA_MANDATE, CREDIT_CARD, COLLECTION_STOP, INVALID_ADDRESS, MEMBER_CASH, MEANWHILE_BALANCED, CUSTOMER_INVALID_DATA, CUSTOMER_ARCHIVED, INTERNAL_ERROR, CREDIT_CARD_EXPIRED. The remaining 40 largely mirror the Finion Capital rejection reasons below (same underlying reason catalog), plus a few excluded-only additions: PURCHASE_LIMIT, IBAN_BLACKLISTED, INVALID_IBAN, CLOSED_BANKACCOUNT, FRAUD, INSOLVENCY, DECEASED, INCOMPLETE_ADDRESS, INVALID_OR_MISSING_INFORMATION, CHARGED_BACK, ALREADY_PURCHASED, ALREADY_CHARGED_BACK, CONTESTED_CONTRACT, WITHDRAWN_MANDATE, TERMINATED_CONTRACT, IBAN_NOT_SEPA_DIRECT_DEBIT_CAPABLE, AMOUNT_EXCEEDS_LIMIT, NON_CONTRACTUAL, PURCHASING_SUSPENDED, INSTRUCTED_BY_STUDIO, MISSING_LIABLE_PERSON, IBAN_INVALID_SINCE_LAST_PAYMENT_RUN, ACCOUNT_CLOSED_BEFORE_COLLECTION, DEBT_OVERAGED, DUNNING_UNSUCCESSFUL, AUTOMATIC_CHARGEBACK, STUDIO_CLOSED_DOWN, REPEATED_INVALID_SEPA_MANDATE, SETTLEMENT_AGRREMENT (sic — typo present in the source system, not a documentation error), INVALID_SEPA_CREDITOR_ID, BACS_PAYMENT_INSTRUMENT_MISSING, BACS_RECURRING_REFERENCE_MISSING, PAYMENT_INSTRUMENT_MISSING, PAYMENT_INSTRUMENT_NOT_CONFIRMED, PAYMENT_INSTRUMENT_INVALID, UNSUPPORTED_DEBT_CLAIM_TYPE, PURCHASESTOP_FRAUD, ALREADY_REJECTED, MANUALLY_REJECTED, OTHER.

A Finion Capital claim was rejected, or a prior Finion Capital collection was charged back (38 values reachable — see mapping note below)

Finion Capital (Sport Alliance’s receivables-financing product, branded to studios as MemberCash) collects membership fees via SEPA Direct Debit, pays studios the full amount on the collection day, absorbs the default risk, and handles all dunning/debt collection. This section covers the reasons it rejects a claim outright or reverses one it already collected on. * PURCHASE_LIMIT — Claim not purchased: purchase limit or purchase stop in effect. * INVALID_IBAN — Invalid IBAN. * CLOSED_BANKACCOUNT — Bank account closed. * FRAUD — Fraud attempt. * INSOLVENCY — Member is insolvent. * DECEASED — Member deceased. * INCOMPLETE_ADDRESS — Address is incomplete. * INVALID_ADDRESS — Address is invalid. * INVALID_OR_MISSING_INFORMATION — Missing or invalid info (e.g. IBAN, address). * CHARGED_BACK — Claim was already charged back. * ALREADY_PURCHASED — Claim was already purchased. * ALREADY_CHARGED_BACK — Claim was already charged back previously. * CONTESTED_CONTRACT — Contract is contested. * WITHDRAWN_MANDATE — Direct debit mandate withdrawn. * INVALID_SEPA_MANDATE — Invalid SEPA mandate. * IBAN_BLACKLISTED — IBAN is on a blacklist (e.g. known for fraud). * TERMINATED_CONTRACT — Studio contract terminated. * IBAN_NOT_SEPA_DIRECT_DEBIT_CAPABLE — Bank does not participate in the SEPA direct debit scheme. * AMOUNT_EXCEEDS_LIMIT — Amount exceeds an allowed limit. * NON_CONTRACTUAL — Claim is not tied to a contract. * PURCHASING_SUSPENDED — Purchasing temporarily suspended. * INSTRUCTED_BY_STUDIO — Chargeback instructed by the studio. * MISSING_LIABLE_PERSON — Missing legal guardian/representative. * IBAN_INVALID_SINCE_LAST_PAYMENT_RUN — IBAN became invalid since the last payment run. * ACCOUNT_CLOSED_BEFORE_COLLECTION — Bank account was closed before collection. * DEBT_OVERAGED — Claim is too old to collect (aged debt). * DUNNING_UNSUCCESSFUL — Dunning process was unsuccessful. * AUTOMATIC_CHARGEBACK — Immediate automatic chargeback; no further collection desired. * STUDIO_CLOSED_DOWN — Chargeback because the studio closed due to a regulatory order. * REPEATED_INVALID_SEPA_MANDATE — SEPA mandate repeatedly invalid. * SETTLEMENT_AGREEMENT — Client agreed to charge back every reversal of a direct debit from the run. * INVALID_SEPA_CREDITOR_ID — Invalid creditor ID on the SEPA mandate; claim can be resubmitted after the mandate is fixed. * UNSUPPORTED_DEBT_CLAIM_TYPE — Unsupported debt claim type. * PURCHASESTOP_FRAUD — Purchase stop due to suspected fraud. * ALREADY_REJECTED — Claim was already rejected. * MANUALLY_REJECTED — Manually rejected. * OTHER — Any other reason. * UNKNOWN — Unknown.

A direct debit or credit card payment was charged back (returned) by the bank or card scheme (9 values)

• INSUFFICIENT_COVERING — Insufficient funds to cover the charge.
• OPPOSITION — Customer actively disputed the charge with their bank.
• INVALID_BANK_INFORMATION — Bank account details were invalid or incorrect.
• INVALID_MANDATE — SEPA mandate was invalid, expired, or revoked.
• AUTHORIZATION_DECLINED — Authorization was declined by the issuing bank.
• INVALID_CARD — Credit card number was invalid.
• CARD_EXPIRED — Credit card had expired.
• REVOKED_BY_CUSTOMER — Customer revoked the authorization.
• OTHER — Catch-all for other return reasons.

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