Reference - Table Mapping

Table Mapping Reference

FM Starting Point fmQBO QuickBooks Online
ACC_Accounts - Customers
INV_Invoices 
(and lines)
- Invoices
PRO_Products - Items
- Payments (and related tables) Payments
- PaymentMethod PaymentMethod
- Preferences Preference
- CompanyInfo Company Info
- Preferences Preferences
- Term Term
- TaxRate TaxRate
- Account Account
- TaxCode TaxCode
*FMSP allows invoices to be associated with both an Account and a Contact. QBO associates Invoices with Customers.  
This integration will connect the QBO ‘Customer' to a corresponding FMSP ‘Account’ the FMSP primary contact.  


Still need help? Contact Us Contact Us