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

# ExpenseReports: Autotask itgen_autotask_expensereports_plural

`read only` `REST`

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

Can only retrieve data.

## API Source

- Endpoint: `/V1.0/ExpenseReports/query`
- Operation: `get /V1.0/ExpenseReports/query`

## Table Columns

The columns of the table `ExpenseReports` 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 | [ ] |  |  |



## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

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