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_ |
varchar2 |
Invoice Number | |||
organization_ |
varchar2 |
Organisation ID | |||
organization_ |
varchar2 |
Organisation Name | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
person_ |
varchar2 |
Person Full Name | |||
person_ |
varchar2 |
Person ID | |||
person_ |
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: