View Categories

Schema Differences

  • Al the header tables are called the same.
  • LetSync Desktop has a history tables that uses to run the Refresh tasks.
  • All the sub-tables that end on “Detail”, on LetSync Desktop end “Ret”
  • txnitemlinedetail -> ItemLineRet
  • txnexpenselinedetail -> ExpenseLineRet
  • IDKEY -> PARENT_IDKEY
  • To update to QuickBooks column: Status -> LetSync Desktop calls it: Operation (add, update, refresh, void, and delete values are still the same). When creating a task that updates QuickBooks and refreshes your database. You have to pick the “Update and Refresh” operation on the “4 – Select Task Operation”