Xero コネクタリファレンス

備考

ベータ版

この機能はベータ版です。使用するには、ワークスペース管理者は プレビュー ページから Lakeflow Connect for Xero を有効にする必要があります。Databricksのプレビューを管理するを参照してください。

Lakeflow Connect の管理された Xero コネクタは、default スキーマの 23 のソーステーブルをサポートしています。12 のテーブルは UpdatedDateUTC カーソルフィールドを使用して増分同期し、その他の 11 のテーブルはランごとに完全更新を使用します。

サポートされているソーステーブル

Xeroコネクタは、defaultソーススキーマ下の次のソーステーブルをサポートしています。

ソーステーブル	プライマリーキー	説明	同期モード	カーソルフィールド
`accounts`	`AccountID`	勘定科目表のアカウント。	インクリメンタル	`UpdatedDateUTC`
`bank_transactions`	`BankTransactionID`	銀行アカウントでの入金および出金トランザクション。	インクリメンタル	`UpdatedDateUTC`
`bank_transfers`	`BankTransferID`	銀行アカウント間の送金。	フル更新のみ
`branding_themes`	`BrandingThemeID`	請求書やその他の文書に適用されるブランドテーマ。	フル更新のみ
`budgets`	`BudgetID`	全体予算および追跡予算。	フル更新のみ
`contacts`	`ContactID`	顧客およびサプライヤー（アーカイブされた連絡先を含む）	インクリメンタル	`UpdatedDateUTC`
`contact_groups`	`ContactGroupID`	連絡先グループと各グループの連絡先。	フル更新のみ
`credit_notes`	`CreditNoteID`	顧客およびサプライヤーのクレジットノート。	インクリメンタル	`UpdatedDateUTC`
`currencies`	`Code`	組織で有効になっている通貨。	フル更新のみ
`invoices`	`InvoiceID`	売上請求書と仕入請求書。	インクリメンタル	`UpdatedDateUTC`
`items`	`ItemID`	組織が売買する製品とサービス。	インクリメンタル	`UpdatedDateUTC`
`linked_transactions`	`LinkedTransactionID`	請求可能経費とそれらが請求される販売請求書の間のLink。	フル更新のみ
`manual_journals`	`ManualJournalID`	手動仕訳。	インクリメンタル	`UpdatedDateUTC`
`organisation`	`OrganisationID`	接続された組織の詳細。	フル更新のみ
`overpayments`	`OverpaymentID`	サプライヤーへの過払い、または顧客からの過払い。	インクリメンタル	`UpdatedDateUTC`
`payments`	`PaymentID`	請求書、クレジットノート、前払い、および過払いに適用される支払い。	インクリメンタル	`UpdatedDateUTC`
`prepayments`	`PrepaymentID`	サプライヤーへの前払い、または顧客からの前払い。	インクリメンタル	`UpdatedDateUTC`
`purchase_orders`	`PurchaseOrderID`	注文書。	インクリメンタル	`UpdatedDateUTC`
`repeating_invoices`	`RepeatingInvoiceID`	繰り返し請求書Template。	フル更新のみ
`tax_rates`	`TaxType`	税率。	フル更新のみ
`tracking_categories`	`TrackingCategoryID`	トラッキングカテゴリとそのオプション（アーカイブされたものを含む）。	フル更新のみ
`users`	`UserID`	組織のユーザー。	インクリメンタル	`UpdatedDateUTC`
`projects`	`projectId`	Xero Projectsからのプロジェクト。	フル更新のみ

ソーステーブル	プライマリーキー	説明	同期モード	カーソルフィールド
`accounts`	`AccountID`	勘定科目表のアカウント。	インクリメンタル	`UpdatedDateUTC`
`bank_transactions`	`BankTransactionID`	銀行アカウントでの入金および出金トランザクション。	インクリメンタル	`UpdatedDateUTC`
`bank_transfers`	`BankTransferID`	銀行アカウント間の送金。	フル更新のみ
`branding_themes`	`BrandingThemeID`	請求書やその他の文書に適用されるブランドテーマ。	フル更新のみ
`budgets`	`BudgetID`	全体予算および追跡予算。	フル更新のみ
`contacts`	`ContactID`	顧客およびサプライヤー（アーカイブされた連絡先を含む）	インクリメンタル	`UpdatedDateUTC`
`contact_groups`	`ContactGroupID`	連絡先グループと各グループの連絡先。	フル更新のみ
`credit_notes`	`CreditNoteID`	顧客およびサプライヤーのクレジットノート。	インクリメンタル	`UpdatedDateUTC`
`currencies`	`Code`	組織で有効になっている通貨。	フル更新のみ
`invoices`	`InvoiceID`	売上請求書と仕入請求書。	インクリメンタル	`UpdatedDateUTC`
`items`	`ItemID`	組織が売買する製品とサービス。	インクリメンタル	`UpdatedDateUTC`
`linked_transactions`	`LinkedTransactionID`	請求可能経費とそれらが請求される販売請求書の間のLink。	フル更新のみ
`manual_journals`	`ManualJournalID`	手動仕訳。	インクリメンタル	`UpdatedDateUTC`
`organisation`	`OrganisationID`	接続された組織の詳細。	フル更新のみ
`overpayments`	`OverpaymentID`	サプライヤーへの過払い、または顧客からの過払い。	インクリメンタル	`UpdatedDateUTC`
`payments`	`PaymentID`	請求書、クレジットノート、前払い、および過払いに適用される支払い。	インクリメンタル	`UpdatedDateUTC`
`prepayments`	`PrepaymentID`	サプライヤーへの前払い、または顧客からの前払い。	インクリメンタル	`UpdatedDateUTC`
`purchase_orders`	`PurchaseOrderID`	注文書。	インクリメンタル	`UpdatedDateUTC`
`repeating_invoices`	`RepeatingInvoiceID`	繰り返し請求書Template。	フル更新のみ
`tax_rates`	`TaxType`	税率。	フル更新のみ
`tracking_categories`	`TrackingCategoryID`	トラッキングカテゴリとそのオプション（アーカイブされたものを含む）。	フル更新のみ
`users`	`UserID`	組織のユーザー。	インクリメンタル	`UpdatedDateUTC`
`projects`	`projectId`	Xero Projectsからのプロジェクト。	フル更新のみ

コネクタオプション

使用方法については、例を参照してください。

オプション	型	スコープ	必須	適用対象	説明
`tenant_id`	String	パイプライン	はい	すべてのテーブル	取り込み元の Xero 組織（テナント）の ID。「テナント ID を検索する」を参照してください。
`start_datetime`	String	パイプライン	No	すべての増分テーブル	取り込む最も早い日時。`yyyy-MM-ddTHH:mm:ssZ`形式（例：`2024-01-01T00:00:00Z`）で指定します。各テーブルの最初の同期にのみ適用されます。以降の同期は、保存されたカーソルから再開されます。設定しない場合、最初の同期は730日前から起動します。

オプション	型	スコープ	必須	適用対象	説明
`tenant_id`	String	パイプライン	はい	すべてのテーブル	取り込み元の Xero 組織（テナント）の ID。「テナント ID を検索する」を参照してください。
`start_datetime`	String	パイプライン	No	すべての増分テーブル	取り込む最も早い日時。`yyyy-MM-ddTHH:mm:ssZ`形式（例：`2024-01-01T00:00:00Z`）で指定します。各テーブルの最初の同期にのみ適用されます。以降の同期は、保存されたカーソルから再開されます。設定しない場合、最初の同期は730日前から起動します。

転送先テーブルスキーマ

`accounts`

プライマリーキー: AccountID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`Code`	`STRING`
`Name`	`STRING`
`AccountID`	`STRING`
`Type`	`STRING`
`BankAccountNumber`	`STRING`
`Status`	`STRING`
`Description`	`STRING`
`BankAccountType`	`STRING`
`CurrencyCode`	`STRING`
`TaxType`	`STRING`
`EnablePaymentsToAccount`	`BOOLEAN`
`ShowInExpenseClaims`	`BOOLEAN`
`Class`	`STRING`
`SystemAccount`	`STRING`
`ReportingCode`	`STRING`
`ReportingCodeName`	`STRING`
`HasAttachments`	`BOOLEAN`
`UpdatedDateUTC`	`STRING`
`AddToWatchlist`	`BOOLEAN`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`IsDeleted`	`BOOLEAN`

フィールド	データ型
`Code`	`STRING`
`Name`	`STRING`
`AccountID`	`STRING`
`Type`	`STRING`
`BankAccountNumber`	`STRING`
`Status`	`STRING`
`Description`	`STRING`
`BankAccountType`	`STRING`
`CurrencyCode`	`STRING`
`TaxType`	`STRING`
`EnablePaymentsToAccount`	`BOOLEAN`
`ShowInExpenseClaims`	`BOOLEAN`
`Class`	`STRING`
`SystemAccount`	`STRING`
`ReportingCode`	`STRING`
`ReportingCodeName`	`STRING`
`HasAttachments`	`BOOLEAN`
`UpdatedDateUTC`	`STRING`
`AddToWatchlist`	`BOOLEAN`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`IsDeleted`	`BOOLEAN`

`bank_transactions`

プライマリーキー: BankTransactionID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`BankTransactionID`	`STRING`
`Type`	`STRING`
`Status`	`STRING`
`StatusAttributeString`	`STRING`
`LineAmountTypes`	`STRING`
`Date`	`STRING`
`DateString`	`STRING`
`Reference`	`STRING`
`IsReconciled`	`BOOLEAN`
`HasAttachments`	`BOOLEAN`
`CurrencyCode`	`STRING`
`CurrencyRate`	`DOUBLE`
`Url`	`STRING`
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`PrepaymentID`	`STRING`
`OverpaymentID`	`STRING`
`UpdatedDateUTC`	`STRING`
`Contact`	`STRUCT<ContactID: STRING, ContactNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, EmailAddress: STRING, BankAccountDetails: STRING, TaxNumber: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, UpdatedDateUTC: STRING, Addresses: VARIANT, Phones: VARIANT, ContactGroups: VARIANT, ContactPersons: VARIANT, HasValidationErrors: BOOLEAN>`
`BankAccount`	`STRUCT<AccountID: STRING, Code: STRING, Name: STRING>`
`LineItems`	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, LineAmount: DOUBLE, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`IsDeleted`	`BOOLEAN`

フィールド	データ型
`BankTransactionID`	`STRING`
`Type`	`STRING`
`Status`	`STRING`
`StatusAttributeString`	`STRING`
`LineAmountTypes`	`STRING`
`Date`	`STRING`
`DateString`	`STRING`
`Reference`	`STRING`
`IsReconciled`	`BOOLEAN`
`HasAttachments`	`BOOLEAN`
`CurrencyCode`	`STRING`
`CurrencyRate`	`DOUBLE`
`Url`	`STRING`
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`PrepaymentID`	`STRING`
`OverpaymentID`	`STRING`
`UpdatedDateUTC`	`STRING`
`Contact`	`STRUCT<ContactID: STRING, ContactNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, EmailAddress: STRING, BankAccountDetails: STRING, TaxNumber: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, UpdatedDateUTC: STRING, Addresses: VARIANT, Phones: VARIANT, ContactGroups: VARIANT, ContactPersons: VARIANT, HasValidationErrors: BOOLEAN>`
`BankAccount`	`STRUCT<AccountID: STRING, Code: STRING, Name: STRING>`
`LineItems`	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, LineAmount: DOUBLE, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`IsDeleted`	`BOOLEAN`

注記

このテーブルはVARIANT列を持つため、slowly changing dimensions (SCD) タイプ2をサポートしていません。

`bank_transfers`

プライマリーキー: BankTransferID

同期モード: フル更新のみ

フィールド	データ型
`FromBankAccount`	`STRUCT<Code: STRING, Name: STRING, AccountID: STRING, Type: STRING, BankAccountNumber: STRING, Status: STRING, Description: STRING, BankAccountType: STRING, CurrencyCode: STRING, TaxType: STRING, EnablePaymentsToAccount: BOOLEAN, ShowInExpenseClaims: BOOLEAN, Class: STRING, SystemAccount: STRING, ReportingCode: STRING, ReportingCodeName: STRING, HasAttachments: BOOLEAN, UpdatedDateUTC: STRING, AddToWatchlist: BOOLEAN>`
`ToBankAccount`	`STRUCT<Code: STRING, Name: STRING, AccountID: STRING, Type: STRING, BankAccountNumber: STRING, Status: STRING, Description: STRING, BankAccountType: STRING, CurrencyCode: STRING, TaxType: STRING, EnablePaymentsToAccount: BOOLEAN, ShowInExpenseClaims: BOOLEAN, Class: STRING, SystemAccount: STRING, ReportingCode: STRING, ReportingCodeName: STRING, HasAttachments: BOOLEAN, UpdatedDateUTC: STRING, AddToWatchlist: BOOLEAN>`
`Amount`	`DOUBLE`
`Date`	`STRING`
`DateString`	`STRING`
`BankTransferID`	`STRING`
`CurrencyRate`	`DOUBLE`
`FromBankTransactionID`	`STRING`
`ToBankTransactionID`	`STRING`
`FromIsReconciled`	`BOOLEAN`
`ToIsReconciled`	`BOOLEAN`
`Reference`	`STRING`
`HasAttachments`	`BOOLEAN`
`CreatedDateUTC`	`STRING`
`CreatedDateUTCString`	`STRING`
`Status`	`STRING`
`FromTracking`	`ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>`
`ToTracking`	`ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`

フィールド	データ型
`FromBankAccount`	`STRUCT<Code: STRING, Name: STRING, AccountID: STRING, Type: STRING, BankAccountNumber: STRING, Status: STRING, Description: STRING, BankAccountType: STRING, CurrencyCode: STRING, TaxType: STRING, EnablePaymentsToAccount: BOOLEAN, ShowInExpenseClaims: BOOLEAN, Class: STRING, SystemAccount: STRING, ReportingCode: STRING, ReportingCodeName: STRING, HasAttachments: BOOLEAN, UpdatedDateUTC: STRING, AddToWatchlist: BOOLEAN>`
`ToBankAccount`	`STRUCT<Code: STRING, Name: STRING, AccountID: STRING, Type: STRING, BankAccountNumber: STRING, Status: STRING, Description: STRING, BankAccountType: STRING, CurrencyCode: STRING, TaxType: STRING, EnablePaymentsToAccount: BOOLEAN, ShowInExpenseClaims: BOOLEAN, Class: STRING, SystemAccount: STRING, ReportingCode: STRING, ReportingCodeName: STRING, HasAttachments: BOOLEAN, UpdatedDateUTC: STRING, AddToWatchlist: BOOLEAN>`
`Amount`	`DOUBLE`
`Date`	`STRING`
`DateString`	`STRING`
`BankTransferID`	`STRING`
`CurrencyRate`	`DOUBLE`
`FromBankTransactionID`	`STRING`
`ToBankTransactionID`	`STRING`
`FromIsReconciled`	`BOOLEAN`
`ToIsReconciled`	`BOOLEAN`
`Reference`	`STRING`
`HasAttachments`	`BOOLEAN`
`CreatedDateUTC`	`STRING`
`CreatedDateUTCString`	`STRING`
`Status`	`STRING`
`FromTracking`	`ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>`
`ToTracking`	`ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`

`branding_themes`

プライマリーキー: BrandingThemeID

同期モード: フル更新のみ

フィールド	データ型
`BrandingThemeID`	`STRING`
`Name`	`STRING`
`LogoUrl`	`STRING`
`Type`	`STRING`
`SortOrder`	`BIGINT`
`CreatedDateUTC`	`STRING`

`budgets`

プライマリーキー: BudgetID

同期モード: フル更新のみ

フィールド	データ型
`BudgetID`	`STRING`
`Type`	`STRING`
`Description`	`STRING`
`UpdatedDateUTC`	`STRING`
`Status`	`STRING`
`BudgetLines`	`ARRAY<STRUCT< AccountID STRING, AccountCode STRING, BudgetBalances ARRAY<STRUCT< Period STRING, Amount DOUBLE, UnitAmount DOUBLE, Notes STRING >> >>`
`Tracking`	`ARRAY<STRUCT< TrackingCategoryID STRING, TrackingOptionID STRING, Name STRING, Option STRING, Status STRING, Options ARRAY<STRUCT< TrackingOptionID STRING, Name STRING, Status STRING, TrackingCategoryID STRING >> >>`

フィールド	データ型
`BudgetID`	`STRING`
`Type`	`STRING`
`Description`	`STRING`
`UpdatedDateUTC`	`STRING`
`Status`	`STRING`
`BudgetLines`	`ARRAY<STRUCT< AccountID STRING, AccountCode STRING, BudgetBalances ARRAY<STRUCT< Period STRING, Amount DOUBLE, UnitAmount DOUBLE, Notes STRING >> >>`
`Tracking`	`ARRAY<STRUCT< TrackingCategoryID STRING, TrackingOptionID STRING, Name STRING, Option STRING, Status STRING, Options ARRAY<STRUCT< TrackingOptionID STRING, Name STRING, Status STRING, TrackingCategoryID STRING >> >>`

`contacts`

プライマリーキー: ContactID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`ContactID`	`STRING`
`MergedToContactID`	`STRING`
`ContactNumber`	`STRING`
`AccountNumber`	`STRING`
`ContactStatus`	`STRING`
`Name`	`STRING`
`FirstName`	`STRING`
`LastName`	`STRING`
`CompanyNumber`	`STRING`
`EmailAddress`	`STRING`
`ContactPersons`	`ARRAY<STRUCT<FirstName: STRING, LastName: STRING, EmailAddress: STRING, IncludeInEmails: BOOLEAN>>`
`BankAccountDetails`	`STRING`
`TaxNumber`	`STRING`
`TaxNumberType`	`STRING`
`AccountsReceivableTaxType`	`STRING`
`AccountsPayableTaxType`	`STRING`
`Addresses`	`ARRAY<STRUCT<AddressType: STRING, AddressLine1: STRING, AddressLine2: STRING, AddressLine3: STRING, AddressLine4: STRING, City: STRING, Region: STRING, PostalCode: STRING, Country: STRING, AttentionTo: STRING>>`
`Phones`	`ARRAY<STRUCT<PhoneType: STRING, PhoneNumber: STRING, PhoneAreaCode: STRING, PhoneCountryCode: STRING>>`
`IsSupplier`	`BOOLEAN`
`IsCustomer`	`BOOLEAN`
`SalesDefaultLineAmountType`	`STRING`
`PurchasesDefaultLineAmountType`	`STRING`
`DefaultCurrency`	`STRING`
`XeroNetworkKey`	`STRING`
`SalesDefaultAccountCode`	`STRING`
`PurchasesDefaultAccountCode`	`STRING`
`SalesTrackingCategories`	`ARRAY<STRUCT<TrackingCategoryName: STRING, TrackingOptionName: STRING>>`
`PurchasesTrackingCategories`	`ARRAY<STRUCT<TrackingCategoryName: STRING, TrackingOptionName: STRING>>`
`TrackingCategoryName`	`STRING`
`TrackingCategoryOption`	`STRING`
`PaymentTerms`	`STRUCT<Bills: STRUCT<Day: BIGINT, Type: STRING>, Sales: STRUCT<Day: BIGINT, Type: STRING>>`
`UpdatedDateUTC`	`STRING`
`ContactGroups`	`ARRAY<STRUCT<Name: STRING, Status: STRING, ContactGroupID: STRING>>`
`Website`	`STRING`
`BrandingTheme`	`STRUCT<BrandingThemeID: STRING, Name: STRING, LogoUrl: STRING, Type: STRING, SortOrder: BIGINT, CreatedDateUTC: STRING>`
`BatchPayments`	`STRUCT<BankAccountNumber: STRING, BankAccountName: STRING, Details: STRING, Code: STRING, Reference: STRING>`
`Discount`	`DOUBLE`
`Balances`	`STRUCT<AccountsReceivable: STRUCT<Outstanding: DOUBLE, Overdue: DOUBLE>, AccountsPayable: STRUCT<Outstanding: DOUBLE, Overdue: DOUBLE>>`
`Attachments`	`ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>`
`HasAttachments`	`BOOLEAN`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`HasValidationErrors`	`BOOLEAN`
`StatusAttributeString`	`STRING`

フィールド	データ型
`ContactID`	`STRING`
`MergedToContactID`	`STRING`
`ContactNumber`	`STRING`
`AccountNumber`	`STRING`
`ContactStatus`	`STRING`
`Name`	`STRING`
`FirstName`	`STRING`
`LastName`	`STRING`
`CompanyNumber`	`STRING`
`EmailAddress`	`STRING`
`ContactPersons`	`ARRAY<STRUCT<FirstName: STRING, LastName: STRING, EmailAddress: STRING, IncludeInEmails: BOOLEAN>>`
`BankAccountDetails`	`STRING`
`TaxNumber`	`STRING`
`TaxNumberType`	`STRING`
`AccountsReceivableTaxType`	`STRING`
`AccountsPayableTaxType`	`STRING`
`Addresses`	`ARRAY<STRUCT<AddressType: STRING, AddressLine1: STRING, AddressLine2: STRING, AddressLine3: STRING, AddressLine4: STRING, City: STRING, Region: STRING, PostalCode: STRING, Country: STRING, AttentionTo: STRING>>`
`Phones`	`ARRAY<STRUCT<PhoneType: STRING, PhoneNumber: STRING, PhoneAreaCode: STRING, PhoneCountryCode: STRING>>`
`IsSupplier`	`BOOLEAN`
`IsCustomer`	`BOOLEAN`
`SalesDefaultLineAmountType`	`STRING`
`PurchasesDefaultLineAmountType`	`STRING`
`DefaultCurrency`	`STRING`
`XeroNetworkKey`	`STRING`
`SalesDefaultAccountCode`	`STRING`
`PurchasesDefaultAccountCode`	`STRING`
`SalesTrackingCategories`	`ARRAY<STRUCT<TrackingCategoryName: STRING, TrackingOptionName: STRING>>`
`PurchasesTrackingCategories`	`ARRAY<STRUCT<TrackingCategoryName: STRING, TrackingOptionName: STRING>>`
`TrackingCategoryName`	`STRING`
`TrackingCategoryOption`	`STRING`
`PaymentTerms`	`STRUCT<Bills: STRUCT<Day: BIGINT, Type: STRING>, Sales: STRUCT<Day: BIGINT, Type: STRING>>`
`UpdatedDateUTC`	`STRING`
`ContactGroups`	`ARRAY<STRUCT<Name: STRING, Status: STRING, ContactGroupID: STRING>>`
`Website`	`STRING`
`BrandingTheme`	`STRUCT<BrandingThemeID: STRING, Name: STRING, LogoUrl: STRING, Type: STRING, SortOrder: BIGINT, CreatedDateUTC: STRING>`
`BatchPayments`	`STRUCT<BankAccountNumber: STRING, BankAccountName: STRING, Details: STRING, Code: STRING, Reference: STRING>`
`Discount`	`DOUBLE`
`Balances`	`STRUCT<AccountsReceivable: STRUCT<Outstanding: DOUBLE, Overdue: DOUBLE>, AccountsPayable: STRUCT<Outstanding: DOUBLE, Overdue: DOUBLE>>`
`Attachments`	`ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>`
`HasAttachments`	`BOOLEAN`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`HasValidationErrors`	`BOOLEAN`
`StatusAttributeString`	`STRING`

`contact_groups`

プライマリーキー: ContactGroupID

同期モード: フル更新のみ

フィールド	データ型
`ContactGroupID`	`STRING`
`Name`	`STRING`
`Status`	`STRING`
`HasValidationErrors`	`BOOLEAN`
`Contacts`	`ARRAY<STRUCT<ContactID STRING, Name STRING>>`

`credit_notes`

プライマリーキー: CreditNoteID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
`Date`	`STRING`
`DueDate`	`STRING`
`Status`	`STRING`
`LineAmountTypes`	`STRING`
`LineItems`	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`CISDeduction`	`DOUBLE`
`CISRate`	`DOUBLE`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`CurrencyCode`	`STRING`
`FullyPaidOnDate`	`STRING`
`CreditNoteID`	`STRING`
`CreditNoteNumber`	`STRING`
`Reference`	`STRING`
`SentToContact`	`BOOLEAN`
`CurrencyRate`	`DOUBLE`
`RemainingCredit`	`DOUBLE`
`Allocations`	ARRAY<STRUCT<AllocationID: STRING, Invoice: STRUCT<InvoiceID: STRING, InvoiceNumber: STRING, CreditNotes: ARRAY<VARIANT>, HasErrors: BOOLEAN, InvoiceAddresses: ARRAY<VARIANT>, InvoicePaymentServices: ARRAY<VARIANT>, IsDiscounted: BOOLEAN, LineItems: ARRAY<VARIANT>, Overpayments: ARRAY<VARIANT>, Payments: ARRAY<VARIANT>, Prepayments: ARRAY<VARIANT>>, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>
`AppliedAmount`	`DOUBLE`
`Payments`	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
`BrandingThemeID`	`STRING`
`StatusAttributeString`	`STRING`
`HasAttachments`	`BOOLEAN`
`HasErrors`	`BOOLEAN`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`Warnings`	`ARRAY<STRUCT<Message: STRING>>`
`InvoiceAddresses`	`ARRAY<STRUCT<InvoiceAddressType: STRING, AddressLine1: STRING, AddressLine2: STRING, AddressLine3: STRING, AddressLine4: STRING, City: STRING, Region: STRING, PostalCode: STRING, Country: STRING>>`
`IsDeleted`	`BOOLEAN`

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
`Date`	`STRING`
`DueDate`	`STRING`
`Status`	`STRING`
`LineAmountTypes`	`STRING`
`LineItems`	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`CISDeduction`	`DOUBLE`
`CISRate`	`DOUBLE`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`CurrencyCode`	`STRING`
`FullyPaidOnDate`	`STRING`
`CreditNoteID`	`STRING`
`CreditNoteNumber`	`STRING`
`Reference`	`STRING`
`SentToContact`	`BOOLEAN`
`CurrencyRate`	`DOUBLE`
`RemainingCredit`	`DOUBLE`
`Allocations`	ARRAY<STRUCT<AllocationID: STRING, Invoice: STRUCT<InvoiceID: STRING, InvoiceNumber: STRING, CreditNotes: ARRAY<VARIANT>, HasErrors: BOOLEAN, InvoiceAddresses: ARRAY<VARIANT>, InvoicePaymentServices: ARRAY<VARIANT>, IsDiscounted: BOOLEAN, LineItems: ARRAY<VARIANT>, Overpayments: ARRAY<VARIANT>, Payments: ARRAY<VARIANT>, Prepayments: ARRAY<VARIANT>>, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>
`AppliedAmount`	`DOUBLE`
`Payments`	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
`BrandingThemeID`	`STRING`
`StatusAttributeString`	`STRING`
`HasAttachments`	`BOOLEAN`
`HasErrors`	`BOOLEAN`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`Warnings`	`ARRAY<STRUCT<Message: STRING>>`
`InvoiceAddresses`	`ARRAY<STRUCT<InvoiceAddressType: STRING, AddressLine1: STRING, AddressLine2: STRING, AddressLine3: STRING, AddressLine4: STRING, City: STRING, Region: STRING, PostalCode: STRING, Country: STRING>>`
`IsDeleted`	`BOOLEAN`

注記

このテーブルはVARIANT列を持つため、slowly changing dimensions (SCD) タイプ2をサポートしていません。

`currencies`

プライマリーキー: Code

同期モード: フル更新のみ

フィールド	データ型
`Code`	`STRING`
`Description`	`STRING`

`invoices`

プライマリーキー: InvoiceID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
`LineItems`	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
`Date`	`STRING`
`DueDate`	`STRING`
`LineAmountTypes`	`STRING`
`InvoiceNumber`	`STRING`
`Reference`	`STRING`
`BrandingThemeID`	`STRING`
`Url`	`STRING`
`CurrencyCode`	`STRING`
`CurrencyRate`	`DOUBLE`
`Status`	`STRING`
`SentToContact`	`BOOLEAN`
`ExpectedPaymentDate`	`STRING`
`PlannedPaymentDate`	`STRING`
`CISDeduction`	`DOUBLE`
`CISRate`	`DOUBLE`
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`TotalDiscount`	`DOUBLE`
`RoundingAmount`	`DOUBLE`
`EnteredTotal`	`DOUBLE`
`InvoiceID`	`STRING`
`RepeatingInvoiceID`	`STRING`
`HasAttachments`	`BOOLEAN`
`IsDiscounted`	`BOOLEAN`
`InvoicePaymentServices`	`ARRAY<VARIANT>`
`Payments`	`ARRAY<STRUCT<PaymentID:STRING,Date:STRING,Amount:DOUBLE,CurrencyRate:DOUBLE,Reference:STRING,HasAccount:BOOLEAN,HasValidationErrors:BOOLEAN>>`
`Prepayments`	`ARRAY<STRUCT<PrepaymentID:STRING,ID:STRING,Date:STRING,Reference:STRING,AppliedAmount:DOUBLE,Total:DOUBLE,CurrencyRate:DOUBLE>>`
`Overpayments`	`ARRAY<STRUCT<OverpaymentID:STRING,ID:STRING,Date:STRING,Reference:STRING,AppliedAmount:DOUBLE,Total:DOUBLE,CurrencyRate:DOUBLE>>`
`AmountDue`	`DOUBLE`
`AmountPaid`	`DOUBLE`
`FullyPaidOnDate`	`STRING`
`AmountCredited`	`DOUBLE`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`CreditNotes`	`ARRAY<STRUCT<CreditNoteID:STRING,CreditNoteNumber:STRING,ID:STRING,AppliedAmount:DOUBLE,DateString:STRING,Date:STRING,Total:DOUBLE>>`
`Attachments`	`ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>`
`HasErrors`	`BOOLEAN`
`StatusAttributeString`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message:STRING>>`
`Warnings`	`ARRAY<STRUCT<Message:STRING>>`
`InvoiceAddresses`	`ARRAY<STRUCT<InvoiceAddressType:STRING,AddressLine1:STRING,AddressLine2:STRING,AddressLine3:STRING,AddressLine4:STRING,City:STRING,Region:STRING,PostalCode:STRING,Country:STRING>>`
`IsDeleted`	`BOOLEAN`

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
`LineItems`	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
`Date`	`STRING`
`DueDate`	`STRING`
`LineAmountTypes`	`STRING`
`InvoiceNumber`	`STRING`
`Reference`	`STRING`
`BrandingThemeID`	`STRING`
`Url`	`STRING`
`CurrencyCode`	`STRING`
`CurrencyRate`	`DOUBLE`
`Status`	`STRING`
`SentToContact`	`BOOLEAN`
`ExpectedPaymentDate`	`STRING`
`PlannedPaymentDate`	`STRING`
`CISDeduction`	`DOUBLE`
`CISRate`	`DOUBLE`
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`TotalDiscount`	`DOUBLE`
`RoundingAmount`	`DOUBLE`
`EnteredTotal`	`DOUBLE`
`InvoiceID`	`STRING`
`RepeatingInvoiceID`	`STRING`
`HasAttachments`	`BOOLEAN`
`IsDiscounted`	`BOOLEAN`
`InvoicePaymentServices`	`ARRAY<VARIANT>`
`Payments`	`ARRAY<STRUCT<PaymentID:STRING,Date:STRING,Amount:DOUBLE,CurrencyRate:DOUBLE,Reference:STRING,HasAccount:BOOLEAN,HasValidationErrors:BOOLEAN>>`
`Prepayments`	`ARRAY<STRUCT<PrepaymentID:STRING,ID:STRING,Date:STRING,Reference:STRING,AppliedAmount:DOUBLE,Total:DOUBLE,CurrencyRate:DOUBLE>>`
`Overpayments`	`ARRAY<STRUCT<OverpaymentID:STRING,ID:STRING,Date:STRING,Reference:STRING,AppliedAmount:DOUBLE,Total:DOUBLE,CurrencyRate:DOUBLE>>`
`AmountDue`	`DOUBLE`
`AmountPaid`	`DOUBLE`
`FullyPaidOnDate`	`STRING`
`AmountCredited`	`DOUBLE`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`CreditNotes`	`ARRAY<STRUCT<CreditNoteID:STRING,CreditNoteNumber:STRING,ID:STRING,AppliedAmount:DOUBLE,DateString:STRING,Date:STRING,Total:DOUBLE>>`
`Attachments`	`ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>`
`HasErrors`	`BOOLEAN`
`StatusAttributeString`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message:STRING>>`
`Warnings`	`ARRAY<STRUCT<Message:STRING>>`
`InvoiceAddresses`	`ARRAY<STRUCT<InvoiceAddressType:STRING,AddressLine1:STRING,AddressLine2:STRING,AddressLine3:STRING,AddressLine4:STRING,City:STRING,Region:STRING,PostalCode:STRING,Country:STRING>>`
`IsDeleted`	`BOOLEAN`

注記

このテーブルはVARIANT列を持つため、slowly changing dimensions (SCD) タイプ2をサポートしていません。

`items`

プライマリーキー: ItemID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`ItemID`	`STRING`
`Code`	`STRING`
`Name`	`STRING`
`Description`	`STRING`
`PurchaseDescription`	`STRING`
`InventoryAssetAccountCode`	`STRING`
`IsSold`	`BOOLEAN`
`IsPurchased`	`BOOLEAN`
`IsTrackedAsInventory`	`BOOLEAN`
`PurchaseDetails`	`STRUCT<UnitPrice: DOUBLE, AccountCode: STRING, COGSAccountCode: STRING, TaxType: STRING>`
`SalesDetails`	`STRUCT<UnitPrice: DOUBLE, AccountCode: STRING, COGSAccountCode: STRING, TaxType: STRING>`
`TotalCostPool`	`DOUBLE`
`QuantityOnHand`	`DOUBLE`
`QuantityAvailable`	`DOUBLE`
`QuantityOnBackOrder`	`DOUBLE`
`StatusAttributeString`	`STRING`
`UpdatedDateUTC`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`

フィールド	データ型
`ItemID`	`STRING`
`Code`	`STRING`
`Name`	`STRING`
`Description`	`STRING`
`PurchaseDescription`	`STRING`
`InventoryAssetAccountCode`	`STRING`
`IsSold`	`BOOLEAN`
`IsPurchased`	`BOOLEAN`
`IsTrackedAsInventory`	`BOOLEAN`
`PurchaseDetails`	`STRUCT<UnitPrice: DOUBLE, AccountCode: STRING, COGSAccountCode: STRING, TaxType: STRING>`
`SalesDetails`	`STRUCT<UnitPrice: DOUBLE, AccountCode: STRING, COGSAccountCode: STRING, TaxType: STRING>`
`TotalCostPool`	`DOUBLE`
`QuantityOnHand`	`DOUBLE`
`QuantityAvailable`	`DOUBLE`
`QuantityOnBackOrder`	`DOUBLE`
`StatusAttributeString`	`STRING`
`UpdatedDateUTC`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`

`linked_transactions`

プライマリーキー: LinkedTransactionID

同期モード: フル更新のみ

フィールド	データ型
`LinkedTransactionID`	`STRING`
`SourceTransactionID`	`STRING`
`SourceLineItemID`	`STRING`
`ContactID`	`STRING`
`TargetTransactionID`	`STRING`
`TargetLineItemID`	`STRING`
`Status`	`STRING`
`Type`	`STRING`
`UpdatedDateUTC`	`STRING`
`SourceTransactionTypeCode`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`

フィールド	データ型
`LinkedTransactionID`	`STRING`
`SourceTransactionID`	`STRING`
`SourceLineItemID`	`STRING`
`ContactID`	`STRING`
`TargetTransactionID`	`STRING`
`TargetLineItemID`	`STRING`
`Status`	`STRING`
`Type`	`STRING`
`UpdatedDateUTC`	`STRING`
`SourceTransactionTypeCode`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`

`manual_journals`

プライマリーキー: ManualJournalID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`ManualJournalID`	`STRING`
`Narration`	`STRING`
`JournalLines`	`ARRAY<STRUCT< LineAmount DOUBLE, AccountCode STRING, AccountID STRING, Description STRING, TaxType STRING, Tracking ARRAY<STRUCT< TrackingCategoryID STRING, Name STRING, Option STRING, TrackingOptionID STRING, Status STRING >>, TaxAmount DOUBLE, IsBlank BOOLEAN >>`
`Date`	`STRING`
`LineAmountTypes`	`STRING`
`Status`	`STRING`
`Url`	`STRING`
`ShowOnCashBasisReports`	`BOOLEAN`
`HasAttachments`	`BOOLEAN`
`UpdatedDateUTC`	`STRING`
`StatusAttributeString`	`STRING`
`Warnings`	`ARRAY<STRUCT<Message STRING>>`
`ValidationErrors`	`ARRAY<STRUCT<Message STRING>>`
`Attachments`	`ARRAY<STRUCT< AttachmentID STRING, FileName STRING, Url STRING, MimeType STRING, ContentLength BIGINT, IncludeOnline BOOLEAN >>`
`IsDeleted`	`BOOLEAN`

フィールド	データ型
`ManualJournalID`	`STRING`
`Narration`	`STRING`
`JournalLines`	`ARRAY<STRUCT< LineAmount DOUBLE, AccountCode STRING, AccountID STRING, Description STRING, TaxType STRING, Tracking ARRAY<STRUCT< TrackingCategoryID STRING, Name STRING, Option STRING, TrackingOptionID STRING, Status STRING >>, TaxAmount DOUBLE, IsBlank BOOLEAN >>`
`Date`	`STRING`
`LineAmountTypes`	`STRING`
`Status`	`STRING`
`Url`	`STRING`
`ShowOnCashBasisReports`	`BOOLEAN`
`HasAttachments`	`BOOLEAN`
`UpdatedDateUTC`	`STRING`
`StatusAttributeString`	`STRING`
`Warnings`	`ARRAY<STRUCT<Message STRING>>`
`ValidationErrors`	`ARRAY<STRUCT<Message STRING>>`
`Attachments`	`ARRAY<STRUCT< AttachmentID STRING, FileName STRING, Url STRING, MimeType STRING, ContentLength BIGINT, IncludeOnline BOOLEAN >>`
`IsDeleted`	`BOOLEAN`

`organisation`

プライマリーキー: OrganisationID

同期モード: フル更新のみ

フィールド	データ型
`OrganisationID`	`STRING`
`APIKey`	`STRING`
`Name`	`STRING`
`LegalName`	`STRING`
`PaysTax`	`BOOLEAN`
`Version`	`STRING`
`OrganisationType`	`STRING`
`BaseCurrency`	`STRING`
`CountryCode`	`STRING`
`IsDemoCompany`	`BOOLEAN`
`OrganisationStatus`	`STRING`
`RegistrationNumber`	`STRING`
`EmployerIdentificationNumber`	`STRING`
`TaxNumber`	`STRING`
`TaxNumberName`	`STRING`
`FinancialYearEndDay`	`BIGINT`
`FinancialYearEndMonth`	`BIGINT`
`SalesTaxBasis`	`STRING`
`SalesTaxPeriod`	`STRING`
`DefaultSalesTax`	`STRING`
`DefaultPurchasesTax`	`STRING`
`PeriodLockDate`	`STRING`
`EndOfYearLockDate`	`STRING`
`CreatedDateUTC`	`STRING`
`Timezone`	`STRING`
`OrganisationEntityType`	`STRING`
`ShortCode`	`STRING`
`Class`	`STRING`
`Edition`	`STRING`
`LineOfBusiness`	`STRING`
`Addresses`	`ARRAY<STRUCT<AddressType STRING, AddressLine1 STRING, AddressLine2 STRING, AddressLine3 STRING, AddressLine4 STRING, City STRING, Region STRING, PostalCode STRING, Country STRING, AttentionTo STRING>>`
`Phones`	`ARRAY<STRUCT<PhoneType STRING, PhoneNumber STRING, PhoneAreaCode STRING, PhoneCountryCode STRING>>`
`ExternalLinks`	`ARRAY<STRUCT<LinkType STRING, Url STRING, Description STRING>>`
`PaymentTerms`	`STRUCT<Bills STRUCT<Day BIGINT, Type STRING>, Sales STRUCT<Day BIGINT, Type STRING>>`

フィールド	データ型
`OrganisationID`	`STRING`
`APIKey`	`STRING`
`Name`	`STRING`
`LegalName`	`STRING`
`PaysTax`	`BOOLEAN`
`Version`	`STRING`
`OrganisationType`	`STRING`
`BaseCurrency`	`STRING`
`CountryCode`	`STRING`
`IsDemoCompany`	`BOOLEAN`
`OrganisationStatus`	`STRING`
`RegistrationNumber`	`STRING`
`EmployerIdentificationNumber`	`STRING`
`TaxNumber`	`STRING`
`TaxNumberName`	`STRING`
`FinancialYearEndDay`	`BIGINT`
`FinancialYearEndMonth`	`BIGINT`
`SalesTaxBasis`	`STRING`
`SalesTaxPeriod`	`STRING`
`DefaultSalesTax`	`STRING`
`DefaultPurchasesTax`	`STRING`
`PeriodLockDate`	`STRING`
`EndOfYearLockDate`	`STRING`
`CreatedDateUTC`	`STRING`
`Timezone`	`STRING`
`OrganisationEntityType`	`STRING`
`ShortCode`	`STRING`
`Class`	`STRING`
`Edition`	`STRING`
`LineOfBusiness`	`STRING`
`Addresses`	`ARRAY<STRUCT<AddressType STRING, AddressLine1 STRING, AddressLine2 STRING, AddressLine3 STRING, AddressLine4 STRING, City STRING, Region STRING, PostalCode STRING, Country STRING, AttentionTo STRING>>`
`Phones`	`ARRAY<STRUCT<PhoneType STRING, PhoneNumber STRING, PhoneAreaCode STRING, PhoneCountryCode STRING>>`
`ExternalLinks`	`ARRAY<STRUCT<LinkType STRING, Url STRING, Description STRING>>`
`PaymentTerms`	`STRUCT<Bills STRUCT<Day BIGINT, Type STRING>, Sales STRUCT<Day BIGINT, Type STRING>>`

`overpayments`

プライマリーキー: OverpaymentID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
`Date`	`STRING`
`DateString`	`STRING`
`Status`	`STRING`
`LineAmountTypes`	`STRING`
`LineItems`	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`CurrencyCode`	`STRING`
`OverpaymentID`	`STRING`
`CurrencyRate`	`DOUBLE`
`RemainingCredit`	`DOUBLE`
`Allocations`	`ARRAY<STRUCT<AllocationID: STRING, Invoice: VARIANT, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>`
`AppliedAmount`	`DOUBLE`
`Payments`	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
`HasAttachments`	`BOOLEAN`
`Reference`	`STRING`
`Attachments`	`ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>`

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
`Date`	`STRING`
`DateString`	`STRING`
`Status`	`STRING`
`LineAmountTypes`	`STRING`
`LineItems`	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`CurrencyCode`	`STRING`
`OverpaymentID`	`STRING`
`CurrencyRate`	`DOUBLE`
`RemainingCredit`	`DOUBLE`
`Allocations`	`ARRAY<STRUCT<AllocationID: STRING, Invoice: VARIANT, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>`
`AppliedAmount`	`DOUBLE`
`Payments`	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
`HasAttachments`	`BOOLEAN`
`Reference`	`STRING`
`Attachments`	`ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>`

注記

このテーブルはVARIANT列を持つため、slowly changing dimensions (SCD) タイプ2をサポートしていません。

`payments`

プライマリーキー: PaymentID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`Invoice`	`VARIANT`
`CreditNote`	`VARIANT`
`Prepayment`	`VARIANT`
`Overpayment`	`VARIANT`
`InvoiceNumber`	`STRING`
`CreditNoteNumber`	`STRING`
`BatchPayment`	`STRUCT<BatchPaymentID: STRING, Date: STRING, Amount: DOUBLE, Status: STRING, Type: STRING, Payments: ARRAY<VARIANT>, Account: STRUCT<AccountID: STRING, Code: STRING, Name: STRING>, Reference: STRING, Particulars: STRING, Code: STRING, Details: STRING, Narrative: STRING, DateString: STRING, TotalAmount: DOUBLE, UpdatedDateUTC: STRING, IsReconciled: BOOLEAN>`
`Account`	`VARIANT`
`Code`	`STRING`
`Date`	`STRING`
`CurrencyRate`	`DOUBLE`
`Amount`	`DOUBLE`
`BankAmount`	`DOUBLE`
`Reference`	`STRING`
`IsReconciled`	`BOOLEAN`
`Status`	`STRING`
`PaymentType`	`STRING`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`PaymentID`	`STRING`
`BatchPaymentID`	`STRING`
`BankAccountNumber`	`STRING`
`Particulars`	`STRING`
`Details`	`STRING`
`HasAccount`	`BOOLEAN`
`HasValidationErrors`	`BOOLEAN`
`StatusAttributeString`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`Warnings`	`ARRAY<STRUCT<Message: STRING>>`
`IsDeleted`	`BOOLEAN`

フィールド	データ型
`Invoice`	`VARIANT`
`CreditNote`	`VARIANT`
`Prepayment`	`VARIANT`
`Overpayment`	`VARIANT`
`InvoiceNumber`	`STRING`
`CreditNoteNumber`	`STRING`
`BatchPayment`	`STRUCT<BatchPaymentID: STRING, Date: STRING, Amount: DOUBLE, Status: STRING, Type: STRING, Payments: ARRAY<VARIANT>, Account: STRUCT<AccountID: STRING, Code: STRING, Name: STRING>, Reference: STRING, Particulars: STRING, Code: STRING, Details: STRING, Narrative: STRING, DateString: STRING, TotalAmount: DOUBLE, UpdatedDateUTC: STRING, IsReconciled: BOOLEAN>`
`Account`	`VARIANT`
`Code`	`STRING`
`Date`	`STRING`
`CurrencyRate`	`DOUBLE`
`Amount`	`DOUBLE`
`BankAmount`	`DOUBLE`
`Reference`	`STRING`
`IsReconciled`	`BOOLEAN`
`Status`	`STRING`
`PaymentType`	`STRING`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`PaymentID`	`STRING`
`BatchPaymentID`	`STRING`
`BankAccountNumber`	`STRING`
`Particulars`	`STRING`
`Details`	`STRING`
`HasAccount`	`BOOLEAN`
`HasValidationErrors`	`BOOLEAN`
`StatusAttributeString`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message: STRING>>`
`Warnings`	`ARRAY<STRUCT<Message: STRING>>`
`IsDeleted`	`BOOLEAN`

注記

このテーブルはVARIANT列を持つため、slowly changing dimensions (SCD) タイプ2をサポートしていません。

`prepayments`

プライマリーキー: PrepaymentID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
`Date`	`STRING`
`Status`	`STRING`
`LineAmountTypes`	`STRING`
`LineItems`	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`Reference`	`STRING`
`InvoiceNumber`	`STRING`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`CurrencyCode`	`STRING`
`PrepaymentID`	`STRING`
`BrandingThemeID`	`STRING`
`CurrencyRate`	`DOUBLE`
`RemainingCredit`	`DOUBLE`
`Allocations`	`ARRAY<STRUCT<AllocationID: STRING, Invoice: VARIANT, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>`
`Payments`	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
`AppliedAmount`	`DOUBLE`
`HasAttachments`	`BOOLEAN`
`Attachments`	`ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>`

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID: STRING, MergedToContactID: STRING, ContactNumber: STRING, AccountNumber: STRING, ContactStatus: STRING, Name: STRING, FirstName: STRING, LastName: STRING, CompanyNumber: STRING, EmailAddress: STRING, ContactPersons: VARIANT, BankAccountDetails: STRING, TaxNumber: STRING, TaxNumberType: STRING, AccountsReceivableTaxType: STRING, AccountsPayableTaxType: STRING, Addresses: VARIANT, Phones: VARIANT, IsSupplier: BOOLEAN, IsCustomer: BOOLEAN, SalesDefaultLineAmountType: STRING, PurchasesDefaultLineAmountType: STRING, DefaultCurrency: STRING, XeroNetworkKey: STRING, SalesDefaultAccountCode: STRING, PurchasesDefaultAccountCode: STRING, SalesTrackingCategories: VARIANT, PurchasesTrackingCategories: VARIANT, TrackingCategoryName: STRING, TrackingCategoryOption: STRING, PaymentTerms: VARIANT, UpdatedDateUTC: STRING, ContactGroups: VARIANT, Website: STRING, BrandingTheme: VARIANT, BatchPayments: VARIANT, Discount: DOUBLE, Balances: VARIANT, Attachments: VARIANT, HasAttachments: BOOLEAN, ValidationErrors: VARIANT, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING>
`Date`	`STRING`
`Status`	`STRING`
`LineAmountTypes`	`STRING`
`LineItems`	ARRAY<STRUCT<LineItemID: STRING, Description: STRING, Quantity: DOUBLE, UnitAmount: DOUBLE, ItemCode: STRING, AccountCode: STRING, AccountID: STRING, TaxType: STRING, TaxAmount: DOUBLE, Item: STRUCT<Code: STRING, Name: STRING, ItemID: STRING>, LineAmount: DOUBLE, Tracking: ARRAY<STRUCT<TrackingCategoryID: STRING, TrackingOptionID: STRING, Name: STRING, Option: STRING>>, DiscountRate: DOUBLE, DiscountAmount: DOUBLE, RepeatingInvoiceID: STRING, Taxability: STRING, SalesTaxCodeId: DOUBLE, TaxBreakdown: ARRAY<STRUCT<TaxComponentId: STRING, Type: STRING, Name: STRING, TaxPercentage: DOUBLE, TaxAmount: DOUBLE, TaxableAmount: DOUBLE, NonTaxableAmount: DOUBLE, ExemptAmount: DOUBLE, StateAssignedNo: STRING, JurisdictionRegion: STRING>>>>
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`Reference`	`STRING`
`InvoiceNumber`	`STRING`
`UpdatedDateUTC`	`STRING`
`UpdatedDateUTCString`	`STRING`
`CurrencyCode`	`STRING`
`PrepaymentID`	`STRING`
`BrandingThemeID`	`STRING`
`CurrencyRate`	`DOUBLE`
`RemainingCredit`	`DOUBLE`
`Allocations`	`ARRAY<STRUCT<AllocationID: STRING, Invoice: VARIANT, Overpayment: VARIANT, Prepayment: VARIANT, CreditNote: VARIANT, Amount: DOUBLE, Date: STRING, IsDeleted: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>>>`
`Payments`	ARRAY<STRUCT<Invoice: VARIANT, CreditNote: VARIANT, Prepayment: VARIANT, Overpayment: VARIANT, InvoiceNumber: STRING, CreditNoteNumber: STRING, BatchPayment: VARIANT, Account: VARIANT, Code: STRING, Date: STRING, CurrencyRate: DOUBLE, Amount: DOUBLE, BankAmount: DOUBLE, Reference: STRING, IsReconciled: BOOLEAN, Status: STRING, PaymentType: STRING, UpdatedDateUTC: STRING, UpdatedDateUTCString: STRING, PaymentID: STRING, BatchPaymentID: STRING, BankAccountNumber: STRING, Particulars: STRING, Details: STRING, HasAccount: BOOLEAN, HasValidationErrors: BOOLEAN, StatusAttributeString: STRING, ValidationErrors: ARRAY<STRUCT<Message: STRING>>, Warnings: ARRAY<STRUCT<Message: STRING>>>>
`AppliedAmount`	`DOUBLE`
`HasAttachments`	`BOOLEAN`
`Attachments`	`ARRAY<STRUCT<AttachmentID: STRING, FileName: STRING, Url: STRING, MimeType: STRING, ContentLength: BIGINT, IncludeOnline: BOOLEAN>>`

注記

このテーブルはVARIANT列を持つため、slowly changing dimensions (SCD) タイプ2をサポートしていません。

`purchase_orders`

プライマリーキー: PurchaseOrderID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`Contact`	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
`LineItems`	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
`Type`	`STRING`
`Date`	`STRING`
`DateString`	`STRING`
`DeliveryDate`	`STRING`
`DeliveryDateString`	`STRING`
`LineAmountTypes`	`STRING`
`PurchaseOrderNumber`	`STRING`
`Reference`	`STRING`
`BrandingThemeID`	`STRING`
`CurrencyCode`	`STRING`
`Status`	`STRING`
`SentToContact`	`BOOLEAN`
`DeliveryAddress`	`STRING`
`AttentionTo`	`STRING`
`Telephone`	`STRING`
`DeliveryInstructions`	`STRING`
`ExpectedArrivalDate`	`STRING`
`ExpectedArrivalDateString`	`STRING`
`PurchaseOrderID`	`STRING`
`CurrencyRate`	`DOUBLE`
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`TotalDiscount`	`DOUBLE`
`HasAttachments`	`BOOLEAN`
`HasErrors`	`BOOLEAN`
`IsDiscounted`	`BOOLEAN`
`UpdatedDateUTC`	`STRING`
`StatusAttributeString`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message:STRING>>`
`Warnings`	`ARRAY<STRUCT<Message:STRING>>`
`Attachments`	`ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>`
`IsDeleted`	`BOOLEAN`

フィールド	データ型
`Contact`	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
`LineItems`	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
`Type`	`STRING`
`Date`	`STRING`
`DateString`	`STRING`
`DeliveryDate`	`STRING`
`DeliveryDateString`	`STRING`
`LineAmountTypes`	`STRING`
`PurchaseOrderNumber`	`STRING`
`Reference`	`STRING`
`BrandingThemeID`	`STRING`
`CurrencyCode`	`STRING`
`Status`	`STRING`
`SentToContact`	`BOOLEAN`
`DeliveryAddress`	`STRING`
`AttentionTo`	`STRING`
`Telephone`	`STRING`
`DeliveryInstructions`	`STRING`
`ExpectedArrivalDate`	`STRING`
`ExpectedArrivalDateString`	`STRING`
`PurchaseOrderID`	`STRING`
`CurrencyRate`	`DOUBLE`
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`TotalDiscount`	`DOUBLE`
`HasAttachments`	`BOOLEAN`
`HasErrors`	`BOOLEAN`
`IsDiscounted`	`BOOLEAN`
`UpdatedDateUTC`	`STRING`
`StatusAttributeString`	`STRING`
`ValidationErrors`	`ARRAY<STRUCT<Message:STRING>>`
`Warnings`	`ARRAY<STRUCT<Message:STRING>>`
`Attachments`	`ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>`
`IsDeleted`	`BOOLEAN`

注記

このテーブルはVARIANT列を持つため、slowly changing dimensions (SCD) タイプ2をサポートしていません。

`repeating_invoices`

プライマリーキー: RepeatingInvoiceID

同期モード: フル更新のみ

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
`Schedule`	`STRUCT<Period:BIGINT,Unit:STRING,DueDate:BIGINT,DueDateType:STRING,StartDate:STRING,NextScheduledDate:STRING,NextScheduledDateString:STRING,EndDate:STRING>`
`LineItems`	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
`LineAmountTypes`	`STRING`
`Reference`	`STRING`
`BrandingThemeID`	`STRING`
`CurrencyCode`	`STRING`
`Status`	`STRING`
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`UpdatedDateUTC`	`STRING`
`RepeatingInvoiceID`	`STRING`
`ID`	`STRING`
`HasAttachments`	`BOOLEAN`
`Attachments`	`ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>`
`ApprovedForSending`	`BOOLEAN`
`SendCopy`	`BOOLEAN`
`MarkAsSent`	`BOOLEAN`
`IncludePDF`	`BOOLEAN`

フィールド	データ型
`Type`	`STRING`
`Contact`	STRUCT<ContactID:STRING,MergedToContactID:STRING,ContactNumber:STRING,AccountNumber:STRING,ContactStatus:STRING,Name:STRING,FirstName:STRING,LastName:STRING,CompanyNumber:STRING,EmailAddress:STRING,BankAccountDetails:STRING,TaxNumber:STRING,TaxNumberType:STRING,AccountsReceivableTaxType:STRING,AccountsPayableTaxType:STRING,IsSupplier:BOOLEAN,IsCustomer:BOOLEAN,DefaultCurrency:STRING,UpdatedDateUTC:STRING,Website:STRING,Discount:DOUBLE,HasAttachments:BOOLEAN,HasValidationErrors:BOOLEAN,ContactPersons:VARIANT,Addresses:VARIANT,Phones:VARIANT>
`Schedule`	`STRUCT<Period:BIGINT,Unit:STRING,DueDate:BIGINT,DueDateType:STRING,StartDate:STRING,NextScheduledDate:STRING,NextScheduledDateString:STRING,EndDate:STRING>`
`LineItems`	ARRAY<STRUCT<LineItemID:STRING,Description:STRING,Quantity:DOUBLE,UnitAmount:DOUBLE,ItemCode:STRING,AccountCode:STRING,AccountID:STRING,TaxType:STRING,TaxAmount:DOUBLE,Item:STRUCT<Code:STRING,Name:STRING,ItemID:STRING>,LineAmount:DOUBLE,Tracking:ARRAY<STRUCT<TrackingCategoryID:STRING,TrackingOptionID:STRING,Name:STRING,Option:STRING>>,DiscountRate:DOUBLE,DiscountAmount:DOUBLE,RepeatingInvoiceID:STRING,Taxability:STRING,SalesTaxCodeId:DOUBLE,TaxBreakdown:ARRAY<STRUCT<TaxComponentId:STRING,Type:STRING,Name:STRING,TaxPercentage:DOUBLE,TaxAmount:DOUBLE,TaxableAmount:DOUBLE,NonTaxableAmount:DOUBLE,ExemptAmount:DOUBLE,StateAssignedNo:STRING,JurisdictionRegion:STRING>>>>
`LineAmountTypes`	`STRING`
`Reference`	`STRING`
`BrandingThemeID`	`STRING`
`CurrencyCode`	`STRING`
`Status`	`STRING`
`SubTotal`	`DOUBLE`
`TotalTax`	`DOUBLE`
`Total`	`DOUBLE`
`UpdatedDateUTC`	`STRING`
`RepeatingInvoiceID`	`STRING`
`ID`	`STRING`
`HasAttachments`	`BOOLEAN`
`Attachments`	`ARRAY<STRUCT<AttachmentID:STRING,FileName:STRING,Url:STRING,MimeType:STRING,ContentLength:BIGINT,IncludeOnline:BOOLEAN>>`
`ApprovedForSending`	`BOOLEAN`
`SendCopy`	`BOOLEAN`
`MarkAsSent`	`BOOLEAN`
`IncludePDF`	`BOOLEAN`

注記

このテーブルはVARIANT列を持つため、slowly changing dimensions (SCD) タイプ2をサポートしていません。

`tax_rates`

プライマリーキー: TaxType

同期モード: フル更新のみ

フィールド	データ型
`Name`	`STRING`
`TaxType`	`STRING`
`TaxComponents`	`ARRAY<STRUCT<Name: STRING, Rate: DOUBLE, IsCompound: BOOLEAN, IsNonRecoverable: BOOLEAN>>`
`Status`	`STRING`
`ReportTaxType`	`STRING`
`CanApplyToAssets`	`BOOLEAN`
`CanApplyToEquity`	`BOOLEAN`
`CanApplyToExpenses`	`BOOLEAN`
`CanApplyToLiabilities`	`BOOLEAN`
`CanApplyToRevenue`	`BOOLEAN`
`DisplayTaxRate`	`DOUBLE`
`EffectiveRate`	`DOUBLE`

フィールド	データ型
`Name`	`STRING`
`TaxType`	`STRING`
`TaxComponents`	`ARRAY<STRUCT<Name: STRING, Rate: DOUBLE, IsCompound: BOOLEAN, IsNonRecoverable: BOOLEAN>>`
`Status`	`STRING`
`ReportTaxType`	`STRING`
`CanApplyToAssets`	`BOOLEAN`
`CanApplyToEquity`	`BOOLEAN`
`CanApplyToExpenses`	`BOOLEAN`
`CanApplyToLiabilities`	`BOOLEAN`
`CanApplyToRevenue`	`BOOLEAN`
`DisplayTaxRate`	`DOUBLE`
`EffectiveRate`	`DOUBLE`

`tracking_categories`

プライマリーキー: TrackingCategoryID

同期モード: フル更新のみ

フィールド	データ型
`TrackingCategoryID`	`STRING`
`TrackingOptionID`	`STRING`
`Name`	`STRING`
`Option`	`STRING`
`Status`	`STRING`
`Options`	`ARRAY<STRUCT<TrackingOptionID STRING, Name STRING, Status STRING, TrackingCategoryID STRING, HasValidationErrors BOOLEAN, IsDeleted BOOLEAN, IsArchived BOOLEAN, IsActive BOOLEAN>>`

フィールド	データ型
`TrackingCategoryID`	`STRING`
`TrackingOptionID`	`STRING`
`Name`	`STRING`
`Option`	`STRING`
`Status`	`STRING`
`Options`	`ARRAY<STRUCT<TrackingOptionID STRING, Name STRING, Status STRING, TrackingCategoryID STRING, HasValidationErrors BOOLEAN, IsDeleted BOOLEAN, IsArchived BOOLEAN, IsActive BOOLEAN>>`

`users`

プライマリーキー: UserID

同期モード: 増分

カーソルフィールド： UpdatedDateUTC

フィールド	データ型
`UserID`	`STRING`
`EmailAddress`	`STRING`
`FirstName`	`STRING`
`LastName`	`STRING`
`UpdatedDateUTC`	`STRING`
`IsSubscriber`	`BOOLEAN`
`OrganisationRole`	`STRING`
`GlobalUserID`	`STRING`

`projects`

プライマリーキー: projectId

同期モード: フル更新のみ

フィールド	データ型
`projectId`	`STRING`
`contactId`	`STRING`
`name`	`STRING`
`currencyCode`	`STRING`
`minutesLogged`	`BIGINT`
`totalTaskAmount`	`STRUCT<currency: STRING, value: DOUBLE>`
`totalExpenseAmount`	`STRUCT<currency: STRING, value: DOUBLE>`
`estimateAmount`	`STRUCT<currency: STRING, value: DOUBLE>`
`minutesToBeInvoiced`	`BIGINT`
`taskAmountToBeInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`taskAmountInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`expenseAmountToBeInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`expenseAmountInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`projectAmountInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`deposit`	`STRUCT<currency: STRING, value: DOUBLE>`
`depositApplied`	`STRUCT<currency: STRING, value: DOUBLE>`
`creditNoteAmount`	`STRUCT<currency: STRING, value: DOUBLE>`
`deadlineUtc`	`TIMESTAMP`
`totalInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`totalToBeInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`estimate`	`STRUCT<currency: STRING, value: DOUBLE>`
`status`	`STRING`

フィールド	データ型
`projectId`	`STRING`
`contactId`	`STRING`
`name`	`STRING`
`currencyCode`	`STRING`
`minutesLogged`	`BIGINT`
`totalTaskAmount`	`STRUCT<currency: STRING, value: DOUBLE>`
`totalExpenseAmount`	`STRUCT<currency: STRING, value: DOUBLE>`
`estimateAmount`	`STRUCT<currency: STRING, value: DOUBLE>`
`minutesToBeInvoiced`	`BIGINT`
`taskAmountToBeInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`taskAmountInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`expenseAmountToBeInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`expenseAmountInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`projectAmountInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`deposit`	`STRUCT<currency: STRING, value: DOUBLE>`
`depositApplied`	`STRUCT<currency: STRING, value: DOUBLE>`
`creditNoteAmount`	`STRUCT<currency: STRING, value: DOUBLE>`
`deadlineUtc`	`TIMESTAMP`
`totalInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`totalToBeInvoiced`	`STRUCT<currency: STRING, value: DOUBLE>`
`estimate`	`STRUCT<currency: STRING, value: DOUBLE>`
`status`	`STRING`

必要な OAuth 権限

接続設定中にサインインすると、コネクタは以下の読み取り専用OAuthスコープを要求します。各スコープで付与される権限については、OAuth 2.0スコープを参照してください。

スコープ	必要なもの
`openid`、`profile`、`email`、 `offline_access`	ベースラインアクセス。`offline_access`を使用すると、コネクタはラン間でアクセストークンを更新できます。
`accounting.settings.read`	`accounts`、`branding_themes`、`currencies`、`items`、`organisation`、`tax_rates`、`tracking_categories`、 `users`
`accounting.contacts.read`	`contacts`, `contact_groups`
`accounting.invoices.read`	`credit_notes`、`invoices`、`linked_transactions`、`purchase_orders`、 `repeating_invoices`
`accounting.payments.read`	`overpayments`、`payments`、 `prepayments`
`accounting.banktransactions.read`	`bank_transactions`, `bank_transfers`
`accounting.manualjournals.read`	`manual_journals`
`accounting.budgets.read`	`budgets`
`projects.read`	`projects`

スコープ	必要なもの
`openid`、`profile`、`email`、 `offline_access`	ベースラインアクセス。`offline_access`を使用すると、コネクタはラン間でアクセストークンを更新できます。
`accounting.settings.read`	`accounts`、`branding_themes`、`currencies`、`items`、`organisation`、`tax_rates`、`tracking_categories`、 `users`
`accounting.contacts.read`	`contacts`, `contact_groups`
`accounting.invoices.read`	`credit_notes`、`invoices`、`linked_transactions`、`purchase_orders`、 `repeating_invoices`
`accounting.payments.read`	`overpayments`、`payments`、 `prepayments`
`accounting.banktransactions.read`	`bank_transactions`, `bank_transfers`
`accounting.manualjournals.read`	`manual_journals`
`accounting.budgets.read`	`budgets`
`projects.read`	`projects`

サポートされているソーステーブル​

コネクタオプション​

転送先テーブルスキーマ​

accounts​

bank_transactions​

bank_transfers​

branding_themes​

budgets​

contacts​

contact_groups​

credit_notes​

currencies​

invoices​

items​

linked_transactions​

manual_journals​

organisation​

overpayments​

payments​

prepayments​

purchase_orders​

repeating_invoices​

tax_rates​

tracking_categories​

users​

projects​

必要な OAuth 権限​

サポートされているソーステーブル

コネクタオプション

転送先テーブルスキーマ

`accounts`

`bank_transactions`

`bank_transfers`

`branding_themes`

`budgets`

`contacts`

`contact_groups`

`credit_notes`

`currencies`

`invoices`

`items`

`linked_transactions`

`manual_journals`

`organisation`

`overpayments`

`payments`

`prepayments`

`purchase_orders`

`repeating_invoices`

`tax_rates`

`tracking_categories`

`users`

`projects`

必要な OAuth 権限