Zuora Version Support

The connector leverages the Zuora API to enable bidirectional access to Zuora.

Authenticating to Zuora

Zuora uses the OAuth standard to authenticate users.

Configuring Tenant property

In order to create a valid connection with the provider you need to choose one of the Tenant values which matches your account configuration. The following is a list with the available options:

• USProduction: Requests sent to https://rest.zuora.com.
• 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"

By default we use USProduction tenant.

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.

You can authenticate to the Zuora via the OAuth 2 mechanism. The connector 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, without the need of opening any login prompt.

Create an App

You must first create an OAuth client in the Zuora UI. To do this, you must be an administrator of your Zuora tenant.

This is a one-time operation.

• In your Zuora tenant, select Administration > Manage Users from the Profile & Settings menu, then create a user. Apps 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.
• On the Users page in your Zuora tenant, select the user you created in the previous step, then create an OAuth client for the user.
• Note the Client ID and Client secret for future use.

Authenticate to Zuora

After setting the following connection properties, you are ready to connect:

• InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken connection property.
• OAuthClientId: Set this to the Client ID in your app settings.
• OAuthClientSecret: Set this to the Client Secret in your app settings.
• Tenant: Set this to your Zuora tenant. Possible options are: USProduction,USAPISandbox,USPerformanceTest,EUProduction,EUSandbox. By default we use USProduction tenant.
• URL: This is required only in case you have a US Production Copy environment. If this proprty is provided, the value of Tenant property has no effect in authentication process.

When you connect, the connector completes the OAuth process.

1. Exchanges the OAuthClientId and OAuthClientSecret for the OAuthAccessToken.
2. Refreshes the access token when it expires.
3. Saves OAuth values in OAuthSettingsLocation to be persisted across connections.

This section details a selection of advanced features of the Zuora connector.

User Defined Views

The connector allows you to define virtual tables, called user defined views, whose contents are decided by a pre-configured query. These views are useful when you cannot directly control queries being issued to the drivers. See User Defined Views for an overview of creating and configuring custom views.

SSL Configuration

Use SSL Configuration to adjust how connector handles TLS/SSL certificate negotiations. You can choose from various certificate formats; see the SSLServerCert property under "Connection String Options" for more information.

Proxy

To configure the connector using Private Agent proxy settings, select the Use Proxy Settings checkbox on the connection configuration screen.

Query Processing

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

See Query Processing for more information.

The Jitterbit Connector for Zuora allows you to define a virtual table whose contents are decided by a pre-configured query. These are called User Defined Views, which are useful in situations where you cannot directly control the query being issued to the driver, e.g. when using the driver from Jitterbit. The User Defined Views can be used to define predicates that are always applied. If you specify additional predicates in the query to the view, they are combined with the query already defined as part of the view.

There are two ways to create user defined views:

• Create a JSON-formatted configuration file defining the views you want.
• DDL statements.

Defining Views Using a Configuration File

User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The connector automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the connector.

This User Defined View configuration file is formatted as follows:

• Each root element defines the name of a view.
• Each root element contains a child element, called query, which contains the custom SQL query for the view.

For example:

{
	"MyView": {
		"query": "SELECT * FROM SampleTable_1 WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", "C:\Users\yourusername\Desktop\tmp\UserDefinedViews.json"

Defining Views Using DDL Statements

The connector is also capable of creating and altering the schema via DDL Statements such as CREATE LOCAL VIEW, ALTER LOCAL VIEW, and DROP LOCAL VIEW.

Create a View

To create a new view using DDL statements, provide the view name and query as follows:

CREATE LOCAL VIEW [MyViewName] AS SELECT * FROM Customers LIMIT 20;

If no JSON file exists, the above code creates one. The view is then created in the JSON configuration file and is now discoverable. The JSON file location is specified by the UserDefinedViews connection property.

Alter a View

To alter an existing view, provide the name of an existing view alongside the new query you would like to use instead:

ALTER LOCAL VIEW [MyViewName] AS SELECT * FROM Customers WHERE TimeModified > '3/1/2020';

The view is then updated in the JSON configuration file.

Drop a View

To drop an existing view, provide the name of an existing schema alongside the new query you would like to use instead.

DROP LOCAL VIEW [MyViewName]

This removes the view from the JSON configuration file. It can no longer be queried.

Schema for User Defined Views

User Defined Views are exposed in the UserViews schema by default. This is done to avoid the view's name clashing with an actual entity in the data model. You can change the name of the schema used for UserViews by setting the UserViewsSchemaName property.

Working with User Defined Views

For example, a SQL statement with a User Defined View called UserViews.RCustomers only lists customers in Raleigh:

SELECT * FROM Customers WHERE City = 'Raleigh';

An example of a query to the driver:

SELECT * FROM UserViews.RCustomers WHERE Status = 'Active';

Resulting in the effective query to the source:

SELECT * FROM Customers WHERE City = 'Raleigh' AND Status = 'Active';

That is a very simple example of a query to a User Defined View that is effectively a combination of the view query and the view definition. It is possible to compose these queries in much more complex patterns. All SQL operations are allowed in both queries and are combined when appropriate.

Customizing the SSL Configuration

By default, the connector attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

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

The Jitterbit Connector for Zuora 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

NOTE: Stored procedures are not currently supported. See the above note for details.

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.

The connector offloads as much of the SELECT statement processing as possible to the Zuora APIs and then processes the rest of the query in memory. See SupportEnhancedSQL for more information on how the connector circumvents API limitations with in-memory client-side processing.

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure* is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

Jitterbit Connector for Zuora 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.

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

Columns

Name	Type	Description
createdbyid	String	The 'createdbyid' column for the 'paymentpartitem' table.
updateddate	Datetime	The 'updateddate' column for the 'paymentpartitem' table.
updatedbyid	String	The 'updatedbyid' column for the 'paymentpartitem' table.
amount	Decimal	The 'amount' column for the 'paymentpartitem' table.
paymentpartid	String	The 'paymentpartid' column for the 'paymentpartitem' table.
createddate	Datetime	The 'createddate' column for the 'paymentpartitem' table.
debittaxationitemid	String	The 'debittaxationitemid' column for the 'paymentpartitem' table.
invoiceitemid	String	The 'invoiceitemid' column for the 'paymentpartitem' table.
debitmemoitemid	String	The 'debitmemoitemid' column for the 'paymentpartitem' table.
id	String	The 'id' column for the 'paymentpartitem' table.
taxationitemid	String	The 'taxationitemid' column for the 'paymentpartitem' table.