Zuora Tables

Tables

ZuoraEmails

Stores email address records associated with Zuora users, including type, primary status, and the user each address belongs to.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zuora integration configuration.
ID	integer	Auto-incremented primary key for the email record.
Value	string	The email address value associated with the user.
Display	string	Human-readable display label for the email address, typically the same as the value.
Type	string	Type classification of the email address (e.g., `work`, `home`, `other`).
Primary	boolean	Indicates whether this is the user's primary email address.
ZuoraUserID	string	Identifier of the Zuora user this email address belongs to.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ZuoraGroups

Contains Zuora SCIM group records used for organizing users, including display name, organization association, active status, and extension metadata.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zuora integration configuration.
ID	string	Unique SCIM-generated identifier for the group.
DisplayName	string	Human-readable display name of the group.
ResourceType	string	SCIM resource type for the group, always `Group`.
Location	string	Canonical SCIM URL of the group resource.
SchemasJson	string	Serialized JSON list of SCIM schema URIs applicable to this group resource.
UrnZuoraScimSchemas10GroupExtensionOrganizationID	string	Zuora organization ID associated with the group, from the Zuora SCIM group extension schema.
UrnZuoraScimSchemas10GroupExtensionActive	boolean	Indicates whether the group is active, from the Zuora SCIM group extension schema.
UrnZuoraScimSchemas10GroupExtensionDescription	string	Description of the group's purpose, from the Zuora SCIM group extension schema.
UrnZuoraScimSchemas10GroupExtensionSchemasJson	string	Serialized JSON list of extension schema URIs applicable to this group, from the Zuora SCIM group extension.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ZuoraGroups_ZuoraUsers

Junction table associating Zuora groups with their member users, linking group and user identifiers with their respective configuration IDs.

Name	Type	Description
ZuoraGroupModelID	string	Identifier of the Zuora group in the group-to-user membership association.
ZuoraGroupModelConfigID	integer	Configuration identifier of the Zuora group record in the group-to-user membership association.
ZuoraUserModelID	string	Identifier of the Zuora user in the group-to-user membership association.
ZuoraUserModelConfigID	integer	Configuration identifier of the Zuora user record in the group-to-user membership association.

ZuoraIntegrations

Integration summary table listing all Zuora integration configurations with OAuth client credentials, creation and modification metadata, and enablement status.

Name	Type	Description
ID	integer	Auto-incremented primary key for the Zuora integration configuration record.
Name	string	Display name of the Zuora integration configuration.
IsEnabled	boolean	Indicates whether the integration configuration is currently active and enabled.
ClientID	string	OAuth client ID used to authenticate API requests for this integration configuration.
CreatedDate	datetime	Timestamp indicating when the integration configuration was created.
ModifiedDate	datetime	Timestamp indicating when the integration configuration was last modified.
CreatedBy	string	Username or identifier of the user who created the integration configuration.
ModifiedBy	string	Username or identifier of the user who last modified the integration configuration.
IntegrationID	integer	Numeric identifier linking this record to the associated Zuora integration instance.

ZuoraRoles

Stores Zuora role definitions assigned to users, including the internal role value and human-readable display name.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zuora integration configuration.
ID	uniqueidentifier	Unique identifier of the Zuora role.
Value	string	Internal system value or identifier of the role.
Display	string	Human-readable display name of the role shown in the Zuora UI.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ZuoraRoles_ZuoraUsers

Junction table associating Zuora roles with the users they are assigned to, linking role and user identifiers with their respective configuration IDs.

Name	Type	Description
ZuoraUserModelID	string	Identifier of the Zuora user in the role-to-user assignment.
ZuoraUserModelConfigID	integer	Configuration identifier of the Zuora user record in the role-to-user assignment.
ZuoraRoleModelID	uniqueidentifier	Identifier of the Zuora role in the role-to-user assignment.
ZuoraRoleModelConfigID	integer	Configuration identifier of the Zuora role record in the role-to-user assignment.

ZuoraServiceProviderAuthenticationSchemes

Records the authentication schemes supported by the Zuora SCIM service provider, including scheme type, description, specification URI, and primary designation.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zuora integration configuration.
Name	string	Name of the authentication scheme supported by the Zuora SCIM service provider (e.g., `OAuth Bearer Token`).
ZuoraServiceProviderConfigurationID	uniqueidentifier	Identifier of the parent service provider configuration this authentication scheme belongs to.
Description	string	Description of the authentication scheme and how it is used to authenticate SCIM requests.
SpecUri	string	URI linking to the specification document that defines this authentication scheme.
Type	string	Type identifier of the authentication scheme (e.g., `oauthbearertoken`, `httpbasic`).
Primary	boolean	Indicates whether this is the primary authentication scheme for the SCIM service provider.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.
ID	integer	Auto-incremented primary key for the authentication scheme record.

ZuoraServiceProviderConfigurations

Contains the Zuora SCIM service provider configuration, describing supported SCIM features such as patch, bulk, filter, sort, and ETag capabilities and their limits.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zuora integration configuration.
ID	uniqueidentifier	Unique identifier of the service provider configuration record.
SchemasJson	string	Serialized JSON list of SCIM schema URIs applicable to the service provider configuration resource.
PatchSupported	boolean	Indicates whether the SCIM PATCH operation is supported by the Zuora service provider.
BulkSupported	boolean	Indicates whether the SCIM bulk operation endpoint is supported by the Zuora service provider.
BulkMaxOperations	integer	Maximum number of operations permitted in a single SCIM bulk request.
BulkMaxPayloadSize	integer	Maximum payload size in bytes allowed for a single SCIM bulk request.
FilterSupported	boolean	Indicates whether SCIM filter queries are supported by the Zuora service provider.
FilterMaxResults	integer	Maximum number of results the Zuora service provider will return in response to a SCIM filter query.
ChangePasswordSupported	boolean	Indicates whether the SCIM change password operation is supported by the Zuora service provider.
SortSupported	boolean	Indicates whether sorting of SCIM list results is supported by the Zuora service provider.
EtagSupported	boolean	Indicates whether ETag-based resource versioning is supported by the Zuora service provider.
MetaResourceType	string	SCIM resource type of the service provider configuration, always `ServiceProviderConfig`.
MetaLocation	string	Canonical SCIM URL of the service provider configuration resource.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ZuoraUsers

Stores Zuora user account records provisioned via the SCIM API, including identity, locale, active status, SSO enablement, organization assignment, and region from the Zuora SCIM extension.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zuora integration configuration.
ID	string	Unique SCIM-generated identifier for the Zuora user.
SchemasJson	string	Serialized JSON list of SCIM schema URIs applicable to this user resource.
Created	datetime	Timestamp indicating when the user account was created.
ResourceType	string	SCIM resource type for the user, always `User`.
Location	string	Canonical SCIM URL of the user resource.
FormattedName	string	Full formatted display name of the user as a single string.
FamilyName	string	Family name (last name) of the user.
GivenName	string	Given name (first name) of the user.
UserName	string	Unique login username for the user, used for authentication into Zuora. Globally unique within the tenant.
DisplayName	string	Human-readable display name of the user shown in the Zuora UI.
PreferredLanguage	string	Preferred language of the user expressed as a BCP 47 language tag (e.g., `en-US`, `fr-FR`).
Locale	string	Locale setting of the user used for formatting dates, numbers, and currency (e.g., `en_US`, `de_DE`).
Active	boolean	Indicates whether the user account is currently active and able to access Zuora.
UrnZuoraScimSchemas10UserExtensionSchemas	string	Serialized SCIM extension schema identifier for the Zuora user extension.
UrnZuoraScimSchemas10UserExtensionOrganizationID	string	Zuora organization ID the user belongs to, from the Zuora SCIM user extension schema.
UrnZuoraScimSchemas10UserExtensionStatus	string	Account status of the user from the Zuora SCIM extension (e.g., `Active`, `Inactive`, `Pending`).
UrnZuoraScimSchemas10UserExtensionSsoEnabled	boolean	Indicates whether single sign-on (SSO) is enabled for this user, from the Zuora SCIM user extension.
UrnZuoraScimSchemas10UserExtensionRegion	string	Data residency region of the user's Zuora tenant (e.g., `US`, `EU`, `NA`).
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.