Vendor Dimension

Modified on Tue, 28 Jul at 12:30 AM

Vendor Summary

The QQube Vendor Dimension contains vendor records maintained in QuickBooks. It supports purchasing, payables, job-cost, financial, and audit analysis using vendor identity, contact, payment, tax, and custom-field information.

Dimension Type

QuickBooks list dimension

Vendors Represent

Businesses and individuals paid for goods or services

QuickBooks Source

Vendor List

Primary Use

Group or filter transactions and balances by vendor

Included Data Models

Customers: Accounts Receivable

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

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

Auditing: Audit Trail

QuickBooks Source

Vendor information comes from the Vendor List in QuickBooks. Vendor records exist at one level and do not have sublevels.

Source Example

QuickBooks Vendor List source example

Single-level list

Unlike customers and jobs, vendors have no parent-child hierarchy in QuickBooks.

Missing vendors

Missing or inapplicable vendor information appears as (No Vendor).

Available Fields

Display Order	Field Name
1	Vendor Active
2	Vendor Type
3	Vendor Is SalesRep
4	Vendor SalesRep Initial
5	Vendor Class
6	Vendor Name
7	Vendor Name On Check
8	Vendor Company
9	Vendor Salutation
10	Vendor First Name
11	Vendor Middle Name
12	Vendor Last Name
13	Vendor Contact Name
14	Vendor Primary Phone
15	Vendor Alt Phone
16	Vendor Alt Phone 2
17	Vendor Alt Mobile
18	Vendor Work Phone
19	Vendor Fax
20	Vendor Alt Fax
21	Vendor Alt Contact Name
22	Vendor Email
23	Vendor Alt Email 1
24	Vendor Alt Email 2
25	Vendor Email Cc
26	Vendor Alt CcEmail
27	Vendor FaceBook
28	Vendor LinkedIn
29	Vendor Twitter
30	Vendor SkypeID
31	Vendor URL 1
32	Vendor URL 2
33	Vendor URL 3
34	Vendor URL 4
35	Vendor Other 1
36	Vendor Other 2
37	Vendor Other 3
38	Vendor Website
39	Vendor Address Line 1
40	Vendor Address Line 2
41	Vendor Address Line 3
42	Vendor Address Line 4
43	Vendor Address Line 5
44	Vendor Address City
45	Vendor Address State
46	Vendor Address Postal Code
47	Vendor Address Country
48	Vendor Address Note
49	Vendor Account Number
50	Vendor Terms
51	Vendor Credit Limit
52	Vendor Billing Rate Name
53	Vendor is 1099
54	Vendor 1099 Number
55	Vendor Sales Tax Code (CAN)
56	Vendor Sales Tax Country (CAN)
57	Vendor is a Sales Tax Agency (CAN)
58	Vendor Tax Registration Number (CAN)
59	Vendor Tax Agency Tax Return (CAN)
60	Vendor Tax Agency Reporting Period (CAN)
61	Vendor Tax Agency Tracks Tax Separately on Sales (CAN)
62	Vendor Tax Agency Account for Separately Tracking Tax on Sales (CAN)
63	Vendor Tax Agency Tracks Tax Separately on Purchases (CAN)
64	Vendor Tax Agency Account for Separately Tracking Tax on Purchases (CAN)
65	Vendor Agency Taxes Are Calculated on Other Taxes (CAN)
66	Vendor Notes
67	Vendor Custom Field 01
68	Vendor Custom Field 02
69	Vendor Custom Field 03
70	Vendor Custom Field 04
71	Vendor Custom Field 05
72	Vendor Custom Field 06
73	Vendor Custom Field 07
74	Vendor Custom Field 08
75	Vendor Custom Field 09
76	Vendor Custom Field 10
77	Vendor Custom Field 11
78	Vendor Custom Field 12