Transaction Date Dimension

Modified on Mon, 27 Jul at 9:43 PM

Calendar Summary

The Transaction Date Dimension is the primary calendar used for most QuickBooks transactions. Vehicle Mileage and Fixed Assets use their own date dimensions.

Calendar Type

Primary transaction calendar

Date Represents

QuickBooks transaction date

QuickBooks Source

Most transaction types

Not Used For

Vehicle Mileage and Fixed Assets

Included Data Models

Customers: Sales, Open Sales Orders, Accounts Receivable

Operations: Purchases, Open Purchase Orders, Accounts Payable, Inventory, Job Cost Details, Time Tracking, Payroll

Finance: General Ledger Detail, Profit and Loss Detail, Cash Position

Auditing: Audit Trail

QuickBooks Source

Transaction Date comes from the primary date recorded on most QuickBooks transactions.

Source Transactions

Most QuickBooks transaction types

Vehicle Mileage and Fixed Assets use their own date dimensions instead of Transaction Date.

Source Example

QuickBooks transaction date source

Estimate Date Separation

QQube separates Estimate Date from Transaction Date so estimates remain visible when job-cost activity is filtered to a specific transaction-date range.

Available Fields

The following fields are included in the Transaction Date Dimension.

Display Order	Field Name
1	Transaction Date
2	Transaction Date Calendar Month Number
3	Transaction Date Calendar Year Number
4	Transaction Date Day Holiday Name
5	Transaction Date Day is Holiday
6	Transaction Date Day is Weekend Day
7	Transaction Date Day is Working Day
8	Transaction Date Day Number in Month
9	Transaction Date Day Number in Quarter
10	Transaction Date Day Number in Week
11	Transaction Date Day Number in Year
12	Transaction Date Day of Week
13	Transaction Date Day of Week Abbr
14	Transaction Date Formal Date
15	Transaction Date Month Abbr
16	Transaction Date Month Begin Date
17	Transaction Date Month End Date
18	Transaction Date Month Name
19	Transaction Date Month Number
20	Transaction Date Month Number in Quarter
21	Transaction Date Month-Year
22	Transaction Date Quarter (FQ)
23	Transaction Date Quarter (Q)
24	Transaction Date Quarter Begin Date
25	Transaction Date Quarter End Date
26	Transaction Date Quarter Number
27	Transaction Date Quarter-Year (FQ)
28	Transaction Date Quarter-Year (Q)
29	Transaction Date Week Begin Date
30	Transaction Date Week End Date
31	Transaction Date Year (FY)
32	Transaction Date Year (Y)
33	Transaction Date Year Begin Date
34	Transaction Date Year End Date
35	Transaction Date Year Number