Open Sales Orders Data Model

Overview of the QuickBooks Open Sales Orders Data Model

This Data Model is based upon the following Open Sales Orders ONLY.

You have the ability to show the components of assemblies with the Document Line Attribute: "Line is BOM Explosion".

Features

• Over 800 available fields
• 20 Measures including 8 not available in any QuickBooks report
• 57 Additional DAX measures for Power/Pivot and Power BI
• 21 List, Attribute, Geography and Calendar Dimensions with over 800 available fields
• Posting, Non-Posting, Linked Sales Order Transactions
• Toggle to show items in assemblies
• Printed and Base U of M Quantities
• Home and Foreign Currencies
• Out-of-the box metrics using Power BI

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Due Date Ship Date Transaction Date Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  Document Attributes Line Attributes Geography
	List Based Dimensions:  Account Bin Location Class Company Currency Customer Customer Rep Customer Message Customer Sales Tax Code Item Item Sales Tax Code Job Job Rep Sales Rep Sales Tax Item Ship Method Site Template Terms UofM
	Linked Information:  Sales Linked Transactions

Additional DAX Measures for PowerPivot and Power BI