Open Purchase Orders Data Model

Overview of the QuickBooks Open Purchase Orders Data Model

The Open Purchase Orders data model contains ONLY open purchase orders.

Features

• Over 750 available fields
• 16 Measures including 7 not available in any QuickBooks report
• 54 Additional DAX measures for Power/Pivot and Power BI
• Posting, Non-Posting, Linked Purchase Order Transactions
• Printed and Base U of M Quantities
• Home and Foreign Currencies

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Due Date Expected Date Service 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 Class Company Currency Customer Customer Rep Item Job Job Rep Other Name Payroll Item Sales Rep Ship Method Source Name Template Terms UofM Vendor
	Linked Information:  NONE

Additional DAX Measures for PowerPivot and Power BI