QuickBooks Import & Export data | QuickBooks API Integration
List TablesListID is the primary key. The FullName (where used) or Name field is also a unique key for these tables.
Transaction tablesTxnID is the primary key.
Child TablesChild tables used in transactions contain a field named TxnLineID which is a primary key. Child tables without this field do not contain a primary key.
Child <- Parent table relationship
Child tables are linked to their parent tables with PARENT_IDKEY containing Parent (ListID or TxnID), depending on if its parent is a list or transaction table.
LetSync Desktop system tables
Powered by BetterDocs