SalesOrderLinkedTransactions
Query QuickBooks Sales Order Linked Transactions.
Table Specific Information
Linked transactions are transactions that have been associated with the SalesOrder specified by the SalesOrderId column.
QuickBooks Online
The QuickBooks Online API does not support SalesOrders.
Columns
| Name | Type | Description |
| ID [KEY] | String | The unique identifier in the format SalesOrderId|ItemLineId. |
| SalesOrderId | String | The item identifier. |
| ReferenceNumber | String | Transaction reference number. This may be set to refnumber*, *refnumber, and *refnumber* in the WHERE clause of a SELECT statement to search by StartsWith, EndsWith, and Contains. Refnum1:refnum2, refnum1:, and :refnum1 may also be used to denote a range. |
| TxnNumber | String | The transaction number. An identifying number for the transaction, but different from the QuickBooks generated ID. |
| CustomerName | String | Customer name this transaction is recorded under. This is required to have a value when inserting. |
| CustomerId | String | Customer id this transaction is recorded under. |
| Date | Date | Transaction date. |
| TransactionId# | String | The ID of the linked transaction. |
| TransactionAmount# | Double | The amount of the linked transaction. |
| TransactionDate# | Date | The date of the linked transaction. |
| TransactionReferenceNumber# | String | The reference number of the linked transaction. |
| TransactionType# | String | The type of linked transaction. |
| TransactionLinkType# | String | The link type between the Sales Order and linked transaction. |
| TimeModified | Datetime | When the SalesOrder was last modified. |
| TimeCreated | Datetime | When the SalesOrder was created. |
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 |
| StartTxnDate | String | Earliest transaction date to search for. |
| EndTxnDate | String | Latest transaction date to search for. |
| StartModifiedDate | String | Earliest modified date to search for. |
| EndModifiedDate | String | Latest modified date to search for. |
| ItemPriceLevel# | String | Item pricelevel name. QuickBooks will not return the PriceLevel. |