Service Item Dimension

Modified on Tue, 28 Jul at 12:05 AM

Service Item Summary

The QQube Service Item Dimension contains the service items from the QuickBooks Item List. It is used where the underlying QuickBooks transactions support service items rather than the complete range of item types.

Dimension Type

QuickBooks list dimension

Service Item Represents

A service item in the QuickBooks company file

QuickBooks Source

Service items in the Item List

Dimension Scope

Service items only

Included Data Models

Operations: Time Tracking, Vehicle Mileage, Payroll

QuickBooks Source

Service item information comes from service-type records in the QuickBooks Item List.

QuickBooks Time Tracking, Vehicle Mileage, and Payroll transactions use service items. QQube therefore provides this specialized Service Item Dimension for those analytics instead of the broader Item Dimension.

Source Example

QuickBooks Service Item source example

Service-item-only dimension

This dimension contains only service items. Use the Item Dimension in analytics that support additional QuickBooks item types.

Missing or inapplicable service item information appears as (No Service Item).

Available Fields

Display Order	Field Name
1	Item Active
2	Item Level
3	Item Has Children
4	Item Class
5	Item Parent Name
6	Item Full Name
7	Item Name
8	Item Name - Hierarchy Level 1
9	Item Name - Hierarchy Level 2
10	Item Name - Hierarchy Level 3
11	Item Name - Hierarchy Level 4
12	Item Name - Hierarchy Level 5
13	Item Description - Hierarchy Level 1
14	Item Description - Hierarchy Level 2
15	Item Description - Hierarchy Level 3
16	Item Description - Hierarchy Level 4
17	Item Description - Hierarchy Level 5
18	Item Name · Description - Hierarchy Level 1
19	Item Name · Description - Hierarchy Level 2
20	Item Name · Description - Hierarchy Level 3
21	Item Name · Description - Hierarchy Level 4
22	Item Name · Description - Hierarchy Level 5
23	Item Bar Code Value
24	Item UofM
25	Item Sales Description
26	Item Sales Amount
27	Item Sales Percent
28	Item Price Includes Tax (CAN)
29	Item Costs Categorized Separately From Sales
30	Item Preferred Vendor Name
31	Item Purchase Description
32	Item Purchase Cost
33	Item Tax Code
34	Item Purchase Tax Code (CAN)
35	Item Taxable
36	Item Account Full Name
37	Item Account Name
38	Item Account Number
39	Item COGS/Expense Account Full Name
40	Item COGS/Expense Account Name
41	Item COGS/Expense Account Number
42	Item Custom Field 01
43	Item Custom Field 02
44	Item Custom Field 03
45	Item Custom Field 04
46	Item Custom Field 05
47	Item Custom Field 06
48	Item Custom Field 07
49	Item Custom Field 08
50	Item Custom Field 09
51	Item Custom Field 10
52	Item Custom Field 11
53	Item Custom Field 12
54	Item Custom Field 13
55	Item Custom Field 14
56	Item Custom Field 15