---
title: "ExpenseReportsById (Autotask)"
description: "itgen_autotask_expensereportsbyid_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.ExpenseReports.ExpenseReportsById
original: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.ExpenseReports.ExpenseReportsById
updated: 2024-06-10T18:39:25Z
license: https://documentation.invantive.eu/en/
---

# ExpenseReportsById: Autotask itgen_autotask_expensereportsbyid_plural

`read only` `REST`

- Catalog: `Autotask`
- Schema: `ExpenseReports`
- Label: itgen_autotask_expensereportsbyid_plural

Can only retrieve data.

## API Source

- Endpoint: `/V1.0/ExpenseReports/{id}`
- Operation: `get /V1.0/ExpenseReports/{id}`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `id` | `` | [x] |  |  |

## Table Columns

The columns of the table `ExpenseReportsById` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `amountDue` | `double` | Amount Due | [ ] |  |  |
| `approvedDate` | `datetime` | Approved Date | [ ] |  |  |
| `approverID` | `int32` | Approver ID | [ ] |  |  |
| `departmentNumber` | `varchar2` | Department Number | [ ] |  |  |
| `id` | `int64` | ID | [ ] |  |  |
| `internalCurrencyCashAdvanceAmount` | `double` | Internal Currency Cash Advance Amount | [ ] |  |  |
| `internalCurrencyExpenseTotal` | `double` | Internal Currency Expense Total | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `organizationalLevelAssociationID` | `int32` | Organisational Level Association ID | [ ] |  |  |
| `quickBooksReferenceNumber` | `varchar2` | Quickbooks Reference Number | [ ] |  |  |
| `reimbursementCurrencyAmountDue` | `double` | Reimbursement Currency Amount Due | [ ] |  |  |
| `reimbursementCurrencyCashAdvanceAmount` | `double` | Reimbursement Currency Cash Advance Amount | [ ] |  |  |
| `reimbursementCurrencyID` | `int32` | Reimbursement Currency ID | [ ] |  |  |
| `rejectionReason` | `varchar2` | Rejection Reason | [ ] |  |  |
| `status` | `int32` | Status | [ ] |  |  |
| `submit` | `char` | Submit | [ ] |  |  |
| `submitDate` | `datetime` | Submit Date | [ ] |  |  |
| `submitterID` | `int32` | Submitter ID | [ ] |  |  |
| `weekEnding` | `datetime` | Weekending | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Autotask](/en/release-notes/drivers?driver=autotask)

