ItemReceiptLinkedTransactions
Queries transactions linked to QuickBooks Item Receipts, such as associated bills or credits.
Table Specific Information
Linked transactions are transactions that have been associated with the ItemReceipts specified by the ItemReceiptId column.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | A unique identifier for the linked transaction, formatted as ItemReceiptId|ItemReceiptLineId. | |
| ItemReceiptId | String |
ItemReceipts.ID | The unique identifier for the item receipt, sourced from the ItemReceipts table. |
| VendorName | String | The name of the vendor associated with the item receipt. Either VendorName or VendorId must be provided when inserting a new item receipt. | |
| VendorId | String |
Vendors.ID | The unique identifier of the vendor associated with the item receipt. Either VendorName or VendorId must be provided when inserting a new item receipt. |
| Date | Date | The date when the item receipt transaction occurred or was recorded. | |
| ReferenceNumber | String | A reference number assigned to the item receipt transaction for identification purposes. | |
| AccountsPayable | String | The name of the accounts payable account associated with this item receipt. | |
| AccountsPayableId | String |
Accounts.ID | The unique identifier of the accounts payable account associated with this item receipt. |
| Memo | String | An optional memo or note describing the item receipt transaction. | |
| Amount | Decimal | The total monetary value of the item receipt. | |
| TxnNumber | Integer | A unique transaction number assigned to distinguish this transaction from others, apart from the Quickbooks generated ID. | |
| ExchangeRate | Double | The exchange rate used to convert the transaction's currency into the home currency of the QuickBooks file. Requires QBXML Version 8.0 or higher. | |
| TransactionId | String | The unique identifier of the linked transaction associated with this item receipt. | |
| TransactionAmount | Decimal | The monetary value of the linked transaction. | |
| TransactionDate | Date | The date when the linked transaction occurred or was recorded. | |
| TransactionReferenceNumber | String | A reference number assigned to the linked transaction for identification purposes. | |
| TransactionType | String | The type of linked transaction (for example, purchase order or bill). | |
| TransactionLinkType | String | The relationship type between the item receipt and the linked transaction, such as a link to a purchase order. | |
| CustomFields | String | Any custom fields associated with this transaction, formatted as XML. | |
| EditSequence | String | An identifier used for version control of this object in QuickBooks. | |
| TimeModified | Datetime | The date and time when the item receipt was last updated. | |
| TimeCreated | Datetime | The date and time when the item receipt was initially created. |