TrackingCategories
Enables querying tracking categories, which are used to segment financial transactions for better analysis and reporting. For example, you can track sales by region or department.
Table Specific Information
The TrackingCategories view allows you to SELECT tracking categories for a Xero organization. The Id column is generated by the cmdlet; it combines the index of the line item with the unique, Xero-generated TrackingCategoryId.
SELECT
The Xero API allows extensive filtering and ordering. You can define WHERE and ORDER BY clauses in a query to filter and order the results using any non-line-item column.
Note: The Xero API does not support filtering on line items or journal lines.
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier combining the tracking option index and the Xero-generated ID of the tracking category. |
| TrackingCategoryId | String | The unique Xero identifier for the tracking category, which defines the grouping of tracking options (for example, Department or Region). |
| Name | String | The name of the tracking category, such as Department or Region, used for organizing transactions. |
| Status | String | The status of the tracking category, which is always set to ACTIVE, indicating it's currently in use. |
| TrackingOptionId | String | The unique Xero identifier for the tracking option, representing a specific selection within the tracking category. |
| OptionName | String | The name of the tracking option, such as 'North' or 'South,' representing a specific value within the category. |
| TenantId | String | The ID of the tenant to query instead of the connection tenant, used when querying data for a different tenant. |