QuickBooks Data Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
Last Updated:17/3/2017
5
Title:
Expected QuickBooks Data Model
6
Blendo (Apirise Inc.)
https://www.blendo.co/knowledge-category/integrations/
7
8
ResourceTable NameDescription
9
AccountsaccountsAn Account object is a component of a Chart Of Accounts, and is part of a ledger. It is used to record a total monetary amount allocated against a specific use
10
BillbillA Bill object is an AP transaction representing a request-for-payment from a third party for goods/services rendered, received, or both.
11
Bill Linesbill_linesIndividual line items of a transaction
12
Billing Paymentbilling_paymentA BillPayment object represents the payment transaction for a bill that the business owner receives from a vendor for goods or services purchased from the vendor
13
Credit Memocredit_memoThe CreditMemo object is a financial transaction representing a refund or credit of payment or part of a payment for goods or services that have been sold.
14
Credit Memo Linescredit_memo_linesIndividual line items of a transaction.
15
DepositdepositA deposit object is a transaction that records one or more deposits of the following types: A customer payment, originally held in the Undeposited Funds account, into the Asset Account specified by the Deposit.DepositToAccountRef attribute. The Deposit.line.LinkedTxn element is used in this case to hold deposit information. A new, direct deposit specified by Deposit.Line.DepositLineDetail line detail.
16
Deposit Linesdeposit_linesIndividual line items of a transaction.
17
EmployeeemployeeAn Employee object represents a person working for the company.
18
EstimateestimateThe Estimate represents a proposal for a financial transaction from a business to a customer for goods or services proposed to be sold, including proposed pricing.
19
Estimate Linesestimate_linesIndividual line items of a transaction.
20
InvoiceinvoiceAn Invoice represents a sales form where the customer pays for a product or service later.
21
Invoice Linesinvoice_linesIndividual line items of a transaction.
22
ItemitemAn item is a thing that your company buys, sells, or re-sells, such as products and services. An item is shown as a line on an invoice or other sales form
23
Journal Codejournal_codeApplicable only for France-locale companies (FR locale). Journal Code is a compliance requirement for a France-locale company. A journal code is assigned to each transaction and it depends on whether it is an income or an expense
24
Journal Entryjournal_entryJournalEntry is a transaction in which: There are at least one pair of lines, a debit and a credit, called distribution lines. Each distribution line has an account from the Chart of Accounts. Query the Account resource for a listing of the Chart of Accounts. The total of the debit column equals the total of the credit column. When you record a transaction with a JournalEntry object, the QuickBooks Online UI labels the transaction as JRNL in the register and as General Journal on reports that list transactions.
25
Journal Entry Linesjournal_entry_linesIndividual line items of a transaction.
26
PaymentpaymentA Payment object records a payment in QuickBooks. The payment can be applied for a particular customer against multiple Invoices and Credit Memos.
27
Payment Linespayment_linesIndividual line items of a transaction.
28
PurchasepurchaseA Purchase object represents an expense, such as a purchase made from a vendor
29
Purchase Linespurchase_linesIndividual line items of a transaction.
30
Purchase Orderpurchase_orderThe PurchaseOrder object is a non-posting transaction representing a request to purchase goods or services from a third party.
31
Purchase Order Linespurchase_order_linesThe PurchaseOrder object is a non-posting transaction representing a request to purchase goods or services from a third party.
32
Sales Receiptsales_receiptA SalesReceipt object represents the sales receipt that is given to a customer. A sales receipt is similar to an invoice
33
Sales Receipt Linessales_receipt_linesA Sales Receipt Lines object represents the sales receipt lines that are shown to the customer.
34
Tax Agencytax_agencyA TaxAgency object is associated with a tax rate and identifies the agency to which that tax rate applies, that is, the entity that collects those taxes.
35
Tax Codetax_codeA TaxCode object is used to track the taxable or non-taxable status of products, services, and customers. You can assign a sales tax code to each of your products, services, and customers based on their taxable or non-taxable status.
36
Tax Ratetax_rateA TaxRate object represents rate applied to calculate tax liability. Use the TaxService entity to create a taxrate. See Global tax model for more information about using TaxRate objects and the tax model in general.
37
TermtermA Term object represents the terms under which a sale is made, typically expressed in the form of days due after the goods are received. Optionally, a discount of the total amount may be applied if payment is made within a stipulated time.
38
Time Activitytime_activityThe TimeActivity object represents a record of time worked by a vendor or employee.
39
VendorvendorThe Vendor object represents the seller from whom your company purchases any service or product.
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu