QuickBooks Import & Export data | QuickBooks API Integration
These relationships link a parent table to one or more child tables. They can apply to both list and transaction tables. The format for these relationships is:Parent.ListID -> Child.PARENT_IDKEY for list tablesParent.TxnID -> Child.PARENT_IDKEY for transaction tables
These relationships link list entries to other list or transaction tables. The format these links use is:TableNameRef_ListIDTableNameRef_FullName
TableName will indicate the table being referenced. For example, the column named CustomerRef_ListID refers to the ListID field in the customer table.For related tables that do not contain a FullName column, the Ref_FullName column will refer to the Name column in the target table.
Adding RelationshipsRelationships defined within the database schema do not support referential integrity constraints. You should only define the relationships to be used within your queries.
Powered by BetterDocs