List ExpenseClaimItems

Community

Status

Documentation

Files

Organization Structure API

Axis-sections
Departments
Legal-Units
Establishments

Core HR API

Employees Directory
Guides

Cleemy Expenses API

Timmi Absences API

Leaves
Leave-requests
Sick-leaves
Imports
Guides

Timmi Office API

User-locations
Work-locations

Timmi Project API

Clients
Projects
Project services
Organizations
Financials

Timmi Settings API

UserDates
Workcycle-exceptions
Working-time-arrangement

Timmi Timesheet API

Time-entries
Timesheets
Reports
Guides

Pagga Mealvouchers API

Statutory
Computation

Pagga Remuneration API

Fixed-natures
Fixed-items
Variable-natures
Variable-items

Poplee Training API

Training-demands
Realized-trainings

GET

api

expenseClaimItems

curl --request GET \
  --url https://example.ilucca.net/api/v3/expenseClaimItems

{
  "data": {
    "items": [
      {
        "id": 1,
        "expenseClaimId": 1,
        "lineNumber": 1,
        "isControlled": true,
        "purchasedOn": "2023-11-07T05:31:56Z",
        "createdOn": "2023-11-07T05:31:56Z",
        "modifiedOn": "2023-11-07T05:31:56Z",
        "originalTransaction": {
          "grossAmount": 123,
          "currencyId": "<string>",
          "isExpenseAbroad": true,
          "currency": {
            "id": "<string>",
            "name": "<string>",
            "url": "<string>"
          }
        },
        "processedAmounts": {
          "grossAmount": 123,
          "currencyId": "<string>",
          "currency": {
            "id": "<string>",
            "name": "<string>",
            "url": "<string>"
          },
          "netAmount": 123,
          "vatBases": [
            {
              "countryVatRateId": 2,
              "countryVatRate": {
                "id": 2,
                "name": "<string>",
                "url": "<string>"
              },
              "vatAmount": 123,
              "amountExcludingVat": 123
            }
          ]
        },
        "expenseNatureId": 1,
        "mileage": {
          "distance": 123,
          "power": 123,
          "waypoints": [
            "<any>"
          ]
        },
        "quantity": 1,
        "effectiveQuantity": 2,
        "attendees": {
          "internal": [
            {
              "id": 123,
              "name": "<string>",
              "url": "<string>",
              "displayName": "<string>",
              "modifiedOn": "<string>",
              "lastName": "<string>",
              "firstName": "<string>",
              "login": "<string>",
              "mail": "<string>",
              "dtContractStart": "<string>",
              "dtContractEnd": "<any>",
              "birthDate": "<string>",
              "employeeNumber": "<string>",
              "calendar": {
                "id": 123,
                "url": "<string>",
                "name": "<string>"
              },
              "culture": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "picture": {
                "id": "<string>",
                "url": "<string>",
                "name": "<string>"
              },
              "applicationData": {
                "profile_figgo": {
                  "id": 123,
                  "name": "<string>",
                  "url": "<string>"
                },
                "profile_utime": {
                  "id": 123,
                  "name": "<string>",
                  "url": "<string>"
                }
              },
              "legalEntity": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "department": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "manager": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "rolePrincipal": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "habilitedRoles": [
                {
                  "id": 123,
                  "name": "<string>",
                  "url": "<string>"
                }
              ],
              "userWorkCycles": [
                {
                  "Id": 123,
                  "OwnerID": 123,
                  "WorkCycleID": 123,
                  "StartsOn": "<string>",
                  "EndsOn": "<string>"
                }
              ]
            }
          ],
          "external": [
            {
              "id": 2,
              "displayName": "<string>"
            }
          ]
        },
        "axisSections": [
          {
            "id": 2,
            "code": "<string>",
            "name": "<string>",
            "multilingualName": "<string>",
            "description": "<string>",
            "ownerId": 2,
            "startOn": "2023-11-07T05:31:56Z",
            "endOn": "2023-11-07T05:31:56Z",
            "active": true,
            "axisId": 123,
            "parentAxisSections": [
              {}
            ],
            "childrenAxisSections": [
              {}
            ]
          }
        ],
        "customFields": {},
        "merchant": "<string>",
        "comment": "<string>",
        "expenseReceipts": [
          {
            "id": "<string>"
          }
        ],
        "authorizedActions": {
          "isCancellable": true,
          "isEditable": true
        },
        "sourceId": {
          "id": "<string>"
        },
        "source": {
          "id": 123,
          "name": "<string>",
          "code": "<string>"
        },
        "ownerId": 123,
        "paymentMethodId": 0
      }
    ]
  }
}

Query Parameters

ownerId

integer[]

Comma-separated list of user identifiers (int).

orderBy

string

{fieldName},{'asc'||'desc'}. Example: ?orderby=purchasedOn,desc

purchasedOn

string

Examples: between,2022-01-01,202201-31.

paging

string

required

{offset},{limit}. Defaults to 0,1000.

Example:

"100,0"

Response

200

application/json

data

object

data.items

object[]

The ExpenseClaimItem, is an expense that has been declared (within an expense report) by its owner (the user who made the expense).

data.items.purchasedOn

string

required

Day the expense was made.

data.items.expenseNatureId

integer

required

Nature of the expense: Meals, Train, Taxi, Hotels, Taxi, Mileage... List depends on the app configuration.

Required range: x >= 0

data.items.id

integer

Required range: x >= 0

data.items.expenseClaimId

integer

Id of the expense claim in which the item is contained.

Required range: x >= 0

data.items.lineNumber

integer

Incremental number used to order expense claim items in an expense claim

Required range: x >= 0

data.items.isControlled

boolean

<true> if the item has been controlled

data.items.createdOn

string

Date-time the item was created. Corresponds to the submition date of the expense claim.

data.items.modifiedOn

string

Date-time the item was last modified.

data.items.originalTransaction

object

Expense amount in original currency.

data.items.processedAmounts

object

Various amounts in the establishment's currency.

data.items.mileage

object | null

Additional information when the expense type is mileage.

data.items.quantity

integer

default:1

The quantity when the expense type is 'Quantity'.

Required range: x >= 1

data.items.effectiveQuantity

integer

Calculated quantity when the expense type is 'Quantity' or 'Invitations' (number of attendees).

Required range: x >= 1

data.items.attendees

object | null

Additional information when the expense type is 'Invitation'.

data.items.attendees.internal

object[]

Attendees who work for the company (ie: Users in the system).

data.items.attendees.external

object[]

External attendees (eg: clients, candidates).

Id of the custom field.

data.items.axisSections

object[] | null

Axis sections values.

data.items.customFields

object | null

Values for custom fields.

data.items.merchant

string | null

Merchant of the expense.

data.items.comment

string | null

data.items.expenseReceipts

object[] | null

The original receipt (PDF file, image, ...).

An expense's receipt.

data.items.authorizedActions

object

Authorized actions on the expense for the current user.

data.items.sourceId

object

The source describes how the expense was created:

0: Legacy
1: OldImport
2: ImportByCb
3: ImportByNature
4: Anytime
5: BudgetInsight
6: Api
7: Ocr
8: Reconciliation
9: InvoiceAggregator
10: EmailAttachments
11: FtpStatementImport
12: CleemyPayment

data.items.source

object

data.items.ownerId

integer

Unique identifier of the user that made this expense.

data.items.paymentMethodId

enum<number>

How this expense was made: the owner used his money, an enterprise debit card, or a Cleemy card:

0: User
1: CorporateCard
3: Cleemy Card

Available options:

0,

1,

3

Was this page helpful?

The expense-claim-item resource

Get an ExpenseClaimItem by id

curl --request GET \
  --url https://example.ilucca.net/api/v3/expenseClaimItems

{
  "data": {
    "items": [
      {
        "id": 1,
        "expenseClaimId": 1,
        "lineNumber": 1,
        "isControlled": true,
        "purchasedOn": "2023-11-07T05:31:56Z",
        "createdOn": "2023-11-07T05:31:56Z",
        "modifiedOn": "2023-11-07T05:31:56Z",
        "originalTransaction": {
          "grossAmount": 123,
          "currencyId": "<string>",
          "isExpenseAbroad": true,
          "currency": {
            "id": "<string>",
            "name": "<string>",
            "url": "<string>"
          }
        },
        "processedAmounts": {
          "grossAmount": 123,
          "currencyId": "<string>",
          "currency": {
            "id": "<string>",
            "name": "<string>",
            "url": "<string>"
          },
          "netAmount": 123,
          "vatBases": [
            {
              "countryVatRateId": 2,
              "countryVatRate": {
                "id": 2,
                "name": "<string>",
                "url": "<string>"
              },
              "vatAmount": 123,
              "amountExcludingVat": 123
            }
          ]
        },
        "expenseNatureId": 1,
        "mileage": {
          "distance": 123,
          "power": 123,
          "waypoints": [
            "<any>"
          ]
        },
        "quantity": 1,
        "effectiveQuantity": 2,
        "attendees": {
          "internal": [
            {
              "id": 123,
              "name": "<string>",
              "url": "<string>",
              "displayName": "<string>",
              "modifiedOn": "<string>",
              "lastName": "<string>",
              "firstName": "<string>",
              "login": "<string>",
              "mail": "<string>",
              "dtContractStart": "<string>",
              "dtContractEnd": "<any>",
              "birthDate": "<string>",
              "employeeNumber": "<string>",
              "calendar": {
                "id": 123,
                "url": "<string>",
                "name": "<string>"
              },
              "culture": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "picture": {
                "id": "<string>",
                "url": "<string>",
                "name": "<string>"
              },
              "applicationData": {
                "profile_figgo": {
                  "id": 123,
                  "name": "<string>",
                  "url": "<string>"
                },
                "profile_utime": {
                  "id": 123,
                  "name": "<string>",
                  "url": "<string>"
                }
              },
              "legalEntity": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "department": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "manager": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "rolePrincipal": {
                "id": 123,
                "name": "<string>",
                "url": "<string>"
              },
              "habilitedRoles": [
                {
                  "id": 123,
                  "name": "<string>",
                  "url": "<string>"
                }
              ],
              "userWorkCycles": [
                {
                  "Id": 123,
                  "OwnerID": 123,
                  "WorkCycleID": 123,
                  "StartsOn": "<string>",
                  "EndsOn": "<string>"
                }
              ]
            }
          ],
          "external": [
            {
              "id": 2,
              "displayName": "<string>"
            }
          ]
        },
        "axisSections": [
          {
            "id": 2,
            "code": "<string>",
            "name": "<string>",
            "multilingualName": "<string>",
            "description": "<string>",
            "ownerId": 2,
            "startOn": "2023-11-07T05:31:56Z",
            "endOn": "2023-11-07T05:31:56Z",
            "active": true,
            "axisId": 123,
            "parentAxisSections": [
              {}
            ],
            "childrenAxisSections": [
              {}
            ]
          }
        ],
        "customFields": {},
        "merchant": "<string>",
        "comment": "<string>",
        "expenseReceipts": [
          {
            "id": "<string>"
          }
        ],
        "authorizedActions": {
          "isCancellable": true,
          "isEditable": true
        },
        "sourceId": {
          "id": "<string>"
        },
        "source": {
          "id": 123,
          "name": "<string>",
          "code": "<string>"
        },
        "ownerId": 123,
        "paymentMethodId": 0
      }
    ]
  }
}