List tables contain QuickBooks data entities (customers, employees, other names, and vendors), items, and other QuickBooks list elements.
Transaction tables contain QuickBooks data for transactions such as invoices, bills, check, etc.
Child tables are always related to either a list or transaction table. The table name for child tables always ends with the word “ret”. Examples of child tables include: invoicelineret, and itemgrouplineret.