Data Model Schemas (QB Desktop)

Version 130

Data Model Schemas (QB Desktop)

CLEARIFY® TEAM

Published: 3/5/2012

CLEARIFY® TEAM

Updated: 12/24/2022

0
30413

0 (0votes)

QQube™ Schemas for QuickBooks Desktop

QQube Logo

QQube contains 36 QuickBooks Data Models and over 7,000 fields - including over 5,000 DAX Formulas for Power Pivot and Power BI - organized according to logical business operations and engineered according to standard data warehousing principles: one FACT table, and multiple DIMENSION tables.

QQube eliminates the need to deal with tables, relationships, reverse engineering, or connection strings. Yet there is total flexibility for database experts or developers.

Advanced users, please refer to this document for using DSN's to connecting externally to the QQube data structures.

QUICKBOOKS SUBJECTS	DATA MODEL
CUSTOMERS AND RECEIVABLES	Sales Open Sales Orders Accounts Receivable

JOBS, TIME, AND MILEAGE	Job Cost Details Time Tracking Vehicle Mileage Profit and Loss by Job (Flexible Period) Profit and Loss by Job by Class (Flexible Period)
INVENTORY	Inventory Management Bill of Materials (BOM)
VENDORS AND PAYABLES	Purchases Open Purchase Orders Accounts Payable
PAYROLL AND HUMAN RESOURCES	Payroll

FINANCIAL STATEMENTS	Standard Monthly Period (36 Periods) Balance Sheet Profit and Loss Statement of Cash Flows Advanced Monthly Period (36 Periods) Profit and Loss Act/Budg/Forecast Flexible Custom Period Balance Sheet Profit and Loss
FINANCIAL STATEMENTS BY CLASS	Standard Monthly Period (36 Periods) Balance Sheet by Class Profit and Loss by Class Statement of Cash Flows by Class Advanced Monthly Period (36 Periods) Profit and Loss by Class Act/Budg/Forecast Flexible Custom Period Balance Sheet Profit and Loss
FINANCIALS FOR 52/53 TAX YEAR	52/53 Periods Profit/Loss 52/53 Periods Profit/Loss by Class
GENERAL LEDGER AND ACCOUNTANT	Trial Balance (All Dates) Trial Balance (Current) Trial Balance Activity Trial Balance Activity by Class General Ledger Detail Profit and Loss Detail Cash Position Fixed Assets

AUDITING	Audit Trail

Comments (no comments yet)

Add a new comment

Data Model Schemas (QB Desktop) | CLEARIFY

Support Guides