Explore the Zoho Books API data model

See how the various Zoho Books endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Zoho Books API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Zoho Books API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

BankAccount

Documentation: https://www.zoho.com/books/api/v3/bank-accounts/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
AccountCodePrefix string - -
GenerationNumber string - -
LastImportDuplicateCount int - -
CanShowInZe boolean - -
CanShowPaypalDirectIntegBanner boolean - -
CanAccessAllBranches boolean - -
CanAccessAllLocations boolean - -
CanAccessAllLocationsOfBankAccount boolean - -
IsUndepositedFunds boolean - -
LatestTransactionDate datetime - -
AccountID string - -
AccountName string - -
IsActive boolean - -
AccountCode string - -
AccountType string - -
AccountSubType string - -
UncategorizedTransactions decimal - -
TotalUnprintedChecks decimal - -
Balance decimal - -
BankBalance decimal - -
BankName string - -
FeedsLastRefreshDate string - -
IsDirectPaypal boolean - -
MfaRequired boolean - -
CurrencyID string Currency → CurrencyID -

Bill

Documentation: https://www.zoho.com/books/api/v3/customer-payments/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Source string - -
ContactCategory string - -
UnusedCreditsPayableAmount decimal - -
DiscountSetting string - -
TdsCalculationType string - -
PaymentTerms int - -
PaymentTermsLabel string - -
PaymentExpectedDate string - -
ScannedPoID string - -
RecurringBillID string -
  • 19 Nov 2025 Foreign Key - Refers to RecurringBill (not implemented)
DueByDays string - -
DueInDays int - -
SubjectContent string - -
IsItemLevelTaxCalc boolean - -
IsInclusiveTax boolean - -
TaxRounding string - -
TrackDiscountInAccount boolean - -
BillOrderType string - -
SubmittedDate string - -
SubmitterID string User → UserID -
ApproverID string User → UserID -
Adjustment decimal - -
AdjustmentDescription string - -
Discount decimal - -
DiscountAppliedOnAmount decimal - -
IsDiscountBeforeTax boolean - -
DiscountAccountID string ChartOfAccounts → AccountID -
DiscountType string - -
SubTotal decimal - -
SubTotalInclusiveOfTax decimal - -
TaxTotal decimal - -
DiscountTotal decimal - -
DiscountPercent decimal - -
PaymentMade decimal - -
VendorCreditsApplied decimal - -
IsLineItemInvoiced boolean - -
TaxOverridePreference string - -
TdsOverridePreference string - -
BillingAddressID string ContactAddress → AddressID -
CreatedByID string User → UserID -
LastModifiedID string User → UserID -
ReferenceID string - -
Notes string - -
Terms string - -
OpenPurchaseordersCount int - -
IsApprovalRequired boolean - -
TotalRetentionAmount decimal - -
CanSendInMail boolean - -
TemplateID string Template → TemplateID -
AccountID string ChartOfAccounts → AccountID -
AdjustmentAccountID string ChartOfAccounts → AccountID -
BillID string - -
CreatedTime datetime - -
LastModifiedTime datetime - -
Status string - -
VendorID string Contact → ContactID -
ColorCode string - -
CurrentSubStatusID string - -
BillNumber string - -
ReferenceNumber string - -
CurrencyID string Contact → ContactID -
Date datetime - -
DueDate datetime - -
ClientViewedTime datetime - -
DueDays string - -
Total decimal - -
TdsTotal decimal - -
Balance decimal - -
UnprocessedPaymentAmount decimal - -
IsUberBill boolean - -
IsTallyBill boolean - -
EntityType string - -
IsBillReconciliationViolated boolean - -
BalanceDue decimal - -

ChartOfAccounts

Documentation: https://www.zoho.com/books/api/v3/chart-of-accounts/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
AccountID string - -
AccountName string - -
CreatedTime datetime - -
LastModifiedTime datetime - -
IsActive boolean - -
ParentAccountID string ChartOfAccounts → AccountID -
AccountCode string - -
AccountType string - -
IsSystemAccount boolean - -
IsUserCreated boolean - -
CanShowInZe boolean - -
Depth int - -
HasAttachment boolean - -
IsChildPresent boolean - -
ChildCount string - -
IsStandaloneAccount boolean - -
IsInvolvedInTransaction boolean - -
ClosingBalance decimal - -
Isdebit boolean - -
Status string - -

Contact

Documentation: https://www.zoho.com/books/api/v3/contacts/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string - -
ContactName string - -
CreatedTime datetime - -
LastModifiedTime datetime - -
CompanyName string - -
ContactType string - -
Status string - -
PaymentTerms int - -
PaymentTermsLabel string - -
CurrencyID string Currency → CurrencyID -
OutstandingReceivableAmount decimal - -
UnusedCreditsReceivableAmount decimal - -
FirstName string - -
LastName string - -
Email string - -
Phone string - -
Mobile string - -
CustomerName string - -
VendorName string - -
Website string - -
LanguageCode string - -
CustomerSubType string - -
Source string - -
IsLinkedWithZohocrm string - -
Twitter string - -
Facebook string - -
OutstandingPayableAmount decimal - -
UnusedCreditsPayableAmount decimal - -
AchSupported boolean - -
PortalStatus string - -
Designation string - -
Department string - -
IsBcyOnlyContact boolean - -
IsCreditLimitMigrationCompleted boolean - -
ContactSalutation string - -
PhotoUrl string - -
InvitedBy string - -
IsClientReviewAsked boolean - -
HasTransaction boolean - -
OwnerID string User → UserID -
IsCrmCustomer boolean - -
PrimaryContactID string ContactPerson → ContactPersonID -
ZcrmAccountID string - -
ZcrmContactID string - -
CrmOwnerID string - -
PaymentTermsID string - -
CreditLimitExceededAmount decimal - -
CurrencySymbol string - -
PricePrecision int - -
ExchangeRate decimal - -
CanShowCustomerOb boolean - -
CanShowVendorOb boolean - -
OpeningBalanceAmount decimal - -
OutstandingObReceivableAmount decimal - -
OutstandingObPayableAmount decimal - -
UnusedRetainerPayments decimal - -
PaymentReminderEnabled boolean - -
IsSmsEnabled boolean - -
IsConsentAgreed boolean - -
ConsentDate string - -
IsClientReviewSettingsEnabled boolean - -
TaxID string Tax → TaxID -
AccountID string ChartOfAccounts → AccountID -
ContactCategory string - -
SalesChannel string - -
PortalReceiptCount int - -
AssociatedWithSquare boolean - -
Notes string - -
CreatedDate string - -
CreatedByID string User → UserID -
LastModifiedByID string User → UserID -
ZohopeopleClientID string - -
SiretNumber string - -
CompanyID string - -
LabelForCompanyID string - -
SubmittedDate string - -
SubmitterID string User → UserID -
ApproverID string User → UserID -
DefaultStatementTemplateID string Template → TemplateID -
DefaultInvoiceTemplateID string Template → TemplateID -
DefaultBillTemplateID string Template → TemplateID -
DefaultEstimateTemplateID string Template → TemplateID -
DefaultCreditnoteTemplateID string Template → TemplateID -
DefaultPaymentthankyouTemplateID string Template → TemplateID -
DefaultInvoiceEmailTemplateID string Template → TemplateID -
DefaultEstimateEmailTemplateID string Template → TemplateID -
DefaultCreditnoteEmailTemplateID string Template → TemplateID -
DefaultPaymentthankyouEmailTemplateID string Template → TemplateID -
DefaultPaymentRemittanceEmailTemplateID string Template → TemplateID -

CreditNote

Documentation: https://www.zoho.com/books/api/v3/credit-notes/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreatedByID string User → UserID -
LastModifiedByID string User → UserID -
InvoiceID string Invoice → InvoiceID -
Notes string - -
Terms string - -
SubjectContent string - -
SalesChannel string - -
TdsCalculationType string - -
ContactCategory string - -
TaxRounding string - -
TaxOverridePreference string - -
TdsOverridePreference string - -
IsInclusiveTax boolean - -
Discount decimal - -
DiscountAppliedOnAmount decimal - -
IsDiscountBeforeTax boolean - -
DiscountType string - -
DiscountAccountID string ChartOfAccounts → AccountID -
AccountID string ChartOfAccounts → AccountID -
AdjustmentAccountID string ChartOfAccounts → AccountID -
IsInventoryValuationPending boolean - -
SubmitterID string User → UserID -
ApproverID string User → UserID -
SubmittedDate datetime - -
ShippingChargeTaxID string Tax → TaxID -
ShippingChargeTax decimal - -
ShippingChargeExclusiveOfTax decimal - -
ShippingChargeInclusiveOfTax decimal - -
ShippingChargeAccountID string ChartOfAccounts → AccountID -
ShippingCharge decimal - -
Adjustment decimal - -
AdjustmentDescription string - -
RoundoffValue decimal - -
TransactionRoundingType string - -
SubTotal decimal - -
SubTotalInclusiveOfTax decimal - -
TaxTotal decimal - -
TotalCreditsUsed decimal - -
TotalRefundedAmount decimal - -
ComputationType string - -
LockDetailsCanLock boolean - -
CreditnoteID string - -
CreditnoteNumber string - -
CreatedTime datetime - -
LastModifiedTime datetime - -
Status string - -
ReferenceNumber string - -
Date datetime - -
CustomerID string Contact → ContactID -
TemplateID string Template → TemplateID -
CurrencyID string Currency → CurrencyID -
SalespersonID string SalesPerson → SalespersonID -
CurrentSubStatusID string - -
Total decimal - -
Balance decimal - -
IsEmailed boolean - -
IsViewedByClient boolean - -
ClientViewedTime string - -
ColorCode string - -
RoundingMode string - -
PricePrecision int - -

Currency

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CurrencyID string - -
CurrencyName string - -
CurrencyCode string - -
CurrencySymbol string - -
PricePrecision decimal - -
CurrencyFormat string - -
IsBaseCurrency boolean - -
ExchangeRate decimal - -
EffectiveDate datetime - -
AutoExchangeRateEnabled boolean - -

CustomerPayment

Documentation: https://www.zoho.com/books/api/v3/customer-payments/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
PaymentID string - -
PaymentNumber string - -
CreatedTime datetime - -
LastModifiedTime datetime - -
Date datetime - -
AccountID string ChartOfAccounts → AccountID -
CustomerID string Contact → ContactID -
TaxAccountID string ChartOfAccounts → AccountID -
PaymentMode string - -
Amount decimal - -
UnusedAmount decimal - -
ReferenceNumber string - -
LastFourDigits string - -
GatewayTransactionID string - -
PaymentGateway string - -
TaxAmountWithheld decimal - -
PaymentType string - -
PaymentStatus string - -
SettlementStatus string - -
PaymentLinkID string - -
CreatedBy string - -
PaymentNumberPrefix string - -
PaymentNumberSuffix string - -
CardType string - -
OfflineCreatedDateWithTime string - -
CustomerAdvanceAccountID string ChartOfAccounts → AccountID -
CurrencyID string Currency → CurrencyID -
BankCharges decimal - -
IsClientReviewSettingsEnabled boolean - -
DiscountAmount decimal - -
IsEarlyPaymentDiscountApplicable boolean - -
OnlineTransactionID string - -
IsOndcChannel boolean - -
TemplateID string Template → TemplateID -
CanSendPaymentSms boolean - -
IsPaymentDetailsRequired boolean - -
PricePrecision int - -
RoundingMode string - -

CustomField

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomfieldID string - -
Label string - -
IsActive boolean - -
SearchEntity string - -
Precision int - -
IsMandatoryInSalesItem boolean - -
IsMandatoryInHp boolean - -
EditOnStore boolean - -
ShowInAllPdf boolean - -
IsInheritedValue boolean - -
MaxLength string - -
ShowInStore boolean - -
Index string - -
ShowInHp boolean - -
IsMandatory boolean - -
DefaultValue string - -
IsMandatoryInStorefront boolean - -
DataType string - -
IsDependentField boolean - -
HelpText string - -

Estimate

Documentation: https://www.zoho.com/books/api/v3/estimates/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EstimateID string - -
EstimateNumber string - -
CreatedTime datetime - -
LastModifiedTime datetime - -
ZcrmPotentialID string - -
CustomerID string Contact → ContactID -
Status string - -
ColorCode string - -
CurrentSubStatusID string - -
ReferenceNumber string - -
Date datetime - -
CurrencyID string Currency → CurrencyID -
Total decimal - -
AcceptedDate datetime - -
DeclinedDate datetime - -
ExpiryDate datetime - -
HasAttachment boolean - -
IsViewedByClient boolean - -
ClientViewedTime datetime - -
IsEmailed boolean - -
TemplateID string Template → TemplateID -
SalespersonID string SalesPerson → SalespersonID -
IsTransactionCreated boolean - -
IsConvertedToOpen boolean - -
IsProgressiveQuote boolean - -
UninvoicedAmount decimal - -
InvoicedAmount decimal - -
ContactCategory string - -
ExchangeRate decimal - -
DiscountAmount decimal - -
Discount string - -
DiscountAppliedOnAmount decimal - -
IsDiscountBeforeTax boolean - -
DiscountType string - -
IsInclusiveTax boolean - -
TaxRounding string - -
TdsCalculationType string - -
EstimateUrl string - -
SubmitterID string User → UserID -
SubmittedDate datetime - -
ApproverID string User → UserID -
ShippingChargeTaxID string Tax → TaxID -
ShippingChargeTax decimal - -
ShippingChargeExclusiveOfTax decimal - -
ShippingChargeInclusiveOfTax decimal - -
ShippingChargeAccountID string ChartOfAccounts → AccountID -
ShippingCharge decimal - -
Adjustment decimal - -
AdjustmentDescription string - -
RoundoffValue decimal - -
TransactionRoundingType string - -
RoundingMode string - -
SubTotal decimal - -
SubTotalInclusiveOfTax decimal - -
SubTotalExclusiveOfDiscount decimal - -
DiscountTotal decimal - -
DiscountPercent decimal - -
TaxTotal decimal - -
PricePrecision int - -
TaxOverridePreference string - -
TdsOverridePreference string - -
Notes string - -
Terms string - -
CreatedByID string User → UserID -
LastModifiedByID string User → UserID -
CanSendEstimateSms boolean - -
AllowPartialPayments boolean - -
EstimateType string - -
SubjectContent string - -
CanLock boolean - -
ProjectID string Project → ProjectID -

Invoice

Documentation: https://www.zoho.com/books/api/v3/invoices/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string - -
InvoiceNumber string - -
CreatedTime datetime - -
LastModifiedTime datetime - -
ZcrmPotentialID string - -
CustomerID string Contact → ContactID -
AchPaymentInitiated boolean - -
ZcrmPotentialName string - -
CompanyName string - -
Status string - -
ReferenceNumber string - -
Date datetime - -
DueDate datetime - -
ClientViewedTime datetime - -
DueDays string - -
Email string - -
ProjectName string - -
Country string - -
Phone string - -
Total decimal - -
Balance decimal - -
PaymentExpectedDate string - -
ShippingCharge decimal - -
Adjustment decimal - -
IsEmailed boolean - -
ColorCode string - -
CurrentSubStatusID string - -
CurrencyID string Currency → CurrencyID -
ScheduleTime string - -
NoOfCopies int - -
ShowNoOfCopies boolean - -
InvoiceUrl string - -
TransactionType string - -
RemindersSent int - -
LastReminderSentDate datetime - -
LastPaymentDate datetime - -
TemplateID string Template → TemplateID -
SalespersonID string SalesPerson → SalespersonID -
WriteOffAmount decimal - -
ExchangeRate decimal - -
UnprocessedPaymentAmount decimal - -
InvoiceSource string - -
RecurringInvoiceID string -
  • 19 Nov 2025 Foreign Key - Refers to RecurringInvoice (not implemented)
IsLastChildInvoice boolean - -
PaymentTerms int - -
PaymentTermsLabel string - -
PaymentReminderEnabled boolean - -
PaymentMade decimal - -
IsInventoryValuationPending boolean - -
IsProgressInvoice boolean - -
CanShowKitReturn boolean - -
IsKitPartialReturn boolean - -
TotalRetentionAmount decimal - -
RetentionOverridePreference string - -
IsAutobillEnabled boolean - -
InprocessTransactionPresent boolean - -
AllowPartialPayments boolean - -
PricePrecision int - -
SubTotal decimal - -
TaxTotal decimal - -
DiscountTotal decimal - -
DiscountPercent decimal - -
Discount decimal - -
DiscountAppliedOnAmount decimal - -
DiscountType string - -
DiscountAccountID string ChartOfAccounts → AccountID -
AccountID string ChartOfAccounts → AccountID -
AdjustmentAccountID string ChartOfAccounts → AccountID -
TaxOverridePreference string - -
TdsOverridePreference string - -
IsDiscountBeforeTax boolean - -
AdjustmentDescription string - -
ShippingChargeTaxID string Tax → TaxID -
ShippingChargeExclusiveOfTax decimal - -
ShippingChargeTax decimal - -
ShippingChargeInclusiveOfTax decimal - -
ShippingChargeAccountID string ChartOfAccounts → AccountID -
RoundoffValue decimal - -
TransactionRoundingType string - -
RoundingMode string - -
IsInclusiveTax boolean - -
SubTotalInclusiveOfTax decimal - -
TaxRegNo string - -
TdsCalculationType string - -
CanSendInvoiceSms boolean - -
PaymentDiscount decimal - -
StopReminderUntilPaymentExpectedDate boolean - -
AchSupported boolean - -
ReaderOfflinePaymentInitiated boolean - -
ComputationType string - -
MerchantID string - -
EcommOperatorID string - -
SalesorderID string -
  • 19 Nov 2025 Foreign Key - Assumed refers to SalesOrder (not implemented)
SubjectContent string - -
CreatedByID string User → UserID -
LastModifiedByID string User → UserID -
IsBackorder string - -
SalesChannel string - -
EstimateID string Estimate → EstimateID -
IsClientReviewSettingsEnabled boolean - -
UnusedRetainerPayments decimal - -
CreditsApplied decimal - -
TaxAmountWithheld decimal - -
IncludesPackageTrackingInfo boolean - -
Notes string - -
Terms string - -
SubmitterID string User → UserID -
ApproverID string User → UserID -
SubmittedDate datetime - -
CanLock boolean - -
QrCodeQrSource string - -
QrCodeIsQrEnabled boolean - -
QrCodeQrValue string - -
QrCodeQrDescription string - -

Item

Documentation: https://www.zoho.com/books/api/v3/items/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
ItemID string - -
ItemName string - -
CreatedTime datetime - -
LastModifiedTime datetime - -
Status string - -
Unit string - -
Rate decimal - -
Source string - -
IsLinkedWithZohocrm boolean - -
ZcrmProductID string - -
TaxID string Tax → TaxID -
AccountID string ChartOfAccounts → AccountID -
PurchaseAccountID string ChartOfAccounts → AccountID -
PurchaseDescription string - -
PurchaseRate decimal - -
CanBeSold boolean - -
CanBePurchased boolean - -
TrackInventory boolean - -
ItemType string - -
ProductType string - -
HasAttachment boolean - -
Sku string - -
ImageName string - -
ImageType string - -
ImageDocumentID string - -
Brand string - -
Manufacturer string - -
CrmOwnerID string - -
UnitID string - -
PurchaseTaxID string Tax → TaxID -
IsDefaultTaxApplied boolean - -
AssociatedTemplateID string Template → TemplateID -
PricebookRate decimal - -
PricingScheme string - -
SalesRate decimal - -
SalesMargin string - -
MinimumOrderQuantity decimal - -
MaximumOrderQuantity decimal - -
VendorID string Contact → ContactID -
VendorName string - -
IsFulfillable boolean - -
CanLock boolean - -

Journal

Documentation: https://www.zoho.com/books/api/v3/bank-accounts/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreatedTime datetime - -
ReversalDate datetime - -
IsPeriodEndJournal boolean - -
FiscalYear int - -
JournalTemplateName string - -
JournalNumberPrefix string - -
JournalNumberSuffix string - -
LineItemTotal decimal - -
AvailableReceivablesCredits decimal - -
AvailablePayablesCredits decimal - -
IsAccrualJournal boolean - -
ProjectID string Project → ProjectID -
SubmittedDate datetime - -
SubmitterID string User → UserID -
ApproverID string User → UserID -
JournalID string - -
LastModifiedTime datetime - -
JournalDate datetime - -
EntryNumber string - -
ReferenceNumber string - -
Notes string - -
Total decimal - -
CurrencyID string Currency → CurrencyID -
Status string - -
JournalType string - -
CreatedByID string User → UserID -

Project

Documentation: https://www.zoho.com/books/api/v3/projects/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
ProjectID string - -
ProjectName string - -
CreatedTime datetime - -
LastModifiedTime datetime - -
Status string - -
CustomerID string Contact → ContactID -
ProjectCode string - -
CanBeInvoiced boolean - -
BillingType string - -
Rate decimal - -
HasAttachment boolean - -
TotalHours string - -
BillableHours string - -
OtherServiceAppSource string - -
UsersWorking int - -
CurrencyID string Currency → CurrencyID -
BillingRateFrequency string - -
IsFromZohoProjects boolean - -
BudgetType string - -
BudgetAmount decimal - -
CostBudgetAmount decimal - -
IsBudgetThresholdNotificationEnabled boolean - -
IsClientApprovalNeeded boolean - -
IsUserApprovalNeeded boolean - -
HoursPerDay string - -
BudgetThreshold decimal - -
IsExpenseInclusive boolean - -
TotalAmount decimal - -
TotalAmountExpenseInclusive string - -
BilledHours string - -
BilledAmount string - -
UnBilledHours string - -
UnBilledAmount string - -
BillableAmount decimal - -
NonBillableHours string - -
NonBillableAmount decimal - -
UnusedRetainerPayments decimal - -
HasActiveRecurringProfiles boolean - -
CreatedByID string User → UserID -
LastModifiedByID string User → UserID -
ZohopeopleProjectID string - -
ZohoworkerlyProjectID string - -
ShowInDashboard boolean - -

ReportingTag

Documentation: https://help.zoho.com/portal/en/community/topic/reporting-tags-api-calls

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TagID string - -
TagName string - -
IsActive boolean - -
AssociatedWith string - -

SalesPerson

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SalespersonID string - -
SalespersonName string - -
IsActive boolean - -
SalespersonEmail string - -
CrmReferenceID string - -

Tax

Documentation: https://www.zoho.com/books/api/v3/taxes/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
TaxID string - -
TaxName string - -
LastModifiedTime datetime - -
Status string - -
TaxPercentage decimal - -
TaxType string - -
OutputTaxAccountName string - -
PurchaseTaxAccountName string - -
TaxSpecificType string - -
TaxAccountID string ChartOfAccounts → AccountID -
PurchaseTaxAccountID string ChartOfAccounts → AccountID -
IsValueAdded boolean - -
IsDefaultTax boolean - -
IsEditable boolean - -
TdsPayableAccountID string ChartOfAccounts → AccountID -
TaxAccountTracking string - -

Template

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TemplateDescription string - -
DocumentTitle string - -
Orientation string - -
PaperSize string - -
PageWidth string - -
PageHeight string - -
ReferenceFieldLabel string - -
ItemNameLabel string - -
DescriptionLabel string - -
QuantityLabel string - -
DiscountLabel string - -
RateLabel string - -
TemplateID string - -
IsActive boolean - -
TemplateName string - -
TemplateGroup string - -
TemplateType string - -
IsCustom boolean - -
IsDefault boolean - -
IsFromPlugin boolean - -

User

Documentation: https://www.zoho.com/books/api/v3/users/#overview

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
CreatedTime datetime - -
DefaultBranchID string -
  • 14 Nov 2025 Foreign Key - Refers to Branches (not implemented). API docs not available but url is simply 'branches'
IsClaimant boolean - -
BillingRate decimal - -
IsAccountant boolean - -
IsAssociatedForApproval boolean - -
IsAssociatedWithOrgEmail boolean - -
UserID string - -
Status string - -
RoleID string -
  • 14 Nov 2025 Foreign Key - Refers to Roles (not implemented). API docs not available but url is simply 'roles'
Email string - -
Mobile string - -
InvitationType string - -
IsSuperAdmin boolean - -
IsCustomerSegmented boolean - -
IsVendorSegmented boolean - -
PhotoUrl string - -
IsEmployee boolean - -
Source string - -
UserType string - -

BankAccountCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
BankAccountRemoteID string BankAccount → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BankAccountID string BankAccount → AccountID -
CustomfieldID string CustomField → CustomfieldID -

BillDocument

Column Type Relates to Notes
RemoteID string - -
BillRemoteID string Bill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BillID string Bill → BillID -
DocumentID string - -
UploadedOn datetime - -
FileName string - -
UploadedByID string User → UserID -
AttachmentOrder int - -
Source string - -
FileSize string - -
CanShowInPortal boolean - -
FileType string - -
AlterText string - -

BillCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
BillRemoteID string Bill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BillID string Bill → BillID -
CustomfieldID string CustomField → CustomfieldID -

BillTax

Column Type Relates to Notes
RemoteID string - -
BillRemoteID string Bill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BillID string Bill → BillID -
TaxID string - -
TaxAmount decimal - -

BillLineItem

Column Type Relates to Notes
RemoteID string - -
BillRemoteID string Bill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BillID string Bill → BillID -
LineItemID string - -
PurchaseorderID string -
  • 19 Nov 2025 Foreign Key - Refers to PurchaseOrder (not implemented)
PurchaseorderItemID string -
  • 19 Nov 2025 Foreign Key - Assume refers to PurchaseOrderLineItem (not implemented)
ItemID string Item → ItemID -
PricebookID string - -
HeaderID string - -
Quantity decimal - -
DiscountAmount decimal - -
Discount string - -
DiscountAccountID string ChartOfAccounts → AccountID -
MarkupPercent decimal - -
ItemTotal decimal - -
ItemOrder int - -
IsBillable boolean - -
CustomerID string Contact → ContactID -
ReceiptLineItemID string - -
ProjectID string Project → ProjectID -
InvoiceID string Invoice → InvoiceID -
ItemMatchingType string - -

ChartOfAccountsTransaction

Column Type Relates to Notes
RemoteID string - -
ChartOfAccountsRemoteID string ChartOfAccounts → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ChartOfAccountsID string ChartOfAccounts → AccountID -
LineNumber int - -
TransactionID string - -
EntityType string - -

ChartOfAccountsDocument

Column Type Relates to Notes
RemoteID string - -
ChartOfAccountsRemoteID string ChartOfAccounts → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ChartOfAccountsID string ChartOfAccounts → AccountID -
DocumentID string - -
CanSendInMail int - -
FileName string - -
FileType string - -
AttachmentOrder int - -
FileSize string - -

ChartOfAccountsCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
ChartOfAccountsRemoteID string ChartOfAccounts → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ChartOfAccountsID string ChartOfAccounts → AccountID -
CustomfieldID string CustomField → CustomfieldID -

ContactAddress

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
AddressID string - -
AddressType string - -
Attention string - -
Address string - -
Street2 string - -
City string - -
StateCode string - -
State string - -
Zip string - -
Country string - -
County string - -
CountryCode string - -
Phone string - -
Fax string - -

ContactDocument

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
DocumentID string - -
UploadedOn datetime - -
FileName string - -
UploadedByID string User → UserID -
AttachmentOrder int - -
Source string - -
FileSize string - -
CanShowInPortal boolean - -
FileType string - -
AlterText string - -

ContactOpeningBalance

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
LineNumber int - -
OpeningBalanceAmount decimal - -
ExchangeRate decimal - -

ContactPerson

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
ContactPersonID string - -
FirstName string - -
LastName string - -
ZcrmContactID string - -

ContactReportingTag

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
TagOptionID string ReportingTagOption → TagOptionID -

ContactCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID string Contact → ContactID -
CustomfieldID string CustomField → CustomfieldID -

CreditNoteLineItem

Column Type Relates to Notes
RemoteID string - -
CreditNoteRemoteID string CreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreditNoteID string CreditNote → CreditnoteID -
LineItemID string - -
ItemID string Item → ItemID -
AccountID string ChartOfAccounts → AccountID -
InvoiceID string Invoice → InvoiceID -
InvoiceItemID string InvoiceLineItem → LineItemID -
ProjectID string Project → ProjectID -
DiscountAccountID string ChartOfAccounts → AccountID -
PricebookID string - -
Quantity decimal - -
ItemOrder int - -
DiscountAmount decimal - -
Discount string - -
ItemTotal decimal - -
IsCreditOnlyItem boolean - -

CreditNoteCreditedInvoice

Column Type Relates to Notes
RemoteID string - -
CreditNoteRemoteID string CreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreditNoteID string CreditNote → CreditnoteID -
CreditnoteInvoiceID string - -
InvoiceID string Invoice → InvoiceID -
Date datetime - -
CreditedAmount decimal - -

CreditNoteAssociatedContact

Column Type Relates to Notes
RemoteID string - -
CreditNoteRemoteID string CreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreditNoteID string CreditNote → CreditnoteID -
ContactPersonID string - -
FirstName string - -
LastName string - -

CreditNoteContact

Column Type Relates to Notes
RemoteID string - -
CreditNoteRemoteID string CreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreditNoteID string CreditNote → CreditnoteID -
ContactPersonID string - -
FirstName string - -
LastName string - -

CreditNoteTax

Column Type Relates to Notes
RemoteID string - -
CreditNoteRemoteID string CreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreditNoteID string CreditNote → CreditnoteID -
TaxName string - -
TaxAmount decimal - -

CreditNoteShippingChargeTax

Column Type Relates to Notes
RemoteID string - -
CreditNoteRemoteID string CreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreditNoteID string CreditNote → CreditnoteID -
TaxName string - -
TaxAmount decimal - -

CreditNoteDocument

Column Type Relates to Notes
RemoteID string - -
CreditNoteRemoteID string CreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreditNoteID string CreditNote → CreditnoteID -
DocumentID string - -
UploadedByID string Contact → ContactID -
UploadedOn datetime - -
CanSendInMail boolean - -
FileName string - -
AttachmentOrder int - -
Source string - -
FileSize string - -
FileType string - -
AlterText string - -
CanShowInPortal boolean - -

CreditNoteCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
CreditNoteRemoteID string CreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreditNoteID string CreditNote → CreditnoteID -
CustomfieldID string CustomField → CustomfieldID -

CustomerPaymentDocument

Column Type Relates to Notes
RemoteID string - -
CustomerPaymentRemoteID string CustomerPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomerPaymentID string CustomerPayment → PaymentID -
DocumentID string - -
UploadedByID string Contact → ContactID -
UploadedOn datetime - -
CanSendInMail boolean - -
FileName string - -
AttachmentOrder int - -
Source string - -
FileSize string - -
FileType string - -
AlterText string - -

CustomerPaymentInvoice

Column Type Relates to Notes
RemoteID string - -
CustomerPaymentRemoteID string CustomerPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomerPaymentID string CustomerPayment → PaymentID -
InvoicePaymentID string - -
InvoiceID string Invoice → InvoiceID -
AmountApplied decimal - -
ApplyDate datetime - -
DiscountAmount decimal - -
IsEarlyPaymentDiscountApplicable boolean - -

CustomerPaymentCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
CustomerPaymentRemoteID string CustomerPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CustomerPaymentID string CustomerPayment → PaymentID -
CustomfieldID string CustomField → CustomfieldID -

CustomFieldOption

Column Type Relates to Notes
RemoteID string - -
CustomFieldRemoteID string CustomField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
CustomfieldID string CustomField → CustomfieldID -
ValueID string - -
IsActive boolean - -
Order int - -

EstimateDocument

Column Type Relates to Notes
RemoteID string - -
EstimateRemoteID string Estimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EstimateID string Estimate → EstimateID -
DocumentID string - -
FileName string - -
UploadedOn datetime - -
UploadedByID string User → UserID -
CanSendInMail boolean - -
AttachmentOrder int - -
Source string - -
FileSize decimal - -
FileType string - -
AlterText string - -

EstimateLineItem

Column Type Relates to Notes
RemoteID string - -
EstimateRemoteID string Estimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EstimateID string Estimate → EstimateID -
LineItemID string - -
ItemID string Item → ItemID -
HeaderID string - -
PricebookID string - -
ItemOrder int - -
Quantity decimal - -
Discount string - -
ItemTotal decimal - -
ComboType string - -

EstimateTax

Column Type Relates to Notes
RemoteID string - -
EstimateRemoteID string Estimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EstimateID string Estimate → EstimateID -
TaxName string - -
TaxAmount decimal - -

EstimateAssociatedContact

Column Type Relates to Notes
RemoteID string - -
EstimateRemoteID string Estimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EstimateID string Estimate → EstimateID -
ContactPersonID string - -
FirstName string - -
LastName string - -

EstimateContact

Column Type Relates to Notes
RemoteID string - -
EstimateRemoteID string Estimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EstimateID string Estimate → EstimateID -
ContactPersonID string - -
FirstName string - -
LastName string - -

EstimateCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
EstimateRemoteID string Estimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
EstimateID string Estimate → EstimateID -
CustomfieldID string CustomField → CustomfieldID -

InvoiceDocument

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string Invoice → InvoiceID -
DocumentID string - -
FileName string - -
UploadedOn datetime - -
UploadedByID string Contact → ContactID -
CanSendInMail boolean - -
AttachmentOrder int - -
Source string - -
FileSize string - -
FileType string - -
AlterText string - -

InvoiceLineItem

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string Invoice → InvoiceID -
LineItemID string - -
ItemID string Item → ItemID -
ItemOrder int - -
Quantity decimal - -
DiscountAmount decimal - -
ItemTotal decimal - -
CostAmount decimal - -
MarkupPercent decimal - -
DiscountAccountID string ChartOfAccounts → AccountID -
HeaderID string - -
PricebookID string - -
BillID string Bill → BillID -
BillItemID string - -
ProjectID string Project → ProjectID -
ExpenseID string -
  • 19 Nov 2025 Foreign Key - Refers to Expense (not implemented)
SalesorderItemID string -
  • 19 Nov 2025 Foreign Key - Assume refers to SalesOrderLineItem (not implemented)

InvoiceTax

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string Invoice → InvoiceID -
LineNumber int - -
TaxAmount decimal - -
TaxName string - -

InvoiceShippingChargeTax

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string Invoice → InvoiceID -
LineNumber int - -
TaxAmount decimal - -
TaxName string - -

InvoiceAssociatedContact

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string Invoice → InvoiceID -
ContactPersonID string - -
FirstName string - -
LastName string - -

InvoiceContact

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string Invoice → InvoiceID -
ContactPersonID string - -
FirstName string - -
LastName string - -

InvoiceCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string Invoice → InvoiceID -
CustomfieldID string CustomField → CustomfieldID -

ItemReportingTag

Column Type Relates to Notes
RemoteID string - -
ItemRemoteID string Item → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ItemID string Item → ItemID -
TagOptionID string ReportingTagOption → TagOptionID -

ItemDefaultPriceBracket

Column Type Relates to Notes
RemoteID string - -
ItemRemoteID string Item → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ItemID string Item → ItemID -
LineNumber int - -
StartQuantity decimal - -
EndQuantity decimal - -
PricebookRate decimal - -

ItemCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
ItemRemoteID string Item → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ItemID string Item → ItemID -
CustomfieldID string CustomField → CustomfieldID -

JournalCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
JournalRemoteID string Journal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JournalID string Journal → JournalID -
CustomfieldID string CustomField → CustomfieldID -

JournalDocument

Column Type Relates to Notes
RemoteID string - -
JournalRemoteID string Journal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JournalID string Journal → JournalID -
DocumentID string - -
UploadedOn datetime - -
FileName string - -
UploadedByID string User → UserID -
CanSendInMail boolean - -
AttachmentOrder int - -
Source string - -
FileSize string - -
FileType string - -
AlterText string - -

JournalLineItem

Column Type Relates to Notes
RemoteID string - -
JournalRemoteID string Journal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
JournalID string Journal → JournalID -
LineID string - -
AccountID string ChartOfAccounts → AccountID -
CustomerID string Contact → ContactID -
ItemOrder int - -
DebitOrCredit string - -
TaxExemptionID string -
  • 18 Nov 2025 Foreign Key - References TaxExemption (not implemented, US Edition only)
TaxAuthorityID string -
  • 18 Nov 2025 Foreign Key - References TaxAuthority (not implemented, US Edition only)
TaxID string Tax → TaxID -
ProjectID string Project → ProjectID -
Amount decimal - -

JournalTax

Column Type Relates to Notes
RemoteID string - -
JournalRemoteID string Journal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JournalID string Journal → JournalID -
LineNumber int - -
TaxName string - -
TaxAmount decimal - -
DebitOrCredit string - -

JournalComment

Column Type Relates to Notes
RemoteID string - -
JournalRemoteID string Journal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
JournalID string Journal → JournalID -
CommentID string - -
Date datetime - -
CommentedByID string User → UserID -
CommentType string - -
OperationType string - -

ProjectUser

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID string Project → ProjectID -
UserID string User → UserID -
Rate decimal - -
BudgetHours decimal - -
BudgetHoursInTime string - -
TotalHours string - -
BilledHours string - -
UnBilledHours string - -
BillableHours string - -
NonBillableHours string - -
StaffRole string - -
StaffStatus string - -

ProjectDocument

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID string Project → ProjectID -
DocumentID string - -
UploadedOn datetime - -
FileName string - -
UploadedByID string User → UserID -
AttachmentOrder int - -
Source string - -
FileSize string - -
CanShowInPortal boolean - -
FileType string - -
AlterText string - -

ProjectCustomFieldValue

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ProjectID string Project → ProjectID -
CustomfieldID string CustomField → CustomfieldID -

ProjectTask

Column Type Relates to Notes
RemoteID string - -
ProjectRemoteID string Project → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
ProjectID string Project → ProjectID -
TaskID string - -
Status string - -
TaskName string - -
Rate decimal - -
BudgetHours int - -
BudgetHoursInTime string - -
TotalHours string - -
BilledHours string - -
UnBilledHours string - -
BillableHours string - -
NonBillableHours string - -
IsBillable boolean - -
ZohopeopleJobID string - -

ReportingTagOption

Column Type Relates to Notes
RemoteID string - -
ReportingTagRemoteID string ReportingTag → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReportingTagID string ReportingTag → TagID -
TagOptionID string - -
TagOptionName string - -
IsActive boolean - -

BankAccountCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
BankAccountCustomFieldValueRemoteID string BankAccountCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

BillCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
BillCustomFieldValueRemoteID string BillCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

BillLineItemDiscount

Column Type Relates to Notes
RemoteID string - -
BillLineItemRemoteID string BillLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BillLineItemID string BillLineItem → LineItemID -
DiscountID string - -
DiscountOrder int - -
DiscountAmount decimal - -
DiscountPercent decimal - -
DiscountAccount string ChartOfAccounts → AccountID -

BillLineItemTax

Column Type Relates to Notes
RemoteID string - -
BillLineItemRemoteID string BillLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BillLineItemID string BillLineItem → LineItemID -
TaxID string Tax → TaxID -
TaxAmount decimal - -

ChartOfAccountsCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
ChartOfAccountsCustomFieldValueRemoteID string ChartOfAccountsCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

ContactCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
ContactCustomFieldValueRemoteID string ContactCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

CreditNoteLineItemTax

Column Type Relates to Notes
RemoteID string - -
CreditNoteLineItemRemoteID string CreditNoteLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CreditNoteLineItemID string CreditNoteLineItem → LineItemID -
TaxID string Tax → TaxID -
TaxAmount decimal - -

CreditNoteLineItemDiscount

Column Type Relates to Notes
RemoteID string - -
CreditNoteLineItemRemoteID string CreditNoteLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceLineItemID string CreditNoteLineItem → LineItemID -
LineNumber int - -
DiscountAmount decimal - -
DiscountPercent decimal - -
DiscountAccount string ChartOfAccounts → AccountID -

CreditNoteCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
CreditNoteCustomFieldValueRemoteID string CreditNoteCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

CustomerPaymentCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
CustomerPaymentCustomFieldValueRemoteID string CustomerPaymentCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

EstimateCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
EstimateCustomFieldValueRemoteID string EstimateCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

InvoiceLineItemTax

Column Type Relates to Notes
RemoteID string - -
InvoiceLineItemRemoteID string InvoiceLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceLineItemID string InvoiceLineItem → LineItemID -
TaxID string Tax → TaxID -
TaxAmount decimal - -

InvoiceLineItemDiscount

Column Type Relates to Notes
RemoteID string - -
InvoiceLineItemRemoteID string InvoiceLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceLineItemID string InvoiceLineItem → LineItemID -
LineNumber int - -
DiscountAmount decimal - -
DiscountPercent decimal - -
DiscountAccount string ChartOfAccounts → AccountID -

InvoiceCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
InvoiceCustomFieldValueRemoteID string InvoiceCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

ItemCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
ItemCustomFieldValueRemoteID string ItemCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

JournalCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
JournalCustomFieldValueRemoteID string JournalCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

JournalLineItemTax

Column Type Relates to Notes
RemoteID string - -
JournalLineItemRemoteID string JournalLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
JournalLineItemID string JournalLineItem → LineID -
TaxID string - -
TaxAmount decimal - -

ProjectCustomFieldValueOption

Column Type Relates to Notes
RemoteID string - -
ProjectCustomFieldValueRemoteID string ProjectCustomFieldValue → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Value string - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Zoho Books data Querying Zoho Books using regular SQL