Purchases Data Model

Overview of the QuickBooks Purchases Data Model

The Purchases data model is used most for pricing/cost analysis

Features

• Over 1000 available fields
• 22 Measures including 10 not available in any QuickBooks report
• 208 Additional DAX measures for Power/Pivot and Power BI
• Items only
• Posting, Non-Posting, Linked Transactions
• Open and Paid Status
• Printed and Base U of M Quantities
• Home and Foreign Currencies

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: 52/53 Tax Year Due Date Expected Date Fiscal Year Fully Paid Date Service Date Ship Date Suggested Discount 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 (Purchases) Class Company Currency Customer Customer Rep Employee Item Item Sales Tax Code 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