Adding a Connection to Zuora

To add a connection to Zuora:

1. In the application console, navigate to the Connections page.
2. At the Add Connections panel, select the icon for the connection you want to add.
3. If the Zuora icon is not available, click the Add More icon to download and install the Zuora connector from the CData site.

For required properties, see the Settings tab.

For connection properties that are not typically required, see the Advanced tab.

Connecting to Zuora

In order to create a valid connection with Zuora, you must configure the Tenant property. Choose the Tenant value that matches your account configuration. Available options:

• USProduction: Requests sent to https://rest.zuora.com. (default)
• USAPISandbox: Requests sent to https://rest.apisandbox.zuora.com"
• USPerformanceTest: Requests sent to https://rest.pt1.zuora.com"
• EUProduction: Requests sent to https://rest.eu.zuora.com"
• EUSandbox: Requests sent to https://rest.sandbox.eu.zuora.com"

After you configure the Tenant you must create a custom OAuth application to generate a token. This is a simple one-time operation. For further information, see Creating a Custom OAuth Application.

Authenticating to Zuora

OAuth

You must create a custom application that includes a client Id and client secret for authentication.

Before you connect, set the following variables:

• OAuthClientId: The client Id assigned when you registered your custom OAuth application.
• OAuthClientSecret: The client secret assigned when you registered your custom OAuth application.

Click Connect to Zuora to open the OAuth endpoint in your default browser. Log in and grant permissions to the application.

The driver then completes the OAuth process as follows:

• Extracts the access token from the callback URL.
• Obtains a new access token when the old one expires.
• Saves OAuth values so that they persist across connections.

Selecting a Zuora Service

We utilize two Zuora services: Data Query and AQuA API. By default ZuoraService is set to AQuADataExport.

DataQuery

The Data Query feature enables you to export data from your Zuora tenant by performing asynchronous, read-only SQL queries. We recommend to use this service for quick lightweight SQL queries.

Limitations

• The maximum number of input records per table after filters have been applied: 1,000,000
• The maximum number of output records: 100,000
• The maximum number of simultaneous queries submitted for execution per tenant: 5
• The maximum number of queued queries submitted for execution after reaching the limitation of simultaneous queries per tenant: 10
• The maximum processing time for each query in hours: 1
• The maximum size of memory allocated to each query in GB: 2
• The maximum number of indices when using Index Join, in other words, the maximum number of records being returned by the left table based on the unique value used in the WHERE clause when using Index Join: 20,000

Selecting a Zuora Service

We utilize two Zuora services: Data Query and AQuA API. By default ZuoraService is set to AQuADataExport.

DataQuery

The Data Query feature enables you to export data from your Zuora tenant by performing asynchronous, read-only SQL queries. We recommend to use this service for quick lightweight SQL queries.

Limitations

• The maximum number of input records per table after filters have been applied: 1,000,000
• The maximum number of output records: 100,000
• The maximum number of simultaneous queries submitted for execution per tenant: 5
• The maximum number of queued queries submitted for execution after reaching the limitation of simultaneous queries per tenant: 10
• The maximum processing time for each query in hours: 1
• The maximum size of memory allocated to each query in GB: 2
• The maximum number of indices when using Index Join, in other words, the maximum number of records being returned by the left table based on the unique value used in the WHERE clause when using Index Join: 20,000

AQuADataExport

AQuA API export is designed to export all the records for all the objects ( tables ). AQuA query jobs have the following limitations:

Limitations

• If a query in an AQuA job is executed longer than 8 hours, this job will be killed automatically.
• The killed AQuA job can be retried three times before returned as failed.

Creating a Custom OAuth Application

All users authenticate to the Zuora via the OAuth 2.0 mechanism. The Sync App uses the client_credential grant type, which means that only the OAuthClientId and OAuthClientSecret are needed to generate a token. This is done via a single HTTP request.

In order to obtain the OAuthClientId and OAuthClientSecret, you must first create a custom OAuth client in the Zuora UI.

Do the following:

1. Using an account that has administration privileges for your Zuora tenant, log in to the Zuora Profiles & Settings menu.
2. Navigate to Administration > Manage Users.
3. Create a user. Applications that use OAuth to authenticate to your Zuora tenant will perform actions as this user. Zuora recommends that you create an API user specifically for this purpose.
4. Navigate to your Zuora tenant's Users page.
5. Select the new user you just created, then create an OAuth client for that user.
6. Note the Client Id and Client secret for future use.

This section details a selection of advanced features of the Zuora Sync App.

User Defined Views

The Sync App supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views .

SSL Configuration

Use SSL Configuration to adjust how Sync App handles TLS/SSL certificate negotiations. You can choose from various certificate formats;. For further information, see the SSLServerCert property under "Connection String Options" .

Firewall and Proxy

Configure the Sync App for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to Zuora and then processes the rest of the query in memory (client-side).

For further information, see Query Processing.

Logging

For an overview of configuration settings that can be used to refine CData logging, see Logging. Only two connection properties are required for basic logging, but there are numerous features that support more refined logging, which enables you to use the LogModules connection property to specify subsets of information to be logged.

Customizing the SSL Configuration

By default, the Sync App attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Connecting Through a Firewall or Proxy

HTTP Proxies

To authenticate to an HTTP proxy, set the following:

• ProxyServer: the hostname or IP address of the proxy server that you want to route HTTP traffic through.
• ProxyPort: the TCP port that the proxy server is running on.
• ProxyAuthScheme: the authentication method the Sync App uses when authenticating to the proxy server.
• ProxyUser: the username of a user account registered with the proxy server.
• ProxyPassword: the password associated with the ProxyUser.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The Sync App dynamically extracts all relevant schema information from Zuora via the REST API. All Zuora entities will be exposed as views.

The CData Sync App models Zuora objects as relational tables and views. A Zuora object has relationships to other objects; in the tables, these relationships are expressed through foreign keys. The following sections show the available API objects and provide more information on executing SQL to Zuora APIs.

Schemas for most database objects are defined in simple, text-based configuration files.

Stored Procedures

Stored Procedures are function-like interfaces to Zuora. They can be used create schema files or get and refresh OAuth Access tokens for Zuora apps.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

Zuora Connector for CData Sync Views

Name	Description
Account	An account is a customer account that collects all of the critical information about the customer, such as contact information, payment terms, and payment methods.
AccountingCode	Each row of this table represents an accounting code.
AccountingPeriod	Accounting periods match your financial periods.An accounting period holds the information you need to perform your company's bookkeeping activities, especially tracking and reporting financial activities such as earnings, expenses, and taxes.
Amendment	An amendment to a subscription.
ApplicationGroup	A group of payment, refund, and credit memo applications.
Attachment	The information of a file attached to a Zuora object.
BillingRun	Each row of this table represents a billing run.
ChargeMetrics	A charge metrics service for accessing the key metrics for Rate Plan Charges in Zuora.
Contact	A contact person. For example, the Bill To contact of a customer account
ContactSnapshot	A copy of the Bill To or Sold To contact information from a posted invoice.
CreditBalanceAdjustment	An adjustment to the credit balance of a customer account.
CreditMemo	A credit memo that is owned by a customer account.
CreditMemoApplication	A credit memo that is applied to an invoice or a debit memo.
CreditMemoApplicationItem	A credit memo that is applied to a line item in an invoice or a line item in a debit memo.
CreditMemoItem	A line item in a credit memo.
CreditMemoPart	An applied or unapplied portion of a credit memo.
CreditMemoPartItem	A portion of a credit memo that is applied to a line item in an invoice or a line item in a debit memo.
CreditTaxationItem	A taxation line item in a credit memo.
DebitMemo	A debit memo that is owned by a customer account.
DebitMemoItem	A line item in a debit memo.
DebitTaxationItem	A taxation line item in a debit memo.
DiscountAppliedMetrics	A discount rate plan charge that is applied to another rate plan charge.
DiscountApplyDetail	Details for the applied discount.
Feature	Each row of this table represents a feature.
FXCustomRate	A custom exchange rate.
Invoice	An invoice represents a bill to a customer.
InvoiceAdjustment	An adjustment to an invoice.
InvoiceItem	A line item in an invoice.
InvoiceItemAdjustment	An adjustment to a line item in an invoice.
InvoicePayment	A payment that is applied to an invoice.
JournalEntry	A journal entry.
JournalEntryItem	A line item in a journal entry.
JournalRun	A journal run.
OrderAction	An order action that is applied to a subscription.
OrderElp	An extended list price metric for an order action.
OrderItem	An order item.
OrderMrr	A monthly recurring revenue metric for an order action.
OrderQuantity	A quantity metric for an order action.
Orders	Each row of this table represents an order.
OrderTcb	A total contracted billing metric for an order action.
OrderTcv	A total contract value metric for an order action.
Payment	Each row of this table represents a payment.
PaymentApplication	A payment that is applied to an invoice or a debit memo.
PaymentApplicationItem	A payment that is applied to a line item in an invoice or a line item in a debit memo.
PaymentGatewayReconciliationEventLog	An event that was processed by a payment reconciliation job.
PaymentMethod	A payment method.
PaymentMethodSnapshot	A copy of the payment method that was used in a transaction.
PaymentMethodTransactionLog	A transaction from Zuora to the payment gateway associated with a payment method.
PaymentPart	An applied or unapplied portion of a payment.
PaymentPartItem	A portion of a payment that is applied to a line item in an invoice or a line item in a debit memo.
PaymentReconciliationJob	A payment reconciliation job.
PaymentReconciliationLog	A reconciled transaction that was processed by a payment reconciliation job.
PaymentRun	A payment run.
PaymentTransactionLog	A transaction from Zuora to the payment gateway associated with a payment.
ProcessedUsage	Uploaded usage that has been processed.
Product	A product in your product catalog.
ProductFeature	A feature in your product catalog.
ProductRatePlan	A rate plan in your product catalog.
ProductRatePlanCharge	A charge in your product catalog.
ProductRatePlanChargeTier	A charge tier in your product catalog.
RatePlan	A rate plan in a subscription.
RatePlanCharge	A charge in a subscription.
RatePlanChargeTier	A charge tier in a subscription.
Refund	Each row of this table represents a refund.
RefundApplication	A refund that is applied to a payment or a credit memo.
RefundApplicationItem	A refund that is applied to a line item in a credit memo.
RefundInvoicePayment	A refunded portion of a payment that is applied to an invoice.
RefundPart	An applied or unapplied portion of a refund.
RefundPartItem	A portion of a refund that is applied to a line item in a credit memo.
RefundTransactionLog	A transaction from Zuora to the payment gateway associated with a payment.
RevenueChargeSummary	A revenue distribution summary of a charge.
RevenueChargeSummaryItem	An item in a revenue distribution summary of a charge.
RevenueEvent	A revenue event.
RevenueEventCreditMemoItem	A revenue event that is associated with a line item in a credit memo.
RevenueEventDebitMemoItem	A revenue event that is associated with a line item in a debit memo.
RevenueEventInvoiceItem	A revenue event that is associated with a line item in an invoice.
RevenueEventInvoiceItemAdjustment	A revenue event that is associated with an adjustment to a line item in an invoice.
RevenueEventItem	A revenue event item.
RevenueEventItemCreditMemoItem	A revenue event item that is associated with a line item in a credit memo.
RevenueEventItemDebitMemoItem	A revenue event item that is associated with a line item in a debit memo.
RevenueEventItemInvoiceItem	A revenue event item that is associated with a line item in an invoice.
RevenueEventItemInvoiceItemAdjustment	A revenue event item that is associated with an adjustment to a line item in an invoice.
RevenueEventType	A revenue event type.
RevenueSchedule	A revenue schedule.
RevenueScheduleCreditMemoItem	A revenue schedule that is associated with a line item in a credit memo.
RevenueScheduleDebitMemoItem	A revenue schedule that is associated with a line item in a debit memo.
RevenueScheduleInvoiceItem	A revenue schedule that is associated with a line item in an invoice.
RevenueScheduleInvoiceItemAdjustment	A revenue schedule that is associated with an adjustment to a line item in an invoice.
RevenueScheduleItem	A revenue schedule item.
RevenueScheduleItemCreditMemoItem	A revenue schedule item that is associated with a line item in a credit memo.
RevenueScheduleItemInvoiceItem	A revenue schedule item that is associated with a line item in an invoice.
RevenueScheduleItemInvoiceItemAdjustment	A revenue schedule item that is associated with an adjustment to a line item in an invoice.
Subscription	Each row of this table represents a subscription.
SubscriptionProductFeature	Each row of this table represents a subscription for a product feature.
TaxationItem	A taxation line item in an invoice.
UpdaterBatch	A batch of payment methods that was sent to a payment method updater service provider.
UpdaterDetail	A payment method update.
Usage	A usage record.f the Active Rating feature is enabled, each row represents a usage record that was created via the Active Rating feature.
User	A user in your Zuora tenant. Only platform admin users can access this table.

An account is a customer account that collects all of the critical information about the customer, such as contact information, payment terms, and payment methods.

Columns

Name	Type	Description
taxexempteffectivedate	Date	Date when the customer's tax exemption starts.
invoicetemplateid	String	The ID of the invoice template. Each customer account can use a specific invoice template for invoice generation.
totaldebitmemobalance	Decimal	The total debit memo balance.
updateddate	Datetime	Date when the account was last updated.
name	String	Name of the account as displayed in the Zuora UI.
createdbyid	String	ID of the Zuora user who created the Account object.
taxexemptissuingjurisdiction	String	Indicates the jurisdiction in which the customer's tax exemption certificate was issued.
currency	String	Currency that the customer is billed in.
taxexemptcertificateid	String	ID of your customer's tax exemption certificate.
crmid	String	CRM account ID for the account. Used in Salesforce integration.
defaultpaymentmethodid	String	ID of the default payment method for the account. This field is required if the AutoPay field is set to true.
status	String	Status of the account in the system.
creditmemotemplateid	String	The credit memo template id.
debitmemotemplateid	String	The debit memo template id.
communicationprofileid	String	Associates the account with a specified communication profile.
invoicedeliveryprefsemail	Bool	Indicates if the customer wants to receive invoices through email.
bcdsettingoption	String	Billing cycle day setting option.
createddate	Datetime	Date when the Account object was created.
unappliedcreditmemoamount	Decimal	The unapplied credit memo amount.
taxcompanycode	String	Unique code that identifies a company account in Avalara. Use this field to calculate taxes based on origin and sold-to addresses in Avalara.
id	String	ID of object. Upon creation of this object, this field becomes AccountId.
balance	Decimal	Current outstanding balance for the account.
soldtoid	String	ID of the person who bought the subscription associated with the account.
unappliedbalance	Decimal	The unapplied balance.
invoicedeliveryprefsprint	Bool	Indicates if the customer wants to receive printed invoices, such as through postal mail.
sequencesetid	String	The ID of the billing document sequence set to assign to the customer account.
additionalemailaddresses	String	List of additional email addresses to receive emailed invoices.
mrr	Decimal
taxexemptexpirationdate	Date	Date when the customer's tax exemption certificate expires.
incollections_c	String	You can use this fields as custom field in your customization.
totalinvoicebalance	Decimal	Total balance of the account's invoices.
taxexemptentityusecode	String	You can use this fields as custom field in your customization.
batch	String	Organizes your customer accounts into groups to optimize your billing and payment operations.
paymentgateway	String	Gateway used for processing electronic payments and refunds.
billcycleday	String	Billing cycle day (BCD) on which bill runs generate invoices for the account.
billtoid	String	ID of the person to bill for the account
notes	String	Comments about the account.
vatid	String	EU Value Added Tax ID.
parentid	String	Identifier of the parent customer account for this Account object. Use this field if you have customer hierarchy enabled.
purchaseordernumber	String	The number of the purchase order associated with this account. Purchase order information generally comes from customers.
updatedbyid	String	ID of the user who last updated the account.
creditbalance	Decimal	Total credit balance for the account.
autopay	Bool	Indicates if future payments are automatically collected when they're due during a Payment Run
customerservicerepname	String	Name of the account's customer service representative, if applicable.
paymentterm	String	Indicates when the customer pays for subscriptions.
entity_c	String
lastinvoicedate	Date	The date when the previous invoice was generated for the account. The field value is null if no invoice has ever been generated for the account.
accountnumber	String	Unique account number assigned to the account.
taxexemptstatus	String	Status of the account's tax exemption.
taxexemptcertificatetype	String	Type of the tax exemption certificate that your customer holds.
salesrepname	String	The name of the sales representative associated with this account, if applicable.
taxexemptdescription	String	Description of the tax exemption certificate that your customer holds.
allowinvoiceedit	Bool	Indicates if associated invoices can be edited.

Each row of this table represents an accounting code.

Columns

Name	Type	Description
status	String	The 'status' column for the 'accountingcode' table.
category	String	The 'category' column for the 'accountingcode' table.
updateddate	Datetime	The 'updateddate' column for the 'accountingcode' table.
updatedbyid	String	The 'updatedbyid' column for the 'accountingcode' table.
glaccountname	String	The 'glaccountname' column for the 'accountingcode' table.
name	String	The 'name' column for the 'accountingcode' table.
type	String	The 'type' column for the 'accountingcode' table.
createdbyid	String	The 'createdbyid' column for the 'accountingcode' table.
createddate	Datetime	The 'createddate' column for the 'accountingcode' table.
glaccountnumber	String	The 'glaccountnumber' column for the 'accountingcode' table.
id	String	The 'id' column for the 'accountingcode' table.
notes	String	The 'notes' column for the 'accountingcode' table.

Accounting periods match your financial periods.An accounting period holds the information you need to perform your company's bookkeeping activities, especially tracking and reporting financial activities such as earnings, expenses, and taxes.

Columns

Name	Type	Description
startdate	Date	The 'startdate' column for the 'accountingperiod' table.
status	String	The 'status' column for the 'accountingperiod' table.
fiscalquarter	String	The 'fiscalquarter' column for the 'accountingperiod' table.
fiscalyear	String	The 'fiscalyear' column for the 'accountingperiod' table.
createdbyid	String	The 'createdbyid' column for the 'accountingperiod' table.
updateddate	Datetime	The 'updateddate' column for the 'accountingperiod' table.
updatedbyid	String	The 'updatedbyid' column for the 'accountingperiod' table.
createddate	Datetime	The 'createddate' column for the 'accountingperiod' table.
id	String	The 'id' column for the 'accountingperiod' table.
enddate	Date	The 'enddate' column for the 'accountingperiod' table.
notes	String	The 'notes' column for the 'accountingperiod' table.
name	String	The 'name' column for the 'accountingperiod' table.

An amendment to a subscription.

Columns

Name	Type	Description
currenttermperiodtype	String	The 'currenttermperiodtype' column for the 'amendment' table.
description	String	The 'description' column for the 'amendment' table.
updateddate	Datetime	The 'updateddate' column for the 'amendment' table.
autorenew	Bool	The 'autorenew' column for the 'amendment' table.
renewaltermperiodtype	String	The 'renewaltermperiodtype' column for the 'amendment' table.
serviceactivationdate	Date	The 'serviceactivationdate' column for the 'amendment' table.
resumedate	Date	The 'resumedate' column for the 'amendment' table.
suspenddate	Date	The 'suspenddate' column for the 'amendment' table.
termtype	String	The 'termtype' column for the 'amendment' table.
name	String	The 'name' column for the 'amendment' table.
contracteffectivedate	Date	The 'contracteffectivedate' column for the 'amendment' table.
customeracceptancedate	Date	The 'customeracceptancedate' column for the 'amendment' table.
subscriptionid	String	The 'subscriptionid' column for the 'amendment' table.
createdbyid	String	The 'createdbyid' column for the 'amendment' table.
currentterm	String	The 'currentterm' column for the 'amendment' table.
status	String	The 'status' column for the 'amendment' table.
updatedbyid	String	The 'updatedbyid' column for the 'amendment' table.
renewalsetting	String	The 'renewalsetting' column for the 'amendment' table.
specificupdatedate	Date	The 'specificupdatedate' column for the 'amendment' table.
code	String	The 'code' column for the 'amendment' table.
type	String	The 'type' column for the 'amendment' table.
termstartdate	Date	The 'termstartdate' column for the 'amendment' table.
createddate	Datetime	The 'createddate' column for the 'amendment' table.
renewalterm	String	The 'renewalterm' column for the 'amendment' table.
id	String	The 'id' column for the 'amendment' table.
effectivedate	Date	The 'effectivedate' column for the 'amendment' table.

A group of payment, refund, and credit memo applications.

Columns

Name	Type	Description
createdbyid	String	The 'createdbyid' column for the 'applicationgroup' table.
updateddate	Datetime	The 'updateddate' column for the 'applicationgroup' table.
operationdate	Date	The 'operationdate' column for the 'applicationgroup' table.
updatedbyid	String	The 'updatedbyid' column for the 'applicationgroup' table.
createddate	Datetime	The 'createddate' column for the 'applicationgroup' table.
paymentid	String	The 'paymentid' column for the 'applicationgroup' table.
id	String	The 'id' column for the 'applicationgroup' table.
refundid	String	The 'refundid' column for the 'applicationgroup' table.

The information of a file attached to a Zuora object.

Columns

Name	Type	Description
description	String	The 'description' column for the 'attachment' table.
updateddate	Datetime	The 'updateddate' column for the 'attachment' table.
size	String	The 'size' column for the 'attachment' table.
updatedbyid	String	The 'updatedbyid' column for the 'attachment' table.
filename	String	The 'filename' column for the 'attachment' table.
associatedobjectid	String	The 'associatedobjectid' column for the 'attachment' table.
associatedobjecttype	String	The 'associatedobjecttype' column for the 'attachment' table.
createdbyid	String	The 'createdbyid' column for the 'attachment' table.
createddate	Datetime	The 'createddate' column for the 'attachment' table.
fileid	String	The 'fileid' column for the 'attachment' table.
id	String	The 'id' column for the 'attachment' table.
filecontenttype	String	The 'filecontenttype' column for the 'attachment' table.

Each row of this table represents a billing run.

Columns

Name	Type	Description
executeddate	Datetime	The 'executeddate' column for the 'billingrun' table.
numberofaccounts	String	The 'numberofaccounts' column for the 'billingrun' table.
accountid	String	The 'accountid' column for the 'billingrun' table.
runtime	String	The 'runtime' column for the 'billingrun' table.
updateddate	Datetime	The 'updateddate' column for the 'billingrun' table.
repeatto	String	The 'repeatto' column for the 'billingrun' table.
autoemail	Bool	The 'autoemail' column for the 'billingrun' table.
targetdateoffset	String	The 'targetdateoffset' column for the 'billingrun' table.
startdate	Datetime	The 'startdate' column for the 'billingrun' table.
invoicedateoffset	String	The 'invoicedateoffset' column for the 'billingrun' table.
chargetypetoexclude	String	The 'chargetypetoexclude' column for the 'billingrun' table.
createdbyid	String	The 'createdbyid' column for the 'billingrun' table.
autopost	Bool	The 'autopost' column for the 'billingrun' table.
billcycleday	String	The 'billcycleday' column for the 'billingrun' table.
lastemailsenttime	Datetime	The 'lastemailsenttime' column for the 'billingrun' table.
targettype	String	The 'targettype' column for the 'billingrun' table.
totaltime	String	The 'totaltime' column for the 'billingrun' table.
noemailforzeroamountinvoice	Bool	The 'noemailforzeroamountinvoice' column for the 'billingrun' table.
invoicedate	Date	The 'invoicedate' column for the 'billingrun' table.
monthlyonday	String	The 'monthlyonday' column for the 'billingrun' table.
numberofcreditmemos	String	The 'numberofcreditmemos' column for the 'billingrun' table.
billingruntype	String	The 'billingruntype' column for the 'billingrun' table.
numberofinvoices	String	The 'numberofinvoices' column for the 'billingrun' table.
status	String	The 'status' column for the 'billingrun' table.
updatedbyid	String	The 'updatedbyid' column for the 'billingrun' table.
weeklyonday	String	The 'weeklyonday' column for the 'billingrun' table.
repeatfrom	String	The 'repeatfrom' column for the 'billingrun' table.
enddate	Datetime	The 'enddate' column for the 'billingrun' table.
invoicesemailed	Bool	The 'invoicesemailed' column for the 'billingrun' table.
timezone	String	The 'timezone' column for the 'billingrun' table.
autorenewal	Bool	The 'autorenewal' column for the 'billingrun' table.
targetdate	Date	The 'targetdate' column for the 'billingrun' table.
createddate	Datetime	The 'createddate' column for the 'billingrun' table.
billingrunnumber	String	The 'billingrunnumber' column for the 'billingrun' table.
posteddate	Datetime	The 'posteddate' column for the 'billingrun' table.
batches	String	The 'batches' column for the 'billingrun' table.
repeattype	String	The 'repeattype' column for the 'billingrun' table.
id	String	The 'id' column for the 'billingrun' table.
errormessage	String	The 'errormessage' column for the 'billingrun' table.

A charge metrics service for accessing the key metrics for Rate Plan Charges in Zuora.

Columns

Name	Type	Description
subscriptionowneraccountnumber	String	The 'subscriptionowneraccountnumber' column for the 'chargemetrics' table.
tcvdiscountamount	Decimal	The 'tcvdiscountamount' column for the 'chargemetrics' table.
tcvgrossamount	Decimal	The 'tcvgrossamount' column for the 'chargemetrics' table.
amendmentid	String	The 'amendmentid' column for the 'chargemetrics' table.
rateplanchargeid	String	The 'rateplanchargeid' column for the 'chargemetrics' table.
mrrgrossamount	Decimal	The 'mrrgrossamount' column for the 'chargemetrics' table.
updateddate	Datetime	The 'updateddate' column for the 'chargemetrics' table.
amendmenttype	String	The 'amendmenttype' column for the 'chargemetrics' table.
productrateplanid	String	The 'productrateplanid' column for the 'chargemetrics' table.
productid	String	The 'productid' column for the 'chargemetrics' table.
subscriptionname	String	The 'subscriptionname' column for the 'chargemetrics' table.
enddate	Date	The 'enddate' column for the 'chargemetrics' table.
startdate	Date	The 'startdate' column for the 'chargemetrics' table.
productrateplanchargeid	String	The 'productrateplanchargeid' column for the 'chargemetrics' table.
mrrnetamount	Decimal	The 'mrrnetamount' column for the 'chargemetrics' table.
tcvnetamount	Decimal	The 'tcvnetamount' column for the 'chargemetrics' table.
currency	String	The 'currency' column for the 'chargemetrics' table.
createddate	Datetime	The 'createddate' column for the 'chargemetrics' table.
id	String	The 'id' column for the 'chargemetrics' table.
invoiceowneraccountnumber	String	The 'invoiceowneraccountnumber' column for the 'chargemetrics' table.
chargenumber	String	The 'chargenumber' column for the 'chargemetrics' table.
mrrdiscountamount	Decimal	The 'mrrdiscountamount' column for the 'chargemetrics' table.

A contact person. For example, the Bill To contact of a customer account

Columns

Name	Type	Description
taxregion	String	The 'taxregion' column for the 'contact' table.
otherphone	String	The 'otherphone' column for the 'contact' table.
accountid	String	The 'accountid' column for the 'contact' table.
description	String	The 'description' column for the 'contact' table.
updateddate	Datetime	The 'updateddate' column for the 'contact' table.
postalcode	String	The 'postalcode' column for the 'contact' table.
county	String	The 'county' column for the 'contact' table.
mobilephone	String	The 'mobilephone' column for the 'contact' table.
personalemail	String	The 'personalemail' column for the 'contact' table.
createdbyid	String	The 'createdbyid' column for the 'contact' table.
workphone	String	The 'workphone' column for the 'contact' table.
firstname	String	The 'firstname' column for the 'contact' table.
updatedbyid	String	The 'updatedbyid' column for the 'contact' table.
address2	String	The 'address2' column for the 'contact' table.
address1	String	The 'address1' column for the 'contact' table.
city	String	The 'city' column for the 'contact' table.
workemail	String	The 'workemail' column for the 'contact' table.
nickname	String	The 'nickname' column for the 'contact' table.
homephone	String	The 'homephone' column for the 'contact' table.
state	String	The 'state' column for the 'contact' table.
createddate	Datetime	The 'createddate' column for the 'contact' table.
country	String	The 'country' column for the 'contact' table.
id	String	The 'id' column for the 'contact' table.
lastname	String	The 'lastname' column for the 'contact' table.
fax	String	The 'fax' column for the 'contact' table.
otherphonetype	String	The 'otherphonetype' column for the 'contact' table.

A copy of the Bill To or Sold To contact information from a posted invoice.

Columns

Name	Type	Description
taxregion	String	The 'taxregion' column for the 'contactsnapshot' table.
otherphone	String	The 'otherphone' column for the 'contactsnapshot' table.
accountid	String	The 'accountid' column for the 'contactsnapshot' table.
description	String	The 'description' column for the 'contactsnapshot' table.
updateddate	Datetime	The 'updateddate' column for the 'contactsnapshot' table.
postalcode	String	The 'postalcode' column for the 'contactsnapshot' table.
contactid	String	The 'contactid' column for the 'contactsnapshot' table.
county	String	The 'county' column for the 'contactsnapshot' table.
mobilephone	String	The 'mobilephone' column for the 'contactsnapshot' table.
personalemail	String	The 'personalemail' column for the 'contactsnapshot' table.
createdbyid	String	The 'createdbyid' column for the 'contactsnapshot' table.
workphone	String	The 'workphone' column for the 'contactsnapshot' table.
firstname	String	The 'firstname' column for the 'contactsnapshot' table.
updatedbyid	String	The 'updatedbyid' column for the 'contactsnapshot' table.
address2	String	The 'address2' column for the 'contactsnapshot' table.
address1	String	The 'address1' column for the 'contactsnapshot' table.
city	String	The 'city' column for the 'contactsnapshot' table.
workemail	String	The 'workemail' column for the 'contactsnapshot' table.
nickname	String	The 'nickname' column for the 'contactsnapshot' table.
homephone	String	The 'homephone' column for the 'contactsnapshot' table.
state	String	The 'state' column for the 'contactsnapshot' table.
createddate	Datetime	The 'createddate' column for the 'contactsnapshot' table.
country	String	The 'country' column for the 'contactsnapshot' table.
id	String	The 'id' column for the 'contactsnapshot' table.
lastname	String	The 'lastname' column for the 'contactsnapshot' table.
fax	String	The 'fax' column for the 'contactsnapshot' table.
otherphonetype	String	The 'otherphonetype' column for the 'contactsnapshot' table.

An adjustment to the credit balance of a customer account.

Columns

Name	Type	Description
customercashonaccountaccountingcodeid	String	The 'customercashonaccountaccountingcodeid' column for the 'creditbalanceadjustment' table.
accountid	String	The 'accountid' column for the 'creditbalanceadjustment' table.
accountingcode	String	The 'accountingcode' column for the 'creditbalanceadjustment' table.
updateddate	Datetime	The 'updateddate' column for the 'creditbalanceadjustment' table.
transferredtoaccounting	String	The 'transferredtoaccounting' column for the 'creditbalanceadjustment' table.
invoiceid	String	The 'invoiceid' column for the 'creditbalanceadjustment' table.
sourcetransactiontype	String	The 'sourcetransactiontype' column for the 'creditbalanceadjustment' table.
createdbyid	String	The 'createdbyid' column for the 'creditbalanceadjustment' table.
number	String	The 'number' column for the 'creditbalanceadjustment' table.
referenceid	String	The 'referenceid' column for the 'creditbalanceadjustment' table.
sourcetransactionid	String	The 'sourcetransactionid' column for the 'creditbalanceadjustment' table.
adjustmentdate	Date	The 'adjustmentdate' column for the 'creditbalanceadjustment' table.
cancelledon	Datetime	The 'cancelledon' column for the 'creditbalanceadjustment' table.
accountingperiodid	String	The 'accountingperiodid' column for the 'creditbalanceadjustment' table.
journalentryid	String	The 'journalentryid' column for the 'creditbalanceadjustment' table.
status	String	The 'status' column for the 'creditbalanceadjustment' table.
comment	String	The 'comment' column for the 'creditbalanceadjustment' table.
updatedbyid	String	The 'updatedbyid' column for the 'creditbalanceadjustment' table.
amount	Decimal	The 'amount' column for the 'creditbalanceadjustment' table.
paymentid	String	The 'paymentid' column for the 'creditbalanceadjustment' table.
reasoncode	String	The 'reasoncode' column for the 'creditbalanceadjustment' table.
sourcetransactionnumber	String	The 'sourcetransactionnumber' column for the 'creditbalanceadjustment' table.
cashaccountingcodeid	String	The 'cashaccountingcodeid' column for the 'creditbalanceadjustment' table.
type	String	The 'type' column for the 'creditbalanceadjustment' table.
createddate	Datetime	The 'createddate' column for the 'creditbalanceadjustment' table.
id	String	The 'id' column for the 'creditbalanceadjustment' table.
refundid	String	The 'refundid' column for the 'creditbalanceadjustment' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'creditbalanceadjustment' table.

A credit memo that is owned by a customer account.

Columns

Name	Type	Description
postedbyid	String	The 'postedbyid' column for the 'creditmemo' table.
accountid	String	The 'accountid' column for the 'creditmemo' table.
cancelledbyid	String	The 'cancelledbyid' column for the 'creditmemo' table.
updateddate	Datetime	The 'updateddate' column for the 'creditmemo' table.
sourceid	String	The 'sourceid' column for the 'creditmemo' table.
transferredtoaccounting	String	The 'transferredtoaccounting' column for the 'creditmemo' table.
totaltaxexemptamount	Decimal	The 'totaltaxexemptamount' column for the 'creditmemo' table.
memonumber	String	The 'memonumber' column for the 'creditmemo' table.
taxmessage	String	The 'taxmessage' column for the 'creditmemo' table.
invoiceid	String	The 'invoiceid' column for the 'creditmemo' table.
source	String	The 'source' column for the 'creditmemo' table.
taxamount	Decimal	The 'taxamount' column for the 'creditmemo' table.
createdbyid	String	The 'createdbyid' column for the 'creditmemo' table.
exchangeratedate	Date	The 'exchangeratedate' column for the 'creditmemo' table.
cancelledon	Datetime	The 'cancelledon' column for the 'creditmemo' table.
totalamountwithouttax	Decimal	The 'totalamountwithouttax' column for the 'creditmemo' table.
postedon	Datetime	The 'postedon' column for the 'creditmemo' table.
billtocontactsnapshotid	String	The 'billtocontactsnapshotid' column for the 'creditmemo' table.
status	String	The 'status' column for the 'creditmemo' table.
memodate	Date	The 'memodate' column for the 'creditmemo' table.
comments	String	The 'comments' column for the 'creditmemo' table.
updatedbyid	String	The 'updatedbyid' column for the 'creditmemo' table.
appliedamount	Decimal	The 'appliedamount' column for the 'creditmemo' table.
refundamount	Decimal	The 'refundamount' column for the 'creditmemo' table.
totalamount	Decimal	The 'totalamount' column for the 'creditmemo' table.
soldtocontactsnapshotid	String	The 'soldtocontactsnapshotid' column for the 'creditmemo' table.
reasoncode	String	The 'reasoncode' column for the 'creditmemo' table.
discountamount	Decimal	The 'discountamount' column for the 'creditmemo' table.
targetdate	Date	The 'targetdate' column for the 'creditmemo' table.
createddate	Datetime	The 'createddate' column for the 'creditmemo' table.
taxstatus	String	The 'taxstatus' column for the 'creditmemo' table.
id	String	The 'id' column for the 'creditmemo' table.
balance	Decimal	The 'balance' column for the 'creditmemo' table.

A credit memo that is applied to an invoice or a debit memo.

Columns

Name	Type	Description
debitmemoid	String	The 'debitmemoid' column for the 'creditmemoapplication' table.
accountid	String	The 'accountid' column for the 'creditmemoapplication' table.
updateddate	Datetime	The 'updateddate' column for the 'creditmemoapplication' table.
updatedbyid	String	The 'updatedbyid' column for the 'creditmemoapplication' table.
amount	Decimal	The 'amount' column for the 'creditmemoapplication' table.
invoiceid	String	The 'invoiceid' column for the 'creditmemoapplication' table.
creditmemoid	String	The 'creditmemoid' column for the 'creditmemoapplication' table.
createdbyid	String	The 'createdbyid' column for the 'creditmemoapplication' table.
createddate	Datetime	The 'createddate' column for the 'creditmemoapplication' table.
id	String	The 'id' column for the 'creditmemoapplication' table.
applicationgroupid	String	The 'applicationgroupid' column for the 'creditmemoapplication' table.
effectivedate	Date	The 'effectivedate' column for the 'creditmemoapplication' table.

A credit memo that is applied to a line item in an invoice or a line item in a debit memo.

Columns

Name	Type	Description
updateddate	Datetime	The 'updateddate' column for the 'creditmemoapplicationitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'creditmemoapplicationitem' table.
amount	Decimal	The 'amount' column for the 'creditmemoapplicationitem' table.
invoiceitemid	String	The 'invoiceitemid' column for the 'creditmemoapplicationitem' table.
debitmemoitemid	String	The 'debitmemoitemid' column for the 'creditmemoapplicationitem' table.
createdbyid	String	The 'createdbyid' column for the 'creditmemoapplicationitem' table.
createddate	Datetime	The 'createddate' column for the 'creditmemoapplicationitem' table.
credittaxationitemid	String	The 'credittaxationitemid' column for the 'creditmemoapplicationitem' table.
debittaxationitemid	String	The 'debittaxationitemid' column for the 'creditmemoapplicationitem' table.
id	String	The 'id' column for the 'creditmemoapplicationitem' table.
creditmemoitemid	String	The 'creditmemoitemid' column for the 'creditmemoapplicationitem' table.
journalentryid	String	The 'journalentryid' column for the 'creditmemoapplicationitem' table.
taxationitemid	String	The 'taxationitemid' column for the 'creditmemoapplicationitem' table.
applicationgroupid	String	The 'applicationgroupid' column for the 'creditmemoapplicationitem' table.
creditmemoapplicationid	String	The 'creditmemoapplicationid' column for the 'creditmemoapplicationitem' table.
effectivedate	Date	The 'effectivedate' column for the 'creditmemoapplicationitem' table.

A line item in a credit memo.

Columns

Name	Type	Description
description	String	The 'description' column for the 'creditmemoitem' table.
updateddate	Datetime	The 'updateddate' column for the 'creditmemoitem' table.
creditmemoid	String	The 'creditmemoid' column for the 'creditmemoitem' table.
taxcodename	String	The 'taxcodename' column for the 'creditmemoitem' table.
taxamount	Decimal	The 'taxamount' column for the 'creditmemoitem' table.
subscriptionid	String	The 'subscriptionid' column for the 'creditmemoitem' table.
createdbyid	String	The 'createdbyid' column for the 'creditmemoitem' table.
servicestartdate	Date	The 'servicestartdate' column for the 'creditmemoitem' table.
taxexemptamount	Decimal	The 'taxexemptamount' column for the 'creditmemoitem' table.
unappliedamount	Decimal	The 'unappliedamount' column for the 'creditmemoitem' table.
journalentryid	String	The 'journalentryid' column for the 'creditmemoitem' table.
taxmode	String	The 'taxmode' column for the 'creditmemoitem' table.
billtocontactsnapshotid	String	The 'billtocontactsnapshotid' column for the 'creditmemoitem' table.
rateplanchargeid	String	The 'rateplanchargeid' column for the 'creditmemoitem' table.
unitofmeasure	String	The 'unitofmeasure' column for the 'creditmemoitem' table.
serviceenddate	Date	The 'serviceenddate' column for the 'creditmemoitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'creditmemoitem' table.
beappliedbyothersamount	Decimal	The 'beappliedbyothersamount' column for the 'creditmemoitem' table.
deferredrevenueaccountingcodeid	String	The 'deferredrevenueaccountingcodeid' column for the 'creditmemoitem' table.
invoiceitemid	String	The 'invoiceitemid' column for the 'creditmemoitem' table.
quantity	Decimal	The 'quantity' column for the 'creditmemoitem' table.
chargename	String	The 'chargename' column for the 'creditmemoitem' table.
recognizedrevenueaccountingcodeid	String	The 'recognizedrevenueaccountingcodeid' column for the 'creditmemoitem' table.
appliedtoothersamount	Decimal	The 'appliedtoothersamount' column for the 'creditmemoitem' table.
soldtocontactsnapshotid	String	The 'soldtocontactsnapshotid' column for the 'creditmemoitem' table.
onaccountaccountingcodeid	String	The 'onaccountaccountingcodeid' column for the 'creditmemoitem' table.
chargedate	Datetime	The 'chargedate' column for the 'creditmemoitem' table.
unitprice	Decimal	The 'unitprice' column for the 'creditmemoitem' table.
productrateplanchargeid	String	The 'productrateplanchargeid' column for the 'creditmemoitem' table.
createddate	Datetime	The 'createddate' column for the 'creditmemoitem' table.
processingtype	String	The 'processingtype' column for the 'creditmemoitem' table.
appliedtoitemid	String	The 'appliedtoitemid' column for the 'creditmemoitem' table.
amountwithouttax	Decimal	The 'amountwithouttax' column for the 'creditmemoitem' table.
id	String	The 'id' column for the 'creditmemoitem' table.
sku	String	The 'sku' column for the 'creditmemoitem' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'creditmemoitem' table.

An applied or unapplied portion of a credit memo.

Columns

Name	Type	Description
debitmemoid	String	The 'debitmemoid' column for the 'creditmemopart' table.
accountid	String	The 'accountid' column for the 'creditmemopart' table.
createdbyid	String	The 'createdbyid' column for the 'creditmemopart' table.
updateddate	Datetime	The 'updateddate' column for the 'creditmemopart' table.
updatedbyid	String	The 'updatedbyid' column for the 'creditmemopart' table.
amount	Decimal	The 'amount' column for the 'creditmemopart' table.
createddate	Datetime	The 'createddate' column for the 'creditmemopart' table.
id	String	The 'id' column for the 'creditmemopart' table.
invoiceid	String	The 'invoiceid' column for the 'creditmemopart' table.
creditmemoid	String	The 'creditmemoid' column for the 'creditmemopart' table.

A portion of a credit memo that is applied to a line item in an invoice or a line item in a debit memo.

Columns

Name	Type	Description
updateddate	Datetime	The 'updateddate' column for the 'creditmemopartitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'creditmemopartitem' table.
amount	Decimal	The 'amount' column for the 'creditmemopartitem' table.
invoiceitemid	String	The 'invoiceitemid' column for the 'creditmemopartitem' table.
debitmemoitemid	String	The 'debitmemoitemid' column for the 'creditmemopartitem' table.
creditmemopartid	String	The 'creditmemopartid' column for the 'creditmemopartitem' table.
createdbyid	String	The 'createdbyid' column for the 'creditmemopartitem' table.
createddate	Datetime	The 'createddate' column for the 'creditmemopartitem' table.
credittaxationitemid	String	The 'credittaxationitemid' column for the 'creditmemopartitem' table.
debittaxationitemid	String	The 'debittaxationitemid' column for the 'creditmemopartitem' table.
id	String	The 'id' column for the 'creditmemopartitem' table.
creditmemoitemid	String	The 'creditmemoitemid' column for the 'creditmemopartitem' table.
taxationitemid	String	The 'taxationitemid' column for the 'creditmemopartitem' table.

A taxation line item in a credit memo.

Columns

Name	Type	Description
accountingcode	String	The 'accountingcode' column for the 'credittaxationitem' table.
updateddate	Datetime	The 'updateddate' column for the 'credittaxationitem' table.
name	String	The 'name' column for the 'credittaxationitem' table.
exemptamount	Decimal	The 'exemptamount' column for the 'credittaxationitem' table.
salestaxpayableaccountingcodeid	String	The 'salestaxpayableaccountingcodeid' column for the 'credittaxationitem' table.
taxamount	Decimal	The 'taxamount' column for the 'credittaxationitem' table.
taxcodedescription	String	The 'taxcodedescription' column for the 'credittaxationitem' table.
createdbyid	String	The 'createdbyid' column for the 'credittaxationitem' table.
taxcode	String	The 'taxcode' column for the 'credittaxationitem' table.
taxdate	Date	The 'taxdate' column for the 'credittaxationitem' table.
taxrate	Decimal	The 'taxrate' column for the 'credittaxationitem' table.
unappliedamount	Decimal	The 'unappliedamount' column for the 'credittaxationitem' table.
creditmemoitemid	String	The 'creditmemoitemid' column for the 'credittaxationitem' table.
journalentryid	String	The 'journalentryid' column for the 'credittaxationitem' table.
taxratetype	String	The 'taxratetype' column for the 'credittaxationitem' table.
taxationitemid	String	The 'taxationitemid' column for the 'credittaxationitem' table.
taxmode	String	The 'taxmode' column for the 'credittaxationitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'credittaxationitem' table.
appliedamount	Decimal	The 'appliedamount' column for the 'credittaxationitem' table.
locationcode	String	The 'locationcode' column for the 'credittaxationitem' table.
refundamount	Decimal	The 'refundamount' column for the 'credittaxationitem' table.
onaccountaccountingcodeid	String	The 'onaccountaccountingcodeid' column for the 'credittaxationitem' table.
jurisdiction	String	The 'jurisdiction' column for the 'credittaxationitem' table.
taxratedescription	String	The 'taxratedescription' column for the 'credittaxationitem' table.
createddate	Datetime	The 'createddate' column for the 'credittaxationitem' table.
id	String	The 'id' column for the 'credittaxationitem' table.
taxableitemsnapshotid	String	The 'taxableitemsnapshotid' column for the 'credittaxationitem' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'credittaxationitem' table.

A debit memo that is owned by a customer account.

Columns

Name	Type	Description
postedbyid	String	The 'postedbyid' column for the 'debitmemo' table.
accountid	String	The 'accountid' column for the 'debitmemo' table.
cancelledbyid	String	The 'cancelledbyid' column for the 'debitmemo' table.
updateddate	Datetime	The 'updateddate' column for the 'debitmemo' table.
transferredtoaccounting	String	The 'transferredtoaccounting' column for the 'debitmemo' table.
totaltaxexemptamount	Decimal	The 'totaltaxexemptamount' column for the 'debitmemo' table.
memonumber	String	The 'memonumber' column for the 'debitmemo' table.
taxmessage	String	The 'taxmessage' column for the 'debitmemo' table.
invoiceid	String	The 'invoiceid' column for the 'debitmemo' table.
source	String	The 'source' column for the 'debitmemo' table.
taxamount	Decimal	The 'taxamount' column for the 'debitmemo' table.
createdbyid	String	The 'createdbyid' column for the 'debitmemo' table.
exchangeratedate	Date	The 'exchangeratedate' column for the 'debitmemo' table.
cancelledon	Datetime	The 'cancelledon' column for the 'debitmemo' table.
duedate	Date	The 'duedate' column for the 'debitmemo' table.
totalamountwithouttax	Decimal	The 'totalamountwithouttax' column for the 'debitmemo' table.
postedon	Datetime	The 'postedon' column for the 'debitmemo' table.
billtocontactsnapshotid	String	The 'billtocontactsnapshotid' column for the 'debitmemo' table.
status	String	The 'status' column for the 'debitmemo' table.
memodate	Date	The 'memodate' column for the 'debitmemo' table.
comments	String	The 'comments' column for the 'debitmemo' table.
updatedbyid	String	The 'updatedbyid' column for the 'debitmemo' table.
autopay	Bool	The 'autopay' column for the 'debitmemo' table.
totalamount	Decimal	The 'totalamount' column for the 'debitmemo' table.
soldtocontactsnapshotid	String	The 'soldtocontactsnapshotid' column for the 'debitmemo' table.
reasoncode	String	The 'reasoncode' column for the 'debitmemo' table.
discountamount	Decimal	The 'discountamount' column for the 'debitmemo' table.
targetdate	Date	The 'targetdate' column for the 'debitmemo' table.
createddate	Datetime	The 'createddate' column for the 'debitmemo' table.
taxstatus	String	The 'taxstatus' column for the 'debitmemo' table.
id	String	The 'id' column for the 'debitmemo' table.
balance	Decimal	The 'balance' column for the 'debitmemo' table.
retrystatus_c	String	The 'retrystatus__c' column for the 'debitmemo' table.

A line item in a debit memo.

Columns

Name	Type	Description
description	String	The 'description' column for the 'debitmemoitem' table.
updateddate	Datetime	The 'updateddate' column for the 'debitmemoitem' table.
taxcodename	String	The 'taxcodename' column for the 'debitmemoitem' table.
taxamount	Decimal	The 'taxamount' column for the 'debitmemoitem' table.
subscriptionid	String	The 'subscriptionid' column for the 'debitmemoitem' table.
createdbyid	String	The 'createdbyid' column for the 'debitmemoitem' table.
servicestartdate	Date	The 'servicestartdate' column for the 'debitmemoitem' table.
taxexemptamount	Decimal	The 'taxexemptamount' column for the 'debitmemoitem' table.
journalentryid	String	The 'journalentryid' column for the 'debitmemoitem' table.
taxmode	String	The 'taxmode' column for the 'debitmemoitem' table.
billtocontactsnapshotid	String	The 'billtocontactsnapshotid' column for the 'debitmemoitem' table.
debitmemoid	String	The 'debitmemoid' column for the 'debitmemoitem' table.
rateplanchargeid	String	The 'rateplanchargeid' column for the 'debitmemoitem' table.
unitofmeasure	String	The 'unitofmeasure' column for the 'debitmemoitem' table.
serviceenddate	Date	The 'serviceenddate' column for the 'debitmemoitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'debitmemoitem' table.
beappliedbyothersamount	Decimal	The 'beappliedbyothersamount' column for the 'debitmemoitem' table.
deferredrevenueaccountingcodeid	String	The 'deferredrevenueaccountingcodeid' column for the 'debitmemoitem' table.
invoiceitemid	String	The 'invoiceitemid' column for the 'debitmemoitem' table.
quantity	Decimal	The 'quantity' column for the 'debitmemoitem' table.
chargename	String	The 'chargename' column for the 'debitmemoitem' table.
recognizedrevenueaccountingcodeid	String	The 'recognizedrevenueaccountingcodeid' column for the 'debitmemoitem' table.
appliedtoothersamount	Decimal	The 'appliedtoothersamount' column for the 'debitmemoitem' table.
soldtocontactsnapshotid	String	The 'soldtocontactsnapshotid' column for the 'debitmemoitem' table.
chargedate	Datetime	The 'chargedate' column for the 'debitmemoitem' table.
unitprice	Decimal	The 'unitprice' column for the 'debitmemoitem' table.
productrateplanchargeid	String	The 'productrateplanchargeid' column for the 'debitmemoitem' table.
createddate	Datetime	The 'createddate' column for the 'debitmemoitem' table.
processingtype	String	The 'processingtype' column for the 'debitmemoitem' table.
amountwithouttax	Decimal	The 'amountwithouttax' column for the 'debitmemoitem' table.
id	String	The 'id' column for the 'debitmemoitem' table.
sku	String	The 'sku' column for the 'debitmemoitem' table.
balance	Decimal	The 'balance' column for the 'debitmemoitem' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'debitmemoitem' table.

A taxation line item in a debit memo.

Columns

Name	Type	Description
accountingcode	String	The 'accountingcode' column for the 'debittaxationitem' table.
updateddate	Datetime	The 'updateddate' column for the 'debittaxationitem' table.
creditamount	Decimal	The 'creditamount' column for the 'debittaxationitem' table.
debitmemoitemid	String	The 'debitmemoitemid' column for the 'debittaxationitem' table.
paymentamount	Decimal	The 'paymentamount' column for the 'debittaxationitem' table.
name	String	The 'name' column for the 'debittaxationitem' table.
exemptamount	Decimal	The 'exemptamount' column for the 'debittaxationitem' table.
salestaxpayableaccountingcodeid	String	The 'salestaxpayableaccountingcodeid' column for the 'debittaxationitem' table.
taxamount	Decimal	The 'taxamount' column for the 'debittaxationitem' table.
taxcodedescription	String	The 'taxcodedescription' column for the 'debittaxationitem' table.
createdbyid	String	The 'createdbyid' column for the 'debittaxationitem' table.
taxcode	String	The 'taxcode' column for the 'debittaxationitem' table.
taxdate	Date	The 'taxdate' column for the 'debittaxationitem' table.
taxrate	Decimal	The 'taxrate' column for the 'debittaxationitem' table.
journalentryid	String	The 'journalentryid' column for the 'debittaxationitem' table.
taxratetype	String	The 'taxratetype' column for the 'debittaxationitem' table.
taxationitemid	String	The 'taxationitemid' column for the 'debittaxationitem' table.
taxmode	String	The 'taxmode' column for the 'debittaxationitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'debittaxationitem' table.
locationcode	String	The 'locationcode' column for the 'debittaxationitem' table.
jurisdiction	String	The 'jurisdiction' column for the 'debittaxationitem' table.
taxratedescription	String	The 'taxratedescription' column for the 'debittaxationitem' table.
createddate	Datetime	The 'createddate' column for the 'debittaxationitem' table.
id	String	The 'id' column for the 'debittaxationitem' table.
balance	Decimal	The 'balance' column for the 'debittaxationitem' table.
taxableitemsnapshotid	String	The 'taxableitemsnapshotid' column for the 'debittaxationitem' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'debittaxationitem' table.

A discount rate plan charge that is applied to another rate plan charge.

Columns

Name	Type	Description
discountrateplanchargeid	String	The 'discountrateplanchargeid' column for the 'discountappliedmetrics' table.
startdate	Date	The 'startdate' column for the 'discountappliedmetrics' table.
rateplanchargeid	String	The 'rateplanchargeid' column for the 'discountappliedmetrics' table.
createdbyid	String	The 'createdbyid' column for the 'discountappliedmetrics' table.
updateddate	Datetime	The 'updateddate' column for the 'discountappliedmetrics' table.
tcv	Decimal	The 'tcv' column for the 'discountappliedmetrics' table.
updatedbyid	String	The 'updatedbyid' column for the 'discountappliedmetrics' table.
createddate	Datetime	The 'createddate' column for the 'discountappliedmetrics' table.
id	String	The 'id' column for the 'discountappliedmetrics' table.
mrr	Decimal	The 'mrr' column for the 'discountappliedmetrics' table.
enddate	Date	The 'enddate' column for the 'discountappliedmetrics' table.

Details for the applied discount.

Columns

Name	Type	Description
rateplanchargeid	String	The 'rateplanchargeid' column for the 'discountapplydetail' table.
appliedproductrateplanid	String	The 'appliedproductrateplanid' column for the 'discountapplydetail' table.
createdbyid	String	The 'createdbyid' column for the 'discountapplydetail' table.
updateddate	Datetime	The 'updateddate' column for the 'discountapplydetail' table.
updatedbyid	String	The 'updatedbyid' column for the 'discountapplydetail' table.
createddate	Datetime	The 'createddate' column for the 'discountapplydetail' table.
appliedproductrateplanchargeid	String	The 'appliedproductrateplanchargeid' column for the 'discountapplydetail' table.
id	String	The 'id' column for the 'discountapplydetail' table.

Each row of this table represents a feature.

Columns

Name	Type	Description
status	String	The 'status' column for the 'feature' table.
description	String	The 'description' column for the 'feature' table.
createdbyid	String	The 'createdbyid' column for the 'feature' table.
featuretype_c	String	The 'featuretype__c' column for the 'feature' table.
updateddate	Datetime	The 'updateddate' column for the 'feature' table.
updatedbyid	String	The 'updatedbyid' column for the 'feature' table.
createddate	Datetime	The 'createddate' column for the 'feature' table.
featurecode	String	The 'featurecode' column for the 'feature' table.
id	String	The 'id' column for the 'feature' table.
name	String	The 'name' column for the 'feature' table.

A custom exchange rate.

Columns

Name	Type	Description
ratedate	Date	The 'ratedate' column for the 'fxcustomrate' table.
createdbyid	String	The 'createdbyid' column for the 'fxcustomrate' table.
updateddate	Datetime	The 'updateddate' column for the 'fxcustomrate' table.
rate	Decimal	The 'rate' column for the 'fxcustomrate' table.
updatedbyid	String	The 'updatedbyid' column for the 'fxcustomrate' table.
createddate	Datetime	The 'createddate' column for the 'fxcustomrate' table.
currencyfrom	String	The 'currencyfrom' column for the 'fxcustomrate' table.
id	String	The 'id' column for the 'fxcustomrate' table.
currencyto	String	The 'currencyto' column for the 'fxcustomrate' table.

An invoice represents a bill to a customer.

Columns

Name	Type	Description
accountid	String	The 'accountid' column for the 'invoice' table.
updateddate	Datetime	The 'updateddate' column for the 'invoice' table.
includesrecurring	Bool	The 'includesrecurring' column for the 'invoice' table.
sourceid	String	The 'sourceid' column for the 'invoice' table.
transferredtoaccounting	String	The 'transferredtoaccounting' column for the 'invoice' table.
taxmessage	String	The 'taxmessage' column for the 'invoice' table.
paymentamount	Decimal	The 'paymentamount' column for the 'invoice' table.
source	String	The 'source' column for the 'invoice' table.
taxamount	Decimal	The 'taxamount' column for the 'invoice' table.
createdbyid	String	The 'createdbyid' column for the 'invoice' table.
postedby	String	The 'postedby' column for the 'invoice' table.
adjustmentamount	Decimal	The 'adjustmentamount' column for the 'invoice' table.
taxexemptamount	Decimal	The 'taxexemptamount' column for the 'invoice' table.
invoicedate	Date	The 'invoicedate' column for the 'invoice' table.
invoicenumber	String	The 'invoicenumber' column for the 'invoice' table.
duedate	Date	The 'duedate' column for the 'invoice' table.
billtocontactsnapshotid	String	The 'billtocontactsnapshotid' column for the 'invoice' table.
lastemailsentdate	Datetime	The 'lastemailsentdate' column for the 'invoice' table.
status	String	The 'status' column for the 'invoice' table.
comments	String	The 'comments' column for the 'invoice' table.
updatedbyid	String	The 'updatedbyid' column for the 'invoice' table.
amount	Decimal	The 'amount' column for the 'invoice' table.
includesusage	Bool	The 'includesusage' column for the 'invoice' table.
refundamount	Decimal	The 'refundamount' column for the 'invoice' table.
autopay	Bool	The 'autopay' column for the 'invoice' table.
soldtocontactsnapshotid	String	The 'soldtocontactsnapshotid' column for the 'invoice' table.
reversed	Bool	The 'reversed' column for the 'invoice' table.
targetdate	Date	The 'targetdate' column for the 'invoice' table.
createddate	Datetime	The 'createddate' column for the 'invoice' table.
includesonetime	Bool	The 'includesonetime' column for the 'invoice' table.
posteddate	Datetime	The 'posteddate' column for the 'invoice' table.
taxstatus	String	The 'taxstatus' column for the 'invoice' table.
amountwithouttax	Decimal	The 'amountwithouttax' column for the 'invoice' table.
creditbalanceadjustmentamount	Decimal	The 'creditbalanceadjustmentamount' column for the 'invoice' table.
id	String	The 'id' column for the 'invoice' table.
balance	Decimal	The 'balance' column for the 'invoice' table.
retrystatus_c	String	The 'retrystatus__c' column for the 'invoice' table.

An adjustment to an invoice.

Columns

Name	Type	Description
impactamount	Decimal	The 'impactamount' column for the 'invoiceadjustment' table.
accountid	String	The 'accountid' column for the 'invoiceadjustment' table.
cancelledbyid	String	The 'cancelledbyid' column for the 'invoiceadjustment' table.
accountingcode	String	The 'accountingcode' column for the 'invoiceadjustment' table.
updateddate	Datetime	The 'updateddate' column for the 'invoiceadjustment' table.
transferredtoaccounting	String	The 'transferredtoaccounting' column for the 'invoiceadjustment' table.
invoiceid	String	The 'invoiceid' column for the 'invoiceadjustment' table.
adjustmentnumber	String	The 'adjustmentnumber' column for the 'invoiceadjustment' table.
createdbyid	String	The 'createdbyid' column for the 'invoiceadjustment' table.
referenceid	String	The 'referenceid' column for the 'invoiceadjustment' table.
adjustmentdate	Date	The 'adjustmentdate' column for the 'invoiceadjustment' table.
invoicenumber	String	The 'invoicenumber' column for the 'invoiceadjustment' table.
cancelledon	Datetime	The 'cancelledon' column for the 'invoiceadjustment' table.
journalentryid	String	The 'journalentryid' column for the 'invoiceadjustment' table.
status	String	The 'status' column for the 'invoiceadjustment' table.
comments	String	The 'comments' column for the 'invoiceadjustment' table.
updatedbyid	String	The 'updatedbyid' column for the 'invoiceadjustment' table.
amount	Decimal	The 'amount' column for the 'invoiceadjustment' table.
deferredrevenueaccountingcodeid	String	The 'deferredrevenueaccountingcodeid' column for the 'invoiceadjustment' table.
reasoncode	String	The 'reasoncode' column for the 'invoiceadjustment' table.
type	String	The 'type' column for the 'invoiceadjustment' table.
createddate	Datetime	The 'createddate' column for the 'invoiceadjustment' table.
id	String	The 'id' column for the 'invoiceadjustment' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'invoiceadjustment' table.

A line item in an invoice.

Columns

Name	Type	Description
soldtocontactid	String	The 'soldtocontactid' column for the 'invoiceitem' table.
accountid	String	The 'accountid' column for the 'invoiceitem' table.
accountingcode	String	The 'accountingcode' column for the 'invoiceitem' table.
updateddate	Datetime	The 'updateddate' column for the 'invoiceitem' table.
productid	String	The 'productid' column for the 'invoiceitem' table.
invoiceid	String	The 'invoiceid' column for the 'invoiceitem' table.
chargeamount	Decimal	The 'chargeamount' column for the 'invoiceitem' table.
taxamount	Decimal	The 'taxamount' column for the 'invoiceitem' table.
subscriptionid	String	The 'subscriptionid' column for the 'invoiceitem' table.
createdbyid	String	The 'createdbyid' column for the 'invoiceitem' table.
taxcode	String	The 'taxcode' column for the 'invoiceitem' table.
revrecstartdate	Date	The 'revrecstartdate' column for the 'invoiceitem' table.
servicestartdate	Date	The 'servicestartdate' column for the 'invoiceitem' table.
taxexemptamount	Decimal	The 'taxexemptamount' column for the 'invoiceitem' table.
journalentryid	String	The 'journalentryid' column for the 'invoiceitem' table.
defaultpaymentmethodid	String	The 'defaultpaymentmethodid' column for the 'invoiceitem' table.
parentaccountid	String	The 'parentaccountid' column for the 'invoiceitem' table.
taxmode	String	The 'taxmode' column for the 'invoiceitem' table.
billtocontactsnapshotid	String	The 'billtocontactsnapshotid' column for the 'invoiceitem' table.
amendmentid	String	The 'amendmentid' column for the 'invoiceitem' table.
appliedtoinvoiceitemid	String	The 'appliedtoinvoiceitemid' column for the 'invoiceitem' table.
rateplanchargeid	String	The 'rateplanchargeid' column for the 'invoiceitem' table.
serviceenddate	Date	The 'serviceenddate' column for the 'invoiceitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'invoiceitem' table.
deferredrevenueaccountingcodeid	String	The 'deferredrevenueaccountingcodeid' column for the 'invoiceitem' table.
productrateplanid	String	The 'productrateplanid' column for the 'invoiceitem' table.
quantity	Decimal	The 'quantity' column for the 'invoiceitem' table.
chargename	String	The 'chargename' column for the 'invoiceitem' table.
recognizedrevenueaccountingcodeid	String	The 'recognizedrevenueaccountingcodeid' column for the 'invoiceitem' table.
billtocontactid	String	The 'billtocontactid' column for the 'invoiceitem' table.
soldtocontactsnapshotid	String	The 'soldtocontactsnapshotid' column for the 'invoiceitem' table.
rateplanid	String	The 'rateplanid' column for the 'invoiceitem' table.
chargedate	Datetime	The 'chargedate' column for the 'invoiceitem' table.
uom	String	The 'uom' column for the 'invoiceitem' table.
unitprice	Decimal	The 'unitprice' column for the 'invoiceitem' table.
productrateplanchargeid	String	The 'productrateplanchargeid' column for the 'invoiceitem' table.
createddate	Datetime	The 'createddate' column for the 'invoiceitem' table.
processingtype	String	The 'processingtype' column for the 'invoiceitem' table.
id	String	The 'id' column for the 'invoiceitem' table.
sku	String	The 'sku' column for the 'invoiceitem' table.
balance	Decimal	The 'balance' column for the 'invoiceitem' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'invoiceitem' table.

An adjustment to a line item in an invoice.

Columns

Name	Type	Description
accountid	String	The 'accountid' column for the 'invoiceitemadjustment' table.
cancelledbyid	String	The 'cancelledbyid' column for the 'invoiceitemadjustment' table.
accountingcode	String	The 'accountingcode' column for the 'invoiceitemadjustment' table.
updateddate	Datetime	The 'updateddate' column for the 'invoiceitemadjustment' table.
sourceid	String	The 'sourceid' column for the 'invoiceitemadjustment' table.
sourcetype	String	The 'sourcetype' column for the 'invoiceitemadjustment' table.
transferredtoaccounting	String	The 'transferredtoaccounting' column for the 'invoiceitemadjustment' table.
invoiceid	String	The 'invoiceid' column for the 'invoiceitemadjustment' table.
adjustmentnumber	String	The 'adjustmentnumber' column for the 'invoiceitemadjustment' table.
salestaxpayableaccountingcodeid	String	The 'salestaxpayableaccountingcodeid' column for the 'invoiceitemadjustment' table.
createdbyid	String	The 'createdbyid' column for the 'invoiceitemadjustment' table.
referenceid	String	The 'referenceid' column for the 'invoiceitemadjustment' table.
servicestartdate	Date	The 'servicestartdate' column for the 'invoiceitemadjustment' table.
adjustmentdate	Date	The 'adjustmentdate' column for the 'invoiceitemadjustment' table.
invoicenumber	String	The 'invoicenumber' column for the 'invoiceitemadjustment' table.
journalentryid	String	The 'journalentryid' column for the 'invoiceitemadjustment' table.
taxationitemid	String	The 'taxationitemid' column for the 'invoiceitemadjustment' table.
cancelleddate	Datetime	The 'cancelleddate' column for the 'invoiceitemadjustment' table.
status	String	The 'status' column for the 'invoiceitemadjustment' table.
comment	String	The 'comment' column for the 'invoiceitemadjustment' table.
serviceenddate	Date	The 'serviceenddate' column for the 'invoiceitemadjustment' table.
updatedbyid	String	The 'updatedbyid' column for the 'invoiceitemadjustment' table.
amount	Decimal	The 'amount' column for the 'invoiceitemadjustment' table.
deferredrevenueaccountingcodeid	String	The 'deferredrevenueaccountingcodeid' column for the 'invoiceitemadjustment' table.
invoiceitemid	String	The 'invoiceitemid' column for the 'invoiceitemadjustment' table.
recognizedrevenueaccountingcodeid	String	The 'recognizedrevenueaccountingcodeid' column for the 'invoiceitemadjustment' table.
reasoncode	String	The 'reasoncode' column for the 'invoiceitemadjustment' table.
invoiceitemname	String	The 'invoiceitemname' column for the 'invoiceitemadjustment' table.
type	String	The 'type' column for the 'invoiceitemadjustment' table.
createddate	Datetime	The 'createddate' column for the 'invoiceitemadjustment' table.
id	String	The 'id' column for the 'invoiceitemadjustment' table.
taxableitemsnapshotid	String	The 'taxableitemsnapshotid' column for the 'invoiceitemadjustment' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'invoiceitemadjustment' table.

A payment that is applied to an invoice.

Columns

Name	Type	Description
updateddate	Datetime	The 'updateddate' column for the 'invoicepayment' table.
updatedbyid	String	The 'updatedbyid' column for the 'invoicepayment' table.
amount	Decimal	The 'amount' column for the 'invoicepayment' table.
paymentid	String	The 'paymentid' column for the 'invoicepayment' table.
refundamount	Decimal	The 'refundamount' column for the 'invoicepayment' table.
invoiceid	String	The 'invoiceid' column for the 'invoicepayment' table.
cashaccountingcodeid	String	The 'cashaccountingcodeid' column for the 'invoicepayment' table.
createdbyid	String	The 'createdbyid' column for the 'invoicepayment' table.
createddate	Datetime	The 'createddate' column for the 'invoicepayment' table.
id	String	The 'id' column for the 'invoicepayment' table.
journalentryid	String	The 'journalentryid' column for the 'invoicepayment' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'invoicepayment' table.

A journal entry.

Columns

Name	Type	Description
status	String	The 'status' column for the 'journalentry' table.
transactiontype	String	The 'transactiontype' column for the 'journalentry' table.
transferredby	String	The 'transferredby' column for the 'journalentry' table.
updateddate	Datetime	The 'updateddate' column for the 'journalentry' table.
updatedbyid	String	The 'updatedbyid' column for the 'journalentry' table.
transferredtoaccounting	String	The 'transferredtoaccounting' column for the 'journalentry' table.
product_s	String	The 'product__s' column for the 'journalentry' table.
createdbyid	String	The 'createdbyid' column for the 'journalentry' table.
number	String	The 'number' column for the 'journalentry' table.
currency	String	The 'currency' column for the 'journalentry' table.
createddate	Datetime	The 'createddate' column for the 'journalentry' table.
transferdate	Datetime	The 'transferdate' column for the 'journalentry' table.
journalentrydate	Date	The 'journalentrydate' column for the 'journalentry' table.
homecurrency	String	The 'homecurrency' column for the 'journalentry' table.
id	String	The 'id' column for the 'journalentry' table.
accountingperiodid	String	The 'accountingperiodid' column for the 'journalentry' table.
entity_s	String	The 'entity__s' column for the 'journalentry' table.
notes	String	The 'notes' column for the 'journalentry' table.
journalrunid	String	The 'journalrunid' column for the 'journalentry' table.
transactioncount	String	The 'transactioncount' column for the 'journalentry' table.

A line item in a journal entry.

Columns

Name	Type	Description
updateddate	Datetime	The 'updateddate' column for the 'journalentryitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'journalentryitem' table.
amount	Decimal	The 'amount' column for the 'journalentryitem' table.
type	String	The 'type' column for the 'journalentryitem' table.
amounthomecurrency	Decimal	The 'amounthomecurrency' column for the 'journalentryitem' table.
accountingcodeid	String	The 'accountingcodeid' column for the 'journalentryitem' table.
createdbyid	String	The 'createdbyid' column for the 'journalentryitem' table.
currency	String	The 'currency' column for the 'journalentryitem' table.
createddate	Datetime	The 'createddate' column for the 'journalentryitem' table.
homecurrency	String	The 'homecurrency' column for the 'journalentryitem' table.
id	String	The 'id' column for the 'journalentryitem' table.
journalentryid	String	The 'journalentryid' column for the 'journalentryitem' table.

A journal run.

Columns

Name	Type	Description
status	String	The 'status' column for the 'journalrun' table.
targetstartdate	Date	The 'targetstartdate' column for the 'journalrun' table.
processenddatetime	Datetime	The 'processenddatetime' column for the 'journalrun' table.
targetdatetype	String	The 'targetdatetype' column for the 'journalrun' table.
updateddate	Datetime	The 'updateddate' column for the 'journalrun' table.
targetenddate	Date	The 'targetenddate' column for the 'journalrun' table.
updatedbyid	String	The 'updatedbyid' column for the 'journalrun' table.
totaljournalentrycount	String	The 'totaljournalentrycount' column for the 'journalrun' table.
createdbyid	String	The 'createdbyid' column for the 'journalrun' table.
number	String	The 'number' column for the 'journalrun' table.
createddate	Datetime	The 'createddate' column for the 'journalrun' table.
id	String	The 'id' column for the 'journalrun' table.
processstartdatetime	Datetime	The 'processstartdatetime' column for the 'journalrun' table.

An order action that is applied to a subscription.

Columns

Name	Type	Description
currenttermperiodtype	String	The 'currenttermperiodtype' column for the 'orderaction' table.
updateddate	Datetime	The 'updateddate' column for the 'orderaction' table.
autorenew	Bool	The 'autorenew' column for the 'orderaction' table.
renewaltermperiodtype	String	The 'renewaltermperiodtype' column for the 'orderaction' table.
serviceactivationdate	Date	The 'serviceactivationdate' column for the 'orderaction' table.
resumedate	Date	The 'resumedate' column for the 'orderaction' table.
suspenddate	Date	The 'suspenddate' column for the 'orderaction' table.
termtype	String	The 'termtype' column for the 'orderaction' table.
renewsetting	String	The 'renewsetting' column for the 'orderaction' table.
contracteffectivedate	Date	The 'contracteffectivedate' column for the 'orderaction' table.
subscriptionversionamendmentid	String	The 'subscriptionversionamendmentid' column for the 'orderaction' table.
customeracceptancedate	Date	The 'customeracceptancedate' column for the 'orderaction' table.
subscriptionid	String	The 'subscriptionid' column for the 'orderaction' table.
createdbyid	String	The 'createdbyid' column for the 'orderaction' table.
currentterm	String	The 'currentterm' column for the 'orderaction' table.
cancellationpolicy	String	The 'cancellationpolicy' column for the 'orderaction' table.
cancellationeffectivedate	Date	The 'cancellationeffectivedate' column for the 'orderaction' table.
updatedbyid	String	The 'updatedbyid' column for the 'orderaction' table.
sequence	String	The 'sequence' column for the 'orderaction' table.
orderid	String	The 'orderid' column for the 'orderaction' table.
type	String	The 'type' column for the 'orderaction' table.
termstartdate	Date	The 'termstartdate' column for the 'orderaction' table.
createddate	Datetime	The 'createddate' column for the 'orderaction' table.
renewalterm	String	The 'renewalterm' column for the 'orderaction' table.
id	String	The 'id' column for the 'orderaction' table.

An extended list price metric for an order action.

Columns

Name	Type	Description
rateplanchargeid	String	The 'rateplanchargeid' column for the 'orderelp' table.
subscriptionownerid	String	The 'subscriptionownerid' column for the 'orderelp' table.
updateddate	Datetime	The 'updateddate' column for the 'orderelp' table.
updatedbyid	String	The 'updatedbyid' column for the 'orderelp' table.
orderactionid	String	The 'orderactionid' column for the 'orderelp' table.
tax	Decimal	The 'tax' column for the 'orderelp' table.
term	String	The 'term' column for the 'orderelp' table.
enddate	Date	The 'enddate' column for the 'orderelp' table.
generatedreason	String	The 'generatedreason' column for the 'orderelp' table.
startdate	Date	The 'startdate' column for the 'orderelp' table.
type	String	The 'type' column for the 'orderelp' table.
createdbyid	String	The 'createdbyid' column for the 'orderelp' table.
createddate	Datetime	The 'createddate' column for the 'orderelp' table.
value	Decimal	The 'value' column for the 'orderelp' table.
id	String	The 'id' column for the 'orderelp' table.
invoiceownerid	String	The 'invoiceownerid' column for the 'orderelp' table.
orderitemid	String	The 'orderitemid' column for the 'orderelp' table.

An order item.

Columns

Name	Type	Description
startdate	Date	The 'startdate' column for the 'orderitem' table.
rateplanchargeid	String	The 'rateplanchargeid' column for the 'orderitem' table.
createdbyid	String	The 'createdbyid' column for the 'orderitem' table.
updateddate	Datetime	The 'updateddate' column for the 'orderitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'orderitem' table.
createddate	Datetime	The 'createddate' column for the 'orderitem' table.
orderactionid	String	The 'orderactionid' column for the 'orderitem' table.
quantity	Decimal	The 'quantity' column for the 'orderitem' table.
id	String	The 'id' column for the 'orderitem' table.
enddate	Date	The 'enddate' column for the 'orderitem' table.

A monthly recurring revenue metric for an order action.

Columns

Name	Type	Description
rateplanchargeid	String	The 'rateplanchargeid' column for the 'ordermrr' table.
subscriptionownerid	String	The 'subscriptionownerid' column for the 'ordermrr' table.
updateddate	Datetime	The 'updateddate' column for the 'ordermrr' table.
updatedbyid	String	The 'updatedbyid' column for the 'ordermrr' table.
orderactionid	String	The 'orderactionid' column for the 'ordermrr' table.
discountchargeid	String	The 'discountchargeid' column for the 'ordermrr' table.
term	String	The 'term' column for the 'ordermrr' table.
enddate	Date	The 'enddate' column for the 'ordermrr' table.
generatedreason	String	The 'generatedreason' column for the 'ordermrr' table.
startdate	Date	The 'startdate' column for the 'ordermrr' table.
type	String	The 'type' column for the 'ordermrr' table.
createdbyid	String	The 'createdbyid' column for the 'ordermrr' table.
createddate	Datetime	The 'createddate' column for the 'ordermrr' table.
value	Decimal	The 'value' column for the 'ordermrr' table.
id	String	The 'id' column for the 'ordermrr' table.
invoiceownerid	String	The 'invoiceownerid' column for the 'ordermrr' table.
orderitemid	String	The 'orderitemid' column for the 'ordermrr' table.

A quantity metric for an order action.

Columns

Name	Type	Description
rateplanchargeid	String	The 'rateplanchargeid' column for the 'orderquantity' table.
subscriptionownerid	String	The 'subscriptionownerid' column for the 'orderquantity' table.
updateddate	Datetime	The 'updateddate' column for the 'orderquantity' table.
updatedbyid	String	The 'updatedbyid' column for the 'orderquantity' table.
orderactionid	String	The 'orderactionid' column for the 'orderquantity' table.
term	String	The 'term' column for the 'orderquantity' table.
enddate	Date	The 'enddate' column for the 'orderquantity' table.
generatedreason	String	The 'generatedreason' column for the 'orderquantity' table.
startdate	Date	The 'startdate' column for the 'orderquantity' table.
createdbyid	String	The 'createdbyid' column for the 'orderquantity' table.
createddate	Datetime	The 'createddate' column for the 'orderquantity' table.
value	Decimal	The 'value' column for the 'orderquantity' table.
id	String	The 'id' column for the 'orderquantity' table.
invoiceownerid	String	The 'invoiceownerid' column for the 'orderquantity' table.
orderitemid	String	The 'orderitemid' column for the 'orderquantity' table.

Each row of this table represents an order.

Columns

Name	Type	Description
status	String	The 'status' column for the 'orders' table.
createdbymigration	Bool	The 'createdbymigration' column for the 'orders' table.
accountid	String	The 'accountid' column for the 'orders' table.
description	String	The 'description' column for the 'orders' table.
createdbyid	String	The 'createdbyid' column for the 'orders' table.
updateddate	Datetime	The 'updateddate' column for the 'orders' table.
updatedbyid	String	The 'updatedbyid' column for the 'orders' table.
createddate	Datetime	The 'createddate' column for the 'orders' table.
ordernumber	String	The 'ordernumber' column for the 'orders' table.
id	String	The 'id' column for the 'orders' table.
orderdate	Date	The 'orderdate' column for the 'orders' table.

A total contracted billing metric for an order action.

Columns

Name	Type	Description
rateplanchargeid	String	The 'rateplanchargeid' column for the 'ordertcb' table.
subscriptionownerid	String	The 'subscriptionownerid' column for the 'ordertcb' table.
updateddate	Datetime	The 'updateddate' column for the 'ordertcb' table.
updatedbyid	String	The 'updatedbyid' column for the 'ordertcb' table.
orderactionid	String	The 'orderactionid' column for the 'ordertcb' table.
tax	Decimal	The 'tax' column for the 'ordertcb' table.
discountchargeid	String	The 'discountchargeid' column for the 'ordertcb' table.
term	String	The 'term' column for the 'ordertcb' table.
enddate	Date	The 'enddate' column for the 'ordertcb' table.
generatedreason	String	The 'generatedreason' column for the 'ordertcb' table.
startdate	Date	The 'startdate' column for the 'ordertcb' table.
type	String	The 'type' column for the 'ordertcb' table.
createdbyid	String	The 'createdbyid' column for the 'ordertcb' table.
createddate	Datetime	The 'createddate' column for the 'ordertcb' table.
value	Decimal	The 'value' column for the 'ordertcb' table.
id	String	The 'id' column for the 'ordertcb' table.
invoiceownerid	String	The 'invoiceownerid' column for the 'ordertcb' table.
orderitemid	String	The 'orderitemid' column for the 'ordertcb' table.

A total contract value metric for an order action.

Columns

Name	Type	Description
rateplanchargeid	String	The 'rateplanchargeid' column for the 'ordertcv' table.
subscriptionownerid	String	The 'subscriptionownerid' column for the 'ordertcv' table.
updateddate	Datetime	The 'updateddate' column for the 'ordertcv' table.
updatedbyid	String	The 'updatedbyid' column for the 'ordertcv' table.
orderactionid	String	The 'orderactionid' column for the 'ordertcv' table.
discountchargeid	String	The 'discountchargeid' column for the 'ordertcv' table.
term	String	The 'term' column for the 'ordertcv' table.
enddate	Date	The 'enddate' column for the 'ordertcv' table.
generatedreason	String	The 'generatedreason' column for the 'ordertcv' table.
startdate	Date	The 'startdate' column for the 'ordertcv' table.
type	String	The 'type' column for the 'ordertcv' table.
createdbyid	String	The 'createdbyid' column for the 'ordertcv' table.
createddate	Datetime	The 'createddate' column for the 'ordertcv' table.
value	Decimal	The 'value' column for the 'ordertcv' table.
id	String	The 'id' column for the 'ordertcv' table.
invoiceownerid	String	The 'invoiceownerid' column for the 'ordertcv' table.
orderitemid	String	The 'orderitemid' column for the 'ordertcv' table.

Each row of this table represents a payment.

Columns

Name	Type	Description
accountid	String	The 'accountid' column for the 'payment' table.
accountingcode	String	The 'accountingcode' column for the 'payment' table.
paymentmethodid	String	The 'paymentmethodid' column for the 'payment' table.
updateddate	Datetime	The 'updateddate' column for the 'payment' table.
markedforsubmissionon	Datetime	The 'markedforsubmissionon' column for the 'payment' table.
transferredtoaccounting	String	The 'transferredtoaccounting' column for the 'payment' table.
appliedcreditbalanceamount	Decimal	The 'appliedcreditbalanceamount' column for the 'payment' table.
referencedpaymentid	String	The 'referencedpaymentid' column for the 'payment' table.
softdescriptor	String	The 'softdescriptor' column for the 'payment' table.
source	String	The 'source' column for the 'payment' table.
secondpaymentreferenceid	String	The 'secondpaymentreferenceid' column for the 'payment' table.
gatewayreconciliationreason	String	The 'gatewayreconciliationreason' column for the 'payment' table.
gatewaystate	String	The 'gatewaystate' column for the 'payment' table.
createdbyid	String	The 'createdbyid' column for the 'payment' table.
referenceid	String	The 'referenceid' column for the 'payment' table.
softdescriptorphone	String	The 'softdescriptorphone' column for the 'payment' table.
gateway	String	The 'gateway' column for the 'payment' table.
currency	String	The 'currency' column for the 'payment' table.
gatewayreconciliationstatus	String	The 'gatewayreconciliationstatus' column for the 'payment' table.
authtransactionid	String	The 'authtransactionid' column for the 'payment' table.
bankidentificationnumber	String	The 'bankidentificationnumber' column for the 'payment' table.
unappliedamount	Decimal	The 'unappliedamount' column for the 'payment' table.
cancelledon	Datetime	The 'cancelledon' column for the 'payment' table.
gatewayresponsecode	String	The 'gatewayresponsecode' column for the 'payment' table.
gatewayresponse	String	The 'gatewayresponse' column for the 'payment' table.
status	String	The 'status' column for the 'payment' table.
comment	String	The 'comment' column for the 'payment' table.
retrynumber_c	String	The 'retrynumber__c' column for the 'payment' table.
submittedon	Datetime	The 'submittedon' column for the 'payment' table.
gatewayorderid	String	The 'gatewayorderid' column for the 'payment' table.
payoutid	String	The 'payoutid' column for the 'payment' table.
updatedbyid	String	The 'updatedbyid' column for the 'payment' table.
amount	Decimal	The 'amount' column for the 'payment' table.
appliedamount	Decimal	The 'appliedamount' column for the 'payment' table.
sourcename	String	The 'sourcename' column for the 'payment' table.
refundamount	Decimal	The 'refundamount' column for the 'payment' table.
type	String	The 'type' column for the 'payment' table.
paymentmethodsnapshotid	String	The 'paymentmethodsnapshotid' column for the 'payment' table.
settledon	Datetime	The 'settledon' column for the 'payment' table.
createddate	Datetime	The 'createddate' column for the 'payment' table.
id	String	The 'id' column for the 'payment' table.
paymentnumber	String	The 'paymentnumber' column for the 'payment' table.
effectivedate	Date	The 'effectivedate' column for the 'payment' table.
retrystatus_c	String	The 'retrystatus__c' column for the 'payment' table.

A payment that is applied to an invoice or a debit memo.

Columns

Name	Type	Description
debitmemoid	String	The 'debitmemoid' column for the 'paymentapplication' table.
paymentapplicationstatus	String	The 'paymentapplicationstatus' column for the 'paymentapplication' table.
accountid	String	The 'accountid' column for the 'paymentapplication' table.
updateddate	Datetime	The 'updateddate' column for the 'paymentapplication' table.
updatedbyid	String	The 'updatedbyid' column for the 'paymentapplication' table.
paymentid	String	The 'paymentid' column for the 'paymentapplication' table.
invoiceid	String	The 'invoiceid' column for the 'paymentapplication' table.
billingdocumentownerid	String	The 'billingdocumentownerid' column for the 'paymentapplication' table.
cashaccountingcodeid	String	The 'cashaccountingcodeid' column for the 'paymentapplication' table.
createdbyid	String	The 'createdbyid' column for the 'paymentapplication' table.
applyamount	Decimal	The 'applyamount' column for the 'paymentapplication' table.
unappliedpaymentaccountingcodeid	String	The 'unappliedpaymentaccountingcodeid' column for the 'paymentapplication' table.
createddate	Datetime	The 'createddate' column for the 'paymentapplication' table.
id	String	The 'id' column for the 'paymentapplication' table.
journalentryid	String	The 'journalentryid' column for the 'paymentapplication' table.
applicationgroupid	String	The 'applicationgroupid' column for the 'paymentapplication' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'paymentapplication' table.
effectivedate	Date	The 'effectivedate' column for the 'paymentapplication' table.

A payment that is applied to a line item in an invoice or a line item in a debit memo.

Columns

Name	Type	Description
updateddate	Datetime	The 'updateddate' column for the 'paymentapplicationitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'paymentapplicationitem' table.
amount	Decimal	The 'amount' column for the 'paymentapplicationitem' table.
invoiceitemid	String	The 'invoiceitemid' column for the 'paymentapplicationitem' table.
debitmemoitemid	String	The 'debitmemoitemid' column for the 'paymentapplicationitem' table.
cashaccountingcodeid	String	The 'cashaccountingcodeid' column for the 'paymentapplicationitem' table.
paymentapplicationid	String	The 'paymentapplicationid' column for the 'paymentapplicationitem' table.
createdbyid	String	The 'createdbyid' column for the 'paymentapplicationitem' table.
unappliedpaymentaccountingcodeid	String	The 'unappliedpaymentaccountingcodeid' column for the 'paymentapplicationitem' table.
createddate	Datetime	The 'createddate' column for the 'paymentapplicationitem' table.
debittaxationitemid	String	The 'debittaxationitemid' column for the 'paymentapplicationitem' table.
id	String	The 'id' column for the 'paymentapplicationitem' table.
journalentryid	String	The 'journalentryid' column for the 'paymentapplicationitem' table.
taxationitemid	String	The 'taxationitemid' column for the 'paymentapplicationitem' table.
applicationgroupid	String	The 'applicationgroupid' column for the 'paymentapplicationitem' table.
accountreceivableaccountingcodeid	String	The 'accountreceivableaccountingcodeid' column for the 'paymentapplicationitem' table.
effectivedate	Date	The 'effectivedate' column for the 'paymentapplicationitem' table.

An event that was processed by a payment reconciliation job.

Columns

Name	Type	Description
gatewayreferenceid	String	The 'gatewayreferenceid' column for the 'paymentgatewayreconciliationeventlog' table.
eventdate	Datetime	The 'eventdate' column for the 'paymentgatewayreconciliationeventlog' table.
amount	Decimal	The 'amount' column for the 'paymentgatewayreconciliationeventlog' table.
gatewayreasonmessage	String	The 'gatewayreasonmessage' column for the 'paymentgatewayreconciliationeventlog' table.
eventtype	String	The 'eventtype' column for the 'paymentgatewayreconciliationeventlog' table.
updateddate	Datetime	The 'updateddate' column for the 'paymentgatewayreconciliationeventlog' table.
createdgatewayreferenceid	String	The 'createdgatewayreferenceid' column for the 'paymentgatewayreconciliationeventlog' table.
createdgatewaysecondreferenceid	String	The 'createdgatewaysecondreferenceid' column for the 'paymentgatewayreconciliationeventlog' table.
gatewayreasoncode	String	The 'gatewayreasoncode' column for the 'paymentgatewayreconciliationeventlog' table.
paymentreconciliationjobid	String	The 'paymentreconciliationjobid' column for the 'paymentgatewayreconciliationeventlog' table.
createddate	Datetime	The 'createddate' column for the 'paymentgatewayreconciliationeventlog' table.
id	String	The 'id' column for the 'paymentgatewayreconciliationeventlog' table.
gatewayrawrecord	String	The 'gatewayrawrecord' column for the 'paymentgatewayreconciliationeventlog' table.
gatewaysecondreferenceid	String	The 'gatewaysecondreferenceid' column for the 'paymentgatewayreconciliationeventlog' table.

A payment method.

Columns

Name	Type	Description
bankname	String	The 'bankname' column for the 'paymentmethod' table.
secondtokenid	String	The 'secondtokenid' column for the 'paymentmethod' table.
streetname	String	The 'streetname' column for the 'paymentmethod' table.
accountid	String	The 'accountid' column for the 'paymentmethod' table.
email	String	The 'email' column for the 'paymentmethod' table.
mandateid	String	The 'mandateid' column for the 'paymentmethod' table.
updateddate	Datetime	The 'updateddate' column for the 'paymentmethod' table.
achaccountnumbermask	String	The 'achaccountnumbermask' column for the 'paymentmethod' table.
creditcardexpirationmonth	String	The 'creditcardexpirationmonth' column for the 'paymentmethod' table.
creditcardexpirationyear	String	The 'creditcardexpirationyear' column for the 'paymentmethod' table.
bankstreetnumber	String	The 'bankstreetnumber' column for the 'paymentmethod' table.
creditcardholdername	String	The 'creditcardholdername' column for the 'paymentmethod' table.
name	String	The 'name' column for the 'paymentmethod' table.
creditcardaddress2	String	The 'creditcardaddress2' column for the 'paymentmethod' table.
paymentmethodstatus	String	The 'paymentmethodstatus' column for the 'paymentmethod' table.
companyname	String	The 'companyname' column for the 'paymentmethod' table.
creditcardaddress1	String	The 'creditcardaddress1' column for the 'paymentmethod' table.
creditcardcity	String	The 'creditcardcity' column for the 'paymentmethod' table.
createdbyid	String	The 'createdbyid' column for the 'paymentmethod' table.
paymentretrywindow	String	The 'paymentretrywindow' column for the 'paymentmethod' table.
banktransfertype	String	The 'banktransfertype' column for the 'paymentmethod' table.
streetnumber	String	The 'streetnumber' column for the 'paymentmethod' table.
achabacode	String	The 'achabacode' column for the 'paymentmethod' table.
bankbranchcode	String	The 'bankbranchcode' column for the 'paymentmethod' table.
achbankname	String	The 'achbankname' column for the 'paymentmethod' table.
banktransferaccounttype	String	The 'banktransferaccounttype' column for the 'paymentmethod' table.
bankpostalcode	String	The 'bankpostalcode' column for the 'paymentmethod' table.
iban	String	The 'iban' column for the 'paymentmethod' table.
bankstreetname	String	The 'bankstreetname' column for the 'paymentmethod' table.
mandatereceived	String	The 'mandatereceived' column for the 'paymentmethod' table.
bankcheckdigit	String	The 'bankcheckdigit' column for the 'paymentmethod' table.
city	String	The 'city' column for the 'paymentmethod' table.
mandatecreationdate	Date	The 'mandatecreationdate' column for the 'paymentmethod' table.
lastfailedsaletransactiondate	Date	The 'lastfailedsaletransactiondate' column for the 'paymentmethod' table.
active	Bool	The 'active' column for the 'paymentmethod' table.
existingmandate	String	The 'existingmandate' column for the 'paymentmethod' table.
achcountry	String	The 'achcountry' column for the 'paymentmethod' table.
state	String	The 'state' column for the 'paymentmethod' table.
achaddress1	String	The 'achaddress1' column for the 'paymentmethod' table.
createddate	Datetime	The 'createddate' column for the 'paymentmethod' table.
country	String	The 'country' column for the 'paymentmethod' table.
creditcardpostalcode	String	The 'creditcardpostalcode' column for the 'paymentmethod' table.
id	String	The 'id' column for the 'paymentmethod' table.
lastname	String	The 'lastname' column for the 'paymentmethod' table.
achaccountname	String	The 'achaccountname' column for the 'paymentmethod' table.
achstate	String	The 'achstate' column for the 'paymentmethod' table.
achaddress2	String	The 'achaddress2' column for the 'paymentmethod' table.
paypalpreapprovalkey	String	The 'paypalpreapprovalkey' column for the 'paymentmethod' table.
creditcardstate	String	The 'creditcardstate' column for the 'paymentmethod' table.
banktransferaccountnumbermask	String	The 'banktransferaccountnumbermask' column for the 'paymentmethod' table.
numconsecutivefailures	String	The 'numconsecutivefailures' column for the 'paymentmethod' table.
paypaltype	String	The 'paypaltype' column for the 'paymentmethod' table.
maxconsecutivepaymentfailures	String	The 'maxconsecutivepaymentfailures' column for the 'paymentmethod' table.
postalcode	String	The 'postalcode' column for the 'paymentmethod' table.
creditcardcountry	String	The 'creditcardcountry' column for the 'paymentmethod' table.
businessidentificationcode	String	The 'businessidentificationcode' column for the 'paymentmethod' table.
achcity	String	The 'achcity' column for the 'paymentmethod' table.
achpostalcode	String	The 'achpostalcode' column for the 'paymentmethod' table.
mandateupdatedate	Date	The 'mandateupdatedate' column for the 'paymentmethod' table.
creditcardmasknumber	String	The 'creditcardmasknumber' column for the 'paymentmethod' table.
mandatestatus	String	The 'mandatestatus' column for the 'paymentmethod' table.
phone	String	The 'phone' column for the 'paymentmethod' table.
bankidentificationnumber	String	The 'bankidentificationnumber' column for the 'paymentmethod' table.
iscompany	Bool	The 'iscompany' column for the 'paymentmethod' table.
devicesessionid	String	The 'devicesessionid' column for the 'paymentmethod' table.
totalnumberofprocessedpayments	String	The 'totalnumberofprocessedpayments' column for the 'paymentmethod' table.
tokenid	String	The 'tokenid' column for the 'paymentmethod' table.
usedefaultretryrule	Bool	The 'usedefaultretryrule' column for the 'paymentmethod' table.
lasttransactiondatetime	Datetime	The 'lasttransactiondatetime' column for the 'paymentmethod' table.
lasttransactionstatus	String	The 'lasttransactionstatus' column for the 'paymentmethod' table.
bankcity	String	The 'bankcity' column for the 'paymentmethod' table.
firstname	String	The 'firstname' column for the 'paymentmethod' table.
paypalemail	String	The 'paypalemail' column for the 'paymentmethod' table.
updatedbyid	String	The 'updatedbyid' column for the 'paymentmethod' table.
bankcode	String	The 'bankcode' column for the 'paymentmethod' table.
creditcardtype	String	The 'creditcardtype' column for the 'paymentmethod' table.
paypalbaid	String	The 'paypalbaid' column for the 'paymentmethod' table.
mandatereason	String	The 'mandatereason' column for the 'paymentmethod' table.
achaccounttype	String	The 'achaccounttype' column for the 'paymentmethod' table.
banktransferaccountname	String	The 'banktransferaccountname' column for the 'paymentmethod' table.
type	String	The 'type' column for the 'paymentmethod' table.
totalnumberoferrorpayments	String	The 'totalnumberoferrorpayments' column for the 'paymentmethod' table.
ipaddress	String	The 'ipaddress' column for the 'paymentmethod' table.
identitynumber	String	The 'identitynumber' column for the 'paymentmethod' table.

A copy of the payment method that was used in a transaction.

Columns

Name	Type	Description
bankname	String	The 'bankname' column for the 'paymentmethodsnapshot' table.
secondtokenid	String	The 'secondtokenid' column for the 'paymentmethodsnapshot' table.
streetname	String	The 'streetname' column for the 'paymentmethodsnapshot' table.
accountid	String	The 'accountid' column for the 'paymentmethodsnapshot' table.
email	String	The 'email' column for the 'paymentmethodsnapshot' table.
mandateid	String	The 'mandateid' column for the 'paymentmethodsnapshot' table.
paymentmethodid	String	The 'paymentmethodid' column for the 'paymentmethodsnapshot' table.
updateddate	Datetime	The 'updateddate' column for the 'paymentmethodsnapshot' table.
achaccountnumbermask	String	The 'achaccountnumbermask' column for the 'paymentmethodsnapshot' table.
creditcardexpirationmonth	String	The 'creditcardexpirationmonth' column for the 'paymentmethodsnapshot' table.
creditcardexpirationyear	String	The 'creditcardexpirationyear' column for the 'paymentmethodsnapshot' table.
bankstreetnumber	String	The 'bankstreetnumber' column for the 'paymentmethodsnapshot' table.
creditcardholdername	String	The 'creditcardholdername' column for the 'paymentmethodsnapshot' table.
name	String	The 'name' column for the 'paymentmethodsnapshot' table.
creditcardaddress2	String	The 'creditcardaddress2' column for the 'paymentmethodsnapshot' table.
paymentmethodstatus	String	The 'paymentmethodstatus' column for the 'paymentmethodsnapshot' table.
companyname	String	The 'companyname' column for the 'paymentmethodsnapshot' table.
creditcardaddress1	String	The 'creditcardaddress1' column for the 'paymentmethodsnapshot' table.
creditcardcity	String	The 'creditcardcity' column for the 'paymentmethodsnapshot' table.
paymentretrywindow	String	The 'paymentretrywindow' column for the 'paymentmethodsnapshot' table.
banktransfertype	String	The 'banktransfertype' column for the 'paymentmethodsnapshot' table.
streetnumber	String	The 'streetnumber' column for the 'paymentmethodsnapshot' table.
achabacode	String	The 'achabacode' column for the 'paymentmethodsnapshot' table.
bankbranchcode	String	The 'bankbranchcode' column for the 'paymentmethodsnapshot' table.
achbankname	String	The 'achbankname' column for the 'paymentmethodsnapshot' table.
banktransferaccounttype	String	The 'banktransferaccounttype' column for the 'paymentmethodsnapshot' table.
bankpostalcode	String	The 'bankpostalcode' column for the 'paymentmethodsnapshot' table.
iban	String	The 'iban' column for the 'paymentmethodsnapshot' table.
bankstreetname	String	The 'bankstreetname' column for the 'paymentmethodsnapshot' table.
mandatereceived	String	The 'mandatereceived' column for the 'paymentmethodsnapshot' table.
bankcheckdigit	String	The 'bankcheckdigit' column for the 'paymentmethodsnapshot' table.
city	String	The 'city' column for the 'paymentmethodsnapshot' table.
mandatecreationdate	Date	The 'mandatecreationdate' column for the 'paymentmethodsnapshot' table.
lastfailedsaletransactiondate	Date	The 'lastfailedsaletransactiondate' column for the 'paymentmethodsnapshot' table.
existingmandate	String	The 'existingmandate' column for the 'paymentmethodsnapshot' table.
state	String	The 'state' column for the 'paymentmethodsnapshot' table.
createddate	Datetime	The 'createddate' column for the 'paymentmethodsnapshot' table.
country	String	The 'country' column for the 'paymentmethodsnapshot' table.
creditcardpostalcode	String	The 'creditcardpostalcode' column for the 'paymentmethodsnapshot' table.
id	String	The 'id' column for the 'paymentmethodsnapshot' table.
lastname	String	The 'lastname' column for the 'paymentmethodsnapshot' table.
achaccountname	String	The 'achaccountname' column for the 'paymentmethodsnapshot' table.
paypalpreapprovalkey	String	The 'paypalpreapprovalkey' column for the 'paymentmethodsnapshot' table.
creditcardstate	String	The 'creditcardstate' column for the 'paymentmethodsnapshot' table.
banktransferaccountnumbermask	String	The 'banktransferaccountnumbermask' column for the 'paymentmethodsnapshot' table.
numconsecutivefailures	String	The 'numconsecutivefailures' column for the 'paymentmethodsnapshot' table.
paypaltype	String	The 'paypaltype' column for the 'paymentmethodsnapshot' table.
maxconsecutivepaymentfailures	String	The 'maxconsecutivepaymentfailures' column for the 'paymentmethodsnapshot' table.
postalcode	String	The 'postalcode' column for the 'paymentmethodsnapshot' table.
creditcardcountry	String	The 'creditcardcountry' column for the 'paymentmethodsnapshot' table.
businessidentificationcode	String	The 'businessidentificationcode' column for the 'paymentmethodsnapshot' table.
mandateupdatedate	Date	The 'mandateupdatedate' column for the 'paymentmethodsnapshot' table.
creditcardmasknumber	String	The 'creditcardmasknumber' column for the 'paymentmethodsnapshot' table.
mandatestatus	String	The 'mandatestatus' column for the 'paymentmethodsnapshot' table.
phone	String	The 'phone' column for the 'paymentmethodsnapshot' table.
bankidentificationnumber	String	The 'bankidentificationnumber' column for the 'paymentmethodsnapshot' table.
iscompany	Bool	The 'iscompany' column for the 'paymentmethodsnapshot' table.
devicesessionid	String	The 'devicesessionid' column for the 'paymentmethodsnapshot' table.
totalnumberofprocessedpayments	String	The 'totalnumberofprocessedpayments' column for the 'paymentmethodsnapshot' table.
tokenid	String	The 'tokenid' column for the 'paymentmethodsnapshot' table.
usedefaultretryrule	Bool	The 'usedefaultretryrule' column for the 'paymentmethodsnapshot' table.
lasttransactiondatetime	Datetime	The 'lasttransactiondatetime' column for the 'paymentmethodsnapshot' table.
lasttransactionstatus	String	The 'lasttransactionstatus' column for the 'paymentmethodsnapshot' table.
bankcity	String	The 'bankcity' column for the 'paymentmethodsnapshot' table.
firstname	String	The 'firstname' column for the 'paymentmethodsnapshot' table.
paypalemail	String	The 'paypalemail' column for the 'paymentmethodsnapshot' table.
bankcode	String	The 'bankcode' column for the 'paymentmethodsnapshot' table.
creditcardtype	String	The 'creditcardtype' column for the 'paymentmethodsnapshot' table.
paypalbaid	String	The 'paypalbaid' column for the 'paymentmethodsnapshot' table.
mandatereason	String	The 'mandatereason' column for the 'paymentmethodsnapshot' table.
achaccounttype	String	The 'achaccounttype' column for the 'paymentmethodsnapshot' table.
banktransferaccountname	String	The 'banktransferaccountname' column for the 'paymentmethodsnapshot' table.
type	String	The 'type' column for the 'paymentmethodsnapshot' table.
totalnumberoferrorpayments	String	The 'totalnumberoferrorpayments' column for the 'paymentmethodsnapshot' table.
ipaddress	String	The 'ipaddress' column for the 'paymentmethodsnapshot' table.
identitynumber	String	The 'identitynumber' column for the 'paymentmethodsnapshot' table.

A transaction from Zuora to the payment gateway associated with a payment method.

Columns

Name	Type	Description
paymentmethodtype	String	The 'paymentmethodtype' column for the 'paymentmethodtransactionlog' table.
accountid	String	The 'accountid' column for the 'paymentmethodtransactionlog' table.
paymentmethodid	String	The 'paymentmethodid' column for the 'paymentmethodtransactionlog' table.
requeststring	String	The 'requeststring' column for the 'paymentmethodtransactionlog' table.
gatewaytransactiontype	String	The 'gatewaytransactiontype' column for the 'paymentmethodtransactionlog' table.
gatewayreasoncode	String	The 'gatewayreasoncode' column for the 'paymentmethodtransactionlog' table.
transactionid	String	The 'transactionid' column for the 'paymentmethodtransactionlog' table.
gateway	String	The 'gateway' column for the 'paymentmethodtransactionlog' table.
gatewayreasoncodedescription	String	The 'gatewayreasoncodedescription' column for the 'paymentmethodtransactionlog' table.
createddate	Datetime	The 'createddate' column for the 'paymentmethodtransactionlog' table.
id	String	The 'id' column for the 'paymentmethodtransactionlog' table.
responsestring	String	The 'responsestring' column for the 'paymentmethodtransactionlog' table.
transactiondate	Datetime	The 'transactiondate' column for the 'paymentmethodtransactionlog' table.

An applied or unapplied portion of a payment.

Columns

Name	Type	Description
debitmemoid	String	The 'debitmemoid' column for the 'paymentpart' table.
accountid	String	The 'accountid' column for the 'paymentpart' table.
createdbyid	String	The 'createdbyid' column for the 'paymentpart' table.
updateddate	Datetime	The 'updateddate' column for the 'paymentpart' table.
updatedbyid	String	The 'updatedbyid' column for the 'paymentpart' table.
amount	Decimal	The 'amount' column for the 'paymentpart' table.
createddate	Datetime	The 'createddate' column for the 'paymentpart' table.
paymentid	String	The 'paymentid' column for the 'paymentpart' table.
id	String	The 'id' column for the 'paymentpart' table.
invoiceid	String	The 'invoiceid' column for the 'paymentpart' table.
billingdocumentownerid	String	The 'billingdocumentownerid' column for the 'paymentpart' table.