Due Date Dimension

Modified on Mon, 27 Jul at 9:07 PM

Calendar Summary

The Due Date Dimension organizes transactions by their QuickBooks due date for aging, payment, and fulfillment analysis.

Calendar Type

Transaction due date

Date Represents

Payment or fulfillment due date

QuickBooks Sources

Nine transaction types

Primary Use

Due-date and aging analysis

Included Data Models

Customers: Sales, Open Sales Orders, Accounts Receivable

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

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

Auditing: Audit Trail

The due date is available in the following QuickBooks transactions:

QuickBooks due date source

The following fields are included in the Due Date Dimension.

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