Subscriptions
Subscriptions & Recurring Payments protects MRR: recovering failed charges, managing the card lifecycle, and predicting churn before it happens. This page lists the 42 data points Athia uses for this use case, with their definitions, sources, availability and data class.
Field names below are the payments-standard names for each data point, so use this page to line your own schema up against them.
The field names on this page are payments-standard names — they describe each data point at the level of the standard it comes from. Athia Data Dictionary carries the names Athia uses and a crosswalk between the two. You do not have to match either exactly — the mapping from your own columns is agreed with your Athia team on ingest. One delivered field often covers several data points here, decline codes especially.
Sub-use cases
- Involuntary churn / dunning — failed recurring charges, retry sequencing and decline reasons that put an active subscription at risk.
- Failed-payment recovery channels — which retry, dunning stage or fallback method actually recovered the invoice, and how much was recovered when.
- Card lifecycle management — stored card expiry, network tokens, Account Updater events and fallback payment methods ahead of the next billing date.
- MIT/CIT tagging — correct merchant- vs customer-initiated marking, credential-on-file flags, scheme transaction IDs and consent evidence.
- SCA/3DS for recurring — the stored-credential attributes that determine exemption and authentication handling on recurring charges.
- MRR/ARR/LTV cohorts — recurring revenue movements, plan and quantity changes, discounts, tax, proration and FX for cohort reporting.
- Pricing & plan experiments — plan, plan-change and discount data behind upgrade, downgrade and pricing tests.
- Lifecycle flows — subscription status and plan transitions across the customer lifecycle.
- Trial→paid conversion — trial start and end dates and the status they convert into.
- Voluntary churn prediction — customer-level signals for customers who choose to cancel.
- Cross-border recurring — billing currency and FX conversion to the base currency.
- Recurring chargebacks — the card and consent evidence needed to defend disputes on recurring charges.
Data points
All 42 fields, grouped by category.
Subscription core
| Field | Category | Definition | Type | Example | Source | Availability | Data class |
|---|---|---|---|---|---|---|---|
subscription_id | Subscription core | Unique identifier of the subscription. | uuid | sub_8a2… | Merchant / ERP integration | Full | None |
customer_id | Subscription core | Identifier of the subscribing customer. | uuid | cus_4f0… | Merchant / ERP integration | Full | PII |
plan_id | Subscription core | Identifier of the priced plan/tier. | string | plan_pro_monthly | Merchant / ERP integration | Full | None |
status | Subscription core | Subscription lifecycle state. | enum | past_due | Merchant / ERP integration | Full | None |
billing_period_start | Subscription core | Start of the current billing period. | date | 2026-05-01 | Merchant / ERP integration | Full | None |
billing_period_end | Subscription core | End of the current billing period. | date | 2026-05-31 | Merchant / ERP integration | Full | None |
next_billing_date | Subscription core | Date the next charge is scheduled. | date | 2026-06-01 | Merchant / ERP integration | Full | None |
trial_start_date | Subscription core | Trial start date. | date | 2026-05-01 | Merchant / ERP integration | Full | None |
trial_end_date | Subscription core | Trial end / conversion date. | date | 2026-05-15 | Merchant / ERP integration | Full | None |
currency | Subscription core | Billing currency. | code | EUR | Merchant / ERP integration | Full | None |
Billing events
| Field | Category | Definition | Type | Example | Source | Availability | Data class |
|---|---|---|---|---|---|---|---|
invoice_id | Billing events | Identifier of the invoice being charged. | uuid | inv_91c… | Merchant / ERP integration | Full | None |
attempt_id | Billing events | Identifier of an individual charge attempt. | uuid | att_22b… | Merchant / ERP integration | Full | None |
retry_attempt_number | Billing events | Sequence number of the dunning retry. | integer | 3 | Merchant / ERP integration | Partial | None |
decline_code_raw | Billing events | Raw processor/issuer decline code. | code | do_not_honor | PSP / processor report | Full | None |
decline_code_canonical | Billing events | Normalized canonical decline reason. | enum | insufficient_funds | Athia derived | Full | None |
dunning_stage | Billing events | Current stage in the dunning sequence. | enum | retry_2_email | Merchant / ERP integration | Partial | None |
recovery_outcome | Billing events | Outcome of the recovery attempt. | enum | recovered | Athia derived | Partial | None |
amount_recovered | Billing events | Amount successfully recovered. | money | 1999 EUR | Merchant / ERP integration | Full | None |
recovery_timestamp | Billing events | When recovery succeeded. | timestamp | 2026-05-20T09:00Z | Merchant / ERP integration | Full | None |
Stored credential
| Field | Category | Definition | Type | Example | Source | Availability | Data class |
|---|---|---|---|---|---|---|---|
mit_indicator | Stored credential | Merchant-Initiated Transaction marker. | boolean | true | PSP / processor report | Partial | None |
cit_indicator | Stored credential | Customer-Initiated Transaction marker. | boolean | false | PSP / processor report | Partial | None |
mit_type | Stored credential | MIT sub-type (recurring, installment, unscheduled). | enum | recurring | PSP / processor report | Partial | None |
cof_indicator | Stored credential | Credential-on-file flag (initial vs subsequent). | enum | subsequent | PSP / processor report | Partial | None |
scheme_transaction_id | Stored credential | Visa TID / Mastercard Trace ID linking the credential chain. | string | MCC1234567890 | PSP / processor report | Limited | None |
original_credential_capture_date | Stored credential | When the credential was first stored with consent. | date | 2025-11-02 | Merchant / ERP integration | Limited | None |
consent_proof_id | Stored credential | Reference to stored consent evidence. | uuid | cns_77a… | Merchant / ERP integration | Limited | Sensitive |
Card lifecycle
| Field | Category | Definition | Type | Example | Source | Availability | Data class |
|---|---|---|---|---|---|---|---|
pan_last4 | Card lifecycle | Last four digits of the card. | string | 4242 | PSP / processor report | Full | PCI |
BIN | Card lifecycle | Bank Identification Number of the stored card. | string | 424242 | PSP / processor report | Full | PCI |
card_expiry | Card lifecycle | Stored card expiry (MM/YY). | string | 08/27 | PSP / processor report | Partial | PCI |
network_token_id | Card lifecycle | Network token for the stored credential. | string | tkn_5dF… | PSP / processor report | Limited | PCI |
network_token_status | Card lifecycle | Lifecycle status of the network token. | enum | active | PSP / processor report | Limited | None |
account_updater_event | Card lifecycle | Account Updater event (new PAN/expiry/closed). | enum | new_pan | Acquirer / network file | Limited | PCI |
au_event_date | Card lifecycle | Date of the Account Updater event. | date | 2026-05-10 | Acquirer / network file | Limited | None |
fallback_payment_method_id | Card lifecycle | Alternate PM to use on failure. | uuid | pm_back_3 | Merchant / ERP integration | Partial | PCI |
MRR movements
| Field | Category | Definition | Type | Example | Source | Availability | Data class |
|---|---|---|---|---|---|---|---|
mrr_movement_type | MRR movements | Type of MRR change. | enum | expansion | Athia derived | Full | None |
mrr_delta | MRR movements | Signed change in MRR for the event. | money | +1000 EUR | Athia derived | Full | None |
plan_change_event | MRR movements | Plan transition (upgrade/downgrade/etc.). | enum | upgrade | Merchant / ERP integration | Full | None |
quantity | MRR movements | Seat/unit count on the subscription. | integer | 25 | Merchant / ERP integration | Full | None |
discount_amount | MRR movements | Applied discount on the period. | money | 200 EUR | Merchant / ERP integration | Full | None |
tax_amount | MRR movements | Tax charged on the invoice. | money | 380 EUR | Merchant / ERP integration | Full | None |
proration_amount | MRR movements | Proration adjustment for mid-period changes. | money | -150 EUR | Merchant / ERP integration | Full | None |
fx_rate_to_base | MRR movements | FX rate converting billing currency to base. | decimal | 1.0850 | Third-party enrichment | Full | None |
Availability
Availability describes how reliably Athia can obtain a field in practice, not how important it is. Fields marked Partial or Limited are still worth mapping — they simply need the right source or setup to arrive consistently.
| Value | What it means |
|---|---|
| Full | Athia gets this reliably from standard sources. |
| Partial | Available from some providers, or some of the time. |
| Limited | Available only in specific setups or on request. |
| Not available | Athia cannot obtain this today. |
Field-level definitions for the core entities are in Athia Data Dictionary.
Updated 1 day ago
Did this page help you?