Calendar Summary
The Job Projected End Date Dimension expands the planned completion date stored with the QuickBooks job record. It supports analysis of scheduled job completion by day, week, month, quarter, or year.
Calendar Type Job lifecycle date | Date Represents Projected 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 projected end date is stored on the Customer:Job record in QuickBooks.
Available Fields
The following fields are included in the Job Projected End Date Dimension.
| Display Order | Field Name |
|---|---|
| 1 | Job Proj End Date |
| 2 | Job Proj End Date Calendar Month Number |
| 3 | Job Proj End Date Calendar Year Number |
| 4 | Job Proj End Date Day Holiday Name |
| 5 | Job Proj End Date Day is Holiday |
| 6 | Job Proj End Date Day is Weekend Day |
| 7 | Job Proj End Date Day is Working Day |
| 8 | Job Proj End Date Day Number in Month |
| 9 | Job Proj End Date Day Number in Quarter |
| 10 | Job Proj End Date Day Number in Week |
| 11 | Job Proj End Date Day Number in Year |
| 12 | Job Proj End Date Day of Week |
| 13 | Job Proj End Date Day of Week Abbr |
| 14 | Job Proj End Date Formal Date |
| 15 | Job Proj End Date Month Abbr |
| 16 | Job Proj End Date Month Begin Date |
| 17 | Job Proj End Date Month End Date |
| 18 | Job Proj End Date Month Name |
| 19 | Job Proj End Date Month Number |
| 20 | Job Proj End Date Month Number in Quarter |
| 21 | Job Proj End Date Month-Year |
| 22 | Job Proj End Date Quarter (FQ) |
| 23 | Job Proj End Date Quarter (Q) |
| 24 | Job Proj End Date Quarter Begin Date |
| 25 | Job Proj End Date Quarter End Date |
| 26 | Job Proj End Date Quarter Number |
| 27 | Job Proj End Date Quarter-Year (FQ) |
| 28 | Job Proj End Date Quarter-Year (Q) |
| 29 | Job Proj End Date Week Begin Date |
| 30 | Job Proj End Date Week End Date |
| 31 | Job Proj End Date Year (FY) |
| 32 | Job Proj End Date Year (Y) |
| 33 | Job Proj End Date Year Begin Date |
| 34 | Job Proj End Date Year End Date |
| 35 | Job Proj End Date Year Number |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article