SubscriptionDetails
Returns details of a subscription.
Columns
| Name | Type | References | |
| OrganizationId | Long |
Organizations.OrganizationId | |
| SubscriptionId [KEY] | Long |
Subscriptions.SubscriptionId | |
| SubscriptionNumber | String | ||
| Status | String | ||
| ActivatedAt | Date | ||
| Addons | String | ||
| AllowPartialPayments | Boolean | ||
| Amount | Double | ||
| AutoApplyCredits | String | ||
| AutoCollect | Boolean | ||
| BillingMode | String | ||
| CanAddBankAccount | Boolean | ||
| ChannelReferenceId | String | ||
| ChannelSource | String | ||
| Contactpersons | String | ||
| CouponDuration | String | ||
| CreatedAt | Date | ||
| CreatedById | String | ||
| CreatedDate | Date | ||
| CreatedTime | Datetime | ||
| CrmOwnerId | String | ||
| CurrencyCode | String | ||
| CurrencySymbol | String | ||
| CurrentTermEndsAt | Date | ||
| CurrentTermStartsAt | Date | ||
| CustomFields | String | ||
| CustomerId | String | ||
| CustomerBillingAddressAttention | String | ||
| CustomerBillingAddressCity | String | ||
| CustomerBillingAddressCountry | String | ||
| CustomerBillingAddressFax | String | ||
| CustomerBillingAddressPhone | String | ||
| CustomerBillingAddressState | String | ||
| CustomerBillingAddressStreet | String | ||
| CustomerBillingAddressStreet2 | String | ||
| CustomerBillingAddressZip | String | ||
| CustomerChannelCustomerId | String | ||
| CustomerChannelReferenceId | String | ||
| CustomerCompanyName | String | ||
| CustomerCustomFields | String | ||
| CustomerCustomerId | String | ||
| CustomerDisplayName | String | ||
| CustomerEmail | String | ||
| CustomerFirstName | String | ||
| CustomerIpAddress | String | ||
| CustomerLastName | String | ||
| CustomerPaymentTerms | Integer | ||
| CustomerPaymentTermsLabel | String | ||
| CustomerSalutation | String | ||
| CustomerShippingAddressAttention | String | ||
| CustomerShippingAddressCity | String | ||
| CustomerShippingAddressCountry | String | ||
| CustomerShippingAddressFax | String | ||
| CustomerShippingAddressPhone | String | ||
| CustomerShippingAddressState | String | ||
| CustomerShippingAddressStreet | String | ||
| CustomerShippingAddressStreet2 | String | ||
| CustomerShippingAddressZip | String | ||
| CustomerWebsite | String | ||
| CustomerZcrmAccountId | String | ||
| CustomerZcrmContactId | String | ||
| EndOfTerm | Boolean | ||
| ExchangeRate | Double | ||
| ExpiresAt | String | ||
| Interval | Integer | ||
| IntervalUnit | String | ||
| IsInclusiveTax | Boolean | ||
| IsMeteredBilling | Boolean | ||
| ItemsAssociated | String | ||
| LastModifiedById | String | ||
| Name | String | ||
| NextBillingAt | Date | ||
| NextShipmentAt | Date | ||
| NextShipmentDay | String | ||
| Notes | String | ||
| OrdersCreated | Integer | ||
| OrdersRemaining | Integer | ||
| PaymentGateways | String | ||
| PaymentTerms | Integer | ||
| PaymentTermsLabel | String | ||
| PlanDescription | String | ||
| PlanDiscount | Double | ||
| PlanItemCustomFields | String | ||
| PlanName | String | ||
| PlanPlanCode | String | ||
| PlanPrice | Double | ||
| PlanQuantity | Integer | ||
| PlanSetupFee | Double | ||
| PlanSetupFeeTaxId | String | ||
| PlanSetupFeeTaxName | String | ||
| PlanSetupFeeTaxPercentage | String | ||
| PlanSetupFeeTaxType | String | ||
| PlanTaxId | String | ||
| PlanTaxName | String | ||
| PlanTaxPercentage | Integer | ||
| PlanTaxType | String | ||
| PlanTotal | Double | ||
| PlanUnit | String | ||
| PricebookId | String | ||
| ProductId | String | ||
| ProductName | String | ||
| ReferenceId | String | ||
| RemainingBillingCycles | Integer | ||
| SalespersonId | String | ||
| SalespersonName | String | ||
| ShippingInterval | Integer | ||
| ShippingIntervalUnit | String | ||
| StartDate | Date | ||
| SubTotal | Double | ||
| TaxRounding | String | ||
| Taxes | String | ||
| TotalOrders | Integer | ||
| UpdatedTime | Datetime | ||
| ZcrmPotentialId | String | ||
| ZcrmPotentialName | String |