CreditMemoLinkedTransactions
Enables querying of transactions linked to specific QuickBooks Credit Memos, such as associated payments or adjustments.
Table Specific Information
Linked transactions are transactions that have been associated with the CreditMemo specified by the CreditMemoId column.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The unique identifier for the credit memo linked transaction, formatted as CreditMemoId|ItemLineId. | |
| CreditMemoId | String |
CreditMemos.ID | The unique identifier of the credit memo associated with the linked transaction. |
| ReferenceNumber | String | The reference number for the credit memo transaction. | |
| TxnNumber | Integer | A manually assigned transaction number to identify the credit memo separately from the Quickbooks generated ID. | |
| Date | Date | The date of the credit memo transaction. If specified in the WHERE clause of a SELECT query, it overrides the pseudo columns StartDate and EndDate. | |
| CustomerId | String |
Customers.ID | The unique identifier of the customer associated with the credit memo. |
| CustomerName | String | The name of the customer associated with the credit memo. | |
| TransactionId | String | The unique identifier of the linked transaction associated with this credit memo. | |
| TransactionAmount | Decimal | The total monetary amount of the linked transaction. | |
| TransactionDate | Date | The date when the linked transaction occurred. | |
| TransactionReferenceNumber | String | The reference number of the linked transaction for identification and tracking. | |
| TransactionType | String | The type of the linked transaction (for example, Invoice, Payment, or Bill). | |
| TransactionLinkType | String | The relationship type between the credit memo and the linked transaction (for example, AppliedTo or OffsetBy). | |
| TimeModified | Datetime | The timestamp of the last modification made to this credit memo or its linked transactions. | |
| TimeCreated | Datetime | The timestamp of when this credit memo or its linked transactions were 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 | |
| ItemPriceLevel | String | The item price level associated with the linked transaction. QuickBooks does not return the price level. |