Explore the QuickBooks API data model

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

Try our interactive ERD Or, browse below

Pulling data from the QuickBooks 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 QuickBooks 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

Account

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Description string - -
AcctNum string - -
CurrencyCode string - -
ParentAccountID string Account → ID -
SubAccount boolean - -
Classification string - -
FullyQualifiedName string - -
AccountType string - -
AccountSubType string - -
AccountAlias string - -
CurrentBalanceWithSubAccounts decimal - -
CurrentBalance decimal - -
TaxCodeID string TaxCode → ID -
Active boolean - -

Bill

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/bill

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
VendorID string Vendor → ID -
CurrencyCode string - -
APAccountID string Account → ID -
TermID string Term → ID -
Domain string - -
TxnDate datetime - -
TotalAmt decimal - -
TaxCodeID string TaxCode → ID -
DueDate datetime - -
DocNumber string - -
PrivateNote string - -
TotalTax decimal - -
ExchangeRate decimal - -
IncludeInAnnualTPAR boolean - -
HomeBalance decimal - -
RecurDataID string - -
Balance decimal - -

BillPayment

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/billpayment

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
VendorID string Vendor → ID -
TotalAmt decimal - -
PayType string - -
SyncToken string - -
CurrencyName string - -
CurrencyCode string - -
DocNumber string - -
PrivateNote string - -
TxnDate datetime - -
ExchangeRate decimal - -
AccountID string Account → ID -
DepartmentID string Department → ID -
ProcessBillPayment boolean - -
BankAccountID string Account → ID -
CheckPaymentPrintStatus string - -
CreditCardAccountID string Account → ID -

Class

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/class

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
FullyQualifiedName string - -
Domain string - -
SyncToken string - -
SubClass boolean - -
Active boolean - -

Company

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/companyinfo

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
CompanyName string - -
CompanyAddressPostalCode string - -
CompanyAddressCity string - -
CompanyAddressCountry string - -
CompanyAddressCountrySubDivisionCode string - -
CompanyAddressLine1 string - -
CompanyAddressLine2 string - -
CompanyAddressLine3 string - -
LegalAddressPostalCode string - -
LegalAddressCity string - -
LegalAddressCountry string - -
LegalAddressCountrySubDivisionCode string - -
LegalAddressLine1 string - -
LegalAddressLine2 string - -
LegalAddressLine3 string - -
CustomerCommunicationAddrPostalCode string - -
CustomerCommunicationAddrCity string - -
CustomerCommunicationAddrCountry string - -
CustomerCommunicationAddrCountrySubDivisionCode string - -
CustomerCommunicationAddrLine1 string - -
CustomerCommunicationAddrLine2 string - -
CustomerCommunicationAddrLine3 string - -
SupportedLanguages string - -
Country string - -
EmailAddress string - -
WebAddrURI string - -
FiscalYearStartMonth string - -
DefaultTimeZone string - -
CompanyStartDate datetime - -

CreditMemo

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/creditmemo

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Domain string - -
SyncToken string - -
TxnDate string - -
DocNumber string - -
PrivateNote string - -
PrintStatus string - -
EmailStatus string - -
ApplyTaxAfterDiscount boolean - -
RemainingCredit decimal - -
TotalAmt decimal - -
Balance decimal - -
Memo string - -
CurrencyName string - -
CurrencyValue string - -
BillAddrPostalCode string - -
BillAddrCity string - -
BillAddrCountry string - -
BillAddrCountrySubDivisionCode string - -
BillAddrLine1 string - -
BillAddrLine2 string - -
BillAddrLine3 string - -
ShipAddrPostalCode string - -
ShipAddrCity string - -
ShipAddrCountry string - -
ShipAddrCountrySubDivisionCode string - -
ShipAddrLine1 string - -
ShipAddrLine2 string - -
ShipAddrLine3 string - -

Customer

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/customer

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DisplayName string - -
Suffix string - -
Title string - -
MiddleName string - -
FamilyName string - -
GivenName string - -
ResaleNum string - -
SecondaryTaxIdentifier string - -
DefaultTaxCodeID string TaxCode → ID -
PreferredDeliveryMethod string - -
TermID string Term → ID -
CustomerTypeID string - -
FaxNumber string - -
BillWithParent boolean - -
CurrencyCode string - -
MobileNumber string - -
AlternatePhoneNumber string - -
ParentCustomerID string Customer → ID -
Notes string - -
WebAddrURI string - -
CompanyName string - -
Balance decimal - -
ShipAddrPostalCode string - -
ShipAddrCity string - -
ShipAddrCountry string - -
ShipAddrCountrySubDivisionCode string - -
ShipAddrLine1 string - -
ShipAddrLine2 string - -
ShipAddrLine3 string - -
PaymentMethodID string - -
IsProject boolean - -
PrimaryTaxIdentifier string - -
PrintOnCheckName string - -
BillAddrPostalCode string - -
BillAddrCity string - -
BillAddrCountry string - -
BillAddrCountrySubDivisionCode string - -
BillAddrLine1 string - -
BillAddrLine2 string - -
BillAddrLine3 string - -
FullyQualifiedName string - -
Level int - -
Active boolean - -

Department

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/department

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
FullyQualifiedName string - -
Domain string - -
SyncToken string - -
SubDepartment boolean - -
Active boolean - -

Deposit

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/deposit

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
CashBackAccountID string Account → ID -
CashBackAmount decimal - -
CashBackMemo string - -
DepositToAccountID string Account → ID -
PrivateNote string - -
SyncToken string - -
CurrencyCode string - -
DepartmentID string Department → ID -
TxnDate datetime - -
ExchangeRate decimal - -
TotalAmt decimal - -
HomeTotalAmt decimal - -
RecurDataID string - -
Domain string - -
GlobalTaxCalculation string - -

Employee

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/employee

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
PrimaryAddrPostalCode string - -
PrimaryAddrCity string - -
PrimaryAddrCountry string - -
PrimaryAddrCountrySubDivisionCode string - -
PrimaryAddrLine1 string - -
PrimaryAddrLine2 string - -
PrimaryAddrLine3 string - -
EmployeeNumber string - -
PrimaryEmailAddressValue string - -
DisplayName string - -
Title string - -
BillableTime boolean - -
GivenName string - -
BirthDate string - -
MiddleName string - -
FamilyName string - -
SSN string - -
PrimaryPhoneNumber string - -
ReleasedDate string - -
MobileNumber string - -
Gender string - -
CostRate decimal - -
BillRate decimal - -
HiredDate string - -
Organization boolean - -
Suffix string - -
PrintOnCheckName string - -
V4IDPseudonym string - -
Active boolean - -

Estimate

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/estimate

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
CustomerID string Customer → ID -
SyncToken string - -
ShipFromAddressPostalCode string - -
ShipFromAddressCity string - -
ShipFromAddressCountry string - -
ShipFromAddressCountrySubDivisionCode string - -
ShipFromAddressLine1 string - -
ShipFromAddressLine2 string - -
ShipFromAddressLine3 string - -
CurrencyCode string - -
BillEmailAddress string - -
TxnDate datetime - -
ShipDate datetime - -
ClassID string Class → ID -
PrintStatus string - -
TermID string Term → ID -
TxnStatus string - -
AcceptedDate datetime - -
ExpirationDate datetime - -
DueDate datetime - -
DocNumber string - -
PrivateNote string - -
LinesSubTotal decimal - -
DiscountLineAmount decimal - -
DiscountLinePercent decimal - -
Memo string - -
EmailStatus string - -
AcceptedBy string - -
ExchangeRate decimal - -
ShipAddrPostalCode string - -
ShipAddrCity string - -
ShipAddrCountry string - -
ShipAddrCountrySubDivisionCode string - -
ShipAddrLine1 string - -
ShipAddrLine2 string - -
ShipAddrLine3 string - -
BillAddrPostalCode string - -
BillAddrCity string - -
BillAddrCountry string - -
BillAddrCountrySubDivisionCode string - -
BillAddrLine1 string - -
BillAddrLine2 string - -
BillAddrLine3 string - -
DepartmentID string Department → ID -
ShipMethodID string - -
ApplyTaxAfterDiscount boolean - -
TotalAmt decimal - -
RecurDataID string - -
TaxExemptionID string - -
TotalTax decimal - -
TaxCodeID string - -
HomeTotalAmt decimal - -

Expense

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/purchase

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
PaymentType string - -
SyncToken string - -
APAccountID string Account → ID -
CurrencyCode string - -
TermID string Term → ID -
TxnDate datetime - -
Domain string - -
TotalAmt decimal - -
PrintStatus string - -
RemitToAddrPostalCode string - -
RemitToAddrCity string - -
RemitToAddrCountry string - -
RemitToAddrCountrySubDivisionCode string - -
RemitToAddrLine1 string - -
RemitToAddrLine2 string - -
RemitToAddrLine3 string - -
TxnSource string - -
DocNumber string - -
PrivateNote string - -
TxnTaxCodeID string TaxCode → ID -
TxnTaxDetailTotalTax decimal - -
ExchangeRate decimal - -
DepartmentID string Department → ID -
VendorID string Vendor → ID -
CustomerID string Customer → ID -
EmployeeID string Employee → ID -
RecurDataID string - -
Credit boolean - -

Invoice

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/invoice

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
LinesSubTotal decimal - -
DiscountLineAmount decimal - -
DiscountLinePercent decimal - -
CustomerID string Customer → ID -
SyncToken string - -
ShipFromAddressPostalCode string - -
ShipFromAddressCity string - -
ShipFromAddressCountry string - -
ShipFromAddressCountrySubDivisionCode string - -
ShipFromAddressLine1 string - -
ShipFromAddressLine2 string - -
ShipFromAddressLine3 string - -
CurrencyCode string - -
DocNumber string - -
BillEmailAddress string - -
TxnDate datetime - -
ShipDate datetime - -
TrackingNum string - -
ClassID string Class → ID -
PrintStatus string - -
SalesTermID string Term → ID -
TxnSource string - -
DepositToAccountID string Account → ID -
GlobalTaxCalculation string - -
AllowOnlineACHPayment boolean - -
TransactionLocationType string - -
DueDate datetime - -
PrivateNote string - -
BillEmailCcAddress string - -
Memo string - -
EmailStatus string - -
ExchangeRate decimal - -
TotalTax decimal - -
TaxCodeID string - -
AllowOnlineCreditCardPayment boolean - -
ShipAddrPostalCode string - -
ShipAddrCity string - -
ShipAddrCountry string - -
ShipAddrCountrySubDivisionCode string - -
ShipAddrLine1 string - -
ShipAddrLine2 string - -
ShipAddrLine3 string - -
DepartmentID string Department → ID -
BillAddrPostalCode string - -
BillAddrCity string - -
BillAddrCountry string - -
BillAddrCountrySubDivisionCode string - -
BillAddrLine1 string - -
BillAddrLine2 string - -
BillAddrLine3 string - -
BillEmailBccAddress string - -
Address string - -
ShipMethodID string - -
HomeBalance decimal - -
TotalAmt decimal - -
InvoiceLink string - -
TaxExemptionID string - -
RecurDataID string - -
Balance decimal - -
HomeTotalAmt decimal - -

Item

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Description string - -
Type string - -
QtyOnHand decimal - -
InvStartDate datetime - -
TrackQtyOnHand boolean - -
IncomeAccountID string Account → ID -
AssetAccountID string Account → ID -
ExpenseAccountID string Account → ID -
SalesTaxIncluded boolean - -
PurchaseTaxIncluded boolean - -
SalesTaxCodeID string TaxCode → ID -
ClassID string Class → ID -
Source string - -
AbatementRate decimal - -
SubItem boolean - -
ReorderPoint decimal - -
PurchaseDesc string - -
PrefVendorID string Vendor → ID -
PurchaseCost decimal - -
PurchaseTaxCodeID string TaxCode → ID -
ParentID string Item → ID -
UnitPrice decimal - -
FullyQualifiedName string - -
TaxClassificationID string - -
Active boolean - -

JournalEntry

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/journalentry

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Domain string - -
SyncToken string - -
TxnDate string - -
PrivateNote string - -
Adjustment boolean - -
CurrencyName string - -
CurrencyValue string - -

Payment

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/payment

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
TotalAmt decimal - -
CustomerID string Customer → ID -
SyncToken string - -
CurrencyCode string - -
PrivateNote string - -
PaymentMethodID string - -
UnappliedAmt decimal - -
DepositToAccountID string Account → ID -
ExchangeRate decimal - -
TxnSource string - -
AccountID string Account → ID -
TxnDate datetime - -
PaymentRefNum string - -
TaxExemptionID string - -

Preferences

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/term

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
AccountingInfoTrackDepartments boolean - -
AccountingInfoClassTrackingPerTxn boolean - -
AccountingInfoClassTrackingPerTxnLine boolean - -
AccountingInfoCustomerTerminology string - -
TimeTrackingUseServices boolean - -
TimeTrackingBillCustomers boolean - -
TimeTrackingShowBillRateToAll boolean - -
TimeTrackingMarkTimeEntriesBillable boolean - -
TimeTrackingWorkWeekStartDate string - -
TaxUsingSalesTax boolean - -
TaxTaxGroupCodeRef string - -
TaxPartnerTaxEnabled boolean - -
ReportCalcAgingReportFromTxnDate boolean - -
ReportReportBasis string - -
CurrencyMultiCurrencyEnabled boolean - -
CurrencyHomeCurrency string - -
ProductAndServicesForSales boolean - -
ProductAndServicesForPurchase boolean - -
ProductAndServicesQuantityWithPriceAndRate boolean - -
ProductAndServicesQuantityOnHand boolean - -
EmailMessagesInvoiceMessage string - -
EmailMessagesInvoiceSubject string - -
EmailMessagesEstimateMessage string - -
EmailMessagesEstimateSubject string - -
EmailMessagesSalesReceiptMessage string - -
EmailMessagesSalesReceiptSubject string - -
EmailMessagesStatementMessage string - -
EmailMessagesStatementSubject string - -
SalesFormCustomTxnNumbers boolean - -
SalesFormAllowDeposit boolean - -
SalesFormAllowDiscount boolean - -
SalesFormDefaultDiscountAccountID string Account → ID -
SalesFormAllowEstimates boolean - -
SalesFormETransactionEnabledStatus string - -
SalesFormETransactionAttachPDF boolean - -
SalesFormETransactionPaymentEnabled boolean - -
SalesFormIPNSupportEnabled boolean - -
SalesFormAllowServiceDate boolean - -
SalesFormAllowShipping boolean - -
SalesFormDefaultTerms decimal - -
SalesFormUsingPriceLevels boolean - -
SalesFormDefaultCustomerMessage string - -
VendorAndPurchasesTrackingByCustomer boolean - -
VendorAndPurchasesBillableExpenseTracking boolean - -
VendorAndPurchasesDefaultMarkup decimal - -
VendorAndPurchasesDefaultMarkupAccountID string Account → ID -
VendorAndPurchasesDefaultTermsID string Term → ID -
DataPartner boolean - -
DTXCopyMemo boolean - -
MTDEnabled boolean - -
FDPEnabled boolean - -
MarkupOnBillableExpenseEnabled boolean - -
ProjectsEnabled boolean - -
SFCEnabled boolean - -
TimeTrackingFeatureEnabled boolean - -
Vendor1099Enabled boolean - -
WarnDuplicateCheckNumber boolean - -
WarnDuplicateBillNumber boolean - -
WarnDuplicateJournalNumber boolean - -
PurchseOrderEnabled boolean - -
ShowAccountNumbers boolean - -
UseCustomTxnNumbers boolean - -
AllowGratuity boolean - -
DateFormat string - -
DateFormatMnemonic string - -
NumberFormat string - -
NumberFormatMnemonic string - -
DefaultCustomerMessage string - -
DefaultItem string Item → ID -
DefaultTaxRateSelection string TaxRate → ID -
UncategorizedAssetAccountID string Account → ID -
UncategorizedExpenseAccountID string Account → ID -
UncategorizedIncomeAccountID string Account → ID -
GratuityAccount string Account → ID -
SignoutInactiveMinutes int - -

PurchaseOrder

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/purchaseorder

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
APAccountID string Account → ID -
VendorID string Vendor → ID -
Domain string - -
SyncToken string - -
CurrencyCode string - -
TxnDate datetime - -
POEmailAddress string - -
ClassID string Class → ID -
TermID string Term → ID -
Memo string - -
POStatus string - -
DueDate datetime - -
DocNumber string - -
PrivateNote string - -
ShipMethodID string - -
TxnTaxCodeID string TaxCode → ID -
TxnTaxDetailTotalTax decimal - -
ShipToCustomerID string Customer → ID -
ExchangeRate decimal - -
ShipAddrPostalCode string - -
ShipAddrCity string - -
ShipAddrCountry string - -
ShipAddrCountrySubDivisionCode string - -
ShipAddrLine1 string - -
ShipAddrLine2 string - -
ShipAddrLine3 string - -
EmailStatus string - -
TotalAmt decimal - -
RecurDataID string - -

BalanceSheetReportByFiscalYear

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/balancesheet

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Customer string - -
ReportName string - -
Currency string - -
Department string - -
DateMacro string - -
ReportBasis string - -
Item string - -
Vendor string - -
Class string - -
SummarizeColumnsBy string - -
StartPeriod string - -
EndPeriod string - -
Time datetime - -
AccountingStandard string - -
NoReportData string - -
CalculatedRemoteID string - -

BalanceSheetReportByMonth

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/balancesheet

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Customer string - -
ReportName string - -
Currency string - -
Department string - -
DateMacro string - -
ReportBasis string - -
Item string - -
Vendor string - -
Class string - -
SummarizeColumnsBy string - -
StartPeriod string - -
EndPeriod string - -
Time datetime - -
AccountingStandard string - -
NoReportData string - -
CalculatedRemoteID string - -

ProfitAndLossReportByFiscalYear

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/profitandloss

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Customer string - -
ReportName string - -
Currency string - -
Department string - -
DateMacro string - -
ReportBasis string - -
Item string - -
Vendor string - -
Class string - -
SummarizeColumnsBy string - -
StartPeriod string - -
EndPeriod string - -
Time datetime - -
AccountingStandard string - -
NoReportData string - -
CalculatedRemoteID string - -

ProfitAndLossReportByMonth

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/profitandloss

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Customer string - -
ReportName string - -
Currency string - -
Department string - -
DateMacro string - -
ReportBasis string - -
Item string - -
Vendor string - -
Class string - -
SummarizeColumnsBy string - -
StartPeriod string - -
EndPeriod string - -
Time datetime - -
AccountingStandard string - -
NoReportData string - -
CalculatedRemoteID string - -

SalesReceipt

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/salesreceipt

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
LinesSubTotal decimal - -
DiscountLineAmount decimal - -
DiscountLinePercent decimal - -
TxnDate datetime - -
Domain string - -
PrintStatus string - -
PaymentRefNum string - -
TotalAmt decimal - -
ApplyTaxAfterDiscount boolean - -
DocNumber string - -
Sparse boolean - -
Balance decimal - -
SyncToken string - -
EmailStatus string - -
CustomerID string Customer → ID -
PaymentMethodID string - -
ProjectID string - -
DepositToAccountID string Account → ID -
Memo string - -
TotalTax decimal - -

TaxAgency

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/taxagency

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DisplayName string - -
SyncToken string - -
TaxTrackedOnSales boolean - -
TaxTrackedOnPurchases boolean - -
LastFileDate datetime - -
TaxRegistrationNumber string - -
TaxAgencyConfig string - -

TaxCode

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/taxcode

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Description string - -
Domain string - -
SyncToken string - -
TaxGroup boolean - -
Taxable boolean - -
Active boolean - -

TaxRate

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/taxrate

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Domain string - -
SyncToken string - -
SpecialTaxType string - -
DisplayType string - -
TaxAgencyID string TaxAgency → ID -
Active boolean - -

Term

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/term

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Domain string - -
SyncToken string - -
Type string - -
DiscountPercent decimal - -
DiscountDays int - -
Active boolean - -

TimeActivity

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/timeactivity

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
TxnDate datetime - -
EndTime datetime - -
StartTime datetime - -
NameOf string - -
Domain string - -
ItemRef string Item → ID -
ProjectRef string - -
CustomerRef string Customer → ID -
EmployeeRef string Employee → ID -
VendorRef string Vendor → ID -
ClassRef string Class → ID -
DepartmentRef string Department → ID -
PayrollItemRef string - -
Minutes decimal - -
Hours decimal - -
HourlyRate decimal - -
BreakMinutes decimal - -
CostRate decimal - -
BillableStatus string - -
Taxable boolean - -
TimeChargeID string - -

Vendor

Documentation: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/vendor

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Title string - -
GivenName string - -
MiddleName string - -
Suffix string - -
FamilyName string - -
PrimaryEmailAddressValue string - -
DisplayName string - -
OtherContactInfoType string - -
OtherContactInfoNumber string - -
TermID string - -
T4AEligible boolean - -
FaxNumber string - -
BusinessNumber string - -
CurrencyCode string - -
HasTPAR boolean - -
TaxReportingBasis string - -
MobileNumber string - -
AlternatePhoneNumber string - -
Vendor1099 boolean - -
CostRate decimal - -
BillRate decimal - -
WebAddrURI string - -
BillAddrPostalCode string - -
BillAddrCity string - -
BillAddrCountry string - -
BillAddrCountrySubDivisionCode string - -
BillAddrLine1 string - -
BillAddrLine2 string - -
BillAddrLine3 string - -
T5018Eligible boolean - -
Active boolean - -

BillAccountLine

Column Type Relates to Notes
RemoteID string - -
BillRemoteID string Bill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
BillID string Bill → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
TaxInclusiveAmt decimal - -
TaxAmount decimal - -
BillableStatus string - -
CustomerID string Customer → ID -
AccountID string Account → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
ProjectID string - -
DetailType string - -

BillItemLine

Column Type Relates to Notes
RemoteID string - -
BillRemoteID string Bill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
BillID string Bill → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
UnitPrice decimal - -
TaxInclusiveAmt decimal - -
Qty decimal - -
PriceLevelID string - -
BillableStatus string - -
CustomerID string Customer → ID -
ItemID string Item → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
LineNum int - -
DetailType string - -

BillPaymentLine

Column Type Relates to Notes
RemoteID string - -
BillPaymentRemoteID string BillPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PaymentID string BillPayment → ID -
LineNumber int - -
Amount decimal - -
BillID string Bill → ID -
VendorCreditID string - -
JournalEntryID string JournalEntry → ID -

CreditMemoSalesItemLine

Column Type Relates to Notes
RemoteID string - -
CreditMemoRemoteID string CreditMemo → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
CreditMemoID string CreditMemo → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
UnitPrice decimal - -
TaxInclusiveAmt decimal - -
Qty decimal - -
BillableStatus string - -
PriceLevelID string - -
CustomerID string Customer → ID -
ItemID string Item → ID -
ItemAccountID string Account → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
LineNum int - -
DetailType string - -

DepositLinkedTxnLine

Column Type Relates to Notes
RemoteID string - -
DepositRemoteID string Deposit → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Increment int - -
DepositID string Deposit → ID -
Amount decimal - -
LinkedTxnTxnType string - -
LinkedTxnTxnID string - -
LinkedTxnTxnLineID string - -
TxnType string - -
CheckNum string - -
TaxApplicableOn string - -
CustomerID string Customer → ID -
AccountID string Account → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
PaymentMethodID string - -

EstimateLine

Column Type Relates to Notes
RemoteID string - -
EstimateRemoteID string Estimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
EstimateID string Estimate → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
UnitPrice decimal - -
TaxInclusiveAmt decimal - -
Qty decimal - -
BillableStatus string - -
PriceLevelID string - -
CustomerID string Customer → ID -
ItemID string Item → ID -
ItemAccountID string Account → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
LineNum int - -
DetailType string - -

EstimateDescriptionLine

Column Type Relates to Notes
RemoteID string - -
EstimateRemoteID string Estimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
EstimateID string Estimate → ID -
LineNum int - -
DetailType string - -

ExpenseAccountLine

Column Type Relates to Notes
RemoteID string - -
ExpenseRemoteID string Expense → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
ExpenseID string Expense → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
TaxInclusiveAmt decimal - -
TaxAmount decimal - -
BillableStatus string - -
CustomerID string Customer → ID -
AccountID string Account → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
ProjectID string - -
DetailType string - -

ExpenseItemLine

Column Type Relates to Notes
RemoteID string - -
ExpenseRemoteID string Expense → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
ExpenseID string Expense → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
UnitPrice decimal - -
TaxInclusiveAmt decimal - -
Qty decimal - -
PriceLevelID string - -
BillableStatus string - -
CustomerID string Customer → ID -
ItemID string Item → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
LineNum int - -
DetailType string - -

InvoiceDescriptionLine

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
InvoiceID string Invoice → ID -
LineNum int - -
DetailType string - -

InvoiceLine

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
InvoiceID string Invoice → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
UnitPrice decimal - -
TaxInclusiveAmt decimal - -
Qty decimal - -
BillableStatus string - -
PriceLevelID string - -
CustomerID string Customer → ID -
ItemID string Item → ID -
ItemAccountID string Account → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
LineNum int - -
DetailType string - -

JournalEntryLine

Column Type Relates to Notes
RemoteID string - -
JournalEntryRemoteID string JournalEntry → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 20 Jul 2024 Line IDs start at zero
Description string - -
DetailType string - -
Amount decimal - -
ExchangeRate decimal - -
ProjectID string - -
AccoundID string Account → RemoteID -
DetailPostingType string - -
DetailEntityType string - -
DetailEntityID string - -
DetailEntityName string - -

PaymentLine

Column Type Relates to Notes
RemoteID string - -
PaymentRemoteID string Payment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PaymentID string Payment → ID -
LineNumber int - -
Amount decimal - -
ExpenseID string Expense → ID -
InvoiceID string Invoice → ID -
CreditMemoID string CreditMemo → ID -

PreferencesCustomField

Column Type Relates to Notes
RemoteID string - -
PreferencesRemoteID string Preferences → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
PreferencesID string Preferences → ID -
Type string - -
BooleanValue boolean - -
StringValue string - -

PurchaseOrderAccountLine

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
PurchaseOrderID string PurchaseOrder → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
TaxInclusiveAmt decimal - -
TaxAmount decimal - -
BillableStatus string - -
CustomerID string Customer → ID -
AccountID string Account → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
ProjectID string - -
DetailType string - -

PurchaseOrderItemLine

Column Type Relates to Notes
RemoteID string - -
PurchaseOrderRemoteID string PurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
PurchaseOrderID string PurchaseOrder → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
UnitPrice decimal - -
TaxInclusiveAmt decimal - -
Qty decimal - -
PriceLevelID string - -
BillableStatus string - -
CustomerID string Customer → ID -
ItemID string Item → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
LineNum int - -
DetailType string - -

BalanceSheetReportByFiscalYearRow

Column Type Relates to Notes
RemoteID string - -
BalanceSheetReportByFiscalYearRemoteID string BalanceSheetReportByFiscalYear → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReportRemoteID string BalanceSheetReportByFiscalYear → RemoteID -
ParentRowNumber int - -
ReportNestingLevel int - -
RowNumber int - -
Type string - -
Group string - -

BalanceSheetReportByFiscalYearColumn

Column Type Relates to Notes
RemoteID string - -
BalanceSheetReportByFiscalYearRemoteID string BalanceSheetReportByFiscalYear → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ColumnNumber int - -
ColType string - -
ColTitle string - -

BalanceSheetReportByMonthRow

Column Type Relates to Notes
RemoteID string - -
BalanceSheetReportByMonthRemoteID string BalanceSheetReportByMonth → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReportRemoteID string BalanceSheetReportByMonth → RemoteID -
ParentRowNumber int - -
ReportNestingLevel int - -
RowNumber int - -
Type string - -
Group string - -

BalanceSheetReportByMonthColumn

Column Type Relates to Notes
RemoteID string - -
BalanceSheetReportByMonthRemoteID string BalanceSheetReportByMonth → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ColumnNumber int - -
ColType string - -
ColTitle string - -

ProfitAndLossReportByFiscalYearRow

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByFiscalYearRemoteID string ProfitAndLossReportByFiscalYear → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReportRemoteID string ProfitAndLossReportByFiscalYear → RemoteID -
ParentRowNumber int - -
ReportNestingLevel int - -
RowNumber int - -
Type string - -
Group string - -

ProfitAndLossReportByFiscalYearColumn

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByFiscalYearRemoteID string ProfitAndLossReportByFiscalYear → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ColumnNumber int - -
ColType string - -
ColTitle string - -

ProfitAndLossReportByMonthRow

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByMonthRemoteID string ProfitAndLossReportByMonth → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ReportRemoteID string ProfitAndLossReportByMonth → RemoteID -
ParentRowNumber int - -
ReportNestingLevel int - -
RowNumber int - -
Type string - -
Group string - -

ProfitAndLossReportByMonthColumn

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByMonthRemoteID string ProfitAndLossReportByMonth → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ColumnNumber int - -
ColType string - -
ColTitle string - -

SalesReceiptLine

Column Type Relates to Notes
RemoteID string - -
SalesReceiptRemoteID string SalesReceipt → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string -
  • 15 Mar 2024 Ids are not globally unique. Instead, they are unique only within their parent item (e.g. 1, 2, 3)
Description string - -
SalesReceiptID string SalesReceipt → ID -
MarkupInfoPriceLevelID string - -
MarkupInfoPercent decimal - -
UnitPrice decimal - -
TaxInclusiveAmt decimal - -
Qty decimal - -
BillableStatus string - -
PriceLevelID string - -
CustomerID string Customer → ID -
ItemID string Item → ID -
ItemAccountID string Account → ID -
ClassID string Class → ID -
TaxCodeID string TaxCode → ID -
Amount decimal - -
LineNum int - -
DetailType string - -

TaxCodeRate

Column Type Relates to Notes
RemoteID string - -
TaxCodeRemoteID string TaxCode → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaxRateID string TaxRate → ID -
TaxRateApplicable string - -
TaxOrder int - -
TaxCodeID string TaxCode → ID -

BalanceSheetReportByFiscalYearRowColumnValue

Column Type Relates to Notes
RemoteID string - -
BalanceSheetReportByFiscalYearRowRemoteID string BalanceSheetReportByFiscalYearRow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
RowRemoteID string BalanceSheetReportByFiscalYearRow → RemoteID -
ColumnNumber int - -
Value string - -
Href string - -

BalanceSheetReportByFiscalYearColumnMetaDataItem

Column Type Relates to Notes
RemoteID string - -
BalanceSheetReportByFiscalYearColumnRemoteID string BalanceSheetReportByFiscalYearColumn → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Iterator int - -
Value string - -

BalanceSheetReportByMonthRowColumnValue

Column Type Relates to Notes
RemoteID string - -
BalanceSheetReportByMonthRowRemoteID string BalanceSheetReportByMonthRow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
RowRemoteID string BalanceSheetReportByMonthRow → RemoteID -
ColumnNumber int - -
Value string - -
Href string - -

BalanceSheetReportByMonthColumnMetaDataItem

Column Type Relates to Notes
RemoteID string - -
BalanceSheetReportByMonthColumnRemoteID string BalanceSheetReportByMonthColumn → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Iterator int - -
Value string - -

ProfitAndLossReportByFiscalYearRowColumnValue

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByFiscalYearRowRemoteID string ProfitAndLossReportByFiscalYearRow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
RowRemoteID string ProfitAndLossReportByFiscalYearRow → RemoteID -
ColumnNumber int - -
Value string - -
Href string - -

ProfitAndLossReportByFiscalYearColumnMetaDataItem

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByFiscalYearColumnRemoteID string ProfitAndLossReportByFiscalYearColumn → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Iterator int - -
Value string - -

ProfitAndLossReportByMonthRowColumnValue

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByMonthRowRemoteID string ProfitAndLossReportByMonthRow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
RowRemoteID string ProfitAndLossReportByMonthRow → RemoteID -
ColumnNumber int - -
Value string - -
Href string - -

ProfitAndLossReportByMonthColumnMetaDataItem

Column Type Relates to Notes
RemoteID string - -
ProfitAndLossReportByMonthColumnRemoteID string ProfitAndLossReportByMonthColumn → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
Iterator int - -
Value string - -

Need more?

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

Connect your own QuickBooks data Querying QuickBooks using regular SQL