Skip to content

LetSync

QuickBooks Import & Export data | QuickBooks API Integration

Home
Trial Registration Forms
- LetSync Desktop/Online
Shop – LetSync Desktop
Contact Us
Forum
Help Center
My account
Cart

Release Notes - LetSync Desktop

Release Notes

What is LetSync Desktop?

What is LetSync Desktop?
Watch Demo

Setting up LetSync Online and QuickBooks Online Integration

Connecting QuickBooks Online Company File to LetSync Online
Disconnecting QuickBooks Online Company File from LetSync Online
Reconnecting QuickBooks Online Company File to LetSync Online
Authorization Code
LetSync Online Outbound IP
Users
QuickBooks Online – LetSync Online Data Integration Overview
SQL Server Database Schema Create Statement for QuickBooks Online
MySQL Server Database Schema Create Statement for QuickBooks Online

Getting Started LetSync Desktop

LetSync Desktop set up for new clients
Activate LetSync Desktop License Key
Adding a QuickBooks Desktop Company File
Adding a QuickBooks Online Company File
Adding Databases
Adding Tasks
Running a Task

LetSync Desktop UI Operational Guide

Export QuickBooks Reports to Database
LetSync Desktop UI
Taskbar
Quickbooks Company Files
QuickBooks Company File re-Authorization
Databases
Tasks
Settings
Account
Restart LetSync Desktop
Move License to Another Computer
Quantity of records to Request per Query
Number of Days In Chunk

Log Files LetSync Desktop

Log Files

Email Notification LetSync Desktop

Email Notification

Scheduling task to run automatically

Scheduling task using PowerShell
Scheduling task to run automatically

Database Schema for QuickBooks Desktop

MySQL Server LetSync Desktop Schema Create
SQL Server LetSync Desktop Schema Create
MariaDB Settings for LetSync Desktop
Schema – Indexes
Schema – Relationships
Update to QuickBooks Operations supported by tables
QuickBooks Desktop API Reference
There are five fundamental table types in the LetSync schema. These are:
Primary Keys
Schema – Working with Items
Custom Fields
Schema – Adding Tables and Fields
Schema – Report Tables
SQL Server connection strings
MySQL Connector/Net connection strings
Oracle connection strings

Updating QuickBooks

Overview of Updating QuickBooks

LetSync Desktop Tables schema

QuickBooks Desktop Reporting

Trial Balance Report
Profit and Loss Detail Report
Custom Transaction Detail Report (Payments With Invoices)
Sales by Item Summary Report
Open POs Report
QuickBooks Report Builder

What is LetSync Online?

LetSync Online Outbound IP
What is LetSync Online?

LetSync Online Register

LetSync Online Register

LetSync Online Tables schema

QuickBooks Online Integration

Setting up the QuickBooks Online integration

View Categories

help
Home
LetSync Online Tables schema
ContactInfo

ContactInfo

FIELD NAME	DATA TYPE	QUERYABLE	UPDATEABLE	REQUIRED ON UPDATE	INSERTABLE	REQUIRED ON INSERT
TypeContactValue	string	true
TypeContactInfo	string	true
TypeSpecified	bool	true
SeqNum	int	true
ParentTableType	string	true
PARENT_ID	string	true

What are your Feelings

Share This Article :

Still stuck? How can we help?

How can we help?

Name: *

Email: *

Message: *

Company Currency Company Info

Copyright © 2026 LetSync