StatementChargeLinkedTransactions
Queries transactions linked to QuickBooks Statement Charges, such as associated payments or invoices.
Table Specific Information
Linked transactions are transactions that have been associated with the StatementCharge specified by the StatementChargeId column.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The unique identifier formatted as StatementChargeId|TransactionLineId. This is used to uniquely identify a specific linked transaction. | |
| StatementChargeId | String | The identifier for the statement charge associated with this transaction. | |
| ReferenceNumber | String | The reference number associated with the statement charge transaction. This value can help track or match the transaction in QuickBooks. | |
| TxnNumber | Integer | The transaction number, which is an additional identifier for the transaction but is not the Quickbooks generated ID. | |
| CustomerName | String | The name of the customer associated with this transaction. This identifies the individual or business linked to the charge. | |
| CustomerId | String |
Customers.ID | The unique identifier for the customer associated with this transaction. This value is used for referencing customers within QuickBooks. |
| Date | Date | The date when the transaction occurred. This represents the main transaction date recorded in QuickBooks. | |
| TransactionId | String | The unique identifier of the linked transaction, used to reference related transactions within QuickBooks. | |
| TransactionAmount | Decimal | The monetary amount associated with the linked transaction. This represents the value of the transaction. | |
| TransactionDate | Date | The date when the linked transaction occurred. This provides the timeline for the linked transaction. | |
| TransactionReferenceNumber | String | The reference number of the linked transaction. This is typically used for tracking or cross-referencing purposes. | |
| TransactionType | String | The type of transaction linked to the statement charge. For example, this could include types such as Invoice, Credit Memo, or Payment. | |
| TransactionLinkType | String | The relationship between the statement charge and the linked transaction. This specifies how the transactions are connected. | |
| TimeModified | Datetime | The date and time when the statement charge was last modified. This indicates the most recent update to the record. | |
| TimeCreated | Datetime | The date and time when the statement charge was initially created in QuickBooks. |