Line Attributes Summary
The QQube Line Attributes Dimension contains properties that apply to individual transaction lines. The available fields vary because different QuickBooks transaction types store different line-level information.
Dimension Type QuickBooks document dimension | QuickBooks Source Detail lines 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
Line attributes come from the detail lines stored on QuickBooks transactions. QQube also derives selected fields, including line amount type, paid or open status, subtotal identification, and BOM explosion identification.
Source Example
Data Model Variations
Most data models call this dimension Line Attributes. Two data models use names specific to their activity:
- Time Tracking: Time Activity Attributes
- Vehicle Mileage: Trip Attributes
Fields with Limited Availability
Line Sequence Number
Only available in Sales, Open Sales Orders, Purchases, Open Purchase Orders, Inventory, and Audit Trail.
Line Serial/Lot Number and Line Serial/Lot Expiration Date
Only available in Sales, Open Sales Orders, Purchases, and Inventory when serial-number or lot-number tracking is enabled through QuickBooks Advanced Inventory.
Available Fields
| Display Order | Field Name |
|---|---|
| 1 | Line Sequence Number |
| 2 | Line Amount Type |
| 3 | Line Item Description |
| 4 | Line Billable Status |
| 5 | Billable Status |
| 6 | Document Notes |
| 7 | Line Is a Subtotal |
| 8 | Line is BOM Explosion |
| 9 | Line Status |
| 10 | Line Paid/Open Status |
| 11 | Line UofM |
| 12 | Line Serial/Lot Number |
| 13 | Line Serial/Lot Expiration Date |
| 14 | Line (Deposit) Check Number |
| 15 | Line (Deposit) Payment Date |
| 16 | Line (Deposit) Payment Method |
| 17 | Line Item Custom Field 01 |
| 18 | Line Item Custom Field 02 |
| 19 | Line Item Custom Field 03 |
| 20 | Line Item Custom Field 04 |
| 21 | Line Item Custom Field 05 |
| 22 | Line Item Custom Field 06 |
| 23 | Line Item Custom Field 07 |
| 24 | Line Item Custom Field 08 |
| 25 | Line Item Custom Field 09 |
| 26 | Line Item Custom Field 10 |
| 27 | Line Item Custom Field 11 |
| 28 | Line Item Custom Field 12 |
| 29 | Line Item Custom Field 13 |
| 30 | Line Item Custom Field 14 |
| 31 | Line Item Custom Field 15 |
| 32 | Line Other1 Field |
| 33 | Line Other2 Field |
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