SalesOrderLinkedTransactions
Queries transactions linked to QuickBooks Sales Orders, such as associated invoices or shipments.
Table Specific Information
Linked transactions are transactions that have been associated with the SalesOrder specified by the SalesOrderId column.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | A unique identifier for the linked transaction in the format SalesOrderId|ItemLineId, combining the sales order ID and the line item ID for clear referencing. | |
| SalesOrderId | String |
SalesOrders.ID | The unique identifier of the sales order associated with the linked transaction. |
| ReferenceNumber | String | The reference number of the sales order, used for tracking and customer communication. | |
| TxnNumber | Integer | The unique transaction number assigned within QuickBooks, distinct from the system-generated ID, for internal reference. | |
| CustomerName | String | The name of the customer associated with this sales order and its linked transactions. | |
| CustomerId | String |
Customers.ID | The unique QuickBooks ID of the customer linked to this sales order and its transactions. |
| Date | Date | The date when the sales order was created or last updated. | |
| TransactionId | String |
Invoices.ID | The QuickBooks ID of the linked transaction, providing a connection between the sales order and the related transaction. |
| TransactionAmount | Decimal | The monetary amount of the linked transaction, such as an invoice or payment related to the sales order. | |
| TransactionDate | Date | The date of the linked transaction, such as when an invoice was issued or a payment was received. | |
| TransactionReferenceNumber | String | The reference number associated with the linked transaction, used for tracking and reconciliation. | |
| TransactionType | String | The type of the linked transaction, such as Invoice, Payment, or Credit Memo, to clarify its role in relation to the sales order. | |
| TransactionLinkType | String | The nature of the link between the sales order and the transaction, such as 'applied to' or 'referenced by.' | |
| TimeModified | Datetime | The last date and time when the sales order or its linked transactions were modified in QuickBooks. | |
| TimeCreated | Datetime | The date and time when the sales order or its linked transactions were initially created in QuickBooks. |
Pseudo-Columns
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ItemPriceLevel | String | The price level applied to the items in the linked transactions. QuickBooks does not return this value directly. |