Payments staging

Stripe — data contract (cleaned Stripe charge row between stages; not affiliated with Stripe)

Name: Stripe data contract
Creator: DataContractGate
License: https://opensource.org/licenses/MIT

Cleaned Stripe charge row after the raw ingest transform. Between-stages gate. Derived from stripe_charges_raw. Not affiliated with Stripe.

This contract is one boundary in the Stripe charges pipeline chain. Validate the payload at that boundary, then follow the neighbors.

Download YAML

Also available: ODCS v3.1.0 YAML. “Use this contract” forks it into your org, then opens the validation playground so you can upload the client file.

Contract family

Stripe charges pipeline

Stripe charges as they move from raw ingest, through a cleaned stage and a daily revenue mart, to a partner payout feed. Not affiliated with Stripe. Sample ids are fake.

1stripe_charges_raw
Ingest
2stripe_charges_stagedThis contract
Derived from stripe_charges_raw
Between stages
3revenue_daily_mart
Derived from stripe_charges_staged
Between stages
4partner_payout_feed
Derived from revenue_daily_mart
Egress

Fields

Name	Type	Required	Rule	Description
charge_id	string	required	pattern /^(ch\|py)_[A-Za-z0-9]+$/	—
customer_id	string	required	pattern /^cus_[A-Za-z0-9]+$/	Flattened Stripe customer id from the raw customer field.
amount	number	required	≥ 0	Charge amount in major currency units (e.g. 42.99 USD), not cents.
currency	string	required	pattern /^[A-Z]{3}$/	Normalized three-letter ISO 4217 currency code, uppercase.
status	string	required	one of: succeeded, pending, failed	—
paid	boolean	required	—	—
refunded	boolean	required	—	—
charged_at	string	required	pattern /^[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}Z$/	Charge creation time as UTC ISO-8601 with trailing Z.
description	string	optional	—	—
payment_intent_id	string	optional	pattern /^pi_[A-Za-z0-9]+$/	—

Sample rows

One synthetic row we wrote. It validates against this contract with zero violations. No real customer data.

[
  {
    "amount": 42.99,
    "charge_id": "ch_3Qdemo0001AaBbCcDd",
    "charged_at": "2025-01-01T00:00:00Z",
    "currency": "USD",
    "customer_id": "cus_DemoAcme0001",
    "description": "Demo invoice INV-DEMO-1001",
    "paid": true,
    "payment_intent_id": "pi_3Qdemo0001AaBbCc",
    "refunded": false,
    "status": "succeeded"
  }
]

Provenance

Verified against: —
Checked: —
Version: v1.0
Author: DataContractGate
License: MIT

Spotted a mismatch with the vendor’s current schema? Report an issue.

Stripe, Shopify, QuickBooks, Xero, HubSpot, Salesforce, Google Analytics and Square are trademarks of their respective owners. DataContractGate is not affiliated with or endorsed by them. These contracts describe data shaped like these vendors’ documented schemas; they are not official and are not certified by any vendor.