Job End Date Dimension

Modified on Mon, 27 Jul at 9:24 PM

Calendar Summary

The Job End Date Dimension expands the completion date stored with the QuickBooks job record. It supports analysis of completed jobs by day, week, month, quarter, or year.

Calendar Type

Job lifecycle date

Date Represents

Actual job completion date

QuickBooks Source

Customer:Job record

Model Relationship

Attached to Job Dimension

Included Data Models

Customers: Sales, Open Sales Orders, Accounts Receivable

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

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

Auditing: Audit Trail

QuickBooks Source

The job end date is stored on the Customer:Job record in QuickBooks.

QuickBooks Customer:Job end date source

Available Fields

The following fields are included in the Job End Date Dimension.

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