Page Comparison

...

Excerpt

This page explains which are the Push and Pull methods supported by Quickbooks connector. Push are the methods where interworks.cloud platform sends information to Quickbooks and pull are the methods where we get information from Quickbooks . For each method the data transformation schema is explained.

	Push			Pull
	Create	Update	Delete	Create	Update
Account
Contact
Invoices
Orders
Products
Payments

Properties Mappings

...

uiuiuiuiui

rw-ui-expands-macro

rw-expand

title	Account Entity

For BSS Account entities we support both push and pull methods.

Below table presents property mapping between BSS Account entity and Quickbooks Customer entity

Account (BSS entity)

Customer (Qb entity)

Name

GivenName

Phone

Primary Phone

Fax

WebSite

WebAddr

Address

Billing Address

IsTaxable

Taxable

ServerVariables
Tax_Excemption_Reason

TaxExemptionReasonId

Account.CorpEmail

Email

Currency
Currency.Mnemonic
Currency.Name

CurrencyRef
CurrencyRef.value
CurrencyRef.name

Lookup value
Account.Currency.IntegationId

Currency

CreatedAt

MetaData.CreateTime

UpdatedAt

MetaData.LastUpdatedTime

rw-expand

title	Contact Entity

For BSS Contact entities we support only push methods.

Below table presents property mapping between BSS Contact entity and Quickbooks Account entity

Contact (BSS entity)

Account (Qb entity)

FirstName LastName

Name

True or False
Depending on the value of Account.ParentAccount

SubAccount

Account.TypeName

AccountType

Currency
Currency.Mnemonic
Currency.Name

CurrencyRef
CurrencyRef.value
CurrencyRef.name

CreatedAt

MetaData.CreateTime

UpdatedAt

MetaData.LastUpdatedTime

rw-expand

title	Product Entity

For BSS Product entities we support only push method.

Below table presents property mapping between BSS Product entity and Quickbooks Item entity

Product (BSS entity)	Item (Qb entity)
Name	Name
FullDescription	Description
IsActive	DisplayName
ServerVariable Product_Type	Type
ServerVariable TaxableId or NonTaxableId depending on the value of Product.IsTaxable	TaxSchedule
IncomeAccountRef from PreSyncrhonization actions	IncomeAccountRef
ExpenseAccountReffrom PreSyncrhonization actions	ExpenseAccountRef
CreatedAt	MetaData.CreateTime
UpdatedAt	MetaData.LastUpdatedTime

rw-expand

title	Invoice Entity

For BSS Invoice entities we support only push method.

Below table presents property mapping between BSS Invoice entity and Quickbooks Invoice entity

Invoice (BSS entity)

Invoice (Qb entity)

InvoiceDate

TxnDate

DueDate

TotalAmount

TotalAmt

BillingAccount.CorpEmail

BillEmail.Address

BillingAccount.Address

BillingAddress

Balance

InvoiceItems[0..n]
Calculated from invoiceItemTaxes, FinalPrice and Quantity
ServerVariables.Invoice_Detail_Type
Product.IntegrationId
Product.Name
FinalPrice
Quantity

Line[0...n]
Amount
DetailType
SalesItemLineDetail.ItemRef.value
SalesItemLineDetail.ItemRef.name
UnitPrice
Qty

Currency
Currency.Mnemonic
Currency.Name

CurrencyRef
CurrencyRef.value
CurrencyRef.name

CreatedAt

MetaData.CreateTime

UpdatedAt

MetaData.LastUpdatedTime

rw-expand

title	Order Entity

For BSS Order entities we support only push method.

Below table presents property mapping between BSS Order entity and Quickbooks Invoice entity

Invoice (BSS entity)

Order (Qb entity)

Date

TxnDate

Code

DocNumber

OrderItems[0..n]
Product.Fulldescription
Calculated from invoiceItemTaxes, FinalPrice and Quantity
ServerVariables.Order_Detail_Type
Product.IntegrationId
Product.Name
FinalPrice
Quantity

Line[0...n]
Description
Amount
DetailType
ItemBasedExpenseLineDetail.ItemRef.value
SalesItemLineDetail.ItemRef.name
UnitPrice
Qty

-
ServerVariables.AP_Account_ID
ServerVariables.AP_Account_Name

APAccountRef
APAccountRef.value
APAccountRef.name

-
ServerVariables.Vendor_ID
ServerVariables.Vendor_Name

VendorRef
VendorRef.value
VendorRef.name

Currency
Currency.Mnemonic
Currency.Name

CurrencyRef
CurrencyRef.value
CurrencyRef.name

CreatedAt

MetaData.CreateTime

UpdatedAt

MetaData.LastUpdatedTime

rw-expand

title	Payment Entity

For BSS Payments entities we support both push and pull method.

Below table presents property mapping between BSS Payment entity and Quickbooks payment entity

Payment (BSS entity)

Payment (Qb entity)

PaymentDate

TxnDate

ServerVariables.Payment_Status

TxnStatus

Amount

TotalAmt

PaymentInvoices
Amount
Invoice.IntegrationId
"Invoice"

Line[0...n]
Amount
LinkedTxn.TxnId
LinkedTxn.TxnType

Currency
Currency.Mnemonic
Currency.Name

CurrencyRef
CurrencyRef.value
CurrencyRef.name

CreatedAt

MetaData.CreateTime

UpdatedAt

MetaData.LastUpdatedTime

Versions Compared

Old Version 4

New Version Current

Key

Properties Mappings