LinkedTransactions
Used to manage linked transactions, allowing users to associate related transactions in Xero for better tracking and reporting.
Columns
| Name | Type | ReadOnly | Description |
| LinkedTransactionID [KEY] | String | True |
The unique Xero identifier for a linked transaction. This field ties together the source and target transactions, enabling users to track related transactions within the system. |
| SourceTransactionID | String | False |
The identifier of the source transaction, such as the purchase component of a billable expense. Currently, only invoices with the type 'ACCPAY' (Accounts Payable) can be used as source transactions. |
| SourceLineItemID | String | False |
The unique line item identifier from the source transaction. This specifies which line item from the source transaction is linked to the current transaction, providing detailed traceability for the expense. |
| ContactID | String | False |
The identifier for the contact associated with the target transaction. In this context, it represents the customer to whom the expense is being billed, linking the expense to a specific customer or client. |
| TargetTransactionID | String | False |
The unique identifier of the target transaction, which is the sales component of a billable expense. Currently, only invoices with the type 'ACCREC' (Accounts Receivable) can be used as target transactions. |
| TargetLineItemID | String | False |
The line item identifier from the target transaction. This is used when allocating a billable expense to a target transaction. It is optional and can be omitted if not needed for the transaction allocation. |
| Status | String | False |
The current status of the linked transaction. This is derived from the statuses of both the source and target transactions and reflects the overall status of the linked transaction. The status cannot be manually set or updated. |
| Type | String | False |
The type of the linked transaction. This field is set to 'BILLABLEEXPENSE', representing a billable expense type. Additional types may be introduced in future updates to accommodate different transaction categories. |
| UpdatedDateUTC | Datetime | True |
The timestamp indicating the last modification of the linked transaction in UTC format. This helps track when changes were made to the linked transaction and ensures up-to-date information is available. |
| TenantId | String | False |
The unique identifier of the tenant. This ensures that the query retrieves data specific to a particular tenant, especially in multi-tenant environments where data must be isolated between different organizations. |