PurchaseOrderLinkedTransactions
Queries transactions linked to QuickBooks Purchase Orders, such as receipts or bills.
Table Specific Information
Linked transactions are transactions that have been associated with the PurchaseOrder specified by the PurchaseOrderId column.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | A unique identifier for the linked transaction, formatted as PurchaseOrderId|ItemLineId, for precise tracking of line items within a purchase order. | |
| PurchaseOrderId | String | The unique identifier of the purchase order associated with this linked transaction. | |
| VendorName | String | The name of the vendor to whom this purchase order is issued. Either VendorName or VendorId must be provided when inserting the transaction. | |
| VendorId | String |
Vendors.ID | The QuickBooks ID of the vendor to whom this purchase order is issued. Either VendorId or VendorName must be provided when inserting the transaction. |
| VendorMessage | String | A custom message or note to be included for the vendor, often used for special instructions or additional information. | |
| ReferenceNumber | String | A reference number assigned to the purchase order for tracking or identification purposes. | |
| TxnNumber | Integer | A unique transaction number assigned for additional tracking, distinct from the Quickbooks generated ID. | |
| Date | Date | The date when the purchase order was created or recorded. When used in a WHERE clause, it overrides pseudo-columns StartDate and EndDate. | |
| TransactionId | String | The QuickBooks ID of the transaction linked to this purchase order, such as a bill or payment. | |
| TransactionAmount | Decimal | The monetary value of the linked transaction, representing its total amount. | |
| TransactionDate | Date | The date on which the linked transaction occurred. | |
| TransactionReferenceNumber | String | The reference number associated with the linked transaction, often used for cross-referencing. | |
| TransactionType | String | The specific type of transaction linked to the purchase order, such as 'Bill' or 'Payment'. | |
| TransactionLinkType | String | Indicates the relationship between the purchase order and the linked transaction, such as 'Applied' or 'Referenced'. | |
| TimeModified | Datetime | The date and time when the purchase order was last modified in QuickBooks. | |
| TimeCreated | Datetime | The date and time when the purchase order was 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 name of the item price level associated with the purchase order. Note that QuickBooks does not return this value. |