Document Attributes Dimension

Modified on Tue, 28 Jul at 2:28 AM

Document Attributes Summary

The QQube Document Attributes Dimension contains transaction-level properties that apply to an entire QuickBooks document. The available fields vary because different transaction types store different header information.

Dimension Type

QuickBooks document dimension

QuickBooks Source

Header information stored on QuickBooks transactions

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

Document attributes come from information stored at the transaction header level in QuickBooks. They include document identification, status, currency, terms, shipping, memo, custom-field, and other properties that apply to the complete transaction rather than an individual line.

Source Example

QuickBooks transaction document attributes source example

Data Model Variations

Most data models call this dimension Document Attributes. Two data models use names specific to their activity:

Time Tracking: Date Entry Attributes
Vehicle Mileage: Odometer Attributes

Fields with Limited Availability

Audit Trail change fields

Only available in Audit Trail:

Document Change Count
Document Change Sequence Number
Document Change Status
Document Data Entry User
Document Entered/TimeModified
Document Is Deleted
Document Is Voided
Document Total Changes

Aging fields

Only available in Accounts Receivable, Accounts Payable, and Cash Position:

Aging Interval Days
Document Days Aged Past Due Date
Document Days Aged Past Txn Date

Time Tracking fields

Only available in Time Tracking:

Number
Date-Time Created
Date-Time Modified

Vehicle Mileage fields

Only available in Vehicle Mileage:

Odometer Reading Start
Odometer Reading End

Open-order timing fields

Open Sales Orders: Document Ship Days Past Transaction Date
Open Purchase Orders: Document Expected Days Past Transaction Date

Model-specific status fields

Job Cost Details: Document Current Estimate Status
Payroll: Document Posting Status
Sales: Document Sales Channel Name
Inventory: Document Category, Document Current Posting Status, Document Current SO Status, and Document Forecast Type

Model-specific custom fields

Purchases and Open Purchase Orders: Document Vendor Custom Fields 01 through 12
Inventory and Job Cost Details: Document Vendor Custom Fields 13 through 24
General Ledger Detail: Document Entity Custom Fields 01 through 12
Profit and Loss Detail: Entity Name Custom Fields 01 through 12

Available Fields

The following consolidated list shows the customer-facing document attribute fields used across the included data models. Each data model contains only the fields applicable to its QuickBooks transactions.

Display Order	Field Name
1	Document Change Count
2	Document Change Sequence Number
3	Document Change Status
4	Document Data Entry User
5	Document Is Deleted
6	Document Is Voided
7	Document Payment Method
8	Document PO Number
9	Document Posting Type
10	Document Print Status
11	Document Reference Number
12	Document Sales Tax Code
13	Document Ship Method
14	Document Terms
15	Document Total Changes
16	Document Transaction Number
17	Document Type
18	Document Entered/TimeModified
19	Aging Interval Days
20	Document Amounts Include Tax (CAN)
21	Document Currency Code
22	Document Customer Message
23	Document Days Aged Past Due Date
24	Document Days Aged Past Txn Date
25	Document FOB
26	Document is A/R or A/P
27	Document Is Finance Charge
28	Document Memo
29	Document Other Field
30	Document Sales Tax Amount
31	Document Sales Tax Percentage
32	Document Suggested/Available Discount Amount
33	Document Template Name
34	Document Total Amount
35	Document Total Applied Amount
36	Document Total Open Amount
37	Document Customer:Job Custom Field 01
38	Document Customer:Job Custom Field 02
39	Document Customer:Job Custom Field 03
40	Document Customer:Job Custom Field 04
41	Document Customer:Job Custom Field 05
42	Document Customer:Job Custom Field 06
43	Document Customer:Job Custom Field 07
44	Document Customer:Job Custom Field 08
45	Document Customer:Job Custom Field 09
46	Document Customer:Job Custom Field 10
47	Document Customer:Job Custom Field 11
48	Document Customer:Job Custom Field 12
49	Document Current Posting State
50	Document Entry Type
51	Entity Name Custom Field 01
52	Entity Name Custom Field 02
53	Entity Name Custom Field 03
54	Entity Name Custom Field 04
55	Entity Name Custom Field 05
56	Entity Name Custom Field 06
57	Entity Name Custom Field 07
58	Entity Name Custom Field 08
59	Entity Name Custom Field 09
60	Entity Name Custom Field 10
61	Entity Name Custom Field 11
62	Entity Name Custom Field 12
63	Document Current Paid/Open Status
64	Document Entity Custom Field 01
65	Document Entity Custom Field 02
66	Document Entity Custom Field 03
67	Document Entity Custom Field 04
68	Document Entity Custom Field 05
69	Document Entity Custom Field 06
70	Document Entity Custom Field 07
71	Document Entity Custom Field 08
72	Document Entity Custom Field 09
73	Document Entity Custom Field 10
74	Document Entity Custom Field 11
75	Document Entity Custom Field 12
76	Document Actual Discount Amount
77	Document Category
78	Document Current PO Status
79	Document Current Posting Status
80	Document Current SO Status
81	Document Days Paid Past Terms
82	Document Days to Pay
83	Document Forecast Type
84	Document Other1 Field
85	Document Other2 Field
86	Document Vendor Custom Field 13
87	Document Vendor Custom Field 14
88	Document Vendor Custom Field 15
89	Document Vendor Custom Field 16
90	Document Vendor Custom Field 17
91	Document Vendor Custom Field 18
92	Document Vendor Custom Field 19
93	Document Vendor Custom Field 20
94	Document Vendor Custom Field 21
95	Document Vendor Custom Field 22
96	Document Vendor Custom Field 23
97	Document Vendor Custom Field 24
98	Document Applied Credit Memo Amount
99	Document Credits Amount
100	Document Current Estimate Status
101	Document Discount Items Amount
102	Document Total Applied Ampount
103	Document Expected Days Past Transaction Date
104	Document Vendor Terms
105	Document Vendor Custom Field 01
106	Document Vendor Custom Field 02
107	Document Vendor Custom Field 03
108	Document Vendor Custom Field 04
109	Document Vendor Custom Field 05
110	Document Vendor Custom Field 06
111	Document Vendor Custom Field 07
112	Document Vendor Custom Field 08
113	Document Vendor Custom Field 09
114	Document Vendor Custom Field 10
115	Document Vendor Custom Field 11
116	Document Vendor Custom Field 12
117	Document Class Name
118	Document Current Closed/Open Status
119	Document Customer is Taxable
120	Document Customer Terms
121	Document Ship Days Past Transaction Date
122	Document Subtotal Amount
123	Document Is To Be Emailed
124	Document Is To Be Printed
125	Document Posting Status
126	Document Sales Channel Name
127	Number
128	Date-Time Created
129	Date-Time Modified
130	Odometer Reading End
131	Odometer Reading Start