QuickBooksコネクタの参照

備考

ベータ版

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

このページには、マネージドQuickBooksコネクタの参照情報が含まれており、サポートされるソーステーブルと宛先テーブルのスキーマも記載されています。

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

QuickBooks コネクタは、すべて default ソーススキーマの下にある次のソーステーブルをサポートしています：

ソーステーブル	プライマリーキー	説明	同期モード	カーソルフィールド
account	Id	勘定科目表のアカウント。	インクリメンタル	last_updated_time
class	Id	収入と支出の追跡に使用されるクラス。	インクリメンタル	last_updated_time
customer	Id	顧客とサブ顧客（ジョブ）	インクリメンタル	last_updated_time
customer_type	Id	顧客をグループ化するために使用される顧客タイプ。	インクリメンタル	last_updated_time
department	Id	トランザクションの追跡に使用される場所（部門）。	インクリメンタル	last_updated_time
employee	Id	従業員。	インクリメンタル	last_updated_time
item	Id	製品・サービス。	インクリメンタル	last_updated_time
payment_method	Id	現金、小切手、クレジットカードなどの支払い方法	インクリメンタル	last_updated_time
term	Id	支払い条件。	インクリメンタル	last_updated_time
vendor	Id	ベンダー。	インクリメンタル	last_updated_time
budget	Id	予算とその予算の詳細。	インクリメンタル	last_updated_time
tax_code	Id	売上税コード。	フル更新のみ
tax_rate	Id	売上税率。	インクリメンタル	last_updated_time
invoice	Id	請求書。	インクリメンタル	last_updated_time
bill	Id	ベンダーからの請求書。	インクリメンタル	last_updated_time
bill_payment	Id	請求書に対して行われた支払い。	インクリメンタル	last_updated_time
payment	Id	顧客から受け取った支払い。	インクリメンタル	last_updated_time
estimate	Id	推定値。	インクリメンタル	last_updated_time
credit_memo	Id	クレジットメモ。	インクリメンタル	last_updated_time
sales_receipt	Id	販売レシート。	インクリメンタル	last_updated_time
refund_receipt	Id	返金の領収書。	インクリメンタル	last_updated_time
purchase	Id	経費、小切手、クレジットカードの請求。	インクリメンタル	last_updated_time
purchase_order	Id	発注書。	インクリメンタル	last_updated_time
deposit	Id	銀行預金。	インクリメンタル	last_updated_time
transfer	Id	アカウント間での転送。	インクリメンタル	last_updated_time
journal_entry	Id	仕訳帳エントリ。	インクリメンタル	last_updated_time
vendor_credit	Id	ベンダーのクレジット。	インクリメンタル	last_updated_time
credit_card_payment	Id	クレジットカード支払い。	インクリメンタル	last_updated_time
attachable	Id	レコードにリンクされた添付ファイルとメモ。	インクリメンタル	last_updated_time
recurring_transaction	Id	定期的なトランザクションのTemplate。	インクリメンタル	last_updated_time
tax_agency	Id	税務当局。	インクリメンタル	last_updated_time
time_activity	Id	時間アクティビティエントリ。	インクリメンタル	last_updated_time
company_info	Id	企業情報。	フル更新のみ
preferences	Id	会社の環境設定。	フル更新のみ
tax_classification	Code	税区分。	フル更新のみ
company_currency	Id	会社で有効な通貨。	インクリメンタル	last_updated_time
exchange_rate	SourceCurrencyCode、TargetCurrencyCode、 AsOfDate	通貨為替レート。	インクリメンタル	last_updated_time

ソーステーブル	プライマリーキー	説明	同期モード	カーソルフィールド
account	Id	勘定科目表のアカウント。	インクリメンタル	last_updated_time
class	Id	収入と支出の追跡に使用されるクラス。	インクリメンタル	last_updated_time
customer	Id	顧客とサブ顧客（ジョブ）	インクリメンタル	last_updated_time
customer_type	Id	顧客をグループ化するために使用される顧客タイプ。	インクリメンタル	last_updated_time
department	Id	トランザクションの追跡に使用される場所（部門）。	インクリメンタル	last_updated_time
employee	Id	従業員。	インクリメンタル	last_updated_time
item	Id	製品・サービス。	インクリメンタル	last_updated_time
payment_method	Id	現金、小切手、クレジットカードなどの支払い方法	インクリメンタル	last_updated_time
term	Id	支払い条件。	インクリメンタル	last_updated_time
vendor	Id	ベンダー。	インクリメンタル	last_updated_time
budget	Id	予算とその予算の詳細。	インクリメンタル	last_updated_time
tax_code	Id	売上税コード。	フル更新のみ
tax_rate	Id	売上税率。	インクリメンタル	last_updated_time
invoice	Id	請求書。	インクリメンタル	last_updated_time
bill	Id	ベンダーからの請求書。	インクリメンタル	last_updated_time
bill_payment	Id	請求書に対して行われた支払い。	インクリメンタル	last_updated_time
payment	Id	顧客から受け取った支払い。	インクリメンタル	last_updated_time
estimate	Id	推定値。	インクリメンタル	last_updated_time
credit_memo	Id	クレジットメモ。	インクリメンタル	last_updated_time
sales_receipt	Id	販売レシート。	インクリメンタル	last_updated_time
refund_receipt	Id	返金の領収書。	インクリメンタル	last_updated_time
purchase	Id	経費、小切手、クレジットカードの請求。	インクリメンタル	last_updated_time
purchase_order	Id	発注書。	インクリメンタル	last_updated_time
deposit	Id	銀行預金。	インクリメンタル	last_updated_time
transfer	Id	アカウント間での転送。	インクリメンタル	last_updated_time
journal_entry	Id	仕訳帳エントリ。	インクリメンタル	last_updated_time
vendor_credit	Id	ベンダーのクレジット。	インクリメンタル	last_updated_time
credit_card_payment	Id	クレジットカード支払い。	インクリメンタル	last_updated_time
attachable	Id	レコードにリンクされた添付ファイルとメモ。	インクリメンタル	last_updated_time
recurring_transaction	Id	定期的なトランザクションのTemplate。	インクリメンタル	last_updated_time
tax_agency	Id	税務当局。	インクリメンタル	last_updated_time
time_activity	Id	時間アクティビティエントリ。	インクリメンタル	last_updated_time
company_info	Id	企業情報。	フル更新のみ
preferences	Id	会社の環境設定。	フル更新のみ
tax_classification	Code	税区分。	フル更新のみ
company_currency	Id	会社で有効な通貨。	インクリメンタル	last_updated_time
exchange_rate	SourceCurrencyCode、TargetCurrencyCode、 AsOfDate	通貨為替レート。	インクリメンタル	last_updated_time

コネクターオプション

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

オプション	Type	スコープ	必須	適用対象	説明
start_datetime	String	パイプライン	No	すべての増分テーブル	データの取り込みを開始する最も古い日時（yyyy-MM-ddTHH:mm:ssXXX形式、例：2024-01-01T00:00:00Z）。各テーブルの最初の同期にのみ適用されます。以降の同期は保存されたカーソルから再開されます。設定しない場合、exchange_rateは30日前から起動し、他の増分テーブルは365日前から起動します。

オプション	Type	スコープ	必須	適用対象	説明
start_datetime	String	パイプライン	No	すべての増分テーブル	データの取り込みを開始する最も古い日時（yyyy-MM-ddTHH:mm:ssXXX形式、例：2024-01-01T00:00:00Z）。各テーブルの最初の同期にのみ適用されます。以降の同期は保存されたカーソルから再開されます。設定しない場合、exchange_rateは30日前から起動し、他の増分テーブルは365日前から起動します。

アップグレード先テーブル スキーマ

account

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
AcctNum	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
ParentRef	STRUCT<value: STRING, name: STRING>
Description	STRING
Active	BOOLEAN
SubAccount	BOOLEAN
Classification	STRING
FullyQualifiedName	STRING
AccountType	STRING
CurrentBalanceWithSubAccounts	DECIMAL(38,9)
TaxCodeRef	STRUCT<value: STRING, name: STRING>
AccountSubType	STRING
CurrentBalance	DECIMAL(38,9)
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
AcctNum	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
ParentRef	STRUCT<value: STRING, name: STRING>
Description	STRING
Active	BOOLEAN
SubAccount	BOOLEAN
Classification	STRING
FullyQualifiedName	STRING
AccountType	STRING
CurrentBalanceWithSubAccounts	DECIMAL(38,9)
TaxCodeRef	STRUCT<value: STRING, name: STRING>
AccountSubType	STRING
CurrentBalance	DECIMAL(38,9)
is_deleted	BOOLEAN

class

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
SubClass	BOOLEAN
Active	BOOLEAN
FullyQualifiedName	STRING
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
SubClass	BOOLEAN
Active	BOOLEAN
FullyQualifiedName	STRING
is_deleted	BOOLEAN

customer

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DisplayName	STRING
Title	STRING
GivenName	STRING
MiddleName	STRING
Suffix	STRING
FamilyName	STRING
PrimaryEmailAddr	STRUCT<Address: STRING>
ResaleNum	STRING
SecondaryTaxIdentifier	STRING
DefaultTaxCodeRef	STRUCT<value: STRING, name: STRING>
PreferredDeliveryMethod	STRING
SalesTermRef	STRUCT<value: STRING, name: STRING>
CustomerTypeRef	STRUCT<value: STRING, name: STRING>
Fax	STRUCT<FreeFormNumber: STRING>
BillWithParent	BOOLEAN
CurrencyRef	STRUCT<value: STRING, name: STRING>
Mobile	STRUCT<FreeFormNumber: STRING>
Job	BOOLEAN
BalanceWithJobs	DECIMAL(38,9)
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
OpenBalanceDate	DATE
Taxable	BOOLEAN
AlternatePhone	STRUCT<FreeFormNumber: STRING>
ParentRef	STRUCT<value: STRING, name: STRING>
Notes	STRING
WebAddr	STRUCT<URI: STRING>
Active	BOOLEAN
CompanyName	STRING
Balance	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
IsProject	BOOLEAN
Source	STRING
PrimaryTaxIdentifier	STRING
PrintOnCheckName	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
FullyQualifiedName	STRING
Level	INT
TaxExemptionReasonId	STRING
ClientEntityId	STRING
V4IDPseudonym	STRING
ARAccountRef	VARIANT
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DisplayName	STRING
Title	STRING
GivenName	STRING
MiddleName	STRING
Suffix	STRING
FamilyName	STRING
PrimaryEmailAddr	STRUCT<Address: STRING>
ResaleNum	STRING
SecondaryTaxIdentifier	STRING
DefaultTaxCodeRef	STRUCT<value: STRING, name: STRING>
PreferredDeliveryMethod	STRING
SalesTermRef	STRUCT<value: STRING, name: STRING>
CustomerTypeRef	STRUCT<value: STRING, name: STRING>
Fax	STRUCT<FreeFormNumber: STRING>
BillWithParent	BOOLEAN
CurrencyRef	STRUCT<value: STRING, name: STRING>
Mobile	STRUCT<FreeFormNumber: STRING>
Job	BOOLEAN
BalanceWithJobs	DECIMAL(38,9)
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
OpenBalanceDate	DATE
Taxable	BOOLEAN
AlternatePhone	STRUCT<FreeFormNumber: STRING>
ParentRef	STRUCT<value: STRING, name: STRING>
Notes	STRING
WebAddr	STRUCT<URI: STRING>
Active	BOOLEAN
CompanyName	STRING
Balance	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
IsProject	BOOLEAN
Source	STRING
PrimaryTaxIdentifier	STRING
PrintOnCheckName	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
FullyQualifiedName	STRING
Level	INT
TaxExemptionReasonId	STRING
ClientEntityId	STRING
V4IDPseudonym	STRING
ARAccountRef	VARIANT
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

customer_type

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
Active	BOOLEAN
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
Active	BOOLEAN
is_deleted	BOOLEAN

department

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
Active	BOOLEAN
FullyQualifiedName	STRING
SubDepartment	BOOLEAN
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
Active	BOOLEAN
FullyQualifiedName	STRING
SubDepartment	BOOLEAN
is_deleted	BOOLEAN

employee

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
PrimaryAddr	VARIANT
PostalCode	VARIANT
PrimaryEmailAddr	VARIANT
DisplayName	STRING
Title	STRING
BillableTime	BOOLEAN
GivenName	STRING
BirthDate	DATE
MiddleName	STRING
SSN	STRING
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
Active	BOOLEAN
ReleasedDate	DATE
CostRate	DECIMAL(38,9)
Mobile	STRUCT<FreeFormNumber: STRING>
Gender	STRING
HiredDate	DATE
BillRate	DECIMAL(38,9)
Organization	BOOLEAN
Suffix	STRING
FamilyName	STRING
PrintOnCheckName	STRING
EmployeeNumber	STRING
V4IDPseudonym	STRING
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
PrimaryAddr	VARIANT
PostalCode	VARIANT
PrimaryEmailAddr	VARIANT
DisplayName	STRING
Title	STRING
BillableTime	BOOLEAN
GivenName	STRING
BirthDate	DATE
MiddleName	STRING
SSN	STRING
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
Active	BOOLEAN
ReleasedDate	DATE
CostRate	DECIMAL(38,9)
Mobile	STRUCT<FreeFormNumber: STRING>
Gender	STRING
HiredDate	DATE
BillRate	DECIMAL(38,9)
Organization	BOOLEAN
Suffix	STRING
FamilyName	STRING
PrintOnCheckName	STRING
EmployeeNumber	STRING
V4IDPseudonym	STRING
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

item

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
InvStartDate	DATE
Type	STRING
QtyOnHand	DECIMAL(38,9)
AssetAccountRef	STRUCT<value: STRING, name: STRING>
Sku	STRING
SalesTaxIncluded	BOOLEAN
TrackQtyOnHand	BOOLEAN
SalesTaxCodeRef	STRUCT<value: STRING, name: STRING>
CustomExtensions	ARRAY<VARIANT>
Source	STRING
PurchaseTaxIncluded	BOOLEAN
Description	STRING
SubItem	BOOLEAN
Taxable	BOOLEAN
ReorderPoint	DECIMAL(38,9)
PurchaseDesc	STRING
PrefVendorRef	STRUCT<value: STRING, name: STRING>
Active	BOOLEAN
ClassRef	STRUCT<value: STRING, name: STRING>
PurchaseTaxCodeRef	STRUCT<value: STRING, name: STRING>
PurchaseCost	DECIMAL(38,9)
ParentRef	STRUCT<value: STRING, name: STRING>
UnitPrice	DECIMAL(38,9)
FullyQualifiedName	STRING
Level	INT
IncomeAccountRef	STRUCT<value: STRING, name: STRING>
ExpenseAccountRef	STRUCT<value: STRING, name: STRING>
TaxClassificationRef	STRUCT<value: STRING, name: STRING>
ItemGroupDetail	STRUCT<ItemGroupLine: ARRAY<VARIANT>>
PrintGroupedItems	BOOLEAN
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
InvStartDate	DATE
Type	STRING
QtyOnHand	DECIMAL(38,9)
AssetAccountRef	STRUCT<value: STRING, name: STRING>
Sku	STRING
SalesTaxIncluded	BOOLEAN
TrackQtyOnHand	BOOLEAN
SalesTaxCodeRef	STRUCT<value: STRING, name: STRING>
CustomExtensions	ARRAY<VARIANT>
Source	STRING
PurchaseTaxIncluded	BOOLEAN
Description	STRING
SubItem	BOOLEAN
Taxable	BOOLEAN
ReorderPoint	DECIMAL(38,9)
PurchaseDesc	STRING
PrefVendorRef	STRUCT<value: STRING, name: STRING>
Active	BOOLEAN
ClassRef	STRUCT<value: STRING, name: STRING>
PurchaseTaxCodeRef	STRUCT<value: STRING, name: STRING>
PurchaseCost	DECIMAL(38,9)
ParentRef	STRUCT<value: STRING, name: STRING>
UnitPrice	DECIMAL(38,9)
FullyQualifiedName	STRING
Level	INT
IncomeAccountRef	STRUCT<value: STRING, name: STRING>
ExpenseAccountRef	STRUCT<value: STRING, name: STRING>
TaxClassificationRef	STRUCT<value: STRING, name: STRING>
ItemGroupDetail	STRUCT<ItemGroupLine: ARRAY<VARIANT>>
PrintGroupedItems	BOOLEAN
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

payment_method

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
Active	BOOLEAN
Type	STRING
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
Active	BOOLEAN
Type	STRING
is_deleted	BOOLEAN

term

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
DiscountPercent	DECIMAL(38,9)
DiscountDays	INT
Active	BOOLEAN
Type	STRING
DayOfMonthDue	INT
DiscountDayOfMonth	INT
DueNextMonthDays	INT
DueDays	INT
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Name	STRING
DiscountPercent	DECIMAL(38,9)
DiscountDays	INT
Active	BOOLEAN
Type	STRING
DayOfMonthDue	INT
DiscountDayOfMonth	INT
DueNextMonthDays	INT
DueDays	INT
is_deleted	BOOLEAN

vendor

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Title	STRING
GivenName	STRING
MiddleName	STRING
Suffix	STRING
FamilyName	STRING
PrimaryEmailAddr	STRUCT<Address: STRING>
DisplayName	STRING
OtherContactInfo	ARRAY<VARIANT>
TermRef	STRUCT<value: STRING, name: STRING>
Source	STRING
T4AEligible	BOOLEAN
Fax	STRUCT<FreeFormNumber: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
Mobile	STRUCT<FreeFormNumber: STRING>
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
Active	BOOLEAN
AlternatePhone	STRUCT<FreeFormNumber: STRING>
Vendor1099	BOOLEAN
CostRate	DECIMAL(38,9)
BillRate	DECIMAL(38,9)
WebAddr	STRUCT<URI: STRING>
T5018Eligible	BOOLEAN
CompanyName	STRING
VendorPaymentBankDetail	VARIANT
TaxIdentifier	STRING
AcctNum	STRING
HasTPAR	BOOLEAN
PrintOnCheckName	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
Balance	DECIMAL(38,9)
V4IDPseudonym	STRING
APAccountRef	VARIANT
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Title	STRING
GivenName	STRING
MiddleName	STRING
Suffix	STRING
FamilyName	STRING
PrimaryEmailAddr	STRUCT<Address: STRING>
DisplayName	STRING
OtherContactInfo	ARRAY<VARIANT>
TermRef	STRUCT<value: STRING, name: STRING>
Source	STRING
T4AEligible	BOOLEAN
Fax	STRUCT<FreeFormNumber: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
Mobile	STRUCT<FreeFormNumber: STRING>
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
Active	BOOLEAN
AlternatePhone	STRUCT<FreeFormNumber: STRING>
Vendor1099	BOOLEAN
CostRate	DECIMAL(38,9)
BillRate	DECIMAL(38,9)
WebAddr	STRUCT<URI: STRING>
T5018Eligible	BOOLEAN
CompanyName	STRING
VendorPaymentBankDetail	VARIANT
TaxIdentifier	STRING
AcctNum	STRING
HasTPAR	BOOLEAN
PrintOnCheckName	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
Balance	DECIMAL(38,9)
V4IDPseudonym	STRING
APAccountRef	VARIANT
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

budget

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
EndDate	DATE
StartDate	DATE
BudgetEntryType	STRING
Name	STRING
BudgetType	STRING
CustomExtensions	ARRAY<STRUCT<ExtensionType: STRING, AssociatedValues: ARRAY<STRUCT<Key: STRING, Value: STRING>>>>
Active	BOOLEAN
BudgetDetail	ARRAY<STRUCT<ClassRef: STRUCT<value: STRING, name: STRING>, DepartmentRef: STRUCT<value: STRING, name: STRING>, Amount: DECIMAL(38,9), BudgetDate: DATE, AccountRef: STRUCT<value: STRING, name: STRING>, CustomerRef: STRUCT<value: STRING, name: STRING>>>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
EndDate	DATE
StartDate	DATE
BudgetEntryType	STRING
Name	STRING
BudgetType	STRING
CustomExtensions	ARRAY<STRUCT<ExtensionType: STRING, AssociatedValues: ARRAY<STRUCT<Key: STRING, Value: STRING>>>>
Active	BOOLEAN
BudgetDetail	ARRAY<STRUCT<ClassRef: STRUCT<value: STRING, name: STRING>, DepartmentRef: STRUCT<value: STRING, name: STRING>, Amount: DECIMAL(38,9), BudgetDate: DATE, AccountRef: STRUCT<value: STRING, name: STRING>, CustomerRef: STRUCT<value: STRING, name: STRING>>>
is_deleted	BOOLEAN

tax_code

プライマリ キー: Id 同期モード: 完全更新のみ

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
Name	STRING
PurchaseTaxRateList	STRUCT<TaxRateDetail: ARRAY<STRUCT<TaxRateRef: STRUCT<value: STRING, name: STRING>, TaxTypeApplicable: STRING, TaxOrder: INT>>>
SalesTaxRateList	STRUCT<TaxRateDetail: ARRAY<STRUCT<TaxRateRef: STRUCT<value: STRING, name: STRING>, TaxTypeApplicable: STRING, TaxOrder: INT>>>
TaxGroup	BOOLEAN
Taxable	BOOLEAN
Active	BOOLEAN
Description	STRING
Hidden	BOOLEAN
TaxCodeConfigType	STRING

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
Name	STRING
PurchaseTaxRateList	STRUCT<TaxRateDetail: ARRAY<STRUCT<TaxRateRef: STRUCT<value: STRING, name: STRING>, TaxTypeApplicable: STRING, TaxOrder: INT>>>
SalesTaxRateList	STRUCT<TaxRateDetail: ARRAY<STRUCT<TaxRateRef: STRUCT<value: STRING, name: STRING>, TaxTypeApplicable: STRING, TaxOrder: INT>>>
TaxGroup	BOOLEAN
Taxable	BOOLEAN
Active	BOOLEAN
Description	STRING
Hidden	BOOLEAN
TaxCodeConfigType	STRING

tax_rate

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
RateValue	DECIMAL(38,9)
Name	STRING
AgencyRef	STRUCT<value: STRING, name: STRING>
SpecialTaxType	STRING
EffectiveTaxRate	ARRAY<STRUCT<RateValue: DECIMAL(38,9), EndDate: STRING, EffectiveDate: STRING>>
DisplayType	STRING
TaxReturnLineRef	STRUCT<value: STRING, name: STRING>
Active	BOOLEAN
OriginalTaxRate	STRING
Description	STRING
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
RateValue	DECIMAL(38,9)
Name	STRING
AgencyRef	STRUCT<value: STRING, name: STRING>
SpecialTaxType	STRING
EffectiveTaxRate	ARRAY<STRUCT<RateValue: DECIMAL(38,9), EndDate: STRING, EffectiveDate: STRING>>
DisplayType	STRING
TaxReturnLineRef	STRUCT<value: STRING, name: STRING>
Active	BOOLEAN
OriginalTaxRate	STRING
Description	STRING
is_deleted	BOOLEAN

invoice

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
DocNumber	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
ShipDate	DATE
TrackingNum	STRING
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
EmailStatus	STRING
EmailSent	VARIANT
SalesTermRef	STRUCT<value: STRING, name: STRING>
TxnSource	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
AllowOnlineAffirmPayment	BOOLEAN
AllowOnlineACHPayment	BOOLEAN
TransactionLocationType	STRING
DueDate	DATE
PrivateNote	STRING
BillEmailCc	STRUCT<Address: STRING>
CustomerMemo	STRUCT<value: STRING>
AllowOnlinePayPalPayment	BOOLEAN
ExchangeRate	DECIMAL(38,9)
Deposit	DECIMAL(38,9)
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
AllowOnlineCreditCardPayment	BOOLEAN
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
BillEmailBcc	STRUCT<Address: STRING>
ShipMethodRef	STRUCT<value: STRING, name: STRING>
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
ApplyTaxAfterDiscount	BOOLEAN
HomeBalance	DECIMAL(38,9)
DeliveryInfo	STRUCT<DeliveryType: STRING, DeliveryTime: TIMESTAMP, DeliveryErrorType: STRING>
TotalAmt	DECIMAL(38,9)
InvoiceLink	STRING
RecurDataRef	STRUCT<value: STRING, name: STRING>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
AllowIPNPayment	BOOLEAN
AllowOnlinePayment	BOOLEAN
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
DocNumber	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
ShipDate	DATE
TrackingNum	STRING
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
EmailStatus	STRING
EmailSent	VARIANT
SalesTermRef	STRUCT<value: STRING, name: STRING>
TxnSource	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
AllowOnlineAffirmPayment	BOOLEAN
AllowOnlineACHPayment	BOOLEAN
TransactionLocationType	STRING
DueDate	DATE
PrivateNote	STRING
BillEmailCc	STRUCT<Address: STRING>
CustomerMemo	STRUCT<value: STRING>
AllowOnlinePayPalPayment	BOOLEAN
ExchangeRate	DECIMAL(38,9)
Deposit	DECIMAL(38,9)
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
AllowOnlineCreditCardPayment	BOOLEAN
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
BillEmailBcc	STRUCT<Address: STRING>
ShipMethodRef	STRUCT<value: STRING, name: STRING>
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
ApplyTaxAfterDiscount	BOOLEAN
HomeBalance	DECIMAL(38,9)
DeliveryInfo	STRUCT<DeliveryType: STRING, DeliveryTime: TIMESTAMP, DeliveryErrorType: STRING>
TotalAmt	DECIMAL(38,9)
InvoiceLink	STRING
RecurDataRef	STRUCT<value: STRING, name: STRING>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
AllowIPNPayment	BOOLEAN
AllowOnlinePayment	BOOLEAN
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

bill

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
TxnDate	DATE
APAccountRef	STRUCT<value: STRING, name: STRING>
SalesTermRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
DueDate	DATE
DocNumber	STRING
PrivateNote	STRING
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
ExchangeRate	DECIMAL(38,9)
DepartmentRef	STRUCT<value: STRING, name: STRING>
IncludeInAnnualTPAR	BOOLEAN
HomeBalance	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
TxnDate	DATE
APAccountRef	STRUCT<value: STRING, name: STRING>
SalesTermRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
DueDate	DATE
DocNumber	STRING
PrivateNote	STRING
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
ExchangeRate	DECIMAL(38,9)
DepartmentRef	STRUCT<value: STRING, name: STRING>
IncludeInAnnualTPAR	BOOLEAN
HomeBalance	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

bill_payment

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
PayType	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
DocNumber	STRING
PrivateNote	STRING
TxnDate	DATE
ExchangeRate	DECIMAL(38,9)
APAccountRef	STRUCT<value: STRING, name: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
ProcessBillPayment	BOOLEAN
Line	ARRAY<STRUCT<Amount: DECIMAL(38,9), LinkedTxn: ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>>>
CheckPayment	STRUCT<BankAccountRef: STRUCT<value: STRING, name: STRING>, PrintStatus: STRING, CheckDetail: STRUCT<CheckNum: STRING, AcctNum: STRING, BankName: STRING, NameOnAcct: STRING>, PayeeAddr: STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>, BillPaymentCheckEx: VARIANT>
CreditCardPayment	STRUCT<CCAccountRef: STRUCT<value: STRING, name: STRING>, CCDetail: STRUCT<CreditChargeInfo: VARIANT, CreditChargeResponse: VARIANT>, BillPaymentCreditCardEx: VARIANT>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
PayType	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
DocNumber	STRING
PrivateNote	STRING
TxnDate	DATE
ExchangeRate	DECIMAL(38,9)
APAccountRef	STRUCT<value: STRING, name: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
ProcessBillPayment	BOOLEAN
Line	ARRAY<STRUCT<Amount: DECIMAL(38,9), LinkedTxn: ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>>>
CheckPayment	STRUCT<BankAccountRef: STRUCT<value: STRING, name: STRING>, PrintStatus: STRING, CheckDetail: STRUCT<CheckNum: STRING, AcctNum: STRING, BankName: STRING, NameOnAcct: STRING>, PayeeAddr: STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>, BillPaymentCheckEx: VARIANT>
CreditCardPayment	STRUCT<CCAccountRef: STRUCT<value: STRING, name: STRING>, CCDetail: STRUCT<CreditChargeInfo: VARIANT, CreditChargeResponse: VARIANT>, BillPaymentCreditCardEx: VARIANT>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

payment

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
TotalAmt	DECIMAL(38,9)
CustomerRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
ProjectRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
UnappliedAmt	DECIMAL(38,9)
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
TxnSource	STRING
PaymentRefNum	STRING
TxnDate	DATE
CreditCardPayment	STRUCT<CreditChargeInfo: VARIANT, CreditChargeResponse: VARIANT>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
ARAccountRef	STRUCT<value: STRING, name: STRING>
ProcessPayment	BOOLEAN
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
TotalAmt	DECIMAL(38,9)
CustomerRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
ProjectRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
UnappliedAmt	DECIMAL(38,9)
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
TxnSource	STRING
PaymentRefNum	STRING
TxnDate	DATE
CreditCardPayment	STRUCT<CreditChargeInfo: VARIANT, CreditChargeResponse: VARIANT>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
ARAccountRef	STRUCT<value: STRING, name: STRING>
ProcessPayment	BOOLEAN
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

estimate

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
ShipDate	DATE
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
SalesTermRef	STRUCT<value: STRING, name: STRING>
TxnStatus	STRING
AcceptedDate	DATE
ExpirationDate	DATE
DueDate	DATE
DocNumber	STRING
PrivateNote	STRING
CustomerMemo	STRUCT<value: STRING>
EmailStatus	STRING
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
AcceptedBy	STRING
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
ShipMethodRef	STRUCT<value: STRING, name: STRING>
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
ApplyTaxAfterDiscount	BOOLEAN
TotalAmt	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
DeliveryInfo	STRUCT<DeliveryType: STRING, DeliveryTime: TIMESTAMP, DeliveryErrorType: STRING>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
ShipDate	DATE
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
SalesTermRef	STRUCT<value: STRING, name: STRING>
TxnStatus	STRING
AcceptedDate	DATE
ExpirationDate	DATE
DueDate	DATE
DocNumber	STRING
PrivateNote	STRING
CustomerMemo	STRUCT<value: STRING>
EmailStatus	STRING
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
AcceptedBy	STRING
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
ShipMethodRef	STRUCT<value: STRING, name: STRING>
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
ApplyTaxAfterDiscount	BOOLEAN
TotalAmt	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
DeliveryInfo	STRUCT<DeliveryType: STRING, DeliveryTime: TIMESTAMP, DeliveryErrorType: STRING>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

credit_memo

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
SalesTermRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
ApplyTaxAfterDiscount	BOOLEAN
DocNumber	STRING
PrivateNote	STRING
CustomerMemo	STRUCT<value: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
EmailStatus	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
HomeBalance	DECIMAL(38,9)
RemainingCredit	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
SalesTermRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
ApplyTaxAfterDiscount	BOOLEAN
DocNumber	STRING
PrivateNote	STRING
CustomerMemo	STRUCT<value: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
EmailStatus	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
HomeBalance	DECIMAL(38,9)
RemainingCredit	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

sales_receipt

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ShipDate	DATE
TrackingNum	STRING
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
PaymentRefNum	STRING
TxnSource	STRING
ApplyTaxAfterDiscount	BOOLEAN
DocNumber	STRING
PrivateNote	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
CustomerMemo	STRUCT<value: STRING>
EmailStatus	STRING
CreditCardPayment	STRUCT<CreditChargeInfo: VARIANT, CreditChargeResponse: VARIANT>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
ShipMethodRef	STRUCT<value: STRING, name: STRING>
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
HomeBalance	DECIMAL(38,9)
DeliveryInfo	STRUCT<DeliveryType: STRING, DeliveryTime: TIMESTAMP, DeliveryErrorType: STRING>
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CustomerRef	STRUCT<value: STRING, name: STRING>
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ShipDate	DATE
TrackingNum	STRING
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
PaymentRefNum	STRING
TxnSource	STRING
ApplyTaxAfterDiscount	BOOLEAN
DocNumber	STRING
PrivateNote	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
CustomerMemo	STRUCT<value: STRING>
EmailStatus	STRING
CreditCardPayment	STRUCT<CreditChargeInfo: VARIANT, CreditChargeResponse: VARIANT>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
ShipMethodRef	STRUCT<value: STRING, name: STRING>
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
HomeBalance	DECIMAL(38,9)
DeliveryInfo	STRUCT<DeliveryType: STRING, DeliveryTime: TIMESTAMP, DeliveryErrorType: STRING>
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

refund_receipt

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
PaymentRefNum	STRING
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
CheckPayment	STRUCT<CheckNum: STRING, AcctNum: STRING, BankName: STRING, NameOnAcct: STRING, Status: STRING>
TxnSource	STRING
DocNumber	STRING
PrivateNote	STRING
CustomerMemo	STRUCT<value: STRING>
CreditCardPayment	STRUCT<CreditChargeInfo: STRUCT<CcExpiryMonth: INT, ProcessPayment: BOOLEAN, PostalCode: STRING, Amount: DECIMAL(38,9), NameOnAcct: STRING, CcExpiryYear: INT, Type: STRING, BillAddrStreet: STRING>, CreditChargeResponse: STRUCT<Status: STRING, AuthCode: STRING, TxnAuthorizationTime: TIMESTAMP, CCTransId: STRING>>
CustomerRef	STRUCT<value: STRING, name: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
PaymentType	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
ApplyTaxAfterDiscount	BOOLEAN
HomeBalance	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
PaymentRefNum	STRING
GlobalTaxCalculation	STRING
ProjectRef	STRUCT<value: STRING, name: STRING>
BillEmail	STRUCT<Address: STRING>
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
ClassRef	STRUCT<value: STRING, name: STRING>
PrintStatus	STRING
CheckPayment	STRUCT<CheckNum: STRING, AcctNum: STRING, BankName: STRING, NameOnAcct: STRING, Status: STRING>
TxnSource	STRING
DocNumber	STRING
PrivateNote	STRING
CustomerMemo	STRUCT<value: STRING>
CreditCardPayment	STRUCT<CreditChargeInfo: STRUCT<CcExpiryMonth: INT, ProcessPayment: BOOLEAN, PostalCode: STRING, Amount: DECIMAL(38,9), NameOnAcct: STRING, CcExpiryYear: INT, Type: STRING, BillAddrStreet: STRING>, CreditChargeResponse: STRUCT<Status: STRING, AuthCode: STRING, TxnAuthorizationTime: TIMESTAMP, CCTransId: STRING>>
CustomerRef	STRUCT<value: STRING, name: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
PaymentType	STRING
BillAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
ApplyTaxAfterDiscount	BOOLEAN
HomeBalance	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
TaxExemptionRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
FreeFormAddress	BOOLEAN
ShipFromAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

purchase

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
PaymentType	STRING
AccountRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
TxnDate	DATE
PrintStatus	STRING
RemitToAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
TxnSource	STRING
GlobalTaxCalculation	STRING
DocNumber	STRING
PrivateNote	STRING
Credit	BOOLEAN
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
PurchaseEx	VARIANT
ExchangeRate	DECIMAL(38,9)
DepartmentRef	STRUCT<value: STRING, name: STRING>
EntityRef	STRUCT<value: STRING, name: STRING, type: STRING>
IncludeInAnnualTPAR	BOOLEAN
TotalAmt	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
PaymentType	STRING
AccountRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
TxnDate	DATE
PrintStatus	STRING
RemitToAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
TxnSource	STRING
GlobalTaxCalculation	STRING
DocNumber	STRING
PrivateNote	STRING
Credit	BOOLEAN
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
PaymentMethodRef	STRUCT<value: STRING, name: STRING>
PurchaseEx	VARIANT
ExchangeRate	DECIMAL(38,9)
DepartmentRef	STRUCT<value: STRING, name: STRING>
EntityRef	STRUCT<value: STRING, name: STRING, type: STRING>
IncludeInAnnualTPAR	BOOLEAN
TotalAmt	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

purchase_order

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
APAccountRef	STRUCT<value: STRING, name: STRING>
VendorRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
POEmail	STRUCT<Address: STRING>
ClassRef	STRUCT<value: STRING, name: STRING>
SalesTermRef	STRUCT<value: STRING, name: STRING>
Memo	STRING
POStatus	STRING
DueDate	DATE
DocNumber	STRING
PrivateNote	STRING
ShipMethodRef	STRUCT<value: STRING, name: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
ShipTo	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
VendorAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
EmailStatus	STRING
TotalAmt	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
DepartmentRef	STRUCT<value: STRING, name: STRING>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
APAccountRef	STRUCT<value: STRING, name: STRING>
VendorRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
TxnDate	DATE
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
POEmail	STRUCT<Address: STRING>
ClassRef	STRUCT<value: STRING, name: STRING>
SalesTermRef	STRUCT<value: STRING, name: STRING>
Memo	STRING
POStatus	STRING
DueDate	DATE
DocNumber	STRING
PrivateNote	STRING
ShipMethodRef	STRUCT<value: STRING, name: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
ShipTo	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
ShipAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
VendorAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
EmailStatus	STRING
TotalAmt	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<STRUCT<TxnId: STRING, TxnType: STRING, TxnLineId: STRING>>
DepartmentRef	STRUCT<value: STRING, name: STRING>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

deposit

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
ExchangeRate	DECIMAL(38,9)
DepartmentRef	STRUCT<value: STRING, name: STRING>
TxnSource	STRING
TxnDate	DATE
CashBack	STRUCT<AccountRef: STRUCT<value: STRING, name: STRING>, Amount: DECIMAL(38,9), Memo: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DepositToAccountRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
ExchangeRate	DECIMAL(38,9)
DepartmentRef	STRUCT<value: STRING, name: STRING>
TxnSource	STRING
TxnDate	DATE
CashBack	STRUCT<AccountRef: STRUCT<value: STRING, name: STRING>, Amount: DECIMAL(38,9), Memo: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<STRUCT<DetailType: VARIANT, TaxLineDetail: STRUCT<TaxRateRef: VARIANT, NetAmountTaxable: DECIMAL(38,9), PercentBased: BOOLEAN, TaxInclusiveAmount: DECIMAL(38,9), OverrideDeltaAmount: DECIMAL(38,9), TaxPercent: DECIMAL(38,9)>, Amount: DECIMAL(38,9)>>>
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

transfer

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
ToAccountRef	STRUCT<value: STRING, name: STRING>
Amount	DECIMAL(38,9)
FromAccountRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
TxnDate	DATE
RecurDataRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	VARIANT
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
ToAccountRef	STRUCT<value: STRING, name: STRING>
Amount	DECIMAL(38,9)
FromAccountRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
TxnDate	DATE
RecurDataRef	STRUCT<value: STRING, name: STRING>
CurrencyRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	VARIANT
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

journal_entry

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
DocNumber	STRING
PrivateNote	STRING
TxnDate	DATE
ExchangeRate	DECIMAL(38,9)
TaxRateRef	STRUCT<value: STRING, name: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
Adjustment	BOOLEAN
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
DocNumber	STRING
PrivateNote	STRING
TxnDate	DATE
ExchangeRate	DECIMAL(38,9)
TaxRateRef	STRUCT<value: STRING, name: STRING>
TxnTaxDetail	STRUCT<TxnTaxCodeRef: STRUCT<value: STRING, name: STRING>, TotalTax: DECIMAL(38,9), TaxLine: ARRAY<VARIANT>>
Adjustment	BOOLEAN
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
HomeTotalAmt	DECIMAL(38,9)
Line	ARRAY<VARIANT>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

vendor_credit

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
DocNumber	STRING
PrivateNote	STRING
ExchangeRate	DECIMAL(38,9)
APAccountRef	STRUCT<value: STRING, name: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
TxnDate	DATE
IncludeInAnnualTPAR	BOOLEAN
Balance	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
GlobalTaxCalculation	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
DocNumber	STRING
PrivateNote	STRING
ExchangeRate	DECIMAL(38,9)
APAccountRef	STRUCT<value: STRING, name: STRING>
DepartmentRef	STRUCT<value: STRING, name: STRING>
TxnDate	DATE
IncludeInAnnualTPAR	BOOLEAN
Balance	DECIMAL(38,9)
RecurDataRef	STRUCT<value: STRING, name: STRING>
TotalAmt	DECIMAL(38,9)
Line	ARRAY<VARIANT>
LinkedTxn	ARRAY<VARIANT>
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

credit_card_payment

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CreditCardAccountRef	STRUCT<value: STRING, name: STRING>
Amount	DECIMAL(38,9)
BankAccountRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
TxnDate	DATE
Memo	STRING
PrintStatus	STRING
CheckNum	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
CreditCardAccountRef	STRUCT<value: STRING, name: STRING>
Amount	DECIMAL(38,9)
BankAccountRef	STRUCT<value: STRING, name: STRING>
PrivateNote	STRING
VendorRef	STRUCT<value: STRING, name: STRING>
TxnDate	DATE
Memo	STRING
PrintStatus	STRING
CheckNum	STRING
CurrencyRef	STRUCT<value: STRING, name: STRING>
ExchangeRate	DECIMAL(38,9)
is_deleted	BOOLEAN

attachable

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
FileName	STRING
Category	STRING
ContentType	STRING
PlaceName	STRING
AttachableRef	VARIANT
Long	STRING
Tag	STRING
Lat	STRING
FileAccessUri	STRING
Size	DECIMAL(38,9)
ThumbnailFileAccessUri	STRING
TempDownloadUri	STRING
ThumbnailTempDownloadUri	STRING
Note	STRING
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
FileName	STRING
Category	STRING
ContentType	STRING
PlaceName	STRING
AttachableRef	VARIANT
Long	STRING
Tag	STRING
Lat	STRING
FileAccessUri	STRING
Size	DECIMAL(38,9)
ThumbnailFileAccessUri	STRING
TempDownloadUri	STRING
ThumbnailTempDownloadUri	STRING
Note	STRING
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

recurring_transaction

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
RecurringInfo	VARIANT
RecurDataRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
TotalAmt	DECIMAL(38,9)
CurrencyRef	STRUCT<value: STRING, name: STRING>
LinkedTxn	ARRAY<VARIANT>
Line	ARRAY<VARIANT>
SalesTermRef	STRUCT<value: STRING, name: STRING>
VendorRef	STRUCT<value: STRING, name: STRING>
APAccountRef	STRUCT<value: STRING, name: STRING>
VendorAddr	VARIANT
Type	STRING
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
RecurringInfo	VARIANT
RecurDataRef	STRUCT<value: STRING, name: STRING>
Balance	DECIMAL(38,9)
TotalAmt	DECIMAL(38,9)
CurrencyRef	STRUCT<value: STRING, name: STRING>
LinkedTxn	ARRAY<VARIANT>
Line	ARRAY<VARIANT>
SalesTermRef	STRUCT<value: STRING, name: STRING>
VendorRef	STRUCT<value: STRING, name: STRING>
APAccountRef	STRUCT<value: STRING, name: STRING>
VendorAddr	VARIANT
Type	STRING
is_deleted	BOOLEAN

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

tax_agency

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DisplayName	STRING
TaxTrackedOnSales	BOOLEAN
TaxTrackedOnPurchases	BOOLEAN
LastFileDate	DATE
TaxRegistrationNumber	STRING
TaxAgencyConfig	STRING

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
DisplayName	STRING
TaxTrackedOnSales	BOOLEAN
TaxTrackedOnPurchases	BOOLEAN
LastFileDate	DATE
TaxRegistrationNumber	STRING
TaxAgencyConfig	STRING

time_activity

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
NameOf	STRING
TxnDate	DATE
EndTime	TIMESTAMP
Hours	INT
VendorRef	STRUCT<value: STRING, name: STRING>
ProjectRef	STRUCT<value: STRING, name: STRING>
HourlyRate	DECIMAL(38,9)
Billable	VARIANT
CustomerRef	STRUCT<value: STRING, name: STRING>
EmployeeRef	STRUCT<value: STRING, name: STRING>
StartTime	TIMESTAMP
ClassRef	STRUCT<value: STRING, name: STRING>
Description	STRING
Taxable	BOOLEAN
CostRate	DECIMAL(38,9)
ItemRef	STRUCT<value: STRING, name: STRING>
PayrollItemRef	STRUCT<value: STRING, name: STRING>
BillableStatus	STRING
DepartmentRef	STRUCT<value: STRING, name: STRING>
Minutes	INT
BreakHours	INT
BreakMinutes	INT
Seconds	INT
TimeChargeId	STRING

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
NameOf	STRING
TxnDate	DATE
EndTime	TIMESTAMP
Hours	INT
VendorRef	STRUCT<value: STRING, name: STRING>
ProjectRef	STRUCT<value: STRING, name: STRING>
HourlyRate	DECIMAL(38,9)
Billable	VARIANT
CustomerRef	STRUCT<value: STRING, name: STRING>
EmployeeRef	STRUCT<value: STRING, name: STRING>
StartTime	TIMESTAMP
ClassRef	STRUCT<value: STRING, name: STRING>
Description	STRING
Taxable	BOOLEAN
CostRate	DECIMAL(38,9)
ItemRef	STRUCT<value: STRING, name: STRING>
PayrollItemRef	STRUCT<value: STRING, name: STRING>
BillableStatus	STRING
DepartmentRef	STRUCT<value: STRING, name: STRING>
Minutes	INT
BreakHours	INT
BreakMinutes	INT
Seconds	INT
TimeChargeId	STRING

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

company_info

プライマリ キー: Id 同期モード: 完全更新のみ

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
CompanyName	STRING
CompanyAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
LegalAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
SupportedLanguages	STRING
Country	STRING
Email	STRUCT<Address: STRING>
WebAddr	STRUCT<URI: STRING>
FiscalYearStartMonth	STRING
CustomerCommunicationAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
LegalName	STRING
EmployerId	STRING
CompanyStartDate	TIMESTAMP
NameValue	ARRAY<VARIANT>
DefaultTimeZone	STRING
CustomerCommunicationEmailAddr	VARIANT

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
CompanyName	STRING
CompanyAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
LegalAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
SupportedLanguages	STRING
Country	STRING
Email	STRUCT<Address: STRING>
WebAddr	STRUCT<URI: STRING>
FiscalYearStartMonth	STRING
CustomerCommunicationAddr	STRUCT<Id: STRING, Line1: STRING, Line2: STRING, Line3: STRING, Line4: STRING, Line5: STRING, City: STRING, Country: STRING, CountrySubDivisionCode: STRING, PostalCode: STRING, Lat: STRING, Long: STRING, Note: STRING>
PrimaryPhone	STRUCT<FreeFormNumber: STRING>
LegalName	STRING
EmployerId	STRING
CompanyStartDate	TIMESTAMP
NameValue	ARRAY<VARIANT>
DefaultTimeZone	STRING
CustomerCommunicationEmailAddr	VARIANT

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

preferences

プライマリ キー: Id 同期モード: 完全更新のみ

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
EmailMessagesPrefs	VARIANT
ProductAndServicesPrefs	VARIANT
ReportPrefs	VARIANT
AccountingInfoPrefs	VARIANT
SalesFormsPrefs	VARIANT
VendorAndPurchasesPrefs	VARIANT
TaxPrefs	VARIANT
OtherPrefs	VARIANT
TimeTrackingPrefs	VARIANT
CurrencyPrefs	VARIANT

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
EmailMessagesPrefs	VARIANT
ProductAndServicesPrefs	VARIANT
ReportPrefs	VARIANT
AccountingInfoPrefs	VARIANT
SalesFormsPrefs	VARIANT
VendorAndPurchasesPrefs	VARIANT
TaxPrefs	VARIANT
OtherPrefs	VARIANT
TimeTrackingPrefs	VARIANT
CurrencyPrefs	VARIANT

注記

このテーブルには VARIANT 列があるため、SCD タイプ 2 はサポートされていません。

tax_classification

プライマリ キー: Code 同期モード: 完全更新のみ

フィールド	データ型
Code	STRING
Name	STRING
Id	STRING
Description	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
ApplicableTo	ARRAY<STRING>
Level	STRING

フィールド	データ型
Code	STRING
Name	STRING
Id	STRING
Description	STRING
ParentRef	STRUCT<value: STRING, name: STRING>
ApplicableTo	ARRAY<STRING>
Level	STRING

company_currency

主キー： Id カーソルフィールド： last_updated_time

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Code	STRING
Name	STRING
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
Active	BOOLEAN
is_deleted	BOOLEAN

フィールド	データ型
Id	STRING
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
Code	STRING
Name	STRING
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
Active	BOOLEAN
is_deleted	BOOLEAN

exchange_rate

プライマリキー: SourceCurrencyCode, TargetCurrencyCode, AsOfDate カーソルフィールド: last_updated_time

フィールド	データ型
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
AsOfDate	DATE
SourceCurrencyCode	STRING
Rate	DECIMAL(38,9)
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
TargetCurrencyCode	STRING

フィールド	データ型
SyncToken	STRING
MetaData	STRUCT<CreateTime: TIMESTAMP, LastUpdatedTime: TIMESTAMP, LastModifiedByRef: STRUCT<value: STRING, name: STRING>>
domain	STRING
sparse	BOOLEAN
last_updated_time	STRING
AsOfDate	DATE
SourceCurrencyCode	STRING
Rate	DECIMAL(38,9)
CustomField	ARRAY<STRUCT<DefinitionId: STRING, StringValue: STRING, Name: STRING, Type: STRING>>
TargetCurrencyCode	STRING