ProjectPurchases2: 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 ProjectPurchases2 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 |
|---|---|---|---|---|---|
has_ |
char |
itgen_spe_has_register_mileage_enabled | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
invoice_ |
varchar2 |
Invoice Number | |||
name |
varchar2 |
Name | |||
organization_ |
varchar2 |
Organisation ID | |||
organization_ |
varchar2 |
itgen_spe_organization_id_2 | |||
organization_ |
varchar2 |
Organisation Name | |||
organization_ |
varchar2 |
itgen_spe_organization_name_2 | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number | |||
organization_ |
varchar2 |
itgen_spe_organization_relation_number_2 | |||
person_ |
varchar2 |
Person Full Name | |||
person_ |
varchar2 |
itgen_spe_person_full_name_2 | |||
person_ |
varchar2 |
Person ID | |||
person_ |
varchar2 |
itgen_spe_person_id_2 | |||
person_ |
varchar2 |
itgen_spe_person_relation_number | |||
person_ |
varchar2 |
itgen_spe_person_relation_number_2 | |||
project_ |
double |
itgen_spe_project_manager_amount | |||
project_ |
varchar2 |
itgen_spe_project_manager_declarable | |||
project_ |
varchar2 |
itgen_spe_project_manager_employee_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_id | |||
project_ |
varchar2 |
itgen_spe_project_manager_name | |||
project_ |
varchar2 |
itgen_spe_project_manager_person_id | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
itgen_spe_project_manager_tariff | |||
project_ |
varchar2 |
Project Number | |||
supplier |
varchar2 |
Supplier | |||
type |
varchar2 |
Type |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: