2024 is the year of the connector - vote here

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 - -

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 - -
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 - -
Source string - -
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 - -
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 - -

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 - -

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 - -

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 - -

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 - -

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 - -

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 - -
Source 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 - -

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 - -

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 - -

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 - -

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 - -

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 - -

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 -

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