---
title: "ProjectPurchases (Simplicate)"
description: "Project Purchases"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectPurchases
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Projects.ProjectPurchases
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# ProjectPurchases: Simplicate Project Purchases

`read only` `REST`

- Catalog: `Simplicate`
- Schema: `Projects`
- Label: Project Purchases

Fetches all project purchase records

Can only retrieve data.

## API Source

- Endpoint: `/projects/purchase`
- Operation: `get /projects/purchase`

## Table Columns

The columns of the table `ProjectPurchases` 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 |
|---|---|---|:---:|---|---|
| `id` | `varchar2` | ID | [ ] |  |  |
| `invoice_number` | `varchar2` | Invoice Number | [ ] |  |  |
| `organization_id` | `varchar2` | Organisation ID | [ ] |  |  |
| `organization_name` | `varchar2` | Organisation Name | [ ] |  |  |
| `organization_relation_number` | `varchar2` | itgen_spe_organization_relation_number | [ ] |  |  |
| `person_full_name` | `varchar2` | Person Full Name | [ ] |  |  |
| `person_id` | `varchar2` | Person ID | [ ] |  |  |
| `person_relation_number` | `varchar2` | itgen_spe_person_relation_number | [ ] |  |  |
| `supplier` | `varchar2` | Supplier | [ ] |  |  |
| `type` | `varchar2` | Type | [ ] |  |  |



## Release Notes

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

- [Simplicate](/en/release-notes/drivers?driver=simplicate)

