Ordway · Schema
Subscription
A recurring billing subscription in Ordway
BillingRevenue AutomationSubscriptionsInvoicingPaymentsRevenue RecognitionSaaS MetricsUsage-Based BillingFinancial ReportingAccounts Receivable
Properties
| Name | Type | Description |
|---|---|---|
| company_id | string | Identifier for the Ordway company account |
| subscription_id | string | Unique identifier for the subscription |
| subscription_line_id | string | Unique identifier for the subscription line item |
| customer_id | string | ID of the customer this subscription belongs to |
| status | stringnull | Current subscription status |
| billing_start_date | stringnull | Date when billing begins |
| service_start_date | stringnull | Date when the service starts |
| contract_effective_date | stringnull | Date when the contract takes effect |
| cancellation_date | stringnull | Date when the subscription was or will be cancelled |
| auto_renew | booleannull | Whether the subscription auto-renews at end of term |
| currency | stringnull | Billing currency (ISO 4217) |
| payment_terms | stringnull | Payment terms for invoices generated by this subscription |
| cmrr | numbernull | Contracted Monthly Recurring Revenue for this subscription line |
| contract_term | stringnull | Contract term duration |
| renewal_term | stringnull | Renewal term duration |
| product_id | stringnull | ID of the product |
| product_name | stringnull | Name of the product |
| plan_name | stringnull | Name of the billing plan |
| charge_id | stringnull | ID of the charge |
| charge_name | stringnull | Name of the charge |
| pricing_model | stringnull | Pricing model for this charge |
| list_price | numbernull | List price before discounts |
| quantity | numbernull | Quantity for per-unit pricing |
| discount | numbernull | Discount percentage applied |
| effective_price | numbernull | Effective price after discounts |
| charge_type | stringnull | Type of charge |
| billing_period | stringnull | Billing frequency |
| current_period_start_date | stringnull | Start of current billing period |
| current_period_end_date | stringnull | End of current billing period |
| billing_schedule_id | stringnull | ID of associated billing schedule |
| revenue_schedule_id | stringnull | ID of associated revenue recognition schedule |
| prorate_partial_periods | booleannull | Whether to prorate charges for partial billing periods |
| exchange_rate | numbernull | Currency exchange rate applied |
| custom_fields | objectnull | User-defined custom fields |
| created_by | stringnull | User who created the record |
| updated_by | stringnull | User who last updated the record |
| created_date | stringnull | Timestamp when the record was created |
| updated_date | stringnull | Timestamp when the record was last updated |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://raw.githubusercontent.com/api-evangelist/ordway/main/json-schema/subscription.json",
"title": "Subscription",
"description": "A recurring billing subscription in Ordway",
"type": "object",
"required": ["company_id", "subscription_id", "subscription_line_id"],
"properties": {
"company_id": {
"type": "string",
"description": "Identifier for the Ordway company account"
},
"subscription_id": {
"type": "string",
"description": "Unique identifier for the subscription"
},
"subscription_line_id": {
"type": "string",
"description": "Unique identifier for the subscription line item"
},
"customer_id": {
"type": "string",
"description": "ID of the customer this subscription belongs to"
},
"status": {
"type": ["string", "null"],
"enum": ["active", "cancelled", "suspended", "pending", "expired", null],
"description": "Current subscription status"
},
"billing_start_date": {
"type": ["string", "null"],
"format": "date",
"description": "Date when billing begins"
},
"service_start_date": {
"type": ["string", "null"],
"format": "date",
"description": "Date when the service starts"
},
"contract_effective_date": {
"type": ["string", "null"],
"format": "date",
"description": "Date when the contract takes effect"
},
"cancellation_date": {
"type": ["string", "null"],
"format": "date",
"description": "Date when the subscription was or will be cancelled"
},
"auto_renew": {
"type": ["boolean", "null"],
"description": "Whether the subscription auto-renews at end of term"
},
"currency": {
"type": ["string", "null"],
"description": "Billing currency (ISO 4217)"
},
"payment_terms": {
"type": ["string", "null"],
"description": "Payment terms for invoices generated by this subscription"
},
"cmrr": {
"type": ["number", "null"],
"description": "Contracted Monthly Recurring Revenue for this subscription line"
},
"contract_term": {
"type": ["string", "null"],
"description": "Contract term duration"
},
"renewal_term": {
"type": ["string", "null"],
"description": "Renewal term duration"
},
"product_id": {
"type": ["string", "null"],
"description": "ID of the product"
},
"product_name": {
"type": ["string", "null"],
"description": "Name of the product"
},
"plan_name": {
"type": ["string", "null"],
"description": "Name of the billing plan"
},
"charge_id": {
"type": ["string", "null"],
"description": "ID of the charge"
},
"charge_name": {
"type": ["string", "null"],
"description": "Name of the charge"
},
"pricing_model": {
"type": ["string", "null"],
"enum": ["flat_fee", "per_unit", "tiered", "volume", "usage_based", null],
"description": "Pricing model for this charge"
},
"list_price": {
"type": ["number", "null"],
"description": "List price before discounts"
},
"quantity": {
"type": ["number", "null"],
"description": "Quantity for per-unit pricing"
},
"discount": {
"type": ["number", "null"],
"description": "Discount percentage applied"
},
"effective_price": {
"type": ["number", "null"],
"description": "Effective price after discounts"
},
"charge_type": {
"type": ["string", "null"],
"enum": ["recurring", "one_time", "usage", null],
"description": "Type of charge"
},
"billing_period": {
"type": ["string", "null"],
"enum": ["monthly", "quarterly", "semi_annual", "annual", "one_time", null],
"description": "Billing frequency"
},
"current_period_start_date": {
"type": ["string", "null"],
"format": "date",
"description": "Start of current billing period"
},
"current_period_end_date": {
"type": ["string", "null"],
"format": "date",
"description": "End of current billing period"
},
"billing_schedule_id": {
"type": ["string", "null"],
"description": "ID of associated billing schedule"
},
"revenue_schedule_id": {
"type": ["string", "null"],
"description": "ID of associated revenue recognition schedule"
},
"prorate_partial_periods": {
"type": ["boolean", "null"],
"description": "Whether to prorate charges for partial billing periods"
},
"exchange_rate": {
"type": ["number", "null"],
"description": "Currency exchange rate applied"
},
"custom_fields": {
"type": ["object", "null"],
"additionalProperties": true,
"description": "User-defined custom fields"
},
"created_by": {
"type": ["string", "null"],
"description": "User who created the record"
},
"updated_by": {
"type": ["string", "null"],
"description": "User who last updated the record"
},
"created_date": {
"type": ["string", "null"],
"format": "date-time",
"description": "Timestamp when the record was created"
},
"updated_date": {
"type": ["string", "null"],
"format": "date-time",
"description": "Timestamp when the record was last updated"
}
}
}