Job Dimension

Modified on Mon, 27 Jul at 11:46 PM

Job Summary

The QQube Job Dimension contains QuickBooks sub:jobs and top-level customers that also function as jobs because they have no sub:jobs.

Dimension Type

QuickBooks list dimension

Job Represents

A QuickBooks sub:job or a customer that also functions as a job

QuickBooks Source

Customer List

Primary Use

Job, project, and job-cost reporting

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

Job information comes from the Customer List in QuickBooks.

This dimension includes sub:jobs and top-level customers that have no sub:jobs and therefore still function as jobs.

Source Example

QuickBooks Customer List source for the Job Dimension

Customers and jobs

A customer with no sub:jobs can function as both the customer and the job. After a job is created beneath that customer, the top-level record remains the customer and the child record is treated as the job.

More information about Customers versus Jobs

Missing or inapplicable job information appears as (No Job).

Available Fields

Display Order	Field Name
1	Job Active
2	Job Type
3	Job Customer Type
4	Job SalesRep Initial
5	Job Has Children
6	Job Class
7	Customer:Job Full Name
8	Job Name
9	Job Name - Hierarchy Level 1
10	Job Name - Hierarchy Level 2
11	Job Name - Hierarchy Level 3
12	Job Name - Hierarchy Level 4
13	Job Name - Hierarchy Level 5
14	Job Company Name
15	Job Salutation
16	Job First Name
17	Job Middle Name
18	Job Last Name
19	Job Contact Name
20	Job Alt Contact Name
21	Job Primary Phone
22	Job Alt Phone
23	Job Alt Phone 2
24	Job Work Phone
25	Job Alt Mobile
26	Job Fax
27	Job Alt Fax
28	Job Email
29	Job Alt Email 1
30	Job Alt Email 2
31	Job Email Cc
32	Job Alt CcEmail
33	Job FaceBook
34	Job LinkedIn
35	Job Twitter
36	Job SkypeID
37	Job URL 1
38	Job URL 2
39	Job URL 3
40	Job URL 4
41	Job Other 1
42	Job Other 2
43	Job Other 3
44	Job Website
45	Job Billing Address Line 1
46	Job Billing Address Line 2
47	Job Billing Address Line 3
48	Job Billing Address Line 4
49	Job Billing Address Line 5
50	Job Billing Address City
51	Job Billing Address State
52	Job Billing Address Postal Code
53	Job Billing Address Country
54	Job Billing Address Note
55	Job Account Number
56	Job Credit Limit
57	Job Preferred Payment Method
58	Job Price Level
59	Job Status
60	Job Has Active Estimates
61	Job Start Date
62	Job Projected End Date
63	Job End Date
64	Job Description
65	Job Notes
66	Job Custom Field 01
67	Job Custom Field 02
68	Job Custom Field 03
69	Job Custom Field 04
70	Job Custom Field 05
71	Job Custom Field 06
72	Job Custom Field 07
73	Job Custom Field 08
74	Job Custom Field 09
75	Job Custom Field 10
76	Job Custom Field 11
77	Job Custom Field 12