Zuora への接続を追加

Zuora への接続を追加するには：

1. アプリケーションコンソールで、接続ページに移動します。
2. 接続の追加パネルで、追加したい接続のアイコンを選択します。
3. Zuora アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからZuora コネクタをダウンロードおよびインストールします。

必須プロパティについては、設定タブを参照してください。

通常必須ではない接続プロパティについては、高度な設定タブを参照してください。

Zuora への接続

Zuora への有効な接続を作成するには、テナントプロパティを設定する必要があります。 アカウント構成に適したテナント値を選択します。利用可能なオプション：

• USProduction：リクエストはhttps://rest.zuora.com（デフォルト）に送信されます。
• USAPISandbox：リクエストはhttps://rest.apisandbox.zuora.com に送信されます。
• USPerformanceTest：リクエストはhttps://rest.pt1.zuora.com に送信されます。
• EUProduction：リクエストはhttps://rest.eu.zuora.com に送信されます。
• EUSandbox：リクエストはhttps://rest.sandbox.eu.zuora.com に送信されます。

テナントを設定したのち、トークンを生成するためにカスタムOAuth アプリケーションを作成する必要があります。これは一度きりの簡単な操作です。詳しくは、カスタムOAuth アプリケーションの作成 を参照してください。

Zuora への認証

OAuth

認証用のクライアントId およびクライアントシークレットを含むカスタムアプリケーションを作成する必要があります。

接続の前に、以下の変数を設定します。

• OAuthClientId：カスタムOAuth アプリケーションの登録時に割り当てられたクライアントId。
• OAuthClientSecret：カスタムOAuth アプリケーションの登録時に割り当てられたクライアントシークレット。

Zuora への接続 をクリックして、デフォルトブラウザでOAuth エンドポイントを開きます。ログインして、アプリケーションにアクセス許可を与えます。

ドライバーは、以下のようにOAuth プロセスを完了します。

• コールバックURL からアクセストークンを取得します。
• 古いトークンの期限が切れたときは、新しいアクセストークンを取得します。
• OAuth 値を保存し、接続間で永続化します。

Zuora サービスの選択

データクエリとAQuA API の2つのZuora サービスを使用します。デフォルトでは、ZuoraService はAQuADataExport に設定されています。

DataQuery

データクエリ機能は、非同期の読み取り専用SQL クエリを実行することで、Zuora テナントからのデータのエクスポートを実現します。 このサービスは、素早く軽量なSQL クエリでの使用を推奨します。

制限

• フィルタ適用後の、テーブルごとの入力レコードの最大数： 1,000,000
• 出力レコードの最大数： 100.000
• テナントごとの、実行用に送信される同時クエリの最大数： 5
• テナントごとの、同時クエリの制限に達した後に実行用に送信され、キューに追加されるクエリの最大数： 10
• 1時間単位での、各クエリの最大処理時間： 1
• GB 単位での、各クエリに割り当てられるメモリの最大サイズ： 2
• Index Join を使用する際のインデックスの最大値。言い換えれば、Index Join を使用する際にWHERE 句で使われる一意の値に基づいた、左のテーブルから返されるレコードの最大数： 20.000

Zuora サービスの選択

データクエリとAQuA API の2つのZuora サービスを使用します。デフォルトでは、ZuoraService はAQuADataExport に設定されています。

DataQuery

データクエリ機能は、非同期の読み取り専用SQL クエリを実行することで、Zuora テナントからのデータのエクスポートを実現します。 このサービスは、素早く軽量なSQL クエリでの使用を推奨します。

制限

• フィルタ適用後の、テーブルごとの入力レコードの最大数： 1,000,000
• 出力レコードの最大数： 100.000
• テナントごとの、実行用に送信される同時クエリの最大数： 5
• テナントごとの、同時クエリの制限に達した後に実行用に送信され、キューに追加されるクエリの最大数： 10
• 1時間単位での、各クエリの最大処理時間： 1
• GB 単位での、各クエリに割り当てられるメモリの最大サイズ： 2
• Index Join を使用する際のインデックスの最大値。言い換えれば、Index Join を使用する際にWHERE 句で使われる一意の値に基づいた、左のテーブルから返されるレコードの最大数： 20.000

AQuADataExport

AQuA API のエクスポートは、すべてのオブジェクト（テーブル）のすべてのレコードをエクスポートするように設計されています。AQuA のクエリジョブには以下の制限があります。

制限

• AQuA のジョブ内のクエリが8時間以上実行されている場合、ジョブは自動的に停止されます。
• 停止されたAQuA のジョブは3回再試行可能で、その後失敗として返されます。

カスタムOAuth アプリケーションの作成

すべてのユーザーは、OAuth 2.0の仕組みでZuora へ認証します。 Sync App は、client_credential グラントタイプを使用するため、トークンの生成に必要なものはOAuthClientId と OAuthClientSecret のみです。生成にはHTTP リクエストを一度行うだけです。

OAuthClientId およびOAuthClientSecret を取得するには、はじめにZuora UI でカスタムOAuth クライアントを作成する必要があります。

以下の手順に従います。

1. Zuora テナントの管理権限を持つアカウントを使用して、Zuora Profiles & Settings メニューにログインします。
2. Administration > Manage Users に移動します。
3. ユーザーを作成します。 Zuora テナントへの認証にOAuth を使用するアプリケーションは、このユーザーとしてアクションを実行します。 Zuora は、この目的に特化したAPI ユーザーを作成することを推奨します。
4. Zuora テナントのUsers ページに移動します。
5. 作成した新規ユーザーを選択し、そのユーザーのOAuth クライアントを作成します。
6. 今後使用するために、クライアントId とクライアントシークレットを控えておきます。

このセクションでは、Zuora Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App はユーザー定義ビューの使用をサポートします。これは事前設定されたユーザー定義クエリによって内容が決定される仮想テーブルです。 このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。 カスタムビューの作成と設定の概要については、ユーザー定義ビュー を参照してください。

SSL の設定

SSL の設定 を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、「接続文字列オプション」にあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシ に合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

Sync App は、Zuora にできるだけ多くのSELECT ステートメント処理をオフロードし、残りのクエリをクライアント側のインメモリで処理します。

詳しくは、クエリ処理 を参照してください。

ログ

CData ログを調整するために使用可能な設定の概要については、ログ を参照してください。基本的なロギングに必要なのは2つの接続プロパティだけですが、より詳細なロギングをサポートする多くの機能があり、LogModules 接続プロパティを使用してロギングする情報のサブセットを指定することができます。

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

• ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
• ProxyPort：プロキシサーバーが起動しているTCP ポート。
• ProxyAuthScheme：プロキシサーバーに対して認証する際にSync App が使用する認証方法。
• ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
• ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

次のプロパティを設定します。

• プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
• 接続をトンネルするには、FirewallType をTUNNEL に設定します。
• 認証するには、FirewallUser とFirewallPassword を設定します。
• SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

Sync App はREST API を使って、Zuora からすべての関連するスキーマ情報を動的に抽出します。すべてのZuora エンティティはビューとして公開されます。

CData Sync App は、Zuora オブジェクトをリレーショナルテーブルおよびビューとしてモデル化します。 Zuora オブジェクトは他のオブジェクトとリレーションを持ちます。テーブルでは、これらのリレーションは外部キーを使用して表されます。 次のセクションでは、利用可能なAPI オブジェクトを示し、Zuora API へのSQL の実行について詳しく説明します。

ほとんどのデータベースオブジェクトのスキーマは、シンプルなテキストベースのコンフィギュレーションファイルで定義されます。

ストアドプロシージャ

ストアドプロシージャ は、Zuora のファンクションライクなインターフェースです。これを使って、スキーマファイルを作成したり、Zuora アプリのOAuth アクセストークンの取得、リフレッシュが可能です。

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

Zuora Connector for CData Sync ビュー

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.